Back-to:Characters
The `character_stats` table
This table holds information on all the stats regarding the character. Used for external applicaitons such as websites, etc.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
PRI |
NO |
0 |
|
Global Unique Identifier, Low part |
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
float |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
guid
The guid of the character.
maxhealth
Maximum amount of health that the character has.
maxpower
field-no-description|3
strength
field-no-description|4
agility
field-no-description|5
stamina
field-no-description|6
intellect
field-no-description|7
spirit
field-no-description|8
armor
field-no-description|9
resHoly
field-no-description|10
resFire
field-no-description|11
resNature
field-no-description|12
resFrost
field-no-description|13
resShadow
field-no-description|14
resArcane
field-no-description|15
blockPct
field-no-description|16
dodgePct
field-no-description|17
parryPct
field-no-description|18
critPct
field-no-description|19
rangedCritPct
field-no-description|20
spellCritPct
field-no-description|21
attackPower
field-no-description|22
rangedAttackPower
field-no-description|23
spellPower
field-no-description|24