Skip to content

character_stats Table

Snapshot of cached combat stats (max health/powers, attributes, resists, crit %, attack power, spell damage/healing) written on save for external tools (armory/web sites); recalculated fresh at each login and never read back by the core.

Schema Summary

Field Type Key Null Default Extra
guid int(11) unsigned PRI NO 0
max_health int(10) unsigned NO 0
max_power1 int(10) unsigned NO 0
max_power2 int(10) unsigned NO 0
max_power3 int(10) unsigned NO 0
max_power4 int(10) unsigned NO 0
max_power5 int(10) unsigned NO 0
max_power6 int(10) unsigned NO 0
max_power7 int(10) unsigned NO 0
strength float NO 0
agility float NO 0
stamina float NO 0
intellect float NO 0
spirit float NO 0
armor int(10) NO 0
holy_res int(10) NO 0
fire_res int(10) NO 0
nature_res int(10) NO 0
frost_res int(10) NO 0
shadow_res int(10) NO 0
arcane_res int(10) NO 0
block_chance float NO 0
dodge_chance float NO 0
parry_chance float NO 0
crit_chance float NO 0
ranged_crit_chance float NO 0
spell_crit_chance float NO 0
attack_power int(10) unsigned NO 0
ranged_attack_power int(10) unsigned NO 0
spell_damage int(10) unsigned NO 0
spell_healing int(10) unsigned NO 0

Field Breakdown

  • guid - Primary Key. Character guid (from characters.guid).
  • max_health - Cached maximum health.
  • max_power1 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power2 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power3 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power4 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power5 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power6 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • max_power7 - Max power for power type N (1=mana, 2=rage, 3=focus, 4=energy, 5=happiness; power types 6 and 7 are unused in the 1.12 client).
  • strength - Cached base attributes.
  • agility - Cached base attributes.
  • stamina - Cached base attributes.
  • intellect - Cached base attributes.
  • spirit - Cached base attributes.
  • armor - Total armor value.
  • holy_res - Cached Holy resistance.
  • fire_res - Cached Fire resistance.
  • nature_res - Cached Nature resistance.
  • frost_res - Cached Frost resistance.
  • shadow_res - Cached Shadow resistance.
  • arcane_res - Cached Arcane resistance.
  • block_chance - Cached avoidance percentages.
  • dodge_chance - Cached avoidance percentages.
  • parry_chance - Cached avoidance percentages.
  • crit_chance - Cached crit percentages.
  • ranged_crit_chance - Cached crit percentages.
  • spell_crit_chance - Cached crit percentages.
  • attack_power - Cached attack power.
  • ranged_attack_power - Cached attack power.
  • spell_damage - Cached bonus spell damage/healing.
  • spell_healing - Cached bonus spell damage/healing.