Parašė bruzgis· 2009 Lap. 3 16:11:29
#6
tuoj parasysiu
$i=0;
$SQL = "SELECT ((SELECT COUNT(download_url) FROM ".DB_PREFIX."downloads WHERE download_license = u.user_id) + (SELECT COUNT(error_summary) FROM ".DB_PREFIX."error_reports WHERE error_user = u.user_id) + (SELECT COUNT(article_subject) FROM ".DB_PREFIX."articles WHERE article_name = u.user_id)) AS kiekis, user_id, user_name FROM ".DB_PREFIX."users u ORDER BY kiekis DESC";
opentable('Portalo aktyviausi nariai');
while($data=dbarray(dbquery($SQL))) {
$i++;
echo "<b>$i</b>. <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='Vartotojo ".$data['user_name']." profilis'>".$data['user_name']." (".$data['kiekis'].")</a><br>";
}
if($i=0) echo "<center>Portale aktyvių narių nėra.</center>";
closetable();
Bandyk.
Redagavo bruzgis· 2009 Lap. 3 16:11:59