Player levelstats tc2

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	Attributes	Key	Null	Default	Extra	Comment
race	tinyint(3)	unsigned	PRI	NO	NULL
class	tinyint(3)	unsigned	PRI	NO	NULL
level	tinyint(3)	unsigned	PRI	NO	NULL
str	tinyint(3)	unsigned		NO	NULL
agi	tinyint(3)	unsigned		NO	NULL
sta	tinyint(3)	unsigned		NO	NULL
inte	tinyint(3)	unsigned		NO	NULL
spi	tinyint(3)	unsigned		NO	NULL

Description of the fields

race

The character race. This field along with class defines what stats to be applied on the character.

Value | ID }}	Name
1 | 1 }}	Human
2 | 2 }}	Orc
4 | 3 }}	Dwarf
8 | 4 }}	Night Elf
16 | 5 }}	Undead
32 | 6 }}	Tauren
64 | 7 }}	Gnome
128 | 8 }}	Troll
512 | 10 }}	Blood Elf
1024 | 11 }}	Draenei

class

The character class. This field along with race defines what stats to be applied on the character.

Value | ID }}	Name
1 | 1 }}	Warrior
2 | 2 }}	Paladin
4 | 3 }}	Hunter
8 | 4 }}	Rogue
16 | 5 }}	Priest
32 | 6 }}	Death Knight
64 | 7 }}	Shaman
128 | 8 }}	Mage
256 | 9 }}	Warlock
1024 | 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.