SQL Standards for Flags and Bits

[ghost]

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! We accept bounties via Bountysource.

[Helias]

yep, we need to do this

[Azcobu]

Been caught by this as well, definitely support this idea.

[Kitzunu]

Any eta on this https://www.azerothcore.org/wiki/sql-standards#flags-amp-bits

much safer way of dealing with flags

[FrancescoBorzi]

no ETA because I'm very busy, if someone wants to help and implement it would be welcome of course

[FrancescoBorzi]

@claudiodfc why closing?