aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-05-26 04:26:54 +0200
committerAokromes <Aokromes@users.noreply.github.com>2016-05-26 04:26:54 +0200
commit49b9c1c9b292dbb4a2b8cc66814ae688d2720278 (patch)
treebe69eb00b6ea3acd2ac938079021f74ca28a94a0
parent6b30b88910c12e5b1619a1a086b7014e95055a30 (diff)
DB/Creature: Missing Flightpath gossip Turida Coldwind
By tkrokli, closes #16508
-rw-r--r--sql/updates/world/6.x/2016_05_26_00_world.sql6
1 files changed, 6 insertions, 0 deletions
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);