12690 Fuel for the Fire NEEDS SPELL FIX

[eyerobot]

12690 Fuel for the Fire
Reliquary of pain, Zul drak, Horde
Fixes Everything but the spell target. 52510 Burst at the seams will not target the Drakkari skullcrusher.
Also there is no script to make a Drakkari Chieftain spawn after every 20 kills. I could do this randomly once the spell target is fixed.

-- 12690 Fuel for the Fire

-- 28844 Drakkari Skullcrusher
UPDATE `creature_template` SET `unit_flags` = 32768 , `unit_flags2` = 2048, `dynamicflags` = 0 WHERE `entry` = 28844;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=28844 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 
(28844, 0, 0, 0, 8, 0, 100, 1, 52510, 0, 0, 0, 80, 2884400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Drakkari Skullcrusher - On Spellhit 'Burst at the Seams' - Run Script");

DELETE FROM `smart_scripts` WHERE (`entryorguid`=2884400 AND `source_type`=9);
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 
(2884400, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 11, 52565, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Script Cast Troll Explosion"),
(2884400, 9, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 11, 52578, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Script Cast Explode Troll Meat"),
(2884400, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 11, 51744, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Script Cast Suicide"),
(2884400, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 33, 29099, 2, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, "On Script Call Killed Monster Credit");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=2 AND `SourceEntry`=52510 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=28844 AND `ConditionValue3`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 2, 52510, 0, 0, 31, 0, 3, 28844, 0, 0, 0, 0, '', 'Spell Burst at the Seams targets Drakkari Skullcrusher');

-- 28843 Bloated Abomination
UPDATE `creature_template` SET `spell1` = 52497, `spell2` = 52510 WHERE `entry` = 28843;


DELETE FROM `smart_scripts` WHERE (`entryorguid`=28843 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 
(28843, 0, 0, 0, 0, 0, 100, 0, 5000, 9000, 8000, 13000, 11, 52497, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Cast Flatulate");

 

[ExO]

Applied the fix now.