<?php

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

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

$url = 'https://api.pgsoft.com/Game/GetDefaultAllGame/language/en-US';
$data = shell_exec('curl -s "' . $url . '"');
$games = json_decode($data, true)['dt']['dagl'];

$insertedGames = [];

foreach ($games as $game) {

        $link = $game['gid'];
        $link = "https://www.pgsoft.com/en/games/". $link ."/";

        $name = $game['gn'];

        $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['pgid'];
        // $gameId = $game['gc'];
        
        $demo_desk = "https://m.pg-demo.com/".$gameId."/index.html?ot=ca7094186b309ee149c55c8822e7ecf2&l=en&btt=2&or=13fgngvp=rnwmmkueb=pbz&__hv=2fMEUCIQCpZixa2Qhpj%2BrwjRreHAKote0VCejTqByw0mHcgKl9jwIgDLYfyQRCsRcyIEzB4qCurVxJar8Jg4OTsfE3s4gJvi0%3D&__sv=010401YytG6oT6vOl81kKt_NDwR6QjynyruQC7y9kpWiV7QEg";

        $demo_mob = "https://m.pg-demo.com/".$gameId."/index.html?ot=ca7094186b309ee149c55c8822e7ecf2&l=en&btt=2&or=13fgngvp=rnwmmkueb=pbz&__hv=2fMEUCIQCpZixa2Qhpj%2BrwjRreHAKote0VCejTqByw0mHcgKl9jwIgDLYfyQRCsRcyIEzB4qCurVxJar8Jg4OTsfE3s4gJvi0%3D&__sv=010401YytG6oT6vOl81kKt_NDwR6QjynyruQC7y9kpWiV7QEg";


        $volatility = 0;

        if($name=='Baccarat Deluxe'){$rtp="98.94";}
        else{$rtp = str_replace('%', '', $game["maxrtp"]);}

        $rtp_low = 0.0;

        $rtp_high = 0.0;

        if($name=='Baccarat Deluxe'){$max_win="11";}
        else{$max_win = str_replace('x', '', $game["hrm"]);}

        // if(empty($game['grl']['pgurl']['10'][0])){$img = $game['grl']['pgurl']['21'][0];}
        // else{$img = $game['grl']['pgurl']['10'][0];}

        $found = false;

        foreach ($game['grl']['ourl'] as $item) {
            if (stripos($item['f'], 'games_cover') !== false) {
                $img = "https://www.pgsoft.com" . $item['v'];
                $found = true;
                break; 
            }
        }

        if (!$found) {
            $img = $game['grl']['pgurl']['21'][0];
        }

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

        require ('insert_values.php');

        require ('inserted_games.php');

}

// Manual games that are missing in API response
$manualGames = [
    [
        'id' => 87,
        'name' => 'Treasures of Aztec',
        'img' => 'https://static.freedemo.games//images/games/treasures-of-aztec//treasures-of-aztec-rectangle-390x254.webp',
    ],
    [
        'id' => 106,
        'name' => 'Ways of the Qilin',
        'img' => 'https://static.freedemo.games//images/games/ways-of-the-qilin//ways-of-the-qilin-rectangle-390x254.webp',
    ],
    [
        'id' => 71,
        'name' => 'Caishen Wins',
        'img' => 'https://static.freedemo.games//images/games/caishen-wins//caishen-wins-rectangle-390x254.webp',
    ],
    [
        'id' => 89,
        'name' => 'Lucky Neko',
        'img' => 'https://static.freedemo.games/images/games/lucky-neko/lucky-neko-rectangle-390x254.webp',
    ],
    [
        'id' => 103,
        'name' => 'Crypty Gold',
        'img' => 'https://static.freedemo.games/images/games/crypto-gold/crypto-gold-rectangle-390x254.webp',
    ],
    [
        'id' => 75,
        'name' => 'Ganesha Fortune',
        'img' => 'https://static.freedemo.games//images/games/ganesha-fortune//ganesha-fortune-rectangle-390x254.webp',
    ],
    [
        'id' => 1340277,
        'name' => 'Asgardian Rising',
        'img' => 'https://static.freedemo.games/images/games/asgardian-rising/asgardian-rising-rectangle-390x254.webp',
    ],
];

foreach ($manualGames as $manualGame) {
        $name = $manualGame['name'];
        $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 = $manualGame['id'];
        $demo_desk = "https://m.pg-demo.com/".$gameId."/index.html?ot=ca7094186b309ee149c55c8822e7ecf2&l=en&btt=2&or=13fgngvp=rnwmmkueb=pbz&__hv=2fMEUCIQCpZixa2Qhpj%2BrwjRreHAKote0VCejTqByw0mHcgKl9jwIgDLYfyQRCsRcyIEzB4qCurVxJar8Jg4OTsfE3s4gJvi0%3D&__sv=010401YytG6oT6vOl81kKt_NDwR6QjynyruQC7y9kpWiV7QEg";
        $demo_mob = "https://m.pg-demo.com/".$gameId."/index.html?ot=ca7094186b309ee149c55c8822e7ecf2&l=en&btt=2&or=13fgngvp=rnwmmkueb=pbz&__hv=2fMEUCIQCpZixa2Qhpj%2BrwjRreHAKote0VCejTqByw0mHcgKl9jwIgDLYfyQRCsRcyIEzB4qCurVxJar8Jg4OTsfE3s4gJvi0%3D&__sv=010401YytG6oT6vOl81kKt_NDwR6QjynyruQC7y9kpWiV7QEg";

        $volatility = 0;
        $rtp = 0;
        $rtp_low = 0;
        $rtp_high = 0;
        $max_win = 0;
        $link = '';
        $img = $manualGame['img'];

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

        require ('insert_values.php');
        require ('inserted_games.php');
}

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