<style type="text/css">
<!--
body {
	background-image: url(images/bg.gif);
}
-->
</style><?php

// Configuration.
// Realm database.
$r_db = "realmdz";
// IP (and port).
$ip = "127.0.0.1:3306";
// Username.
$user = "root";
// Password.
$pass = "evox";
// Site title.

// End config.

$page = '


<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">
<p style="text-align:center;">

<br /><br /><br />
Username:
<br /><input name="username" type="text" maxlength="14" /><br />
Password:
<br /><input name="password" type="password" maxlength="12" /><br />
Email:
<br /><input name="email" type="text" maxlength="50" />
<br /> <br />
<button type="submit">Create</button>
</p>
</form>
</body>
</html>';

function error_s ($text) {
	echo("<p style=\"background-color:black;color:white;\">" . $text);
	echo("<br /><br /><a style=\"color:white;\" href=register2.php>Back</a></p>");
	echo("<a style=\"color:white;\" href=index.php>Home</a></p>");


};

$user_chars = "#[^a-zA-Z0-9_\-]#";
$email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";

$con = @mysql_connect($ip, $user, $pass);
if (!$con) {
	error_s("Unable to connect to database: " . mysql_error());
};

if (!empty($_POST)) {
        if ((empty($_POST["username"]))||(empty($_POST["password"]))||(empty($_POST["email"])) ) {
                error_s("You did not enter all the required information.");
				exit();
        } else {
                $username = strtoupper($_POST["username"]);
                $password = strtoupper($_POST["password"]);
                $email = strtoupper($_POST["email"]);
                if (strlen($username) < 4) {
                        error_s("Username too short.");
                        exit();
                };
                if (strlen($username) > 14) {
                        error_s("Username too long.");
                        exit();
                };
                if (strlen($password) < 4) {
                        error_s("Password too short.");
                        exit();
                };
                if (strlen($password) > 12) {
                        error_s("Password too long.");
                        exit();
                };
                if (strlen($email) < 4) {
                        error_s("Email was too short.");
                        exit();
                };
				if (strlen($email) > 50) {
                        error_s("Email was too long.");
                        exit();
                };
                if (preg_match($user_chars,$username)) {
                        error_s("Username contained illegal characters.");
                        exit();
                };
                if (preg_match($user_chars,$password)) {
                        error_s("Password contained illegal characters.");
                        exit();
                };
                if (!preg_match($email_chars,$email)) {
                        error_s("Email was in an incorrect format.");
                        exit();

                };
				   if ($_POST['tbc'] != "on") {
                        $tbc = "3";
                } else {
                        $tbc = "3";
                };
                $username = mysql_real_escape_string($username);
                $password = mysql_real_escape_string($password);
                $email = mysql_real_escape_string($email);
                $qry = @mysql_query("select username from " . mysql_real_escape_string($r_db) . ".account where username = '" . $username . "'", $con);
				if (!$qry) {
					error_s("Error querying database: " . mysql_error());
				};
                if ($existing_username = mysql_fetch_assoc($qry)) {
                        foreach ($existing_username as $key => $value) {
                                $existing_username = $value;
                        };
                };
                $existing_username = strtoupper($existing_username);
                if ($existing_username == strtoupper($_POST['username'])) {
                        error_s("That username is already taken.");
                        exit();
                };
				unset($qry);
                $qry = @mysql_query("select email from " . mysql_real_escape_string($r_db) . ".account where email = '" . $email . "'", $con);
				if (!$qry) {
					error_s("Error querying database: " . mysql_error());
				};
                if ($existing_email = mysql_fetch_assoc($qry)) {
                        foreach ($existing_email as $key => $value) {
                                $existing_email = $value;
                        };
                };
                if ($existing_email == $_POST['email']) {
                        error_s("That email is already in use.");
                        exit();
                };

				unset($qry);
                $sha_pass_hash = sha1(strtoupper($username) . ":" . strtoupper($password));
                $register_sql = "insert into " . mysql_real_escape_string($r_db) . ".account (username, sha_pass_hash, gmlevel, email, expansion) values (upper('" . $username . "'),'" . $sha_pass_hash . "','1','" . $email . "','" . $tbc . "')";
                $qry = @mysql_query($register_sql, $con);
				if (!$qry) {
					error_s("Error creating account: " . mysql_error());
				};
                echo("Account successfully created.Set Realmlist infernowow.servegame.com:3725");
				echo("<br><a style=\"color:white;\" href=index.php>Home</a></p><br />");
				exit();
        };
} else {
        echo($page);
};

?>