Player levelstats
Материал из YTDB DataBase
(Новая страница: «{| align="right" | __TOC__ |} Back to world database list of tables. <big>'''The `player_levelstats` table'''</big> This table holds informati…»)
Следующая правка →
Версия 10:12, 3 февраля 2010
|
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 | Null | Key | Default | Extra |
| race | tinyint(3) unsigned | NO | PRI | ||
| class | tinyint(3) unsigned | NO | PRI | ||
| level | tinyint(3) unsigned | NO | PRI | ||
| str | tinyint(3) unsigned | NO | |||
| agi | tinyint(3) unsigned | NO | |||
| sta | tinyint(3) unsigned | NO | |||
| inte | tinyint(3) unsigned | NO | |||
| spi | tinyint(3) unsigned | NO |
Description of the fields
race
The character race. This field along with class defines what stats to be applied on the character.
| ID | Название |
| 1 | Человек |
| 2 | Орк |
| 3 | Дворф |
| 4 | Ночной эльф |
| 5 | Нежить |
| 6 | Таурен |
| 7 | Гном |
| 8 | Тролль |
| 9 | Гоблин 
|
| 10 | Кровавый эльф 
|
| 11 | Дреней
|
| 22 | Ворген
|
class
The character class. This field along with race defines what stats to be applied on the character.
| ID | Название |
| 1 | Воин |
| 2 | Паладин |
| 3 | Охотник |
| 4 | Разбойник |
| 5 | Жрец |
| 6 | Рыцарь смерти 
|
| 7 | Шаман |
| 8 | Маг |
| 9 | Чернокнижник |
| 11 | Друид |
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.
