From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/character_stats.md | 490 ++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 455 insertions(+), 35 deletions(-) (limited to 'docs/character_stats.md') diff --git a/docs/character_stats.md b/docs/character_stats.md index 2440b42..4585b1f 100644 --- a/docs/character_stats.md +++ b/docs/character_stats.md @@ -1,35 +1,455 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_stats](character_stats) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Maxhealth | int(10) unsigned | -Maxpower1 | int(10) unsigned | -Maxpower2 | int(10) unsigned | -Maxpower3 | int(10) unsigned | -Maxpower4 | int(10) unsigned | -Maxpower5 | int(10) unsigned | -Maxpower6 | int(10) unsigned | -Maxpower7 | int(10) unsigned | -Strength | int(10) unsigned | -Agility | int(10) unsigned | -Stamina | int(10) unsigned | -Intellect | int(10) unsigned | -Spirit | int(10) unsigned | -Armor | int(10) unsigned | -ResHoly | int(10) unsigned | -ResFire | int(10) unsigned | -ResNature | int(10) unsigned | -ResFrost | int(10) unsigned | -ResShadow | int(10) unsigned | -ResArcane | int(10) unsigned | -BlockPct | float unsigned | -DodgePct | float unsigned | -ParryPct | float unsigned | -CritPct | float unsigned | -RangedCritPct | float unsigned | -SpellCritPct | float unsigned | -AttackPower | int(10) unsigned | -RangedAttackPower | int(10) unsigned | -SpellPower | int(10) unsigned | -Resilience | int(10) unsigned | +# 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 -- cgit