banish.lib.php3

使用PHP编程的聊天室

<?
// This library allows to ensure the user who wants to enter in the chat is not a
// banished one.
// Additional credits for this lib go to Tomas Haluza (<[e-mail]>),
// Ray Lopez (<[e-mail]>) and Fabiano R. Prestes (<[e-mail]>)

$IsBanished = false;

// Clean the banished users table
$DbLink->query("DELETE FROM ".C_BAN_TBL." WHERE ban_until < ".time());

// Get the IP of the user
if (!isset($ChatPath)) $ChatPath = "";
if (!isset($IP) || $IP == "") include("./${ChatPath}lib/get_IP.lib.php3");


// Seek for a banished nick
$DbLink->query("SELECT ip,rooms FROM ".C_BAN_TBL." WHERE username='$U' LIMIT 1");
$Nb = $DbLink->num_rows();
// Nick of the user is banished from some rooms
if ($Nb != "0")
{
	list($Old_IP,$BanishedFromRooms) = $DbLink->next_record();
	$DbLink->clean_results();
	$BanishedFromRooms = addslashes($BanishedFromRooms);

	// Is the user banished from the room he wants to enter in
	if ($BanishedFromRooms == "*")
	{
		$IsBanished = true;
	}
	elseif (isset($R1) && $R1 != "")
	{
		if (room_in($R1, $BanishedFromRooms)) $IsBanished = true;
	}
	elseif (isset($R0) && $R0 != "")
	{
		if (room_in($R0, $BanishedFromRooms)) $IsBanished = true;
	};

	// Update the IP of the user in the banished table when necessary
	if ($IsBanished && $IP != $Old_IP && (substr($IP, 0, 1) != "p" || substr($Old_IP, 0, 1) == "p")) $DbLink->query("UPDATE ".C_BAN_TBL." SET ip='$IP' WHERE username='$U'");
}
// Nick of the user isn't banished from any room, seek for banished IP
else
{
	$DbLink->clean_results();

	$DbLink->query("SELECT rooms,ban_until FROM ".C_BAN_TBL." WHERE ip='$IP' LIMIT 1");
	$Nb = $DbLink->num_rows();
	// IP is banished from some rooms
	if ($Nb != "0")
	{
		list($BanishedFromRooms,$Until) = $DbLink->next_record();
		$DbLink->clean_results();
		$BanishedFromRooms = addslashes($BanishedFromRooms);

		// Is the IP banished from the room user wants to enter in ?
		if ($BanishedFromRooms == "*")
		{
			$IsBanished = true;
		}
		elseif (isset($R1) && $R1 != "")
		{
			if (room_in($R1, $BanishedFromRooms)) $IsBanished = true;
		}
		elseif (isset($R0) && $R0 != "")
		{
			if (room_in($R0, $BanishedFromRooms)) $IsBanished = true;
		};

		// Add the user to the banished table when necessary
		if ($IsBanished) $DbLink->query("INSERT INTO ".C_BAN_TBL." VALUES ('$U', '$Latin1', '$IP', '$BanishedFromRooms', '$Until')");
	}
	else
	{
		$DbLink->clean_results();
	};
 };

?>