about summary refs log tree commit diff stats
path: root/login.php
diff options
context:
space:
mode:
authorAndrew Dolgov <noreply@fakecake.org>2017-11-19 13:03:36 +0300
committerAndrew Dolgov <noreply@fakecake.org>2017-11-19 13:03:36 +0300
commitdfee22901d7c5defc61ef16e831d7c4a8f05ffd1 (patch)
tree19c70fcf048284decccfa9388e374047b04b14d4 /login.php
parent41e97ceb2c0e7b36ebb273707f12d2d940c87085 (diff)
downloadthe-epube-dfee22901d7c5defc61ef16e831d7c4a8f05ffd1.tar.gz
the-epube-dfee22901d7c5defc61ef16e831d7c4a8f05ffd1.tar.xz
* use PDO::sqlite
* remove database-backed sessions (too slow for sqlite)
Diffstat (limited to 'login.php')
-rw-r--r--login.php9
1 files changed, 5 insertions, 4 deletions
diff --git a/login.php b/login.php
index 6aa258a..9deae75 100644
--- a/login.php
+++ b/login.php
@@ -4,16 +4,17 @@
 	@$op = $_REQUEST["op"];
 
 	if ($op == "perform-login") {
-		$user = SQLite3::escapeString(trim(mb_strtolower($_REQUEST["user"])));
-		$password = SQLite3::escapeString('SHA256:' . hash('sha256', "$user:" . trim($_REQUEST["password"])));
+		$user = trim(mb_strtolower($_REQUEST["user"]));
+		$password = 'SHA256:' . hash('sha256', "$user:" . trim($_REQUEST["password"]));
 
 		require_once "db.php";
 
 		$dbh = Db::get();
 
-		$res = $dbh->query("SELECT id FROM epube_users WHERE user = '$user' AND pass = '$password'");
+		$sth = $dbh->prepare("SELECT id FROM epube_users WHERE user = ? AND pass = ?");
+		$sth->execute([$user, $password]);
 
-		if ($line = $res->fetchArray(SQLITE3_ASSOC)) {
+		if ($line = $sth->fetch()) {
 			require_once "sessions.php";
 
 			$_SESSION["owner"] = $user;