[Release] WebBan Script + Java + MSSQL

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Banned_IP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Banned_IP]
GO

CREATE TABLE [dbo].[Banned_IP] (
	[IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[reason] [varchar] (999) COLLATE Chinese_PRC_CI_AS NULL ,
	[from] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

<?php
$ip = $_SERVER['REMOTE_ADDR'];                                                                           
$dbuser = "sa";                                                                                    
$dbpasswd = "123456789";
$host = "127.0.0.1";                                                     
$db = 'MuOnline';
mssql_connect("$host","$dbuser","$dbpasswd");
mssql_select_db("$db");
$q = mssql_query("SELECT * FROM Banned_IP WHERE IP = '$ip'");
$get = mssql_num_rows($q);
// if found
if ($get == "1")
{ 
// deny user access
$r=mssql_fetch_array($q);
echo('<script language="Javascript">alert("YOUR IP '.$_SERVER["REMOTE_ADDR"].' BLOCKED \n Reason: '.$r["reason"].'\n By '.$r["from"].'"); </script>');
exit();
}
?>

mssql_connect("$host","$dbuser","$dbpasswd");
mssql_select_db("$db");
$q = mssql_query("SELECT * FROM Banned_IP WHERE IP = '$ip'");
$get = mssql_num_rows($q);
$q2 = mssql_query("SELECT * FROM MEMB_INFO WHERE bloc_code = '1'");
$get2 = mssql_num_rows($q2);
$r=mssql_fetch_array($q);
$r2=mssql_fetch_array($q2);
// if found
if ($get == "1" && $get2 == "1")
{
echo('<script language="Javascript">alert("YOUR Account '.$r2["memb___id"].' \nYOUR IP '.$_SERVER["REMOTE_ADDR"].'\nBLOCKED \nReason: '.$r["reason"].'\nBy '.$r["from"].'"); </script>');
exit();
}
elseif ($get == "1")
{ 
// deny user access
echo('<script language="Javascript">alert("YOUR IP '.$_SERVER["REMOTE_ADDR"].' BLOCKED \nReason: '.$r["reason"].'\nBy '.$r["from"].'"); </script>');
exit();
}
elseif ($get2 == "1")
{
echo('<script language="Javascript">alert("YOUR Account '.$r2["memb___id"].' BLOCKED \n"); </script>');
exit();
}