diff options
| -rw-r--r-- | www/invite.php | 8 | ||||
| -rw-r--r-- | www/register.php | 9 | ||||
| -rw-r--r-- | www/setup.php (renamed from www/check.php) | 0 |
3 files changed, 13 insertions, 4 deletions
diff --git a/www/invite.php b/www/invite.php index 4a055e3..f77e6f6 100644 --- a/www/invite.php +++ b/www/invite.php @@ -41,8 +41,12 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') { // $db->exec("INSERT INT0 user (id, name, senpai, key, status, email) VALUES (NULL, '$id', '$key', 0, '$safe_email');"); // $db->exec("UPDATE user SET invites='$invite' WHERE id='$id';"); - if($db->exec("INSERT INTO user (id, name, senpai, key, status, email) VALUES (NULL, NULL, '$id', '$key', 0, '$safe_email');") && $db->exec("UPDATE user SET invites='$invite' WHERE id='$id';")) - { + if($db->exec(" + BEGIN TRANSACTION; + INSERT INTO user (id, name, senpai, key, status, email) VALUES (NULL, NULL, '$id', '$key', 0, '$safe_email'); + UPDATE user SET invites='$invite' WHERE id='$id'; + COMMIT; + ")){ header("Refresh: 0; /invite?reason=success"); } else { header("Refresh: 0; /invite?reason=database"); 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"); diff --git a/www/check.php b/www/setup.php index 2ff5f52..2ff5f52 100644 --- a/www/check.php +++ b/www/setup.php |