blob: a6b9dd1ec54ad27bf722179ed69ced111a31812d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
# character\_aura
[<-Back-to:Characters](database-characters.md)
**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][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier |
| [casterGuid][2] | BIGINT | UNSIGNED | PRI | NO | 0 | | Full Global Unique Identifier |
| [itemGuid][3] | BIGINT | UNSIGNED | PRI | NO | 0 | | |
| [spell][4] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [effectMask][5] | TINYINT | UNSIGNED | PRI | NO | 0 | | |
| [recalculateMask][6] | TINYINT | UNSIGNED | | NO | 0 | | |
| [stackCount][7] | TINYINT | UNSIGNED | | NO | 1 | | |
| [amount0][8] | INT | SIGNED | | NO | 0 | | |
| [amount1][9] | INT | SIGNED | | NO | 0 | | |
| [amount2][10] | INT | SIGNED | | NO | 0 | | |
| [base_amount0][11] | INT | SIGNED | | NO | 0 | | |
| [base_amount1][12] | INT | SIGNED | | NO | 0 | | |
| [base_amount2][13] | INT | SIGNED | | NO | 0 | | |
| [maxDuration][14] | INT | SIGNED | | NO | 0 | | |
| [remainTime][15] | INT | SIGNED | | NO | 0 | | |
| [remainCharges][16] | TINYINT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #casterguid
[3]: #itemguid
[4]: #spell
[5]: #effectmask
[6]: #recalculatemask
[7]: #stackcount
[8]: #amount
[9]: #amount
[10]: #amount
[11]: #baseamount0
[12]: #baseamount1
[13]: #baseamount2
[14]: #maxduration
[15]: #remaintime
[16]: #remaincharges
**Description of the fields**
### guid
The GUID of the target affected by the aura. See [characters.guid](characters#guid).
### casterGuid
The GUID of the player who casted the aura. See [characters.guid](characters#guid).
### itemGuid
The GUID of the item which casted the aura. See [item\_instance.guid](item\_instance#guid).
### spell
The spell from which the aura was applied. See [Spell.dbc](spell) column 1.
### 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
`field-no-description|5`
### stackcount
Determines how many stacks of the spell the character has.
### amount
The modifier value associated with the aura.
### base\_amount0
`field-no-description|11`
### base\_amount1
`field-no-description|12`
### base\_amount2
`field-no-description|13`
### 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.
|
