[g-force2k2]

jitzs... add this coding to the php file that you want to have the top ten list shown in:

PHP Code:

$richest = $DB_site->query("
  SELECT username, userid, posts, joindate, gold
  FROM user 
  WHERE userid != 0
  ORDER BY gold DESC LIMIT 10");
while($rich = $DB_site->fetch_array($richest)) {
  $member = "<a href='member.php?s=$session[sessionhash]&action=getinfo&userid=$rich[userid]'>$rich[username]</a>";
  $joindate = vbdate($dateformat,$rich[joindate]);
   $richtop10.="<tr><td width='40%'><smallfont>$member</smallfont></td><td width='20%'><smallfont>$joindate</smallfont></td><td width='20%'><smallfont>$rich[gold]</smallfont></td><td width='20%'><smallfont>$rich[posts]</smallfont></td></tr>";
  }
  eval("\$top10rich = \"".gettemplate('richest_members')."\";"); 


Create a new template called:

richest_members

and in the template place:

<table cellpadding='4' cellspacing='1' border=0>
$richtop10
</table>

And from there you can customize how ever you want... regards...

g-force2k2