diff options
| author | Xanvial <xanvial@gmail.com> | 2013-01-23 01:20:31 +0700 |
|---|---|---|
| committer | Xanvial <xanvial@gmail.com> | 2013-01-23 01:20:31 +0700 |
| commit | d0d3d0f3c461d666305a646912b27c3516febc6d (patch) | |
| tree | 46e404c7a2bf3426438301c0f8e045b58a04a755 /sql | |
| parent | d258c12d734534338540117c045eebe788ef157b (diff) | |
Scripts/Creature: Hira Snowdawn no longer sells Tome of Cold Weather Flight
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_01_21_01_world_misc_434.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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; |