diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_12_19_31_world_2020_01_03_01_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_19_31_world_2020_01_03_01_world.sql b/sql/updates/world/master/2021_12_19_31_world_2020_01_03_01_world.sql new file mode 100644 index 00000000000..f8f0eed6377 --- /dev/null +++ b/sql/updates/world/master/2021_12_19_31_world_2020_01_03_01_world.sql @@ -0,0 +1,13 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=301 WHERE `entry`=3849; +UPDATE `creature_template` SET `gossip_menu_id`=300 WHERE `entry`=3850; + +DELETE FROM `gossip_menu` WHERE `MenuID` IN (21213, 21214, 300, 301) AND `TextID` IN (798,799); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`) VALUES +(300,798), +(301,799); + +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (21213, 21214, 300, 301); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES +(300, 0, 0, "Please unlock the courtyard door.", 2802, 1, 1, 0), +(301, 0, 0, "Please unlock the courtyard door.", 2802, 1, 1, 0); |