prepare(" SELECT uid FROM player WHERE upper(name) = upper(:name) AND password = :password; "); $statement->bindValue(":name", $uname, SQLITE3_TEXT); $statement->bindValue(":password", $password, SQLITE3_TEXT); $statement->execute(); $r = $statement->execute()->fetchArray(SQLITE3_ASSOC); if (!$r){ error_log("REDIRECT TO:" . URL::BASE); header("Location: " . URL::BASE); exit(); die(); return 401; } $uid = $r["uid"]; setcookie("uid", $uid, time() + 5 * 24 * 60 * 60); // 5 Days session_regenerate_id(); $_SESSION['session'] = true; $_SESSION['name'] = $uname; $_SESSION['uid'] = $uid; header("Location: " . URL::BASE . "/$uid/"); exit(); die(); return 0; } ?>