Parašė iSound· 2009 Rugs. 20 19:09:45
#6
Pirma tai gal šita:
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,5");
opentable("Paskutiniai prisijungę nariai</span>");
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
$lastseen = time() - $data['user_lastvisit'];
if ($lastseen < 60){
$lastseen = "<font color='green'><b><center><img src='http://mp3world.lt/images/online.gif' border='0' alt=''/></a></b></font>";
} else { $lastseen = "<font color='6699ff'><b><center><img src='http://mp3world.lt/images/offline.gif' border='0' alt=''/></a></b></font>";}
echo "<td width='400' align='center' class='tbl2' style='white-space:nowrap'>".$data['user_name']."
<br>
<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'
title='".$data['user_name']."'><img height='77' width='77' border='0' src='".IMAGES."avatars/"; if($data['user_avatar']) {echo $data['user_avatar'];} else { echo "noavatar.png" ;}
echo "'><br>".$lastseen."<br></a></td>";
}} else { echo "<td align='center'>Nebuvo prisijungusių narių</td>";}
echo "</table>";
closetable();
Redagavo iSound· 2009 Rugs. 20 19:09:57