From 35f2f5530abc3308cfc6b107255eaa3c82076e76 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 30 May 2015 19:29:47 +0200 Subject: DB/Creature: Remy "Two Times" By Killyana, closes #12616 --- sql/updates/world/2015_05_30_03_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2015_05_30_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_05_30_03_world.sql b/sql/updates/world/2015_05_30_03_world.sql new file mode 100644 index 00000000000..634705b846f --- /dev/null +++ b/sql/updates/world/2015_05_30_03_world.sql @@ -0,0 +1,8 @@ +-- +UPDATE `npc_text` SET `text0_0`="$N, you are ready for the ultimate task. The fiery runes etched on the floor of the molten core are conduits to the realm of fire, and their presence is both an affront to us and a source of power for the Firelords. They must be extinguished!$B$BTo extinguish a rune, take a vial of aqual quintessence. Pour it on the rune and its flame will go out, rendering it useless and weakening our enemy!", `BroadcastTextID0`=8703 WHERE `id`=6158; +DELETE FROM `gossip_menu` WHERE `entry`=5032; +UPDATE `creature_template` SET `npcflag`=2, `gossip_menu_id`=0 WHERE `entry`=241; + +UPDATE `creature_template` SET `gossip_menu_id`=11611 WHERE `entry`=240; +DELETE FROM `gossip_menu` WHERE `entry`=6159; +DELETE FROM `npc_text` WHERE `ID`=6157; -- cgit v1.2.3