<?php

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

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

$url = 'https://spinomenal.com/games/';
require_once('simple_html_dom.php');
$html_content = file_get_contents($url);
$html = str_get_html($html_content);

$insertedGames = [];
// $count = 0;

foreach ($html->find('div.element') as $div) {
    // $count++;
    // if ($count > 10) { break; }

    $link = $div->find('div.element-inner a', 0)->href;
    $name = $div->find('.thumb-title', 0)->plaintext;

    $name = str_replace("Irish Treasures – LF", "Irish Treasures – Leprechaun's Fortune", $name);
    $name = str_replace("Story Of Egypt – ED", "Story Of Egypt – Egyptian Darkness", $name);
    $name = str_replace("The Ankh Protector – ED", "The Ankh Protector – Egyptian Darkness", $name);
    $name = str_replace("Times Of Egypt – ED", "Times Of Egypt – Egyptian Darkness", $name);

    $provider_id = $id;

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

    $volatility = 0;
    $rtp = 0.0;
    $rtp_low = 0.0;
    $rtp_high = 0.0;
    $max_win = 0;

    $img = $div->find('.flip-img-wrap img', 0)->getAttribute('data-src');

    if (!empty($link)) {
        $html_game = file_get_contents($link);
        if ($html_game !== false) {
            $dom_game = new DOMDocument();
            @$dom_game->loadHTML($html_game);
            $xpath_game = new DOMXPath($dom_game);

            $iframe_link = $xpath_game->query('//p[@class="game-play-btn"]//a')->item(0);
            if ($iframe_link !== null) {
                $href = $iframe_link->getAttribute('href');
                if (strpos($href, 'http') === false) {
                    $demo_desk_link = "https://spinomenal.com" . $href;
                } else {
                    $demo_desk_link = $href;
                }

                if (!empty($demo_desk_link)) {
                    $html_demo_desk = @file_get_contents($demo_desk_link);
                    if ($html_demo_desk !== false) {
                        $dom_demo_desk = new DOMDocument();
                        @$dom_demo_desk->loadHTML($html_demo_desk);
                        $xpath_demo_desk = new DOMXPath($dom_demo_desk);
                        
                        $iframe = $xpath_demo_desk->query('//iframe[@id="game-iframe"]')->item(0);
                        if ($iframe !== null) {
                            $demo_desk = $iframe->getAttribute('src');
                        } else {
                            $demo_desk = "";
                        }
                    } else {
                        $demo_desk = "";
                    }
                } else {
                    $demo_desk = "";
                }
            } else {
                $demo_desk = "";
            }
        } else {
            $demo_desk = "";
        }
        $demo_mob = $demo_desk;
    } else {
        $demo_desk = "";
        $demo_mob = "";
    }

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

    require ('insert_values.php');

    require ('inserted_games.php');
}

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