AzerothCore
Pages :

character_aura

<-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.

Table 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.