Parašė .Vaidas.· 2010 Geg. 7 00:05:00
#1
Stai saukyklos kodas -
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='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
if($data['user_avatar']){
echo "<img border='0' alt='".$locale['on106']."' title='".$locale['on106']."' src='".BASEDIR."images/avatars/".$data['user_avatar']."' width='30' height='30'></a> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
}else{
echo "<img border='0' alt='".$locale['on106']."' title='".$locale['on106']."' src='http://www.vlrg.lt/images/noav.gif' width='30' height='30'></a> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
}
echo "$data[user_name]</a></td><td align='right' class='small2' color='#FFFFFF'><color=#ffffff><b>[$data[shout_count]]</b></color></td></tr>";
}
}
echo "</table>";
closeside();
?>
Gal zinok kaip pakeisti spalva,kad butu skaiciu spalva kitokia? :) Aciu is anksto.
Redagavo Karolis· 2010 Geg. 7 13:05:10