diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 10 | ||||
| -rw-r--r-- | sql/updates/10246_world_spell_linked_spell.sql | 3 | ||||
| -rw-r--r-- | sql/updates/10246_world_spell_script_names.sql | 10 |
3 files changed, 23 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 01119ed3c4e..a15c71f8cef 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18156,6 +18156,8 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 67623,-67620, 1, 'Remove Paralytic Toxin when hit by Burning Bite'), (-66683, 68667, 0, 'Icehowl - Surge of Adrenaline'), (-67661, 68667, 0, 'Icehowl - Surge of Adrenaline'), +-- Forge of Souls +(-68839, 68846, 0, 'Bronjahm: Corrupt Soul Summon'), -- Icecrown Citadel (-69674, 69706, 0, 'Rotface: Mutated Infection Summon'), (-71224, 69706, 0, 'Rotface: Mutated Infection Summon'), @@ -26784,6 +26786,13 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 72752, 'spell_pvp_trinket_wotf_shared_cd'), ( 72757, 'spell_pvp_trinket_wotf_shared_cd'), -- instances +-- Forge of Souls +( 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'), +-- Icecrown Citadel ( 69057, 'spell_marrowgar_bone_spike_graveyard'), ( 69140, 'spell_marrowgar_coldflame'), ( 72705, 'spell_marrowgar_coldflame'), @@ -26861,6 +26870,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 72457, 'spell_putricide_regurgitated_ooze'), ( 72875, 'spell_putricide_regurgitated_ooze'), ( 72876, 'spell_putricide_regurgitated_ooze'), +-- Ulduar ( 62717, 'spell_ignis_slag_pot'), ( 63477, 'spell_ignis_slag_pot'), -- quest 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'); |