Achievement_criteria_requirement - cmangos/issues GitHub Wiki

Back to world database list of tables.

This table contains what need to be done to complete an achievement criteria.

Field	Type	Attributes	Can be null	Default	Comments
criteria_id	mediumint(8)	signed	NO	None
type	tintint(3)	unsigned	NO	0
value1	mediumint(8)	unsigned	NO	0
value2	mediumint(8)	unsigned	NO	0

Column 0 (ID) of achievement_criteria.dbc This DBC contains the achievement_id on 2nd column and will be later extracted to show relations.

Describes how to use value1 and 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_REQUIRE_NTH_BIRTHDAY
21	TYPE_REQUIRE_KNOWN_TITLE
22	TYPE_PVP_SCRIPT

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_S_AREA = 6
  • value1: Area ID from AreaTable.dbc

• 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_REQUIRE_NTH_BIRTHDAY = 20
  • value1: nth-birthday

• TYPE_CRITERIA_REQUIRE_KNOWN_TITLE = 21
  • value1: title_id

• TYPE_PVP_SCRIPT = 22

Make battleground or outdoor PvP script call for check current criteria requirements fit