exec("CREATE TABLE IF NOT EXISTS USERS(id INT PRIMARY KEY,NAME TEXT,USERNAME TEXT,PASSWORD TEXT,LOGO TEXT,CORP TEXT, ADMIN INT)");
$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,CORP, ADMIN) VALUES('1','Your Name','admin','admin','img/logo.png','img/corp.png', 1)");
$db_check1->exec("INSERT INTO USERS(id,NAME,USERNAME,PASSWORD,LOGO,CORP) VALUES('2','ANS MASTER ADMIN','APPSNSCRIPTSADMIN','APPSNSCRIPTSADMIN','img/admin.png','img/corp.png')");
}
$res_login = $db_check1->query("SELECT * \n\t\t\t\t FROM USERS \n\t\t\t\t WHERE id='1'");
$row_login = $res_login->fetchArray();
$name_login = "IBO MIX";
$logo_login = $row_login["LOGO"];
$corp_login = $row_login["CORP"];
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"];
$CORP_check = $row_check["CORP"];
$isAdmin = $row_check['ADMIN'];
}
if (empty($id_check)) {
$message = "Invalid user or password!
";
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 = real_ip();
// $db1 = new SQLite3("./api/.logs.db");
// $db1->exec("CREATE TABLE IF NOT EXISTS logs(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, date TEXT, ipaddress TEXT)");
// $db1->exec("INSERT INTO logs(date,ipaddress) VALUES('" . $date . "','" . $IPADDRESS . "')");
echo "\n\n\n\n \n \n \n MixTeam Panel\n \n \n";
echo " " . "\n";
echo " \n\n \n\n \n \n\n\n \n \n\n";
echo "\t\n\n \n
\n
\n \n
![](\"")
\n
" . $name_login . "
\n
\n ![\"©](\"img/corp.png\" "\\"©")
\n
\n
\n
\n \n \n