diff options
| author | Benjamin Jackson <38561765+heyitsbench@users.noreply.github.com> | 2023-01-02 16:35:55 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-01-02 18:35:55 -0300 |
| commit | c689a45de588867062ecd30f1b9d989f77f32981 (patch) | |
| tree | 01ffb6c367d60b95f10829ff314aa108e59b20f4 /docs | |
| parent | 4365099b356a48b47392cdd0d7933ee3e03af3d1 (diff) | |
| download | wiki-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.md | 3 | ||||
| -rw-r--r-- | docs/player_class_stats.md | 80 | ||||
| -rw-r--r-- | docs/player_levelstats.md | 79 | ||||
| -rw-r--r-- | docs/player_race_stats.md | 59 |
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. |
