<?

$username="root";
$password="";
$database="auth";
$localhost="127.0.0.1";

$user=$_POST['user'];
$pass=$_POST['pass'];
$expansion=$_POST['expansion'];


mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");


$Query1="SELECT id FROM account WHERE username=\"" . mysql_real_escape_string($user) . "\"";
$Query2=mysql_query($Query1) or die(mysql_error());
    if($Query2>0) { die("<p align='center'>Error:<br><br>Account Exists<br><br>Please go back and try again.</p>"); }


$query = "INSERT INTO account (username, sha_pass_hash, expansion) VALUES ('$user',SHA1(CONCAT(UPPER('$user'),':',UPPER('$pass'))),'$expansion')";
mysql_query($query);



mysql_close();

Echo"user:$user<br>pass:$pass<br>exp:$expansion<br>Query1:$Query1<br>Query2:$Query2<br>query:$query"
?>

<br>
---Old---<br>
An Attempt Was Made To Make  Your Account.<br>
Unfortunetly, I Have No Idea How To Verify It's Success.<br>
Instead, Here Is A Dancing Murloc.<br>
<img src="Images/Murloc2.gif">