character_aura

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

Description of fields

guid

The character guid of the target affected by the aura.  

casterGuid

The character guid player who casted the aura.  

itemGuid

The item guid of the item which casted the aura.  

spell

The Spell ID which applied the aura.  

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

Bitmask of effect indizes that can be recalculated.

Value	Name
1	EFFECT_1
2	EFFECT_2
4	EFFECT_3

 

stackCount

Determines how many stacks of the spell the character has.  

amount[0-2]

The base_amount + modifier value associated with the aura.  

base_amount[0-2]

The base_amount value associated with the aura.  

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.  

critChance

Crit chance of the caster at the moment of aura application.  

applyResilience

Boolean if this aura is subject to resilience

• 0: full amount
• 1: reduced by resilience