Cleanup the mage spell scripts, and move SPELLFAMILY_PRIEST and SPELLFAMILY_ROGUE dummy effect handlers to spell scripts.

--HG--
branch : trunk

1 files changed, 11 insertions, 0 deletions

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');