Core/Spells: Update/Convert mage "Permafrost" for 4.3.4

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql
new file mode 100644
index 00000000000..1705485c672
--- /dev/null
+++ b/sql/updates/world/2013_07_20_07_world_spell_script_misc_434.sql
@@ -0,0 +1,13 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (-11175);
+INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
+(-11175,'spell_mage_permafrost');
+
+DELETE FROM `spell_ranks` WHERE `first_spell_id`=11175;
+INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES
+(11175, 11175, 1),
+(11175, 12569, 2),
+(11175, 12571, 3);
+
+DELETE FROM `spell_bonus_data` WHERE `entry`=91394;
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
+(91394, 0, 0, 0, 0, 'Mage - Permafrost');