diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-30 19:29:47 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-30 19:29:47 +0200 |
| commit | 35f2f5530abc3308cfc6b107255eaa3c82076e76 (patch) | |
| tree | 4ed7f6a30e3b79425b63aef6619ad57642140eaf | |
| parent | 13e9f688907fe19932e35b4c7fe1b6c1cfed57c7 (diff) | |
DB/Creature: Remy "Two Times"
By Killyana, closes #12616
| -rw-r--r-- | sql/updates/world/2015_05_30_03_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |