Advertisement
Guest User

Untitled

a guest
Jul 10th, 2014
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.67 KB | None | 0 0
  1. if(isset($_POST["login"]) || isset($_SESSION["username"]) && isset($_SESSION["password"]))
  2. {
  3.     $username=isset($_POST['username']) ? $_POST['username'] : $_SESSION["username"];
  4.     $password=isset($_POST['password']) ? $_POST['password'] : $_SESSION["password"];
  5.     if(empty($username)) $err[].="Username is empty";
  6.     if(empty($password)) $err[].="Password is empty";
  7.     if(!ctype_alnum($username.$password)) $err[].="Username and Password must contain only alphanumeric symbols!";
  8.     if(!$err)
  9.     {
  10.         $sql = isset($_POST["login"])
  11.              ? mysqli_prepare($con, "SELECT u_id FROM accounts WHERE u_username=? AND u_password=? LIMIT 1")
  12.              : mysqli_prepare($con, "SELECT t_userid,t_ip FROM mem_login WHERE t_username=? AND t_password=? LIMIT 1");
  13.         mysqli_stmt_bind_param($sql, "ss", $username, $password);
  14.         mysqli_stmt_execute($sql);
  15.         isset($_POST['login']) ? mysqli_stmt_bind_result($sql, $id) : mysqli_stmt_bind_result($sql, $id, $ip);
  16.         mysqli_stmt_fetch($sql);
  17.         mysqli_stmt_close($sql);
  18.         if($id!=0 && isset($ip) ? $ip==$_SERVER['REMOTE_ADDR'] : TRUE)
  19.         {
  20.             define("LOGGED", TRUE, FALSE);
  21.             $user["t_userid"]=$id;
  22.             if(isset($_POST["login"]))
  23.             {
  24.                 mysqli_query($con,"DELETE FROM mem_login WHERE t_userid=$id");
  25.                 $_SESSION["username"]=$username;
  26.                 $_SESSION["password"]=$password;
  27.                 $sql = mysqli_prepare($con, "INSERT INTO mem_login (t_userid,t_ip,t_username,t_password) VALUES (?,?,?,?)");
  28.                 mysqli_stmt_bind_param($sql, "isss", $id, $_SERVER['REMOTE_ADDR'], $username, $password);
  29.                 mysqli_stmt_execute($sql);
  30.                 mysqli_stmt_close($sql);
  31.             }
  32.         } else define("LOGGED", FALSE, FALSE);
  33.     } else define("LOGGED", FALSE, FALSE);
  34. } else define("LOGGED", FALSE, FALSE);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement