character_aura
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
guid
The GUID of the target affected by the aura. See characters.guid.
casterGuid
The GUID of the player who casted the aura. See characters.guid.
itemGuid
The GUID of the item which casted the aura. See item_instance.guid.
spell
The spell from which the aura was applied. See Spell.dbc column 1.
effectMask
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.
recalculateMask
field-no-description|5
stackcount
Determines how many stacks of the spell the character has.
amount
The modifier value associated with the aura.
base_amount0
field-no-description|11
base_amount1
field-no-description|12
base_amount2
field-no-description|13
maxduration
The maximum duration of the aura in ms.
remaintime
The time remaining in ms on the aura. -1 means that the aura is indefinite.
remaincharges
The number of charges remaining on the aura.