Code: Select all
SELECT DATE(FROM_UNIXTIME(FLOOR(post_time/2629744)*2629744)) as Date , COUNT(FLOOR(post_time/2629744)) as post_count , COUNT(DISTINCT(poster_id)) as poster_count FROM my_forum_db.phpbb_posts GROUP BY Date ORDER BY Date;
This gives the number of posts and number of posters for every month since the forum database was started.
The periods are not exactly calendar months, but are exactly 1/12 of a year.
Here is a reasonably successful forum Here is one where all the users migrated to facebook