Display most active users

[qpurser]

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

[mchll9898]

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

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.