openside ("?aukyklos Top 10");



$result=dbquery("SELECT user_name, user_avatar, user_location, user_icq, user_id, count(user_id) AS shout_count FROM ".$db_prefix."shoutbox INNER JOIN

".$db_prefix."users ON shout_name=user_id GROUP BY user_name ORDER BY shout_count DESC LIMIT 0,10");



echo "<table width='100%' cellpadding='0' cellspacing='1'>";

$i=0;

if(dbrows($result)!=0){

while($data=dbarray($result)){

echo "<tr><td class='small0' align='left'> <td align='left' class='tbl'><a href='".BASEDIR." profile.php?lookup=$data[user_id]' class='right'>";

echo "<img border='0' alt='".$locale['on106']."' title='".$locale['on106']."' src='".BASEDIR."images/avatars/".$data['user_avatar']."' width='20' height='20'></a> <td align='left' class='tbl'><a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='right'>";

echo "$data[user_name]</a></td><td class='small0' align='right'><td align='right' class='tbl'> $data[shout_count]</td></tr>";

}

}

echo "</table>";

closeside();

?>