vb.org Archive - Display most active users

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

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Display most active users (https://vborg.vbsupport.ru/showthread.php?t=266685)

Display most active users

Hi,

i am using vBulletin 4.1.4. I am looking for a solution how to reward users that are posting threads and answering to threads in my forum.
Basically I need to publicly display who posted created the most threads/answered to the most threads per week - so i can reward that user somehow.

I have tested vbExperience but its not working with vBulletin 4.1.4. The post counter is incorrect.

Create New Plugin:

Hook: forumhome_complete
Title: Most Actived Member Of The Week
Execution Order : 5

Code

Code:

$cutofftime = TIMENOW - 7*86400;

$mostactive = $db->query_first("select count(postid) as count, post.userid, user.username from ".TABLE_PREFIX."post INNER JOIN ".TABLE_PREFIX."user on user.userid = post.userid where post.dateline > $cutofftime GROUP BY post.userid ORDER BY count DESC LIMIT 1");



vB_Template::preRegister('FORUMHOME',array('mostactive' => $mostactive));

Now To Display Username of the Most Active Member

Use:

Code:

{vb:raw mostactive.username}





anywhere in the FORUMHOME TEMPLATE

Is there a way to do this to show in the Sidebar/Forum Blocks ??

Thanks it works!

It would be cool to display the username as a link which opens the context menu. exactly like clicking a username in the forum.
you have an idea how to manage this?

Quote:

Originally Posted by rammieone (Post 2219732)

Is there a way to do this to show in the Sidebar/Forum Blocks ??

Open Forum Block Manager

Create a new block -> type -> Custom Html (if you already have some block which is Custom HTML type and you want to add in that, then edit that block else create new block)

type: PHP

Content:

Code:

global $db;

$cutofftime = TIMENOW - 7*86400;

$mostactive = $db->query_first("select count(postid) as count, post.userid, user.username from ".TABLE_PREFIX."post INNER JOIN ".TABLE_PREFIX."user on user.userid = post.userid where post.dateline > $cutofftime GROUP BY post.userid ORDER BY count DESC LIMIT 1");



$templater = vB_Template::create('mostactivemember');

$templater->register('mostactive',$mostactive);

$mostactives = $templater->render();

return $mostactives;

Now You need to create a template

Title: mostactivemember

Code:

1. You can Use {vb:raw mostactive.username} to display the username

2. You can Use  {vb:raw mostactive.count} to display the post count in a week

Quote:

Originally Posted by ravel123 (Post 2219741)

Thanks it works!

It would be cool to display the username as a link which opens the context menu. exactly like clicking a username in the forum.
you have an idea how to manage this?

Replace The Plugin Content With This

Code:

$cutofftime = TIMENOW - 7*86400;

$mostactive = $db->query_first("select count(postid) as count, post.userid, user.username from ".TABLE_PREFIX."post INNER JOIN ".TABLE_PREFIX."user on user.userid = post.userid where post.dateline > $cutofftime GROUP BY post.userid ORDER BY count DESC LIMIT 1");

$memberaction_dropdown = construct_memberaction_dropdown(fetch_userinfo($mostactive[userid]));





vB_Template::preRegister('FORUMHOME',array('mostactive' => $mostactive));

vB_Template::preRegister('FORUMHOME',array('memberaction_dropdown' => $memberaction_dropdown));

and use

Code:

{vb:raw memberaction_dropdown}

where you want in FORUMHOME TEMPLATE

Thank you very much. It works great :)

Thanks Sherif Worked a treat!

I have another question related to this topic.

If no threads have been created this week. I dont want to show the message.

So i tried the following condition with no success:

Code:

<vb:if condition="{vb:raw mostactive.count} > 0">

my message

</vb:if>

Quote:

Originally Posted by ravel123 (Post 2219951)

I have another question related to this topic.

If no threads have been created this week. I dont want to show the message.

So i tried the following condition with no success:

Code:

<vb:if condition="{vb:raw mostactive.count} > 0">

my message

</vb:if>

script counts post not the thread..

u can use this condition

<vb:if condition="$mostactive[count] > 0">
my message
</vb:if>

there isn't a plugin for this anywhere ?

I think it's also a good idea to reward back users and moderators..to keep them active on the forum.

I guess the Moderator part, I can pick from the Admin CP and seeing how much moderating they've done for the month...

would be nice if there was a plugin to put everything together though.

I'd make an announcement once a month in our announcement section...showing the most active users and moderators.

--------------- Added [DATE]1312495499[/DATE] at [TIME]1312495499[/TIME] ---------------

anybody ?

tryin to get a quick reply...otherwise i'll just make the changes specified in this thread.

I tried to add this but got an error.
Any help why this is happening?
Thanks

Database error in vBulletin 4.1.5:

Invalid SQL:
select count(postid) as count, post.userid, user.username from V4post INNER JOIN V4user on user.userid = post.userid where post.dateline > 1311952983 GROUP BY post.userid ORDER BY count DESC LIMIT 1;

MySQL Error : Unknown column 'post.userid' in 'field list'
Error Number : 1054
Request Date : Friday, August 5th 2011 @ 11:23:03 AM
Error Date : Friday, August 5th 2011 @ 11:23:04 AM
Script : http://xxx.com/V4/forum.php
Referrer : http://xxx.com/V4/forum.php
IP Address :
Username :
Classname :
MySQL Version : 5.0.91-log

Quote:

Originally Posted by Badshah93 (Post 2219722)

Create New Plugin:

Hook: forumhome_complete
Title: Most Actived Member Of The Week
Execution Order : 5

Code

Code:

$cutofftime = TIMENOW - 7*86400;

$mostactive = $db->query_first("select count(postid) as count, post.userid, user.username from ".TABLE_PREFIX."post INNER JOIN ".TABLE_PREFIX."user on user.userid = post.userid where post.dateline > $cutofftime GROUP BY post.userid ORDER BY count DESC LIMIT 1");



vB_Template::preRegister('FORUMHOME',array('mostactive' => $mostactive));

Now To Display Username of the Most Active Member

Use:

Code:

{vb:raw mostactive.username}





anywhere in the FORUMHOME TEMPLATE

I know this is old, but maybe someone can help. This works great - I have vb 4.2.5.

I was wondering what I would need to add to the code to exclude my user id, so I'm not showing up as the most active member of my site.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (12)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01815 seconds Memory Usage 1,749KB 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 (10)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (12)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: