/booka/trunk

<?php

	/*

	firstrun.php

	*/

$username1 = $_POST[userName];

$password1 = $_POST[userPassword];

$password2 = $_POST[userPassword2];

include "./inc/head.php";

if(file_exists("./cfg/lock.lock")){

	?>

		<p class="warning">This instalation locked, you need to remove ./cfg/lock.lock</p>

		<p class="warning">Klick <a href="./BooKa.php"> here </a> to return to the BooKa page.</p>

	<?php

	//header('Location: ./BooKa.php');

} else {

if($debug){

	echo "<p>";

	echo "{$username} <br/>";

	echo "{$password1} <br/>";

	echo "{$password2} <br/>";

	echo "</p>";

}

?>

	<div class="menu2">

		 <h1> Welcome to BooKa </h1>

		 <h2> a Mimimalistic booking software </h2>

		 <hr />

		 <p> here you register the abmin account </p>

		 <form action="firstrun.php" method="post" >

		 	<p>

		 		User name: <input type="text" name="userName" /> <br/>

		 		Password:  <input type="password" name="userPassword" /> <br />

		 		Password again: <input type="password" name="userPassword2" /> <br />

		 		<input type="hidden" name="reg" value="true" /> <br/>

		 		<?php

		 		if($_POST[reg]){

		 			if($username1 == null) echo "you need to add a username <br />";

		 			if($password1 == null) echo "you need a password! <br />";

		 			if($password1 != $password2) echo "Passwords deos not match <br />";

		 		}

		 		?>

		 		<input type="submit" name="submitt" />

		 	</p>

		 </form>

	</div>

<?php

}

if($username1 != null && $password1 != null && $password2 == $password1){

	include "./inc/dbConnect.php";

	$newpassword = md5($password1);

	//create users table

	//user group 1 is admin, 2 is "normal users"

	$db->queryExec("BEGIN;

		CREATE TABLE users(id INTEGER PRIMARY KEY, username CHAR(255), password CHAR(255), 'group' INTEGER);

		INSERT INTO users (username, password, 'group') VALUES('{$username1}' , '{$newpassword}', '1');

		COMMIT;") or die("could not do query");

	echo $db->error;

	//end of user table creation...

	echo "Registration complite";

	//This creates the bookins table

	$db->queryexec("BEGIN;

		CREATE TABLE bookings

		(id INTEGER PRIMARY KEY,

		name CHAR, phone CHAR,

		mail CHAR, adress CHAR,

		StartDate DATE, EndDate DATE);

		COMMIT;") or die("could not create table:");

	echo $db->error;

	//end of table creation...

	fopen("./cfg/lock.lock", 'w') or die("can't open file");

}

include "./inc/foot.php";

?>