<?php
$dbhost = "db4free.net";
$dbname = "membership";
$dbuser ="********";
$dbpass = "******";
$table = "g_users";
$username = "This Name Is Too Long And Will Not Work With The Game So It Is Invalid So Enter A Real Username That Is Valid When Signing Up";
$email = "thisisafakeinvalidemailanddoesnotworksoenteryouremailwhensigningup";
$colour = 1;

function check_email_address($email) {
  if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) {
    return false;
  }
  $email_array = explode("@", $email);
  $local_array = explode(".", $email_array[0]);
  for ($i = 0; $i < sizeof($local_array); $i++) {
    if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%&
?'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$",
$local_array[$i])) {
      return false;
    }
  }


  if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) {
    $domain_array = explode(".", $email_array[1]);
    if (sizeof($domain_array) < 2) {
        return false;
    }
    for ($i = 0; $i < sizeof($domain_array); $i++) {
      if
(!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|
?([A-Za-z0-9]+))$",
$domain_array[$i])) {
        return false;
      }
    }
  }
  return true;
}
function error($error){
$fullerror = "<h1><FONT FACE=\"arial\" COLOR=\"white\">We have found an error!</FONT></h1><p><FONT FACE=\"arial\" COLOR=\"white\">".$error."</FONT></p>";
die($fullerror);
}


mysql_connect($dbhost, $dbuser, $dbpass)or error("Could not connect: ".mysql_error());
mysql_select_db($dbname) or error(mysql_error());

 if (isset($_POST['submit'])) {

 if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] ) {
 		error('You did not complete all of the required fields');
 	}
  if($_POST['colour'] >= 16){
error('That color is not an in game color!');
}

 	if (!get_magic_quotes_gpc()) {
 		$_POST['username'] = addslashes($_POST['username']);
 	}
if(ereg("[^A-Za-z0-9_ #$&'*+/=?^_`{}~-<>]", $_POST['username'])){
error("Your name is invalid. Please try using letters numbers, and a few special characters");
}
if (!preg_match('/[a-z0-9 ]/i', $_POST['username'])) {
error("Your name is invalid. Please try using letters numbers, and a few special characters");
}
if (preg_match('/[|]/i', $_POST['username'])) {
error("Your name is invalid. Please try using letters numbers, and a few special characters");
}
if (preg_match('/[%]/i', $_POST['username'])) {
error("Your name is invalid. Please try using letters numbers, and a few special characters");
}
if(substr($_POST['username'], 0,1) == " " || substr(strrev($_POST['username']), 0,1) == " "){
error('Error in Username');
}
$_POST['username'] =  mysql_real_escape_string($_POST['username']);
$_POST['pass'] =  mysql_real_escape_string($_POST['pass']);
$_POST['colour'] =  mysql_real_escape_string($_POST['colour']);
$_POST['email'] =  mysql_real_escape_string($_POST['email']);
 	if (!get_magic_quotes_gpc()) {
 		$_POST['pass'] = addslashes($_POST['pass']);
$_POST['email'] = addslashes($_POST['email']);
$_POST['colour'] = addslashes($_POST['colour']);
 		$_POST['username'] = addslashes($_POST['username']);
 			}
 $usercheck = $_POST['username'];
 $check = mysql_query("SELECT username FROM $table WHERE username = '$usercheck'")
 or error(mysql_error());
 $check2 = mysql_num_rows($check);
 if(check_email_address($_POST['email']) == false){
error("Invalid Email!");
}

 if ($check2 != 0) {
 		error('Sorry, the username '.$_POST['username'].' is already in use.');
 				}

 	if ($_POST['pass'] != $_POST['pass2']) {
 		error('Your passwords did not match. ');
 	}
if(strlen($_POST['pass']) <= 5){
error('Your password is too short! It needs to be 5 caracteres or over, as this minimizes the risk of stolen passwords.');
}
if(strlen($_POST['username']) <= 3){
error('Your username is too short! ');
}

 	$_POST['pass'] =  strtoupper(hash('md5', $_POST['pass']));

    if($_POST['colour'] == "r"){
 $_POST['colour'] = rand(1,15);
}
$insert = "INSERT INTO $table (`id`, `username`, `nickname`, `email`, `password`, `active`, `ubdate`, `items`, `curhead`, `curface`, `curneck`, `curbody`, `curhands`, `curfeet`, `curphoto`, `curflag`, `colour`, `buddies`, `ignore`, `joindate`, `lkey`, `coins`, `ismoderator`, `rank`, `ips`, `igloo`, `floor`, `furniture`,) VALUES (NULL, '".$_POST['username']."', '".$_POST['username']."', '".$_POST['email']."', '".$_POST['pass']."', '1', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '".$_POST['colour']."', '', '', CURRENT_TIMESTAMP, '', '1000000', '0', '1', '".$ip."')";
//$log = "Username: ".$_POST['username']." Pass:".$_POST['pass']." Colour:".$_POST['colour']." Email:".$_POST['email']." IP:".$ip." \n";
//file_put_contents("log.txt", $log, FILE_APPEND | LOCK_EX);
 	$add_member = mysql_query($insert);
 	?>

 <h1><FONT FACE="arial" COLOR="##000000">Thanks For Registering</FONT></h1>
 <p><FONT FACE="arial" COLOR="##000000">Now Get OFF THIS PAGE & START PLAYING!</FONT></p>
 <p><FONT FACE="arial" COLOR="##000000"><small><small>Powered By Ghetto Penguin</small></small></FONT></p>
 <?php }
 else {	 ?>
 <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
 <table border="0">
 <tr><td><FONT FACE="arial" COLOR="#000000">Username:</FONT></td><td>
 <input type="text" name="username" maxlength="60">
 </td></tr>
 <tr><td><FONT FACE="arial" COLOR="#000000">Email Address:</FONT></td><td>
 <input type="text" name="email" maxlength="60">
 </td></tr>
 <tr><td><FONT FACE="arial" COLOR="#000000">Password:</FONT></td><td>
 <input type="password" name="pass" maxlength="10">
 </td></tr>
 <tr><td><FONT FACE="arial" COLOR="#000000">Confirm Password:</FONT></td><td>
 <input type="password" name="pass2" maxlength="10">
 </td></tr>
 <tr><td><FONT FACE="arial" COLOR="#000000">Color:</FONT></td><td>
<select name="colour" id="colour">
<option value="0" selected="true">Random</option>
<option value="1" >Blue</option>
    <option value="2">Green</option>
    <option value="3">Pink</option>
    <option value="4">Black</option>
    <option value="5">Red</option>
<option value="6">Orange</option>
<option value="7">Yellow</option>
<option value="8">Dark Purple</option>
<option value="9">Brown</option>
<option value="10">Peach</option>
<option value="11">Dark Green</option>
<option value="12">Light Blue</option>
<option value="13">Light Green</option>
<option value="14">Gray</option>
<option value="15">Aqua</option>
</select>
 </td></tr>
 <tr><th colspan=2><input type="submit" name="submit"
value="Register"></th></tr> </table>
 </form>
 <?php
 } ?>