0) { $DbLink->query("SELECT m_time FROM ".C_MSG_TBL." WHERE m_time > '$LastCheck' AND username = 'SYS enter' AND type = 1 ORDER BY m_time DESC LIMIT 1"); if ($DbLink->num_rows() > 0) { $BeepRoom = "1"; list($LastCheck) = $DbLink->next_record(); }; $DbLink->clean_results(); } // ** Prepare the http refresh header ** $URL_Query = (isset($QUERY_STRING)) ? $QUERY_STRING : getenv("QUERY_STRING"); if (!ereg("LastCheck", $URL_Query)) { $Refresh = $URL_Query."&LastCheck=${LastCheck}&B=${B}"; } else { $Refresh = ereg_replace("LastCheck=([0-9]+)","LastCheck=".$LastCheck, $URL_Query); } // ** Compute the beeps/nobeeps reload query used when the sound icon is clicked ** $B1 = ($B > 0 ? "0" : "1"); $ChangeBeeps_Reload = ereg_replace("&B=([0-2])","&B=${B1}",$Refresh); // For translations with an explicit charset (not the 'x-user-defined' one) if (!isset($FontName)) $FontName = ""; // Text direction $textDirection = ($Charset == "windows-1256") ? "RTL" : "LTR"; ?>
":""); $tag_close = ($tag_open != "" ? "":""); return $tag_open.($lang ? htmlentities($str) : htmlspecialchars($str)).$tag_close; } // ** count rooms ** $DbLink->query("SELECT DISTINCT u.room FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1"); $NbRooms = $DbLink->num_rows(); $DbLink->clean_results(); if ($NbRooms > 0) { // ** count users ** $DbLink->query("SELECT DISTINCT u.username, u.latin1 FROM ".C_USR_TBL." u, ".C_MSG_TBL." m WHERE u.room = m.room AND m.type = 1 ORDER BY username"); $NbUsers = $DbLink->num_rows(); if($NbUsers > 3) { echo("
0)
{
if($DbLink->query("SELECT DISTINCT room FROM ".C_MSG_TBL." WHERE type = 1 ORDER BY room"))
{
if($DbLink->num_rows() > 0)
{
$Users = new DB;
while(list($Other) = $DbLink->next_record())
{
if($Users->query("SELECT username, latin1, status FROM ".C_USR_TBL." WHERE room = '".addslashes($Other)."' ORDER BY username"))
{
if($Users->num_rows() > 0)
{
echo("".htmlspecialchars($Other)." (".$Users->num_rows().")
");
while(list($Username,$Latin1,$status) = $Users->next_record())
{
echo("- ".special_char($Username,$Latin1,$status)."
");
}
}
}
$Users->clean_results();
echo("
"); } } } } else { echo("