<?php
$db1 = new SQLite3('.sportdb.db');
$result2 = $db1->query('SELECT url, c1, c2, c3 FROM sport');
$row2 = $result2->fetchArray(SQLITE3_ASSOC);
$sports = $row2['url'] . '?heading=' . $row2['c1'] . '&border_color=' . $row2['c2'] . '&autoscroll=' . $row2['c3'];
$db1->close();

$db = new SQLite3('.bet3db.db');


if ($_SERVER['REQUEST_METHOD'] === 'GET' && isset($_GET['code'])) {
    $db = new SQLite3('.bet3db.db');
    $query = "SELECT * FROM portals WHERE code = :code";
    $statement = $db->prepare($query);
    $statement->bindValue(':code', $_GET['code'], SQLITE3_TEXT);
    $result = $statement->execute();
    
    $app_dns = [];
    
    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        $dns = [
            'dns_title' => $row['name'],
            'url' => $row['url'],
            'live_dns' => '',
            'epg_dns' => '',
            'movie_dns' => '',
            'series_dns' => '',
            'catchup_dns' => '',
        ];
        $app_dns[] = $dns;
    }
    
    $statement->close();
    
    if (empty($app_dns)) {
        $invalidDns = [
            'dns_title' => 'ERROR INVALID CODE!',
            'url' => 'http://example.com',
            'live_dns' => '',
            'epg_dns' => '',
            'movie_dns' => '',
            'series_dns' => '',
            'catchup_dns' => '',
        ];
        $app_dns[] = $invalidDns;
    }
    
    // Use $app_dns as needed
}
$db->close();
$data = [
    "app_mode" => "Xstream",
    "code_login" => "true",
    "app_mode_universal" => "",
    "in_app_purchase" => [
        "in_app_purchase_id" => "",
        "lic_key" => "",
        "in_app_status" => "false"
    ],
    "ads" => [
        "ads_app_id" => "#",
        "ads_banner" => "#",
        "ads_intrestial" => "#",
        "ads_rewarded" => "#",
        "ads_native" => "\/200463343\/InHouse_Native",
        "ads_intrestial_time_delay" => "3600",
        "ads_ios_status" => "false",
        "ads_status" => "false"
    ],
    "app_conf" => [
        "allow_4k" => "true",
        "content_4k" => "",
        "domain_url" => "http:\/\/example.com",
        "login_url" => "http:\/\/example.com",
        "package_name" => "com.easy.purple.player",
        "privacy_policy" => "https://www.tvsportguide.com/widget/5cc316f797659/?heading=Events&border_color=custom&autoscroll=1&custom_colors=?heading=#1d23dd&border_color=#ffffff&autoscroll=#000000",
        "private_access" => "true",
        "private_video_url" => "https:\/\/hiboss.b-cdn.net",
        "startup_msg" => "BetBetBet",
        "vpn" => "true",
        "vpn_sub_splash" => "false",
        "vpn_login_screen" => "false",
        "allow_cast" => "true",
        "remote_support" => "false",
        "wifi_option" => "false",
        "sub_splash" => "true",
        "clear_catch" => "true",
        "setting_option" => "true",
        "app_list_status" => "true",
        "private_menu" => "true",
        "epg_timeshift" => "true",
        "epg_catchup" => "true",
        "catchup" => "true",
        "epg_roku" => "false",
        "dashbord_ticker" => "true",
        "login_ticker" => "true",
        "sub_profile" => "true",
        "set_default_play" => "true",
        "set_recent_play" => "true",
        "remind_me" => "false",
        "cloud_remind_me" => "#",
        "cloud_remind_me_url" => "#",
        "cloud_recording" => "true",
        "cloud_recent_fav" => "false",
        "cloud_recent_fav_url" => "#",
        "multi_recording" => "true",
        "recording" => "true",
        "app_external_plugin" => "false",
        "chat_url" => "",
        "startup_plugin_install" => "false",
        "startup_archive_category" => "false",
        "startup_auto_boot" => "false",
        "startup_device_select" => "true",
        "manual_device_select" => "true",
        "header_key" => "Purple",
        "header_value" => "User-Agent",
        "smtp_server" => "",
        "smtp_port" => "",
        "smtp_username" => "",
        "smtp_password" => "",
        "smtp_from_email" => "",
        "channel_reporting" => "false",
        "channel_reporting_to_email" => "",
        "movie_show_reqest" => "false",
        "movie_show_reqest_to_email" => "",
        "channel_report_email_subject" => "",
        "movie_shows_reqest_email_subject" => "",
        "p2p" => "false",
        "p2p_signal" => "wss:\/\/signalcloud.cdnbye.com",
        "p2p_setting_default" => "false",
        "intro_video" => "false",
        "theme_change_allow" => "true",
        "theme_change_layout" => "L19,NUL",
        "report_issue_from_email" => "support@purplesmarttv.com",
        "report_issue_to_email" => "info@purplesmarttv.com",
        "report_issue" => "false",
        "reporting_api" => "#",
        "mqtt_server" => "#",
        "mqtt_endpoint" => "#",
        "auto_login" => "true",
        "multi_profile" => "true",
        "server_selection" => "true",
        "app_settings" => "true",
        "app_settings_passcode" => "0000",
        "app_general_settings" => "true",
        "multi_profile_auto_login" => "true",
        "sub_user_profile" => "true",
        "sub_user_profile_allow" => "5",
        "sub_user_profile_default" => "false",
        "sub_user_profile_setting" => "true",
        "sub_user_profile_select_on_start" => "true",
        "stream_format" => "",
        "default_device_select" => [
            "detect" => "false",
            "device" => "TV"
        ],
        "sub_user_profile_settings" => "false"
    ],
    "app_dns" => $app_dns,
    "app_image" => [
        "app_img" => "false",
        "app_logo" => "https:\/\/assets.stickpng.com\/images\/5842ab6da6515b1e0ad75b0a.png",
        "app_mobile_icon" => "https:\/\/assets.stickpng.com\/images\/5842ab6da6515b1e0ad75b0a.png",
        "app_tv_banner" => "https:\/\/assets.stickpng.com\/images\/5842ab6da6515b1e0ad75b0a.png"
    ],
    "about" => [
        "description" => "",
        "developed" => "",
        "name" => "",
        "skype" => "",
        "telegram" => "",
        "whatsapp" => ""
    ],
    "support" => [
        "email" => "support@purplesmarttv.com",
        "web" => "http:\/\/google.com",
        "skype" => "skype",
        "telegram" => "234",
        "whatsapp" => "123456"
    ],
    "version" => [
        "version_check" => "false",
        "version_code" => "21",
        "version_name" => "5.0",
        "version_download_url" => "",
        "version_download_url_apk" => "",
        "version_force_update" => "false",
        "version_update_msg" => ""
    ],
    "endpoint" => [
        "m3u_parse" => "#",
        "login" => "#",
        "register" => "#",
        "list_get" => "#",
        "list_xstream_update" => "#",
        "deleteurl" => "#",
        "list_m3u_update" => "#",
        "list_update_epg" => "#"
    ],
    "api_key" => [
        "imdb_api" => "https:\/\/omdbapi.b-cdn.net\/?t=%s&apikey=f608cd74",
        "g_api_key" => "AIzaSyCXTlsFcriBtNmakgbCoP7XGfRGcB_Mc0c",
        "image_imdb" => "https:\/\/images.metahub.space\/poster\/large\/%s\/img",
        "trakt_api_key" => "9f2897b7a0dac4606e3074622cf6c52581f8dc208bc1520381b18bd90b74e257",
        "vpn_url" => "#",
        "vpn_username" => "#",
        "vpn_password" => "#",
        "ip_stack_key" => "75a3f0c901c3b0c9ef6b9decd12cc58e",
        "check_ip" => "https:\/\/checkip.justwatch.com"
    ],
    "background" => [
        "background_auto_change" => "false",
        "background_mannual_change" => "true",
        "background_orverlay_color_code" => "",
        "background_url" => [
            ["url" => ""],
            ["url" => ""],
            ["url" => ""],
            ["url" => ""]
        ]
    ],
    "language" => [
        "defult_language" => "EN",
        "firstime_select_language" => "true"
    ],
    "themes" => [
        "theme_defult_layout" => "NUL",
        "theme_color_1" => "#000000",
        "theme_color_2" => "#FFFFFF",
        "theme_color_3" => "#",
        "theme_change" => null
    ],
    "private_menu" => [],
    "plugin_list" => []
];

$encodedData = base64_encode(base64_encode(base64_encode(base64_encode(json_encode($data)))));
echo $encodedData;
?>