blob: c7d07741cb9d2896275ffcdb2d2828e6faf9f0c9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# player\_race\_stats
[<-Back-to:World](database-world.md)
**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][1] | TINYINT | UNSIGNED | PRI | NO | | | |
| [Strength][2] | INT | UNSIGNED | | NO | 0 | | |
| [Agility][3] | INT | UNSIGNED | | NO | 0 | | |
| [Stamina][4] | INT | UNSIGNED | | NO | 0 | | |
| [Intellect][5] | INT | UNSIGNED | | NO | 0 | | |
| [Spirit][6] | INT | UNSIGNED | | NO | 0 | | |
[1]: #Race
[2]: #Strength
[3]: #Agility
[4]: #Stamina
[5]: #Intellect
[6]: #Spirit
**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`](chrraces).
### 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\`](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.
|
