====== character_stats 表 ======
----
[[数据库:characters数据库:首页|<-返回:Characters 数据库]]

This table holds information on all the stats regarding the character. Used for external applications such as websites. See worldserver.conf: PlayerSave.Stats.*

**表结构**
^Field^Type^Attributes^Key^Null^Default^extra^Comment^
|[[#guid|guid]]|INT|UNSIGNED|PRI|NO|0| |Global Unique Identifier, Low part|
|[[#maxhealth|maxhealth]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower1]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower2]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower3]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower4]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower5]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower6]]|INT|UNSIGNED| |NO|0| | |
|[[#maxpower|maxpower7]]|INT|UNSIGNED| |NO|0| | |
|[[#strength|strength]]|INT|UNSIGNED| |NO|0| | |
|[[#agility|agility]]|INT|UNSIGNED| |NO|0| | |
|[[#stamina|stamina]]|INT|UNSIGNED| |NO|0| | |
|[[#intellect|intellect]]|INT|UNSIGNED| |NO|0| | |
|[[#spirit|spirit]]|INT|UNSIGNED| |NO|0| | |
|[[#armor|armor]]|INT|UNSIGNED| |NO|0| | |
|[[#resHoly|resHoly]]|INT|UNSIGNED| |NO|0| | |
|[[#resFire|resFire]]|INT|UNSIGNED| |NO|0| | |
|[[#resNature|resNature]]|INT|UNSIGNED| |NO|0| | |
|[[#resFrost|resFrost]]|INT|UNSIGNED| |NO|0| | |
|[[#resShadow|resShadow]]|INT|UNSIGNED| |NO|0| | |
|[[#resArcane|resArcane]]|INT|UNSIGNED| |NO|0| | |
|[[#blockPct|blockPct]]|FLOAT|SIGNED| |NO|0| | |
|[[#dodgePct|dodgePct]]|FLOAT|SIGNED| |NO|0| | |
|[[#parryPct|parryPct]]|FLOAT|SIGNED| |NO|0| | |
|[[#critPct|critPct]]|FLOAT|SIGNED| |NO|0| | |
|[[#rangedCritPct|rangedCritPct]]|FLOAT|SIGNED| |NO|0| | |
|[[#spellCritPct|spellCritPct]]|FLOAT|SIGNED| |NO|0| | |
|[[#attackPower|attackPower]]|INT|UNSIGNED| |NO|0| | |
|[[#rangedAttackPower|rangedAttackPower]]|INT|UNSIGNED| |NO|0| | |
|[[#spellPower|spellPower]]|INT|UNSIGNED| |NO|0| | |
|[[#resilience|resilience]]|INT|UNSIGNED| |NO|0| | |



===== 字段说明 =====
----
==== guid ====

The character guid. See characters.guid.

==== maxhealth ====

Maximum amount of health that the character has.

==== maxpower ====

^Value^Description^
|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.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== dodgePct ====

Character's current dodge chance.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== parryPct ====

Character's current parry chance.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== critPct ====

Character's current crit chance.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== rangedCritPct ====

Character's current ranged crit chance.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== spellCritPct ====

Character's current spell crit chance.

Value must be >=0. If the value does not meet the condition the SQL will fail on character_stats_chk_1.

==== attackPower ====

Character's current attackpower.

==== rangedAttackPower ====

Character's current ranged attackpower.

==== spellPower ====

Character's current spellpower.

==== resilience ====

Character's current resilience value.