From cc899ddc2d57524d45958db52b9eccaa7603e433 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sat, 29 Jun 2013 18:46:22 +0200 Subject: DB/Misc: - Convert c_t_a entry into c_a to prevent errors - Allow mounting in Black Temple - fix by exodius to add sound for Corrupted Ashbringer Closes #9997 --- sql/updates/world/2013_06_29_01_world_creature_addon.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2013_06_29_01_world_creature_addon.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_29_01_world_creature_addon.sql b/sql/updates/world/2013_06_29_01_world_creature_addon.sql new file mode 100644 index 00000000000..e7ec3a48752 --- /dev/null +++ b/sql/updates/world/2013_06_29_01_world_creature_addon.sql @@ -0,0 +1,10 @@ +DELETE FROM `creature_template_addon` WHERE `entry`=17975; +DELETE FROM `creature_addon` WHERE `guid`=82987; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(82987,829870,0,0,1,0,''); -- Converted from c_t_a, works on both normal and heroic entry + +-- allow mounting inside Black Temple (outdoor areas) +UPDATE `instance_template` SET `allowMount`=1 WHERE `map`=564; + +-- fix for issue #9997 by Exodius +UPDATE `spell_script_names` SET `spell_id`=28441 WHERE `spell_id`=28414 AND `ScriptName`='spell_item_ashbringer'; -- cgit v1.2.3