aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-12-15 00:14:55 -0300
committerariel- <ariel-@users.noreply.github.com>2017-12-15 01:46:52 -0300
commita36e804ae4639be40be17282e6c79fad9a769517 (patch)
treeddd718a5dee49d189de257cbd2748f6474e4b914 /sql
parent193bd3b45264326011814a5ee7694b9bbe13eb75 (diff)
Core/Auras: periodics refactor part 5: ported periodic trigger spell auras to scripts
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2017_12_15_03_world_335.sql35
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_15_03_world_335.sql b/sql/updates/world/3.3.5/2017_12_15_03_world_335.sql
new file mode 100644
index 00000000000..342129c7360
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_12_15_03_world_335.sql
@@ -0,0 +1,35 @@
+UPDATE `spell_dbc` SET `EffectTriggerSpell1`=30571 WHERE `Id`=30576;
+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');