I can use script
PHP Code:
<?php
require_once "config.inc.php";
if(isset($_SESSION["step2"]) && isset($_POST["step2"])) {
$errorStr = formStep3();
if($errorStr!=null){
require_once('register.html');
}else{
require_once('success.html');
$suc=$success;
unset($_SESSION[step2], $_SESSION[step1]);
}}
else {
require_once('register.html');
$_SESSION["step2"] = 1; }
function formStep3(){
$errors = array();
$errorStr = null;
$strSql="select * from Tbl_user where user_id='$_POST[username]'";
if ($_POST[ZoneGroup]=="zone1") {
$account_odbc = odbc_connect('account','sa','********');
} elseif ($_POST[ZoneGroup]=="zone2") {
$account_odbc = odbc_connect('account2','sa','*******');
} else {
die ("<p><b>·ÖÇøÑ¡Ôñ´íÎó!</b></p>");
}
$user_result=odbc_do($account_odbc,$strSql);
$result_query=odbc_fetch_row($user_result);
if (odbc_result($user_result,1)!= "") $errors[] = "This Accountname already exists, please choose another one.";
if(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST[username])) $errors[]="You are only alowed to use uppper and lower cases in English in your username.";
if(strlen($_POST[username])<3) $errors[] = "The length of your username can't be less than 3 characters";
if(strlen($_POST[username])>15) $errors[]= "The length of your username can't be more than 15 characters";
if(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST[password1])) $errors[]="You can only use English Characters of Upper case and lower case in your password. Try again";
if(preg_match("/^[0-9]{3,15}$/i",$_POST[password1])) $errors[]="You are not alowed just to input numbers as your password.";
if($_POST[username]==$_POST[password1]) $errors[]= "Accountname and password can't be the same!";
if(strlen($_POST[password1])<3) $errors[] = "The length of the password can't be less than 3 characters";
if(strlen($_POST[password1])>15) $errors[] = "The length of the password can't be more than 15 characters";
if($_POST[password2]!=$_POST[password1]) $errors[] = "Password does not match";
if(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST[mail])) $errors[]="Your E-mail Adress is not valid. Please enter a valid one.";
if(strlen($_POST[referred])>20) $errors[] = "The length of the referred name can't be more than 20 characters";
if(sizeof($errors)>0){
$errorStr .= "<br><font>";
$errorStr .= "You have the following error(s):";
foreach($errors as $error)
$errorStr .= "<li>$error</li>";
$errorStr .= "</font><br><br>";
}else{
$passwd_user=md5($_POST["password1"]);
$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);
$dk_account_query="insert into user_profile(user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) values('$dk_user_no','$_POST[username]','$passwd_user','801011000000','1','0','Y','05/06/2009 00:00:00',null,null,null,'000')";
$dk_account_query2="insert into Tbl_user(user_no,user_id,user_pwd,user_mail,user_answer,user_question) values('$dk_user_no','$_POST[username]','$_POST[password1]','$_POST[mail]',0,0)";
$dk_account_result1=odbc_do($account_odbc,$dk_account_query);
$dk_account_result2=odbc_do($account_odbc,$dk_account_query2);
odbc_close($account_odbc);
}
return $errorStr;
}
?>
but can't use
PHP Code:
<?php
// written by zombe and
// modifyed janvier123 :)
// cleaning up after is ass :)
//-----------------------------------------------
// This script is made for players to reborn themselfs
// But its has some limits inside
// - Cant Reborn a [GM] character
// - Can have some bug, that i cant find :)
//
// How does it work ?
// - Enter a name
// - Check the requirements
// - Press "Yes, make me rebiorn plz
// - Done :)
//-----------------------------------------------
// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
'host' => "192.168.1.3", // Normaly "localhost" or "XXX.XXX.XXX.XXX"
'user' => "sa", // Your username for MSSQL server, normaly "sa"
'pass' => "*******" // Your password for MSSQL server
);
//<--! ind MSSQL info !-->
// Please fill in your Classes info if not correct
//<--! begin classes info !-->
$classes = array(
'0' => "Azure Knight",
'1' => "Segita Hunter",
'2' => "Incar Magician",
'3' => "Vicious Summoner",
'4' => "Segnale",
'5' => "Bagi Warrior",
'6' => "Aloken"
);
//<--! end classes info !-->
// Please fill in your requirements if not correct
// WARNING DO NOT PUT "." BETWEEN "dil"
//<--! begin requirements info !-->
$req = array(
'name' => "Any name... Duh!",
'level' => "200",
'dil' => "50000000",
'class' => "Any class... Duh!",
'reborn' => "None"
);
//<--! end requirements info !-->
// Please chance if you want
//<--! begin text info !-->
$text = array(
'title1' => "Is this correct?",
'title2' => "Your new stats.",
'button1' => "Next ...",
'step1' => "Enter character name:",
'table1' => "--------- Type ---------",
'table2' => "--------- Current ---------",
'table3' => "--------- Required ---------",
'done' => "Reborn was successful, blah.",
'error1' => "Something went wrong, lol",
'error2' => "No such character"
);
//<--! end text info !-->
// Step 1:
// Getting name to fill in the table below and to exec the reborn script
if ($_GET['step'] == ""){
echo'<center><Form Name ="form" action="reborn.php?step=2" Method ="POST">';
echo''.$text['step1'].'<p>';
echo'<input name="name" type="text" value="">';
echo'<br>';
echo'<input type="hidden" name="select" value="1">';
echo'<input name="submit" type="submit" value="'.$text['button1'].'">';
echo'</form></center>';
// getting name from form and go to step 2
// OK time for step 2
} else if ($_GET['step'] == "2"){
if($_POST['select'] == '1') {
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT * FROM character.dbo.user_character WHERE character_name = '".$_POST['name']."'",$ms_con);
$count1 = mssql_num_rows($result1);
$result1 = mssql_query("SELECT login_flag FROM account.dbo.USER_PROFILE WHERE user_no = '".$_POST['user_no']."'",$ms_con);
$row1 = mssql_fetch_row($result1);
if($row1[0] == '1100') {
$result2 = mssql_query("SELECT character_no FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."' ORDER by login_time DESC",$ms_con);
$row2 = mssql_fetch_row($result2);
}
if($row1[0] == '1100' && $row2[0] == $_POST['char_no']) {
echo "<br>This character can not currently be edited, since it is online.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif($count1 < '1') {
echo "<center><br>Could not find the character name. <br><a href='javascript:history.back()'>Go Back</a></center>";
} elseif($count > '1') {
echo "<center><br>There were several characters with the same name found. <br>Please check that name in the database.<br><a href='javascript:history.back()'>Go Back</a></center>";
} else {
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result2 = mssql_query("SELECT character_name,dwExp,dwMoney,wLevel,Reborn FROM character.dbo.user_character WHERE character_name = '".$_POST['name']."'",$ms_con);
$row2 = mssql_fetch_row($result2);
echo "<center><br><form action='reborn.php?step=3' method='POST'>
<table class='innertab'>
<tr>
<td colspan='3' align='left'><b><center>".$text['title1']."</center></b></td>
</tr>
<tr>
<td colspan='3' align='left'> </td>
</tr>
<tr>
<td align='left'><b>".$text['table1']."</b></td>
<td align='left'><b>".$text['table2']."</b></td>
<td align='left'><b>".$text['table3']."</b></td>
</tr>
<tr>
<td align='left'><b>Character Name:</b></td>
<td align='left'><input type='text' name='new_name' readonly=readonly maxlength='20' value='".$row2[0]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['name']."'></td>
</tr>
<tr>
<td align='left'><b>Level:</b></td>
<td align='left'><input type='text' name='new_wLevel' readonly=readonly maxlength='20' value='".$row2[3]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['level']."'></td>
</tr>
<tr>
<td align='left'><b>DIL Inventory:</b></td>
<td align='left'><input type='text' name='new_dwMoney' readonly=readonly maxlength='20' value='".$row2[2]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['dil']."'></td>
</tr>
<tr>
<td align='left'><b>Reborn:</b></td>
<td align='left'><input type='text' name='new_reborn' readonly=readonly maxlength='20' value='".$row2[4]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['reborn']."'></td>
</tr>
<tr>
<td align='left' colspan='3'>
<input type='submit' value='Yes, make me reborn'>
</tr>
</table>
</form></center>";
}
}
// WARNING YOU NEED TO CHANGE "/170/" IF YOU CHANGED YOUR REQUIREMENTS
} elseif(!preg_match("/170/", $_POST['new_wLevel'])) {
echo "<br><center>The level does not match the requirements.<br><a href='javascript:history.back()'>Go Back</a></center>";
// WARNING YOU NEED TO CHANGE "/50000000/" IF YOU CHANGED YOUR REQUIREMENTS
// } elseif(!preg_match("/50000000/", $_POST['new_dwMoney'])) {
// echo "<br><center>The dill does not match the requirements.<br><a href='javascript:history.back()'>Go Back</a></center>";
// if step 2 is ok go to step 3
// OK time for step 3
} else if ($_GET['step'] == "3"){
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result3 = mssql_query("
USE character;
EXEC RemoteReborn '".$_POST['new_name']."'
",$ms_con);
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result4 = mssql_query("SELECT character_name,dwExp,wLevel,wStr,wDex,wCon,wSpr,dwMoney,wStatPoint,wSkillPoint,Reborn FROM character.dbo.user_character WHERE character_name = '".$_POST['new_name']."'",$ms_con);
$row4 = mssql_fetch_array($result4);
echo"<center><table class='innertab'>
<tr>
<td colspan='3' align='left'><b><center>".$text['done']."</center></b></td>
</tr>
<tr>
<td colspan='3' align='left'> </td>
</tr>
<tr>
<td align='left'><b>".$text['table1']."</b></td>
<td align='left'><b>".$text['table2']."</b></td>
</tr>
<tr>
<td align='left'><b>Character Name:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[0]."'></td>
</tr>
<tr>
<td align='left'><b>Exp:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[1]."'></td>
</tr>
<tr>
<td align='left'><b>Level:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[2]."'></td>
</tr>
<tr>
<td align='left'><b>Str points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[3]."'></td>
</tr>
<tr>
<td align='left'><b>Dex points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[4]."'></td>
</tr>
<tr>
<td align='left'><b>Con points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[5]."'></td>
</tr>
<tr>
<td align='left'><b>Spr points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[6]."'></td>
</tr>
<tr>
<td align='left'><b>Dill:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[7]."'></td>
</tr>
<tr>
<td align='left'><b>Stat points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[8]."'></td>
</tr>
<tr>
<td align='left'><b>Dil Inventory:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[9]."'></td>
</tr>
<tr>
<td align='left'><b>Reborn:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[10]."'></td>
</tr>
</table></center>";
echo "<center><br><a href='reborn.php'>Thank you! Take me back now.</a></center>";
}
else echo"<p>Something went wrong, lol.";
?>
come on lazy man...