From 95a2eec9232afdb1614e648dc4d587e307515d34 Mon Sep 17 00:00:00 2001 From: tkrokli Date: Tue, 12 Jan 2016 07:27:27 +0100 Subject: Core/Scripts: move npc_shadowfang_prisoner gossip option to DB Getting rid of one more incorrect and hardcoded text which now will be read correct and from the DB instead. Wrong text: "Thanks, I'll follow you to the door." (core) Correct text: "Please unlock the courtyard door." (DB) Thanks to @Aokromes, @r00ty, @velinath, @Nayd, @Treeston, @Zedron and lots of other regular TrinityCore developers and members for the inspiration and motivation, as well as helpfulness along the way. --- sql/updates/world/2016_01_12_12_world335.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2016_01_12_12_world335.sql (limited to 'sql') diff --git a/sql/updates/world/2016_01_12_12_world335.sql b/sql/updates/world/2016_01_12_12_world335.sql new file mode 100644 index 00000000000..c3206e70ac4 --- /dev/null +++ b/sql/updates/world/2016_01_12_12_world335.sql @@ -0,0 +1,5 @@ +-- Insert missing gossip_menu_option 21213 for Sorcerer Ashcrombe and 21214 for Deathstalker Adamant: +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (21213,21214) AND `OptionBroadcastTextID`= 2802; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES +(21213,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0), +(21214,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0); -- cgit v1.2.3