Scripts/Spells: move implementation of some spells into scripts.

* 41337 Aura of Anger
* 46394 Burn (Brutallus)
* 53302 Sniper Training
* 45472 Parachute
* 66118 Leeching Swarm
* 51685 Prey on the Weak
* 20911 Blessing of Sanctuary
* 25899 Greater Blessing of Sanctuary
Scripts/Spells: remove several spells implementations from core to table (requires DB data)
* 31231 Cheat Death
* 51662 Hunger for Blood

--HG--
branch : trunk

2 files changed, 28 insertions, 2 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 018ee3894b2..43ec1457c75 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -26752,8 +26752,12 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 24750, 'spell_gen_trick'),
 ( 24751, 'spell_gen_trick_or_treat'),
 ( 29266, 'spell_creature_permanent_feign_death'),
+( 41337, 'spell_gen_aura_of_anger'),
+( 45472, 'spell_gen_parachute'),
+( 46394, 'spell_gen_burn_brutallus'),
 ( 57685, 'spell_creature_permanent_feign_death'),
 ( 58601, 'spell_gen_remove_flight_auras'),
+( 66118, 'spell_gen_leeching_swarm'),
 ( 58951, 'spell_creature_permanent_feign_death'),
 ( 70592, 'spell_creature_permanent_feign_death'),
 ( 70628, 'spell_creature_permanent_feign_death'),
@@ -26829,6 +26833,8 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 20425, 'spell_pal_judgement_of_command'),
 ( 63521, 'spell_pal_guarded_by_the_light'),
 (-20473, 'spell_pal_holy_shock'),
+( 20911, 'spell_pal_blessing_of_sanctuary'),
+( 25899, 'spell_pal_blessing_of_sanctuary')
 ( 37877, 'spell_pal_blessing_of_faith'),
 -- hunter
 ( 53209, 'spell_hun_chimera_shot'),
@@ -26837,13 +26843,13 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 53478, 'spell_hun_last_stand_pet'),
 ( 23989, 'spell_hun_readiness'),
 ( 37506, 'spell_hun_scatter_shot'),
+(-53302, 'spell_hun_sniper_training'),
 ( 55709, 'spell_hun_pet_heart_of_the_phoenix'),
 ( 54044, 'spell_hun_pet_carrion_feeder'),
 -- rogue
 (  5938, 'spell_rog_shiv'),
 ( 14185, 'spell_rog_preparation'),
-( 31231, 'spell_rog_cheat_death'),
-( 51662, 'spell_rog_hunger_for_blood'),
+(-51685, 'spell_rog_prey_on_the_weak'),
 -- priest
 ( 47948, 'spell_pri_pain_and_suffering_proc'),
 (-47540, 'spell_pri_penance'),
diff --git a/sql/updates/10029_world_spell_script_names.sql b/sql/updates/10029_world_spell_script_names.sql
new file mode 100644
index 00000000000..d49fbb41f8b
--- /dev/null
+++ b/sql/updates/10029_world_spell_script_names.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=41337 AND `ScriptName`='spell_gen_aura_of_anger';
+DELETE FROM `spell_script_names` WHERE `spell_id`=46394 AND `ScriptName`='spell_gen_burn_brutallus';
+DELETE FROM `spell_script_names` WHERE `spell_id`=-53302 AND `ScriptName`='spell_hun_sniper_training';
+DELETE FROM `spell_script_names` WHERE `spell_id`=45472 AND `ScriptName`='spell_gen_parachute';
+DELETE FROM `spell_script_names` WHERE `spell_id`=-51685 AND `ScriptName`='spell_rog_prey_on_the_weak';
+DELETE FROM `spell_script_names` WHERE `spell_id`=66118 AND `ScriptName`='spell_gen_leeching_swarm';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (20911,25899) AND `ScriptName`='spell_pal_blessing_of_sanctuary';
+
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES 
+(41337,'spell_gen_aura_of_anger'),
+(46394,'spell_gen_burn_brutallus'),
+(-53302,'spell_hun_sniper_training'),
+(45472,'spell_gen_parachute'),
+(-51685,'spell_rog_prey_on_the_weak'),
+(66118,'spell_gen_leeching_swarm'),
+(20911,'spell_pal_blessing_of_sanctuary'),
+(25899,'spell_pal_blessing_of_sanctuary');
+
+DELETE FROM `spell_script_names` WHERE `spell_id`=51662 AND `ScriptName`='spell_rog_hunger_for_blood';
+DELETE FROM `spell_script_names` WHERE `spell_id`=31231 AND `ScriptName`='spell_rog_cheat_death';