Add more methods to SpellScript.

Spells cleanup: move spells from the core to scripts.

* Shaman spells: 39610 Mana Tide Totem, 1535 Fire Nova (and ranks)
* Death Knight spells: 55090 Scourge Strike (and ranks), 49158 Corpse Explosion (and ranks), 50524 Runic Power Feed
* Druid spells: 54846 Glyph of Starfire
* Warlock spells: 6201 Create Healthstone (and ranks), 47422 Everlasting Affliction, 47193 Demonic Empowerment, 63521 Guarded by The Light
* Hunter spells: 37506 Scatter Shot, 53412 Invigoration, 53209 Chimera Shot
* Quest spells: 45449 Arcane Prisoner Rescue (quest 11587), 46023 The Ultrasonic Screwdriver (quest 11730). Closes issue #3068

Clean old code for hunter's Heart of the Phoenix, move script effect of hunter's Master's Call to corresponding script.
Move DK's Hungering Cold to spell_scripts table (needs DB support)

--HG--
branch : trunk

1 files changed, 65 insertions, 0 deletions

diff --git a/sql/updates/9436_world_spell_script_names.sql b/sql/updates/9436_world_spell_script_names.sql
new file mode 100644
index 00000000000..5b70ef3e0fe
--- /dev/null
+++ b/sql/updates/9436_world_spell_script_names.sql
@@ -0,0 +1,65 @@
+-- QUEST SPELLS
+-- 45449 Arcane Prisoner Rescue
+DELETE FROM `spell_script_names` WHERE `spell_id`=45449 AND `ScriptName`='spell_q11587_arcane_prisoner_rescue';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (45449,'spell_q11587_arcane_prisoner_rescue');
+
+-- 46023 The Ultrasonic Screwdriver
+DELETE FROM `spell_script_names` WHERE `spell_id`=46023 AND `ScriptName`='spell_q11730_ultrasonic_screwdriver';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (46023,'spell_q11730_ultrasonic_screwdriver');
+
+-- SHAMAN SPELLS
+-- 1535 Fire Nova (and ranks)
+DELETE FROM `spell_script_names` WHERE `spell_id`=-1535 AND `ScriptName`='spell_sha_fire_nova';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-1535,'spell_sha_fire_nova');
+
+-- 39610 Mana Tide Totem
+DELETE FROM `spell_script_names` WHERE `spell_id`=39610 AND `ScriptName`='spell_sha_mana_tide_totem';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (39610,'spell_sha_mana_tide_totem');
+
+-- DEATH KNIGHT SPELLS
+-- 49158 Corpse Explosion (and ranks)
+DELETE FROM `spell_script_names` WHERE `spell_id`=-49158 AND `ScriptName`='spell_dk_corpse_explosion';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-49158,'spell_dk_corpse_explosion');
+
+-- 50524 Runic Power Feed
+DELETE FROM `spell_script_names` WHERE `spell_id`=50524 AND `ScriptName`='spell_dk_runic_power_feed';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (50524,'spell_dk_runic_power_feed');
+
+-- 55090 Scourge Strike (and ranks)
+DELETE FROM `spell_script_names` WHERE `spell_id`=-55090 AND `ScriptName`='spell_dk_scourge_strike';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-55090,'spell_dk_scourge_strike');
+
+-- DRUID SPELLS
+-- 54846 Glyph of Starfire
+DELETE FROM `spell_script_names` WHERE `spell_id`=54846 AND `ScriptName`='spell_dru_glyph_of_starfire';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (54846,'spell_dru_glyph_of_starfire');
+
+-- WARLOCK SPELLS
+-- 6201 Create Healthstone (and ranks)
+DELETE FROM `spell_script_names` WHERE `spell_id`=-6201 AND `ScriptName`='spell_warl_create_healthstone';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-6201,'spell_warl_create_healthstone');
+
+-- 47193 Demonic Empowerment
+DELETE FROM `spell_script_names` WHERE `spell_id`=47193 AND `ScriptName`='spell_warl_demonic_empowerment';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (47193,'spell_warl_demonic_empowerment');
+
+-- 47422 Everlasting Affliction
+DELETE FROM `spell_script_names` WHERE `spell_id`=47422 AND `ScriptName`='spell_warl_everlasting_affliction';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (47422,'spell_warl_everlasting_affliction');
+
+-- 63521 Guarded by The Light
+DELETE FROM `spell_script_names` WHERE `spell_id`=63521 AND `ScriptName`='spell_warl_guarded_by_the_light';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (63521,'spell_warl_guarded_by_the_light');
+
+-- HUNTER SPELLS
+-- 53209 Chimera Shot
+DELETE FROM `spell_script_names` WHERE `spell_id`=53209 AND `ScriptName`='spell_hun_chimera_shot';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (53209,'spell_hun_chimera_shot');
+
+-- 53412 Invigoration
+DELETE FROM `spell_script_names` WHERE `spell_id`=53412 AND `ScriptName`='spell_hun_invigoration';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (53412,'spell_hun_invigoration');
+
+-- 37506 Scatter Shot
+DELETE FROM `spell_script_names` WHERE `spell_id`=37506 AND `ScriptName`='spell_hun_scatter_shot';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (37506,'spell_hun_scatter_shot');