<?php
	$ServerName = $ServerUserName = $ServerPassword = "";
	$ServerNameErr = $ServerUserNameErr = $ServerPasswordErr = "";
	$error = 0;
	
	if ($_SERVER['REQUEST_METHOD'] == 'POST') {
		if (empty($_POST["server"])) {
			$ServerNameErr = "DB Address is required";
			$error++;
		}
		else {
			$ServerName = $_POST['server'];
		}
		
		if (empty($_POST['serverUserName'])) {
			$ServerUserNameErr = "UserName is required";
			$error++;
		}
		else {
			$ServerUserName = $_POST['serverUserName'];
		}
		
		if (empty($_POST['serverPassword'])) {
			$ServerPasswordErr = "Password is required";
		}
		else {
			$ServerPassword = $_POST['serverPassword'];
		}
		
		if ($error == 0) {
			Start($ServerName, $ServerUserName, $ServerPassword);
		}
	}
	
	function Start($ServerName, $ServerUserName, $ServerPassword)
	{
		$dbName = "brentswelding";
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword);
		if ($conDataBase->connect_error) {
			die("Connection Failed 1 : " . $conDataBase->connect_error);
		}
		
		/*$sql = "CREATE DATABASE " . $dbName;
		if ($conDataBase->query($sql) === TRUE) {
			echo ("db for users created");
			$conDataBase->close();
		}
		else {
			$conDataBase->close();
			die("Fatal Error 1");
		}*/
		
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
		if ($conDataBase->connect_error) {
			die("Connection Failed 2 : " . $conDataBase->connect_error);
		}
		
		$sql = "CREATE TABLE users (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, password VARCHAR(50) NOT NULL, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50) NOT NULL, phone BIGINT (11) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("users table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 2");
		}
		
		$sql = "CREATE TABLE activitylog (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, status VARCHAR(3) NOT NULL, ipaddress VARCHAR(45) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("activitylog table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 3");
		}
		
		$sql = "CREATE TABLE reviews (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, review VARCHAR(512) NOT NULL, rating VARCHAR(5) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("reviews table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 4");
		}
		
		$sql = "CREATE TABLE stats (id INT (6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, ipaddress VARCHAR(45) NOT NULL, username VARCHAR(30) NOT NULL, page VARCHAR(15) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("stats table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 5");
		}
		$conDataBase->close();
		
		$dbName = "brentsweldingadmin";
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword);
		if ($conDataBase->connect_error) {
			die ("Connection Failed " . $conDataBase->connect_error);
		}
		
		/*$sql = "CREATE DATABASE " . $dbName;
		if ($conDataBase->query($sql) === TRUE) {
			echo ("db for users created");
			$conDataBase->close();
		}
		else {
			$conDataBase->close();
			die("Fatal Error 1");
		}*/
		
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
		if ($conDataBase->connect_error) {
			echo("Connection Failed 3 : " . $conDataBase->connect_error);
		}
		
		$sql = "CREATE TABLE users (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, password VARCHAR(50) NOT NULL, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50) NOT NULL, phone INT (11) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("users table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 6");
		}
		
		$sql = "CREATE TABLE activitylog (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, status VARCHAR(3) NOT NULL, ipaddress VARCHAR(45) NOT NULL, reg_data TIMESTAMP)";
		if ($conDataBase->query($sql) === TRUE) {
			echo ("activitylog table created");
		}
		else {
			$conDataBase->close();
			die("Fatal Error 7");
		}
		$conDataBase->close();
		echo ("<script>alert('done');</script>");
		return;
	}
?>
<!DOCTYPE html>
<html>
	<head>
    	<title>Brents Welding DB Creator</title>
    </head>
    <body>
    	<form method="post" action="<?php htmlspecialchars($_SERVER['PHP_SELF']);?>">
        	<p>
            	<label>DB Address</label>
                <input type="text" name="server" value="<?php echo $ServerName;?>">
                <span class="error">* <?php echo $ServerNameErr;?></span>
            </p>
            <p>
            	<label>DB UserName</label>
                <input type="text" name="serverUserName" value="<?php echo $ServerUserName;?>">
                <span class="error">* <?php echo $ServerUserNameErr;?></span>
            </p>
            <p>
            	<label>DB Password</label>
                <input type="text" name="serverPassword">
                <span class="error">* <?php echo $ServerPasswordErr;?></span>
            </p>
            <input type="submit" name="submit" value="Submit">
        </form>
    </body>
</html>