view_active.php

个人主页音乐程序 个人主页音乐程序 个人主页音乐程序 个人主页音乐程序 个人主页音乐程序

<?
/**
 * view_active.php ! Show active users online
 * Musicbox Version 2.1
 * TeaM SCRiPTMAFiA 2005
 */
 
if(!defined('TBL_ACTIVE_USERS')) {
  die("Error processing page");
}

$q = "SELECT username FROM ".TBL_ACTIVE_USERS
    ." ORDER BY timestamp DESC,username";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
   echo "Error displaying info";
}
else if($num_rows > 0){
   /* Display active users, with link to their info */
   echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
   echo "<tr><td><font size=\"2\">\n";
   for($i=0; $i<$num_rows; $i++){
      $uname = mysql_result($result,$i,"username");
	  $query = "SELECT avatar FROM ".TBL_USERS ." WHERE username = '$uname' LIMIT 1";
	  $result_2 = $database->query($query);
      $avatar = mysql_result($result_2,0,"avatar");

      echo "<a href=\"userinfo.php?user=$uname\"><img src=\"".AVATARS_URL.$avatar."\" width=\"30\" height=\"30\" align=\"middle\"></a> <a href=\"userinfo.php?user=$uname\">$uname</a> / ";
   }
   echo "</font></td></tr></table><br>\n";
}
?>