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.