Top Poster

silv3rbullet

New Member
Sorry if this is the wrong section.
Could anyone help me get a Top Posters thing like this? (In other words, make the mod display the top 10 top posters.)

awesome.jpg
 
Ok, in the XML, i tried changing the LIMIT 1 in

<title>Today's Top Poster</title>
<hookname>forumhome_start</hookname>
<phpcode><![CDATA[if ($vbulletin->options['todays_top_poster']){

$simdi = TIMENOW;
$dateline = $simdi - (86400 * 1);
$top_posters = $vbulletin->db->query_read_slave("
SELECT COUNT(post.dateline) AS postcount, post.userid, user.username, usergroupid,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "post AS post
JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE dateline > $dateline
GROUP BY userid
ORDER BY postcount DESC
LIMIT 1");

to 10, but that makes it go like

Today's Top Poster: Bob Today's Top Poster: Joe etc.
Help please?
 
Back
Top