DB/Achievement Criteria: Difference between revisions

From wowdev
Jump to navigation Jump to search
mNo edit summary
(information about different types of criteria)
Line 13: Line 13:
| 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 || Group || Integer || For example: 129 is for professions on skill 450. Not always accurate.
| 4 || Requirement_1 || Integer ||  
|-
|-
| 5 || Quantity || Integer || Quantitiy required to meet this criteria (level, number of quests, etc)
| 5 || Value_1 || Integer ||  
|-
|-
| 6 || Category? || Integer || Some kind of category. 3 are BG things.
| 6 || Requirement_2 || Integer ||  
|-
| 7 || Value_2 || Integer ||
|-
| 8 || Requirement_3 || Integer ||
|-
| 9 || Value_3 || Integer ||
|-
| 10 || Description || [[Loc]] || Criteria description.
|-
| 27 || CompletionFlag || Integer ||
|-
| 28 || GroupFlag || Integer ||
|-
| 29 || Unknown || Integer ||
|-
| 30 || Timelimit || Integer || Complete quest in %i seconds.
|-
| 31 || Order || Integer ||
|}
 
==Information by type==
This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.
 
This information is retrieved from TrinityCore's [http://dev.trinitycore.org/trinitycore2/src/561ac59c59ac/src/game/DBCStructure.h DBCStructure.h].
 
====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;"
|- style="background:#F0F8FF;"
| 7 || [[Map.dbc|Map?]] || iRefID || Only set for battlegrounds.
| 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
|-
|-
| 8 || Category2? || Integer || Nearly the same as the ones before but different sometimes.
| 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;"
|- style="background:#F0F8FF;"
| 9 || [[Map.dbc|Map2?]] || iRefID ||
| 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
|-
|-
| 10 || Description || [[Loc]] || Criteria description.
| 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
|-
| 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
|}    
 
====HONORABLE_KILL_AT_AREA = 31 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
|- style="background:#F0F8FF;"
| 3 || [[AreaTable.dbc|Area]]  || iRefID
|-
| 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;"
| 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
|-
| 3 || unused || Integer ||           
|-       
| 4 || count || 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
|-
| 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
|-
| 3 || teamtype || Integer ||                      {2,3,5}
|-
| 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?
|-
| 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 ====
{| 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]]''
{| 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
|-
|-
| 27 || Unknown || Integer ||  
| 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
|-
|-
| 28 || Unknown || Integer ||  
| 3 || ratingType || Integer  
|}
 
====LOOT_TYPE              = 109 ====
{| style="background:#FCFCFC; color:black"
|-
! width="80" | Column
! width="180" | Field
! width="80" | Type
! width="500" | Notes
|-
|-
| 29 || Unknown || Integer ||  
| 3 || lootType || Integer || 3=fishing, 2=pickpocket, 4=disentchant
|-
|-
| 30 || Value || Integer || Complete quest in %i seconds.
| 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
|-
|-
| 31 || Unknown || Integer ||
| 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
|}          


[[Category:DBC]][[Category:3.0.2.8905]]
[[Category:DBC]][[Category:3.0.2.8905]]
__NOTOC__

Revision as of 22:10, 12 June 2009

Achievement criterias. This file has been added with WoW 3.0.1.8303

Structure

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 Requirement_1 Integer
5 Value_1 Integer
6 Requirement_2 Integer
7 Value_2 Integer
8 Requirement_3 Integer
9 Value_3 Integer
10 Description Loc Criteria description.
27 CompletionFlag Integer
28 GroupFlag Integer
29 Unknown Integer
30 Timelimit Integer Complete quest in %i seconds.
31 Order Integer

Information by type

This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.

This information is retrieved from TrinityCore's DBCStructure.h.

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

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

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


Retrieved from "https://wowdev.wiki/index.php?title=DB/Achievement_Criteria&oldid=2067"