aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorazazel <none@none>2010-09-21 23:59:45 +0600
committerazazel <none@none>2010-09-21 23:59:45 +0600
commit5eb0fd80acfb0fe93b6e0e1af09d8129534120c2 (patch)
treefe546aadaf823b8373283524c55df21227d23d3c /sql/updates
parent38be7aab55bd3cf09c8cc3f8832a018faf009338 (diff)
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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10029_world_spell_script_names.sql20
1 files changed, 20 insertions, 0 deletions
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';