Back to 'character_arena_stats' Return to characters Go to 'character_banned'
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.
| 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 | |||
| critChance | float | NO | 0 | ||||
| applyResilience | tinyint | signed | NO | 0 |
The character guid of the target affected by the aura.
The character guid player who casted the aura.
The item guid of the item which casted the aura.
The SpellID from Spell.dbc which applied the aura.
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.
Bitmask of effect indizes that can be recalculated.
| Value | Name |
|---|---|
| 1 | EFFECT_1 |
| 2 | EFFECT_2 |
| 4 | EFFECT_3 |
Determines how many stacks of the spell the character has.
The base_amount + modifier value associated with the aura.
The base_amount value associated with the aura.
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.
Crit chance of the caster at the moment of aura application.
Boolean if this aura is subject to resilience
Back to 'character_arena_stats' Return to characters Go to 'character_banned'