Core/Spells: move Death Knights Presences into SpellScripts, fix possible issue after spec change, and fix some startup errors

Closes #10354

1 files changed, 22 insertions, 0 deletions

diff --git a/sql/updates/world/2013_07_25_00_spell_script_names.sql b/sql/updates/world/2013_07_25_00_spell_script_names.sql
new file mode 100644
index 00000000000..14e6d16df44
--- /dev/null
+++ b/sql/updates/world/2013_07_25_00_spell_script_names.sql
@@ -0,0 +1,22 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN (
+'spell_warl_banish',
+'spell_dru_enrage',
+'spell_pri_mana_burn',
+'spell_pri_guardian_spirit',
+'spell_dk_improved_blood_presence',
+'spell_dk_improved_frost_presence',
+'spell_dk_improved_unholy_presence',
+'spell_dk_presence'
+);
+
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(-710,  'spell_warl_banish'),
+(5229,  'spell_dru_enrage'),
+(8129,  'spell_pri_mana_burn'),
+(47788, 'spell_pri_guardian_spirit'),
+(-50365,'spell_dk_improved_blood_presence'),
+(-50384,'spell_dk_improved_frost_presence'),
+(-50391,'spell_dk_improved_unholy_presence'),
+(48266, 'spell_dk_presence'),
+(48263, 'spell_dk_presence'),
+(48265, 'spell_dk_presence');