[WOD]Sowing a solution

[Cidragon]

Bugtracker link: https://firestorm-servers.com/us/report/see_report/4304

wowhead link: http://www.wowhead.com/quest=24566/sowing-a-solution

Brought correction: add kill credit on spell hit

Code: 

-- Insert SAI to creature
UPDATE `world`.`creature_template` SET `AIName`='SmartAI' WHERE `entry` IN('37090', '37091');

-- Add spells and kill credit on spell hit
DELETE FROM `world`.`smart_scripts` where `entryorguid` IN('37090', '37091');
INSERT INTO `world`.`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 
('37090', '0', '0', '0', '4', '0', '100', '1', '0', '0', '0', '0', '11', '6268', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Deviate Terrortooth - On Aggro - Cast Rushing Charge (No Repeat)'),
('37090', '0', '1', '0', '0', '0', '100', '0', '4000', '5000', '15000', '21000', '11', '80608', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Deviate Terrortooth - In Combat - Cast Summon Pebble'),
('37090', '0', '2', '3', '8', '0', '100', '0', '70458', '0', '0', '0', '33', '37726', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Spell Hit - Give Kill Credit sowing a solution'),
('37090', '0', '3', '0', '61', '0', '100', '0', '0', '0', '0', '0', '49', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Spell Hit - Start Attack'),
('37091', '0', '0', '0', '11', '0', '100', '1', '0', '0', '0', '0', '11', '80807', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Deviate Plainstrider - On Respawn - Cast Sand Blast (No Repeat)'),
('37091', '0', '1', '2', '8', '0', '100', '0', '70458', '0', '0', '0', '33', '37726', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Spell Hit - Give Kill Credit sowing a solution'),
('37091', '0', '2', '0', '61', '0', '100', '0', '0', '0', '0', '0', '49', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Spell Hit - Start Attack');

 

Note: This was tested on Trinitycore 6.x branch and should work for legion too.

[Mikrole]

Patch Accepted, merged soon to live realms.