" 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");
$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("
![\"".L_EXPCOL."\"](\"images/closed.gif\"){kind=small}
");
echo(" ".htmlspecialchars($Other)." (".$OthersUsers->num_rows().")");
echo("