<?php
ob_start();

session_start();

include('connection.php');

if(isset($_SESSION['logged'])) die(header("location: index.php"));

if(isset($_POST['submitted']) && $_POST['submitted'])
{
	$con = @mysql_connect($MySQLhost, $MySQLuser, $MySQLpass) or die('MySQL error, retry! 1');
	$db = @mysql_select_db($MySQLdata, $con) or die('MySQL error, retry! 2');

	if(isset($_POST['username']) && $_POST['username'] && isset($_POST['password']) && $_POST['password'])
	{

		$username = $_POST['username'];
		$password = md5(mysql_real_escape_string($_POST['password']));
		$email = $_POST['email'];
		$gamename = $_POST['gamename'];


		$query = "SELECT * FROM `users` WHERE `username`='" . mysql_real_escape_string($username) ."'";
		$result = @mysql_query($query) or die('MySQL! Error 4...');

		if(mysql_num_rows($result)) die("That name is already in use! <a href='register.php'>Go Back</a>");

		$query = "SELECT * FROM `users` ORDER BY `id` DESC LIMIT 1";
		$result = @mysql_query($query) or die('MySQL error, retry! 5');

		if(mysql_num_rows($result)) $row = @mysql_fetch_assoc($result) or die('MySQL error, retry 6');

		if(isset($row)) $nextID = $row['id'] + 1;
		else $nextID = 1;

		$query = "INSERT INTO `users` VALUES ('" . $nextID . "', '" . mysql_real_escape_string($username) . "', '" . $password . "', '0', '" . $email . "', '" . $gamename . "', '0', '0', '0', '0', '0')";
		$result = @mysql_query($query) or die('MySQL error, retry! 7');

		if($con) @mysql_close($con) or die('MySQL error, retry! 8');

		header("location: Account.php");
	}
	else
	{
		die('Invalid input - retry!');
	}
}