From 44c8ccadd701c1a4bc0ce08ee53a7a7ba55289d4 Mon Sep 17 00:00:00 2001 From: ariel- Date: Fri, 15 Dec 2017 00:14:55 -0300 Subject: Core/Auras: periodics refactor part 5: ported periodic trigger spell auras to scripts (cherry picked from commit a36e804ae4639be40be17282e6c79fad9a769517) --- ...2021_03_13_01_world_2017_12_15_03_world_335.sql | 36 ++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 sql/updates/world/master/2021_03_13_01_world_2017_12_15_03_world_335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2021_03_13_01_world_2017_12_15_03_world_335.sql b/sql/updates/world/master/2021_03_13_01_world_2017_12_15_03_world_335.sql new file mode 100644 index 00000000000..9b3615f65fc --- /dev/null +++ b/sql/updates/world/master/2021_03_13_01_world_2017_12_15_03_world_335.sql @@ -0,0 +1,36 @@ +-- UPDATE `spell_dbc` SET `EffectTriggerSpell1`=30571 WHERE `Id`=30576; +UPDATE `serverside_spell_effect` SET `EffectTriggerSpell`=30576 WHERE `SpellID`=30576 AND `EffectIndex`=0 AND `DifficultyID`=0; +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gen_restoration','spell_gen_nitrous_boost','spell_kelthuzad_frost_blast','spell_inoculate_nestlewood','spell_item_extract_gas','spell_alar_flame_quills','spell_item_absorb_eye_of_grillok','spell_sha_t3_8p_bonus','spell_pursuing_spikes',/*'spell_sha_mana_tide',*/'spell_gen_negative_energy_periodic','spell_jormungars_slime_pool',/*'spell_pal_beacon_of_light',*/'spell_silithus_summon_cultist_periodic'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(23493, 'spell_gen_restoration'), +(24379, 'spell_gen_restoration'), +(27746, 'spell_gen_nitrous_boost'), +(27808, 'spell_kelthuzad_frost_blast'), +(29528, 'spell_inoculate_nestlewood'), +(30427, 'spell_item_extract_gas'), +(34229, 'spell_alar_flame_quills'), +(38554, 'spell_item_absorb_eye_of_grillok'), +(28820, 'spell_sha_t3_8p_bonus'), +(65920, 'spell_pursuing_spikes'), +(65922, 'spell_pursuing_spikes'), +(65923, 'spell_pursuing_spikes'), +-- (16191, 'spell_sha_mana_tide'), +(46284, 'spell_gen_negative_energy_periodic'), +(66882, 'spell_jormungars_slime_pool'), +-- (53563, 'spell_pal_beacon_of_light'), +(24745, 'spell_silithus_summon_cultist_periodic'), +(24747, 'spell_silithus_summon_cultist_periodic'), +(24757, 'spell_silithus_summon_cultist_periodic'), +(24759, 'spell_silithus_summon_cultist_periodic'), +(24761, 'spell_silithus_summon_cultist_periodic'), +(24762, 'spell_silithus_summon_cultist_periodic'), +(24766, 'spell_silithus_summon_cultist_periodic'), +(24769, 'spell_silithus_summon_cultist_periodic'), +(24771, 'spell_silithus_summon_cultist_periodic'), +(24773, 'spell_silithus_summon_cultist_periodic'), +(24785, 'spell_silithus_summon_cultist_periodic'), +(24787, 'spell_silithus_summon_cultist_periodic'), +(24791, 'spell_silithus_summon_cultist_periodic'), +(24792, 'spell_silithus_summon_cultist_periodic'), +(24793, 'spell_silithus_summon_cultist_periodic'), +(46595, 'spell_silithus_summon_cultist_periodic'); -- cgit v1.2.3