<?php
require("config.php");
function getN ($int) {
if ($int == 0) { $char = "SG"; }
if ($int == 1) { $char = "MP"; }
if ($int == 2) { $char = "PHX"; }
if ($int == 4) { $char = "Trading Hole"; }
return $char;
}
$error=1;
if($_POST['lostpassword']=='Buy') {
$error = 2;
$account_id = stripslashes($_SESSION['user']);
$Nation = stripslashes($_POST['nation']);
$name = stripslashes($_POST['name']);
$ChaOnline = stripslashes($_POST['ChaOnline']);
$query = "SELECT resetmoney,resetlevel,resetslimit,reset_skill,reset_quest,reset_stat,clean_skills from RanUser.dbo.Web";
$result = $db->Execute($query);
$row = $result->fetchrow();
$Cost = $row[0];
$result = mssql_query ("SELECT ChaMoney,ChaLevel,ChaReborn,ChaOnline FROM RanGame1.dbo.Chainfo Where ChaName = '$name'");
$rows=mssql_num_rows($result);
if($rows>0) {
$rows=mssql_fetch_assoc($result);
extract($rows);
$reborn2 = ($ChaReborn);
$type = ($ChaOnline);
$lev = ($ChaLevel);
$rb = ($ChaReborn);
$Gold = ($ChaMoney);
if($type>=1) {
echo "<center><font color=red size=2>Sorry this character is online.</font><p>";
$error = 1;
}
if($lev<=205) {
echo "<center><font color=red size=2>Sorry this character doesnt reach the level required.</font><p>";
$error = 1;
}
if($rb>=40) {
echo "<center><font color=red size=2>Sorry this character reached the limit for 1st stage proceed to 2nd stage.</font><p>";
$error = 1;
}
}
}
if($error==1) {
$query = "SELECT resetmoney,resetlevel,resetslimit,reset_skill,reset_quest,reset_stat,clean_skills from RanUser.dbo.Web";
$result = $db->Execute($query);
$row = $result->fetchrow();
echo "
<table width=350 border=0 cellspacing=2 cellpadding=1>
";
$login = stripslashes($_SESSION['user']);
$comanda1="SELECT UserNum from RanUser.dbo.UserInfo where Username = '$login' ";
$rezultat2=mssql_query($comanda1) or die("Can`t be executed");
while($r2=mssql_fetch_array($rezultat2)){
$Usernum = $r2["UserNum"];
}
;
echo "<center><div style='width:546px; margin:0 0 0 10px; padding:10px; border:1px solid #484848; background:#; color:#0099CC; text-align:center; line-height:18px'>
Reborn 1 to 40 Need Level 205 </div>
<div style='width:546px; margin:0 0 0 10px; padding:10px; border:1px solid #484848; background:#; color:#0099CC; text-align:center; line-height:18px'>
REMOVE ALL THE ITEMS YOU WEAR AND PUT IN INVENTORY BEFORE YOU REBORN TO AVOID ITEMLOSS </div>
<center>
</center>
<table width=480 border=0 cellspacing=0 cellpadding=0 bgcolor=black align=center>
<tr height=19>
<td align=center bgcolor=gray width=80 height=26 style='background: #0099CC; font: 11px verdana, sans-serif; color:#eee;'><font size=-1 color=#fbffff face=Helvetica, Geneva, Arial, SunSans-Regular, sans-serif><strong>ID</strong></font></td>
<td align=left bgcolor=gray width=200 height=26 style='background: #0099CC; font: 11px verdana, sans-serif; color:#eee;'><font size=-1 color=#fbffff face=Helvetica, Geneva, Arial, SunSans-Regular, sans-serif><strong>Name</strong></font></td>
<td align=center bgcolor=gray width=200 height=26 style='background: #0099CC; font: 11px verdana, sans-serif; color:#eee;'><font size=-1 color=#fbffff face=Helvetica, Geneva, Arial, SunSans-Regular, sans-serif><strong>Level</strong></font></td>
<td align=center bgcolor=gray width=200 height=26 style='background: #0099CC; font: 11px verdana, sans-serif; color:#eee;'><font size=-1 color=#fbffff face=Helvetica, Geneva, Arial, SunSans-Regular, sans-serif><strong>Reborn</strong></font></td>
</tr>
";
$rezultat4=mssql_query("SELECT * from RanGame1.dbo.Chainfo where Usernum = '$Usernum' ") or die("Cant");
while($r3=mssql_fetch_array($rezultat4))
{
$b1 = $r3['ChaName'];
$b2 = $r3['ChaNum'];
$b3 = $r3['ChaReborn'];
$b4 = $r3['ChaMoney'];
$b5 = $r3['ChaLevel'];
echo"
<tr height=19>
<td align=center width=80 height=19 style='border-bottom:#CCCCCC 1px dashed'><b><font color=black size=2>$b2</td>
<td align=left width=200 height=19 style='border-bottom:#CCCCCC 1px dashed'><b><font color=black size=2>$b1</td>
<td align=center width=200 height=19 style='border-bottom:#CCCCCC 1px dashed'><b><font color=black size=2>$b5</td>
<td align=center width=200 height=19 style='border-bottom:#CCCCCC 1px dashed'><b><font color=black size=2>$b3</td>
</td>
</tr>
";
}
echo " </table>";
}
echo "<br><center><form name='lostpassword' action='' method='post' onsubmit='return checkform1()' autocomplete='off'>
<table CELLSPACING=0 BORDER=0 CELLPADDING=0 align=CENTER>
<tr>
<td width=100 align=right>
<font size=2 color=black><b>Character :
</td>
<td>
<select name=name style='background: #0099CC; font: 11px verdana, sans-serif; color:#eee;'>";
$i=0;
$rezultat4=mssql_query("SELECT * from RanGame1.dbo.Chainfo where Usernum = '$Usernum' ") or die("Cant");
while($r3=mssql_fetch_array($rezultat4))
{
$r1 = $r3['ChaName'];
$r2 = $r3['ChaNum'];
$r2++;
echo"
<option value=$r1>$r1
";
}
echo "
</select>
</td>
<td width=100 align=right><input type=hidden name=lostpassword value='Buy'>
<input type=hidden name=Nation value='$r2'>
<td align=right><input type=submit name=Login value=' Reborn 'tabindex='5' class='btn2' style='font-size:12px;height:24px;width:65px;' /></td></tr>
</form>
";
if($error==2) {
$query = "SELECT resetmoney,resetlevel,resetslimit,reset_skill,reset_quest,reset_stat,clean_skills from RanUser.dbo.Web";
$result = $db->Execute($query);
$row = $result->fetchrow();
$account_id = stripslashes($_SESSION['user']);
$Usernum = ($UserNum);
$Alz = ($Alz);
$Nation = stripslashes($_POST['nation']);
$name = stripslashes($_POST['name']);
$Cost = $row[0];
$r = $row[1] / $row[1];
$rr = 1;
$rezultat4=mssql_query("SELECT * from RanGame1.dbo.Chainfo where Usernum = '$Usernum' ") or die("Cant");
$r3=mssql_fetch_array($rezultat4);
$b1 = $r3['ChaName'];
$b2 = $r3['ChaNum'];
$b3 = $r3['ChaReborn'];
$b4 = $r3['ChaMoney'];
$b5 = $r3['ChaLevel'];
$b6 = $r3['ChaRB'];
$error_rb = 0;
//EDIT THIS
$reward_stats = 500;
$reward_skillstats = 0;
$rb_level_first_stage = 201;
$rb_level_second_stage = 203;
$rb_level_third_stage = 204;
$rb_level_fourth_stage = 205;
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaReborn = ChaReborn + 1 WHERE ChaName = '$name'");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaExp = 0 WHERE ChaName = '$name'");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkillPoint = ChaSkillPoint+'$reward_skillstats' WHERE ChaName = '$name'");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaStRemain = 200*ChaReborn WHERE ChaName = '$name'");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaLevel = 1 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaPower = 0 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaStrong = 0 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaStrength = 0 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSpirit = 0 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaDex = 0 WHERE ChaName = '$name' ");
mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaIntel = 0 WHERE ChaName = '$name'");
$result = mssql_query ("SELECT ChaMoney FROM RanGame1.dbo.ChaInfo Where ChaName = '$name'");
$rows=mssql_num_rows($result);
echo "<center><br><font size=3 color=green>Character Reborn successfully.</font><br><br><font size=2>Your Character <b>$name</b> have:</font> <font color=black size=2><b>$Gold</font></b><font size=2> Left</font><br><br>";
delayedrefresh('controlpanel.php?op=user&option=manualreborn');
}
?></table>
