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]

[lifesourcerec]

Thanks! Now, is there a way to put it in a table (something simple like the "attached thumbnails" box). would make them look more organized.

[Gary King]

I'm not one for cosmetics; so if someone wants to give some HTML code on where it should go, then be my guest, and please share it as well I just provide the functionality

[lifesourcerec]

Installed it without problems

[MindTrix]

Nice one Gary Thanks for releasing

[lifesourcerec]

Removed this hack as it does a number on server load.

[HakkieDEV]

Originally Posted by lifesourcerec

Removed this hack as it does a number on server load.

I agree, also installed this hack, but even with the database fix it created too much server load.

[Photon]

I installed it but I removed it because it doesn't look nice for my style..

[dubumb]

wow thanks... This is such a great hack... Thank you so much!!!!

[SmartGnome]

Thanks for the hack, install clicked........ and now is the time to play with some cosmetics here :laugh: