[RELEASE] Top X number of posters on non vb page

Ok ok I know these are getting lame, but I am the type of person that likes all my forum info on the main page. SO if you are too thn here is another for you.

This will list the top X posters with the highest post count.

Demo:
http://www.extremeforums.com/include/topposters.inc.php

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

require("config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
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://www.extremeforums.com/forums/member.php?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A></FONT><BR>";
}
 
?>

Edit the echo statement and the $num variable as you see fit

~Chris

[Edited by TechTalk on 08-06-2000 at 08:48 PM]

thanks again i got this to work at http://animeboards.net/forums/topposters.php3 so can you also include the number of posts made by each member

i.e.

- member (1234)
- member2 (999)

Nice Glad you got it working. I also have the numbers on my site but forgot to post the modification.

If anyone is interested:

change:

while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/member.php?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A></FONT><BR>";
}

to:

while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;&#176
<A HREF=\"http://www.extremeforums.com/forums/member.php?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A>&nbsp;(<i>$latest_array[posts]</i>)</FONT><BR>";
}

~Chris

wow.. thanks just about to post a 'To techtalk' thread

I did all the hacks you posted at http://animeboards.net/index2.php3 but am missing a Today's Active topics one ... could you share the code you used to include the active topics in there ?

what about most replied to thread as well?

is there anyway of making it display the top 10 users that have been active for the past 45 days?