query("SELECT room,status FROM ".C_USR_TBL." WHERE username = '$U' LIMIT 1");
if($DbLink->num_rows() != 0)
{
// There is a row for the user in the users table
list($room,$status) = $DbLink->next_record();
$DbLink->clean_results();
$kicked = 0;
if ($room != stripslashes($R)) // Same nick in another room
{
$DbLink->query("INSERT INTO ".C_MSG_TBL." VALUES ($T, '$R', 'SYS exit', '', ".time().", '', 'sprintf(L_EXIT_ROM, \"".special_char($U,$Latin1,1)."\")')");
$kicked = 3;
}
elseif ($status == "k") // Kicked by a moderator or the admin.
{
$DbLink->query("INSERT INTO ".C_MSG_TBL." VALUES ($T, '$R', 'SYS exit', '', ".time().", '', 'sprintf(L_KICKED, \"".special_char($U,$Latin1,1)."\")')");
$kicked = 1;
}
elseif ($status == "d") // The admin just deleted the room
{
$kicked = 2;
}
elseif ($status == "b") // Banished by a moderator or the admin.
{
$DbLink->query("INSERT INTO ".C_MSG_TBL." VALUES ($T, '$R', 'SYS exit', '', ".time().", '', 'sprintf(L_BANISHED, \"".special_char($U,$Latin1,1)."\")')");
$kicked = 4;
};
if ($kicked > 0)
{
// Kick the user from the current room
?>
close();
exit;
};
// Updates the time to ensure the user won't be cleaned from the users table
$DbLink->query("UPDATE ".C_USR_TBL." SET u_time = ".time()." WHERE room = '$R' AND username = '$U'");
}
else
{
// User hasn't been found in the users table -> add a row
$DbLink->clean_results();
$DbLink->query("SELECT perms,rooms FROM ".C_REG_TBL." WHERE username='$U' LIMIT 1");
$reguser = ($DbLink->num_rows() != 0);
if ($reguser) list($perms, $rooms) = $DbLink->next_record();
$DbLink->clean_results();
// Get user status
$status = "u";
if ($reguser)
{
switch ($perms)
{
case 'admin':
$status = "a";
break;
case 'moderator':
$roomsTab = explode(",",$rooms);
for (reset($roomsTab); $room_name=current($roomsTab); next($roomsTab))
{
if (strcasecmp(stripslashes($R), $room_name) == 0)
{
$status = "m";
break;
};
};
default:
$status = "r";
};
};
// Get IP address
include("./lib/get_IP.lib.php3"); // Set the $IP var
$DbLink->query("INSERT INTO ".C_USR_TBL." VALUES ('$R', '$U', '$Latin1', ".time().", '$status', '$IP')");
};
// Text direction
$textDirection = ($Charset == "windows-1256") ? "RTL" : "LTR";
// For translations with an explicit charset (not the 'x-user-defined' one)
if (!isset($FontName)) $FontName = "";
?>
Messages frame
0)
echo('');
?>
" TYPE="text/css">
>
query("SELECT m_time, username, latin1, address, message FROM ".C_MSG_TBL." WHERE ".$CondForQuery." ORDER BY m_time DESC LIMIT $N");
// Format and display new messages
if($DbLink->num_rows() > 0)
{
$i = "1";
$today = date('j', time() + C_TMZ_OFFSET*60*60);
$MessagesString = "";
while(list($Time, $User, $Latin1, $Dest, $Message) = $DbLink->next_record())
{
// Skip the oldest message if the day seperator has been added
if (isset($day_separator) && $i == $N) continue;
$NewMsg = "