Achievement criteria requirement

Материал из YTDB DataBase

(Различия между версиями)
Перейти к: навигация, поиск
(→criteria_id)
(→OtherFields)
 
(23 промежуточные версии не показаны)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
 +
[[Category: Mangos world database tables]]
К описанию таблиц [[mangosdb_struct|базы данных mangos]].
К описанию таблиц [[mangosdb_struct|базы данных mangos]].
-
<big>'''Таблица `achievement_criteria_data`'''</big>
+
<big>'''Таблица `achievement_criteria_requirement`'''</big>
 +
 
 +
Таблица содержит данные, которые необходимы для получения достижения. Используется для создания дополнительных условий что бы получить достижения.
-
Таблица содержит данные, которые необходимы для получения достижения
 
<big>'''Структура'''</big>
<big>'''Структура'''</big>
{| border="1"
{| border="1"
-
|Field
+
|'''Field'''
-
|Type
+
|'''Type'''
-
|Attributes
+
|'''Attributes'''
-
|Can be null
+
|'''Null'''
-
|Default
+
|'''Default'''
-
|Comments
+
|'''Key'''
 +
|'''Comments'''
|-
|-
|[[#criteria_id|criteria_id]]
|[[#criteria_id|criteria_id]]
|mediumint(8)
|mediumint(8)
-
|signed
+
|
|NO
|NO
-
|None
+
|
 +
|PRI
|
|
|-
|-
Строка 30: Строка 34:
|NO
|NO
|0
|0
 +
|PRI
|
|
|-
|-
Строка 37: Строка 42:
|NO
|NO
|0
|0
 +
|
|
|
|-
|-
Строка 44: Строка 50:
|NO
|NO
|0
|0
 +
|
|
|
|}
|}
Строка 50: Строка 57:
<big>'''Описание полей'''</big>
<big>'''Описание полей'''</big>
====criteria_id====
====criteria_id====
-
Поле 0 (ID) из [[Achievement_Criteria.dbc|Achievement_Criteria.dbc]]
+
Поле 0 (идентификатор) из [[Achievement_Criteria.dbc]]
Эта DBC содержит achievement_id во втором поле и должна быть извлечена чтобы показать связи.
Эта DBC содержит achievement_id во втором поле и должна быть извлечена чтобы показать связи.
Строка 94: Строка 101:
|-
|-
| 17 || TYPE_BG_LOSS_TEAM_SCORE
| 17 || TYPE_BG_LOSS_TEAM_SCORE
 +
|-
 +
| 18 || TYPE_INSTANCE_SCRIPT
 +
|-
 +
| 19 || TYPE_S_EQUIPED_ITEM_LVL
 +
|-
 +
| 20 || TYPE_NTH_BIRTHDAY
 +
|-
 +
| 21 || TYPE_KNOWN_TITLE
|}
|}
-
====value1 и value2====
+
====OtherFields====
-
Зависит от того, что указано в поле Type, может принимать следующие значения:
+
Depending on what Type was set, the meaning and use for the following fields varies.
-
TYPE_T - цель, TYPE_S - игрок.
+
TYPE_T are for targets and TYPE_S are for sources
* '''TYPE_T_CREATURE = 1'''
* '''TYPE_T_CREATURE = 1'''
-
** value1: Цель - creature_template.[[creature_template#entry|entry]]
+
** value1: Target creature_template.[[creature_template#entry|entry]]
* '''TYPE_T_PLAYER_CLASS_RACE = 2 '''
* '''TYPE_T_PLAYER_CLASS_RACE = 2 '''
-
** value1: Класс игрока
+
** value1: Target Player class
-
** value2: Раса игрока
+
** value2: Target Player race
* '''TYPE_T_PLAYER_LESS_HEALTH = 3 '''
* '''TYPE_T_PLAYER_LESS_HEALTH = 3 '''
-
** value1: проценты HP цели
+
** value1: Target Health percentage
Строка 119: Строка 134:
* '''TYPE_S_AURA = 5 '''
* '''TYPE_S_AURA = 5 '''
** value1: Spell ID
** value1: Spell ID
-
** value2: Номер эффекта
+
** value2: Effect index
* '''TYPE_S_AREA = 6 '''
* '''TYPE_S_AREA = 6 '''
-
** value1: Area ID из [[AreaTable.dbc]]
+
** value1: Area ID from [[AreaTable.dbc]]
* '''TYPE_T_AURA = 7 '''
* '''TYPE_T_AURA = 7 '''
** value1: Spell ID
** value1: Spell ID
-
** value2: Номер эффекта
+
** value2: Effect index
Строка 136: Строка 151:
* '''TYPE_T_LEVEL = 9'''
* '''TYPE_T_LEVEL = 9'''
-
** value1: Минимальный уровень цели
+
** value1: Target Min Level
* '''TYPE_T_GENDER = 10'''
* '''TYPE_T_GENDER = 10'''
-
** value1: Пол: 0=М, 1=Ж
+
** value1: Gender: 0=Male, 1=Female
Строка 148: Строка 163:
* '''TYPE_MAP_DIFFICULTY = 12'''
* '''TYPE_MAP_DIFFICULTY = 12'''
-
** value1: Сложность подземелья: DIFFICULTY_NORMAL = 0, DIFFICULTY_HEROIC = 1
+
** value1: Map difficulty:  
 +
{| border="1"
 +
|Description
 +
|Flag
 +
|-
 +
|DUNGEON_DIFFICULTY_NORMAL || 0
 +
|-
 +
|DUNGEON_DIFFICULTY_HEROIC || 1
 +
|-
 +
|RAID_DIFFICULTY_10MAN_NORMAL || 0
 +
|-
 +
|RAID_DIFFICULTY_25MAN_NORMAL || 1
 +
|-
 +
|RAID_DIFFICULTY_10MAN_HEROIC || 2
 +
|-
 +
|RAID_DIFFICULTY_25MAN_HEROIC || 3
 +
|}
* '''TYPE_MAP_PLAYER_COUNT = 13'''
* '''TYPE_MAP_PLAYER_COUNT = 13'''
-
** value1: Количество. Для критерия "with less than %u people in the zone"
+
** value1: Count. For criteria "with less than %u people in the zone"
* '''TYPE_T_TEAM = 14'''
* '''TYPE_T_TEAM = 14'''
-
** value1: Фракция: HORDE = 67, ALLIANCE = 469
+
** value1: Team: HORDE = 67, ALLIANCE = 469
Строка 164: Строка 195:
* '''TYPE_HOLIDAY = 16'''
* '''TYPE_HOLIDAY = 16'''
-
** value1: ID праздника из Holiday.dbc и [[Game_event#holiday|game_event]], который должен быть активен
+
** value1: Holiday ID which must be active from Holiday.dbc and [[Game_event#holiday|game_event]]
* '''TYPE_BG_LOSS_TEAM_SCORE = 17 '''
* '''TYPE_BG_LOSS_TEAM_SCORE = 17 '''
-
** value1: Мин количество очков
+
** value1: min_score
-
** value2: Макс количество очков
+
** value2: max_score
 +
 
 +
 
 +
* '''TYPE_INSTANCE_SCRIPT = 18 '''
 +
Make instance script call for check current criteria requirements fit
 +
 
 +
 
 +
* '''TYPE_S_EQUIPED_ITEM_LVL = 19 '''
 +
** value1: item_level
 +
** value2: item_quality
 +
For equipped item in slot `misc1` to item level and quality
 +
 
 +
 
 +
* '''TYPE__NTH_BIRTHDAY = 20 '''
 +
** value1: nth_birthday
 +
 
 +
 
 +
* '''TYPE__KNOWN_TITLE = 21 '''
 +
** value1: title_id

Текущая версия на 20:22, 27 марта 2011

Содержание

К описанию таблиц базы данных mangos.


Таблица `achievement_criteria_requirement`

Таблица содержит данные, которые необходимы для получения достижения. Используется для создания дополнительных условий что бы получить достижения.


Структура

Field Type Attributes Null Default Key Comments
criteria_id mediumint(8) NO PRI
type tintint(3) unsigned NO 0 PRI
value1 mediumint(8) unsigned NO 0
value2 mediumint(8) unsigned NO 0


Описание полей

criteria_id

Поле 0 (идентификатор) из Achievement_Criteria.dbc Эта DBC содержит achievement_id во втором поле и должна быть извлечена чтобы показать связи.

type

Описывает как использовать value1 и value2.

Type Name
0 TYPE_NONE
1 TYPE_T_CREATURE
2 TYPE_T_PLAYER_CLASS_RACE
3 TYPE_T_PLAYER_LESS_HEALTH
4 TYPE_T_PLAYER_DEAD
5 TYPE_S_AURA
6 TYPE_S_AREA
7 TYPE_T_AURA
8 TYPE_VALUE
9 TYPE_T_LEVEL
10 TYPE_T_GENDER
11 TYPE_DISABLED
12 TYPE_MAP_DIFFICULTY
13 TYPE_MAP_PLAYER_COUNT
14 TYPE_T_TEAM
15 TYPE_S_DRUNK
16 TYPE_HOLIDAY
17 TYPE_BG_LOSS_TEAM_SCORE
18 TYPE_INSTANCE_SCRIPT
19 TYPE_S_EQUIPED_ITEM_LVL
20 TYPE_NTH_BIRTHDAY
21 TYPE_KNOWN_TITLE

OtherFields

Depending on what Type was set, the meaning and use for the following fields varies. TYPE_T are for targets and TYPE_S are for sources

  • TYPE_T_CREATURE = 1
    • value1: Target creature_template.entry


  • TYPE_T_PLAYER_CLASS_RACE = 2
    • value1: Target Player class
    • value2: Target Player race


  • TYPE_T_PLAYER_LESS_HEALTH = 3
    • value1: Target Health percentage


  • TYPE_T_PLAYER_DEAD = 4
    • value1: Team value the source player and target dead player must both meet


  • TYPE_S_AURA = 5
    • value1: Spell ID
    • value2: Effect index



  • TYPE_T_AURA = 7
    • value1: Spell ID
    • value2: Effect index


  • TYPE_VALUE = 8
    • value1: Min Value. Value provided with achievement update must be not less that limit


  • TYPE_T_LEVEL = 9
    • value1: Target Min Level


  • TYPE_T_GENDER = 10
    • value1: Gender: 0=Male, 1=Female


  • TYPE_DISABLED = 11

Used to prevent achievement criteria to complete if not all requirements are implemented and listed in this table


  • TYPE_MAP_DIFFICULTY = 12
    • value1: Map difficulty:
Description Flag
DUNGEON_DIFFICULTY_NORMAL 0
DUNGEON_DIFFICULTY_HEROIC 1
RAID_DIFFICULTY_10MAN_NORMAL 0
RAID_DIFFICULTY_25MAN_NORMAL 1
RAID_DIFFICULTY_10MAN_HEROIC 2
RAID_DIFFICULTY_25MAN_HEROIC 3


  • TYPE_MAP_PLAYER_COUNT = 13
    • value1: Count. For criteria "with less than %u people in the zone"


  • TYPE_T_TEAM = 14
    • value1: Team: HORDE = 67, ALLIANCE = 469


  • TYPE_S_DRUNK = 15
    • value1: Druken State. DRUNKEN_SOBER = 0, DRUNKEN_TIPSY = 1, DRUNKEN_DRUNK = 2, DRUNKEN_SMASHED = 3


  • TYPE_HOLIDAY = 16
    • value1: Holiday ID which must be active from Holiday.dbc and game_event


  • TYPE_BG_LOSS_TEAM_SCORE = 17
    • value1: min_score
    • value2: max_score


  • TYPE_INSTANCE_SCRIPT = 18

Make instance script call for check current criteria requirements fit


  • TYPE_S_EQUIPED_ITEM_LVL = 19
    • value1: item_level
    • value2: item_quality

For equipped item in slot `misc1` to item level and quality


  • TYPE__NTH_BIRTHDAY = 20
    • value1: nth_birthday


  • TYPE__KNOWN_TITLE = 21
    • value1: title_id
Источник — «http://wiki.ytdb.ru:89/index.php/Achievement_criteria_requirement»
Личные инструменты