MyBB - Who posted in the last 24 hours and how many posts did they make?

Banadmin · 04-18-2013, 05:34 PM

PHP Code:
SELECT u.uid, u.username, s.total
FROM mybb_users u
INNER JOIN (
SELECT uid, count( * ) AS total
FROM `mybb_posts` 
WHERE dateline >= ( UNIX_TIMESTAMP( NOW( ) ) - ( 24 *60 *60 ) ) 
GROUP BY uid
)s ON u.uid = s.uid
ORDER BY s.total DESC 

Replace "mybb_" with your database prefix.
Credits to pavman from MyBB forums for this wonderful query! Smile

Judas · 05-05-2013, 02:38 PM

This will come in handy in the CYBER competition Wink

Grily · 05-05-2013, 02:38 PM

Thanks Blue. I might use this if I ever start a new forum. I'll keep this in mind.

Krew · 05-06-2013, 03:04 PM

I guess you are using this right now, Blue?

Banadmin · 05-27-2013, 09:48 PM

Yes, I am Krew.

Banadmin · 05-27-2013, 09:55 PM

(05-27-2013, 09:50 PM)Pal Wrote:
(05-27-2013, 09:48 PM)Blue Wrote: Yes, I am Krew.

05-06-2013, 04:04 PM
Blue pls.

I liked your post fuck. c:

Ronnie · 05-27-2013, 10:04 PM

Thanks for this Blue Smile

Mafia · 05-29-2013, 02:34 PM

Thanks blue, it will come in handy later on Biggrin

Combo · 05-30-2013, 07:59 AM

Thanks for sharing mate, may come in handy. Smile

Banadmin · 06-01-2013, 07:44 PM

No problemo. I thought this was a handy thing to know for contests etc.