<?php
// Connect to the database
require_once('pdo.php');
require_once('get_provider_translit.php');
require('create_images.php');

$id = 28;
$provider_translit = getProviderTranslit($id);

// Load HTML content from a locally stored file
$html_content = file_get_contents('manual_dom_betsoft.html');

// Include the Simple HTML DOM Parser library
require_once('simple_html_dom.php');

$html = str_get_html($html_content);

$insertedGames = [];
$count=0;
foreach ($html->find('div.game-single-box') as $div) {
        $count++;
        if($count>5){break;}
        $link = $div->find('a.uk-button.uk-button-outline.uk-button-outline-black.uk-button-small.uk-display-block', 0);
        $link = $link->href;

        $name = $div->find('.game-single-box-image', 0);
        $name = $name->alt;

        $provider_id = $id;

        $translit = str_replace(" ", "-", $name);
        $translit = str_replace("&#039;", "-", $translit);
        $translit = preg_replace("/[^a-zA-Z0-9\-]/", "", $translit);
        $translit = str_replace("---", "-", $translit);
        $translit = str_replace("--", "-", $translit);

        if (!empty($link)) {

            $ch = curl_init($link);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
            $html = curl_exec($ch);
            curl_close($ch);

            // $html = file_get_contents($link);
            $dom = new DOMDocument();
            @$dom->loadHTML($html);
            $xpath = new DOMXPath($dom);
            $iframe = $xpath->query('//iframe[@id="game-demo-iframe"]')->item(0);
            if ($iframe !== null) {
                $demo_desk = $iframe->getAttribute('src');
            } else {
                $demo_desk = "";
            }
            $demo_mob = $demo_desk;
        } else {
            $demo_desk = "";
            $demo_mob = "";
        }
        
        $volatility = 0;
        $rtp = 0.0;
        $rtp_low = 0.0;
        $rtp_high = 0.0;
        $max_win = 0.0;

        $img = $div->find('.game-single-box-image', 0);
        $img = $img->src;

        // createImage($provider_translit, $translit, $img);

        // require ('insert_values.php');

        require ('inserted_games.php');
}

echo json_encode(['insertedGames' => $insertedGames]);
?>