<?php
$MD5Code = "kikugalanet"; // Your Neuz MD5 Code
$dbAddr = 'Your SQL Express Here'; // Your MSSQL Host IP
$dbUser = 'sa'; // Your Database user
$dbPass = 'Your DB Pass'; // Your Database User password
$dbName = "CHARACTER_01_DBF"; // Your Account Database
$server_name = "Flyff"; // Define your Servername here
$reg_allow = 1; // To turn on registering a write "1"
if(!extension_loaded("mssql")) {
echo "The required module is not enabled on your MSSQL server. Please enable it.";
exit();
}

$link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Could not connect to the database. Please check your settings.");
mssql_select_db($dbName, $link);
?>
<table width="500" border="0" class="tables2">
<tr>
<td align="center" height="18"></td>
</tr>
<tr>
<td align="left" class="Estilo3"></td>
</tr>
<tr>
<td align="center" class="estilo3"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>

<td align="center">
<?php
if ($act == 'reborn')
{
$id = $_GET["id"];
$matchrows = mssql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'");
$checkrows = mssql_num_rows($matchrows);
if ($checkrows != 0)
{
$id = $_GET["id"];
$query = mssql_query("SELECT * FROM characters WHERE id = $id");
$get = mssql_fetch_array($query);
$class = $get['class'];
$lvl = $get['level'];
$rebirths = $get['rebirths'];

if (($lvl == 121) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths) && ($penya >= $rebirthcost))
{
if ($class == 24) { mssql_query("UPDATE characters SET class = 16 WHERE id = $id"); }
if ($class == 25) { mssql_query("UPDATE characters SET class = 17 WHERE id = $id"); }
if ($class == 26) { mssql_query("UPDATE characters SET class = 18 WHERE id = $id"); }
if ($class == 27) { mssql_query("UPDATE characters SET class = 19 WHERE id = $id"); }
if ($class == 28) { mssql_query("UPDATE characters SET class = 20 WHERE id = $id"); }
if ($class == 29) { mssql_query("UPDATE characters SET class = 21 WHERE id = $id"); }
if ($class == 30) { mssql_query("UPDATE characters SET class = 22 WHERE id = $id"); }
if ($class == 31) { mssql_query("UPDATE characters SET class = 23 WHERE id = $id"); }

mssql_query("UPDATE characters SET level = 60 WHERE id = $id");
mssql_query("UPDATE characters SET world = 1 WHERE id = $id");
mssql_query("UPDATE characters SET posx = 6973 WHERE id = $id");
mssql_query("UPDATE characters SET posy = 10 WHERE id = $id");
mssql_query("UPDATE characters SET posz = 3328 WHERE id = $id");
mssql_query("UPDATE characters SET rebirths = rebirths + 1 WHERE id = $id");
mssql_query("UPDATE characters SET penya = $penya - $rebirthcost WHERE id = $id");

if (mssql_affected_rows() != 0)
{
echo "<center><h3>Character has successfully been rebirth!</h3></center>";
}
else
{
echo "<center><h3>An error has occured, please try again.</h3></center>";
}
}
else
{
echo "<center><h3>Your character can not yet be rebirth. You must be level 120 HERO and get 20000000 of penya.</h3></center>";
}
}
}
?>