accountcreation.php

<?php

$serverconfigs = parse_ini_file("config.ini",false);
$servername = $serverconfigs['servername'];
$db_username = $serverconfigs['username'];
$db_password = $serverconfigs['password'];
$db_name = $serverconfigs['databasename'];
$betakeyneeded = $serverconfigs['isbetakeyneeded'];

global $servername;
global $db_username;
global $db_password;
global $db_name;
global $betakeyneeded;

if (array_key_exists("username", $_POST) && array_key_exists("password", $_POST) && array_key_exists("betakey",$_POST)) {
	createAccount($_POST["username"], ($_POST["password"]),$_POST["betakey"]);
}

function createAccount($username,$password,$betakey){
	
	$up_betakey = strtoupper($betakey);
	$up_username = strtoupper($username);
	$up_password = strtoupper($password);
	$isBetaKeyused = checkbetakey($up_betakey);
	

	if($GLOBALS['betakeyneeded'] == 1){
		if($up_betakey == ""){
			echo "Without BetaKey no Accountcreation!";
		return;
		}
	
		if($isBetaKeyused == "1"){
			echo "BetaKey is used";
			return;
		}
	
		if($isBetaKeyused == "-1"){
			echo "BetaKey not found!";
			return;
		}
	}
	
	
	$accountExist = checkifAccountexist($up_username);
	if($accountExist == "1"){
		echo "Account already exists";
		return;
	}
	
	// Create connection
	$conn = new mysqli($GLOBALS["servername"], $GLOBALS['db_username'], $GLOBALS['db_password'], $GLOBALS['db_name']);
	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
		echo "Connection failed";
	}
	
	$passwordbuilder = $up_username .":".$up_password;
	$hashed_pw = sha1($passwordbuilder);
	
	//echo $hashed_pw;
	$final_pw = strtoupper ($hashed_pw);

	// prepare and bind
	$stmt = $conn->prepare("INSERT INTO account (username, sha_pass_hash) VALUES (?,?)");
	$stmt->bind_param("ss",$user_name, $user_password);

	// set parameters and execute
	$user_name = $up_username;
	$user_password = $final_pw;
	$stmt->execute();

	betaKeyUsed($up_betakey);

	$stmt->close();
	$conn->close();
	echo "Accountcreation successfull!";
	return;
}

function betaKeyUsed($betakey){
	
	$up_betakey = strtoupper($betakey);
	$conn = new mysqli($GLOBALS["servername"], $GLOBALS['db_username'], $GLOBALS['db_password'], $GLOBALS['db_name']);
	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
		echo "Connection failed";
	}
	

	$stmt = $conn->prepare("Update betakey set `active` = 1 where `betakeynr` = ?");
	$stmt->bind_param("s",$db_betakeynr);

	// set parameters and execute
	$db_betakeynr = $up_betakey;
	$stmt->execute();


	$stmt->close();
	$conn->close();
}

function checkifAccountexist($username){
	
	$conn = new mysqli($GLOBALS["servername"], $GLOBALS['db_username'], $GLOBALS['db_password'], $GLOBALS['db_name']);
	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}
	
	$sql = "SELECT id, username FROM account";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
		if($row["username"] == $username){
			return "1";
		}
		
	
      
    }
	return "0";
	
	$conn->close();
	
	}
}

function checkbetakey($betakey){
	$up_betakey = strtoupper($betakey);
	
	$server = $GLOBALS['servername'];
	$dbuser = $GLOBALS['db_username'];
	$dbpass = $GLOBALS['db_password'];
	$dbschema = $GLOBALS['db_name'];
	

	$conn = new mysqli($server, $dbuser,$dbpass, $dbschema);
	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}

	$sql = "SELECT id, betakeynr, active FROM betakey";
	$result = $conn->query($sql);

	if ($result->num_rows > 0) {
    // output data of each row
		while($row = $result->fetch_assoc()) {		
			if(strtoupper($row["betakeynr"]) == $up_betakey){
				//echo strtoupper($row["betakeynr"]);
				$conn->close();
				return $row["active"];
			}
			
		}
	} else {
		$conn->close();
		return "-1";
	
	}	
	$conn->close();
}

?>