<?php
ob_start();
session_start();
date_default_timezone_set("Asia/Jakarta");
include('../config/koneksi.php');

$sql_0 = mysqli_query($conn,"SELECT * FROM `tb_seo` WHERE cuid = 1") or die(mysqli_error());
$s0 = mysqli_fetch_array($sql_0);
$urlweb = $s0['urlweb'];

$getProvider = mysqli_query($conn,"SELECT * FROM `tb_tripayapi` WHERE cuid = 1") or die(mysqli_error());
$gp = mysqli_fetch_array($getProvider);
$provider = $gp['provider'];
$urlRequest = $gp['urlRequest'];
$secureLogin = $gp['api_key'];
$secretKey = $gp['secret_key'];

$kabupaten = mysqli_query($conn,"SELECT * FROM `tb_ppplayer` WHERE status = 1 AND provider = 'PragmaticPlay'") or die(mysqli_error($conn));
while($k = mysqli_fetch_array($kabupaten)){
	$userID = $k['userID'];
	$externalPlayerId = $k['externalPlayerId'];

	$params = 'externalPlayerId='.$externalPlayerId.'&secureLogin='.$secureLogin.$secretKey;
    $hashNeed = md5($params);
    $curl = curl_init();
                                                
    curl_setopt_array($curl, array(
        CURLOPT_URL => $urlRequest.'/balance/current',
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_ENCODING => "",
        CURLOPT_MAXREDIRS => 10,
        CURLOPT_TIMEOUT => 0,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        CURLOPT_CUSTOMREQUEST => "POST",
        CURLOPT_POSTFIELDS => "secureLogin=".$secureLogin."&externalPlayerId=".$externalPlayerId."&hash=".$hashNeed,
        CURLOPT_HTTPHEADER => array(
            "Content-Type: application/x-www-form-urlencoded",
            "Cache-Control: no-cache"
        ),
    ));
                                                           
    $response = curl_exec($curl);
    //echo $response;
    curl_close($curl);
    $hasil = json_decode($response, true);
    $newSaldo = $hasil['balance'];
    $update = mysqli_query($conn,"UPDATE `tb_ppplayer` SET `balance` = '$newSaldo' WHERE userID = '$userID' AND provider = 'PragmaticPlay'") or die(mysqli_error());
}
?>