achievement_criteria_data
The `achievement_criteria_data` table
This table contains the data that a player needs to obtain / complete in order to receive a given achievement.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
mediumint(8) | signed | PRI | NO | NULL |
|
| |
tinyint(3) | unsigned | PRI | NO | 0 |
|
| |
medium(8) | unsigned |
| NO | 0 |
|
| |
medium(8) | unsigned |
| NO | 0 |
|
| |
char(64) | signed |
| NO |
|
|
|
Description of the fields
criteria_id
This is the ID from Achievement_Criteria.dbc.
type
Depending on this value, it will determine how value1 and value2 are used.
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_SCRIPT |
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 |
20 | TYPE_MAP_ID |
21 | TYPE_S_PLAYER_CLASS_RACE |
22 | TYPE_NTH_BIRTHDAY |
23 | TYPE_S_KNOWN_TITLE |
value1
*TYPE_T_CREATURE
- The target here must be a valid entry from creature_template
*TYPE_T_PLAYER_CLASS_RACE
- The target here is a valid class (paste class list). value2 must also be set
*TYPE_T_PLAYER_LESS_HEALTH
- The percentage of health that the target must reach.
*TYPE_T_PLAYER_DEAD
- The faction of the target player (must match player attempting achievement).
*TYPE_S_AURA
- The spell ID of the aura that must be on the player. value2 must also be set.
*TYPE_S_AREA
- Area ID from AreaTable.dbc
*TYPE_T_AURA
- The spell ID of the aura that must be on the target. value2 must also be set.
*TYPE_VALUE
- Value to compare needed to attain achievement. This value is used in conjunction with another type. (see value2 for comparisation type)
*TYPE_T_LEVEL
- The minimum level that the target can be.
*TYPE_T_GENDER
- Gender: 0=Male, 1=Female
*TYPE_SCRIPT
- Used to disable an achievement if all requirements are not defined. Would usually be used if not all are known.
*TYPE_MAP_DIFFICULTY
- Map difficulty: (for dungeons)
- Normal = 0
- Heroic = 1
- Map difficulty: (for raids)
- 10 Man Normal = 0
- 25 Man Normal = 1
- 10 Man Heroic = 2
- 25 Man Heroic = 3
- Map difficulty: (for dungeons)
*TYPE_MAP_PLAYER_COUNT
- The number of other players that must be in the zone. (not sure if it is minimum or maximum).
*TYPE_T_TEAM
- The target must be on this team: Alliance = 469, Horde = 67
*TYPE_S_DRUNK
- How drunk the player must be:
- DRUNKEN_SOBER = 0
- DRUNKEN_TIPSY = 1
- DRUNKEN_DRUNK = 2
- DRUNKEN_SMASHED = 3
- How drunk the player must be:
*TYPE_HOLIDAY
- Holiday ID from Holiday.dbc and game_event. Must be an active holiday.
*TYPE_BG_LOSS_TEAM_SCORE
- Player's team win bg and opposition team have team score in range. // Min. score
*TYPE_INSTANCE_SCRIPT
- Make instance script call for check current criteria requirements fit.
*TYPE_S_EQUIPED_ITEM
*TYPE_MAP_ID
- Player must be on mapId
*TYPE_S_PLAYER_CLASS_RACE
- The Source here is a valid class (paste class list). value2 must also be set
*TYPE_NTH_BIRTHDAY
- Number of Birthday
*TYPE_S_KNOWN_TITLE
- The value here is a valid titleId. See CharTitles.dbc
value2
*TYPE_T_PLAYER_CLASS_RACE
*TYPE_S_PLAYER_CLASS_RACE
- The value here is a valid race ID. See ChrRaces.dbc
*TYPE_S_AURA
- Effect Index of the aura
*TYPE_T_AURA
- Effect Index of the aura
*TYPE_BG_LOSS_TEAM_SCORE
- Max. score
*TYPE_S_EQUIPED_ITEM
*TYPE_VALUE
ComparisationType:
COMP_TYPE_EQ = 0 COMP_TYPE_HIGH = 1 COMP_TYPE_LOW = 2 COMP_TYPE_HIGH_EQ = 3 COMP_TYPE_LOW_EQ = 4
ScriptName
The ScriptName for when scripting it in the core.
This might also be 'SmartTrigger'. It will than use SmartAI.