DB/Achievement Criteria: Difference between revisions

From wowdev
Jump to navigation Jump to search
(Updated. New Style.)
m (flags from client, comments from trinity)
 
(27 intermediate revisions by 8 users not shown)
Line 1: Line 1:
Achievement criterias. This file has been added with WoW 3.0.1.8303
__FORCETOC__
Achievement criterias.  


== Structure ==
{{Template:Sandbox/VersionRange|min_expansionlevel=3|max_expansionlevel=5}}
 
==3.0.2.8303-3.3.5.12340==
===Table===
{| style="background:#FCFCFC; color:black"
{| style="background:#FCFCFC; color:black"
|-  
|-  
Line 13: Line 17:
| 2 || [[Achievement.dbc|Achievement]] || iRefID || References the achievement this criteria is needed for.
| 2 || [[Achievement.dbc|Achievement]] || iRefID || References the achievement this criteria is needed for.
|-
|-
| 3 || Unknown || Integer ||  
| 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===
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Value
! width="250" | Description
! width="300" | 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..''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || creatureID || Integer
|-       
| 4 || creatureCount | Integer
|}          
 
====WIN_BG = 1 ====
''There are further criterias instead just winning''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[Map.dbc|Map]] || iRefID
|-     
| 4 || winCount || Integer   
|}  
 
====REACH_LEVEL            = 5 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-
| 4 || level || Integer
|}          
 
====REACH_SKILL_LEVEL      = 7 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|- style="background:#F0F8FF;"
| 3 || skillID || iRefID || [[SkillLine.dbc]] or what?
|-
| 4 || skillLevel || Integer ||       
|}        
 
====COMPLETE_ACHIEVEMENT  = 8 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[Achievement.dbc|Achievement]]  || iRefID
|}
 
====COMPLETE_QUEST_COUNT  = 9 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-
| 4 || totalQuestCount || Integer
|}    
 
====COMPLETE_DAILY_QUEST_DAILY = 10 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-   
| 4 || numberOfDays || Integer
|}    
 
====COMPLETE_QUESTS_IN_ZONE = 11 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || zoneID || Integer
|-       
| 4 || questCount || Integer
|}        
 
====COMPLETE_DAILY_QUEST  = 14 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-       
| 4 || questCount || Integer
|}          
 
====COMPLETE_BATTLEGROUND  = 15 ====
====DEATH_AT_MAP          = 16 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 ||[[Map.dbc|Map]] || iRefID
|}            
 
====DEATH_IN_DUNGEON      = 18 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || manLimit || Integer
|}          
 
====COMPLETE_RAID          = 19 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
| 3 || groupSize || Integer ||                  can be 5, 10 or 25
|}
 
====KILLED_BY_CREATURE    = 20 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || creatureEntry || Integer
|}    
 
====FALL_WITHOUT_DYING    = 24 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-     
| 4 || fallHeight || Integer
|}        
 
====DEATHS_FROM            = 26 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[EnvironmentalDamage.dbc|EnvironmentalDamage]] || iRefID
|}
 
====COMPLETE_QUEST        = 27 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
|-
| 4 || Group || Integer || For example: 129 is for professions on skill 450. Not always accurate.
| 3 || questID || Integer
|-           
| 4 || questCount || Integer    
|}
 
====BE_SPELL_TARGET        = 28 ====
====BE_SPELL_TARGET2      = 69 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 ||  [[Spell.dbc|Spell]]    || iRefID
|-       
| 4 || spellCount || Integer ||           
|}      
 
====CAST_SPELL            = 29 ====
====CAST_SPELL2            = 110 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 ||  [[Spell.dbc|Spell]]    || iRefID
|-       
| 4 || castCount || Integer
|}    
 
====BG_OBJECTIVE_CAPTURE            = 30 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
|-
| 5 || Quantity || Integer || Quantitiy required to meet this criteria (level, number of quests, etc)
| 3 || unknow || Integer ||                   // value 42 = capture the flag
|-
|-
| 6 || Category? || Integer || Some kind of category. 3 are BG things.
| 4 || count(?) || Integer ||                   // how many captures required
|}
 
====HONORABLE_KILL_AT_AREA = 31 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
|- style="background:#F0F8FF;"
| 7 || [[Map.dbc|Map?]] || iRefID || Only set for battlegrounds.
| 3 || [[AreaTable.dbc|Area]] || iRefID  
|-
|-
| 8 || Category2? || Integer || Nearly the same as the ones before but different sometimes.
| 4 || killCount || Integer  
|}        
 
====WIN_ARENA              = 32 ====
====PLAY_ARENA            = 33 ====
 
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[Map.dbc|Map]] || iRefID
|}
 
====LEARN_SPELL            = 34 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
|- style="background:#F0F8FF;"
| 9 || [[Map.dbc|Map2?]] || iRefID ||
| 3 || [[Spell.dbc|Spell]]   || iRefID  
|}
 
====WIN_RATED_ARENA        = 37 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
|-
| 10 || Description || [[Loc]] || Criteria description.
| 3 || unused || Integer ||            
|-       
| 4 || count || Integer ||                     
|-
|-
| 27 || Unknown || Integer ||  
| 5 || flag || Integer || 4=in a row
|}
 
====HIGHEST_TEAM_RATING    = 38 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
|-
| 28 || Unknown || Integer ||  
| 3 || teamtype || Integer ||                     {2,3,5}
|}
 
====REACH_TEAM_RATING      = 39 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
|-
| 29 || Unknown || Integer ||  
| 3 || teamtype || Integer ||                     {2,3,5}
|-
|-
| 30 || Unknown || Integer ||  
| 4 || teamrating || Integer ||          
|}      
 
====LEARN_SKILL_LEVEL      = 40 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|- style="background:#F0F8FF;"
| 3 || skillID || iRefID || [[SkillLine.dbc]] or what?
|-
|-
| 31 || Unknown || Integer ||  
| 4 || skillLevel || Integer || apprentice=1, journeyman=2, expert=3, artisan=4, master=5, grand master=6
|}
|}


[[Category:DBC]][[Category:3.0.2.8905]]
====OWN_ITEM              = 36 ====
====USE_ITEM              = 41 ====
====LOOT_ITEM              = 42 ====
====EQUIP_ITEM            = 57 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[Item.dbc|Item]] || iRefID
|-
| 4 || itemCount || Integer       
|}
 
====EXPLORE_AREA          = 43 ====
''This areaReference is '''NOT''' the index from [[AreaTable.dbc]] but from {{DBRef|table=WorldMapOverlay}}''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || areaReference || Integer       
|}
 
====OWN_RANK              = 44 ====
''This rank is '''NOT''' the index from [[CharTitles.dbc]]''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || rank || Integer   
|}    
 
====BUY_BANK_SLOT          = 45 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-     
| 4 || numberOfSlots || Integer
|}        
 
====GAIN_REPUTATION        = 46 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|- style="background:#F0F8FF;"
| 3 || [[Faction.dbc|Faction]] || iRefID ||
|-     
| 4 || reputationAmount || Integer ||            Total reputation amount, so 42000 = exalted
|}
 
====GAIN_EXALTED_REPUTATION= 47 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-       
| 4 || numberOfExaltedFactions || Integer 
|}
 
====VISIT_BARBER_SHOP      = 48 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-           
| 4 || numberOfVisits || Integer         
|}
 
====EQUIP_EPIC_ITEM        = 49 ====
''Where is the required itemlevel stored?''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || itemSlot || Integer       
|}
 
====ROLL_NEED_ON_LOOT      = 50 ====
====ROLL_GREED_ON_LOOT      = 51 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || rollValue || Integer
|-           
| 4 || count || Integer     
|}  
 
====HK_CLASS              = 52 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[ChrClasses.dbc|Class]] || iRefID
|-             
| 4 || count || Integer             
|}
 
====HK_RACE                = 53 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 ||  [[ChrRaces.dbc|Race]] || iRefID
|-           
| 4 || count || Integer   
|}
 
====DO_EMOTE              = 54 ====
''where is the information about the target stored?''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|- style="background:#F0F8FF;"
| 3 || [[Emotes.dbc|Emote]] || iRefID ||
|-
| 4 || count || Integer ||  count of emotes, always required special target or requirements
|}
 
====DAMAGE_DONE            = 13 ====
====HEALING_DONE          = 55 ====
====GET_KILLING_BLOWS      = 56 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
| 3 || unused || Integer ||     
|-         
| 4 || count || Integer ||         
|-         
| 5 || flag || Integer || 3 for battleground healing
|- style="background:#F0F8FF;"
| 6 || [[Map.dbc|Map]] || iRefID ||
|}
 
====MONEY_FROM_QUEST_REWARD= 62 ====
====LOOT_MONEY            = 67 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-       
| 4 || goldInCopper || Integer
|}                    
 
====USE_GAMEOBJECT        = 68 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || goEntry || Integer
|-     
| 4 || useCount || Integer
|}              
 
====SPECIAL_PVP_KILL      = 70 ====
''Are those special criteria stored in the dbc?''
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-       
| 4 || killCount || Integer
|}            
 
====FISH_IN_GAMEOBJECT    = 72 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || goEntry || Integer
|-             
| 4 || lootCount || Integer
|}          
 
====LEARN_SKILLLINE_SPELLS = 75 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[SkillLine.dbc|SkillLine]] || iRefID
|-             
| 4 || spellCount || Integer
|}      
 
====WIN_DUEL              = 76 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-       
| 4 || duelCount || Integer
|}              
 
====HIGHEST_POWER          = 96 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
| 3 || powerType || Integer ||  0=mana, 1=rage, 3=energy, 6=runic power
|}
 
====HIGHEST_STAT          = 97 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
| 3 || statType || Integer || 4=spirit, 3=int, 2=stamina, 1=agi, 0=strength
|}
 
====HIGHEST_SPELLPOWER    = 98 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|- style="background:#F0F8FF;"
| 3 ||spellSchool || iRefID ||  [[SkillLine.dbc|SkillLine]] or [[Resistances.dbc|Resistances]] ?
|}
 
====HIGHEST_RATING        = 100 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || ratingType || Integer
|}
 
====LOOT_TYPE              = 109 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
| 3 || lootType || Integer ||  3=fishing, 2=pickpocket, 4=disentchant
|-
| 4 || lootTypeCount || Integer ||             
|}
 
====LEARN_SKILL_LINE      = 112 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[SkillLine.dbc|SkillLine]] || iRefID
|-
| 4 || spellCount || Integer
|}
 
====EARN_HONORABLE_KILL    = 113 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-  
| 4 || killCount || Integer
|}
 
====ACCEPTED_SUMMONS    = 114 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-  
| 4 || Here comes a 1 in, because it's a Statistic|| Integer
|}
 
====ACHIVEMENTPOINTS_REACHED  = 115 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | 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 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|-
| 3 || unused || Integer
|-  
| 4 || PlayerCount || Integer
|}
 
[[Category:DBC]][[Category:DBC_WotLK]]

Latest revision as of 13:18, 16 April 2019

Achievement criterias.

Wrath … Mists

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
Retrieved from "https://wowdev.wiki/index.php?title=DB/Achievement_Criteria&oldid=26675"