aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2019-08-17 17:42:58 +0200
committerShauren <shauren.trinity@gmail.com>2019-08-17 17:42:58 +0200
commit677663139cd130be502d5854d7ab7d1aebdf494c (patch)
tree7ec3583a03469e7ce08e99660daa451f6a917302 /sql
parentea16c4ac9fcbef26ce28865212af904e2a0f6db8 (diff)
Core/Spells: Removed PROC_ATTR_DISABLE_EFF_* attributes and store that in a separate column
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2019_08_17_01_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_08_17_01_world.sql b/sql/updates/world/3.3.5/2019_08_17_01_world.sql
new file mode 100644
index 00000000000..f9239dd8a2e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_17_01_world.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `spell_proc` ADD `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesMask`;
+
+UPDATE `spell_proc` SET `DisableEffectsMask`=((`AttributesMask` >> 4) & 0x7);
+UPDATE `spell_proc` SET `AttributesMask`=(`AttributesMask` & 0xF);