diff options
author | Alex Auvolat <alex@adnab.me> | 2017-01-18 19:12:01 +0100 |
---|---|---|
committer | Alex Auvolat <alex@adnab.me> | 2017-01-18 19:12:01 +0100 |
commit | cb727d392892ba2b6199a918f320dc6423d74d4c (patch) | |
tree | 8f451bfa89c1d85c404e2f16be37705c89eb2fb6 /lib/login.php | |
parent | 77048675abf5fad43e8b5371c35e1c86b3be59c2 (diff) | |
download | Bits-cb727d392892ba2b6199a918f320dc6423d74d4c.tar.gz Bits-cb727d392892ba2b6199a918f320dc6423d74d4c.zip |
Start update to PDO instead of old mysql_ functions
Diffstat (limited to 'lib/login.php')
-rw-r--r-- | lib/login.php | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/lib/login.php b/lib/login.php index 2ba954e..a58ee75 100644 --- a/lib/login.php +++ b/lib/login.php @@ -2,7 +2,7 @@ require("conf/login.php"); -session_start($session_name); +session_start(); $priv = array(0 => "Anonymous", 1 => "Member", 2 => "Administrator"); $user = array('id' => 0, 'name' => 'Anonymous', 'priv' => 0); @@ -15,9 +15,9 @@ if (isset($_GET['logout'])) { } if (isset($_POST['login']) && isset($_POST['pw'])) { - $sql = sql("SELECT id FROM account ". - "WHERE login = '" . esc($_POST['login']) . "' AND password = PASSWORD('" . esc($_POST['pw']) . "')"); - if ($util = mysql_fetch_assoc($sql)) { + $sql = sql("SELECT id FROM account WHERE login = ? AND password = PASSWORD(?)", + esc($_POST['login']), esc($_POST['pw'])); + if ($util = $sql->fetch()) { $_SESSION['user_id'] = intval($util['id']); } else { $error = "Wrong username or password."; @@ -31,9 +31,9 @@ if (isset($_SESSION['user_id'])) { $user = $_SESSION['user']; } else { $sql = sql("SELECT login AS name, id, priv ". - "FROM account ". - "WHERE id = " . $_SESSION['user_id']); - if ($util = mysql_fetch_assoc($sql)) { + "FROM account WHERE id = ?", + $_SESSION['user_id']); + if ($util = $sql->fetch()) { $user['id'] = $_SESSION['user_id']; $user['name'] = $util['name']; $user['priv'] = $util['priv']; |