<?php

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

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

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

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

$html = str_get_html($html_content);

$insertedGames = [];

foreach ($html->find('.elementor-grid-item') as $div) {

        $link = $div->find('.flipbox_content-details .elementor-button-link', 0);
        $link = $link->href;

        $parts = explode('/', rtrim($link, '/'));
        $name = end($parts);
        $name = preg_replace_callback('/\b(\w+)\b/', function ($matches) {
            return ucfirst(strtolower($matches[1]));
        }, $name);
        $name = str_replace("-", " ", $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);

        $demo_desk = $div->find('.flipbox_content-details .elementor-button-link', 1);
        $demo_desk = $demo_desk->href;
        $demo_desk = str_replace("&amp;", "&", $demo_desk);

        $demo_mob = $demo_desk;

        $volatility = 0;

        $rtp = 0.0;

        $rtp_low = 0.0;

        $rtp_high = 0.0;

        $max_win = 0;

        $img = $div->find('.flipbox_content-image', 0);
        $img = $img->getAttribute('src');
        $img = str_replace("&#215;", "×", $img);
        $img = str_replace("&#xD7;", "×", $img);
        $img = str_replace("&times;", "×", $img);

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

        require ('insert_values.php');

        require ('inserted_games.php');

}

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