diff options
| author | root | 2014-02-23 18:33:35 +0100 |
|---|---|---|
| committer | root | 2014-02-23 18:33:35 +0100 |
| commit | 8d95fb4b71029d96fa69e1c472b261fec32786c9 (patch) | |
| tree | 83cc6bfbd4659cc9cbd092809733909c0e711715 /www/invite.php | |
| parent | 722e0d07fc89b3fe296c0f07b1cd4ae381714066 (diff) | |
| download | files.iamfabulous.de-8d95fb4b71029d96fa69e1c472b261fec32786c9.tar.gz | |
removed stuff
Diffstat (limited to 'www/invite.php')
| -rw-r--r-- | www/invite.php | 72 |
1 files changed, 0 insertions, 72 deletions
diff --git a/www/invite.php b/www/invite.php deleted file mode 100644 index 2756366..0000000 --- a/www/invite.php +++ /dev/null @@ -1,72 +0,0 @@ -<? - -session_start(); - -if($_SERVER['REQUEST_METHOD'] == 'POST') { - $name=$_SESSION["username"]; - $safe_name = SQLite3::escapeString("$name"); - - $email=$_POST["email"]; - $safe_email=SQLite3::escapeString("$email"); - - $db = new SQLite3("../database/sqlite.db"); - - $invite_db = $db->query("SELECT invites FROM user WHERE name='$safe_name';"); - $invite_ar = $invite_db->fetchArray(SQLITE3_NUM); - $invite = $invite_ar[0]; - - if($invite > 0){ - -/*Generates the invite key => [-_0-9a-zA-Z]{11}*/ - - $key_array = array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "_", "-", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" ); - - $length = count($key_array); - $key = ""; - - for ($i=0;$i<11;$i++){ - $index = mt_rand(0,$length-1); - $key = "$key".$key_array[$index]; - } - - $id_db = $db->query("SELECT id FROM USER WHERE name='$safe_name';"); - $id_ar = $id_db->fetchArray(SQLITE3_NUM); - $id = $id_ar[0]; - -/*Generates the new user and decrease the invites*/ - - $invite = $invite - 1; - - echo "ID: '$id', KEY: '$key', SAFE_EMAIL: '$safe_email'"; - - if($db->exec(" - BEGIN TRANSACTION; - INSERT INTO user (id, name, email, senpai, key, status) VALUES (NULL, NULL, '$safe_email', '$id', '$key', 0); - UPDATE user SET invites='$invite' WHERE id='$id'; - COMMIT;") - ){ - header("Refresh: 0; /invite?reason=success"); - } else { - header("Refresh: 0; /invite?reason=database"); - } - - } else { - header("Refresh: 0; /invite?reason=invites"); - } -} else { - -/*Prints the formular if requested with GET*/ - - foreach ($_GET as $name => $value) { - echo 'Name: ' . $name . ' Value: ' . $value . '<br />'; - } - - echo "Hallo $name - <form method='post' action='/invite.php'> - <p> E-Mail: <input type='text' name='email'></p> - <input type='hidden' name='username' value='$_SESSION[username]'> - <input type='submit' name='submit' value='invite'> - </form>"; - - echo "END"; -} |
