SQL Standards for Flags and Bits

ghost commented 3 years ago

When I was changing creature_template the query was not in sync with the SQL standards implemented. Would be nice to get the job done using Keira instead of manually changing the query 😀

Wrong example:

UPDATE `creature_template` SET `mechanic_immune_mask` = 617299803 WHERE `entry` = 7727;

Good example:

-- Adding flags
UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|64|256|1024 WHERE `entry` = 7727;

-- Removing flags
UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`&~(64|256|1024) WHERE `entry` = 7727;

Link: https://www.azerothcore.org/wiki/sql-standards#flags-amp-bits

--- Want to back this issue? **[Post a bounty on it!](https://app.bountysource.com/issues/99383440-sql-standards-for-flags-and-bits?utm_campaign=plugin&utm_content=tracker%2F139701226&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://app.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F139701226&utm_medium=issues&utm_source=github).