#### mercado_pago.php ####
<?php
session_start();
// Verifica login se tiver um sistema central de sessões
// if (!isset($_SESSION['login'])) { header("Location: index.php"); exit; }
include './includes/header.php';
?>

<div class="card radius-10">
    <div class="card-body">
        <div class="d-flex align-items-center justify-content-between mb-4">
            <h5 class="card-title mb-0 text-success">Mercado Pago Gold Avançado</h5>
            <button class="btn btn-secondary btn-sm" onclick="window.history.back()"><i class='bx bx-arrow-back'></i> Voltar ao Painel</button>
        </div>

        <div class="row">
            <div class="col-12 col-lg-6">
                <!-- Access Token -->
                <div class="card border border-secondary mb-4 shadow-none">
                    <div class="card-header bg-transparent border-bottom border-secondary">
                        <h6 class="mb-0 text-primary"><i class='bx bx-key'></i> Configuração Mercado Pago Gold</h6>
                    </div>
                    <div class="card-body">
                        <label class="form-label">Access Token (Mercado Pago)</label>
                        <div class="input-group">
                            <input type="text" id="access_token" class="form-control" placeholder="APP_USR-...">
                            <button class="btn btn-primary" onclick="saveToken()"><i class='bx bx-save'></i> Salvar</button>
                        </div>
                    </div>
                </div>

                <!-- Cupons -->
                <div class="card border border-secondary mb-4 shadow-none">
                    <div class="card-header bg-transparent border-bottom border-secondary">
                        <h6 class="mb-0 text-warning"><i class='bx bx-purchase-tag'></i> Gerenciar Cupons</h6>
                    </div>
                    <div class="card-body">
                        <div class="row g-2 mb-3">
                            <div class="col-md-6">
                                <input type="text" id="cupom_codigo" class="form-control" placeholder="Código (Ex: PROMO30)">
                            </div>
                            <div class="col-md-4">
                                <input type="number" id="cupom_desconto" class="form-control" placeholder="Desconto (%)">
                            </div>
                            <div class="col-md-2">
                                <button class="btn btn-warning w-100 text-dark" onclick="addCupom()" t

#### pagamento_maos.php ####
<?php
session_start();
require_once __DIR__ . '/whatsapp_api.php';

$msg_sucesso = '';
$msg_erro = '';

if (isset($_POST['renovar'])) {
    $link_colado = trim($_POST['link_colado'] ?? '');
    
    // Tenta interpretar o input. Se contiver URL, extrai query params. Se não for, usa direto.
    $input_val = '';
    $url_to_parse = '';

    if (filter_var($link_colado, FILTER_VALIDATE_URL)) {
        $url_to_parse = $link_colado;
    } elseif (preg_match('/https?:\/\/[^\s"\'<>]+/i', $link_colado, $urlMatch)) {
        $url_to_parse = $urlMatch[0];
    }

    if (!empty($url_to_parse)) {
        $query = parse_url($url_to_parse, PHP_URL_QUERY);
        parse_str((string)$query, $params);
        $mac_address = $params['mac'] ?? '';
        $telefone = $params['telefone'] ?? '';
        $input_val = !empty($telefone) ? $telefone : $mac_address;
    } else {
        $input_val = $link_colado;
    }
    
    $input_val = strtoupper(trim($input_val));
    
    if (empty($input_val)) {
        $msg_erro = 'Entrada inválida. Não foi possível extrair MAC ou telefone.';
    } else {
        $configPath = __DIR__ . '/api/renovar/config.json';
        $config = file_exists($configPath) ? json_decode(file_get_contents($configPath), true) : [];
        $whatsFile = __DIR__ . '/whats.json';
        $whatsData = file_exists($whatsFile) ? json_decode(file_get_contents($whatsFile), true) : [];
        if (!is_array($whatsData)) $whatsData = [];
        
        $clean_input = preg_replace('/[^0-9]/', '', $input_val);
        $input_phone_core = normalizePhoneCore($input_val);

        // Prepara variações de MAC caso tenha digitado sem dois-pontos
        $mac_variations = [$input_val];
        $clean_mac = preg_replace('/[^A-Z0-9]/', '', $input_val);
        if (strlen($clean_mac) === 12 && preg_match('/^[A-F0-9]{12}$/', $clean_mac)) {
            $mac_variations[] = implode(':', str_split($clean_mac, 2));
        }

        $is_multimac = false;
        $multimac_m = null;

        if (isset($config['multimacs']) && is_array($config['multimacs'])) {
            foreach ($config['multimacs'] as $m) {
                $match = false;
                
                // 1. Verifica se bate com o código (WhatsApp do revendedor/pacote) com ou sem o 9º dígito / +55
                $codigo_m = strtoupper(trim((string)($m['codigo'] ?? '')));
                if ($codigo_m !== '' && ($codigo_m === $input_val || phonesMatch($codigo_m, $input_val))) {
                    $matc

#### enviar_cobrancas.php ####
<?php
// enviar_cobrancas.php
// Envio manual de cobrança aos clientes vencidos (botão da tela Início). Somente admin logado ou token do cron.
require_once __DIR__ . '/cron_guard.php';
cron_authorize(true);

set_time_limit(0);
ignore_user_abort(true);
date_default_timezone_set('America/Sao_Paulo');
require_once __DIR__ . '/whatsapp_api.php';

$db = new SQLite3(__DIR__ . "/api/db/studiolivecode_clientes.db");
$db->busyTimeout(5000);
$dbNotif = new SQLite3(__DIR__ . "/api/db/studiolivecode_notificacoes.db");
$dbNotif->busyTimeout(5000);
$dbNotif->exec("CREATE TABLE IF NOT EXISTS notificacoes_log (id INTEGER PRIMARY KEY AUTOINCREMENT, mac TEXT, notificacao_id TEXT, data_envio TEXT)");

$whatsFile = __DIR__ . '/whats.json';
$whatsData = file_exists($whatsFile) ? json_decode(file_get_contents($whatsFile), true) : [];
if (!is_array($whatsData)) $whatsData = [];

$hoje = date('Y-m-d');
$res = $db->query("SELECT * FROM ibo WHERE expire_date < date('now') AND active = 1");

$enviados = 0;
$ignorados = 0;
while ($row = $res->fetchArray(SQLITE3_ASSOC)) {
    $mac = $row['mac_address'];

    if (!isset($whatsData[$mac]) || empty($whatsData[$mac]['whatsapp'])) continue;
    $numero = preg_replace('/[^0-9]/', '', $whatsData[$mac]['whatsapp']);
    if (strlen($numero) < 10) continue;
    if (strlen($numero) <= 11) $numero = '55' . $numero;

    // Não cobra o mesmo cliente duas vezes no mesmo dia
    $chk = $dbNotif->prepare("SELECT COUNT(*) FROM notificacoes_log WHERE mac = :mac AND notificacao_id = 'cobranca_manual' AND data_envio = :hoje");
    $chk->bindValue(':mac', $mac, SQLITE3_TEXT);
    $chk->bindValue(':hoje', $hoje, SQLITE3_TEXT);
    if ((int)$chk->execute()->fetchArray()[0] > 0) { $ignorados++; continue; }

    $nome = !empty($row['title']) ? $row['title'] : $row['username'];
    $mensagem = "Olá " . $nome . ",\nSua assinatura venceu. Por favor, renove para continuar usando nosso serviço.";

    $ret = sendWhatsAppMessage($numero, $mensagem);
    if ($ret && isset($ret['status']) && $ret['status'] === 'success') {
        $enviados++;
        $ins = $dbNotif->prepare("INSERT INTO notificacoes_log (mac, notificacao_id, data_envio) VALUES (:mac, 'cobranca_manual', :hoje)");
        $ins->bindValue(':mac', $mac, SQLITE3_TEXT);
        $ins->bindValue(':hoje', $hoje, SQLITE3_TEXT);
        $ins->execute();
        // Previne banimento variando o tempo entre 4 a 8 segundos
        sleep(rand(4, 8));
    }
}
$db->close();
$dbNotif->close();
header('Content-T

#### cron_config.json ####
{
    "token": "e1e15f56db37c3c53021bf3ee9ee5d8f",
    "domain": "admpremium.cadtech.com.br"
}

#### whats.json ####
{
    "87:78:01:9C:82:96": {
        "whatsapp": "+55 51 8019-3438",
        "name": "Cristiano de Souza",
        "mac": "87:78:01:9C:82:96"
    },
    "EB:13:09:3E:16:44": {
        "whatsapp": "+55 11 96689-4175",
        "name": "Denis 02",
        "mac": "EB:13:09:3E:16:44"
    },
    "4B:E5:77:0D:62:F2": {
        "whatsapp": "+55 11 98315-5251",
        "name": "Rafael Felipe",
        "mac": "4B:E5:77:0D:62:F2"
    },
    "BD:EF:80:17:B6:DC": {
        "whatsapp": "5555981005918",
        "name": "Tici Celular",
        "mac": "BD:EF:80:17:B6:DC"
    },
    "3F:C6:07:8C:C7:7B": {
        "whatsapp": "55991568454",
        "name": "Andrey PC Mesa ",
        "mac": "3F:C6:07:8C:C7:7B"
    },
    "80:25:38:4F:12:6F": {
        "whatsapp": "55981005918",
        "name": "Salvador  Amazon Gael",
        "mac": "80:25:38:4F:12:6F"
    },
    "5B:47:E6:1F:FC:D3": {
        "whatsapp": "55981081775",
        "nome": "Luciano Pauletto farias, LENNOX",
        "updated_at": "2026-08-11 10:58:08"
    },
    "F3:0D:B7:4F:3E:44": {
        "whatsapp": "",
        "name": "Andrey cozinha",
        "mac": "F3:0D:B7:4F:3E:44"
    },
    "28:1C:2E:48:BD:EE": {
        "whatsapp": "",
        "name": "Tomate Lauro",
        "mac": "28:1C:2E:48:BD:EE"
    },
    "58:D8:28:3D:33:44": {
        "whatsapp": "51998567610",
        "name": "Andreia",
        "mac": "58:D8:28:3D:33:44"
    },
    "30:B4:6F:CC:D4:4F": {
        "whatsapp": "55991545691",
        "name": "Igor sala ",
        "mac": "30:B4:6F:CC:D4:4F"
    },
    "BB:3A:73:98:30:92": {
        "whatsapp": "",
        "name": "Celular Gael ",
        "mac": "BB:3A:73:98:30:92"
    },
    "BB:F9:E6:3D:83:68": {
        "whatsapp": "",
        "name": "M\u00e1rcio Nina",
        "mac": "BB:F9:E6:3D:83:68"
    },
    "0E:55:5B:43:8C:31": {
        "whatsapp": "",
        "name": "Ethi",
        "mac": "0E:55:5B:43:8C:31"
    },
    "26:81:C1:7F:77:81": {
        "whatsapp": "",
        "name": "Marlon 1",
        "mac": "26:81:C1:7F:77:81"
    },
    "7C:85:F5:55:28:35": {
        "whatsapp": "",
        "name": "Bruninha",
        "mac": "7C:85:F5:55:28:35"
    },
    "43:66:5D:70:8A:E5": {
        "whatsapp": "55991794942",
        "name": "Alexandre Juca ",
        "mac": "43:66:5D:70:8A:E5"
    },
    "F6:DA:C6:2A:02:09": {
        "whatsapp": "",
        "name": "Zezinho quarto",
        "mac": "F6:DA:C6:2A:02:09"
    },
    "51:1C:69:03:19:F5": {
        "whatsapp": "41997394006",
        "name": "Marcio N

#### evolution_config.json ####
{
    "evolution_url": "https:\/\/admhibrido.cadtech.com.br",
    "global_apikey": "HUB_6A60FC9971FF61d9cabab",
    "instance_name": "HUB Hibrido"
}

#### .git/config ####
[core]
	repositoryformatversion = 0
	filemode = true
	bare = false
	logallrefupdates = true
[remote "origin"]
	url = git@github.com:Dyplaytv/admpremium.git
	fetch = +refs/heads/*:refs/remotes/origin/*
[branch "main"]
	remote = origin
	merge = refs/heads/main


#### api/config.php ####
MISSING

#### includes/config.php ####
MISSING

#### dump_bot.php ####
<?php
$dbb = new SQLite3('./api/db/studiolivecode_bot.db');
$resb = $dbb->query("SELECT * FROM bot WHERE id='1'");
$rowb = $resb->fetchArray(SQLITE3_ASSOC);
file_put_contents('bot_debug.txt', json_encode($rowb));

$dbv = new SQLite3('./api/db/studiolivecode_vencimento.db');
$resv = $dbv->query("SELECT * FROM vencimento");
$vencs = [];
while($r = $resv->fetchArray(SQLITE3_ASSOC)) { $vencs[] = $r; }
file_put_contents('venc_debug.txt', json_encode($vencs));
?>


#### API DIR ####
. .. .adb.db .ansdb.db .htaccess allads.php banners.json bg.php contato.php db debug.log getappuser.php ibo.json index.php language.json logo.php note.json pagamento.php payment playlist.php qr.php renovar setting.json setting.php sportjr.php teste_manual.json theme.json theme_change 
DONE