这是本文档旧的修订版!
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.