![]() |
Most posts in the last ## days?
Is there a hack that's just like the Top ## posters list, but only counts the last ## days of posts, 30 days for example? That would be an easy way to see who's currently the most active members.
|
You also could use the who was online hack,
an active user isn;t a poster always |
$DB_site->query("SELECT DISTINCT(userid),COUNT(postid) AS posts
FROM post WHERE userid > 0 AND post.dateline>=".(time()-24*3600*30)." GROUP BY userid ORDER BY posts DESC "); |
Just out of curiousity ... where do you put this ???
I need something like this ... I have give aways every week for the top 5 posters and I'd like something to do this easier. Thanks |
you have to put it onto the script where you want to have it..
|
All times are GMT. The time now is 09:21 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|