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

2 files changed, 83 insertions, 2 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 6099d56ce93..d44b6641b06 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14740,6 +14740,9 @@ LOCK TABLES `spell_script_names` WRITE;
 INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 -- generic
 ( 58601, 'spell_gen_remove_flight_auras'),
+-- quest
+( 45449, 'spell_q11587_arcane_prisoner_rescue'),
+( 46023, 'spell_q11730_ultrasonic_screwdriver'),
 -- warrior
 ( 12975,'spell_warr_last_stand'),
 -- paladin
@@ -14747,9 +14750,12 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 (-20473, 'spell_pal_holy_shock'),
 ( 37877, 'spell_pal_blessing_of_faith'),
 -- hunter
-( 23989, 'spell_hun_readiness'),
+( 53209, 'spell_hun_chimera_shot'),
+( 53412, 'spell_hun_invigoration'),
 ( 53271, 'spell_hun_masters_call'),
 ( 53478, 'spell_hun_last_stand_pet'),
+( 23989, 'spell_hun_readiness'),
+( 37506, 'spell_hun_scatter_shot'),
 ( 55709, 'spell_hun_pet_heart_of_the_phoenix'),
 ( 54044, 'spell_hun_pet_carrion_feeder'),
 -- rogue
@@ -14761,13 +14767,23 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 47948, 'spell_pri_pain_and_suffering_proc'),
 (-47540, 'spell_pri_penance'),
 -- death knight
+(-49158,'spell_dk_corpse_explosion'),
+( 50524,'spell_dk_runic_power_feed'),
+(-55090,'spell_dk_scourge_strike'),
 -- shaman
+( 39610, 'spell_sha_mana_tide_totem'),
+( -1535, 'spell_sha_fire_nova'),
 -- mage
 ( 11958, 'spell_mage_cold_snap'),
 ( 31687, 'spell_mage_summon_water_elemental'),
-( 32826, 'spell_mage_polymorph_visual');
+( 32826, 'spell_mage_polymorph_visual'),
 -- warlock
+( -6201, 'spell_warl_create_healthstone'),
+( 47193, 'spell_warl_demonic_empowerment'),
+( 47422, 'spell_warl_everlasting_affliction'),
+( 63521, 'spell_warl_guarded_by_the_light'),
 -- druid
+( 54846, 'spell_dru_glyph_of_starfire');
 /*!40000 ALTER TABLE `spell_script_names` ENABLE KEYS */;
 UNLOCK TABLES;
 
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');