<?php
$mysqlserver = $_POST['mysqlserver'];
$mysqlusername = $_POST['mysqlusername'];
$mysqlpassword = $_POST['mysqlpassword'];
$mysqldatabase = $_POST['mysqldatabase'];

$dbexists = $_POST['dbexists'];

$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];

$submit = $_POST['done'];

if(isset($submit)) {
	$fields = array();
	$fields['mysqlserver'] = $mysqlserver;
	$fields['mysqlusername'] = $mysqlusername;
	// do not check for sql password because some times there is none
	$fields['mysqldatabase'] = $mysqldatabase;
	$fields['name'] = $name;
	$fields['email'] = $email;
	$fields['password'] = $password;

	foreach($fields as $key => $val) {
		if(trim($val) == '') {
			$error = $key . ' is not set!';
			break;
		}
	}

	if($error != '') {
		echo $error;
	} else {
		// create config file
		$filecontent = '<?php
							$mysqlserver = \'' . $mysqlserver .'\'; // Hostname; usually localhost or 127.0.0.1
							$mysqlusername = \'' . $mysqlusername . '\'; // MySQL Username
							$mysqlpassword = \'' . $mysqlpassword . '\'; // Password used to login to MySQL
							$mysqldatabase = \'' . $mysqldatabase . '\'; //Database to hold all information
							mysql_connect($mysqlserver, $mysqlusername, $mysqlpassword);
						?>';
		$handle = fopen('../includes/sqlconnect.php', 'a');
		fwrite($handle, $filecontent);

		// connect to sql
		$connect = mysql_connect($mysqlserver, $mysqlusername, $mysqlpassword);

		if(!$connect)
			die('Cannot connect: ' . mysql_error());
		else {
			if($dbexists != 'on') { // database doesn't already exist
				$create_db_query = 'CREATE DATABASE ' . $mysqldatabase;
				if(mysql_query($create_db_query, $connect)) {
					// database was created;
					echo 'Success!';
				} else // show any errors when creating database
					die('Error creating database: ' . mysql_error());
			} else {
				// begin installation
			}
		}
	}
}
?>