[Banadmin]

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!

[Judas]

This will come in handy in the CYBER competition

[Grily]

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

[Krew]

I guess you are using this right now, Blue?

[Banadmin]

Yes, I am Krew.

[Banadmin]

Yes, I am Krew.

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

I liked your post fuck. c:

[Ronnie]

Thanks for this Blue

[Mafia]

Thanks blue, it will come in handy later on

[Combo]

Thanks for sharing mate, may come in handy.

[Banadmin]

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