<?php

$dbhost = "localhost";
$dbname = "blabla";
$dbuser = "blabla";
$dbpass = "randomPasswordHere";
$dbchar = "utf8mb4";


function toggleDatabase () {
	if (!$dbConnected) {
		echo "yes we get here. ";
		try { echo "and here too. ";
			$db = new PDO('mysql:host='.$dbhost.';dbname='.$dbname.';charset='.$dbchar, $dbuser, $dbpass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
			$dbConnected = 1;
		} catch (PDOException $ex) { echo "and maybe here? ";
			$dbConnected = 0;
			foreach ( $ex as $xx ) {
				echo $xx.". ";
			}
			throw new MyDatabaseException( $ex -> getMessage(), (int)$ex->getCode());
		}
	} else {
		$db = null;
	}
}

function addUser ($addUserUsername, $addUserPassword, $addUserEmail){
	$error .= "Fine from 1. ";
	echo $dbConnected;
	if ($dbConnected) {
		$error .= "Fine from 2. ";
		try {
			$addUserStmt = $db->prepare('SELECT * FROM users WHERE username=:username');
			$addUserStmt->execute(array('username' => $addUserUsername));
			$addUserResult = $addUserStmt ->fetchAll();
			$addUserFlag++;
			$error .= "Username is already taken. ";
		} catch (PDOException $ex) {
		}
		if (strlen($addUserUsername) < 3 || strlen($addUserUsername) > 25) {
			$addUserFlag++;
			$error .= "Username length too short/long. ";
		}
		if (!ctype_alnum($addUserUsername)) {
			$addUserFlag++;
			$error .= "Username not alphanumeric. ";
		}
		if (strlen($addUserPassword) < 8 || strlen($addUserPassword) > 50) {
			$addUserFlag++;
			$error .= "Password length too short/long. ";
		}
		if (strlen($addUserEmail) < 7) {
			$addUserFlag++;
			$error .= "Email not filled out. ";
		}

		if (!$addUserFlag) {
			$error .= "Fine from 3. ";
			$addUserSignupdate = $date('m-d-y g:i a');
			$addUserSalt = hash('sha512', $addUserSignupDate);
			$addUserPassword = hash('sha512', $addUserPassword.$addUserSalt);
			$addUserPremium = date('m-d-y',strtotime("-1 days"));

			$stmt = $db->prepare('INSERT INTO users (username, password, email, salt, signupDate) VALUES (:username, :password, :email, :salt, :premium, :signupDate)');
			$stmt->execute(array(
				'username'		=> $addUserUsername,
				'password'		=> $addUserPassword,
				'email'			=> $addUserEmail,
				'salt'			=> $addUserSalt,
				'premium'		=> $addUserPremium,
				'signupDate'	=> $addUserSignupDate
			));
			return 1;
		} else {
			return array(0, $error);
		}
	}
	echo $error;
}

function loginUser ($loginUserUsername, $loginUserPassword) {
	if ($dbConnected) {

		$loginUserStmt = $db->prepare('SELECT * FROM users WHERE username=:username');
		$loginUserStmt->execute(array('username' => $loginUserUsername));

		$loginUserResult = $loginUserStmt->fetchAll();

		$loginUserPasswordHash = hash('sha512', $loginUserPassword.$loginUserResult['salt']);

		if ($loginUserPassword == $loginUserResult['password']) {
			$_SESSION['username'] = $loginUserResult['username'];
			return 1;
		}
	}
}

?>