Gary King
06-06-2004, 10:00 PM
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 findeval('print_output("' . fetch_template('FORUMDISPLAY') . '");');add above (change $topposterno to how many top posters per forum you want to show)// 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 $navbarbelow 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">$top[username]</a></b> with <b>$top[posts]</b> posts$final
[u]OPTIONAL STEPS
If you want it to work faster (on large boards especially),
then run the following query on your database:
ALTER TABLE post ADD INDEX (username);
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 findeval('print_output("' . fetch_template('FORUMDISPLAY') . '");');add above (change $topposterno to how many top posters per forum you want to show)// 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 $navbarbelow 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">$top[username]</a></b> with <b>$top[posts]</b> posts$final
[u]OPTIONAL STEPS
If you want it to work faster (on large boards especially),
then run the following query on your database:
ALTER TABLE post ADD INDEX (username);