Eggy Retro Quest - Full Diagnostics

Read-only checker for login/session, SQL bridge, save persistence, claimed rewards, Eggy Gold, rank XP, and browser/API state.

Core Status

DB bridgeOK /var/www/vhosts/eggy.net/httpdocs/retro/gamev5/api/_db.php
PDO connectedOK
Detected usernameguest GUEST
Detected user IDempty
Session keys
[
    "after_client_login"
]

Current Account

{
    "user_row": null,
    "rank": {
        "username": "guest",
        "user_id": null,
        "xp": 0,
        "level": 1,
        "title": "Novice",
        "next_xp": 2500,
        "to_go": 2500,
        "pct": 0,
        "eggy_gold": 0
    }
}

Required SQL Tables / Columns

TableStatusMissing Required ColumnsFound Columns
usersOK noneid, username, password, created_at, golden_spins, platinum_spins, free_platinum_claimed, daily_spins_used, daily_spins_reset_at, referral_code, referred_by_user_id, account_standing, is_suspended, suspension_reason, suspension_until, suspension_is_permanent, secret_word_hash, secret_word_plain, xp, level, avatar, daily_mission_date, mission_spin_count, mission_spin_claimed, mission_golden_count, mission_golden_claimed, mission_platinum_count, mission_platinum_claimed, avatar_frame, cash_balance, total_cash_earned, total_cash_withdrawn, golden_eggs, lifetime_golden_spins, mystery_wins, arcade_xp, arcade_level, avatar_path, avatar_choice, puzzle_trade_success, puzzle_trade_rating, puzzle_streak_days, puzzle_last_drop_date, regular_spins, regular_spins_last_refill, puzzle_pity_counter, daily_free_spins, daily_free_spins_last_refill, onboarding_seen, bonus_meter, claimed_free_platinum, avatar_updated_at, snowballs, watering_cans, is_rpg_bot, bot_created_at, eggy_gold
eggy_retro_savesOK noneusername, user_id, save_json, updated_at, x, y, map, zone_type, coins, xp, level, rank, inventory, achievements, version, world1_complete, town_unlocked, completed_levels_json, current_spawn_zone
eggy_retro_statsOK noneusername, user_id, steps, wins, talks, grass, eggy_gold_found, egglings, buildings, areas_visited, items_found, monster_contacts, updated_at, current_zone, current_inside, player_x, player_y, facing
eggy_retro_achievement_claimsOK noneid, username, user_id, achievement_id, achievement_name, rarity, eggy_gold_awarded, claimed_at, rank_xp_awarded, created_at
eggy_retro_collected_itemsOK noneid, username, user_id, item_key, area_id, inside, item_name, reward_type, reward_amount, collected_at, amount
eggy_retro_gold_logOK noneid, username, user_id, achievement_id, amount, created_at, source, source_ref
eggy_user_rank_profileOK noneuser_id, total_xp, global_rank, prestige_level, prestige_rank_level, unclaimed_rank_rewards, claimed_rank_rewards, current_title, current_badge_image, last_rank_up_at, created_at, updated_at
eggy_user_xp_logOK noneid, user_id, xp_amount, source, source_ref, note, rank_before, rank_after, created_at

SQL Save Row

ExistsOK
Updated2026-05-23 15:40:00
JSON bytes553
DecodeOK
{
    "areaId": null,
    "inside": null,
    "player": [],
    "coins": null,
    "collectedWorldItems_count": 0,
    "claimedAchievementRewards_count": 0,
    "visited_count": 0,
    "saved_user": null,
    "saved_at": null
}

Stats / Collected / File Fallback

{
    "stats_row": {
        "username": "guest",
        "user_id": null,
        "steps": 0,
        "wins": 0,
        "talks": 0,
        "grass": 0,
        "eggy_gold_found": 35,
        "egglings": 1,
        "buildings": 0,
        "areas_visited": 1,
        "items_found": 0,
        "monster_contacts": 0,
        "updated_at": "2026-05-23 15:40:00",
        "current_zone": 0,
        "current_inside": 0,
        "player_x": 553,
        "player_y": 430,
        "facing": "down"
    },
    "collected_items_table_count": 0,
    "file_fallback_save": null
}

Recent Achievement Claims

[]

Recent Eggy Gold Logs

[]

Browser/API Live Probe

This checks what the browser sees while logged in. It does not call the save API or claim API, so it will not overwrite your save or award anything.

Open server JSON
Not run yet.

What to look for

GUESTIf username is guest here, the game/API is loading before the account session is recognised, or this debug URL is on the wrong subdomain/session.
NO SAVEIf SQL save row is missing after playing and refreshing, save_progress.php is not receiving or writing the game state.
ITEMS RESETIf save JSON has collectedWorldItems_count as 0 after collecting coins/items, the frontend is not serialising collected items or save API is being overwritten by an old local state.
GOLD DUPESIf eggy_gold_found in stats goes backwards or save JSON coins resets, gold can be credited again. The fix is to preserve max counters and item IDs server-side.