openside("name");
$result = dbquery("SELECT * FROM `".DB_PREFIX."downloads` GROUP by `download_author` ORDER by COUNT(*) DESC LIMIT 5");
echo "
";
while ($data = dbarray($result)) {
$time = dbrows(dbquery("SELECT * FROM `".DB_PREFIX."downloads` WHERE `download_author`='".$data['download_author']."'"));
$data2 = dbarray(dbquery("SELECT * FROM `".DB_PREFIX."users` WHERE `user_id`='".$data['download_author']."'"));
echo "
".$data2['user_name']." |
$time |
";
}
echo "
";
closeside();