MyBB Community Forums

Full Version: Checking how many posts?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all

I run daily competitions where my members make a certain amount of posts on the forum to enter.

So.. Is there a way to see how many posts members have made in a day?

I need something or a mod that shows a list of members that have made posts today.

Hope someone can help

thanks
Steve
You can do this in phpMyAdmin:
SELECT username, COUNT(pid) as c FROM mybb_posts WHERE FROM_UNIXTIME(dateline) BETWEEN '2011-06-16 00:00:00' AND '2011-06-16 23:59:59' GROUP BY uid ORDER BY c DESC

This would give you how many posts every user has made today.
Hi

Is there one for thread count as well? Would be good if there is.

thanks
Steve
Can't you just check through their profile?
Try this one:
SELECT username, COUNT(tid) as c FROM mybb_threads WHERE FROM_UNIXTIME(dateline) BETWEEN '2011-06-16 00:00:00' AND '2011-06-16 23:59:59' GROUP BY uid ORDER BY c DESC
error im recieving is: #1054 - Unknown column 'pid' in 'field list'

am i right in thinking i need to change pid to tid?

thanks
Steve
Oh, I'm sorry, yes. It has to be tid instead of pid.