character_aura Table¶
Non-passive auras persisting on a character across logout, including self-cast stances/shapeshift forms. Passive spells are skipped by the save and re-applied from learned spells instead.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guid |
int(11) unsigned | PRI | NO | 0 | |
caster_guid |
bigint(20) unsigned | PRI | NO | 0 | |
item_guid |
int(11) unsigned | PRI | NO | 0 | |
spell |
int(11) unsigned | PRI | NO | 0 | |
stacks |
int(11) unsigned | NO | 1 | ||
charges |
int(11) unsigned | NO | 0 | ||
base_points0 |
float | NO | 0 | ||
base_points1 |
float | NO | 0 | ||
base_points2 |
float | NO | 0 | ||
periodic_time0 |
int(11) unsigned | NO | 0 | ||
periodic_time1 |
int(11) unsigned | NO | 0 | ||
periodic_time2 |
int(11) unsigned | NO | 0 | ||
max_duration |
int(11) | NO | 0 | ||
duration |
int(11) | NO | 0 | ||
effect_index_mask |
tinyint(3) unsigned | NO | 0 |
Field Breakdown¶
guid- Primary Key. Character guid carrying the aura (characters.guid).caster_guid- Primary Key. Unit guid of the aura caster (the player's own guid for self-cast auras;0only if applied without a caster object).item_guid- Primary Key. Item that granted the aura (proc/enchant), else 0.spell- Primary Key. Spell id producing this aura.stacks- Current stack count (refreshable auras).charges- Remaining proc/consumable charges.base_points0- Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.base_points1- Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.base_points2- Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.periodic_time0- Tick interval in ms for periodic effects 1-3.periodic_time1- Tick interval in ms for periodic effects 1-3.periodic_time2- Tick interval in ms for periodic effects 1-3.max_duration- Total duration in ms when applied.duration- Remaining duration in ms at save time.effect_index_mask- Bitmask of active effect indexes (bit0 = effect1 …).