Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Content-type:application/json');
- session_start();
- include("enc.php");
- mysqlcon();
- $email = mysql_real_escape_string(strip_tags($_POST["username"]));
- $password = sha1($_POST["password"]);
- $sql = "SELECT * FROM users WHERE username = '{$email}' AND password = '{$password}'";
- $result = mysql_query($sql); // or exit("ERROR: " . mysql_error() . "<br>IN QUERY: " . $sql);
- if (mysql_num_rows($result) > 0) {
- $row = mysql_fetch_array($result);
- $_SESSION["userid"] = $row['user_pid'];
- $json1 = json_encode(array('session_state' => true));
- echo $json1;
- } else {
- $userid_generator = uniqid(rand(), false);
- mysql_query("INSERT INTO users (user_pid, email, password, datetime_registered, is_leader) VALUES ('$userid_generator', '{$email}', '{$password}', NOW(), 'no')");
- $id = mysql_insert_id();
- $leaders = mysql_query("SELECT * FROM users WHERE is_leader LIKE '%yes%'");
- while($rows = mysql_fetch_array($leaders)) {
- if ($rows['is_leader'] == 'yes') {
- $leader_id = $rows['user_pid'];
- mysql_query("INSERT IGNORE INTO friends (node1id, node2id, friends_since, friend_type)
- VALUES('$leader_id', '$userid_generator', NOW(), 'full')");
- }
- $_SESSION["userid"] = $userid_generator;
- }
- $json2 = json_encode(array('session_state' => false));
- echo $json2;
- }
- ?>
Add Comment
Please, Sign In to add comment