exec("DELETE FROM ibo WHERE id=" . $_GET["delete"]); // $db->close(); // for($i = 0; $i < count($_SESSION['macs']); $i++){ // $session_row = $_SESSION['macs'][$i]; // if($session_row['id'] == $_GET["delete"]){ // unset($_SESSION['macs'][$i]); // } // } // header("Location: users_mac.php"); // } if (isset($_GET["activate"])) { $new_expire_date = date('Y-m-d', strtotime('+1 year')); $db->exec("UPDATE ibo SET active = 1, expire_date = '$new_expire_date' WHERE id=" . $_GET["activate"]); if(isset($_SESSION['macs'])){ for($i = 0; $i < count($_SESSION['macs']); $i++){ $session_row = $_SESSION['macs'][$i]; if($session_row['id'] == $_GET["activate"]){ $_SESSION['macs'][$i]['active'] = 1; $_SESSION['macs'][$i]['expire_date'] = $new_expire_date; } } }else{ $res = $db->query("SELECT * FROM ibo WHERE id = ". $_GET["activate"]); $_SESSION['macs'] = []; while ($row = $res->fetchArray()) { array_push($_SESSION['macs'], $row); } } $db->close(); header("Location: users_mac.php"); } if($_POST) { $mac_address = strtoupper($_POST['mac_address']); $db = new SQLite3("./api/.ansdb.db"); $macRes = $db->query("SELECT * FROM ibo WHERE mac_address = '$mac_address' AND id_user = '$id_store'"); } include "includes/header_mac.php"; ?> query("SELECT mac_amount FROM USERS WHERE id = '$id_store' "); $macCount = $res->fetchArray()['mac_amount']; $dbUsers->close(); $res = $db->query("SELECT COUNT(*) as count FROM ibo WHERE id_user = '$id_store' AND active = 1 AND expire_date > date('now')"); $count = $res->fetchArray()['count']; $available = $macCount - $count; echo "

Você pode registrar mais $available MACs (Limite de $macCount)

"; ?>

= $today; $pwd_req = 0; if ($playlist_password) { $pwd_req = 1; $idns = "****"; $iepg = "****"; $ititle = "****"; } echo " \n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; // echo " " . "\n"; // echo " " . "\n"; if(!$active){ echo " "; } echo "\t\t\t\t\n\t\t\t\n"; } if($macRes){ while ($row = $macRes->fetchArray()) { create_line($row); } }else if(isset($_SESSION['macs'])) { foreach ($_SESSION['macs'] as $mac_row){ create_line($mac_row); } } ?>

ID	Device ID	Username	Expire Date	DNS / M3U	EPG	Title
" . $iid . "	" . $imac . "	" . $iusername . "	" . $iexpire_date . "	" . $idns . "	" . $iepg . "	" . $ititle . "			Ativar

\n\$('#confirm-delete').on('show.bs.modal', function(e) {\n \$(this).find('.btn-ok').attr('href', \$(e.relatedTarget).data('href'));\n});\n \n\n "; ?>

User Dashboard