<?php

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

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

$curlCommand = "curl -X POST 'https://www.playngo.com/_api/cloud-data/v1/wix-data/collections/query' -H 'Content-Type: application/json' --data-raw '{\"collectionName\":\"game-items\",\"dataQuery\":{\"filter\":{},\"paging\":{\"offset\":0,\"limit\":1000},\"fields\":[]},\"options\":{},\"includeReferencedItems\":[],\"segment\":\"LIVE\",\"appId\":\"c6beae7e-471f-4612-82a9-f66b48c9cd71\"}' -H 'Authorization: wixcode-pub.a5d828400efa9089daed22a928fb8b077947c7bf.eyJpbnN0YW5jZUlkIjoiMWNiNmJmNjktYzk0ZS00YTQ4LWIzZjUtZGU5YmUzMTA2MzBiIiwiaHRtbFNpdGVJZCI6IjBkZWM0YmVmLWVkZDItNGQzZC04OWM0LTE5OWZhNDgwNGY5NCIsInVpZCI6bnVsbCwicGVybWlzc2lvbnMiOm51bGwsImlzVGVtcGxhdGUiOmZhbHNlLCJzaWduRGF0ZSI6MTY5NzcyMDM2ODk0NCwiYWlkIjoiNDVhNjdiMjItYzI2Ni00MjU3LTk5NTQtZjE4ZWU0MzNkNmJlIiwiYXBwRGVmSWQiOiJDbG91ZFNpdGVFeHRlbnNpb24iLCJpc0FkbWluIjpmYWxzZSwibWV0YVNpdGVJZCI6ImY5NGNkMmJkLTI5NmEtNGNhYy04NmQ2LWEzMmFhNTlmMDBjOSIsImNhY2hlIjpudWxsLCJleHBpcmF0aW9uRGF0ZSI6bnVsbCwicHJlbWl1bUFzc2V0cyI6Ikhhc0RvbWFpbixBZHNGcmVlLFNob3dXaXhXaGlsZUxvYWRpbmciLCJ0ZW5hbnQiOm51bGwsInNpdGVPd25lcklkIjoiNzA3MDlhNGEtMzQzNy00YzliLTgzYTgtNzIzNGJiNWEyZjk2IiwiaW5zdGFuY2VUeXBlIjoicHViIiwic2l0ZU1lbWJlcklkIjpudWxsLCJwZXJtaXNzaW9uU2NvcGUiOm51bGwsImxvZ2luQWNjb3VudElkIjpudWxsLCJpc0xvZ2luQWNjb3VudE93bmVyIjpudWxsfQ=='";

$result = shell_exec($curlCommand);

if ($result === false) {
} else {
    $games = json_decode($result, true)['items'];
}

$insertedGames = [];

foreach ($games as $game) {

        $link = "";

        $name = $game['title'];

        $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);

        $demo_desk = $game['iFrameMobile'];

        $demo_mob = $game['iFrameMobile'];

        $volatility = 0;

        $rtp = 0.0;

        $rtp_low = 0.0;

        $rtp_high = 0.0;

        $max_win = 0.0;

        $img = $game['gamesPreview'];
        $img = str_replace("wix:image://v1/", "", $img);
        $slash=explode("/", $img);
        $code=count($slash)-2;
        $img=$slash[$code];
        $img="https://static.wixstatic.com/media/".$img;

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

        require ('insert_values.php');

        require ('inserted_games.php');

}

/*
curl -X POST 'https://www.playngo.com/_api/cloud-data/v1/wix-data/collections/query' -H 'Content-Type: application/json' --data-raw '{"collectionName":"game-items","dataQuery":{"filter":{},"paging":{"offset":0,"limit":1000},"fields":[]},"options":{},"includeReferencedItems":[],"segment":"LIVE","appId":"c6beae7e-471f-4612-82a9-f66b48c9cd71"}' -H 'Authorization: wixcode-pub.a5d828400efa9089daed22a928fb8b077947c7bf.eyJpbnN0YW5jZUlkIjoiMWNiNmJmNjktYzk0ZS00YTQ4LWIzZjUtZGU5YmUzMTA2MzBiIiwiaHRtbFNpdGVJZCI6IjBkZWM0YmVmLWVkZDItNGQzZC04OWM0LTE5OWZhNDgwNGY5NCIsInVpZCI6bnVsbCwicGVybWlzc2lvbnMiOm51bGwsImlzVGVtcGxhdGUiOmZhbHNlLCJzaWduRGF0ZSI6MTY5NzcyMDM2ODk0NCwiYWlkIjoiNDVhNjdiMjItYzI2Ni00MjU3LTk5NTQtZjE4ZWU0MzNkNmJlIiwiYXBwRGVmSWQiOiJDbG91ZFNpdGVFeHRlbnNpb24iLCJpc0FkbWluIjpmYWxzZSwibWV0YVNpdGVJZCI6ImY5NGNkMmJkLTI5NmEtNGNhYy04NmQ2LWEzMmFhNTlmMDBjOSIsImNhY2hlIjpudWxsLCJleHBpcmF0aW9uRGF0ZSI6bnVsbCwicHJlbWl1bUFzc2V0cyI6Ikhhc0RvbWFpbixBZHNGcmVlLFNob3dXaXhXaGlsZUxvYWRpbmciLCJ0ZW5hbnQiOm51bGwsInNpdGVPd25lcklkIjoiNzA3MDlhNGEtMzQzNy00YzliLTgzYTgtNzIzNGJiNWEyZjk2IiwiaW5zdGFuY2VUeXBlIjoicHViIiwic2l0ZU1lbWJlcklkIjpudWxsLCJwZXJtaXNzaW9uU2NvcGUiOm51bGwsImxvZ2luQWNjb3VudElkIjpudWxsLCJpc0xvZ2luQWNjb3VudE93bmVyIjpudWxsfQ=='
*/

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