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.

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

caster_guid

bigint(20)

unsigned

PRI

NO

0

 

Full Global Unique Identifier

item_guid

bigint(20)

unsigned

PRI

NO

0

 

 

spell

mediumint(8)

unsigned

PRI

NO

0

 

 

effect_mask

tinyint(3)

unsigned

PRI

NO

0

 

 

recalculate_mask

tinyint(3)

unsigned

 

NO

0

 

 

stackcount

tinyint(3)

unsigned

 

NO

1

 

 

amount0

int(11)

signed

 

NO

0

 

 

amount1

int(11)

signed

 

NO

0

 

 

amount2

int(11)

signed

 

NO

0

 

 

base_amount0

int(11)

signed

 

NO

0

 

 

base_amount1

int(11)

signed

 

NO

0

 

 

base_amount2

int(11)

signed

 

NO

0

 

 

maxduration

int(11)

signed

 

NO

0

 

 

remaintime

int(11)

signed

 

NO

0

 

 

remaincharges

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.