<?
/* Script Created by BORODA specially for MMORPG-DEV.COM Community */
/* Modded by Kvait */
include "core.php";

//Preregistartion processing. Making the password string a valid format
$aaa=$_REQUEST['login'].$_REQUEST['pass'];
$md=md5($aaa);
$cc="0x";
$md52=$cc.$md;
$login = $_REQUEST['login'];
$question = $_REQUEST['question'];
$answer = $_REQUEST['answer'];
$email = $_REQUEST['email'];
$gender = $_REQUEST['gender'];
$realname = "John Doe"; //$_REQUEST['realname'];
$dn = 9401108; //$_REQUEST['dn'];
$mnumber = 9401108; //$_REQUEST['mnumber'];
$pnumber = 9401108; //$_REQUEST['pnumber'];
$province = "Japan"; //$_REQUEST['province'];
$city = "Tokyo"; //$_REQUEST['city'];
$address = "777 Lucky Street"; //$_REQUEST['address'];
$zip = "777"; //$_REQUEST['zip'];

// Connection with MSSQL server
$conn=mssql_connect($SERVER,$ADMIN_NAME,$ADMIN_PASS);
$db = mssql_select_db($DATABASE,$conn) or die("Connection failed! Check your core.php");

// Check if user already exists
$query = "SELECT * FROM users WHERE (name = '$login')";
$rresult = mssql_query($query) or die("Failed to execute query! Something went wrong... $query");
$last2=mssql_fetch_row($rresult);
if ($last2['0'] > 0) {
echo "Such user already exists!";
exit;
}

$query = "exec adduser '$login',$md52,'$question',$answer,'$realname','$d n','$email','$mnumber','$province','$city','$pnumb er','$address','$zip','$gender','','1',$md52";
$rresult = mssql_query($query) or die("Failed to execute query! Something went wrong...");

$getID = "select * from users where name='$login'";
$doGetID = mssql_query($getID);
$player = mssql_fetch_array($doGetID);
$giveTo = $player['ID'];

$giveGold = "DECLARE @error integer
exec usecash $giveTo,1,0,1,0,250000,1,@error";
$doGiveGold = mssql_query($giveGold);
//All done. Lets info the user...
echo "<b>Account:</b> $login<br><b>Password:</b> $_REQUEST[pass]<br><br>Registration is complete.";
?>