MyBB Community Forums

Hi Guys,

I am running a contest on my forum...

The member who makes the most posts between Date xxx and Date xxx wins a prize.

What would be the best way of keeping a track of this on MyBB? Is there somewhere where I can find out how many posts a user has made that day etc etc?

Thanks
LTC

MyBB doesn't particularly support this, but if it's exactly one day, you can check if via the Forum Stats page.

If it's not exactly one day, you can do it via a query (unsure if this works):

SELECT u.username, count(*) as posts FROM mybb_users RIGHT JOIN mybb_posts p ON u.uid = p.uid
WHERE p.dateline > [insert start time here] and p.dateline < [insert end time here]
GROUP BY u.uid
ORDER BY posts DESC

This is interesting I am wondering myself how you would pull this off.