Back-to:Characters
The `character_stats` table
This table holds information on all the stats regarding the character. Used for external applications such as websites.
See worldserver.conf: PlayerSave.Stats.*
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 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
|
Description of the fields
The guid of the character.
Maximum amount of health that the character has.
1 - mana
2 - rage
3 - focus
4 - energy
5 - happiness
6 - rune
7 - runic power
Character's current strength value.
Character's current agility value.
Character's current stamina value.
Character's current intellect value.
Character's current spirit value.
Character's current armor value.
Character's current holy resistance value.
Character's current fire resistance value.
Character's current nature resistance value.
Character's current frost resistance value.
Character's current shadow resistance value.
Character's current arcane resistance value.
Character's current block chance.
Character's current dodge chance.
Character's current parry chance.
Character's current crit chance.
Character's current ranged crit chance.
Character's current spell crit chance.
Character's current attackpower.
Character's current ranged attackpower.
Character's current spellpower.
Character's current resilience value.
confluenceTd