vb.org Archive - [VB3 RC3] Most active user in the forums

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - [VB3 RC3] Most active user in the forums (https://vborg.vbsupport.ru/showthread.php?t=60391)

Kentaurus

01-17-2004 10:00 PM

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

Gio Takahashi

01-18-2004 06:16 PM

Any screen shots?

Kentaurus

01-18-2004 07:42 PM

Quote:

Originally Posted by Gio Takahashi

Any screen shots?

Sure, I just uploaded them. Check the first post.

Mike Gaidin

01-18-2004 07:50 PM

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

01-18-2004 07:52 PM

Quote:

Originally Posted by 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.

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

01-18-2004 07:56 PM

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

gmarik

01-19-2004 07:17 AM

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

Kentaurus

01-19-2004 08:22 AM

Quote:

Originally Posted by gmarik

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

01-20-2004 10:26 PM

Quote:

Originally Posted by gmarik

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 ...

[high]* Natch clicks install[/high]

eXtremeTim

01-22-2004 12:32 AM

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

Detomah

01-29-2004 08:57 PM

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

02-01-2004 08:42 PM

Quote:

Originally Posted by Detomah

This query:

Code:

$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:

Code:

$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

02-15-2004 07:55 AM

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

HTML Code:

 // <!-- 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	02-24-2004 04:06 AM

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

02-24-2004 07:44 AM

It already does that. ;)

Mike Gaidin

02-24-2004 08:29 PM

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

Boofo

02-24-2004 10:02 PM

Try using this for the post count. ;)

Quote:

$maxposter[total]

Mike Gaidin

02-25-2004 12:05 AM

Thanks Bob. Works like a charm.

MikeXP

03-21-2004 02:22 AM

Thanks Bob and the creator of the hack it worked great :)

http://GlobalBoards.com

Parmstig

03-24-2004 10:55 AM

Quote:

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

Von Halen

03-30-2004 03:24 AM

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+

04-03-2004 03:38 AM

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

higabyte

04-04-2004 11:28 PM

Code:

// 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

04-06-2004 11:02 PM

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

higabyte

04-11-2004 09:21 PM

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

Boofo

04-11-2004 09:45 PM

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

04-15-2004 09:44 PM

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

04-15-2004 11:03 PM

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

higabyte

04-17-2004 11:54 AM

GMT -5 Eastern US & Canada, Bogota, Lima

Thanks...

turbidblue

07-04-2004 04:09 AM

thank you very much :)

nice hack :)

Blam Forumz

08-17-2004 08:30 AM

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

WreckRman2

08-25-2004 01:11 AM

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

Ig@r	08-25-2004 05:08 PM

Quote:

Originally Posted by kentaurus

I think it would make more scense to dispaly users posts count for last 24 hours rather then total post count.

jilly

08-25-2004 09:04 PM

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?

All times are GMT. The time now is 02:45 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01305 seconds Memory Usage 1,785KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_html_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (34)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: