+- Sinisterly (https://sinister.ly)
+-- Forum: Design (https://sinister.ly/Forum-Design)
+--- Forum: Web Design (https://sinister.ly/Forum-Web-Design)
+--- Thread: MyBB - Who posted in the last 24 hours and how many posts did they make? (/Thread-MyBB-Who-posted-in-the-last-24-hours-and-how-many-posts-did-they-make)
Pages:
1
2
MyBB - Who posted in the last 24 hours and how many posts did they make? - Banadmin - 04-18-2013
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!
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Judas - 05-05-2013
This will come in handy in the CYBER competition
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Grily - 05-05-2013
Thanks Blue. I might use this if I ever start a new forum. I'll keep this in mind.
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Krew - 05-06-2013
I guess you are using this right now, Blue?
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Banadmin - 05-27-2013
Yes, I am Krew.
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Banadmin - 05-27-2013
(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:
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Ronnie - 05-27-2013
Thanks for this Blue
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Mafia - 05-29-2013
Thanks blue, it will come in handy later on
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Combo - 05-30-2013
Thanks for sharing mate, may come in handy.
RE: MyBB - Who posted in the last 24 hours and how many posts did they make? - Banadmin - 06-01-2013
No problemo. I thought this was a handy thing to know for contests etc.