Player levelstats
From UDB
|
Back to world database list of tables.
The `player_levelstats` table
This table holds information on what stats are gained by characters when they level up. Each race-class combination has different level stats. All of the values in this table signify only the base stats of the race-class combination at a specific level.
Structure
| Field | Type | Null | Key | Default | Extra |
| race | tinyint(3) unsigned | NO | PRI | ||
| class | tinyint(3) unsigned | NO | PRI | ||
| level | tinyint(3) unsigned | NO | PRI | ||
| basehp | smallint(5) unsigned | NO | |||
| basemana | smallint(5) unsigned | NO | |||
| str | tinyint(3) unsigned | NO | |||
| agi | tinyint(3) unsigned | NO | |||
| sta | tinyint(3) unsigned | NO | |||
| inte | tinyint(3) unsigned | NO | |||
| spi | tinyint(3) unsigned | NO |
Description of the fields
race
The character race. This field along with class defines what stats to be applied on the character.
| ID | Name |
| 1 | Human |
| 2 | Orc |
| 3 | Dwarf |
| 4 | Night Elf |
| 5 | Undead |
| 6 | Tauren |
| 7 | Gnome |
| 8 | Troll |
| 10 | Blood Elf |
| 11 | Draenei |
class
The character class. This field along with race defines what stats to be applied on the character.
| ID | Name |
| 1 | Warrior |
| 2 | Paladin |
| 3 | Hunter |
| 4 | Rogue |
| 5 | Priest |
| 7 | Shaman |
| 8 | Mage |
| 9 | Warlock |
| 11 | Druid |
level
The level at which the stats should be applied.
basehp
The base health of the character (before stamina bonuses).
basemana
The base mana of the character (before intellect bonuses).
str
The base strength of the character.
agi
The base agility of the character.
sta
The base stamina of the character.
inte
The base intellect of the character.
spi
The base spirit of the character.
