character_stats

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
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.

confluenceTd