<?php

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

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

$url1 = 'https://smartsoftgaming.com/WebAPI/api/WebsiteApi/GetCategories';
$data1 = file_get_contents($url1);
$categories = json_decode($data1, true);

// Loop through categories and fetch games for each category
foreach ($categories as $category) {
    $categoryName = $category['categoryName'];
    $url2 = 'https://smartsoftgaming.com/WebAPI/api/WebsiteApi/GetGames?categoryName=' . urlencode($categoryName);
    $data2 = file_get_contents($url2);
    $games = json_decode($data2, true);

    foreach ($games as $game) {

        $link = "";

        $name = $game['displayName'];
        if($name=="WildsAndGods"){$name = "Wilds And Gods";}

        $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['gameName'];
        
        $demo_desk = "https://server.ssg-public.com/SmartSoftGamePlay/authorization.aspx?GameName=".$gameId;

        $demo_mob = $demo_desk;

        $volatility = 0;

        $rtp = 0.0;

        $rtp_low = 0.0;

        $rtp_high = 0.0;

        $max_win = 0.0;

        $img = $game['imagePath'];
        $img = "https://smartsoftgaming.com/fileserver/content/images/".$img;

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

        require ('insert_values.php');

        require ('inserted_games.php');
    }
}

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

?>