Quote:
Originally Posted by Liz
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
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
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