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("".$NbUsers." ".($NbUsers > 1 ? L_USERS : L_USER)."/".$NbRooms." ".($NbRooms > 1 ? L_ROOMS : L_ROOM)."");
}
else
{
echo("");
$Term = "";
while(list($Username,$Latin1) = $DbLink->next_record())
{
echo($Term.special_char($Username,$Latin1,''));
$Term = ", ";
}
echo("");
};
$DbLink->clean_results();
}
else
{
echo("".L_NO_USER."\n");
};
?>
" TYPE="text/css">
" TARGET="_blank">
sound.gif" WIDTH=13 HEIGHT=13 ALIGN="MIDDLE" BORDER=0 ALT="">
0)
{
if($DbLink->query("SELECT DISTINCT room FROM ".C_MSG_TBL." WHERE type = 1 ORDER BY room"))
{
if($DbLink->num_rows() > 0)
{
$i = 0;
$ChildNb = Array();
$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)
{
$i++;
$id = "room".$i;
echo("
");
echo("
");
echo("![\"".L_EXPCOL."\"](\"images/closed.gif\")
");
echo("
".htmlspecialchars($Other)." (".$Users->num_rows().")");
echo("
");
$j = 0;
while(list($Username,$Latin1,$status) = $Users->next_record())
{
$j++;
echo("- ".special_char($Username,$Latin1,$status)."
");
};
echo("
");
$ChildNb[$id] = $j;
}
}
$Users->clean_results();
}
}
}
$DbLink->clean_results();
}
else
{
echo("".L_NO_USER."");
}
$DbLink->close();
?>