From 49b9c1c9b292dbb4a2b8cc66814ae688d2720278 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 26 May 2016 04:26:54 +0200 Subject: DB/Creature: Missing Flightpath gossip Turida Coldwind By tkrokli, closes #16508 --- sql/updates/world/6.x/2016_05_26_00_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/6.x/2016_05_26_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_05_26_00_world.sql b/sql/updates/world/6.x/2016_05_26_00_world.sql new file mode 100644 index 00000000000..f907fd8a6c1 --- /dev/null +++ b/sql/updates/world/6.x/2016_05_26_00_world.sql @@ -0,0 +1,6 @@ +-- NPC 25288 Turida Coldwind, update existing gossip menu option with missing values +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`= 53141, `option_id`= 4, `npc_option_npcflag`= 8192 WHERE `menu_id`= 13048; + +-- insert missing gossip menu +DELETE FROM `gossip_menu` WHERE `entry` = 13048 AND `text_id`= 18324; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (13048,18324); -- cgit v1.2.3