aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorRobingad <robingad@rambler.ru>2022-01-27 23:18:46 +0200
committerGitHub <noreply@github.com>2022-01-27 22:18:46 +0100
commit3e725e1d2521547ea651ef2b4e01c980c9b5ff3e (patch)
tree40575fe4c28c4d785669680aac0c9308bc97070a /sql/updates
parent2b7545378a53a0bc9b11a5a73ebf7b2f7aee7a7b (diff)
Scripts/Spells: Fix shaman Earthquake (#27620)
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2022_01_27_02_world_shaman_earthquake.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_27_02_world_shaman_earthquake.sql b/sql/updates/world/master/2022_01_27_02_world_shaman_earthquake.sql
new file mode 100644
index 00000000000..07cd68709f9
--- /dev/null
+++ b/sql/updates/world/master/2022_01_27_02_world_shaman_earthquake.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_earthquake_tick';
+
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(77478, 'spell_sha_earthquake_tick'); -- Earthquake
+
+UPDATE `areatrigger_create_properties` SET `ScriptName`='areatrigger_sha_earthquake' WHERE `Id`=3691;
+
+DELETE FROM `spell_proc` WHERE `SpellId` IN (273221);
+INSERT INTO `spell_proc` (`SpellId`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`SpellFamilyMask3`,`ProcFlags`,`SpellTypeMask`,`SpellPhaseMask`,`HitMask`,`AttributesMask`,`DisableEffectsMask`,`ProcsPerMinute`,`Chance`,`Cooldown`,`Charges`) VALUES
+(273221,0x00,11,0x00000000,0x00000000,0x00000000,0x00000000,0x0,0x0,0x1,0x0,0x0,0x0,0,0,0,0); -- Aftershock