From 677663139cd130be502d5854d7ab7d1aebdf494c Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 17 Aug 2019 17:42:58 +0200 Subject: Core/Spells: Removed PROC_ATTR_DISABLE_EFF_* attributes and store that in a separate column --- sql/updates/world/3.3.5/2019_08_17_01_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_08_17_01_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3