[How To?] Number of posts on an hour-by-hour basis

[mickeyjuice]

G'day,

is there any way I can see the number of posts in each hour for my forum? I'm just interested in seeing the busy/down times each day.

I have searched, but no joy. Possibly wrong search terms, etc.

[pavemen]

use phpMyAdmin or similar and run this query

SELECT hour(from_unixtime(dateline)), count(pid) FROM `mybb_posts` group by hour(from_unixtime(dateline))

result is list of hours 0-23 and number of posts.

on large boards, this may be slow

[mickeyjuice]

Thanks for that, works a treat. Brilliant.

I was hoping that this could be looked at easily on the web with the other stats, but I guess you can't have everything :-)