<?PHP
error_reporting(E_ALL);
session_start();


include("includes/_mysql_connection.php");


$limiet         = 25000;
$limiet_online  = 1500;
$ledennu        = mysql_query("SELECT `id` FROM `users`");
$ledennu        = mysql_num_rows($ledennu);
$ledenonline    = mysql_query("SELECT `id` FROM `users` WHERE `lastclick`>".(time() - 900)) or die(mysql_error());
$ledenonline    = mysql_num_rows($ledenonline);
$landenQ        = mysql_query("SELECT * FROM `landen`");


while($res = mysql_fetch_assoc($landenQ))
{
	$landen[$res['id']] = $res['land'];
}


include("./includes/_functions.php");


$regged     = false;
$username   = "";
$email      = "";


if(isset($_POST['submit_register']))
{
	$username      = trim($_POST['username']);
	$email         = trim($_POST['mailadres']);
	$email         = trim($_POST['email_check']);
	$pass          = $_POST['password'];
	$pass_check    = $_POST['password_check'];
	$code          = $_POST['code'];
	$land          = $_POST['land'];


	if(!is_name($username))
    {
		$error = "Je hebt een ongeldige gebruikersnaam ingevoerd!";
	}
	if(!is_email($email))
    {
		$error = "Je hebt een ongelige e-mail ingevoerd!";
	}
	if(strlen($pass) < 5)
    {
		$error = "Je wachtwoord moet minimaal 5 tekens zijn!";
	}
	if($pass != $pass_check)
    {
		$error = "De opgegeven wachtwoorden zijn ongelijk!";
	}


	if($mailadres != $email_check)
    {
		$error = "De opgegeven e-mails zijn ongelijk!";
	}


	$host = gethostbyaddr($_SERVER['REMOTE_ADDR']);


//	if(!ereg("nl$", $host) && !ereg("be$", $host) && !ereg("arpa$", $host) && $_SERVER['REMOTE_ADDR'] != "127.0.0.1")
//    {
//		$error = "IP's buiten Nederland en Belgi&euml; zijn geblockt!";
//	}
	if($_SESSION['code_captcha'] != $code)
    {
		$error = "De code was niet gelijk aan het plaatje!";
	}
	if(!array_key_exists($land, $landen))
    {
		$error = "Het land dat je hebt opgegeven bestaat niet!";
	}


	$nameSet = mysql_query("SELECT `id` FROM `users` WHERE `username`='".mr($username)."' LIMIT 1") or die(mysql_error());
	$emailSet = mysql_query("SELECT `id` FROM `users` WHERE `email`='".$email."' LIMIT 1") or die(mysql_error());


	if(mysql_num_rows($nameSet) == 1)
    {
		$error = "Er is al iemand met deze gebruikersnaam!";
	}
	if(mysql_num_rows($emailSet) == 1)
    {
		$error = "Er is al iemand met dit e-mailadres!";
	}
	if($ledennu >= $limiet)
    {
		$error = "Het ledenlimiet is bereikt! Probeer het later weer.";
	}


	$isRg      = mysql_query("SELECT `id` FROM `users` WHERE `ip`='".$_SERVER['REMOTE_ADDR']."' LIMIT 1") or die(mysql_error());
	$isRegged  = mysql_num_rows($isRg);


	if(($isRegged >= 1 || ( isset($_COOKIE['regged']) && $_COOKIE['regged'] == "yes" )) && $_SERVER['REMOTE_ADDR'] != '91.182.143.109')
    {
		$error = "Er is al geregistreerd vanaf deze computer!";
	}


	if(!isset($error))
    {
		if(isset($_POST['rec']) && ctype_digit($_POST['rec']))
        {
			mysql_query("UPDATE `status` SET `refs`=`refs`+1 WHERE `id`=".$_POST['rec']) or die(mysql_error());
			mysql_query("UPDATE `count_missions_hour` SET `m_9`=`m_9`+1 WHERE `id`=".$_POST['rec']) or die(mysql_error());
			mysql_query("UPDATE `speldata` SET `bankmoney`=`bankmoney`+15000 WHERE `id`=".$_POST['rec']) or die(mysql_error());
		}
		
		 $sql = mysql_query("INSERT INTO `users`(`username`, `email`,`ip`, `registerDate`, `sha512`) VALUES ('".$username."', '".$email."', '".$_SERVER['REMOTE_ADDR']."', NOW(), '".hash("sha512", $pass)."')") or die(mysql_error());


		 $_SESSION['__id'] = mysql_insert_id();


		 $tabellen = array(
		 "status" => "id",
		 "userstats" => "id",
		 "usertimes" => "id",
		 "profiel" => "id",
		 "uitrust" => "id",
		 "count_missions_all" => "id",
		 "count_missions_hour" => "id",
		 "count_missions" => "id"
		 );
		 
		 foreach($tabellen AS $tabel => $id)
         {
          mysql_query("INSERT INTO `".$tabel."`(`".$id."`) VALUES (".$_SESSION['__id'].")") or die(mysql_error());
		 }
		  mysql_query("INSERT INTO `speldata`(`id`, `land_id`) VALUES (".$_SESSION['__id'].", ".$_POST['land'].")") or die(mysql_error());


		 setcookie("regged", "yes", (time() + (60*60*24*365)) );


		 $regged = true;