====== achievement_criteria_data 表 ====== ---- [[数据库:world数据库:首页|<-返回:World 数据库]] 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|criteria_id]]|MEDIUMINT| |PRI|NO| | | | |[[#type|type]]|TINYINT|UNSIGNED|PRI|NO|0| | | |[[#value1|value1]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#value2|value2]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#ScriptName|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.