Changed database schema again.

1 files changed, 8 insertions, 10 deletions

diff --git a/www/register.php b/www/register.php
index 87c2e90..c9de638 100644
--- a/www/register.php
+++ b/www/register.php
@@ -44,6 +44,9 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') {
 		exit;
 	} else {
 
+		$id_db = $db->query("SELECT id FROM user WHERE email='$safe_email';");
+		$id_ar = $id_db->fetchArray(SQLITE3_NUM);
+		$id = $id_ar[0];
 
 /*Generates the encrypted password and the database transactions*/
 
@@ -55,18 +58,13 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') {
 
 	        if($db->exec("
 			BEGIN TRANSACTION;
-			UPDATE user SET name='$safe_name', salt='$salt', password='$hash_password', status=1, invites=5 WHERE email='$safe_email';
-			CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT);
-			INSERT INTO $safe_name (id, folder, name, type, public) VALUES (NULL, 0, '/', 'FOLDER', 'HIDDEN');
+			UPDATE user SET name='$safe_name', salt='$salt', password='$hash_password', invites=5, status=1, register=(SELECT datetime()) WHERE id=$id;
+			INSERT INTO files (id, parent, owner, name, folder, mime, size, share, extra) VALUES (NULL, 0, $id, '/', 'DIRECTORY', NULL, NULL, 'PUBLIC', NULL);
 			COMMIT;")
 		){
-			if(mkdir("/var/www/files/files/$name")){
-				$_SESSION["login"] = true;
-				$_SESSION["username"] = $name;
-				header("Refresh: 0; /register?reason=registration");
-			} else {
-				header("Refresh: 0; /register?reason=mkdir");
-			 }
+			$_SESSION["login"] = true;
+			$_SESSION["username"] = $name;
+			header("Refresh: 0; /register?reason=registration");
 		} else {
 			header("Refresh: 0; /register?reason=database");
 		}