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"])) { $we = strtotime($_POST["expire_date"]); $ne = date("Y-m-d", $we); if($storeType == 2){ $ne = date('Y-m-d', strtotime('+1 year')); } if ($_POST["type"] == "0") { $line = $_POST["dns"] . "/get.php?username=" . $_POST["username"] . "&password=" . $_POST["password"] . "&type=m3u_plus&output=ts"; } else { $line = $_POST["url"]; } $address1 = strtoupper($_POST["mac_address"]); $playlistpassword = ""; if(isset($_POST["playlistpassword"])){ $playlistpassword = $_POST["playlistpassword"]; } if (!$isAdmin) { $dbUsers = new SQLite3("./api/.anspanel.db"); $res = $dbUsers->query("SELECT mac_amount FROM USERS WHERE id = '$id' "); $macCount = $res->fetchArray()['mac_amount']; $dbUsers->close(); $res = $db->query("SELECT COUNT(*) as count FROM ibo WHERE id_user = '$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, key, username, password, expire_date, dns, epg_url, title, url, type, id_user, playlistpassword, active) VALUES('" . $address1 . "', '" . $_POST["key"] . "', '" . $_POST["username"] . "', '" . $_POST["password"] . "', '" . $ne . "', '" . $_POST["dns"] . "', '" . $_POST["epg_url"] . "', '" . $_POST["title"] . "', '" . $line . "', '" . $_POST["type"] . "', '$id', '$playlistpassword', 1)"); 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: users.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.php"; if($limited){ echo "
Limite de MACs excedido!
"; } echo "
\n\n \n

Activate User

\n\n \n
\n
\n
User Details
\n
\n
\n
\n
\n \n
\n \n
\n
\n
\n \n
\n \n
\n
\n \r\n\r\n
\n \r\n
\n Select Login Mode for DNS: \r\n \r\n
\n\n \r\n\r\n \r\n\r\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
\n \n
\n
\n
\n
\n
\n \n
\n \n
\n
\n
\n
\n \n
\n \n
\n
"; if ($storeType == '1'){ echo "
\n \n
\n \n
\n\n
\n"; } if ($storeType == '2') { echo "
\n
"; } echo "\n
\n\n
\n \n
\n \n \n


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