DB/Achievement Criteria
Jump to navigation
Jump to search
Achievement criterias.
3.0.2.8303-3.3.5.12340
Table
Column | Field | Type | Notes |
---|---|---|---|
1 | ID | Integer | |
2 | Achievement | iRefID | References the achievement this criteria is needed for. |
3 | Type | Integer | Which type is this criteria? This defines the rows below. See below. |
4 | ReqAssetID | Integer | Main requirement |
5 | ReqAmount | Integer | Main requirement count |
6 | StartEvent | Integer | additional requirement 1 type |
7 | StartAssetID | Integer | additional requirement 1 value |
8 | FailEvent | Integer | additional requirement 2 type |
9 | FailAssetID | Integer | additional requirement 2 value |
10-26 | Description | Loc | Criteria description. |
27 | Flags | Integer | |
28 | TimerStartEvent | Integer | |
29 | TimerAssetID | Integer | |
30 | TimerTime | Integer | Complete quest in %i seconds. |
31 | OrderInUI | Integer | Order of criteria in achievement's description. |
Flags
Value | Description | Comment |
---|---|---|
0x01 | CRITERIA_FLAG_PROGRESS_BAR | |
0x02 | CRITERIA_FLAG_HIDDEN | |
0x04 | CRITERIA_FLAG_FAIL_ACHIEVEMENT | achievement is failed if criteria is not met |
0x08 | CRITERIA_FLAG_RESET_ON_START | criteria counters reset each restart |
0x10 | CRITERIA_FLAG_IS_DATE | is a date requirement |
0x20 | CRITERIA_FLAG_IS_MONEY | counter shows currency |
0x40 | CRITERIA_FLAG_IS_ACHIEVEMENT_ID | |
0x80 | CRITERIA_FLAG_QUANTITY_IS_CAPPED |
Information by Type
This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.
KILL_CREATURE = 0
Also used for player deaths..
Column | Field | Type |
---|---|---|
3 | creatureID | Integer |
4 | Integer |
WIN_BG = 1
There are further criterias instead just winning
Column | Field | Type |
---|---|---|
3 | Map | iRefID |
4 | winCount | Integer |
REACH_LEVEL = 5
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | level | Integer |
REACH_SKILL_LEVEL = 7
Column | Field | Type | Notes |
---|---|---|---|
3 | skillID | iRefID | SkillLine.dbc or what? |
4 | skillLevel | Integer |
COMPLETE_ACHIEVEMENT = 8
Column | Field | Type |
---|---|---|
3 | Achievement | iRefID |
COMPLETE_QUEST_COUNT = 9
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | totalQuestCount | Integer |
COMPLETE_DAILY_QUEST_DAILY = 10
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | numberOfDays | Integer |
COMPLETE_QUESTS_IN_ZONE = 11
Column | Field | Type |
---|---|---|
3 | zoneID | Integer |
4 | questCount | Integer |
COMPLETE_DAILY_QUEST = 14
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | questCount | Integer |
COMPLETE_BATTLEGROUND = 15
DEATH_AT_MAP = 16
Column | Field | Type |
---|---|---|
3 | Map | iRefID |
DEATH_IN_DUNGEON = 18
Column | Field | Type |
---|---|---|
3 | manLimit | Integer |
COMPLETE_RAID = 19
Column | Field | Type | Notes |
---|---|---|---|
3 | groupSize | Integer | can be 5, 10 or 25 |
KILLED_BY_CREATURE = 20
Column | Field | Type |
---|---|---|
3 | creatureEntry | Integer |
FALL_WITHOUT_DYING = 24
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | fallHeight | Integer |
DEATHS_FROM = 26
Column | Field | Type |
---|---|---|
3 | EnvironmentalDamage | iRefID |
COMPLETE_QUEST = 27
Column | Field | Type |
---|---|---|
3 | questID | Integer |
4 | questCount | Integer |
BE_SPELL_TARGET = 28
BE_SPELL_TARGET2 = 69
Column | Field | Type | |
---|---|---|---|
3 | Spell | iRefID | |
4 | spellCount | Integer |
CAST_SPELL = 29
CAST_SPELL2 = 110
Column | Field | Type |
---|---|---|
3 | Spell | iRefID |
4 | castCount | Integer |
BG_OBJECTIVE_CAPTURE = 30
Column | Field | Type | Notes |
---|---|---|---|
3 | unknow | Integer | // value 42 = capture the flag |
4 | count(?) | Integer | // how many captures required |
HONORABLE_KILL_AT_AREA = 31
Column | Field | Type |
---|---|---|
3 | Area | iRefID |
4 | killCount | Integer |
WIN_ARENA = 32
PLAY_ARENA = 33
Column | Field | Type |
---|---|---|
3 | Map | iRefID |
LEARN_SPELL = 34
Column | Field | Type |
---|---|---|
3 | Spell | iRefID |
WIN_RATED_ARENA = 37
Column | Field | Type | Notes |
---|---|---|---|
3 | unused | Integer | |
4 | count | Integer | |
5 | flag | Integer | 4=in a row |
HIGHEST_TEAM_RATING = 38
Column | Field | Type | Notes |
---|---|---|---|
3 | teamtype | Integer | {2,3,5} |
REACH_TEAM_RATING = 39
Column | Field | Type | Notes |
---|---|---|---|
3 | teamtype | Integer | {2,3,5} |
4 | teamrating | Integer |
LEARN_SKILL_LEVEL = 40
Column | Field | Type | Notes |
---|---|---|---|
3 | skillID | iRefID | SkillLine.dbc or what? |
4 | skillLevel | Integer | apprentice=1, journeyman=2, expert=3, artisan=4, master=5, grand master=6 |
OWN_ITEM = 36
USE_ITEM = 41
LOOT_ITEM = 42
EQUIP_ITEM = 57
Column | Field | Type |
---|---|---|
3 | Item | iRefID |
4 | itemCount | Integer |
EXPLORE_AREA = 43
This areaReference is NOT the index from AreaTable.dbc but from WorldMapOverlayRec
Column | Field | Type |
---|---|---|
3 | areaReference | Integer |
OWN_RANK = 44
This rank is NOT the index from CharTitles.dbc
Column | Field | Type |
---|---|---|
3 | rank | Integer |
BUY_BANK_SLOT = 45
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | numberOfSlots | Integer |
GAIN_REPUTATION = 46
Column | Field | Type | Notes |
---|---|---|---|
3 | Faction | iRefID | |
4 | reputationAmount | Integer | Total reputation amount, so 42000 = exalted |
GAIN_EXALTED_REPUTATION= 47
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | numberOfExaltedFactions | Integer |
VISIT_BARBER_SHOP = 48
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | numberOfVisits | Integer |
EQUIP_EPIC_ITEM = 49
Where is the required itemlevel stored?
Column | Field | Type |
---|---|---|
3 | itemSlot | Integer |
ROLL_NEED_ON_LOOT = 50
ROLL_GREED_ON_LOOT = 51
Column | Field | Type |
---|---|---|
3 | rollValue | Integer |
4 | count | Integer |
HK_CLASS = 52
Column | Field | Type |
---|---|---|
3 | Class | iRefID |
4 | count | Integer |
HK_RACE = 53
Column | Field | Type |
---|---|---|
3 | Race | iRefID |
4 | count | Integer |
DO_EMOTE = 54
where is the information about the target stored?
Column | Field | Type | Notes |
---|---|---|---|
3 | Emote | iRefID | |
4 | count | Integer | count of emotes, always required special target or requirements |
DAMAGE_DONE = 13
HEALING_DONE = 55
GET_KILLING_BLOWS = 56
Column | Field | Type | Notes |
---|---|---|---|
3 | unused | Integer | |
4 | count | Integer | |
5 | flag | Integer | 3 for battleground healing |
6 | Map | iRefID |
MONEY_FROM_QUEST_REWARD= 62
LOOT_MONEY = 67
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | goldInCopper | Integer |
USE_GAMEOBJECT = 68
Column | Field | Type |
---|---|---|
3 | goEntry | Integer |
4 | useCount | Integer |
SPECIAL_PVP_KILL = 70
Are those special criteria stored in the dbc?
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | killCount | Integer |
FISH_IN_GAMEOBJECT = 72
Column | Field | Type |
---|---|---|
3 | goEntry | Integer |
4 | lootCount | Integer |
LEARN_SKILLLINE_SPELLS = 75
Column | Field | Type |
---|---|---|
3 | SkillLine | iRefID |
4 | spellCount | Integer |
WIN_DUEL = 76
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | duelCount | Integer |
HIGHEST_POWER = 96
Column | Field | Type | Notes |
---|---|---|---|
3 | powerType | Integer | 0=mana, 1=rage, 3=energy, 6=runic power |
HIGHEST_STAT = 97
Column | Field | Type | Notes |
---|---|---|---|
3 | statType | Integer | 4=spirit, 3=int, 2=stamina, 1=agi, 0=strength |
HIGHEST_SPELLPOWER = 98
Column | Field | Type | Notes |
---|---|---|---|
3 | spellSchool | iRefID | SkillLine or Resistances ? |
HIGHEST_RATING = 100
Column | Field | Type |
---|---|---|
3 | ratingType | Integer |
LOOT_TYPE = 109
Column | Field | Type | Notes |
---|---|---|---|
3 | lootType | Integer | 3=fishing, 2=pickpocket, 4=disentchant |
4 | lootTypeCount | Integer |
LEARN_SKILL_LINE = 112
Column | Field | Type |
---|---|---|
3 | SkillLine | iRefID |
4 | spellCount | Integer |
EARN_HONORABLE_KILL = 113
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | killCount | Integer |
ACCEPTED_SUMMONS = 114
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | Here comes a 1 in, because it's a Statistic | Integer |
ACHIVEMENTPOINTS_REACHED = 115
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | unused | Integer |
//This thing really confuses me... Maybe it is only used for "Over Ninethousand", because nowhere AchPoints are Specified
RANDOM_DUNGEON_PLAYERCOUNT = 119
Column | Field | Type |
---|---|---|
3 | unused | Integer |
4 | PlayerCount | Integer |