{
  "status": "template",
  "problem_summary": "Wild Wolpertinger (entry 23487) spawns are entirely missing on map 0 (Dun Morogh) during Brewfest (event 24), preventing Alliance players from seeing or catching them for quest 11117.",
  "affected_scope": [
    {
      "evidence_refs": ["E000001"],
      "kind": "database",
      "source_ref": "analysis/evidence/content/7d7c0a392a2c81dfb3208133bd3a763231e4b75bbefadde63f1329cf500951f4.json"
    },
    {
      "evidence_refs": ["E000004"],
      "kind": "database",
      "source_ref": "analysis/evidence/content/3b49eb9b3aa013b465356b0cc2615e5cb220c41d8c1bcae1420a3cb1b92bb052.json"
    }
  ],
  "required_change": "Create an SQL template to insert creature spawn records for Wild Wolpertinger (entry 23487) on map 0 in Dun Morogh, and associate each inserted spawn GUID with Brewfest (eventEntry 24) in game_event_creature.",
  "implementation_intent": "Provide an SQL migration template containing designated placeholders for the missing spawn coordinates and GUIDs, enabling the addition of Dun Morogh Wolpertingers linked to the Brewfest event.",
  "implementation_guidance": [
    "Draft an SQL insert statement for the creature table targeting map 0, id 23487, phaseMask 1, with placeholders for guid, position_x, position_y, position_z, and orientation.",
    "Draft corresponding SQL insert statements for game_event_creature associating the placeholder GUIDs with eventEntry 24.",
    "Use explicitly named uppercase placeholders rather than inventing coordinate or GUID values."
  ],
  "constraints": [
    "New spawns must target creature entry 23487 and map 0.",
    "All new creature records must be mapped to eventEntry 24 in game_event_creature.",
    "Do not guess or hardcode coordinate placements or primary key GUIDs without verified project data."
  ],
  "preserve": [
    "Existing Durotar spawns for creature entry 23487 on map 1 and their associations in game_event_creature.",
    "SmartAI configuration and creature template settings for entry 23487."
  ],
  "forbidden_changes": [
    "Modifying creature_template entries 23487 or 22943.",
    "Altering C++ source files or quest scripting for quest 11117.",
    "Deleting or altering existing creature or game_event_creature records for map 1."
  ],
  "do_not_fix_by": [
    "Do not implement dynamic C++ script summoning for quest 11117.",
    "Do not modify quest requirements or credit criteria in quest_template."
  ],
  "validation_requirements": [
    {
      "description": "Confirm creature spawn entries for id 23487 exist on map 0 and have matching records with eventEntry 24 in game_event_creature.",
      "evidence_refs": ["E000001"]
    }
  ],
  "missing_information": [
    "Valid reference coordinates and orientations for Wild Wolpertinger spawns around the Ironforge Brewfest area in Dun Morogh.",
    "Unused creature GUID allocation range for the target database."
  ],
  "reason": "The root cause is definitively confirmed as missing static world spawns on map 0 tied to Brewfest event 24, but coordinate and GUID parameters must be supplied to finalize the SQL statements.",
  "human_dev": {
    "status": "assigned",
    "title": "Provide Dun Morogh Wolpertinger spawn coordinates and allocate GUIDs",
    "reason": "Specific coordinates around the Ironforge Brewfest perimeter and suitable database GUIDs are required to populate the SQL migration template.",
    "instructions": [
      "Determine suitable coordinate locations (position_x, position_y, position_z, orientation) around the Ironforge Brewfest grounds in Dun Morogh for Wild Wolpertinger spawns.",
      "Identify an available GUID range in the creature table.",
      "Replace the placeholders in the SQL template with the chosen coordinates and GUIDs, then apply and review the migration."
    ],
    "expected_results": [
      "A completed SQL migration script populating creature and game_event_creature entries for Wild Wolpertinger (entry 23487) on map 0 for event 24."
    ]
  ],
  "placeholders": [
    {
      "description": "Unique creature table primary key GUID for each newly added spawn record.",
      "token": "{{CREATURE_GUID}}"
    },
    {
      "description": "X coordinate for the Dun Morogh spawn position.",
      "token": "{{POSITION_X}}"
    },
    {
      "description": "Y coordinate for the Dun Morogh spawn position.",
      "token": "{{POSITION_Y}}"
    },
    {
      "description": "Z coordinate for the Dun Morogh spawn position.",
      "token": "{{POSITION_Z}}"
    },
    {
      "description": "Orientation angle in radians for the Dun Morogh spawn.",
      "token": "{{ORIENTATION}}"
    }
  ]
}