Most posts in the last ## days?

[nintendo]

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.

[flup]

You also could use the who was online hack,
an active user isn;t a poster always

[Xenon]

$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
");

[Mustang5ohhh]

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

[Xenon]

you have to put it onto the script where you want to have it..