📦 Provider: $provider

";
        print_r($res);
        die;
    }
    */

    foreach ($games as $game) {

        // ===============================
        // SUPPORT SPORTBOOK (NO GAME CODE)
        // ===============================
        $game_code = $game['game_code'] 
            ?? $game['code'] 
            ?? $game['provider_code'] 
            ?? $provider;

        $game_name = $game['game_name'] 
            ?? $game['name'] 
            ?? $game['provider_name'] 
            ?? $provider;

        if (empty($game_code)) {
            $game_code = $provider;
        }

        if (empty($game_name)) {
            $game_name = $provider;
        }

        $game_code = mysqli_real_escape_string($koneksi, $game_code);
        $game_name = mysqli_real_escape_string($koneksi, $game_name);

        // ===============================
        // GAMBAR
        // ===============================
        $image = '';

        $possibleKeys = ['image', 'img', 'icon', 'game_icon', 'thumbnail'];

        foreach ($possibleKeys as $key) {
            if (isset($game[$key])) {

                if (is_string($game[$key]) && !empty($game[$key])) {
                    $image = $game[$key];
                    break;
                }

                if (is_array($game[$key])) {
                    foreach ($game[$key] as $imgVal) {
                        if (is_string($imgVal) && !empty($imgVal)) {
                            $image = $imgVal;
                            break 2;
                        }
                    }
                }
            }
        }

        // fallback scan semua field
        if (empty($image)) {
            foreach ($game as $val) {

                if (is_array($val)) {
                    foreach ($val as $subVal) {
                        if (is_string($subVal) && strpos($subVal, 'http') !== false) {
                            $image = $subVal;
                            break 2;
                        }
                    }
                }

                if (is_string($val) && strpos($val, 'http') !== false) {
                    $image = $val;
                    break;
                }
            }
        }

        $image = mysqli_real_escape_string($koneksi, $image);

        // ===============================
        // GAME TYPE
        // ===============================
        if (in_array($provider, ['M9BET','IBC','FBSPORT','DIGITAIN','CMDSPORTSBOOK'])) {
            $game_type = 'sportbook';
        } else {
            $game_type = $game['game_type'] 
                ?? $game['gameType'] 
                ?? $game['type'] 
                ?? 'slot';
        }

        $game_type = mysqli_real_escape_string($koneksi, $game_type);

        // ===============================
        // STATUS
        // ===============================
        $status = 'active';

        // ===============================
        // CEK DUPLIKAT
        // ===============================
        $cek = mysqli_query($koneksi, "SELECT id FROM games WHERE game_code='$game_code'");

        if (mysqli_num_rows($cek) > 0) {

            mysqli_query($koneksi, "
                UPDATE games SET 
                    game_name='$game_name',
                    images='$image',
                    provider='$provider',
                    game_type='$game_type',
                    status_game='$status'
                WHERE game_code='$game_code'
            ");

            echo "♻️ Update: $game_name 
";

        } else {

            mysqli_query($koneksi, "
                INSERT INTO games 
                (game_code, game_name, images, provider, game_type, status_game)
                VALUES
                ('$game_code','$game_name','$image','$provider','$game_type','$status')
            ");

            echo "✅ Insert: $game_name 
";
        }
    }
}

echo "
✅ SELESAI IMPORT GAME";