TrinityCore/TrinityCore — Issue #3915: [Quest/Fix] War is Hell
Author: Kapoeira
Created: 2011-11-11 04:10:56+00:00
State: open

```sql
DELETE FROM creature_ai_scripts WHERE creature_id IN (24009,24010);
UPDATE creature_template SET AIName='SmartAI' WHERE entry IN (24009,24010);
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(24009,0,0,0,8,0,100,0,42793,0,0,0,41,20,0,0,0,0,0,0,1,0,0,0,0,0,0, 'Alliance Corpse - On Burn Body Hit - Despawn'),
(24010,0,0,0,8,0,100,0,42793,0,0,0,41,20,0,0,0,0,0,0,1,0,0,0,0,0,0, 'Horde Corpse - On Burn Body Hit - Despawn');
```

Also add this to SpellMgr::LoadDBCCorrections

```c++
case 42793: // Burn Body (Quest War is Hell)
spellInfo->EffectImplicitTargetA[2] = TARGET_UNIT_CASTER;
spellInfo->EffectMiscValue[2] = 24008;
break;
```

Why a DBC hack ? Because there is a kill credit effect on the spell used by the item, and it contains incomplete data.

Valcorb tried this. http://www.trinitycore.org/f/topic/4958-incomplete-war-is-hell/
However imo we should better use the DBC data and fix it since its there and thats most probably some blizzard fail.