The `character_aura` table
Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | PRI | NO | 0 | Global Unique Identifier | |
| casterGuid | BIGINT | UNSIGNED | PRI | NO | 0 | Full Global Unique Identifier | |
| itemGuid | BIGINT | UNSIGNED | PRI | NO | 0 | ||
| spell | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| effectMask | TINYINT | UNSIGNED | PRI | NO | 0 | ||
| recalculateMask | TINYINT | UNSIGNED | NO | 0 | |||
| stackCount | TINYINT | UNSIGNED | NO | 1 | |||
| amount0 | INT | SIGNED | NO | 0 | |||
| amount1 | INT | SIGNED | NO | 0 | |||
| amount2 | INT | SIGNED | NO | 0 | |||
| base_amount0 | INT | SIGNED | NO | 0 | |||
| base_amount1 | INT | SIGNED | NO | 0 | |||
| base_amount2 | INT | SIGNED | NO | 0 | |||
| maxDuration | INT | SIGNED | NO | 0 | |||
| remainTime | INT | SIGNED | NO | 0 | |||
| remainCharges | TINYINT | UNSIGNED | NO | 0 |
Description of the fields
The GUID of the target affected by the aura. See characters.guid.
The GUID of the player who casted the aura. See characters.guid.
The GUID of the item which casted the aura. See item_instance.guid.
The spell from which the aura was applied. See Spell.dbc column 1.
The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2.
field-no-description|5
Determines how many stacks of the spell the character has.
The modifier value associated with the aura.
field-no-description|11
field-no-description|12
field-no-description|13
The maximum duration of the aura in ms.
The time remaining in ms on the aura. -1 means that the aura is indefinite.
The number of charges remaining on the aura.