exec("CREATE TABLE IF NOT EXISTS ibo(id INTEGER PRIMARY KEY NOT NULL,\r\nmac_address VARCHAR(100),\r\nkey VARCHAR(100),\r\nusername VARCHAR(100),\r\npassword VARCHAR(100),\r\nexpire_date VARCHAR(100),\r\ndns VARCHAR(100),\r\nepg_url VARCHAR(100),\r\ntitle VARCHAR(100),\r\nurl VARCHAR(100),\r\ntype VARCHAR(100))"); $res = $db->query("SELECT * FROM ibo"); if (isset($_POST["submit"])) { $line = $_POST["url"]; $playlistpassword = ""; if(isset($_POST["playlistpassword"])){ $playlistpassword = $_POST["playlistpassword"]; } $res = $db->query("SELECT id_user FROM ibo WHERE mac_address = '$mac_address' AND store_type = 2"); $store_id = $res->fetchArray()['id_user']; $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']; if ($count >= $macCount) { $limited = true; } if(!$limited){ $db->exec("INSERT INTO ibo(mac_address, expire_date, epg_url, title, url, type, id_user, store_type, playlistpassword) VALUES('$mac_address', '$expire', '" . $_POST["epg_url"] . "', '" . $_POST["title"] . "', '$line', '$type', '$store_id', 2, '$playlistpassword')"); if (!isset($_SESSION['macs'])){ $_SESSION['macs'] = []; } $macRes = $db->query("SELECT * FROM ibo WHERE mac_address = '$address1'"); while($row = $macRes->fetchArray()){ if(!sessionContains($row)){ array_push($_SESSION['macs'], $row); } } header("Location: playlists_mac.php"); } $db->close(); } function sessionContains($searchRow){ foreach ($_SESSION['macs'] as $session_row){ if($session_row['id'] == $searchRow['id']){ return true; } } return false; } include "includes/header_playlist.php"; if($limited){ echo "
Limite de MACs excedido!
"; } echo "
\n\n \n

Activate Playlist

\n\n \n
\n
\n
User Details
\n
\n
\n
\n
\n \n
\n
$mac_address
\n
\n"; echo "
\n \n
\n"; echo " " . "\n"; echo "
\n
\n \r\n
\n
\n \n
\n \n
\n
\n
\n
\n \n
\n \n
\n
\n
\n
\n \n
\n\n
\n
\n
"; echo "
\n
"; echo "\n
\n\n
\n
\n
\n
\n
\n


\n"; include "includes/footer.php"; echo "\n\n\n"; ?>