player_race_stats
The `player_race_stats` table
This table holds information on modifiers for stat values applied to characters. All of the values in this table signify only the stat value modifiers based on the race of a character.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| Race | TINYINT | UNSIGNED | PRI | NO | |||
| Strength | INT | UNSIGNED | NO | 0 | |||
| Agility | INT | UNSIGNED | NO | 0 | |||
| Stamina | INT | UNSIGNED | NO | 0 | |||
| Intellect | INT | UNSIGNED | NO | 0 | |||
| Spirit | INT | UNSIGNED | NO | 0 |
Description of the fields
Race
The character race. This field defines what values to apply to the stats of a character. This value is taken from ''%%ChrRaces.dbc%%''.
Strength
The strength modifier to apply to a character's base stat.
Agility
The agility modifier to apply to a character's base stat.
Stamina
The stamina modifier to apply to a character's base stat.
Intellect
The intellect modifier to apply to a character's base stat.
Spirit
The spirit modifier to apply to a character's base stat.
Relation to `player_class_stats`
This table alone does not define the stats of a character. The values from this table are combined with the values found in the player\_class\_stats table to apply the final stats to a character at any level.
The way the final stat can be calculated is as follows: Take the base stat from player\_class\_stats and add the modifier for that stat from this table.
For example, a druid at level forty has a base strength stat of forty-six. Combining that with a night elf's strength modifier of negative four, you get a final value of forty-two.