[PHP]
if (isset($_POST['submit'])) {
$host = "127.0.0.1";
$database = "MuOnline";
$user = "sa";
$password = "SQL pass";
if (extension_loaded('gd')){echo("");}
else{Die("
Loading php_gd2.dll Failed!
Please Enable php_gd2.dll In Your Php.ini");}
$connect = mssql_connect($host,$user,$password);
$db = mssql_select_db($database,$connect);
if(!$db) die('
Connection with SQL Server failed!');
$account = stripslashes($_POST['acc']);
$pass= stripslashes($_POST['pass']);
$querya = mssql_query("!@#$%^ * From MEMB_STAT where memb___id='$account' and ConnectStat='1'");
$rowa = mssql_num_rows($querya);
$queryacc = mssql_query("!@#$%^ * From MEMB_INFO where memb___id='$account' and memb__pwd='$pass'");
$rowacc = mssql_num_rows($queryacc);
if($rowa>0){ echo "Your Account is Online"; $err=1;}
elseif($rowacc<=0){ echo "Wrong Password or Account"; $err=1;}
if ($err!=1) {
function stone($account){
$query= mssql_query("declare @it varbinary(1200);
set @it=(!@#$%^ [Items] from [warehouse] where [AccountID]='$account');
print @it");
$items = substr(mssql_get_last_message(),2);
$br=0;
for($i=0;$i<120;$i++){
if(substr($items,$i*20,4)=="D508"){$br++;$items=substr_replace($items,"FFFFFFFFFFFFFFFFFFFF",$i*20,20);}
}
$new_warehouse=mssql_query("update [warehouse] set [Items]=0x$items where [AccountID]='$account'");
return $br;
}
$querych = mssql_query("!@#$%^ * From StoneRena where acc='$account'");
$rowch = mssql_num_rows($querych);
$stones= stone($account);
if($rowch<=0){
$a = mssql_query("INSERT INTO StoneRena (acc, stone) VALUES('$account', '$stones')");
echo "You Deposited $stones Stone ";
}
else {
$a= mssql_query("update StoneRena set stone=stone+$stones where [acc]='$account'");
echo "You Deposited $stones Stone ";
}
return $br;
}
}
?>[/PHP]