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 ($storeType == 5) { $dbUsers = new SQLite3("./api/.anspanel.db"); $numRows = $dbUsers->querySingle("SELECT COUNT(*) FROM USERS WHERE USERNAME = '". $_POST['login'] ."' OR NAME = '". $_POST['firstname'] ."' "); if ($numRows <= 0) { $logoPath = "logotipo_painel/logo.png"; $query = "INSERT INTO users (NAME, USERNAME, PASSWORD, LOGO, store_type, mac_amount, ADMIN, expire_date, email, price_to_mp) VALUES ('{$_POST['firstname']}', '{$_POST['login']}', '{$_POST['password']}', '$logoPath', '0', '{$_POST['qtd_macs']}', '1', '{$_POST['expire_date']}', '{$_POST['email']}', '{$_POST['price_to_mp']}')"; $result = $dbUsers->exec($query); if (!$result) { echo "Erro ao executar o comando SQL: " . $dbUsers->lastErrorMsg(); echo "

";
                print_r($_POST);
                die;
            }

            header("Location: users.php");
        } else {
            $_SESSION['error_session'] = "Usuário já foi cadastrado";
            header("Location: users.php");
        }
        $dbUsers->close();

    }else {
//        if (!$isAdmin) {

            $dbUsers = new SQLite3("./api/.anspanel.db");
            $res = $dbUsers->query("SELECT u.mac_amount, (SELECT SUM(mac_amount) FROM USERS WHERE user_id=u.id) as amountSum FROM USERS u WHERE u.id = '$id' ");
            $fetch = $res->fetchArray();
            $macCount = $fetch['mac_amount'];
            
            if($macCount != "9999999999"){
    
                $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']+$fetch['amountSum'];
    
                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($isAdmin == 1){
    if (strtotime(date("Y-m-d", strtotime($expire_date))) <= strtotime(date("Y-m-d"))) {
        echo "Função bloqueada! Regularize a sua assinatura para voltar a cadastrar novas revendas";
        die;
    }
}
if($storeType == 1){
    if (strtotime(date("Y-m-d", strtotime($revenda_date_expire))) <= strtotime(date("Y-m-d"))) {
        echo "Função bloqueada! Entre em contato com seu revendedor";
        die;
    }
}

if($limited){
    echo "MACs limit exceeded!";
} else {
    $dbUsers = new SQLite3("./api/.anspanel.db");
    $res = $dbUsers->query("SELECT u.mac_amount, (SELECT SUM(mac_amount) FROM USERS WHERE user_id=u.id) as amountSum  FROM USERS u WHERE u.id = '$id' ");
    $fetch = $res->fetchArray();
    $macCount = $fetch['mac_amount'];
    $dbUsers->close();
    
    if($macCount != "9999999999"){
        $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'];
        
        $availableMacs = $macCount - ($count + $fetch['amountSum']);
        
        
        if($storeType != 5) {
            echo "MAC disponíveis: $availableMacs";
        }
    }else{
                $availableMacs = 9999999999;
                 
        if($storeType != 5) {
            echo "MAC disponíveis: Ilimitado";
        }
    }
    
}

if($storeType == 5){
    $title = "Criação de Usuario Master";
}else{
    $title = "Activate User";
}


echo "        \n\n          \n           $title 
\n\n              \n                \n                \n                 User Details
\n                \n     
                   
                   \n                                  \n                    \n                                   \n           
                                            
                                   ";
    if($storeType != '5') {
        echo "         \n                                        Device MAC \n                                    
    \n                                        \n                                    
\n                                
\n                        \n	  \r\n\r\n";

    if(!$dnsFixoUser) {
        echo "\n                                    \r\n\n                             Select Login Mode:  \r\n                                    \r\n
\n\n  \r\n\r\n        \r\n\r\n\n    \r\n    ";
        $onlyRead = "";
    }else{
        $onlyRead = " readonly='true' ";
        echo '';
    }

    echo "                            \n                                    \n                                        Server Name\n                                    \n                                    \n                                        \n                                    
\n                                
\n                \n                                \n                                    \n                                        Username\n                                    \n                                    \n                                        \n                                    
\n                                
\n                                \n                                    \n                                        Password\n                                    \n                                    \n                                        \n                                    
\n                                \n

                                 \n                                    \n                                        DNS\n                                    \n                                    \n                                        \n                                    
\n                                
\n                         
\n                     \n                                 \n                                    \n                                        M3U List\n                                    \n                                    \n                                        \n                                    
\n                                
\n                       
\n                                 \n                                    \n                                        EPG URL\n                                    \n                                    \n                                        \n                                    
\n                                ";
    }else{
        echo '
            
               Conta Ilimitada?
                  
                    
                     
            
            
               Quantidade de Macs disponiveis
                  
                    
                     
            
            
               Login
                  
                    
                     
            
            
               Email
                  
                    
                     
            
            
               Valor
                  
                    
                     
            
            
               Senha
                  
                    
                     
            
            
               Nome do Master
                  
                    
                     
            
        ';
    }
                                    echo "\n                                    \n                                        Expiration Date\n                                    \n                                    \n                                         \n                                    
\n\n                                \n";
                                if ($storeType == '2') {
                                    echo "
                                                Playlist Password (Optional)
                                            \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";

?>