Here is what I have so far. The SAI is probably more elaborate than necessary but I was trying to go on memory. I had to update the water bucket item_template, as I mentioned only the spell in the first position works visually. The update to the creature_template is to keep them from flagging the player into combat when hit with that bucket splash spell (42114).
[CODE]
– Headless Horseman - Fire (DND) SAI
SET @ENTRY := 23537;
UPDATE creature_template
SET AIName
=“SmartAI”,unit_flags
=131072 WHERE entry
= @ENTRY;
DELETE FROM smart_scripts
WHERE entryorguid
= @ENTRY AND source_type
=0;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,23,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - On Respawn - Increment Phase by 2”),
(@ENTRY,0,1,2,8,13,100,0,42114,0,1000,1000,28,43184,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - On SpellHit - Remove Headless Horseman Burning Base Aura”),
(@ENTRY,0,2,3,61,13,100,0,0,0,0,0,28,42971,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - On SpellHit Linked - Remove Headless Horseman Burning Aura”),
(@ENTRY,0,3,4,61,13,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,7,0,0,0,0,0,0,0,“Headless Horseman Fire - On SpellHit Linked - Quest Credit ‘Fire Training’ and ‘Fire Brigade’”),
(@ENTRY,0,4,0,61,13,100,0,0,0,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - On SpellHit Linked - Set Phase 2”),
(@ENTRY,0,5,6,23,2,100,0,43184,0,50000,100000,11,43184,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura (Phase 2) - Cast Headless Horseman Burning Base Aura”),
(@ENTRY,0,6,0,61,2,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura Linked (Phase 2) - Increment Phase by 1”),
(@ENTRY,0,7,8,23,2,100,0,42971,0,50000,100000,11,42971,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura (Phase 2) - Cast Headless Horseman Burning Aura”),
(@ENTRY,0,8,0,61,2,100,0,0,0,0,0,23,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura Linked (Phase 2) - Increment Phase by 2”),
(@ENTRY,0,9,10,1,4,100,0,1000,4000,1000,4000,11,42971,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura (Phase 3) - Cast Headless Horseman Burning Aura”),
(@ENTRY,0,10,0,61,4,100,0,0,0,0,0,23,0,2,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura Linked (Phase 3) - Decrement Phase by 2”),
(@ENTRY,0,11,12,1,8,100,0,1000,4000,1000,4000,11,43184,0,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura (Phase 4) - Cast Headless Horseman Burning Base Aura”),
(@ENTRY,0,12,0,61,8,100,0,0,0,0,0,23,0,3,0,0,0,0,1,0,0,0,0,0,0,0,“Headless Horseman Fire - Missing Aura Linked (Phase 4) - Decrement Phase by 3”);
– Update Water Bucket
SET @ENTRY := 32971;
UPDATE item_template
SET spellid_1
=42114, spellcharges_1
=0,spellid_2
=42340,spelltrigger_2
=0,spellcharges_2
=-1 WHERE entry
= @ENTRY; [/CODE]
Currently the only issue I’m having is that some of the creatures will flag the player in combat when hit with spell 42114, but not all of them…I think something is not refreshing properly. Feel free to tear this up…it’s been awhile since I scripted anything.