Untitled

<html>
<?php
	if (!isset($_SESSION)) {
		session_start();
	}
	$database_db = "runescape";
	$user_db = "root";
	$password_db = "caution";
	$host_db = "localhost";


	mysql_connect($host_db, $user_db, $password_db) or die(mysql_error());
	mysql_select_db($database_db) or die(mysql_error());

	if ($_POST['user'] == "") {
		die('You must provide a username. Click<a href = "register.php"> here </a>to go back and try again.');
	}
	if ($_POST['pass'] == "") {
		die('You must provide a password. Click<a href = "register.php"> here </a>to go back and try again.');
	}
	if ($_POST['pass'] != $_POST['passRetype']) {
		die('Your passwords do not match. Click<a href = "register.php"> here </a>to go back and try again.');
	}

	$user=$_POST["user"];
	$pass=$_POST["pass"];
	$passRetype=$_POST["passRetype"];

	$existing_account = mysql_query("SELECT * FROM characters WHERE username = '$user' LIMIT 1");

	if (mysql_num_rows($existing_account) == 1) {
		die('This username has already been taken. Click<a href = "register.php"> here </a>to go back and try again.');
	}

	$account_count = mysql_query("SELECT * FROM characters") or die(mysql_error());

	$newID = 1;

	while ($row = mysql_fetch_array($account_count)) {
		$newID++;
	}

	mysql_query("INSERT INTO characters (ID, username, password, absX, absY, heightLevel, hitpoints, specialAmount, poisonDelay, skullTimer, pkPoints, energy, ancients, playerIsMember, dharokDamage, spellBook, appearanceSet, rights, ip, splitChat, autoRetaliate, combatmode, lastmeleemode, lastrangemode, starter, online, pet, running) VALUES('$newID', '$user', '$pass', '3090', '3490', '0', '10', '100', '-1', '0', '0', '100', '1', '1', '0', '1', '1', '0', '127.0.0.1', '0', '0', '0', '0', '0', '0', '0', '0', '0')") or die(mysql_error());

	echo 'Your account has been added to the database. You may now login.';
?>

</html>