AzerothCore 中文

用户工具

站点工具

您的足迹:
数据库:world数据库:achievement_criteria_data

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

后一修订版		前一修订版
数据库:world数据库:achievement_criteria_data [2023/09/24 13:22] – 创建 admin数据库:world数据库:achievement_criteria_data [2023/09/24 13:30] (当前版本) – [value1] admin
行 3: 行 3:
 [[数据库:world数据库:首页|<-返回:World 数据库]] [[数据库: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^ ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^
-|[[#id|id]]|INT|UNSIGNED|PRI|NO| | | | +|[[#criteria_id|criteria_id]]|MEDIUMINT| |PRI|NO| | | | 
-|[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | +|[[#type|type]]|TINYINT|UNSIGNED|PRI|NO|0| | | 
-|[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | +|[[#value1|value1]]|MEDIUMINT|UNSIGNED| |NO|0| | | 
-|[[#comment|comment]]|VARCHAR(255)|SIGNED| |YES|' '| | |+|[[#value2|value2]]|MEDIUMINT|UNSIGNED| |NO|0| | | 
 +|[[#ScriptName|ScriptName]]|char(64)| | |NO| | | | 
  
 ===== 字段说明 ===== ===== 字段说明 =====
行 22: 行 24:
 Depending on this value, it will determine how value1 and value2 are used. Depending on this value, it will determine how value1 and value2 are used.
  
-Type Name +^Type^Name^ 
-0 TYPE_NONE +|0|TYPE_NONE| 
-1 TYPE_T_CREATURE +|1|TYPE_T_CREATURE| 
-2 TYPE_T_PLAYER_CLASS_RACE +|2|TYPE_T_PLAYER_CLASS_RACE| 
-3 TYPE_T_PLAYER_LESS_HEALTH +|3|TYPE_T_PLAYER_LESS_HEALTH| 
-4 TYPE_T_PLAYER_DEAD +|4|TYPE_T_PLAYER_DEAD| 
-5 TYPE_S_AURA +|5|TYPE_S_AURA| 
-6 TYPE_S_AREA +|6|TYPE_S_AREA| 
-7 TYPE_T_AURA +|7|TYPE_T_AURA| 
-8 TYPE_VALUE +|8|TYPE_VALUE| 
-9 TYPE_T_LEVEL +|9|TYPE_T_LEVEL| 
-10 TYPE_T_GENDER +|10|TYPE_T_GENDER| 
-11 TYPE_SCRIPT +|11|TYPE_SCRIPT| 
-12 TYPE_MAP_DIFFICULTY +|12|TYPE_MAP_DIFFICULTY| 
-13 TYPE_MAP_PLAYER_COUNT +|13|TYPE_MAP_PLAYER_COUNT| 
-14 TYPE_T_TEAM +|14|TYPE_T_TEAM| 
-15 TYPE_S_DRUNK +|15|TYPE_S_DRUNK| 
-16 TYPE_HOLIDAY +|16|TYPE_HOLIDAY| 
-17 TYPE_BG_LOSS_TEAM_SCORE +|17|TYPE_BG_LOSS_TEAM_SCORE| 
-18 TYPE_INSTANCE_SCRIPT +|18|TYPE_INSTANCE_SCRIPT| 
-19 TYPE_S_EQUIPED_ITEM +|19|TYPE_S_EQUIPED_ITEM| 
-20 TYPE_MAP_ID +|20|TYPE_MAP_ID| 
-21 TYPE_S_PLAYER_CLASS_RACE +|21|TYPE_S_PLAYER_CLASS_RACE| 
-22 TYPE_NTH_BIRTHDAY +|22|TYPE_NTH_BIRTHDAY| 
-23 TYPE_S_KNOWN_TITLE+|23|TYPE_S_KNOWN_TITLE| 
 ==== value1 ==== ==== value1 ====
  
-TYPE_T_CREATURE +**TYPE_T_CREATURE** 
- +  * The target here must be a valid entry from creature_template 
-The target here must be a valid entry from creature_template +**TYPE_T_PLAYER_CLASS_RACE** 
-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 target here is a valid class (paste class list). value2 must also be set +  * The percentage of health that the target must reach. 
-TYPE_T_PLAYER_LESS_HEALTH +**TYPE_T_PLAYER_DEAD** 
- +  * The faction of the target player (must match player attempting achievement). 
-The percentage of health that the target must reach. +**TYPE_S_AURA** 
-TYPE_T_PLAYER_DEAD +  * The spell ID of the aura that must be on the player. value2 must also be set. 
- +**TYPE_S_AREA** 
-The faction of the target player (must match player attempting achievement). +  * Area ID from AreaTable.dbc 
-TYPE_S_AURA +**TYPE_T_AURA** 
- +  * The spell ID of the aura that must be on the target. value2 must also be set. 
-The spell ID of the aura that must be on the player. value2 must also be set. +**TYPE_VALUE** 
-TYPE_S_AREA +  * Value to compare needed to attain achievement. This value is used in conjunction with another type. (see value2 for comparisation type) 
- +**TYPE_T_LEVEL** 
-Area ID from AreaTable.dbc +  * The minimum level that the target can be. 
-TYPE_T_AURA +**TYPE_T_GENDER** 
- +  * Gender: 0=Male, 1=Female 
-The spell ID of the aura that must be on the target. value2 must also be set. +**TYPE_SCRIPT** 
-TYPE_VALUE +  * Used to disable an achievement if all requirements are not defined. Would usually be used if not all are known. 
- +**TYPE_MAP_DIFFICULTY** 
-Value to compare needed to attain achievement. This value is used in conjunction with another type. (see value2 for comparisation type) +  * Map difficulty: (for dungeons) 
-TYPE_T_LEVEL +    * Normal = 0 
- +    * Heroic = 1 
-The minimum level that the target can be. +  * Map difficulty: (for raids) 
-TYPE_T_GENDER +    * 10 Man Normal = 0 
- +    * 25 Man Normal = 1 
-Gender: 0=Male, 1=Female +    * 10 Man Heroic = 2 
-TYPE_SCRIPT +    * 25 Man Heroic = 3 
- +**TYPE_MAP_PLAYER_COUNT** 
-Used to disable an achievement if all requirements are not defined. Would usually be used if not all are known. +  * The number of other players that must be in the zone. (not sure if it is minimum or maximum). 
-TYPE_MAP_DIFFICULTY +**TYPE_T_TEAM** 
- +  * The target must be on this team: Alliance = 469, Horde = 67 
-Map difficulty: (for dungeons) +**TYPE_S_DRUNK** 
-Normal = 0 +  * How drunk the player must be: 
-Heroic = 1 +    * DRUNKEN_SOBER = 0 
-Map difficulty: (for raids) +    * DRUNKEN_TIPSY = 1 
-10 Man Normal = 0 +    * DRUNKEN_DRUNK = 2 
-25 Man Normal = 1 +    * DRUNKEN_SMASHED = 3 
-10 Man Heroic = 2 +**TYPE_HOLIDAY** 
-25 Man Heroic = 3 +  * Holiday ID from Holiday.dbc and game_event. Must be an active holiday. 
-TYPE_MAP_PLAYER_COUNT +**TYPE_BG_LOSS_TEAM_SCORE** 
- +  * Player's team win bg and opposition team have team score in range. <nowiki>//</nowiki> Min. score 
-The number of other players that must be in the zone. (not sure if it is minimum or maximum). +**TYPE_INSTANCE_SCRIPT** 
-TYPE_T_TEAM +  * Make instance script call for check current criteria requirements fit. 
- +**TYPE_S_EQUIPED_ITEM** 
-The target must be on this team: Alliance = 469, Horde = 67 +  * Item level 
-TYPE_S_DRUNK +**TYPE_MAP_ID** 
- +  * Player must be on mapId 
-How drunk the player must be: +**TYPE_S_PLAYER_CLASS_RACE** 
-DRUNKEN_SOBER = 0 +  * The Source here is a valid class (paste class list). value2 must also be set   
-DRUNKEN_TIPSY = 1 +**TYPE_NTH_BIRTHDAY** 
-DRUNKEN_DRUNK = 2 +  * Number of Birthday 
-DRUNKEN_SMASHED = 3 +**TYPE_S_KNOWN_TITLE** 
-TYPE_HOLIDAY +  * The value here is a valid titleId. See CharTitles.dbc
- +
-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 ==== ==== value2 ====
  
-TYPE_T_PLAYER_CLASS_RACE TYPE_S_PLAYER_CLASS_RACE +**TYPE_T_PLAYER_CLASS_RACE TYPE_S_PLAYER_CLASS_RACE** 
- +  * The value here is a valid race ID. See ChrRaces.dbc 
-The value here is a valid race ID. See ChrRaces.dbc +**TYPE_S_AURA** 
-TYPE_S_AURA +  * Effect Index of the aura 
- +**TYPE_T_AURA** 
-Effect Index of the aura +  * Effect Index of the aura 
-TYPE_T_AURA +**TYPE_BG_LOSS_TEAM_SCORE** 
- +  * Max. score 
-Effect Index of the aura +**TYPE_S_EQUIPED_ITEM** 
-TYPE_BG_LOSS_TEAM_SCORE +  * Item quality 
- +**TYPE_VALUE** 
-Max. score +^ComparisationType^ 
-TYPE_S_EQUIPED_ITEM +|COMP_TYPE_EQ = 0| 
- +|COMP_TYPE_HIGH = 1| 
-Item quality +|COMP_TYPE_LOW = 2| 
-TYPE_VALUE +|COMP_TYPE_HIGH_EQ = 3| 
- +|COMP_TYPE_LOW_EQ = 4|
-ComparisationType +
-COMP_TYPE_EQ = 0 +
-COMP_TYPE_HIGH = 1 +
-COMP_TYPE_LOW = 2 +
-COMP_TYPE_HIGH_EQ = 3 +
-COMP_TYPE_LOW_EQ = 4+
 ==== ScriptName ==== ==== ScriptName ====
  
数据库/world数据库/achievement_criteria_data.1695532960.txt.gz · 最后更改: 2023/09/24 13:22 由 admin
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki