player_levelstats
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 | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| race | tinyint | unsigned | PRI | NO | |||
| class | tinyint | unsigned | PRI | NO | |||
| level | tinyint | unsigned | PRI | NO | |||
| str | smallint | unsigned | NO | strength | |||
| agi | smallint | unsigned | NO | agility | |||
| sta | smallint | unsigned | NO | stamina | |||
| inte | smallint | unsigned | NO | intellect | |||
| spi | smallint | unsigned | NO | spirit |
Description of fields
race
The characters ChrRace ID. This field along with class defines what stats to be applied on the character.
| ID | Name | ID | Name | |
|---|---|---|---|---|
| 1 | Human | 2 | Orc | |
| 4 | Dwarf | 16 | Undead | |
| 8 | Night Elf | 32 | Tauren | |
| 64 | Gnome | 128 | Troll | |
| 1024 | Draenei | 512 | Blood Elf |
class
The characters ChrClass ID. This field along with race defines what stats to be applied on the character.
| ID | Name | ID | Name | |
|---|---|---|---|---|
| 1 | Warrior | 6 | Death Knight | |
| 2 | Paladin | 7 | Shaman | |
| 3 | Hunter | 8 | Mage | |
| 4 | Rogue | 9 | Warlock | |
| 5 | Priest | 11 | Druid |
level
The level at which the stats should be applied.
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.