Display most active users

[ravel123]

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.

[Badshah93]

Create New Plugin:

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

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:

{vb:raw mostactive.username}


anywhere in the FORUMHOME TEMPLATE

[ProFifaLeagues]

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

[ravel123]

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?

[Badshah93]

Originally Posted by rammieone

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:

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

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

Originally Posted by ravel123

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

$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

{vb:raw memberaction_dropdown}

where you want in FORUMHOME TEMPLATE

[ravel123]

Thank you very much. It works great

[ProFifaLeagues]

Thanks Sherif Worked a treat!

[ravel123]

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:

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

[Badshah93]

Originally Posted by ravel123

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:

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

[mikeinjersey]

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.