{
    "ok": true,
    "summary": {
        "guilds": 2,
        "members": 2,
        "join_requests": 0,
        "active_wars": 0,
        "bot_actions": 3,
        "announcements": 0
    },
    "leaderboards": {
        "guilds": [
            {
                "id": "1",
                "name": "Up da Wahs",
                "level": "1",
                "xp": "25",
                "glory_points": "3",
                "members": "1"
            },
            {
                "id": "2",
                "name": "BushFooty",
                "level": "1",
                "xp": "6",
                "glory_points": "3",
                "members": "1"
            }
        ],
        "members": [
            {
                "guild_id": "1",
                "guild_name": "Up da Wahs",
                "display_name": "aussiewarrior",
                "role": "Owner",
                "donated_coins": "0",
                "glory_contributed": "0"
            },
            {
                "guild_id": "2",
                "guild_name": "BushFooty",
                "display_name": "BushBaher",
                "role": "Owner",
                "donated_coins": "0",
                "glory_contributed": "0"
            }
        ]
    },
    "qa": {
        "checks": [
            {
                "key": "table_guilds",
                "label": "guilds table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_members",
                "label": "guild_members table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_join_requests",
                "label": "guild_join_requests table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_chat_messages",
                "label": "guild_chat_messages table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_donations",
                "label": "guild_donations table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_wars",
                "label": "guild_wars table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_profiles",
                "label": "guild_profiles table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_activity_feed",
                "label": "guild_activity_feed table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_announcements",
                "label": "guild_announcements table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_treasury_goals",
                "label": "guild_treasury_goals table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_war_challenges",
                "label": "guild_war_challenges table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_war_score_events",
                "label": "guild_war_score_events table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_league_seasons",
                "label": "guild_league_seasons table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_league_standings",
                "label": "guild_league_standings table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_tournament_brackets",
                "label": "guild_tournament_brackets table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_bot_profiles",
                "label": "guild_bot_profiles table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "table_guild_bot_actions",
                "label": "guild_bot_actions table",
                "status": "green",
                "message": "Installed"
            },
            {
                "key": "orphan_members",
                "label": "Orphan active members",
                "status": "green",
                "message": "0 orphan rows"
            },
            {
                "key": "owner_membership",
                "label": "Owner membership sync",
                "status": "green",
                "message": "0 guilds missing active owner member row"
            },
            {
                "key": "member_cap",
                "label": "10-member cap safety",
                "status": "green",
                "message": "0 guilds over cap"
            }
        ],
        "status": "green",
        "red": 0,
        "amber": 0,
        "generated_at": "2026-07-05 14:30:57"
    },
    "recent_activity": [
        {
            "id": "7",
            "guild_id": "2",
            "actor_user_id": "907",
            "activity_type": "mission_progress",
            "title": "Guild mission progress",
            "body": "War Readiness Week: 2/100",
            "meta_json": "{\"mission_key\":\"weekly_war_readiness\",\"period_key\":\"2026-W27\"}",
            "visibility": "guild",
            "created_at": "2026-07-05 01:39:49",
            "guild_name": "BushFooty",
            "display_name": "BushBaher"
        },
        {
            "id": "6",
            "guild_id": "2",
            "actor_user_id": "907",
            "activity_type": "mission_progress",
            "title": "Guild mission progress",
            "body": "War Readiness Week: 1/100",
            "meta_json": "{\"mission_key\":\"weekly_war_readiness\",\"period_key\":\"2026-W27\"}",
            "visibility": "guild",
            "created_at": "2026-07-05 01:39:42",
            "guild_name": "BushFooty",
            "display_name": "BushBaher"
        },
        {
            "id": "5",
            "guild_id": "2",
            "actor_user_id": "907",
            "activity_type": "mission_progress",
            "title": "Guild mission progress",
            "body": "Battle Together: 1/20",
            "meta_json": "{\"mission_key\":\"daily_battle_points\",\"period_key\":\"2026-07-05\"}",
            "visibility": "guild",
            "created_at": "2026-07-05 01:39:17",
            "guild_name": "BushFooty",
            "display_name": "BushBaher"
        },
        {
            "id": "4",
            "guild_id": "2",
            "actor_user_id": "907",
            "activity_type": "war_challenge",
            "title": "War challenge sent",
            "body": "Challenge sent to Up da Wahs",
            "meta_json": "{\"challenge_id\":1,\"target_guild_id\":1}",
            "visibility": "guild",
            "created_at": "2026-07-05 01:36:08",
            "guild_name": "BushFooty",
            "display_name": "BushBaher"
        },
        {
            "id": "1",
            "guild_id": "1",
            "actor_user_id": "904",
            "activity_type": "bot_war_scout",
            "title": "Guild bot action",
            "body": "Bot scouted a future guild war target.",
            "meta_json": "{\"bot\":\"Scout Bot\",\"behaviour\":\"war_scout\",\"guild\":\"Up da Wahs\"}",
            "visibility": "guild",
            "created_at": "2026-07-03 18:53:11",
            "guild_name": "Up da Wahs",
            "display_name": "aussiewarrior"
        },
        {
            "id": "2",
            "guild_id": "1",
            "actor_user_id": "904",
            "activity_type": "bot_donation",
            "title": "Guild bot donation",
            "body": "Bot donated coins to guild treasury.",
            "meta_json": "{\"bot\":\"Treasury Bot\",\"behaviour\":\"donor\",\"guild\":\"Up da Wahs\"}",
            "visibility": "guild",
            "created_at": "2026-07-03 18:53:11",
            "guild_name": "Up da Wahs",
            "display_name": "aussiewarrior"
        },
        {
            "id": "3",
            "guild_id": "1",
            "actor_user_id": "904",
            "activity_type": "bot_coach_chat",
            "title": "Guild bot action",
            "body": "Bot posted guild encouragement.",
            "meta_json": "{\"bot\":\"Coach Bot\",\"behaviour\":\"coach_chat\",\"guild\":\"Up da Wahs\"}",
            "visibility": "guild",
            "created_at": "2026-07-03 18:53:11",
            "guild_name": "Up da Wahs",
            "display_name": "aussiewarrior"
        }
    ],
    "maintenance_preview": {
        "next_tick": "Run maintenance to update wars, standings and bots."
    },
    "ux_qa": {
        "status": "green",
        "red_count": 0,
        "amber_count": 0,
        "checks": [
            {
                "key": "guild_hq_route",
                "status": "green",
                "message": "Web route /guilds/hq is registered in index.php."
            },
            {
                "key": "guilds_table",
                "status": "green",
                "message": "Base guilds table exists."
            },
            {
                "key": "guild_members_table",
                "status": "green",
                "message": "Guild members table exists."
            },
            {
                "key": "guild_profiles_table",
                "status": "green",
                "message": "Advanced guild profiles table exists."
            },
            {
                "key": "guild_activity_feed_table",
                "status": "green",
                "message": "Guild activity feed table exists."
            },
            {
                "key": "guild_announcements_table",
                "status": "green",
                "message": "Guild announcements table exists."
            },
            {
                "key": "guild_treasury_table",
                "status": "green",
                "message": "Guild treasury goal table exists."
            },
            {
                "key": "guild_wars_table",
                "status": "green",
                "message": "Guild wars table exists."
            },
            {
                "key": "guild_league_table",
                "status": "green",
                "message": "Guild league tables exist."
            },
            {
                "key": "guild_bot_table",
                "status": "green",
                "message": "Guild bot tables exist."
            },
            {
                "key": "guild_css_classes",
                "status": "green",
                "message": "Premium guild CSS is present."
            },
            {
                "key": "guild_nav_link",
                "status": "green",
                "message": "Guild HQ is visible in the main player navigation."
            },
            {
                "key": "guild_hard_resolver",
                "status": "green",
                "message": "Phase 23.13 auth-aware hard guild membership resolver is installed."
            }
        ],
        "generated_at": "2026-07-05 14:30:57",
        "version": "4.2.1-social-hub-dashboard-upgrade"
    }
}