diff options
| -rw-r--r-- | sql/updates/world/master/2020_09_12_08_world_2017_09_26_08_world_335.sql | 21 |
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"); |