creature_classlevelstats
This table contains the base values for creature health, mana, armor, attack power, ranged attack power, damage, and experience.
Field | Type | Attributes | Null | Default |
tinyint(3) | unsigned | NO | NULL | |
tinyint(3) | unsigned | NO | NULL | |
smallint(5) | unsigned | NO | 1 | |
smallint(5) | unsigned | NO | 1 | |
smallint(5) | unsigned | NO | 1 | |
smallint(5) | unsigned | NO | 0 | |
smallint(5) | unsigned | NO | 1 | |
attackpower | smallint(5) | unsigned | NO | 0 |
rangedattackpower | smallint(5) | unsigned | NO | 0 |
damage_base | float | NO | 0 | |
damage_exp1 | float | NO | 0 | |
damage_exp2 | float | NO | 0 | |
comment | text | YES | NULL |
level
Level of the creature.
class
Class of the creature. This is a reference to the unit_class field in the 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 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 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 to determine the creature's final health.
basemana
Base mana for the creature. This value is multiplied by 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 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?
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).