top 5 posters

Hi all I'm trying to do the top 5 posters hack like on http://www.extremeforums.com. But have no idea how to do this.

Any help would be greatly apreciated.

JP

that just displays the txt. What should it be surrounded with?

I don't think you can put php into the templates.

but you can try

<?php include("top3.php3") ?>

thanks but doe snot work. any idea what to do now?

I would lovethis feature.
JP

I just posted the include command like you wanted. I assumed you knew to put the opening and closing PHP tags there.

rangersfan had it right, but forgot the semicolon I think...c'mon JP, troubleshoot!

<?php include("top5.php3"); ?>

Make sure top5.php3 is in the same directory...if it's not, you'll have to include the relative path.

Well you can open index.php and place this code after require("global.php")

// Set this to the max number top posters to display 
$num = 5; 
$sql = "SELECT userid,username FROM user ORDER BY posts DESC LIMIT $num"; 
$results = $DB_site->query($sql);
while ($result = $DB_site->fetch_array($results))
{ 
  $top5 .= "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;° 
   <A HREF=\"member.php?action=getinfo&userid=$result[userid]\">$result[username]</A></FONT><BR>"; 
}

OR

put this in a file called top5.php

<?php
// Set this to the max number top posters to display
$num = 5;
$sql = "SELECT userid,username FROM user ORDER BY posts DESC LIMIT $num";
$results = $DB_site->query($sql);
while ($result = $DB_site->fetch_array($results))
{
  $top5 .= "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
   <A HREF=\"member.php?action=getinfo&userid=$result[userid]\">$result[username]</A></FONT><BR>";
}
?>

and then put require("top5.php"); after require("global.php");

then for either way you put $top5 in your forumhome template where you want the results to show up.

[Edited by rangersfan on 09-13-2000 at 12:58 PM]

TWT nah it would work without the semi-colon if there is only one command.

sorry guys, as i'm sure you've guessed my strength is not coding.

rangersfan, the latter did not work.

is it because of the several double quotes?

Try it now, both ways work for me now.

once again thanks, but not working.

1/ I have top.php in the admin folder

[quote]
<?php
require("global.php");
// Set this to the max number top posters to display
$num = 5;
$sql = "SELECT userid,username FROM user ORDER BY posts DESC LIMIT $num";
$results = $DB_site->query($sql);
while ($result = $DB_site->fetch_array($results))
{
$top5 .= "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"member.php?action=getinfo&userid=$result[userid]\">$result[username]</A></FONT><BR>";
}
?>
[quote]

I also have edited index.php and added $top5 into forumhome template.....help......
JP

Put top5.php in the forums folder, not the admin folder. Remove the require("global.php"); from the top5.php so that it matches what I told you to do.