From 90719f4deb17c8d89d74a7b9872764c1df081f6d Mon Sep 17 00:00:00 2001 From: root Date: Mon, 17 Feb 2014 20:25:04 +0100 Subject: fixed database setup --- www/register.php | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'www/register.php') diff --git a/www/register.php b/www/register.php index 53fb35c..69362ec 100644 --- a/www/register.php +++ b/www/register.php @@ -53,8 +53,13 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') { for($i=0;$i<15000;$i++) $hash_password = md5($hash_password); - if($db->exec("UPDATE user SET name='$safe_name', salt='$salt', password='$hash_password', status=1, invites=5 WHERE email='$safe_email';") && $db->exec("CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, typ TEXT, public TEXT);") && $db->exec("INSERT INTO $safe_name (id, folder, name, typ, public) VALUES (NULL, 0, '/', 'FOLDER', 'HIDDEN');") - ){ + 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, typ TEXT, public TEXT); + INSERT INTO $safe_name (id, folder, name, typ, public) VALUES (NULL, 0, '/', 'FOLDER', 'HIDDEN'); + COMMIT; + ")){ $_SESSION["login"] = true; $_SESSION["username"] = $name; header("Refresh: 0; /?reason=registration"); -- cgit v1.2.3