<?php


$host = "localhost";
$user2 = "root";
$pass = "";
$db = "accounts";


$cxn = mysql_connect($host,$user2,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());


$query = "SELECT * FROM users";
$result = mysql_query($query,$cxn);


$row = mysql_fetch_object($result) or die (mysql_error());


$query2 = "SELECT ip FROM users WHERE ip='{$_SERVER['REMOTE_ADDR']}'";
$result = mysql_query($query,$cxn);


$row2 = mysql_fetch_object($result) or die (mysql_error());
  
$user = $_POST['user'];
$mail = $_POST['mail'];
$pass = $_POST['pass'];
$repeatpass = $_POST['repeat'];
$submit = $_POST['submit'];
  
  
	if($submit && $user == "") 
	{
		echo "Je moet een gebruikersnaam invullen!";
	}
	if($submit && $pass == "")
	{
		echo "Je moet een wachtwoord invullen!";
	}
	if($submit && $repeat != $pass)
	{
		echo "Je wachtwoord komt niet overheen!";
	}
	if($submit && $mail == "")
	{
		echo "Je moet een e-mail invullen!";
	}
	if($submit && $row->login == $user)
	{
		echo "Deze gebruikersnaam bestaat al!";
	}
	if($submit && $row2 == TRUE)
	{
		echo "Er is al op dit IP geregistreerd!";
	}
	if($submit && $pass == $repeatpass && (strlen($user)> 3) && (strlen($pass)> 3) && $user != $row->user && $row2 != TRUE)
    {
		$ip = $_SERVER['REMOTE_ADDR'];
        echo "<b>Je bent succesvol geregistreerd!</b><br>";


        echo "<a href='login.php'>Klik hier om in te loggen!</a>";
		
		$bank = "10000";
		$cash = "2500";


        $sql = "INSERT INTO users(login,pass,email,ip,cash,bank) VALUES('$user','$pass','$mail','$ip','$cash','$bank')";
 }
  
  
  ?>