Achievement criteria requirement

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

(Перенаправлено с Achievement criteria data)
Перейти к: навигация, поиск

Содержание

К описанию таблиц базы данных 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
Личные инструменты