From e9ef8934874b396d26f545a26dda08b72ee72e37 Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Tue, 26 Sep 2017 12:08:17 +0200 Subject: DB/Gossip: Aurora Skycaller Closes #20427 (cherry picked from commit 166f0e7fb26ef4fc8b947816a728f417bba6c4b8) --- .../2020_09_12_08_world_2017_09_26_08_world_335.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/master/2020_09_12_08_world_2017_09_26_08_world_335.sql diff --git a/sql/updates/world/master/2020_09_12_08_world_2017_09_26_08_world_335.sql b/sql/updates/world/master/2020_09_12_08_world_2017_09_26_08_world_335.sql new file mode 100644 index 00000000000..5d874b12105 --- /dev/null +++ b/sql/updates/world/master/2020_09_12_08_world_2017_09_26_08_world_335.sql @@ -0,0 +1,21 @@ +-- Fix gossip menu for Aurora Skycaller +DELETE FROM `gossip_menu` WHERE `MenuID` IN (4743, 4744, 4745); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(4743,5795,0), +(4743,5816,0), +(4743,5817,0), +(4743,5818,0), +(4744,5796,0), +(4745,5797,0); + +DELETE FROM `gossip_menu_option_action` WHERE `MenuId`=4743 AND `OptionIndex` IN (0,1); +INSERT INTO `gossip_menu_option_action` (`MenuId`,`OptionIndex`,`ActionMenuId`) VALUES +(4743,0,4744), +(4743,1,4745); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 14 AND `SourceGroup`= 4743; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14,4743,5816,0,0,8,0,5245,0,0,1,0,0,'',"Aurora Skycaller - Show Gossip Menu Text 5816 if Quest 5245 is NOT rewarded"), +(14,4743,5795,0,0,6,0,67,0,0,0,0,0,'',"Aurora Skycaller - Show Gossip Menu Text 5795 if Player is Horde"), +(14,4743,5817,0,0,8,0,5245,0,0,0,0,0,'',"Aurora Skycaller - Show Gossip Menu Text 5817 if Quest 5245 is rewarded"), +(14,4743,5818,0,0,8,0,5247,0,0,0,0,0,'',"Aurora Skycaller - Show Gossip Menu Text 5818 if Quest 5247 is rewarded"); -- cgit v1.2.3