Display most active users

[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