The `spell_custom_attr` table
Table used for storing custom spell attributes.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| spell_id | MEDIUMINT | UNSIGNED | PRI | NO | 0 | spell id | |
| attributes | INT | UNSIGNED | NO | 0 | SpellCustomAttributes |
Description of the fields
Spell ID. See Spell.dbc .
Spell custom attributes from the enumeration SpellCustomAttributes in SpellInfo.h
| Attributes | Flag | Bit value | Comment |
|---|---|---|---|
| SPELL_ATTR0_CU_ENCHANT_PROC | 1 | 0x00000001 | |
| SPELL_ATTR0_CU_CONE_BACK | 2 | 0x00000002 | |
| SPELL_ATTR0_CU_CONE_LINE | 4 | 0x00000004 | |
| SPELL_ATTR0_CU_SHARE_DAMAGE | 8 | 0x00000008 | Meteor like spells (divided damage among all targets) |
| SPELL_ATTR0_CU_NO_INITIAL_THREAT | 16 | 0x00000010 | |
| SPELL_ATTR0_CU_AURA_CC | 32 | 0x00000020 | |
| SPELL_ATTR0_CU_DONT_BREAK_STEALTH | 64 | 0x00000040 | |
| SPELL_ATTR0_CU_NO_PVP_FLAG | 128 | 0x00000080 | Does not PvP flag |
| SPELL_ATTR0_CU_DIRECT_DAMAGE | 256 | 0x00000100 | |
| SPELL_ATTR0_CU_CHARGE | 512 | 0x00000200 | |
| SPELL_ATTR0_CU_PICKPOCKET | 1024 | 0x00000400 | |
| SPELL_ATTR0_CU_IGNORE_EVADE | 2048 | 0x00000800 | |
| SPELL_ATTR0_CU_NEGATIVE_EFF0 | 4096 | 0x00001000 | |
| SPELL_ATTR0_CU_NEGATIVE_EFF1 | 8192 | 0x00002000 | |
| SPELL_ATTR0_CU_NEGATIVE_EFF2 | 16384 | 0x00004000 | |
| SPELL_ATTR0_CU_IGNORE_ARMOR | 32768 | 0x00008000 | |
| SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER | 65536 | 0x00010000 | |
| SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET | 131072 | 0x00020000 | |
| SPELL_ATTR0_CU_ALLOW_INFLIGHT_TARGET | 262144 | 0x00040000 | |
| SPELL_ATTR0_CU_NEEDS_AMMO_DATA | 524288 | 0x00080000 | |
| SPELL_ATTR0_CU_BINARY_SPELL | 1048576 | 0x00100000 | |
| SPELL_ATTR0_CU_NO_POSITIVE_TAKEN_BONUS | 2097152 | 0x00200000 | |
| SPELL_ATTR0_CU_SINGLE_AURA_STACK | 4194304 | 0x00400000 | All sources add stacks the same aura |
| SPELL_ATTR0_CU_SCHOOLMASK_NORMAL_WITH_MAGIC | 8388608 | 0x00800000 | |
| SPELL_ATTR0_CU_AURA_CANNOT_BE_SAVED | 16777216 | 0x01000000 | |
| SPELL_ATTR0_CU_POSITIVE_EFF0 | 33554432 | 0x02000000 | |
| SPELL_ATTR0_CU_POSITIVE_EFF1 | 67108864 | 0x04000000 | |
| SPELL_ATTR0_CU_POSITIVE_EFF2 | 134217728 | 0x08000000 | |
| SPELL_ATTR0_CU_FORCE_SEND_CATEGORY_COOLDOWNS | 268435456 | 0x10000000 | |
| SPELL_ATTR0_CU_FORCE_AURA_SAVING | 536872960 | 0x20000800 | |
| SPELL_ATTR0_CU_ENCOUNTER_REWARD | 1073741824 | 0x40000000 |
-- (@SPELL_ATTR0_CU_NEGATIVE = @SPELL_ATTR0_CU_NEGATIVE_EFF0 | @SPELL_ATTR0_CU_NEGATIVE_EFF1 | @SPELL_ATTR0_CU_NEGATIVE_EFF2) -- (@SPELL_ATTR0_CU_POSITIVE = @SPELL_ATTR0_CU_POSITIVE_EFF0 | @SPELL_ATTR0_CU_POSITIVE_EFF1 | @SPELL_ATTR0_CU_POSITIVE_EFF2) DELETE FROM `spell_custom_attr` WHERE `spell_id`=123; INSERT INTO `spell_custom_attr` (`spell_id`, `attributes`) VALUES (123, @SPELL_ATTR0_CU_FLAG1 | @SPELL_ATTR0_CU_FLAG2);