Back-to:Characters
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 |
int(10) |
unsigned |
PRI |
NO |
0 |
|
Global Unique Identifier |
|
bigint(20) |
unsigned |
PRI |
NO |
0 |
|
Full Global Unique Identifier |
|
bigint(20) |
unsigned |
PRI |
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
PRI |
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
PRI |
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
1 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
guid
The GUID of the target affected by the aura. See characters.guid
caster_guid
The GUID of the player who casted the aura. See characters.guid
item_guid
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
effect_mask
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.
recalculate_mask
field-no-description|5
stackcount
Determines how many stacks of the spell the character has.
amount
The modifier value associated with the aura.
base_amount
field-no-description|8
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.