MyBB Community Forums

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.