From 66fcd52106bb14961498afb9d3f0344e21d0890b Mon Sep 17 00:00:00 2001
From: azazel <none@none>
Date: Wed, 18 Aug 2010 00:20:23 +0600
Subject: 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
---
 sql/base/world_database.sql | 20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

(limited to 'sql/base/world_database.sql')

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;
 
-- 
cgit v1.2.3