From 5eb0fd80acfb0fe93b6e0e1af09d8129534120c2 Mon Sep 17 00:00:00 2001 From: azazel Date: Tue, 21 Sep 2010 23:59:45 +0600 Subject: 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 --- sql/updates/10029_world_spell_script_names.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/10029_world_spell_script_names.sql (limited to 'sql/updates') 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'; -- cgit v1.2.3