character_stats

This table holds information on all the stats regarding the character. Used for external applications such as websites. Needs a value >0 in config for PlayerSave.Stats.MinLevel

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int	unsigned	PRI	NO	0		Global Unique Identifier, Low part
maxhealth	int	unsigned		NO	0
maxpower1	int	unsigned		NO	0
maxpower2	int	unsigned		NO	0
maxpower3	int	unsigned		NO	0
maxpower4	int	unsigned		NO	0
maxpower5	int	unsigned		NO	0
maxpower6	int	unsigned		NO	0
maxpower7	int	unsigned		NO	0
strength	int	unsigned		NO	0
agility	int	unsigned		NO	0
stamina	int	unsigned		NO	0
intellect	int	unsigned		NO	0
spirit	int	unsigned		NO	0
armor	int	unsigned		NO	0
resHoly	int	unsigned		NO	0
resFire	int	unsigned		NO	0
resNature	int	unsigned		NO	0
resFrost	int	unsigned		NO	0
resShadow	int	unsigned		NO	0
resArcane	int	unsigned		NO	0
blockPct	float			NO	0
dodgePct	float			NO	0
parryPct	float			NO	0
critPct	float			NO	0
rangedCritPct	float			NO	0
spellCritPct	float			NO	0
attackPower	int	unsigned		NO	0
rangedAttackPower	int	unsigned		NO	0
spellPower	int	unsigned		NO	0
resilience	int	unsigned		NO	0

Description of fields

guid

The guid of the character.  

maxhealth

Maximum amount of health that the character has.  

maxpower1

Maximum amount of mana that the character has.  

maxpower2

Maximum amount of rage that the character has.  

maxpower3

Maximum amount of focus that the character has.  

maxpower4

Maximum amount of energy that the character has.  

maxpower5

Maximum amount of happiness that the character has.  

maxpower6

Maximum amount of rune that the character has.  

maxpower7

Maximum amount of runic power that the character has.  

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.