[VB3 RC3] Most active user in the forums

[Kentaurus]

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.

[Gio Takahashi]

Any screen shots?

[Kentaurus]

Any screen shots?
Sure, I just uploaded them. Check the first post.

[Mike Gaidin]

How is the most active determined? It shows the most active on my forums as a member that only has 108 posts. That's 900 posts shy of what I have.

[Kentaurus]

How is the most active determined? It shows the most active on my forums as a member that only has 108 posts. That's 900 posts shy of what I have.That's because that member has posted more today. For this hack the most active user in the forum is not the one that has most posts, but the one that has most posts in the current day.

[Mike Gaidin]

Oh ok. I guess I should read the first post more thoroughly. :p

[gmarik]

Nice, but rather useless. Make it something more, maybe integrate into calendar, I don't now. . .

[Kentaurus]

Nice, but rather useless. Make it something more, maybe integrate into calendar, I don't now. . .How would you integrate it into the calendar? Recording the most active user of each day and adding it to an event?

[Natch]

Nice, but rather useless. Make it something more, maybe integrate into calendar, I don't now. . .
Not a nice comment ... if you find it useless, just don't post ... or to put it another way - unless you have constructive criticism, don't open your yap ;)

I think it's gonne be great - simple and probably more accurate to promote the active members of your forum ...

* Natch clicks install

[eXtremeTim]

Nice im going to add it to my list of your hacks to install. ;)

[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]

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]

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" ?

[Von Halen]

I know this is probably a stupid question to you guys, but where do I put the $maxposter[total]? Do I change the user id, or username ones? Or just add this in somewhere? Thanks.

[+Fares+]

great hack ! any way to make the member bold with a red color ?

[higabyte]

// Hack: most active user
$start = TIMENOW - TIMENOW % 86400;
$end = $start + 86400;


what time is that? i just noticed mine reset and its only 830pm right now...

[higabyte]

ok, yea it resets at 8pm how can I make it change at midnight?? thanks!

[higabyte]

did i miss the thread where it said there was no more support for this hack?? :(

[Boofo]

Well, I can help you set it up for whatever your server time in the Admin CP is set at but if you want anything other than that, I can't help you. ;)

[higabyte]

yea i just need to set it to change at midnight vice changing at 8pm est which is what its changing at with the above code...

thanks!

[Boofo]

What is your setting in the Admin CP set at for server time?

[higabyte]

GMT -5 Eastern US & Canada, Bogota, Lima

Thanks...

[turbidblue]

thank you very much :)

nice hack :)

[Blam Forumz]

/me installs this really uber cool hack which shows a member who registered last night as my most active user :S

[WreckRman2]

Umm... did I miss something? Mine too changes at 8pm instead of midnight. How do you fix that?

[Ig@r]

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!
I think it would make more scense to dispaly users posts count for last 24 hours rather then total post count.

[jilly]

it seems to slow my index page down quite a bit when loading, and then it isn't showing it once it does load. I uninstalled and reinstalled it, in case I might have done it wrong - but still no show - any ideas on how to troubleshoot? It's not even showing up the phrase or anything...

(ps - tried to install it at www.skatemd.com/forums/index.php )

ps I am using 3.0.1 - maybe that is the issue?