Merge pull request #9009 from Souler/fix_mage_rof

[4.3.4] Spells/Mage: Ring of Frost

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2013_01_26_01_world_misc_434.sql b/sql/updates/world/2013_01_26_01_world_misc_434.sql
new file mode 100644
index 00000000000..2abe6090c3f
--- /dev/null
+++ b/sql/updates/world/2013_01_26_01_world_misc_434.sql
@@ -0,0 +1,7 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (82676, 82691);
+INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
+(82676, 'spell_mage_ring_of_frost'),
+(82691, 'spell_mage_ring_of_frost_freeze');
+
+-- Set flags UNIT_FLAG_DISABLE_MOVE| UNIT_FLAG_STUNNED|UNIT_FLAG_NOT_SELECTABLE on Ring of Frost
+UPDATE `creature_template` SET `unit_flags` = 0x4|0x40000|0x2000000 WHERE `entry` = 44199;