From 10ba39e62644c0d071013d50775790307de807c2 Mon Sep 17 00:00:00 2001 From: Killyana Date: Fri, 3 Jan 2020 15:55:26 +0100 Subject: Creature/Script: Add text target for npc_shadowfang_prisoner --- sql/updates/world/3.3.5/2020_01_03_01_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_01_03_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_01_03_01_world.sql b/sql/updates/world/3.3.5/2020_01_03_01_world.sql new file mode 100644 index 00000000000..db15abb5b04 --- /dev/null +++ b/sql/updates/world/3.3.5/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`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, BoxBroadcastTextID, `VerifiedBuild`) VALUES +(300, 0, 0, "Please unlock the courtyard door.", 2802, 1, 1, 0, 0, 0, 0, "", 0, 0), +(301, 0, 0, "Please unlock the courtyard door.", 2802, 1, 1, 0, 0, 0, 0, "", 0, 0); -- cgit v1.2.3