exec("CREATE TABLE IF NOT EXISTS USERS(id INT PRIMARY KEY, NAME TEXT, USERNAME TEXT, PASSWORD TEXT, LOGO TEXT, BACKGROUND TEXT)");
$rows = $db_check1->query("SELECT COUNT(*) as count FROM USERS");
$row = $rows->fetchArray();
$numRows = $row["count"];
if ($numRows == 0) {
$db_check1->exec("INSERT INTO USERS(id, NAME, USERNAME, PASSWORD, LOGO, BACKGROUND) VALUES('1','Seu Nome','admin','admin','$logoPath','$backgroundPath')");
}
$res_login = $db_check1->query("SELECT * FROM USERS WHERE id='1'");
$row_login = $res_login->fetchArray();
$name_login = $row_login["NAME"];
$logo_login = $row_login["LOGO"];
$background_login = $row_login["BACKGROUND"];
if (isset($_POST["login"])) {
if (!$db_check1) {
echo $db_check1->lastErrorMsg();
}
$sql_check = "SELECT * FROM USERS WHERE USERNAME='" . $_POST["username"] . "' AND PASSWORD='" . $_POST["password"] . "'";
$ret_check = $db_check1->query($sql_check);
while ($row_check = $ret_check->fetchArray()) {
$id_check = $row_check["id"];
$store_type = $row_check["store_type"];
$NAME = $row_check["NAME"];
$LOGO_check = $row_check["LOGO"];
$BACKGROUND_check = $row_check["BACKGROUND"];
$isAdmin = $row_check['ADMIN'];
}
if (empty($id_check)) {
$message = "Usuário ou senha inválidos!
";
echo $message;
} else {
$_SESSION["admin"] = $isAdmin;
$_SESSION["N"] = $id_check;
$_SESSION["id"] = $id_check;
$_SESSION["store_type"] = $store_type;
$path = "users";
if ($store_type == '2') {
$path .= '_mac';
}
header("Location: $path.php");
}
$db_check1->close();
}
$date = date("d-m-Y H:i:s");
$IPADDRESS = getIPAddress();
?>
GflixApps - GPLAYER MAX