Scripts/Forge of Souls: Revisited Bronjahm script, removed ugly hacks and fixed spells properly

--HG--
branch : trunk

2 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/10246_world_spell_linked_spell.sql b/sql/updates/10246_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..46cfa0d936d
--- /dev/null
+++ b/sql/updates/10246_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-68839;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(-68839,68846,0, 'Bronjahm: Corrupt Soul Summon');
diff --git a/sql/updates/10246_world_spell_script_names.sql b/sql/updates/10246_world_spell_script_names.sql
new file mode 100644
index 00000000000..1b049bb9ea6
--- /dev/null
+++ b/sql/updates/10246_world_spell_script_names.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (68793,69050) AND `ScriptName`='spell_bronjahm_magic_bane';
+DELETE FROM `spell_script_names` WHERE `spell_id`=68861 AND `ScriptName`='spell_bronjahm_consume_soul';
+DELETE FROM `spell_script_names` WHERE `spell_id`=69008 AND `ScriptName`='spell_bronjahm_soulstorm_channel';
+DELETE FROM `spell_script_names` WHERE `spell_id`=68870 AND `ScriptName`='spell_bronjahm_soulstorm_visual';
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(68793,'spell_bronjahm_magic_bane'),
+(69050,'spell_bronjahm_magic_bane'),
+(68861,'spell_bronjahm_consume_soul'),
+(69008,'spell_bronjahm_soulstorm_channel'),
+(68870,'spell_bronjahm_soulstorm_visual');