Jake Bunce
Well-known member
These all generate results like this:
By Day:
For registrations per day:
For posts per day:
For threads per day:
By Day:
For registrations per day:
Code:
SELECT COUNT(*) AS registrations, FROM_UNIXTIME(register_date, '%Y-%m-%d') AS date
FROM xf_user
GROUP BY date
ORDER BY date
For posts per day:
Code:
SELECT COUNT(*) AS posts, FROM_UNIXTIME(post_date, '%Y-%m-%d') AS date
FROM xf_post
GROUP BY date
ORDER BY date
For threads per day:
Code:
SELECT COUNT(*) AS threads, FROM_UNIXTIME(post_date, '%Y-%m-%d') AS date
FROM xf_thread
GROUP BY date
ORDER BY date