public function loadSession($username, $password)
{
$verify = Database::execQuery("SELECT EXISTS(SELECT id FROM users WHERE username = '******' and pass = md5('{$password}')) as 'asshole'")[0][0];
if ($verify) {
// jika sudah benar
error_log($verify);
session_start();
// maka simpan data ID ke dalam session
$_SESSION['userID'] = Database::execQuery("SELECT id from users where username = '******' and pass = md5('{$password}') and role != 5")[0]['id'];
header("Location: " . \Turner\System\App::$information['serverAddr'] . "/index");
// dan arahkan ke halaman indeks
} else {
$wrongData = true;
// jika tidak, tampilkan halaman login kembali dengan error salah data
include "magician/login.php";
exit;
// keluar
return 0;
}
}
public static function deleteFunction($slug)
{
$conn = new Database();
$conn->connect();
$conn->beginTransaction();
$conn->query("DELETE FROM post WHERE slug = '" . htmlspecialchars($slug, ENT_QUOTES) . "'");
if (is_bool($conn)) {
$conn->rollBack();
} else {
$conn->commit();
header("Location: " . \Turner\System\App::$information['serverAddr'] . "/post");
}
}
