diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2017-09-26 12:08:17 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-09-26 12:08:17 +0200 |
| commit | 166f0e7fb26ef4fc8b947816a728f417bba6c4b8 (patch) | |
| tree | 8003e940bf0ab9d51397d7eca35758600a89dc56 | |
| parent | 445b277b968d941be9e96185bd0d21b1c071cb89 (diff) | |
DB/Gossip: Aurora Skycaller
Closes #20427
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_26_08_world_335.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_26_08_world_335.sql b/sql/updates/world/3.3.5/2017_09_26_08_world_335.sql new file mode 100644 index 00000000000..dba0f165f89 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_26_08_world_335.sql @@ -0,0 +1,20 @@ +-- 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); + +UPDATE `gossip_menu_option` SET `ActionMenuID`=4744 WHERE `MenuID`=4743 AND `OptionID`=0; +UPDATE `gossip_menu_option` SET `ActionMenuID`=4745 WHERE `MenuID`=4743 AND `OptionID`=1; + +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"); +UPDATE `gossip_menu_option` SET `ActionMenuID`=3623 WHERE `MenuID`=3624; |