这是本文档旧的修订版!
achievement_criteria_data 表
This table contains the data that a player needs to obtain / complete in order to receive a given achievement.
表结构
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
criteria_id | MEDIUMINT | PRI | NO | ||||
type | TINYINT | UNSIGNED | PRI | NO | 0 | ||
value1 | MEDIUMINT | UNSIGNED | NO | 0 | |||
value2 | MEDIUMINT | UNSIGNED | NO | 0 | |||
ScriptName | char(64) | NO |
字段说明
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 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 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
Item level 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
- Item quality
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.