[WOD]Impending Retribution

[Cidragon]

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

wowhead link: http://www.wowhead.com/quest=28134/impending-retribution

Brought correction: add gossip option and kill credit to npcs on quest

Code:

-- gossip options
DELETE FROM `world`.`gossip_menu_option` WHERE `menu_id` IN('12359', '12360', '12356');
INSERT INTO `world`.`gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES 
('12359', '0', '0', 'I might be able to help. Were the Neferset behind this?', '0', '1', '1', '0', '0', '0', '0', '', '0'),
('12360', '0', '0', 'The King whises to be informed about recent Neferset activity', '0', '1', '1', '0', '0', '0', '0', '', '0'),
('12356', '0', '0', 'King Phaoris sent me to ask you about Neferset activity.', '0', '1', '1', '0', '0', '0', '0', '', '0');

-- condition on quest
DELETE FROM `world`.`conditions` WHERE `SourceGroup` IN('12359', '12360', '12356') AND `ConditionValue1` = '28134';
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
('15', '12360', '0', '0', '0', '9', '0', '28134', '0', '0', '0', '0', '0', '', ''),
('15', '12359', '0', '0', '0', '9', '0', '28134', '0', '0', '0', '0', '0', '', ''),
('15', '12356', '0', '0', '0', '9', '0', '28134', '0', '0', '0', '0', '0', '', '');

-- SAI update
UPDATE `world`.`creature_template` SET `AIName`='SmartAI' WHERE `entry` IN('47715', '46603', '47930');

-- kill credit on gossip select
DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` IN('46603', '47715', '47930');
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 
('46603', '0', '0', '1', '62', '0', '100', '0', '12356', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Nomarch Teneth - On gossip option select - Close gossip'),
('46603', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '33', '47932', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Nomarch Teneth - Kill Credit'),
('47715', '0', '0', '1', '62', '0', '100', '0', '12359', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Sun Priest Asaris - On gossip option select - Close gossip'),
('47715', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '33', '47933', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Sun Priest Asaris - Kill Credit'),
('47930', '0', '0', '1', '62', '0', '100', '0', '12360', '0', '0', '0', '72', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Asaq - On gossip option select - Close gossip'),
('47930', '0', '1', '0', '61', '0', '100', '0', '0', '0', '0', '0', '33', '47936', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Asaq - Kill Credit');

 

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

[Mikrole]

Patch Accepted, merged soon on live realms.