From 09260ee6c13e6350c8aa6dc0602ee3031537f16e Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 18 Oct 2010 13:19:04 +0200 Subject: Scripts/Forge of Souls: Revisited Bronjahm script, removed ugly hacks and fixed spells properly --HG-- branch : trunk --- sql/updates/10246_world_spell_linked_spell.sql | 3 +++ sql/updates/10246_world_spell_script_names.sql | 10 ++++++++++ 2 files changed, 13 insertions(+) create mode 100644 sql/updates/10246_world_spell_linked_spell.sql create mode 100644 sql/updates/10246_world_spell_script_names.sql (limited to 'sql/updates') 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'); -- cgit v1.2.3