Gagal mengambil daftar provider dari API SGX.
");
}
// ==========================================
// 2. FORM TAMPILAN DASHBOARD UTAMA
// ==========================================
echo "[Error] Data provider tidak valid.
";
exit;
}
echo "";
echo "[INFO] Menghubungi API SGX Center...
";
echo "[INFO] Target Provider:
{$provider_name} ({$provider_code})";
echo "--------------------------------------------------
";
$response_raw = $SGX->getgames($provider_code);
$response = json_decode($response_raw, true);
if (is_array($response) && isset($response['status']) && $response['status'] == 200) {
// 🔹 SMART AUTO-DETECT STRUKTUR DATA GAME (Mendukung Slot & Sportsbook)
$game_list = [];
if (isset($response['data']['games']) && is_array($response['data']['games'])) {
// Jalur Biasa: Jika ada sub-array 'games' (Umumnya tipe SLOT)
$game_list = $response['data']['games'];
} elseif (isset($response['data']) && is_array($response['data']) && !isset($response['data']['provider_code'])) {
// Jalur Alternatif: Jika data berbentuk list array langsung di dalam 'data'
$game_list = $response['data'];
} elseif (isset($response['data']) && is_array($response['data']) && isset($response['data']['provider_code'])) {
// Jalur Sportsbook/Casino: Jika 'data' bukan berupa list melainkan langsung 1 baris objek data provider itu sendiri
$game_list = [$response['data']];
} else {
// Fallback terakhir, jadikan response utama pembungkusnya
$game_list = $response;
}
if (!empty($game_list) && is_array($game_list)) {
$stmt = $koneksi->prepare("
INSERT INTO tb_game
(provider_name, game_provider, game_name, game_code, game_type, game_image, game_status, seq, source)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
game_name = VALUES(game_name),
game_type = VALUES(game_type),
game_image = VALUES(game_image),
game_status = VALUES(game_status)
");
$inserted_count = 0;
foreach ($game_list as $index => $game) {
// Lewati elemen status bawaan json
if (in_array($index, ['status', 'msg', 'message', 'code', 'error']) || !is_array($game)) {
continue;
}
// Pemetaan penamaan key item game
$game_name = $game['game_name'] ?? $game['name'] ?? $provider_name;
$game_code = $game['game_code'] ?? $game['code'] ?? $game['provider_code'] ?? '';
$game_type = $game['game_type'] ?? $game['type'] ?? 'SPORTS';
$game_image = $game['game_image'] ?? $game['image'] ?? $game['provider_image'] ?? '';
$game_status = "1";
$source = "SGX";
$seq = ($index === 0 || !is_numeric($index)) ? 1 : $index + 1;
if (empty($game_code)) {
continue;
}
$stmt->bind_param(
"sssssssis",
$provider_name,
$provider_code,
$game_name,
$game_code,
$game_type,
$game_image,
$game_status,
$seq,
$source
);
$stmt->execute();
$inserted_count++;
}
$stmt->close();
echo "
[SUKSES] Berhasil memproses total {$inserted_count} data game untuk {$provider_name}!";
echo "[INFO] Sinkronisasi database selesai 100%.
";
} else {
echo "
[WARNING] Daftar game kosong atau tidak ada data aktif.";
}
} else {
$msg_error = $response['message'] ?? $response['msg'] ?? 'Format Respons API Salah / RTO';
echo "
[GAGAL] API menolak permintaan. Alasan: {$msg_error}";
echo "
Raw JSON Balikan:".htmlspecialchars($response_raw)."
";
}
echo "