<?php
require("config1.php");
include_once('sql_check.php');
_OQE01();
$_I6otf=mssql_connect("$_I6ooJ","$_I6Cto","$_I6i8Q");
$_I6iiJ=mssql_select_db("MuOnline",$_I6otf);
$_IfQ8O = stripslashes($_POST['character_name']);
$_I6L6J = stripslashes($_POST['login_name']);
$_IfI86 = stripslashes($_POST['password']);
if (
(preg_match("[^';]", $_IfQ8O)) ||
(preg_match("[^';]", $_I6L6J)) ||
(preg_match("[^';]", $_IfI86)) )
{
echo("Please use the following characters: A-Z 0-9");
exit();
}
$_IfQ8O = str_replace("'","","$_IfQ8O");
$_IfQ8O = str_replace(" ","","$_IfQ8O");
$_I6L6J = str_replace("'","","$_I6L6J");
$_I6L6J = str_replace(" ","","$_I6L6J");
$_IfI86 = str_replace("'","","$_IfI86");
$_IfI86 = str_replace(" ","","$_IfI86");
$_I6LiQ = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$_I6L6J'");
$_I6lI8 = mssql_num_rows($_I6LiQ);
$_IfjJt = mssql_query("SELECT Name FROM Character WHERE Name='$_IfQ8O' and AccountID = '$_I6L6J'");
$_Ifj6C = mssql_num_rows($_IfjJt);
$_If0IQ = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$_IfI86' and memb___id='$_I6L6J'");
$_If0Lf = mssql_num_rows($_If0IQ);
$_IftOJ = mssql_query("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id='$_I6L6J'");
$_IftCJ = mssql_fetch_row($_IftOJ);
$_I6J8j = mssql_query("Select Clevel,Resets,Money,LevelUpPoint,Class,ctlcode From Character where Name='$_IfQ8O'");
$_I66L1 = mssql_fetch_row($_I6J8j);
$_IojJQ=$_I66L1[1] + (1);
$_IoJ0t=$_I66L1[2]-$_IfC6I;
$_IoJQl=$_IfC6I;
$_IoJ8t=$_I66L1[1] + 1;
$_IoJLo=$_I66L1[1] * $_IfLIL + $_IfLIL;
if (empty($_IfQ8O) || empty($_I6L6J) || empty($_IfI86)){
echo " Fields were missed out go back and enter them.";}
elseif ($_I6lI8 <= 0){
echo "Your account doesn't exist. Please go back and try again.";}
elseif ($_Ifj6C <= 0){
echo "Your character doesn't exist in your account. Please go back and try again."; }
elseif ($_If0Lf <= 0){
echo "The password you entered is incorrect."; }
elseif ($_I66L1[1] > $_Ifiof-1){
echo "<font color=red><b>You are MAX resets possible, GG!</b>"; }
elseif ($_IftCJ[0] != 0){
echo "Please logoff before reset!"; }
elseif ($_I66L1[5]==8){
echo "<font color=red><b>Warning! GM cant reset! Good try! XTYLING will bann you :P</b></font>"; }
elseif ($_I66L1[0] < $_IfiQL){
echo " You need <font color=red>$_IfiQL</font> lvl to reset, your level is <font color=green>$_I66L1[0]</font>"; }
elseif ($_IoJ0t < 0){
echo " You need <font color=red>$_IoJQl</font> zen to reset!"; }
else {
if ($_I66L1[0]>0){
$_If1j0 = "
UPDATE dbo.Character
SET clevel=1
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET Resets = '$_IojJQ'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET experience = '0'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET money = '$_IoJ0t'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET MapNumber = '0'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET MapPosX= '125'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET MapPosY= '125'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
";}
$_Io680 = mssql_query($_If1j0);
echo "$_IfQ8O have done $_IoJ8t reset successfully.";
}
?>