Parašė Lordcraft· 2008 Rugs. 7 00:09:34
#3
turiu as sita ir ji neveikia, rodo ten man narius su 0 postu.
man reikia kaip sitos panel, cia su komentarais:
openside ("Daugiausiai komentaru parašė");
$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS comment_count FROM ".$db_prefix."comments INNER JOIN
".$db_prefix."users ON comment_name=user_id GROUP BY user_name ORDER BY comment_count DESC LIMIT 0,5");
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='".THEME."images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
echo "$data[user_name]</a></td><td class='small2' align='right'>[$data[comment_count]]</td></tr>";
}
}
echo "</table>";
closeside();