openside("TOP-5 Uploaderiai");
$result = dbquery("SELECT d.download_user, u.user_id, u.user_name FROM ".$db_prefix."downloads d
LEFT JOIN ".DB_USERS." u ON d.download_user=u.user_id
GROUP BY download_user ORDER BY COUNT(d.download_id) DESC LIMIT 5");
if (dbrows($result) != 0) {
echo "\n";
while($data = dbarray($result)) {
$num = dbcount("(download_user)", $db_prefix."downloads", "download_user='".$data['download_user']."' LIMIT 5");
echo "![image](".THEME."images/bullet.gif) ".$data['user_name']." |
".$num." failž |
\n";
}
echo "
\n";
} else { echo "Nëra\n"; }
closeside();
?>