summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorBenjamin Jackson <38561765+heyitsbench@users.noreply.github.com>2023-01-02 16:35:55 -0500
committerGitHub <noreply@github.com>2023-01-02 18:35:55 -0300
commitc689a45de588867062ecd30f1b9d989f77f32981 (patch)
tree01ffb6c367d60b95f10829ff314aa108e59b20f4 /docs
parent4365099b356a48b47392cdd0d7933ee3e03af3d1 (diff)
downloadwiki-c689a45de588867062ecd30f1b9d989f77f32981.tar.gz
wiki-c689a45de588867062ecd30f1b9d989f77f32981.tar.bz2
wiki-c689a45de588867062ecd30f1b9d989f77f32981.zip
Split `player_levelstats` table document to coincide with pending AC PR. (#852)
* Change `player_levelstats` to `player_class_stats` and update info. * Update headers with new file name. * Create player_race_stats.md * Update index. * Add calculation example. * Update table description.
Diffstat (limited to 'docs')
-rw-r--r--docs/database-world.md3
-rw-r--r--docs/player_class_stats.md80
-rw-r--r--docs/player_levelstats.md79
-rw-r--r--docs/player_race_stats.md59
4 files changed, 141 insertions, 80 deletions
diff --git a/docs/database-world.md b/docs/database-world.md
index a7e6b41..1e9b4cd 100644
--- a/docs/database-world.md
+++ b/docs/database-world.md
@@ -128,6 +128,7 @@
- [pet_levelstats](pet_levelstats.md)
- [pet_name_generation](pet_name_generation.md)
- [pickpocketing_loot_template](loot_template.md)
+- [player_class_stats](player_class_stats.md)
- [player_classlevelstats](player_classlevelstats.md)
- [player_factionchange_achievement](player_factionchange_achievement.md)
- [player_factionchange_items](player_factionchange_items.md)
@@ -135,7 +136,7 @@
- [player_factionchange_reputations](player_factionchange_reputations.md)
- [player_factionchange_spells](player_factionchange_spells.md)
- [player_factionchange_titles](player_factionchange_titles.md)
-- [player_levelstats](player_levelstats.md)
+- [player_race_stats](player_race_stats.md)
- [player_xp_for_level](player_xp_for_level.md)
- [playercreateinfo](playercreateinfo.md)
- [playercreateinfo_action](playercreateinfo_action.md)
diff --git a/docs/player_class_stats.md b/docs/player_class_stats.md
new file mode 100644
index 0000000..f42e1a4
--- /dev/null
+++ b/docs/player_class_stats.md
@@ -0,0 +1,80 @@
+# player\_class\_stats
+
+[<-Back-to:World](database-world.md)
+
+**The \`player\_class\_stats\` table**
+
+This table holds information on what values are applied to stats for characters as they level up. All of the values in this table signify only the base stats of a class at a specific level.
+
+**Structure**
+
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
+|----------------|---------|------------|-----|------|---------|-------|---------|
+| [Class][1] | TINYINT | UNSIGNED | PRI | NO | | | |
+| [Level][2] | TINYINT | UNSIGNED | PRI | NO | | | |
+| [Strength][3] | INT | UNSIGNED | | NO | 0 | | |
+| [Agility][4] | INT | UNSIGNED | | NO | 0 | | |
+| [Stamina][5] | INT | UNSIGNED | | NO | 0 | | |
+| [Intellect][6] | INT | UNSIGNED | | NO | 0 | | |
+| [Spirit][7] | INT | UNSIGNED | | NO | 0 | | |
+
+[1]: #Class
+[2]: #Level
+[3]: #Strength
+[4]: #Agility
+[5]: #Stamina
+[6]: #Intellect
+[7]: #Spirit
+
+**Description of the fields**
+
+### Class
+
+The character class. This field defines what values to apply to the stats of a character. This value is taken from [`ChrClasses.dbc`](chrclasses).
+
+### Level
+
+The level at which the stats should be applied.
+
+### Strength
+
+The base strength to be applied to a character.
+
+### Agility
+
+The base agility to be applied to a character.
+
+### Stamina
+
+The base stamina to be applied to a character.
+
+### Intellect
+
+The base intellect to be applied to a character.
+
+### Spirit
+
+The base spirit to be applied to a character.
+
+### Examples
+
+| Class | Level | Strength | Agility | Stamina | Intellect | Spirit |
+|-------|-------|----------|---------|---------|-----------|--------|
+| 1 | 1 | 23 | 20 | 22 | 20 | 20 |
+| 2 | 1 | 22 | 20 | 22 | 20 | 21 |
+| 3 | 1 | 20 | 23 | 21 | 20 | 21 |
+| 4 | 1 | 21 | 23 | 21 | 20 | 20 |
+| 5 | 1 | 20 | 20 | 20 | 22 | 23 |
+| 6 | 55 | 108 | 73 | 99 | 29 | 42 |
+| 7 | 1 | 21 | 20 | 21 | 21 | 22 |
+| 8 | 1 | 20 | 20 | 20 | 23 | 22 |
+| 9 | 1 | 20 | 20 | 21 | 22 | 22 |
+| 11 | 1 | 21 | 20 | 20 | 22 | 22 |
+
+**Relation to [\`player\_race\_stats\`](player_race_stats)**
+
+This table alone does not define the stats of a character at any level. The values from this table are combined with the values found in the `player\_race\_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 this table and add the modifier for that stat from `player\_race\_stats`.
+
+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.
diff --git a/docs/player_levelstats.md b/docs/player_levelstats.md
deleted file mode 100644
index d36bdb6..0000000
--- a/docs/player_levelstats.md
+++ /dev/null
@@ -1,79 +0,0 @@
-# player\_levelstats
-
-[<-Back-to:World](database-world.md)
-
-**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][1] | TINYINT | UNSIGNED | PRI | NO | NULL | | |
-| [class][2] | TINYINT | UNSIGNED | PRI | NO | NULL | | |
-| [level][3] | TINYINT | UNSIGNED | PRI | NO | NULL | | |
-| [str][4] | TINYINT | UNSIGNED | | NO | NULL | | |
-| [agi][5] | TINYINT | UNSIGNED | | NO | NULL | | |
-| [sta][6] | TINYINT | UNSIGNED | | NO | NULL | | |
-| [inte][7] | TINYINT | UNSIGNED | | NO | NULL | | |
-| [spi][8] | TINYINT | UNSIGNED | | NO | NULL | | |
-
-[1]: #race
-[2]: #class
-[3]: #level
-[4]: #str
-[5]: #agi
-[6]: #sta
-[7]: #inte
-[8]: #spi
-
-**Description of the fields**
-
-### race
-
-The character race. This field along with [class](#player_levelstats-class) defines what stats to be applied on the character.
-`ChrRaces.dbc`
-
-### class
-
-The character class. This field along with [race](#player_levelstats-race) defines what stats to be applied on the character.
-`ChrClasses.dbc`
-
-### 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.
-
-### Examples
-
-| race | class | level | str | agi | sta | inte | spi |
-|------|-------|-------|-----|-----|-----|------|-----|
-| 1 | 1 | 1 | 23 | 20 | 22 | 20 | 20 |
-| 2 | 1 | 1 | 26 | 17 | 24 | 17 | 23 |
-| 3 | 1 | 1 | 25 | 16 | 25 | 19 | 19 |
-| 4 | 1 | 1 | 20 | 25 | 21 | 20 | 20 |
-| 5 | 1 | 1 | 22 | 18 | 23 | 18 | 25 |
-| 6 | 1 | 1 | 28 | 15 | 24 | 15 | 22 |
-| 7 | 1 | 1 | 18 | 23 | 21 | 24 | 20 |
-| 8 | 1 | 1 | 24 | 22 | 23 | 16 | 21 |
-| 11 | 1 | 1 | 24 | 17 | 21 | 21 | 22 |
diff --git a/docs/player_race_stats.md b/docs/player_race_stats.md
new file mode 100644
index 0000000..c7d0774
--- /dev/null
+++ b/docs/player_race_stats.md
@@ -0,0 +1,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.