Parašė Noyz· 2010 Rugp. 4 11:08:46
#1
Ieškau top uploaderių panelės, buvau radęs čia, bet neveikė, gal galit duot veikiančią, ar šitą pataisyt?
openside("Uploader'iu TOP 15!");
$result = dbquery("SELECT user_name, user_id, count(user_id) AS downloads_count FROM ".$db_prefix."downloads
INNER JOIN ".$db_prefix."users ON download_author=user_id GROUP BY user_name ORDER BY downloads_count DESC LIMIT 15");
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'> <img src='/images/star.gif'>
<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>$data[user_name]</a></td>
<td class='small2' align='right'>".$data['downloads_count']."</td></tr>";
}
} else echo "<tr><td align='center'>Nieko nera.</td></tr>";
echo "</table>";
closeside();