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/creature_classlevelstats.md | 194 +++++++++++++++++++++++++++++++++++---- 1 file changed, 177 insertions(+), 17 deletions(-) (limited to 'docs/creature_classlevelstats.md') diff --git a/docs/creature_classlevelstats.md b/docs/creature_classlevelstats.md index d9ec514..8e76700 100644 --- a/docs/creature_classlevelstats.md +++ b/docs/creature_classlevelstats.md @@ -1,17 +1,177 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [creature_classlevelstats](creature_classlevelstats) - -Column | Type | Description ---- | --- | --- -Level | tinyint(3) unsigned | -Class | tinyint(3) unsigned | -Basehp0 | smallint(5) unsigned | -Basehp1 | smallint(5) unsigned | -Basehp2 | smallint(5) unsigned | -Basemana | smallint(5) unsigned | -Basearmor | smallint(5) unsigned | -Attackpower | smallint(5) unsigned | -Rangedattackpower | smallint(5) unsigned | -Damage_base | float | -Damage_exp1 | float | -Damage_exp2 | float | -Comment | text | +# creature\_classlevelstats + +`` + +**Table Structure** + +This table contains the base values for creature health, mana, armor, attack power, ranged attack power, damage, and experience. + + +++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Null

Default

level

tinyint(3)

unsigned

NO

NULL

class

tinyint(3)

unsigned

NO

NULL

basehp0

smallint(5)

unsigned

NO

1

basehp1

smallint(5)

unsigned

NO

1

basehp2

smallint(5)

unsigned

NO

1

basemana

smallint(5)

unsigned

NO

0

basearmor

smallint(5)

unsigned

NO

1

attackpowersmallint(5)unsignedNO0
rangedattackpowersmallint(5)unsignedNO0
damage_basefloat
+		NO0
damage_exp1float
+		NO0
damage_exp2float
+		NO0
commenttext
+		YESNULL
+ +**Field Descriptions** + +### level + +Level of the creature. + +### class + +Class of the creature. This is a reference to the [unit\_class](http://collab.kpsn.org/display/tc/creature_template#creature_template-unit_class) field in the [creature\_template](http://collab.kpsn.org/display/tc/creature_template) table. + +### basehp0 + +Base health for the creature if creature\_template.exp value is set to 0. This value is multiplied by [creature\_template.Health\_mod](http://collab.kpsn.org/display/tc/creature_template#creature_template-Health_mod)  to determine the creature's final health. + +### basehp1 + +Base health for the creature if creature\_template.exp value is set to 1. This value is multiplied by [creature\_template.Health\_mod](http://collab.kpsn.org/display/tc/creature_template#creature_template-Health_mod)  to determine the creature's final health. + +### basehp2 + +Base health for the creature if creature\_template.exp value is set to 2. This value is multiplied by [creature\_template.Health\_mod](http://collab.kpsn.org/display/tc/creature_template#creature_template-Health_mod)  to determine the creature's final health. + +### basemana + +Base mana for the creature. This value is multiplied by  [creature\_template.Mana\_mod](http://collab.kpsn.org/display/tc/creature_template#creature_template-Mana_mod) to determine the creature's final mana. + +### basearmor + +Base armor for the creature. This value is multiplied by creature\_template.Armor\_mod to determine the creature's final armor. + +### attackpower + +Base attack power for the creature. This value is multiplied by [creature\_template.attackpower](http://collab.kpsn.org/display/tc/creature_template#creature_template-attackpower) to determine the creature's final attack power. + +### rangedattackpower + +Base ranged attack power for the creature. It is currently unknown what this value is multiplied by to determine the creature's final attack power. Maybe it works the same as attack power and multiplies by [creature\_template.attackpower](http://collab.kpsn.org/display/tc/creature_template#creature_template-attackpower)? + +### damage\_base + +This field is used for unknown. (Might be the base dmg if exp1 and exp2 is set to 0). + +### damage\_exp1 + +Min damage. This will increase/decrease by creature\_template.damagemodifier. + +### damage\_exp2 + +Max damage This will increase/decrease by creature\_template.damagemodifier. + +### comment + +A comment describing the purpose of the record (entry). + + -- cgit