{
    "ok": true,
    "phase": "40.51",
    "modes": [
        {
            "id": "1",
            "slug": "quick_match",
            "name": "Quick Match",
            "engine_type": "hybrid",
            "description": "Casual full match plus card battle. Basic rewards and safe testing mode.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":160,\"loss_coins\":60,\"draw_coins\":95,\"win_xp\":140,\"loss_xp\":65,\"draw_xp\":95}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "2",
            "slug": "ranked_match",
            "name": "Ranked Match",
            "engine_type": "hybrid",
            "description": "ELO-style ranked match with stronger rewards and visual rating movement.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":240,\"loss_coins\":80,\"draw_coins\":130,\"win_xp\":220,\"loss_xp\":85,\"draw_xp\":150,\"rating_win\":25,\"rating_loss\":-15,\"rating_draw\":3}",
            "rating_enabled": "1",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "3",
            "slug": "card_duel",
            "name": "Turn-Based Duel",
            "engine_type": "card",
            "description": "Best-of-3 strategic card battle using position groups and stat combinations.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":120,\"loss_coins\":35,\"draw_coins\":70,\"win_xp\":100,\"loss_xp\":40,\"draw_xp\":70}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "4",
            "slug": "stadium_battle",
            "name": "Stadium Battle",
            "engine_type": "match",
            "description": "Full 80-minute stadium control battle. Awards stadium points, ownership pressure and live-ops progress.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":260,\"loss_coins\":95,\"draw_coins\":145,\"win_xp\":240,\"loss_xp\":90,\"draw_xp\":155}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-07-01 02:24:34",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "5",
            "slug": "guild_war_placeholder",
            "name": "Guild War Scrimmage",
            "engine_type": "match",
            "description": "Guild-linked battle mode. Feeds Guild missions, contribution, glory and war momentum using the standalone Guild core loop.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":230,\"loss_coins\":85,\"draw_coins\":130,\"win_xp\":235,\"loss_xp\":90,\"draw_xp\":145}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-07-01 02:24:34",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "6",
            "slug": "tournament_placeholder",
            "name": "Tournament Qualifier",
            "engine_type": "match",
            "description": "Tournament-ready qualifier match for knockout/finals battle flow and release QA.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":230,\"loss_coins\":80,\"draw_coins\":130,\"win_xp\":230,\"loss_xp\":85,\"draw_xp\":140}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-07-01 02:24:34",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "7",
            "slug": "guild_war",
            "name": "Guild War",
            "engine_type": "match",
            "description": "Primary Guild War battle mode. Results feed Guild missions, contribution score, war readiness, glory and activity feed.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":260,\"loss_coins\":95,\"draw_coins\":150,\"win_xp\":270,\"loss_xp\":105,\"draw_xp\":165}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-07-01 02:24:34",
            "updated_at": "2026-07-05 14:50:45"
        },
        {
            "id": "8",
            "slug": "tournament",
            "name": "Tournament Match",
            "engine_type": "match",
            "description": "Tournament match mode for live brackets, finals pressure and knockout battle presentation.",
            "entry_rules_json": null,
            "reward_rules_json": "{\"win_coins\":250,\"loss_coins\":90,\"draw_coins\":140,\"win_xp\":250,\"loss_xp\":95,\"draw_xp\":150}",
            "rating_enabled": "0",
            "stamina_enabled": "1",
            "is_enabled": "1",
            "created_at": "2026-07-01 02:24:34",
            "updated_at": "2026-07-05 14:50:45"
        }
    ],
    "guild": {
        "ok": true,
        "phase": "40.53",
        "version": "4.0.53-battle-guild-deep-enhancement-integration",
        "has_guild": true,
        "user_id": 904,
        "guild_id": 1,
        "guild_name": "Up da Wahs",
        "role": "Owner",
        "source": "guild_members.direct",
        "route_canary": "GuildStandaloneController::index phase40.55 qa-cron-api-ui",
        "core_power": 181,
        "core_grade": "Foundation",
        "mission_percent": 0,
        "perk_percent": 0,
        "war_momentum": 7,
        "war_grade": "Cold",
        "meta_power": 0,
        "meta_grade": "Building",
        "deep_power": 140,
        "deep_grade": "Foundation",
        "guild_tokens": 0,
        "war_prep_ready": 0,
        "equipped_boost": [],
        "stadium_buffs": [],
        "guild_badges": [],
        "season_division": "Foundation",
        "war_ladder_division": "foundation",
        "daily_battle_mission": {
            "id": "1",
            "mission_key": "daily_battle_points",
            "name": "Battle Together",
            "description": "Score guild mission progress from matches, card battles, war scoring and daily gameplay.",
            "cadence": "daily",
            "action_key": "battle_points",
            "target_value": 20,
            "reward_xp": "300",
            "reward_glory": "120",
            "reward_coins": "250",
            "sort_order": "10",
            "is_active": "1",
            "created_at": "2026-07-04 15:30:25",
            "updated_at": "2026-07-04 15:30:25",
            "period_key": "2026-07-05",
            "current_value": 0,
            "remaining": 20,
            "percent": 0,
            "status": "active",
            "reward": {
                "guild_xp": 300,
                "glory": 120,
                "coins": 250,
                "player_coins": 50,
                "player_xp": 60
            },
            "can_claim": false
        },
        "weekly_war_mission": {
            "id": "4",
            "mission_key": "weekly_war_readiness",
            "name": "War Readiness Week",
            "description": "Build weekly readiness through war points, active members and bot support.",
            "cadence": "weekly",
            "action_key": "war_points",
            "target_value": 100,
            "reward_xp": "1200",
            "reward_glory": "500",
            "reward_coins": "1000",
            "sort_order": "40",
            "is_active": "1",
            "created_at": "2026-07-04 15:30:25",
            "updated_at": "2026-07-04 15:30:25",
            "period_key": "2026-W27",
            "current_value": 0,
            "remaining": 100,
            "percent": 0,
            "status": "active",
            "reward": {
                "guild_xp": 1200,
                "glory": 500,
                "coins": 1000,
                "player_coins": 200,
                "player_xp": 240
            },
            "can_claim": false
        },
        "unlocked_perks": [],
        "battle_boosts": {
            "xp_bonus": 0,
            "war_bonus_percent": 0,
            "academy_bonus_percent": 0,
            "summary": "Unlock Guild perks to boost battle value."
        },
        "next_actions": [
            "Contribute to Battle Together",
            "Contribute to Pack Room Energy",
            "Contribute to Treasury Drive",
            "Contribute to War Readiness Week",
            "Unlock Clubhouse Boost"
        ],
        "available_modes": [
            "guild_war",
            "guild_war_placeholder"
        ],
        "cta": "Push Guild War",
        "page": {
            "ok": true,
            "phase": "40.55",
            "version": "4.0.55-guild-qa-cron-api-ui-polish",
            "route_canary": "GuildStandaloneController::index phase40.55 qa-cron-api-ui",
            "controller_user_id": 904,
            "auth_id": 904,
            "identity": {
                "ok": true,
                "user_id": 904,
                "source": "Auth::id",
                "user": {
                    "id": 904,
                    "email": "pauldaley@whitelinefever.com",
                    "display_name": "aussiewarrior",
                    "status": "active",
                    "timezone": "Australia/Brisbane",
                    "avatar_path": null,
                    "banner_path": null,
                    "last_login_at": "2026-07-05 06:48:55",
                    "created_at": "2026-06-27 01:46:10",
                    "updated_at": "2026-07-05 06:48:55"
                },
                "diagnostic": [],
                "candidate_sources": [
                    "Auth::id",
                    "session.user_id",
                    "session.auth_user_id",
                    "session.current_user_id",
                    "session.rlcg_user_id",
                    "session.user.id",
                    "session.user.user_id",
                    "cookie.RLCG_AUTH_HINT"
                ],
                "session_name": "RLCGSESSID",
                "session_id_prefix": "da233125"
            },
            "user": {
                "id": 904,
                "email": "pauldaley@whitelinefever.com",
                "display_name": "aussiewarrior",
                "status": "active",
                "timezone": "Australia/Brisbane",
                "avatar_path": null,
                "banner_path": null,
                "last_login_at": "2026-07-05 06:48:55",
                "created_at": "2026-06-27 01:46:10",
                "updated_at": "2026-07-05 06:48:55"
            },
            "wallet": {
                "coins": 9567,
                "gems": 0,
                "xp": 7655,
                "level": 8
            },
            "has_guild": true,
            "in_guild": true,
            "guild_id": 1,
            "guild_name": "Up da Wahs",
            "guild": {
                "id": 1,
                "name": "Up da Wahs",
                "slug": "up-da-wahs",
                "description": "Oh Ah Up da Wahs",
                "visibility": "public",
                "status": "active",
                "level": 1,
                "xp": 25,
                "glory_points": 3,
                "member_limit": 10,
                "owner_user_id": 904,
                "created_at": "2026-06-27 03:28:41",
                "updated_at": "2026-07-03 08:53:11",
                "banner_path": null,
                "emblem_path": null,
                "role": "Owner",
                "member_status": "active"
            },
            "guild_source": "guild_members.direct",
            "membership_gate": {
                "ok": true,
                "user_id": 904,
                "has_guild": true,
                "in_guild": true,
                "guild_id": 1,
                "guild": {
                    "id": 1,
                    "name": "Up da Wahs",
                    "slug": "up-da-wahs",
                    "description": "Oh Ah Up da Wahs",
                    "visibility": "public",
                    "status": "active",
                    "level": 1,
                    "xp": 25,
                    "glory_points": 3,
                    "member_limit": 10,
                    "owner_user_id": 904,
                    "created_at": "2026-06-27 03:28:41",
                    "updated_at": "2026-07-03 08:53:11",
                    "banner_path": null,
                    "emblem_path": null,
                    "role": "Owner",
                    "member_status": "active"
                },
                "membership": {
                    "id": 1,
                    "guild_id": 1,
                    "user_id": 904,
                    "role": "Owner",
                    "status": "active",
                    "donated_coins": 0,
                    "glory_contributed": 0,
                    "joined_at": "2026-06-27 03:28:41",
                    "updated_at": "2026-07-05 14:49:03",
                    "display_name": "aussiewarrior",
                    "email": "pauldaley@whitelinefever.com"
                },
                "source": "guild_members.direct",
                "repaired": []
            },
            "current_member": {
                "id": 1,
                "guild_id": 1,
                "user_id": 904,
                "role": "Owner",
                "status": "active",
                "donated_coins": 0,
                "glory_contributed": 0,
                "joined_at": "2026-06-27 03:28:41",
                "updated_at": "2026-07-05 14:49:03",
                "display_name": "aussiewarrior",
                "email": "pauldaley@whitelinefever.com"
            },
            "role": "Owner",
            "permissions": {
                "can_manage": true,
                "can_chat": true,
                "can_donate": true,
                "can_leave": false,
                "can_war": true
            },
            "roster": [
                {
                    "id": 1,
                    "user_id": 904,
                    "display_name": "aussiewarrior",
                    "role": "Owner",
                    "status": "active",
                    "coins_contributed": 0,
                    "xp": 0,
                    "joined_at": "2026-06-27 03:28:41"
                }
            ],
            "chat": [
                {
                    "id": 1,
                    "guild_id": 1,
                    "user_id": 904,
                    "body": "Go the Wahs",
                    "status": "visible",
                    "created_at": "2026-06-27 21:46:13",
                    "updated_at": "2026-06-27 21:46:13",
                    "deleted_at": null,
                    "display_name": "aussiewarrior",
                    "email": "pauldaley@whitelinefever.com"
                }
            ],
            "announcements": [],
            "activity": [
                {
                    "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",
                    "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",
                    "display_name": "aussiewarrior"
                },
                {
                    "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",
                    "display_name": "aussiewarrior"
                }
            ],
            "treasury": {
                "total": 0,
                "goals": [],
                "donations": [],
                "recent_donations": [],
                "total_donated": 0
            },
            "wars": {
                "wars": [],
                "active": [],
                "challenges": [
                    {
                        "id": 1,
                        "challenger_guild_id": 2,
                        "target_guild_id": 1,
                        "created_by_user_id": 907,
                        "status": "pending",
                        "message": "Friendly guild war challenge.",
                        "starts_at": "2026-07-05 02:36:08",
                        "ends_at": "2026-07-06 01:36:08",
                        "created_at": "2026-07-05 01:36:08",
                        "updated_at": "2026-07-05 01:36:08",
                        "challenger_name": "BushFooty",
                        "target_name": "Up da Wahs"
                    }
                ],
                "score_events": []
            },
            "join_requests": [],
            "browser_guilds": [
                {
                    "id": "2",
                    "owner_user_id": "907",
                    "name": "BushFooty",
                    "slug": "bushfooty",
                    "description": "Back to the grass roots",
                    "visibility": "public",
                    "status": "active",
                    "emblem_path": null,
                    "banner_path": null,
                    "level": "1",
                    "xp": "6",
                    "glory_points": "3",
                    "member_limit": "10",
                    "settings_json": null,
                    "created_at": "2026-07-04 22:33:42",
                    "updated_at": "2026-07-05 01:39:49",
                    "deleted_at": null,
                    "member_count": "1"
                }
            ],
            "stats": {
                "members": 1,
                "member_limit": 10,
                "level": 1,
                "xp": 25,
                "glory": 3,
                "readiness": 11,
                "grade": "Building",
                "wars": 0,
                "war_challenges": 1,
                "treasury_total": 0,
                "core_power": 181,
                "core_grade": "Foundation",
                "mission_percent": 0,
                "perk_percent": 0,
                "war_momentum": 7,
                "meta_power": 0,
                "meta_grade": "Building",
                "deep_power": 140,
                "deep_grade": "Foundation"
            },
            "render_proof": {
                "phase": "40.55",
                "version": "4.0.55-guild-qa-cron-api-ui-polish",
                "view": "guilds/standalone",
                "controller": "GuildStandaloneController",
                "controller_user_id": 904,
                "guild_id": 1,
                "identity_source": "Auth::id",
                "guild_source": "guild_members.direct",
                "session_name": "RLCGSESSID",
                "session_id_prefix": "da233125",
                "release_wrapper": "RLCG\\Services\\GuildStandaloneReleaseService"
            },
            "debug": {
                "identity": {
                    "ok": true,
                    "user_id": 904,
                    "source": "Auth::id",
                    "user": {
                        "id": 904,
                        "email": "pauldaley@whitelinefever.com",
                        "display_name": "aussiewarrior",
                        "status": "active",
                        "timezone": "Australia/Brisbane",
                        "avatar_path": null,
                        "banner_path": null,
                        "last_login_at": "2026-07-05 06:48:55",
                        "created_at": "2026-06-27 01:46:10",
                        "updated_at": "2026-07-05 06:48:55"
                    },
                    "diagnostic": [],
                    "candidate_sources": [
                        "Auth::id",
                        "session.user_id",
                        "session.auth_user_id",
                        "session.current_user_id",
                        "session.rlcg_user_id",
                        "session.user.id",
                        "session.user.user_id",
                        "cookie.RLCG_AUTH_HINT"
                    ],
                    "session_name": "RLCGSESSID",
                    "session_id_prefix": "da233125"
                },
                "gate": {
                    "ok": true,
                    "user_id": 904,
                    "has_guild": true,
                    "in_guild": true,
                    "guild_id": 1,
                    "guild": {
                        "id": 1,
                        "name": "Up da Wahs",
                        "slug": "up-da-wahs",
                        "description": "Oh Ah Up da Wahs",
                        "visibility": "public",
                        "status": "active",
                        "level": 1,
                        "xp": 25,
                        "glory_points": 3,
                        "member_limit": 10,
                        "owner_user_id": 904,
                        "created_at": "2026-06-27 03:28:41",
                        "updated_at": "2026-07-03 08:53:11",
                        "banner_path": null,
                        "emblem_path": null,
                        "role": "Owner",
                        "member_status": "active"
                    },
                    "membership": {
                        "id": 1,
                        "guild_id": 1,
                        "user_id": 904,
                        "role": "Owner",
                        "status": "active",
                        "donated_coins": 0,
                        "glory_contributed": 0,
                        "joined_at": "2026-06-27 03:28:41",
                        "updated_at": "2026-07-05 14:49:03",
                        "display_name": "aussiewarrior",
                        "email": "pauldaley@whitelinefever.com"
                    },
                    "source": "guild_members.direct",
                    "repaired": []
                },
                "guild_id": 1,
                "session": {
                    "active": true,
                    "name": "RLCGSESSID",
                    "id_prefix": "da233125",
                    "keys": {
                        "user_id": "904",
                        "auth_user_id": "904",
                        "current_user_id": "904",
                        "rlcg_user_id": "904",
                        "user": {
                            "id": 904,
                            "user_id": 904
                        },
                        "rlcg_current_player_id": "904",
                        "rlcg_visible_guild_user_id": "904",
                        "rlcg_last_guild_user_id": "904",
                        "rlcg_profile_viewer_id": "904",
                        "phase4014_profile_viewer_id": "904",
                        "player_id": "904",
                        "account_id": "904",
                        "member_user_id": "904",
                        "rlcg_visible_guild_id": "1",
                        "rlcg_visible_guild_source": "guild_members.direct"
                    }
                },
                "cookies": {
                    "RLCG_AUTH_HINT": "present",
                    "RLCGSESSID": "da2331258cbf54e0686159d4",
                    "RLCG_GUILD_HINT": "present"
                },
                "release": {
                    "phase": "40.55",
                    "version": "4.0.55-guild-qa-cron-api-ui-polish",
                    "user_id": 904,
                    "guild_id": 1,
                    "qa_status": "green",
                    "automation_profiles": 2,
                    "automation_actions": 0,
                    "meta_power": 0,
                    "meta_qa_status": "green"
                }
            },
            "release_stage": true,
            "core_loop_stage": true,
            "profile": {
                "id": 1,
                "guild_id": 1,
                "emblem_key": "shield_green",
                "banner_key": "stadium_neon",
                "motto": "Collect. Compete. Conquer.",
                "region": "Australia",
                "division": "Foundation League",
                "rank_title": "Contender",
                "profile_json": "{\"theme\":\"neon_league\",\"accent\":\"green\"}",
                "created_at": "2026-07-02 08:53:40",
                "updated_at": "2026-07-02 08:53:40"
            },
            "league": {
                "season": {
                    "id": "1",
                    "season_key": "guild-league-foundation",
                    "name": "Foundation Guild League",
                    "status": "active",
                    "division_count": "4",
                    "starts_at": "2026-07-01 22:53:09",
                    "ends_at": "2026-07-31 22:53:09",
                    "reward_json": "{\"top_1\":{\"coins\":2500,\"glory\":1000},\"top_10\":{\"coins\":500,\"glory\":150}}",
                    "created_at": "2026-07-01 22:53:09",
                    "updated_at": "2026-07-01 22:53:09"
                },
                "standings": [
                    {
                        "id": 1,
                        "season_id": 1,
                        "guild_id": 1,
                        "division": "Foundation",
                        "points": 0,
                        "wins": 0,
                        "losses": 0,
                        "draws": 0,
                        "wars_played": 0,
                        "rank_position": 0,
                        "updated_at": "2026-07-02 08:53:40",
                        "guild_name": "Up da Wahs"
                    },
                    {
                        "id": 2,
                        "season_id": 1,
                        "guild_id": 2,
                        "division": "Foundation",
                        "points": 0,
                        "wins": 0,
                        "losses": 0,
                        "draws": 0,
                        "wars_played": 0,
                        "rank_position": 0,
                        "updated_at": "2026-07-05 01:16:53",
                        "guild_name": "BushFooty"
                    }
                ],
                "mine": {
                    "id": 1,
                    "season_id": 1,
                    "guild_id": 1,
                    "division": "Foundation",
                    "points": 0,
                    "wins": 0,
                    "losses": 0,
                    "draws": 0,
                    "wars_played": 0,
                    "rank_position": 0,
                    "updated_at": "2026-07-02 08:53:40"
                }
            },
            "tournaments": [
                {
                    "id": "1",
                    "season_id": "1",
                    "name": "Foundation Guild Cup",
                    "status": "open",
                    "bracket_json": "{\"type\":\"single_elimination\",\"max_guilds\":16}",
                    "reward_json": "{\"winner\":{\"coins\":5000,\"glory\":2000},\"runner_up\":{\"coins\":1500,\"glory\":500}}",
                    "starts_at": "2026-07-01 22:53:09",
                    "ends_at": "2026-07-15 22:53:09",
                    "created_at": "2026-07-01 22:53:09",
                    "updated_at": "2026-07-01 22:53:09",
                    "entered": false
                }
            ],
            "automations": {
                "profiles": [
                    {
                        "id": 3,
                        "guild_id": 1,
                        "name": "Metro Titans",
                        "persona_key": "donor",
                        "squad_power": 1250,
                        "is_enabled": 1,
                        "created_at": "2026-07-05 10:34:03",
                        "updated_at": "2026-07-05 10:34:03"
                    },
                    {
                        "id": 4,
                        "guild_id": 1,
                        "name": "Harbour Marlins",
                        "persona_key": "recruiter",
                        "squad_power": 1162,
                        "is_enabled": 1,
                        "created_at": "2026-07-05 10:34:03",
                        "updated_at": "2026-07-05 10:34:03"
                    }
                ],
                "recent_actions": [],
                "enabled": 2,
                "last_action": null
            },
            "automation": {
                "ok": true,
                "phase": "40.53",
                "version": "4.0.53-guild-deep-enhancements",
                "guild_id": 1,
                "user_id": 904,
                "score": {
                    "score": 140,
                    "grade": "Foundation",
                    "summary": "HQ, contracts, live events, role depth, war prep, reputation, shop and generated squad support."
                },
                "hq": {
                    "rooms": [
                        {
                            "id": 14,
                            "guild_id": 1,
                            "room_key": "command_room",
                            "name": "Command Room",
                            "description": "Improves generated squad support and coordination.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 280,
                            "buff_key": "support_coordination",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        },
                        {
                            "id": 12,
                            "guild_id": 1,
                            "room_key": "medical_room",
                            "name": "Medical Room",
                            "description": "Improves stamina recovery presentation.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 240,
                            "buff_key": "stamina_recovery",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        },
                        {
                            "id": 10,
                            "guild_id": 1,
                            "room_key": "pack_room",
                            "name": "Pack Room",
                            "description": "Improves shared pack milestone output.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 220,
                            "buff_key": "pack_milestone",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        },
                        {
                            "id": 13,
                            "guild_id": 1,
                            "room_key": "stadium_office",
                            "name": "Stadium Office",
                            "description": "Improves stadium control bonuses.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 260,
                            "buff_key": "stadium_control",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        },
                        {
                            "id": 9,
                            "guild_id": 1,
                            "room_key": "strategy_room",
                            "name": "Strategy Room",
                            "description": "Improves war preparation and scouting.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 250,
                            "buff_key": "war_scouting",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        },
                        {
                            "id": 8,
                            "guild_id": 1,
                            "room_key": "training_room",
                            "name": "Training Room",
                            "description": "Improves battle XP and member development.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 200,
                            "buff_key": "battle_xp",
                            "buff_value": 2,
                            "created_at": "2026-07-05 10:34:02",
                            "updated_at": "2026-07-05 10:34:02",
                            "percent": 0
                        },
                        {
                            "id": 11,
                            "guild_id": 1,
                            "room_key": "treasury_vault",
                            "name": "Treasury Vault",
                            "description": "Improves donation and shop economy capacity.",
                            "level": 1,
                            "current_materials": 0,
                            "upgrade_target": 300,
                            "buff_key": "treasury_bonus",
                            "buff_value": 3,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "percent": 0
                        }
                    ],
                    "level_sum": 7
                },
                "contracts": {
                    "items": [
                        {
                            "id": 6,
                            "guild_id": 1,
                            "contract_key": "raid_pressure",
                            "title": "Raid Pressure",
                            "description": "Push damage into the active guild raid.",
                            "target_value": 1000,
                            "cadence": "weekly",
                            "reward_json": "{\"tokens\":120,\"guild_xp\":300}",
                            "status": "active",
                            "starts_at": null,
                            "ends_at": null,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "user_current": 0,
                            "user_status": "active",
                            "percent": 0
                        },
                        {
                            "id": 5,
                            "guild_id": 1,
                            "contract_key": "donate_cards",
                            "title": "Donate Card Materials",
                            "description": "Feed guild crafting and headquarters growth.",
                            "target_value": 25,
                            "cadence": "weekly",
                            "reward_json": "{\"tokens\":80,\"guild_xp\":180}",
                            "status": "active",
                            "starts_at": null,
                            "ends_at": null,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "user_current": 0,
                            "user_status": "active",
                            "percent": 0
                        },
                        {
                            "id": 4,
                            "guild_id": 1,
                            "contract_key": "win_battles",
                            "title": "Win Battle Orders",
                            "description": "Members combine battle wins for guild tokens.",
                            "target_value": 10,
                            "cadence": "weekly",
                            "reward_json": "{\"tokens\":90,\"guild_xp\":250}",
                            "status": "active",
                            "starts_at": null,
                            "ends_at": null,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "user_current": 0,
                            "user_status": "active",
                            "percent": 0
                        }
                    ],
                    "completed": 0,
                    "total": 3,
                    "percent": 0
                },
                "currency": {
                    "user_tokens": 0,
                    "guild_tokens": 0,
                    "ledger": []
                },
                "shop": {
                    "items": [
                        {
                            "id": "1",
                            "item_key": "guild_common_pack",
                            "name": "Guild Common Pack",
                            "description": "Entry pack reward for loyal members.",
                            "cost_tokens": "120",
                            "unlock_level": "1",
                            "reward_json": "{\"pack\":\"guild_common\"}",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        },
                        {
                            "id": "3",
                            "item_key": "stamina_boost",
                            "name": "Stamina Boost",
                            "description": "Temporary stamina-focused battle boost.",
                            "cost_tokens": "160",
                            "unlock_level": "2",
                            "reward_json": "{\"boost\":\"stamina\"}",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        },
                        {
                            "id": "4",
                            "item_key": "rivalry_banner",
                            "name": "Rivalry Banner",
                            "description": "Cosmetic badge/banner reward.",
                            "cost_tokens": "220",
                            "unlock_level": "2",
                            "reward_json": "{\"cosmetic\":\"rivalry_banner\"}",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        },
                        {
                            "id": "2",
                            "item_key": "guild_rare_pack",
                            "name": "Guild Rare Pack",
                            "description": "Higher value guild pack room reward.",
                            "cost_tokens": "350",
                            "unlock_level": "3",
                            "reward_json": "{\"pack\":\"guild_rare\"}",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        }
                    ],
                    "purchases": []
                },
                "roles": {
                    "rows": [
                        {
                            "id": 55,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "manage_members",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 59,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 60,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "manage_scouting",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 58,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "post_announcements",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 57,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 56,
                            "guild_id": 1,
                            "role_name": "General",
                            "permission_key": "start_wars",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 49,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "manage_members",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 53,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 54,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "manage_scouting",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 52,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "post_announcements",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 51,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "spend_treasury",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 50,
                            "guild_id": 1,
                            "role_name": "Owner",
                            "permission_key": "start_wars",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 61,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 65,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 66,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "manage_scouting",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 64,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "post_announcements",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 63,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 62,
                            "guild_id": 1,
                            "role_name": "Recruiter",
                            "permission_key": "start_wars",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 91,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 95,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 96,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "manage_scouting",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 94,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "post_announcements",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 93,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 92,
                            "guild_id": 1,
                            "role_name": "Rookie",
                            "permission_key": "start_wars",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 79,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 83,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 84,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "manage_scouting",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 82,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "post_announcements",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 81,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 80,
                            "guild_id": 1,
                            "role_name": "Scout",
                            "permission_key": "start_wars",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 67,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 71,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 72,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "manage_scouting",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 70,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "post_announcements",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 69,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "spend_treasury",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 68,
                            "guild_id": 1,
                            "role_name": "Treasurer",
                            "permission_key": "start_wars",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 85,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 89,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 90,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "manage_scouting",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 88,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "post_announcements",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 87,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 86,
                            "guild_id": 1,
                            "role_name": "Veteran",
                            "permission_key": "start_wars",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 73,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "manage_members",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 77,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "manage_recruitment",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 78,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "manage_scouting",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 76,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "post_announcements",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 75,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "spend_treasury",
                            "is_enabled": 0,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 74,
                            "guild_id": 1,
                            "role_name": "War Captain",
                            "permission_key": "start_wars",
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        }
                    ],
                    "roles": {
                        "General": {
                            "manage_members": true,
                            "manage_recruitment": true,
                            "manage_scouting": true,
                            "post_announcements": true,
                            "spend_treasury": false,
                            "start_wars": true
                        },
                        "Owner": {
                            "manage_members": true,
                            "manage_recruitment": true,
                            "manage_scouting": true,
                            "post_announcements": true,
                            "spend_treasury": true,
                            "start_wars": true
                        },
                        "Recruiter": {
                            "manage_members": false,
                            "manage_recruitment": true,
                            "manage_scouting": false,
                            "post_announcements": false,
                            "spend_treasury": false,
                            "start_wars": false
                        },
                        "Rookie": {
                            "manage_members": false,
                            "manage_recruitment": false,
                            "manage_scouting": false,
                            "post_announcements": false,
                            "spend_treasury": false,
                            "start_wars": false
                        },
                        "Scout": {
                            "manage_members": false,
                            "manage_recruitment": false,
                            "manage_scouting": true,
                            "post_announcements": false,
                            "spend_treasury": false,
                            "start_wars": false
                        },
                        "Treasurer": {
                            "manage_members": false,
                            "manage_recruitment": false,
                            "manage_scouting": false,
                            "post_announcements": false,
                            "spend_treasury": true,
                            "start_wars": false
                        },
                        "Veteran": {
                            "manage_members": false,
                            "manage_recruitment": false,
                            "manage_scouting": false,
                            "post_announcements": false,
                            "spend_treasury": false,
                            "start_wars": false
                        },
                        "War Captain": {
                            "manage_members": false,
                            "manage_recruitment": false,
                            "manage_scouting": true,
                            "post_announcements": true,
                            "spend_treasury": false,
                            "start_wars": true
                        }
                    }
                },
                "rivalries": {
                    "history": [],
                    "trophies": []
                },
                "live_events": {
                    "items": [
                        {
                            "id": 1,
                            "event_key": "derby_weekend",
                            "name": "Derby Weekend",
                            "description": "Guild battles and rivalry actions push a weekend prize track.",
                            "event_type": "rivalry",
                            "target_value": 500,
                            "reward_json": "{\"tokens\":150,\"guild_xp\":250}",
                            "status": "active",
                            "starts_at": "2026-07-04 04:43:08",
                            "ends_at": "2026-07-11 04:43:08",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08",
                            "current_value": 0,
                            "progress_target": 500,
                            "progress_status": "active",
                            "percent": 0
                        },
                        {
                            "id": 2,
                            "event_key": "training_camp",
                            "name": "Training Camp",
                            "description": "Every battle and mission pushes shared training gains.",
                            "event_type": "training",
                            "target_value": 350,
                            "reward_json": "{\"tokens\":100,\"guild_xp\":200}",
                            "status": "active",
                            "starts_at": "2026-07-04 04:43:08",
                            "ends_at": "2026-07-11 04:43:08",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08",
                            "current_value": 0,
                            "progress_target": 350,
                            "progress_status": "active",
                            "percent": 0
                        }
                    ],
                    "active": 2
                },
                "reputation": {
                    "current": {
                        "id": 2,
                        "guild_id": 1,
                        "user_id": 904,
                        "loyalty_points": 0,
                        "donations_made": 0,
                        "wars_joined": 0,
                        "raid_damage": 0,
                        "missions_completed": 0,
                        "orders_completed": 0,
                        "mvp_awards": 0,
                        "inactive_warnings": 0,
                        "last_active_at": "2026-07-05 10:34:03",
                        "created_at": "2026-07-05 10:34:03",
                        "updated_at": "2026-07-05 10:34:03",
                        "display_name": "aussiewarrior"
                    },
                    "leaders": [
                        {
                            "id": 2,
                            "guild_id": 1,
                            "user_id": 904,
                            "loyalty_points": 0,
                            "donations_made": 0,
                            "wars_joined": 0,
                            "raid_damage": 0,
                            "missions_completed": 0,
                            "orders_completed": 0,
                            "mvp_awards": 0,
                            "inactive_warnings": 0,
                            "last_active_at": "2026-07-05 10:34:03",
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03",
                            "display_name": "aussiewarrior"
                        }
                    ]
                },
                "recruitment": {
                    "guild_id": 1,
                    "mode": "public",
                    "min_level": 1,
                    "min_squad_power": 0,
                    "auto_accept": 0,
                    "application_prompt": "Tell us how you will help the guild.",
                    "updated_by_user_id": null,
                    "created_at": "2026-07-05 10:34:03",
                    "updated_at": "2026-07-05 10:34:03"
                },
                "notifications": {
                    "unread": 0,
                    "items": []
                },
                "war_prep": {
                    "plans": [],
                    "ready_percent": 0,
                    "current": null
                },
                "boosts": {
                    "available": {
                        "attack_drill": {
                            "name": "Attack Drill",
                            "stat": "attack",
                            "value": 2,
                            "description": "+2 attack-style presentation boost"
                        },
                        "defensive_wall": {
                            "name": "Defensive Wall",
                            "stat": "defense",
                            "value": 2,
                            "description": "+2 defence-style presentation boost"
                        },
                        "stamina_surge": {
                            "name": "Stamina Surge",
                            "stat": "stamina",
                            "value": 2,
                            "description": "+2 stamina-style presentation boost"
                        },
                        "rivalry_focus": {
                            "name": "Rivalry Focus",
                            "stat": "rivalry",
                            "value": 3,
                            "description": "Extra rivalry pressure in guild battles"
                        }
                    },
                    "equipped": []
                },
                "hall_of_fame": {
                    "entries": []
                },
                "automation": {
                    "squads": [
                        {
                            "id": 3,
                            "guild_id": 1,
                            "name": "Metro Titans",
                            "persona_key": "donor",
                            "squad_power": 1250,
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 4,
                            "guild_id": 1,
                            "name": "Harbour Marlins",
                            "persona_key": "recruiter",
                            "squad_power": 1162,
                            "is_enabled": 1,
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        }
                    ],
                    "recent_actions": []
                },
                "name_pool": {
                    "words": [
                        {
                            "id": 66,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Crimson",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 60,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Golden",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 62,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Harbour",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 58,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Iron",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 57,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Northern",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 63,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Outback",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 64,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Prime",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 59,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Rapid",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 61,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Storm",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 65,
                            "guild_id": 1,
                            "category": "adjective",
                            "word": "Wild",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 76,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Chargers",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 70,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Comets",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 73,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Falcons",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 74,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Marlins",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 67,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Raiders",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 75,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Rangers",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 68,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Rovers",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 72,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Sharks",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 69,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Titans",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 71,
                            "guild_id": 1,
                            "category": "noun",
                            "word": "Wolves",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 77,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Brisbane",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 82,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Bush",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 83,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Central",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 78,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Coastal",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 84,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Frontier",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 81,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Metro",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 79,
                            "guild_id": 1,
                            "category": "place",
                            "word": "River",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": 80,
                            "guild_id": 1,
                            "category": "place",
                            "word": "Valley",
                            "is_enabled": 1,
                            "created_by_user_id": 904,
                            "created_at": "2026-07-05 10:34:03"
                        }
                    ],
                    "sample": "Prime Titans"
                },
                "admin_tools": {
                    "installed": true,
                    "installed_count": 14,
                    "total": 14,
                    "guild_id": 1
                },
                "agenda": [
                    "Finish contract orders",
                    "Set war preparation readiness",
                    "Push live event progress",
                    "Upgrade headquarters rooms"
                ],
                "qa": {
                    "status": "green",
                    "missing": [],
                    "installed": 18,
                    "required": 18,
                    "phase": "40.53"
                }
            },
            "leaderboards": {
                "guilds": [
                    {
                        "id": "1",
                        "name": "Up da Wahs",
                        "level": "1",
                        "xp": "25",
                        "glory_points": "3",
                        "member_limit": "10",
                        "members": "1"
                    },
                    {
                        "id": "2",
                        "name": "BushFooty",
                        "level": "1",
                        "xp": "6",
                        "glory_points": "3",
                        "member_limit": "10",
                        "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"
                    }
                ]
            },
            "core_loop": {
                "ok": true,
                "phase": "40.50",
                "version": "4.0.50-guild-core-game-loop",
                "guild_id": 1,
                "user_id": 904,
                "power": {
                    "score": 181,
                    "grade": "Foundation",
                    "summary": "Foundation guild core loop power"
                },
                "missions": {
                    "period_key": "2026-07-05",
                    "weekly_period_key": "2026-W27",
                    "items": [
                        {
                            "id": "1",
                            "mission_key": "daily_battle_points",
                            "name": "Battle Together",
                            "description": "Score guild mission progress from matches, card battles, war scoring and daily gameplay.",
                            "cadence": "daily",
                            "action_key": "battle_points",
                            "target_value": 20,
                            "reward_xp": "300",
                            "reward_glory": "120",
                            "reward_coins": "250",
                            "sort_order": "10",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "period_key": "2026-07-05",
                            "current_value": 0,
                            "remaining": 20,
                            "percent": 0,
                            "status": "active",
                            "reward": {
                                "guild_xp": 300,
                                "glory": 120,
                                "coins": 250,
                                "player_coins": 50,
                                "player_xp": 60
                            },
                            "can_claim": false
                        },
                        {
                            "id": "2",
                            "mission_key": "daily_pack_energy",
                            "name": "Pack Room Energy",
                            "description": "Open packs and add shared energy to your guild core loop.",
                            "cadence": "daily",
                            "action_key": "pack_open",
                            "target_value": 8,
                            "reward_xp": "220",
                            "reward_glory": "80",
                            "reward_coins": "150",
                            "sort_order": "20",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "period_key": "2026-07-05",
                            "current_value": 0,
                            "remaining": 8,
                            "percent": 0,
                            "status": "active",
                            "reward": {
                                "guild_xp": 220,
                                "glory": 80,
                                "coins": 150,
                                "player_coins": 30,
                                "player_xp": 44
                            },
                            "can_claim": false
                        },
                        {
                            "id": "3",
                            "mission_key": "daily_treasury_drive",
                            "name": "Treasury Drive",
                            "description": "Donate coins and help fund guild upgrades.",
                            "cadence": "daily",
                            "action_key": "guild_donation",
                            "target_value": 5,
                            "reward_xp": "200",
                            "reward_glory": "100",
                            "reward_coins": "200",
                            "sort_order": "30",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "period_key": "2026-07-05",
                            "current_value": 0,
                            "remaining": 5,
                            "percent": 0,
                            "status": "active",
                            "reward": {
                                "guild_xp": 200,
                                "glory": 100,
                                "coins": 200,
                                "player_coins": 40,
                                "player_xp": 40
                            },
                            "can_claim": false
                        },
                        {
                            "id": "4",
                            "mission_key": "weekly_war_readiness",
                            "name": "War Readiness Week",
                            "description": "Build weekly readiness through war points, active members and bot support.",
                            "cadence": "weekly",
                            "action_key": "war_points",
                            "target_value": 100,
                            "reward_xp": "1200",
                            "reward_glory": "500",
                            "reward_coins": "1000",
                            "sort_order": "40",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "period_key": "2026-W27",
                            "current_value": 0,
                            "remaining": 100,
                            "percent": 0,
                            "status": "active",
                            "reward": {
                                "guild_xp": 1200,
                                "glory": 500,
                                "coins": 1000,
                                "player_coins": 200,
                                "player_xp": 240
                            },
                            "can_claim": false
                        }
                    ],
                    "completed": 0,
                    "total": 4,
                    "percent": 0
                },
                "perks": {
                    "items": [
                        {
                            "id": "1",
                            "perk_key": "clubhouse_boost",
                            "name": "Clubhouse Boost",
                            "description": "Guild members earn a small XP lift from core activity.",
                            "tier": "1",
                            "required_level": "1",
                            "required_glory": "0",
                            "cost_coins": "0",
                            "effect_json": "{\"xp_boost_percent\": 2}",
                            "sort_order": "10",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "is_unlocked": false,
                            "unlocked_at": null,
                            "effect": {
                                "xp_boost_percent": 2
                            }
                        },
                        {
                            "id": "2",
                            "perk_key": "market_scouts",
                            "name": "Market Scouts",
                            "description": "Guild trading and market squads get better pricing visibility.",
                            "tier": "1",
                            "required_level": "2",
                            "required_glory": "250",
                            "cost_coins": "0",
                            "effect_json": "{\"market_insight\": 1}",
                            "sort_order": "20",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "is_unlocked": false,
                            "unlocked_at": null,
                            "effect": {
                                "market_insight": 1
                            }
                        },
                        {
                            "id": "3",
                            "perk_key": "pack_room",
                            "name": "Pack Room",
                            "description": "Pack-room missions add extra guild energy and reward pressure.",
                            "tier": "2",
                            "required_level": "3",
                            "required_glory": "700",
                            "cost_coins": "0",
                            "effect_json": "{\"pack_energy_bonus\": 3}",
                            "sort_order": "30",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "is_unlocked": false,
                            "unlocked_at": null,
                            "effect": {
                                "pack_energy_bonus": 3
                            }
                        },
                        {
                            "id": "4",
                            "perk_key": "war_room",
                            "name": "War Room",
                            "description": "War scoring, scouting and bot pressure are stronger.",
                            "tier": "2",
                            "required_level": "4",
                            "required_glory": "1200",
                            "cost_coins": "0",
                            "effect_json": "{\"war_bonus_percent\": 5}",
                            "sort_order": "40",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "is_unlocked": false,
                            "unlocked_at": null,
                            "effect": {
                                "war_bonus_percent": 5
                            }
                        },
                        {
                            "id": "5",
                            "perk_key": "elite_academy",
                            "name": "Elite Academy",
                            "description": "Top guild contribution creates stronger player progression rewards.",
                            "tier": "3",
                            "required_level": "6",
                            "required_glory": "2500",
                            "cost_coins": "0",
                            "effect_json": "{\"member_reward_bonus\": 8}",
                            "sort_order": "50",
                            "is_active": "1",
                            "created_at": "2026-07-04 15:30:25",
                            "updated_at": "2026-07-04 15:30:25",
                            "is_unlocked": false,
                            "unlocked_at": null,
                            "effect": {
                                "member_reward_bonus": 8
                            }
                        }
                    ],
                    "unlocked": 0,
                    "total": 5,
                    "percent": 0
                },
                "contribution": {
                    "today": [],
                    "week": [],
                    "user_today": 0,
                    "user_week": 0,
                    "leaders": []
                },
                "rewards": {
                    "pending": [],
                    "claimed": []
                },
                "war_momentum": {
                    "score": 7,
                    "grade": "Cold",
                    "active_wars": 0,
                    "challenges": 1,
                    "boosts": {
                        "readiness": 11,
                        "missions": 0,
                        "perks": 0
                    }
                },
                "bots": {
                    "enabled": 3,
                    "profiles": [
                        {
                            "id": "1",
                            "name": "Coach Bot",
                            "behaviour_key": "coach_chat",
                            "is_enabled": "1",
                            "donation_budget_coins": "0",
                            "chat_persona": "motivator",
                            "rules_json": "{\"chat_weight\":70,\"donate_weight\":0,\"war_weight\":20}",
                            "created_at": "2026-07-01 22:53:09",
                            "updated_at": "2026-07-01 22:53:09"
                        },
                        {
                            "id": "2",
                            "name": "Treasury Bot",
                            "behaviour_key": "donor",
                            "is_enabled": "1",
                            "donation_budget_coins": "1000",
                            "chat_persona": "supporter",
                            "rules_json": "{\"chat_weight\":20,\"donate_weight\":80,\"war_weight\":0}",
                            "created_at": "2026-07-01 22:53:09",
                            "updated_at": "2026-07-01 22:53:09"
                        },
                        {
                            "id": "3",
                            "name": "Scout Bot",
                            "behaviour_key": "war_scout",
                            "is_enabled": "1",
                            "donation_budget_coins": "0",
                            "chat_persona": "analyst",
                            "rules_json": "{\"chat_weight\":30,\"donate_weight\":0,\"war_weight\":85}",
                            "created_at": "2026-07-01 22:53:09",
                            "updated_at": "2026-07-01 22:53:09"
                        }
                    ],
                    "last_actions": [
                        {
                            "id": 3,
                            "guild_id": 1,
                            "bot_profile_id": 1,
                            "action_type": "chat",
                            "payload_json": "{\"bot\":\"Coach Bot\",\"behaviour\":\"coach_chat\",\"guild\":\"Up da Wahs\"}",
                            "summary": "Bot posted guild encouragement.",
                            "created_at": "2026-07-03 18:53:11",
                            "bot_name": "Coach Bot"
                        },
                        {
                            "id": 2,
                            "guild_id": 1,
                            "bot_profile_id": 2,
                            "action_type": "donation",
                            "payload_json": "{\"bot\":\"Treasury Bot\",\"behaviour\":\"donor\",\"guild\":\"Up da Wahs\"}",
                            "summary": "Bot donated coins to guild treasury.",
                            "created_at": "2026-07-03 18:53:11",
                            "bot_name": "Treasury Bot"
                        },
                        {
                            "id": 1,
                            "guild_id": 1,
                            "bot_profile_id": 3,
                            "action_type": "war_scout",
                            "payload_json": "{\"bot\":\"Scout Bot\",\"behaviour\":\"war_scout\",\"guild\":\"Up da Wahs\"}",
                            "summary": "Bot scouted a future guild war target.",
                            "created_at": "2026-07-03 18:53:11",
                            "bot_name": "Scout Bot"
                        }
                    ]
                },
                "agenda": [
                    "Push mission: Battle Together (0%).",
                    "Unlock the next Guild perk to improve the whole club.",
                    "Build war momentum before challenging stronger rivals."
                ],
                "next_actions": [
                    "Contribute to Battle Together",
                    "Contribute to Pack Room Energy",
                    "Contribute to Treasury Drive",
                    "Contribute to War Readiness Week",
                    "Unlock Clubhouse Boost"
                ],
                "qa": {
                    "status": "green",
                    "missing_tables": [],
                    "message": "Guild core loop persistence is installed."
                }
            },
            "meta_game": {
                "phase": "40.52",
                "version": "4.0.52-guild-meta-game-enhancements",
                "has_guild": true,
                "season": {
                    "installed": true,
                    "season": {
                        "id": "1",
                        "season_key": "season-202607",
                        "name": "Guild Season Jul 2026",
                        "status": "active",
                        "starts_at": "2026-07-01 00:00:00",
                        "ends_at": "2026-07-31 23:59:59",
                        "created_at": "2026-07-05 01:54:11",
                        "updated_at": "2026-07-05 01:54:11"
                    },
                    "entry": {
                        "id": 2,
                        "season_id": 1,
                        "guild_id": 1,
                        "division": "Foundation",
                        "tier": 3,
                        "points": 0,
                        "wins": 0,
                        "losses": 0,
                        "draws": 0,
                        "promotion_score": 0,
                        "status": "active",
                        "created_at": "2026-07-05 02:03:59",
                        "updated_at": "2026-07-05 02:03:59"
                    },
                    "standings": [
                        {
                            "id": 1,
                            "season_id": 1,
                            "guild_id": 2,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 01:54:11",
                            "updated_at": "2026-07-05 01:54:11",
                            "guild_name": "BushFooty"
                        },
                        {
                            "id": 2,
                            "season_id": 1,
                            "guild_id": 1,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 02:03:59",
                            "updated_at": "2026-07-05 02:03:59",
                            "guild_name": "Up da Wahs"
                        }
                    ],
                    "promotion_zone": [
                        {
                            "id": 1,
                            "season_id": 1,
                            "guild_id": 2,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 01:54:11",
                            "updated_at": "2026-07-05 01:54:11",
                            "guild_name": "BushFooty"
                        },
                        {
                            "id": 2,
                            "season_id": 1,
                            "guild_id": 1,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 02:03:59",
                            "updated_at": "2026-07-05 02:03:59",
                            "guild_name": "Up da Wahs"
                        }
                    ],
                    "relegation_zone": [
                        {
                            "id": 1,
                            "season_id": 1,
                            "guild_id": 2,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 01:54:11",
                            "updated_at": "2026-07-05 01:54:11",
                            "guild_name": "BushFooty"
                        },
                        {
                            "id": 2,
                            "season_id": 1,
                            "guild_id": 1,
                            "division": "Foundation",
                            "tier": 3,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "draws": 0,
                            "promotion_score": 0,
                            "status": "active",
                            "created_at": "2026-07-05 02:03:59",
                            "updated_at": "2026-07-05 02:03:59",
                            "guild_name": "Up da Wahs"
                        }
                    ]
                },
                "raids": [
                    {
                        "id": 2,
                        "guild_id": 1,
                        "raid_key": "sunday_demolition_pack",
                        "name": "Sunday Demolition Pack",
                        "boss_hp": 1200,
                        "current_hp": 1200,
                        "status": "active",
                        "difficulty": 1,
                        "reward_json": "{\"guild_xp\":350,\"glory\":120,\"pack\":\"Guild War Pack\"}",
                        "starts_at": "2026-07-05 02:03:59",
                        "ends_at": "2026-07-12 02:03:59",
                        "created_at": "2026-07-05 02:03:59",
                        "updated_at": "2026-07-05 02:03:59",
                        "percent": 0,
                        "damage_done": 0
                    }
                ],
                "pack_rooms": [
                    {
                        "id": 2,
                        "guild_id": 1,
                        "room_key": "guild_war_pack_room",
                        "name": "Guild War Pack Room",
                        "pack_target": 25,
                        "current_packs": 0,
                        "reward_json": "{\"shared_pack\":\"Guild War Pack\",\"threshold\":25}",
                        "status": "active",
                        "created_at": "2026-07-05 02:03:59",
                        "updated_at": "2026-07-05 02:03:59",
                        "percent": 0
                    }
                ],
                "crafting": [
                    {
                        "id": 2,
                        "guild_id": 1,
                        "project_key": "club_legend_fusion",
                        "name": "Club Legend Fusion",
                        "target_materials": 500,
                        "current_materials": 0,
                        "reward_json": "{\"fusion\":\"Guild Legend Token\",\"guild_xp\":500}",
                        "status": "active",
                        "created_at": "2026-07-05 02:03:59",
                        "updated_at": "2026-07-05 02:03:59",
                        "percent": 0
                    }
                ],
                "stadium": {
                    "installed": true,
                    "owned": [
                        {
                            "id": 2,
                            "guild_id": 1,
                            "stadium_key": "home_ground",
                            "stadium_name": "Guild Home Ground",
                            "control_points": 0,
                            "buff_key": "home_ground_xp",
                            "buff_percent": 0,
                            "status": "contested",
                            "updated_at": "2026-07-05 02:03:59"
                        }
                    ],
                    "buffs": [],
                    "total_buff": 0
                },
                "rivalries": [],
                "scouting": [],
                "weekly_awards": {
                    "period_key": "2026-W27",
                    "items": [],
                    "leaders": []
                },
                "badges": {
                    "guild": [],
                    "user": [],
                    "featured": []
                },
                "war_ladder": {
                    "installed": true,
                    "entry": {
                        "id": 9,
                        "division_key": "foundation",
                        "guild_id": 1,
                        "guild_name": "Up da Wahs",
                        "is_bot": 0,
                        "points": 0,
                        "wins": 0,
                        "losses": 0,
                        "updated_at": "2026-07-05 02:03:59"
                    },
                    "division": "foundation",
                    "entries": [
                        {
                            "id": 7,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 7",
                            "is_bot": 1,
                            "points": 18,
                            "wins": 5,
                            "losses": 3,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 2,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 2",
                            "is_bot": 1,
                            "points": 13,
                            "wins": 3,
                            "losses": 0,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 4,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 4",
                            "is_bot": 1,
                            "points": 13,
                            "wins": 0,
                            "losses": 0,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 8,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 8",
                            "is_bot": 1,
                            "points": 12,
                            "wins": 0,
                            "losses": 4,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 6,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 6",
                            "is_bot": 1,
                            "points": 9,
                            "wins": 2,
                            "losses": 0,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 3,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 3",
                            "is_bot": 1,
                            "points": 3,
                            "wins": 4,
                            "losses": 4,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 5,
                            "division_key": "foundation",
                            "guild_id": 0,
                            "guild_name": "Prime Rovers 5",
                            "is_bot": 1,
                            "points": 2,
                            "wins": 2,
                            "losses": 1,
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        {
                            "id": 9,
                            "division_key": "foundation",
                            "guild_id": 1,
                            "guild_name": "Up da Wahs",
                            "is_bot": 0,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "updated_at": "2026-07-05 02:03:59"
                        },
                        {
                            "id": 1,
                            "division_key": "foundation",
                            "guild_id": 2,
                            "guild_name": "BushFooty",
                            "is_bot": 0,
                            "points": 0,
                            "wins": 0,
                            "losses": 0,
                            "updated_at": "2026-07-05 01:54:11"
                        }
                    ],
                    "generated_fillers": 7
                },
                "meta_power": {
                    "score": 0,
                    "grade": "Building",
                    "summary": "Guild meta-game influence across raids, seasons, war ladder, stadium and badges."
                },
                "daily_agenda": [
                    "Hit raid boss: Sunday Demolition Pack",
                    "Fill pack room: Guild War Pack Room",
                    "Feed crafting: Club Legend Fusion",
                    "Win battles to increase stadium control.",
                    "Start a rivalry by challenging a nearby Guild.",
                    "Add a scouting target for cards, market or rivals."
                ],
                "qa": {
                    "status": "green",
                    "missing_tables": [],
                    "message": "Guild meta-game persistence is installed."
                }
            },
            "hardening": {
                "ok": true,
                "phase": "40.55",
                "version": "4.0.55-guild-qa-cron-api-ui-polish",
                "summary": {
                    "guilds": 2,
                    "members": 2,
                    "active_members": 2,
                    "join_requests": 0,
                    "wars": 0,
                    "active_wars": 0,
                    "raids": 2,
                    "active_raids": 2,
                    "generated_support_squads": 4,
                    "name_words": 84,
                    "notifications_unread": 0,
                    "flags_open": 0
                },
                "settings": {
                    "daily_token_cap": {
                        "id": "1",
                        "setting_key": "daily_token_cap",
                        "setting_value": "500",
                        "value_type": "int",
                        "label": "Daily token cap",
                        "description": "Maximum Guild Tokens a member should earn from normal daily guild actions.",
                        "sort_order": "10",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "weekly_token_cap": {
                        "id": "2",
                        "setting_key": "weekly_token_cap",
                        "setting_value": "2500",
                        "value_type": "int",
                        "label": "Weekly token cap",
                        "description": "Maximum Guild Tokens a member should earn from normal weekly guild actions.",
                        "sort_order": "20",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "mission_reward_multiplier": {
                        "id": "3",
                        "setting_key": "mission_reward_multiplier",
                        "setting_value": "100",
                        "value_type": "percent",
                        "label": "Mission reward multiplier",
                        "description": "Percentage multiplier applied to mission reward tuning.",
                        "sort_order": "30",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "raid_reward_multiplier": {
                        "id": "4",
                        "setting_key": "raid_reward_multiplier",
                        "setting_value": "100",
                        "value_type": "percent",
                        "label": "Raid reward multiplier",
                        "description": "Percentage multiplier for raid rewards.",
                        "sort_order": "40",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "war_reward_multiplier": {
                        "id": "5",
                        "setting_key": "war_reward_multiplier",
                        "setting_value": "100",
                        "value_type": "percent",
                        "label": "War reward multiplier",
                        "description": "Percentage multiplier for war rewards.",
                        "sort_order": "50",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "shop_price_multiplier": {
                        "id": "6",
                        "setting_key": "shop_price_multiplier",
                        "setting_value": "100",
                        "value_type": "percent",
                        "label": "Shop price multiplier",
                        "description": "Percentage multiplier for Guild Shop prices.",
                        "sort_order": "60",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "treasury_daily_donation_cap": {
                        "id": "7",
                        "setting_key": "treasury_daily_donation_cap",
                        "setting_value": "50000",
                        "value_type": "int",
                        "label": "Treasury daily donation cap",
                        "description": "Maximum coins one member can donate per day.",
                        "sort_order": "70",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "reward_claim_cooldown_minutes": {
                        "id": "8",
                        "setting_key": "reward_claim_cooldown_minutes",
                        "setting_value": "15",
                        "value_type": "int",
                        "label": "Reward claim cooldown minutes",
                        "description": "Cooldown between repeat reward claims from the same source.",
                        "sort_order": "80",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "inactive_warning_days": {
                        "id": "9",
                        "setting_key": "inactive_warning_days",
                        "setting_value": "7",
                        "value_type": "int",
                        "label": "Inactive warning days",
                        "description": "Days before a member can be flagged as inactive.",
                        "sort_order": "90",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "perk_cost_scaling_percent": {
                        "id": "10",
                        "setting_key": "perk_cost_scaling_percent",
                        "setting_value": "115",
                        "value_type": "percent",
                        "label": "Perk cost scaling",
                        "description": "Scaling percentage for perk costs by tier.",
                        "sort_order": "100",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "hq_upgrade_cost_scaling_percent": {
                        "id": "11",
                        "setting_key": "hq_upgrade_cost_scaling_percent",
                        "setting_value": "135",
                        "value_type": "percent",
                        "label": "HQ upgrade cost scaling",
                        "description": "Scaling percentage for HQ room upgrade targets.",
                        "sort_order": "110",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "join_request_daily_cap": {
                        "id": "12",
                        "setting_key": "join_request_daily_cap",
                        "setting_value": "5",
                        "value_type": "int",
                        "label": "Join request daily cap",
                        "description": "Maximum guild join requests per player per day.",
                        "sort_order": "120",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "invite_daily_cap": {
                        "id": "13",
                        "setting_key": "invite_daily_cap",
                        "setting_value": "10",
                        "value_type": "int",
                        "label": "Invite daily cap",
                        "description": "Maximum outgoing guild invites per leader per day.",
                        "sort_order": "130",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "leave_rejoin_cooldown_hours": {
                        "id": "14",
                        "setting_key": "leave_rejoin_cooldown_hours",
                        "setting_value": "24",
                        "value_type": "int",
                        "label": "Leave/rejoin cooldown hours",
                        "description": "Cooldown before a player should join another guild after leaving.",
                        "sort_order": "140",
                        "updated_at": "2026-07-04 19:52:35"
                    },
                    "ownership_transfer_cooldown_hours": {
                        "id": "15",
                        "setting_key": "ownership_transfer_cooldown_hours",
                        "setting_value": "72",
                        "value_type": "int",
                        "label": "Ownership transfer cooldown hours",
                        "description": "Cooldown guidance for guild ownership transfers.",
                        "sort_order": "150",
                        "updated_at": "2026-07-04 19:52:35"
                    }
                },
                "maintenance": {
                    "installed": true,
                    "last_run": null,
                    "last_status": "never",
                    "last_finished_at": null,
                    "next_expected": "External cron or admin Run Maintenance Now",
                    "stuck_wars": 0,
                    "stuck_raids": 0,
                    "pending_join_requests": 0
                },
                "guilds": [
                    {
                        "id": "2",
                        "owner_user_id": "907",
                        "name": "BushFooty",
                        "slug": "bushfooty",
                        "description": "Back to the grass roots",
                        "visibility": "public",
                        "status": "active",
                        "emblem_path": null,
                        "banner_path": null,
                        "level": "1",
                        "xp": "6",
                        "glory_points": "3",
                        "member_limit": "10",
                        "settings_json": null,
                        "created_at": "2026-07-04 22:33:42",
                        "updated_at": "2026-07-05 01:39:49",
                        "deleted_at": null,
                        "member_count": "1"
                    },
                    {
                        "id": "1",
                        "owner_user_id": "904",
                        "name": "Up da Wahs",
                        "slug": "up-da-wahs",
                        "description": "Oh Ah Up da Wahs",
                        "visibility": "public",
                        "status": "active",
                        "emblem_path": null,
                        "banner_path": null,
                        "level": "1",
                        "xp": "25",
                        "glory_points": "3",
                        "member_limit": "10",
                        "settings_json": null,
                        "created_at": "2026-06-27 03:28:41",
                        "updated_at": "2026-07-03 08:53:11",
                        "deleted_at": null,
                        "member_count": "1"
                    }
                ],
                "issues": {
                    "wars": [],
                    "raids": [],
                    "ownerless_guilds": [],
                    "duplicate_names": [],
                    "open_flags": []
                },
                "economy": {
                    "settings": {
                        "daily_token_cap": {
                            "id": "1",
                            "setting_key": "daily_token_cap",
                            "setting_value": "500",
                            "value_type": "int",
                            "label": "Daily token cap",
                            "description": "Maximum Guild Tokens a member should earn from normal daily guild actions.",
                            "sort_order": "10",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "weekly_token_cap": {
                            "id": "2",
                            "setting_key": "weekly_token_cap",
                            "setting_value": "2500",
                            "value_type": "int",
                            "label": "Weekly token cap",
                            "description": "Maximum Guild Tokens a member should earn from normal weekly guild actions.",
                            "sort_order": "20",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "mission_reward_multiplier": {
                            "id": "3",
                            "setting_key": "mission_reward_multiplier",
                            "setting_value": "100",
                            "value_type": "percent",
                            "label": "Mission reward multiplier",
                            "description": "Percentage multiplier applied to mission reward tuning.",
                            "sort_order": "30",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "raid_reward_multiplier": {
                            "id": "4",
                            "setting_key": "raid_reward_multiplier",
                            "setting_value": "100",
                            "value_type": "percent",
                            "label": "Raid reward multiplier",
                            "description": "Percentage multiplier for raid rewards.",
                            "sort_order": "40",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "war_reward_multiplier": {
                            "id": "5",
                            "setting_key": "war_reward_multiplier",
                            "setting_value": "100",
                            "value_type": "percent",
                            "label": "War reward multiplier",
                            "description": "Percentage multiplier for war rewards.",
                            "sort_order": "50",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "shop_price_multiplier": {
                            "id": "6",
                            "setting_key": "shop_price_multiplier",
                            "setting_value": "100",
                            "value_type": "percent",
                            "label": "Shop price multiplier",
                            "description": "Percentage multiplier for Guild Shop prices.",
                            "sort_order": "60",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "treasury_daily_donation_cap": {
                            "id": "7",
                            "setting_key": "treasury_daily_donation_cap",
                            "setting_value": "50000",
                            "value_type": "int",
                            "label": "Treasury daily donation cap",
                            "description": "Maximum coins one member can donate per day.",
                            "sort_order": "70",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "reward_claim_cooldown_minutes": {
                            "id": "8",
                            "setting_key": "reward_claim_cooldown_minutes",
                            "setting_value": "15",
                            "value_type": "int",
                            "label": "Reward claim cooldown minutes",
                            "description": "Cooldown between repeat reward claims from the same source.",
                            "sort_order": "80",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "inactive_warning_days": {
                            "id": "9",
                            "setting_key": "inactive_warning_days",
                            "setting_value": "7",
                            "value_type": "int",
                            "label": "Inactive warning days",
                            "description": "Days before a member can be flagged as inactive.",
                            "sort_order": "90",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "perk_cost_scaling_percent": {
                            "id": "10",
                            "setting_key": "perk_cost_scaling_percent",
                            "setting_value": "115",
                            "value_type": "percent",
                            "label": "Perk cost scaling",
                            "description": "Scaling percentage for perk costs by tier.",
                            "sort_order": "100",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "hq_upgrade_cost_scaling_percent": {
                            "id": "11",
                            "setting_key": "hq_upgrade_cost_scaling_percent",
                            "setting_value": "135",
                            "value_type": "percent",
                            "label": "HQ upgrade cost scaling",
                            "description": "Scaling percentage for HQ room upgrade targets.",
                            "sort_order": "110",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "join_request_daily_cap": {
                            "id": "12",
                            "setting_key": "join_request_daily_cap",
                            "setting_value": "5",
                            "value_type": "int",
                            "label": "Join request daily cap",
                            "description": "Maximum guild join requests per player per day.",
                            "sort_order": "120",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "invite_daily_cap": {
                            "id": "13",
                            "setting_key": "invite_daily_cap",
                            "setting_value": "10",
                            "value_type": "int",
                            "label": "Invite daily cap",
                            "description": "Maximum outgoing guild invites per leader per day.",
                            "sort_order": "130",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "leave_rejoin_cooldown_hours": {
                            "id": "14",
                            "setting_key": "leave_rejoin_cooldown_hours",
                            "setting_value": "24",
                            "value_type": "int",
                            "label": "Leave/rejoin cooldown hours",
                            "description": "Cooldown before a player should join another guild after leaving.",
                            "sort_order": "140",
                            "updated_at": "2026-07-04 19:52:35"
                        },
                        "ownership_transfer_cooldown_hours": {
                            "id": "15",
                            "setting_key": "ownership_transfer_cooldown_hours",
                            "setting_value": "72",
                            "value_type": "int",
                            "label": "Ownership transfer cooldown hours",
                            "description": "Cooldown guidance for guild ownership transfers.",
                            "sort_order": "150",
                            "updated_at": "2026-07-04 19:52:35"
                        }
                    },
                    "token_balance_total": 0,
                    "token_earned_7d": 0,
                    "token_spent_7d": 0,
                    "shop_purchases_7d": 0,
                    "reward_claims_7d": 0
                },
                "notifications": {
                    "installed": true,
                    "unread": 0,
                    "recent": [],
                    "coverage": [
                        "join_request",
                        "request_accepted",
                        "promotion",
                        "announcement",
                        "war_challenge",
                        "war_started",
                        "war_result",
                        "raid_reward",
                        "mission_completed",
                        "shop_unlocked",
                        "hq_upgrade",
                        "season_end",
                        "member_award"
                    ]
                },
                "recruitment": {
                    "settings_rows": 2,
                    "pending": 0,
                    "stale_pending": 0
                },
                "generated_squads": {
                    "profiles": [
                        {
                            "id": "4",
                            "guild_id": "1",
                            "name": "Harbour Marlins",
                            "persona_key": "recruiter",
                            "squad_power": "1162",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": "3",
                            "guild_id": "1",
                            "name": "Metro Titans",
                            "persona_key": "donor",
                            "squad_power": "1250",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 10:34:03",
                            "updated_at": "2026-07-05 10:34:03"
                        },
                        {
                            "id": "2",
                            "guild_id": "2",
                            "name": "Coastal Sharks",
                            "persona_key": "pack_runner",
                            "squad_power": "1429",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        },
                        {
                            "id": "1",
                            "guild_id": "2",
                            "name": "Iron Rangers",
                            "persona_key": "war_captain",
                            "squad_power": "1392",
                            "is_enabled": "1",
                            "created_at": "2026-07-05 04:43:08",
                            "updated_at": "2026-07-05 04:43:08"
                        }
                    ],
                    "recent_actions": [],
                    "sample": "River Sharks"
                },
                "name_pool": {
                    "installed": true,
                    "words": [
                        {
                            "category": "adjective",
                            "word": "Crimson",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Golden",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Harbour",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Iron",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Northern",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Outback",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Prime",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Rapid",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Storm",
                            "uses": "3"
                        },
                        {
                            "category": "adjective",
                            "word": "Wild",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Chargers",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Comets",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Falcons",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Marlins",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Raiders",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Rangers",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Rovers",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Sharks",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Titans",
                            "uses": "3"
                        },
                        {
                            "category": "noun",
                            "word": "Wolves",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Brisbane",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Bush",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Central",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Coastal",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Frontier",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Metro",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "River",
                            "uses": "3"
                        },
                        {
                            "category": "place",
                            "word": "Valley",
                            "uses": "3"
                        }
                    ],
                    "sample": "Iron Titans"
                },
                "api_readiness": {
                    "ready": true,
                    "endpoints": [
                        "/api/v1/guilds",
                        "/api/v1/guilds/hq",
                        "/api/v1/guilds/mobile",
                        "/api/v1/guilds/core",
                        "/api/v1/guilds/qa",
                        "/api/v1/guilds/release-hardening",
                        "/api/v1/guilds/meta/raid-hit",
                        "/api/v1/guilds/meta/pack-room",
                        "/api/v1/guilds/meta/crafting",
                        "/api/v1/guilds/debug-membership"
                    ],
                    "mobile_payloads": [
                        "hq",
                        "missions",
                        "rewards",
                        "shop",
                        "raids",
                        "wars",
                        "seasons",
                        "roster",
                        "announcements",
                        "notifications",
                        "name_pool",
                        "generated_support_squads"
                    ]
                },
                "onboarding": [
                    {
                        "step_key": "join_or_create",
                        "title": "Join or create a guild",
                        "reward": "100 coins + 25 Guild Tokens"
                    },
                    {
                        "step_key": "first_mission",
                        "title": "Complete first guild mission contribution",
                        "reward": "Guild XP + contribution score"
                    },
                    {
                        "step_key": "treasury_donation",
                        "title": "Donate to treasury",
                        "reward": "Guild Tokens + reputation"
                    },
                    {
                        "step_key": "claim_reward",
                        "title": "Claim a guild reward",
                        "reward": "Player XP / coins"
                    },
                    {
                        "step_key": "war_prep",
                        "title": "Set war preparation",
                        "reward": "Readiness score"
                    },
                    {
                        "step_key": "guild_shop",
                        "title": "Open the Guild Shop",
                        "reward": "Starter purchase discount"
                    },
                    {
                        "step_key": "raid_contribution",
                        "title": "Contribute to raid damage",
                        "reward": "Raid contribution badge"
                    },
                    {
                        "step_key": "first_perk",
                        "title": "Unlock or view first guild perk",
                        "reward": "Guild progress badge"
                    }
                ],
                "safety": {
                    "profanity_filter": "ready",
                    "duplicate_name_guard": "enabled in Guild creation",
                    "join_request_spam_limit": 5,
                    "invite_spam_limit": 10,
                    "treasury_audit": "enabled",
                    "reward_audit": "enabled",
                    "cooldowns": {
                        "leave_rejoin_hours": 24,
                        "ownership_transfer_hours": 72
                    }
                },
                "audit": [],
                "qa": {
                    "status": "green",
                    "red": 0,
                    "amber": 0,
                    "checks": [
                        {
                            "label": "guilds",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_members",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_balance_controls",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_admin_audit_logs",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_maintenance_runs",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_notifications",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_name_word_pool",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_auto_squad_profiles",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_token_ledger",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "guild_rewards",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "label": "Open safety flags",
                            "status": "green",
                            "message": "0 open"
                        },
                        {
                            "label": "Stuck wars",
                            "status": "green",
                            "message": "0 stuck"
                        },
                        {
                            "label": "Stuck raids",
                            "status": "green",
                            "message": "0 stuck"
                        },
                        {
                            "label": "Balance controls",
                            "status": "green",
                            "message": "15 setting(s)"
                        }
                    ]
                },
                "polish": {
                    "ok": true,
                    "phase": "40.55",
                    "version": "4.0.55-guild-qa-cron-api-ui-polish",
                    "status": "amber",
                    "user_id": 0,
                    "guild_id": 0,
                    "qa_suite": {
                        "status": "amber",
                        "red": 0,
                        "amber": 5,
                        "green": 15,
                        "checks": [
                            {
                                "key": "standalone_route",
                                "label": "Standalone Guild route",
                                "status": "amber",
                                "message": "Admin/global QA context"
                            },
                            {
                                "key": "user_resolved",
                                "label": "Logged-in user resolved",
                                "status": "amber",
                                "message": "Global/admin QA run"
                            },
                            {
                                "key": "guild_resolved",
                                "label": "Guild membership resolved",
                                "status": "amber",
                                "message": "Global/admin QA run"
                            },
                            {
                                "key": "table_guilds",
                                "label": "guilds",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_members",
                                "label": "guild_members",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_balance_controls",
                                "label": "guild_balance_controls",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_maintenance_runs",
                                "label": "guild_maintenance_runs",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_qa_runs",
                                "label": "guild_qa_runs",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_cron_health",
                                "label": "guild_cron_health",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_missions",
                                "label": "guild_missions",
                                "status": "amber",
                                "message": "Install latest Guild gameplay migration if needed"
                            },
                            {
                                "key": "table_guild_rewards",
                                "label": "guild_rewards",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_hq_rooms",
                                "label": "guild_hq_rooms",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_shop_items",
                                "label": "guild_shop_items",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_notifications",
                                "label": "guild_notifications",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_name_word_pool",
                                "label": "guild_name_word_pool",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_auto_squad_profiles",
                                "label": "guild_auto_squad_profiles",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "table_guild_war_ladder_entries",
                                "label": "guild_war_ladder_entries",
                                "status": "green",
                                "message": "Installed"
                            },
                            {
                                "key": "generated_name_language",
                                "label": "Generated names avoid automation wording",
                                "status": "green",
                                "message": "0 generated name(s) need cleanup"
                            },
                            {
                                "key": "cron_health",
                                "label": "Guild cron health",
                                "status": "amber",
                                "message": "Last status: never"
                            },
                            {
                                "key": "api_payloads",
                                "label": "Mobile/API payload map",
                                "status": "green",
                                "message": "16 payload(s) mapped"
                            }
                        ],
                        "generated_at": "2026-07-05 14:50:46"
                    },
                    "cron": {
                        "installed": true,
                        "last_status": "never",
                        "last_finished_at": "",
                        "last_source": "master/manual",
                        "recommended_cpanel_command": "php /home/whitelinefever/public_html/tcg/cron/run.php guild-maintenance token=YOUR_CRON_TOKEN",
                        "web_cron_url": "https://tcg.whitelinefever.com/cron/run.php?job=guild-maintenance&token=YOUR_CRON_TOKEN",
                        "recent": []
                    },
                    "api": {
                        "ready": true,
                        "endpoints": [
                            "/api/v1/guilds/mobile",
                            "/api/v1/guilds/qa",
                            "/api/v1/guilds/cron-health",
                            "/api/v1/guilds/release-hardening",
                            "/api/v1/guilds/core",
                            "/api/v1/guilds/name-pool",
                            "/api/v1/guilds/meta/raid-hit",
                            "/api/v1/guilds/meta/pack-room",
                            "/api/v1/guilds/meta/crafting",
                            "/api/v1/guilds/meta/scout-add"
                        ],
                        "mobile_payloads": [
                            "user",
                            "guild",
                            "hq",
                            "missions",
                            "perks",
                            "rewards",
                            "shop",
                            "raids",
                            "wars",
                            "seasons",
                            "roster",
                            "announcements",
                            "notifications",
                            "name_pool",
                            "generated_support_squads",
                            "qa"
                        ],
                        "guild_id": 0,
                        "user_id": 0
                    },
                    "ui": {
                        "show_route_canary": false,
                        "compact_debug": true,
                        "default_tab_order": [
                            "Today",
                            "Missions",
                            "Rewards",
                            "Wars",
                            "Raid",
                            "HQ",
                            "Shop",
                            "Roster",
                            "Admin"
                        ],
                        "status_cards": [
                            {
                                "label": "Today",
                                "value": "0%",
                                "hint": "mission progress"
                            },
                            {
                                "label": "Season",
                                "value": "Foundation",
                                "hint": "division"
                            },
                            {
                                "label": "Readiness",
                                "value": "0%",
                                "hint": "war prep"
                            },
                            {
                                "label": "QA",
                                "value": "AMBER",
                                "hint": "release state"
                            }
                        ]
                    },
                    "last_runs": [],
                    "release_notes": [
                        "Guild canary is hidden by default and visible only through debug mode.",
                        "Guild maintenance can now run directly from cPanel cron without running the full master tick.",
                        "Mobile/API payloads are mapped around the standalone Guild source of truth."
                    ]
                },
                "checklist": [
                    {
                        "label": "Standalone Guild path remains source of truth",
                        "status": "green",
                        "message": "Phase 40.48+ route and service are still used."
                    },
                    {
                        "label": "Admin inspection and repair tools",
                        "status": "green",
                        "message": "Guild release admin panel available at /admin/guild-release."
                    },
                    {
                        "label": "Maintenance visibility",
                        "status": "green",
                        "message": "Last/next/stuck job status available."
                    },
                    {
                        "label": "Economy balance controls",
                        "status": "green",
                        "message": "Tokens, rewards, cooldowns and caps are tunable."
                    },
                    {
                        "label": "Generated names avoid automation labels",
                        "status": "green",
                        "message": "Generated squads/ladders use editable word-pool names."
                    },
                    {
                        "label": "Release QA status",
                        "status": "green",
                        "message": "0 red / 0 amber"
                    }
                ]
            },
            "qa": {
                "status": "green",
                "red": 0,
                "amber": 0,
                "checks": [
                    {
                        "key": "table_guilds",
                        "label": "guilds",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_members",
                        "label": "guild_members",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_join_requests",
                        "label": "guild_join_requests",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_chat_messages",
                        "label": "guild_chat_messages",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_donations",
                        "label": "guild_donations",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_wars",
                        "label": "guild_wars",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_profiles",
                        "label": "guild_profiles",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_activity_feed",
                        "label": "guild_activity_feed",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_announcements",
                        "label": "guild_announcements",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_treasury_goals",
                        "label": "guild_treasury_goals",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_war_challenges",
                        "label": "guild_war_challenges",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_war_score_events",
                        "label": "guild_war_score_events",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_league_seasons",
                        "label": "guild_league_seasons",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_league_standings",
                        "label": "guild_league_standings",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_tournament_brackets",
                        "label": "guild_tournament_brackets",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_auto_squad_profiles",
                        "label": "guild_auto_squad_profiles",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "table_guild_auto_squad_actions",
                        "label": "guild_auto_squad_actions",
                        "status": "green",
                        "message": "Installed"
                    },
                    {
                        "key": "owner_membership",
                        "label": "Owner membership sync",
                        "status": "green",
                        "message": "0 owner rows missing"
                    },
                    {
                        "key": "orphan_members",
                        "label": "Orphan active members",
                        "status": "green",
                        "message": "0 orphan rows"
                    },
                    {
                        "key": "member_cap",
                        "label": "Member cap",
                        "status": "green",
                        "message": "0 guilds over cap"
                    }
                ],
                "generated_at": "2026-07-05 14:50:46"
            },
            "polish": {
                "ok": true,
                "phase": "40.55",
                "version": "4.0.55-guild-qa-cron-api-ui-polish",
                "status": "amber",
                "user_id": 904,
                "guild_id": 1,
                "qa_suite": {
                    "status": "amber",
                    "red": 0,
                    "amber": 2,
                    "green": 18,
                    "checks": [
                        {
                            "key": "standalone_route",
                            "label": "Standalone Guild route",
                            "status": "green",
                            "message": "GuildStandaloneController::index phase40.55 qa-cron-api-ui"
                        },
                        {
                            "key": "user_resolved",
                            "label": "Logged-in user resolved",
                            "status": "green",
                            "message": "User #904"
                        },
                        {
                            "key": "guild_resolved",
                            "label": "Guild membership resolved",
                            "status": "green",
                            "message": "Guild #1"
                        },
                        {
                            "key": "table_guilds",
                            "label": "guilds",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_members",
                            "label": "guild_members",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_balance_controls",
                            "label": "guild_balance_controls",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_maintenance_runs",
                            "label": "guild_maintenance_runs",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_qa_runs",
                            "label": "guild_qa_runs",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_cron_health",
                            "label": "guild_cron_health",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_missions",
                            "label": "guild_missions",
                            "status": "amber",
                            "message": "Install latest Guild gameplay migration if needed"
                        },
                        {
                            "key": "table_guild_rewards",
                            "label": "guild_rewards",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_hq_rooms",
                            "label": "guild_hq_rooms",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_shop_items",
                            "label": "guild_shop_items",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_notifications",
                            "label": "guild_notifications",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_name_word_pool",
                            "label": "guild_name_word_pool",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_auto_squad_profiles",
                            "label": "guild_auto_squad_profiles",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "table_guild_war_ladder_entries",
                            "label": "guild_war_ladder_entries",
                            "status": "green",
                            "message": "Installed"
                        },
                        {
                            "key": "generated_name_language",
                            "label": "Generated names avoid automation wording",
                            "status": "green",
                            "message": "0 generated name(s) need cleanup"
                        },
                        {
                            "key": "cron_health",
                            "label": "Guild cron health",
                            "status": "amber",
                            "message": "Last status: never"
                        },
                        {
                            "key": "api_payloads",
                            "label": "Mobile/API payload map",
                            "status": "green",
                            "message": "16 payload(s) mapped"
                        }
                    ],
                    "generated_at": "2026-07-05 14:50:46"
                },
                "cron": {
                    "installed": true,
                    "last_status": "never",
                    "last_finished_at": "",
                    "last_source": "master/manual",
                    "recommended_cpanel_command": "php /home/whitelinefever/public_html/tcg/cron/run.php guild-maintenance token=YOUR_CRON_TOKEN",
                    "web_cron_url": "https://tcg.whitelinefever.com/cron/run.php?job=guild-maintenance&token=YOUR_CRON_TOKEN",
                    "recent": []
                },
                "api": {
                    "ready": true,
                    "endpoints": [
                        "/api/v1/guilds/mobile",
                        "/api/v1/guilds/qa",
                        "/api/v1/guilds/cron-health",
                        "/api/v1/guilds/release-hardening",
                        "/api/v1/guilds/core",
                        "/api/v1/guilds/name-pool",
                        "/api/v1/guilds/meta/raid-hit",
                        "/api/v1/guilds/meta/pack-room",
                        "/api/v1/guilds/meta/crafting",
                        "/api/v1/guilds/meta/scout-add"
                    ],
                    "mobile_payloads": [
                        "user",
                        "guild",
                        "hq",
                        "missions",
                        "perks",
                        "rewards",
                        "shop",
                        "raids",
                        "wars",
                        "seasons",
                        "roster",
                        "announcements",
                        "notifications",
                        "name_pool",
                        "generated_support_squads",
                        "qa"
                    ],
                    "guild_id": 1,
                    "user_id": 904
                },
                "ui": {
                    "show_route_canary": false,
                    "compact_debug": true,
                    "default_tab_order": [
                        "Today",
                        "Missions",
                        "Rewards",
                        "Wars",
                        "Raid",
                        "HQ",
                        "Shop",
                        "Roster",
                        "Admin"
                    ],
                    "status_cards": [
                        {
                            "label": "Today",
                            "value": "0%",
                            "hint": "mission progress"
                        },
                        {
                            "label": "Season",
                            "value": "Foundation",
                            "hint": "division"
                        },
                        {
                            "label": "Readiness",
                            "value": "0%",
                            "hint": "war prep"
                        },
                        {
                            "label": "QA",
                            "value": "GREEN",
                            "hint": "release state"
                        }
                    ]
                },
                "last_runs": [],
                "release_notes": [
                    "Guild canary is hidden by default and visible only through debug mode.",
                    "Guild maintenance can now run directly from cPanel cron without running the full master tick.",
                    "Mobile/API payloads are mapped around the standalone Guild source of truth."
                ]
            },
            "release_checklist": [
                {
                    "label": "Standalone route live",
                    "status": "green",
                    "message": "GuildStandaloneController::index phase40.55 qa-cron-api-ui"
                },
                {
                    "label": "Logged-in user resolved",
                    "status": "green",
                    "message": "User #904"
                },
                {
                    "label": "Guild membership resolved",
                    "status": "green",
                    "message": "Guild #1"
                },
                {
                    "label": "Core loop tables",
                    "status": "green",
                    "message": "Guild core loop persistence is installed."
                },
                {
                    "label": "Guild missions",
                    "status": "green",
                    "message": "0 / 4 mission(s) complete"
                },
                {
                    "label": "Guild perks",
                    "status": "green",
                    "message": "0 / 5 unlocked"
                },
                {
                    "label": "Meta-game tables",
                    "status": "green",
                    "message": "Guild meta-game persistence is installed."
                },
                {
                    "label": "Meta-game power",
                    "status": "amber",
                    "message": "Building \u00b7 0 power"
                },
                {
                    "label": "Generated squad interactions",
                    "status": "green",
                    "message": "2 generated squad profile(s)"
                },
                {
                    "label": "Release QA",
                    "status": "green",
                    "message": "0 red / 0 amber"
                }
            ]
        }
    },
    "rounds": [
        {
            "id": "1",
            "slug": "mvp_battle",
            "name": "MVP Battle",
            "card_selector_json": "{\"positions\": [\"any\"], \"count\": 1}",
            "stat_pool_json": "[\"speed\", \"attack\", \"defense\", \"stamina\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "6",
            "weight": "100",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "2",
            "slug": "backs_battle",
            "name": "Battle of the Backs",
            "card_selector_json": "{\"positions\": {\"fullback\": 1, \"winger\": 2, \"centre\": 2, \"five_eighth\": 1, \"halfback\": 1}}",
            "stat_pool_json": "[\"speed\", \"attack\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "6",
            "weight": "95",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "3",
            "slug": "forwards_battle",
            "name": "Battle of the Forwards",
            "card_selector_json": "{\"positions\": {\"front_row\": 2, \"second_row\": 2, \"hooker\": 1, \"lock\": 1}}",
            "stat_pool_json": "[\"attack\", \"defense\", \"stamina\", \"skill\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "6",
            "weight": "95",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "7",
            "slug": "halves_battle",
            "name": "Battle of the Halves",
            "card_selector_json": "{\"positions\": {\"five_eighth\": 1, \"halfback\": 1}}",
            "stat_pool_json": "[\"attack\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "4",
            "weight": "85",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "8",
            "slug": "spine_battle",
            "name": "Battle of the Spine",
            "card_selector_json": "{\"positions\": {\"fullback\": 1, \"five_eighth\": 1, \"halfback\": 1, \"hooker\": 1}}",
            "stat_pool_json": "[\"speed\", \"attack\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "5",
            "weight": "85",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "4",
            "slug": "bench_battle",
            "name": "Battle of the Bench",
            "card_selector_json": "{\"slot_group\": \"interchange\", \"count\": 4}",
            "stat_pool_json": "[\"speed\", \"attack\", \"defense\", \"stamina\", \"skill\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "6",
            "weight": "80",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "5",
            "slug": "wingers_battle",
            "name": "Battle of the Wingers",
            "card_selector_json": "{\"positions\": {\"winger\": 2}}",
            "stat_pool_json": "[\"speed\", \"attack\", \"stamina\", \"skill\"]",
            "min_stats": "2",
            "max_stats": "4",
            "weight": "70",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "6",
            "slug": "centres_battle",
            "name": "Battle of the Centres",
            "card_selector_json": "{\"positions\": {\"centre\": 2}}",
            "stat_pool_json": "[\"speed\", \"attack\", \"defense\", \"skill\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "5",
            "weight": "70",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "9",
            "slug": "backs_mvp",
            "name": "Backs MVP",
            "card_selector_json": "{\"positions\": [\"fullback\", \"winger\", \"centre\", \"five_eighth\", \"halfback\"], \"count\": 1}",
            "stat_pool_json": "[\"speed\", \"attack\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "5",
            "weight": "65",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "10",
            "slug": "forwards_mvp",
            "name": "Forwards MVP",
            "card_selector_json": "{\"positions\": [\"front_row\", \"second_row\", \"hooker\", \"lock\"], \"count\": 1}",
            "stat_pool_json": "[\"attack\", \"defense\", \"stamina\", \"skill\"]",
            "min_stats": "2",
            "max_stats": "4",
            "weight": "65",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        },
        {
            "id": "11",
            "slug": "utility_mvp",
            "name": "Utility MVP",
            "card_selector_json": "{\"slot_group\": \"interchange\", \"count\": 1}",
            "stat_pool_json": "[\"speed\", \"attack\", \"defense\", \"stamina\", \"skill\", \"kicking\", \"passing\"]",
            "min_stats": "2",
            "max_stats": "5",
            "weight": "55",
            "is_enabled": "1",
            "created_at": "2026-06-26 15:31:28",
            "updated_at": "2026-06-26 15:31:28"
        }
    ]
}