Character stats tc2
Back to characters database list of tables.
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 |
| guid | int(10) | unsigned | PRI | NO | 0 | Global Unique Identifier, Low part | |
| maxhealth | int(10) | unsigned | NO | 0 | |||
| maxpower1 | int(10) | unsigned | NO | 0 | |||
| maxpower2 | int(10) | unsigned | NO | 0 | |||
| maxpower3 | int(10) | unsigned | NO | 0 | |||
| maxpower4 | int(10) | unsigned | NO | 0 | |||
| maxpower5 | int(10) | unsigned | NO | 0 | |||
| maxpower6 | int(10) | unsigned | NO | 0 | |||
| maxpower7 | int(10) | unsigned | NO | 0 | |||
| strength | int(10) | unsigned | NO | 0 | |||
| agility | int(10) | unsigned | NO | 0 | |||
| stamina | int(10) | unsigned | NO | 0 | |||
| intellect | int(10) | unsigned | NO | 0 | |||
| spirit | int(10) | unsigned | NO | 0 | |||
| armor | int(10) | unsigned | NO | 0 | |||
| resHoly | int(10) | unsigned | NO | 0 | |||
| resFire | int(10) | unsigned | NO | 0 | |||
| resNature | int(10) | unsigned | NO | 0 | |||
| resFrost | int(10) | unsigned | NO | 0 | |||
| resShadow | int(10) | unsigned | NO | 0 | |||
| resArcane | int(10) | unsigned | NO | 0 | |||
| blockPct | float | unsigned | NO | 0 | |||
| dodgePct | float | unsigned | NO | 0 | |||
| parryPct | float | unsigned | NO | 0 | |||
| critPct | float | unsigned | NO | 0 | |||
| rangedCritPct | float | unsigned | NO | 0 | |||
| spellCritPct | float | unsigned | NO | 0 | |||
| attackPower | int(10) | unsigned | NO | 0 | |||
| rangedAttackPower | int(10) | unsigned | NO | 0 | |||
| spellPower | int(10) | unsigned | NO | 0 | |||
| resilience | 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
1 - mana 2 - rage 3 - focus 4 - energy 5 - happiness 6 - rune 7 - runic power
strength
Character's current strength value.
agility
Character's current agility value.
stamina
Character's current stamina value.
intellect
Character's current intellect value.
spirit
Character's current spirit value.
armor
Character's current armor value.
resHoly
Character's current holy resistance value.
resFire
Character's current fire resistance value.
resNature
Character's current nature resistance value.
resFrost
Character's current frost resistance value.
resShadow
Character's current shadow resistance value.
resArcane
Character's current arcane resistance value.
blockPct
Character's current block chance.
dodgePct
Character's current dodge chance.
parryPct
Character's current parry chance.
critPct
Character's current crit chance.
rangedCritPct
Character's current ranged crit chance.
spellCritPct
Character's current spell crit chance.
attackPower
Character's current attackpower.
rangedAttackPower
Character's current ranged attackpower.
spellPower
Character's current spellpower.
resilience
Character's current resilience value.
