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 bridge	OK /var/www/vhosts/eggy.net/httpdocs/games/retro/test/api/_db.php
PDO connected	FAIL
Detected username	guest GUEST
Detected user ID	empty
Session keys	[]

Current Account

{
    "user_row": null,
    "rank": null
}

Required SQL Tables / Columns

Table	Status	Missing Required Columns	Found Columns

SQL Save Row

Exists	FAIL
Updated	empty
JSON bytes	0
Decode	FAIL

{
    "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": null,
    "collected_items_table_count": null,
    "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

GUEST	If 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 SAVE	If SQL save row is missing after playing and refreshing, save_progress.php is not receiving or writing the game state.
ITEMS RESET	If 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 DUPES	If 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.