From e7e49c56cf5b357c1bdcf1e199435dbeec17797e Mon Sep 17 00:00:00 2001 From: silinoron Date: Tue, 27 Jul 2010 21:12:40 -0700 Subject: Cleanup the mage spell scripts, and move SPELLFAMILY_PRIEST and SPELLFAMILY_ROGUE dummy effect handlers to spell scripts. --HG-- branch : trunk --- sql/scripts/world_scripts_full.sql | 12 +++++++++++- sql/updates/9058_world_spell_script_names.sql | 11 +++++++++++ 2 files changed, 22 insertions(+), 1 deletion(-) create mode 100644 sql/updates/9058_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index c50bcdafb73..1a5b035f611 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1650,7 +1650,17 @@ update creature_template set scriptname="boss_flame_leviathan_safety_container" DELETE FROM spell_script_names WHERE spell_id=19958 AND ScriptName='spell_mage_cold_snap'; DELETE FROM spell_script_names WHERE spell_id=32826 AND ScriptName='spell_mage_polymorph_visual'; DELETE FROM spell_script_names WHERE spell_id=31687 AND ScriptName='spell_mage_summon_water_elemental'; +DELETE FROM spell_script_names WHERE spell_id=-47540 AND ScriptName='spell_pri_penance'; +DELETE FROM spell_script_names WHERE spell_id=31231 AND ScriptName='spell_rog_cheat_death'; +DELETE FROM spell_script_names WHERE spell_id=51662 AND ScriptName='spell_rog_hunger_for_blood'; +DELETE FROM spell_script_names WHERE spell_id=14185 AND ScriptName='spell_rog_preparation'; +DELETE FROM spell_script_names WHERE spell_id=5938 AND ScriptName='spell_rog_shiv'; INSERT INTO spell_script_names (spell_id, ScriptName) VALUES (11958,'spell_mage_cold_snap'), (32826,'spell_mage_polymorph_visual'), -(31687,'spell_mage_summon_water_elemental'); +(31687,'spell_mage_summon_water_elemental'), +(-47540, 'spell_pri_penance'), +(31231,'spell_rog_cheat_death'), +(51662,'spell_rog_hunger_for_blood'), +(14185,'spell_rog_preparation'), +(5938,'spell_rog_shiv'); diff --git a/sql/updates/9058_world_spell_script_names.sql b/sql/updates/9058_world_spell_script_names.sql new file mode 100644 index 00000000000..1b2d54c967e --- /dev/null +++ b/sql/updates/9058_world_spell_script_names.sql @@ -0,0 +1,11 @@ +DELETE FROM spell_script_names WHERE spell_id=-47540 AND ScriptName='spell_pri_penance'; +DELETE FROM spell_script_names WHERE spell_id=31231 AND ScriptName='spell_rog_cheat_death'; +DELETE FROM spell_script_names WHERE spell_id=51662 AND ScriptName='spell_rog_hunger_for_blood'; +DELETE FROM spell_script_names WHERE spell_id=14185 AND ScriptName='spell_rog_preparation'; +DELETE FROM spell_script_names WHERE spell_id=5938 AND ScriptName='spell_rog_shiv'; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(-47540,'spell_pri_penance'), +(31231,'spell_rog_cheat_death'), +(51662,'spell_rog_hunger_for_blood'), +(14185,'spell_rog_preparation'), +(5938,'spell_rog_shiv'); -- cgit v1.2.3