Top Posters per Forum (shown in forumdisplay)

What does this hack do?

This hack shows the top poster in each forum, in the forumdisplay template (so when viewing the forum, you can see the top poster for that forum).

The line that displays the top poster for the forum is in the template, so you can move it anywhere you want it to show up!

View screenshots for examples!

Instructions

Open forumdisplay.php and find

PHP Code:

eval('print_output("' . fetch_template('FORUMDISPLAY') . '");'); 


add above (change $topposterno to how many top posters per forum you want to show)

PHP Code:

// Top Posters Per Forum hack v1.0 by Gary W.
$topposterno = 5;

$topposter = $DB_site->query("SELECT COUNT(post.postid) AS posts,userid,username FROM " . TABLE_PREFIX . "post AS post
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON post.threadid = thread.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON forum.forumid = thread.forumid
    WHERE forum.forumid=$forumid
    GROUP BY userid ORDER BY posts DESC LIMIT 0, $topposterno");

$topposterno2 = $topposterno;

while ($top = $DB_site->fetch_array($topposter))
{
  $topposterno--;

  if ($topposterno == 0)
  {
    $and = "and ";
    $final = "!";
  }
    
    eval ('$topposters .= "' . $comma . fetch_template('topposters') . '";');
  //eval ("\$topposters .= \"" . $comma . fetch_template("topposters"). "\";");
  $comma = ",";
} 


open FORUMDISPLAY template and find

$navbar

below add

<td><span class="smallfont">This forum's top $topposterno2 posters are: $topposters</span></td>

add a template named topposters with following content

$and<b><a href="member.php?$session[sessionurl]u=$top[userid]">$top[username]</a></b> with <b>$top[posts]</b> posts$final

OPTIONAL STEPS

If you want it to work faster (on large boards especially),
then run the following query on your database:
[sql]
ALTER TABLE post ADD INDEX (username);
[/sql]

[Reeve of shinra]

How many queries does this add?

[Overlord]

Is there any way someone can mod this hack into the vb2 style of showing a forums top posters? I want this hack but it doesn't really fit the way it is, I would prefer that it would make the forums 'replies' on the forumhome a link, so when you click it a vb3 style dropdown box opens with the top however many posters.

I could possibly mod this hack myself to do what I want, but I'm fairly new to this and I'm not sure if A: It'll work o.o, or B: the loading times that it will add to the forumhome.

[VriendP]

I think you could make this code more efficient by grabbing a template once, instead of grabbing it for each user in the list...

But I'm not sure if that would reduce the amount of queries though, just seems logical.

Nice hack, I'll play with it!

[Neutral Singh]

Gary, you are wonderful !!

[hollyboy]

would it be possible to see the top posters per forum all on one page?

[vktechnology]

good hack, i just install

[zylstra]

Gary, would you port this to 3.5 please?

Thanks.