<?php

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

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

$url = 'https://www.yggdrasilgaming.com/w/wp-admin/admin-ajax.php?action=games_data';
$data = file_get_contents($url);
$games = json_decode($data, true);

$insertedGames = [];
// $count = 0;
foreach ($games as $game) {
    // $count++;
    // if ($count > 4) {
    //     break;
    // }
        $link = $game['link'];

        $name = $game['title'];
        $name = str_replace("™", "", $name);
        if ($name == "Rise and Fall of Ra - POSTPONED"){continue;}

        $provider_id = $id;

        $translit = str_replace(" ", "-", $name);
        $translit = str_replace("&#039;", "-", $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);

        $gameId = $game['ID'];
        
        $html = file_get_contents($link);
        $dom = new DOMDocument();
        @$dom->loadHTML($html);
        $xpath = new DOMXPath($dom);
        $iframe = $xpath->query('//embed[@class="modal-iframe"]')->item(0);
        if ($iframe !== null) {
            $demo_desk = $iframe->getAttribute('data-iframe-src');
        } else {
            $demo_desk = "";
        }

        $html = file_get_contents($link);
        $dom = new DOMDocument();
        @$dom->loadHTML($html);
        $xpath = new DOMXPath($dom);
        $iframe = $xpath->query('//embed[@class="modal-iframe"]')->item(0);
        if ($iframe !== null) {
            $demo_mob = $iframe->getAttribute('data-iframe-mobile-src');
        } else {
            $demo_mob = "";
        }

        $volatility = 0;

        $rtp = 0.0;

        $rtp_low = 0.0;

        $rtp_high = 0.0;

        $max_win = 0.0;

        $img = $game['image'];

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

        require ('insert_values.php');

        require ('inserted_games.php');

}

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