用户工具

站点工具


数据库:characters数据库:character_stats

这是本文档旧的修订版!


character_stats 表


<-返回:Characters 数据库

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

表结构

FieldTypeAttributesKeyNullDefaultextraComment
guidINTUNSIGNEDPRINO0 Global Unique Identifier, Low part
maxhealthINTUNSIGNED NO0
maxpower1INTUNSIGNED NO0
maxpower2INTUNSIGNED NO0
maxpower3INTUNSIGNED NO0
maxpower4INTUNSIGNED NO0
maxpower5INTUNSIGNED NO0
maxpower6INTUNSIGNED NO0
maxpower7INTUNSIGNED NO0
strengthINTUNSIGNED NO0
agilityINTUNSIGNED NO0
staminaINTUNSIGNED NO0
intellectINTUNSIGNED NO0
spiritINTUNSIGNED NO0
armorINTUNSIGNED NO0
resHolyINTUNSIGNED NO0
resFireINTUNSIGNED NO0
resNatureINTUNSIGNED NO0
resFrostINTUNSIGNED NO0
resShadowINTUNSIGNED NO0
resArcaneINTUNSIGNED NO0
blockPctFLOATSIGNED NO0
dodgePctFLOATSIGNED NO0
parryPctFLOATSIGNED NO0
critPctFLOATSIGNED NO0
rangedCritPctFLOATSIGNED NO0
spellCritPctFLOATSIGNED NO0
attackPowerINTUNSIGNED NO0
rangedAttackPowerINTUNSIGNED NO0
spellPowerINTUNSIGNED NO0
resilienceINTUNSIGNED NO0

字段说明


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.

数据库/characters数据库/character_stats.1695525903.txt.gz · 最后更改: 2023/09/24 11:25 由 admin

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki