top 10 download submitter block

Nuke Soldier Joined: Jun 15, 2003 Posts: 31

hi,

i want to create something similar to the top 10 article submitter but for downloads. I'm not sure how I would edit the code to do this. plz help,

[php:1:067b8914ee]$sql = "SELECT username, counter FROM ".$user_prefix."_users WHERE counter > '0' ORDER BY counter DESC LIMIT 0,$top";
$result = $db->sql_query($sql);
if ($db->sql_numrows($result) > 0) {
echo "<table border=\"0\" cellpadding=\"10\" width=\"100%\"><tr><td align=\"left\">\n"
."$top "._NEWSSUBMITTERS." \n";
$lugar=1;
while ($row = $db->sql_fetchrow($result)) {
$uname = $row[username];
$counter = $row[counter];
if($counter>0) {
echo "<big>&</big>&$lugar: <a href=\"userinfo-.html$uname\">$uname</a> - ($counter "._NEWSSENT.") \n";
$lugar++;
}
}
echo "</td></tr></table> \n";
}[/php:1:067b8914ee]