<?php
include("scripts/mysql_connector.php");
//IMPORTANT STUFF
$username = mysql_real_escape_string(stripslashes($_POST["strUsername"]));
$password = mysql_real_escape_string(stripslashes($_POST["strPassword"]));
$pass = md5($password);
$age = mysql_real_escape_string(stripslashes($_POST["intAge"]));
$dob = mysql_real_escape_string(stripslashes($_POST["strDOB"]));
$email = mysql_real_escape_string(stripslashes($_POST["strEmail"]));
$gender = mysql_real_escape_string(stripslashes($_POST["strGender"]));
$classid = 2;//mysql_real_escape_string(stripslashes($_POST["ClassID"]));
$eyecolor = mysql_real_escape_string(stripslashes($_POST["intColorEye"]));
$skincolor = mysql_real_escape_string(stripslashes($_POST["intColorSkin"]));
$haircolor = mysql_real_escape_string(stripslashes($_POST["intColorHair"]));
$hairid = $_POST['HairID'];


//Grabs IP
if ($_SERVER['HTTP_X_FORWARD_FOR']) {
$ip = $_SERVER['HTTP_X_FORWARD_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}


//Checks if Email has Already been used
$emailcheck = mysql_query("SELECT id FROM etl_users WHERE strEmail='$email'") or die("status=Error&strReason=" . mysql_error());
if (mysql_num_rows($emailcheck) != 0) {
	die("status=Taken&strReason=The email is already in used by another user.");
}

//Checks If Username has been Taken
$sql = mysql_query("SELECT * FROM etl_users WHERE strUsername = '$username'") or die("status=Error&strReason=" . mysql_error());
if (mysql_num_rows($sql) !=0) {
	die("status=Taken&strReason=The username is already in use by another character.");
} else {

//Sets Hairname & hairfile
switch ($hairid) {
	//MALE HAIR
	case 52:
		$hairname = 'Default';
		$hairfile = 'hair/M/Default.swf';
		break;
	case 55:
		$hairname = 'Goku1';
		$hairfile = 'hair/M/Goku1.swf';
		break;
	case 58:
		$hairname = 'Goku2';
		$hairfile = 'hair/M/Goku2.swf';
		break;
	case 64:
		$hairname = 'Normal2';
		$hairfile = 'hair/M/Normal2.swf';
		break;
	case 92:
		$hairname = 'Ponytail8';
		$hairfile = 'hair/M/Ponytail8.swf';
		break;

	//FEMALE HAIR
	case 14:
		$hairname = 'Pig1Bangs1';
		$hairfile = 'hair/F/Pig1Bangs1.swf';
		break;
	case 18:
		$hairname = 'Pig2Bangs2';
		$hairfile = 'hair/F/Pig2Bangs2.swf';
		break;
	case 26:
		$hairname = 'Pony2Bangs2';
		$hairfile = 'hair/F/Pony2Bangs2.swf';
		break;
	case 83:
		$hairname = 'Bangs2Long';
		$hairfile = 'hair/F/Bangs2Long.swf';
		break;
	case 84:
		$hairname = 'Bangs3Long';
		$hairfile = 'hair/F/Bangs3Long.swf';
		break;
}
$regon = date("Y-m-d");
//Inserts Character Info into DB
$sql2 = mysql_query("INSERT INTO etl_users (strUsername, strPassword, strEmail, iAge, strGender, currentClass, strHairName, strHairFilename, intColorSkin, intColorHair, intColorEye, registered_ip, sHouseInfo, referredBy, registered_on, strQuests) VALUES ('$username', '$pass', '$email', '$age', '$gender','$classid','$hairname','$hairfile', '$skincolor', '$haircolor', '$eyecolor', '$ip', '', '', '$regon', '00000000000000000')") or die("status=Error&strReason=" . mysql_error());

//Selects New User ID
$sql3 = mysql_query("SELECT * FROM etl_users WHERE strUsername='$username'") or die("status=Error&strReason=" . mysql_error());
$user = mysql_fetch_assoc($sql3) or die("status=Error&strReason=" . mysql_error());
$user_id = $user['id'];

/** ADD'S STARTING CLASSES **/
/** StylinQuest Worlds Features **/
switch ($classid) {
	case 1: //Barbarian Class
		$addarmour = mysql_query("INSERT INTO etl_users_items (item_id, user_id, bEquip, sES, iLvl, iCP) VALUES ('1', '$user_id', '1', 'ar', '1', '0')") or die("status=Error&strReason=" . mysql_error());
		break;
	case 4: //Merchang Class
		$addarmour = mysql_query("INSERT INTO etl_users_items (item_id, user_id, bEquip, sES, iLvl, iCP) VALUES ('2', '$user_id', '1', 'ar', '1', '0')") or die("status=Error&strReason=" . mysql_error());
		break;
	case 3: //Wizard Class
		$addarmour = mysql_query("INSERT INTO etl_users_items (item_id, user_id, bEquip, sES, iLvl, iCP) VALUES ('3', '$user_id', '1', 'ar', '1', '0')") or die("status=Error&strReason=" . mysql_error());
		break;
	case 10: //Fae Class
		$addarmour = mysql_query("INSERT INTO etl_users_items (item_id, user_id, bEquip, sES, iLvl, iCP) VALUES ('4', '$user_id', '1', 'ar', '1', '0')") or die("status=Error&strReason=" . mysql_error());
		break;
}

//Adds Default Weapon to User
$addweapon = mysql_query("INSERT INTO etl_users_items (item_id, user_id, bEquip, sES, iLvl) VALUES ('1', '$user_id', '1', 'Weapon', '1')") or die("status=Error&strReason=" . mysql_error());

//So The User Isn't Lonely
$addfriends = mysql_query("INSERT INTO etl_users_friends (user_id) VALUES ('$user_id')") or die("status=Error&strReason=" . mysql_error());

//SUCCESS
echo "status=Success";
}
?>