Character aura tc2
|
Back to characters database list of tables.
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
This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.
stackcount
Determines how many stacks of the spell the character has.
amount
The modifier value associated with the aura.
base_amount
This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.
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.
