View Single Post
Old 09-07-2017, 12:49 PM   #23
crakarjax
Registered User
 
crakarjax's Avatar
 
Join Date: Dec 2009
Location: Kirkland, WA
Posts: 1,302
Re: Photobucket, and the Loss of Knowledge

Quote:
Originally Posted by Liz View Post
Thank you again for your input. I will let Josh explain it to you.
Let's be real Liz, Josh isn't going to explain anything to me because why should/would he? I'm not asking for an explanation, I'm telling it how it is.

Quote:
Originally Posted by special-K View Post
No knowledge has been lost, just the pictures for reference.
Well that's pretty BS because a picture speaks a thousand words and I think most would agree that many posts are pretty worthless now without the pics to go with them. Not everyone can or wants to read a wall of text to understand something.

Quote:
Originally Posted by special-K View Post
Do you have some knowledge of member and post decline the rest of us don't? ... Someone called the administrators here cheap, yet the site with all it's vast resources is still free. But you already knew that
Have you seen the ads here? Just because you don't pay money doesn't mean it's free.

I agree that this site does contain a lot of good knowledge, but facebook groups are doing to forums what forums did to libraries.

Want to see if post/thread count is waning? Liz, ask Josh to run this query and let's find out It will report your thread counts and post counts grouped by month since the forum was created.
Code:
SELECT p.period, p.posts, t.threads
FROM
    (SELECT 
        FROM_UNIXTIME(dateline, '%Y %M') AS period, 
        FROM_UNIXTIME(dateline, '%Y%m') AS order_by,
        COUNT(*) AS posts
    FROM post
    GROUP BY period) AS p
LEFT JOIN
    (SELECT FROM_UNIXTIME(dateline, '%Y %M') AS period, COUNT(*) AS threads
    FROM thread
    GROUP BY period) AS t
    ON p.period = t.period
ORDER BY p.order_by
__________________
1968 LWB C20 / AC / Wood Bed

Last edited by crakarjax; 09-07-2017 at 12:57 PM.
crakarjax is offline   Reply With Quote