query("SELECT * FROM ibo WHERE mac_address = '$mac_address' AND store_type = 2");
$validStore = true;
while ($row = $macRes->fetchArray()) {
if(empty($row['id_user'])){
$validStore = false;
break;
}
}
if(!$validStore && isset($_POST['store_link'])){
$dbUsers = new SQLite3("./api/.anspanel.db");
$store_id = $_POST['store_id'];
$ret = $dbUsers->query("SELECT COUNT(*) as count FROM USERS WHERE id = '$store_id'");
$storeExists = $ret->fetchArray()['count'] > 0;
if($storeExists){
$res = $dbUsers->query("SELECT mac_amount FROM USERS WHERE id = '$store_id' ");
$macCount = $res->fetchArray()['mac_amount'];
$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->query("UPDATE ibo SET id_user = '$store_id' WHERE mac_address = '$mac_address' AND store_type = 2 AND (id_user = '' OR id_user IS NULL)");
$validStore = true;
}
}
$dbUsers->close();
}
include "includes/header_playlist.php";
function create_line($row){
$playlist_password = $row['playlistpassword'];
$iid = $row["id"];
$imac = $row["mac_address"];
$ikey = $row["key"];
$iexpire_date = $row["expire_date"];
if ($idns = $row["dns"] == NULL) {
$iusername = "listm3u-id" . $row["id"];
$idns = $row["url"];
} else {
$iusername = $row["username"];
$idns = $row["dns"];
}
$iepg = $row["epg_url"];
$ititle = $row["title"];
$pwd_req = 0;
if ($playlist_password) {
$pwd_req = 1;
$idns = "****";
$iepg = "****";
$ititle = "****";
}
echo " \n";
echo " | " . $iid . " | " . "\n";
echo " " . $imac . " | " . "\n";
echo " " . $iusername . " | " . "\n";
echo " " . $iexpire_date . " | " . "\n";
echo " " . $iexpire_date . " | " . "\n";
echo " " . $iexpire_date . " | " . "\n";
echo " " . $idns . " | " . "\n";
echo " " . $iepg . " | " . "\n";
echo " " . $ititle . " | " . "\n";
echo " | " . "\n";
echo "\t\t\t\t\n\t\t\t\n";
}
?>
query("SELECT * FROM ibo WHERE mac_address = '$mac_address' AND store_type = 2");
?>
Playlist Dashboard
Proteja sua playlist com senha clicando em Editar, e configurando uma senha
| ID |
Device ID |
Username |
Expire Date |
Expire Date |
Expire Date |
DNS / M3U |
EPG |
Title |
Edit |
fetchArray()) {
create_line($row);
}
if($macRes) { ?>
Código de vendedor inválido";
}
if(isset($limited) && !$limited) {
echo "Limite de MACs excedidos para a loja
";
}
?>
\n\$('#confirm-delete').on('show.bs.modal', function(e) {\n \$(this).find('.btn-ok').attr('href', \$(e.relatedTarget).data('href'));\n});\n \n \n