diff options
| author | root | 2014-02-17 20:25:04 +0100 |
|---|---|---|
| committer | root | 2014-02-17 20:25:04 +0100 |
| commit | 90719f4deb17c8d89d74a7b9872764c1df081f6d (patch) | |
| tree | 1bde8e81ff78ff5a17327684e5196a3c704e467a | |
| parent | 922521df8ac69fcf24faf799669cbc9ca9da7892 (diff) | |
| download | files.iamfabulous.de-90719f4deb17c8d89d74a7b9872764c1df081f6d.tar.gz | |
fixed database setup
| -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 |