From d0d3d0f3c461d666305a646912b27c3516febc6d Mon Sep 17 00:00:00 2001
From: Xanvial <xanvial@gmail.com>
Date: Wed, 23 Jan 2013 01:20:31 +0700
Subject: Scripts/Creature: Hira Snowdawn no longer sells Tome of Cold Weather
 Flight

---
 sql/updates/world/2013_01_21_01_world_misc_434.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/updates/world/2013_01_21_01_world_misc_434.sql

(limited to 'sql')

diff --git a/sql/updates/world/2013_01_21_01_world_misc_434.sql b/sql/updates/world/2013_01_21_01_world_misc_434.sql
new file mode 100644
index 00000000000..dcf058b44e0
--- /dev/null
+++ b/sql/updates/world/2013_01_21_01_world_misc_434.sql
@@ -0,0 +1,4 @@
+-- NPC Hira Snowdawn no longer sells Tome of Cold Weather Flight
+UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=31238;
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=10723 AND `id`=1;
+DELETE FROM `npc_vendor` WHERE `entry`=31238 AND `item`=49177;
-- 
cgit v1.2.3