From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/character_aura.md | 264 +++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 244 insertions(+), 20 deletions(-) (limited to 'docs/character_aura.md') diff --git a/docs/character_aura.md b/docs/character_aura.md index 048b285..ade1c23 100644 --- a/docs/character_aura.md +++ b/docs/character_aura.md @@ -1,20 +1,244 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_aura](character_aura) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -CasterGuid | bigint(20) unsigned | -ItemGuid | bigint(20) unsigned | -Spell | mediumint(8) unsigned | -EffectMask | tinyint(3) unsigned | -RecalculateMask | tinyint(3) unsigned | -StackCount | tinyint(3) unsigned | -Amount0 | int(11) | -Amount1 | int(11) | -Amount2 | int(11) | -Base_amount0 | int(11) | -Base_amount1 | int(11) | -Base_amount2 | int(11) | -MaxDuration | int(11) | -RemainTime | int(11) | -RemainCharges | tinyint(3) unsigned | +# 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. -- cgit