DB/Gossip: Aurora Skycaller

Closes #20427

(cherry picked from commit 166f0e7fb26ef4fc8b947816a728f417bba6c4b8)

1 files changed, 21 insertions, 0 deletions

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");