" TYPE="text/css">
":"");
$tag_close = ($tag_open != "" ? "":"");
return $tag_open.($lang ? htmlentities($str) : htmlspecialchars($str)).$tag_close;
}
// Used inside javascript links
function special_char2($str,$lang)
{
return ($lang ? htmlentities(addslashes($str)) : htmlspecialchars(addslashes($str)));
}
$DbLink = new DB;
//** Build users list for the current room **
if (C_DB_TYPE == 'mysql')
{
$currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . $R . '\' '
. 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
{
$currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
. 'WHERE usr.room = \'' . $R . '\' AND usr.username = reg.username '
. 'UNION '
. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . $R . '\' '
. 'ORDER BY username';
}
else
{
$currentRoomQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . $R . '\' '
. 'ORDER BY username';
}
$DbLink->query($currentRoomQuery);
echo("".htmlspecialchars(stripslashes($R))." (".$DbLink->num_rows().")
\n");
echo("
\n");
while(list($User, $Latin1, $status, $gender) = $DbLink->next_record())
{
// Put an icon when there is a profile for the user
if($gender == 0)
$gender = 'undefined';
elseif($gender == 1)
$gender = 'boy';
elseif($gender == 2)
$gender = 'girl';
else
$gender = 'none';
if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
{
$Cmd2Send = ($User == stripslashes($U) ? "'PROFILE',''" : "'WHOIS','".special_char2($User,$Latin1)."'");
echo('
');
}
else
{
echo('
');
}
if($User != stripslashes($U))
{
echo("
".special_char($User,$Latin1,$status)."\n");
}
else
{
echo(special_char($User,$Latin1,$status)."
\n");
}
}
echo("
\n");
$DbLink->clean_results();
//** Build users list for other rooms **
$AddPwd2Link = (isset($PWD_Hash) && $PWD_Hash != "") ? "&PWD_Hash=$PWD_Hash" : "";
$DbLink->query("SELECT DISTINCT room FROM ".C_MSG_TBL." WHERE room != '$R' AND type = 1 ORDER BY room");
if($DbLink->num_rows() > 0)
{
$i = 0;
$ChildNb = Array();
$OthersUsers = new DB;
while(list($Other) = $DbLink->next_record())
{
if (C_DB_TYPE == 'mysql')
{
$otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr LEFT JOIN ' . C_REG_TBL . ' reg ON usr.username = reg.username '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
. 'ORDER BY username';
}
else if (C_DB_TYPE == 'pgsql')
{
$otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, reg.gender '
. 'FROM ' . C_USR_TBL . ' usr, ' . C_REG_TBL . ' reg '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' AND usr.username = reg.username '
. 'UNION '
. 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.username NOT IN (SELECT reg.username FROM ' . C_REG_TBL . ' reg) AND usr.room = \'' . addslashes($Other) . '\' '
. 'ORDER BY username';
}
else
{
$otherRoomsQuery = 'SELECT usr.username, usr.latin1, usr.status, NULL AS gender '
. 'FROM ' . C_USR_TBL . ' usr '
. 'WHERE usr.room = \'' . addslashes($Other) . '\' '
. 'ORDER BY username';
}
$OthersUsers->query($otherRoomsQuery);
if($OthersUsers->num_rows() > 0)
{
$i++;
$id = md5($Other);
if ($i == 1) $FirstOtherRoom = "Parent".$id;
echo("\n");
echo("\n");
$j = 0;
while(list($OtherUser, $Latin1, $status, $gender) = $OthersUsers->next_record())
{
$j++;
// Put an icon when there is a profile for the user
if($gender == 0)
$gender = 'undefined';
elseif($gender == 1)
$gender = 'boy';
elseif($gender == 2)
$gender = 'girl';
else
$gender = 'none';
if ($status != "u" && $status != "k" && $status != "d" && $status != "b")
{
echo('
');
}
else
{
echo('
');
}
echo("
".special_char($OtherUser,$Latin1,$status)."\n");
}
echo("
\n");
$ChildNb[$id] = $j;
}
$OthersUsers->clean_results();
}
}
$DbLink->clean_results();
$DbLink->close();
// Display all rest default rooms
for($k = 0; $k < count($DefaultChatRooms); $k++)
{
$tmpRoom = stripslashes($DefaultChatRooms[$k]);
$id = md5($tmpRoom);
// Display this room name when it hadn't been displayed yet
if (strcasecmp($tmpRoom, stripslashes($R)) != 0 && (!isset($ChildNb) || !isset($ChildNb[$id])))
{
if (!isset($FirstOtherRoom))
$FirstOtherRoom = "Parent".$id;
echo("\n");
};
}
?>