[VB3 RC3] Most active user in the forums

This hack adds to your forum home page the most active user
today, he is the user that has posted the most from 0:00 GMT
until the end of the day.

In your forum home page it appears something like:

The most active user in the forum is: Username!

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

[Detomah]

Would there be any way to do this so it does not include certain usergroups?

I would like to use this hack, but it's fairly obvious at the moment that I would be the most active user on my forum as admin, followed cloesly behind by my moderators. I'd like to be able to use it but only with my registered users counting towards it.

[Kentaurus]

Originally Posted by Detomah

Would there be any way to do this so it does not include certain usergroups?

I would like to use this hack, but it's fairly obvious at the moment that I would be the most active user on my forum as admin, followed cloesly behind by my moderators. I'd like to be able to use it but only with my registered users counting towards it.

This query:

$maxposter = $DB_site->query_first("SELECT user.username,user.userid,count(*) total FROM ".TABLE_PREFIX."user AS user,".TABLE_PREFIX."post AS post WHERE user.userid=post.userid AND post.dateline BETWEEN $start AND $end GROUP BY post.userid ORDER BY total DESC LIMIT 1");

change it to:

$maxposter = $DB_site->query_first("SELECT user.username,user.userid,count(*) total FROM ".TABLE_PREFIX."user AS user,".TABLE_PREFIX."post AS post WHERE user.userid=post.userid AND post.dateline BETWEEN $start AND $end AND usergroupid NOT IN (5,6) GROUP BY post.userid ORDER BY total DESC LIMIT 1");

and change for your wanted usergroups

[Boofo]

Wouldn't this change actually work better because it would follow the server time like most other things do on the forumhome.

 // <!-- MOST ACTIVE MEMBER -->
 $maxposter = $DB_site->query_first("
   SELECT user.username,user.userid,count(*) AS total
   FROM ".TABLE_PREFIX."user AS user,".TABLE_PREFIX."post AS post
   WHERE user.userid=post.userid
   AND post.dateline
   AND usergroupid NOT IN (5,7)
   And dateline >= $starttime
   GROUP BY post.userid
   ORDER BY total
   DESC LIMIT 1

And does this include thread counts AND post counts? I'm trying to set up the percentage of posts this user has made out of the ones for that day. But I keep getting a divison by zero error (which I think i may have stopped, I'm still testing).

[VAN]

How about modifying this so it shows the # of posts the most active member has made during the time period?

Something like...

Todays Most Active Member: Username with 125 Posts.

[Boofo]

It already does that.

[Mike Gaidin]

Mine doesn't do that. Mine just has the member name.

[Boofo]

Try using this for the post count.

$maxposter[total]

[Mike Gaidin]

Thanks Bob. Works like a charm.

[MikeXP]

Thanks Bob and the creator of the hack it worked great

http://GlobalBoards.com

[Parmstig]

Originally Posted by Boofo

Try using this for the post count. $maxposter[total]

Thanks, is it possible in a easy way to make it similiar to $recordusers (most ever was online)

Like "Most Active user ever was xxx with xxx in one day" ?