{ "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": "08e9e18a" }, "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-04 22:32:18", "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-04 22:32:18", "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": "08e9e18a", "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": "08e9e18a" }, "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-04 22:32:18", "display_name": "aussiewarrior", "email": "pauldaley@whitelinefever.com" }, "source": "guild_members.direct", "repaired": [] }, "guild_id": 1, "session": { "active": true, "name": "RLCGSESSID", "id_prefix": "08e9e18a", "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", "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": "Storm Rovers" }, "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": "Golden Marlins" }, "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": "Brisbane Chargers" }, "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:46:41" }, "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:46:41" }, "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:46:41" }, "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" } ] }