- Joined
- Nov 13, 2008
- Messages
- 1,367
- Reaction score
- 509
Ето кода за всеки един от вас , който не може да се оправи със query и иска да си реска героя със сета на xtyling web-a
PHP:
<?php include"home.php"; ?>
</style></head><body leftmargin="0" topmargin="0">
<table align="center" border="1" bordercolor="#666666" cellpadding="0" cellspacing="0" frame="vsides" rules="none" width="760">
<tbody><tr>
<td align="left" background="images/left_bg.gif" valign="top" width="204"><img src="images/left_top_news.gif" height="36" width="204">
<?php include"pictures.php"; ?>
<?php include"menu.php"; ?></td>
<td background="images/xu.gif" height="190" width="1"></td>
<td align="center" bgcolor="#ffffff" valign="top" width="553">
<table width="540" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td colspan="3"> </td>
<td> </td>
</tr>
<tr>
<td width="24"> </td>
<td colspan="3"><div align="center"><span class="style6">Reset Character</span></div></td>
<td width="28"> </td>
</tr>
<tr>
<td> </td>
<td colspan="3"> </td>
<td> </td>
</tr>
<tr>
<td height="28"> </td>
<td width="10"> </td>
<td width="79"> </td>
<td width="399"><?php
require("config.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 " You dont have characters";}
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! </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 LevelUpPoint = '$_IoJLo'
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'
UPDATE dbo.Character SET strength = '25'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET dexterity = '25'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET vitality = '25'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET energy = '25'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'
UPDATE dbo.Character SET LevelUpPoint = '$_IoJLo'
WHERE Name = '$_IfQ8O'
AND AccountID = '$_I6L6J'";}
$_Io680 = mssql_query($_If1j0);
echo "$_IfQ8O have done $_IoJ8t reset successfully.";
}
?></td>
<td> </td>
</tr>
<tr>
<td height="28"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="28"> </td>
<td colspan="3"><p><p></td>
<td> </td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</body></html>
