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

it's all in this thread

http://www.vbulletin.com/forum/showt...?threadid=2658

thanks but...
Once I have the text below to I just include it in the template in the vb control panel?
cheers
JP

<?php
// Set this to the max number top posters to display
$num = 20;

require("admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query = "SELECT * FROM user ORDER BY posts DESC LIMIT $num";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://animeboards.net/forums/member.php?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A></FONT><BR>";
}

save it in a file like top5.php3

and then use an include command into your non vb page

right like this:

1/ save file as top5.php3 in admin folder.
2/ create include (how?) in forumhome template.
3/ end

Is this right?

errhh... the you want the top 5 posters where on your site ?

what i did was only put it on my front index page which is a non vb page.. then i used a php include on my front index.php3 page at http://animeboards.net i saved top5.php3 into my root directory

<?php 
include("/home/usr1/www.animeboards.net/htdocs/top5.php3"); 
?>

oh I want to include it on my forum category page --> forumhome template.

http://216.10.4.112/forums/index.php

Is this easier?
JP

well i don't know anything about php really just code that others here have given me... so that's where my knowledge ends... i haven't tried php code in the forumhome template before ... you can try it though...

OK, I'll try - how do I include the file?
JP

PS Thanks for all your help!

include("top3.php3");