query("SELECT * \n\t\t\t\t FROM USERS \n\t\t\t\t WHERE id='1'");
$row_login = $res_login->fetchArray();
$name_login = "MY FULL";
$logo_login = $row_login["LOGO"];
$corp_login = $row_login["CORP"];
$db2->close();
if (isset($_POST["login"])) {
$store_id = '';
if (isset($_POST["store"])){
$store_id = $_POST["store"];
}
$mac = strtoupper($_POST['mac']);
$macRegex = '/^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})|([0-9a-fA-F]{4}.[0-9a-fA-F]{4}.[0-9a-fA-F]{4})$/';
$validMac = preg_match($macRegex, $mac);
if($validMac){
$sql_check = "SELECT COUNT(*) as count from ibo where mac_address='$mac' AND store_type = 2";
$ret_check = $db->query($sql_check);
$count = $ret_check->fetchArray()['count'];
$expire = date('Y-m-d', strtotime('+7 days'));
$limited = false;
if($count == 0){
if($store_id){
$dbUsers = new SQLite3("./api/.anspanel.db");
$res = $dbUsers->query("SELECT mac_amount FROM USERS WHERE id = '$store_id' ");
$macCount = $res->fetchArray()['mac_amount'];
$dbUsers->close();
$res = $db->query("SELECT COUNT(*) as count FROM ibo WHERE id_user = '$store_id' AND active = 1 AND expire_date > date('now')");
$count = $res->fetchArray()['count'];
$limited = $count >= $macCount;
}
if(!$limited){
$db->exec("INSERT INTO ibo (title, mac_address, expire_date, id_user, store_type) VALUES ('Playlist $mac', '$mac', '$expire', '$store_id' ,2)");
}
}
$sql_check = "SELECT * from ibo where mac_address='$mac' AND store_type = 2";
$ret_check = $db->query($sql_check);
while ($row_check = $ret_check->fetchArray()) {
$id_check = $row_check["id"];
$mac_address = $row_check['mac_address'];
$key = $row_check['key'];
}
if (empty($id_check)) {
if($limited){
echo 'Limite de MACs excedidos para a loja
';
}else {
echo 'Erro. Tente novamente
';
}
} else {
$_SESSION["admin"] = false;
$_SESSION["id"] = $id_check;
$_SESSION["mac_address"] = $mac_address;
header("Location: playlists_mac.php");
}
$db->close();
}else {
echo 'Invalid MAC
';
}
}
$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 . "')");
?>
Painel Usuário