Achievement Criteria

Back-to:DBC

Achievement_Criteria.dbc

This DBC has been added with WoW 3.0.1.8303 and contains the needed criteria to obtain an achievement.

Version is : 3.3.5a

Structure

Column	Field	Type	Notes
1	ID	Integer	Criteria ID
2	Achievement	iRefID	Reference to the achievement this criteria is needed for.
3	Type	Integer	Which type is this criteria? This defines the rows below. See below.
4	asset_id	Integer	Main requirement
5	Quantity	Integer	Main requirement count
6	start_event	Integer	additional requirement 1 type
7	start_asset	Integer	additional requirement 1 value
8	fail_event	Integer	additional requirement 2 type
9	fail_asset	Integer	additional requirement 2 value
10-25	Description	Loc	Criteria description.
26	?		Mostly 16712190, but not always
27	Flags	Integer	display flags: 1: shows progress bar (other flags I don't know)
28	timer_start_event	Integer
29	timer_asset_id	Integer
30	timer_time	Integer	Complete quest in %i seconds.
31	ui_order	Integer

Description of the fields

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

This information is retrieved from DBCStructure.h.

KILL_CREATURE = 0

Also used for player deaths..

Column	Field	Type
4	creatureID	Integer
5	killCount	Integer

WIN_BG = 1

There are further criterias instead just winning

Column	Field	Type
4	Map	iRefID
5	winCount	Integer

REACH_LEVEL = 5

Column	Field	Type
4	unused	Integer
5	level	Integer

REACH_SKILL_LEVEL = 7

Column	Field	Type	Notes
4	skillID	iRefID	SkillLine.dbc or what?
5	skillLevel	Integer

COMPLETE_ACHIEVEMENT = 8

Column	Field	Type
4	Achievement	iRefID

COMPLETE_QUEST_COUNT = 9

Column	Field	Type
4	unused	Integer
5	totalQuestCount	Integer

COMPLETE_DAILY_QUEST_DAILY = 10

Column	Field	Type
4	unused	Integer
5	numberOfDays	Integer

COMPLETE_QUESTS_IN_ZONE = 11

Column	Field	Type
4	zoneID	Integer
5	questCount	Integer

DAMAGE_DONE = 13

COMPLETE_DAILY_QUEST = 14

Column	Field	Type
4	unused	Integer
5	questCount	Integer

COMPLETE_BATTLEGROUND = 15

DEATH_AT_MAP = 16

Column	Field	Type
4	Map	iRefID

DEATH_IN_DUNGEON = 18

Column	Field	Type
4	manLimit	Integer

COMPLETE_RAID = 19

Column	Field	Type	Notes
4	groupSize	Integer	can be 5, 10 or 25

KILLED_BY_CREATURE = 20

Column	Field	Type
4	creatureEntry	Integer

FALL_WITHOUT_DYING = 24

Column	Field	Type
4	unused	Integer
5	fallHeight	Integer

DEATHS_FROM = 26

Column	Field	Type
4	EnvironmentalDamage	iRefID

COMPLETE_QUEST = 27

Column	Field	Type
4	questID	Integer
5	questCount	Integer

BE_SPELL_TARGET = 28

BE_SPELL_TARGET2 = 69

Column	Field	Type
4	Spell	iRefID
5	spellCount	Integer

CAST_SPELL = 29

CAST_SPELL2 = 110

Column	Field	Type
4	Spell	iRefID
5	castCount	Integer

BG_OBJECTIVE_CAPTURE = 30

Column	Field	Type	Notes
4	unknow	Integer	value 42 = capture the flag
5	count(?)	Integer	how many captures required

HONORABLE_KILL_AT_AREA = 31

Column	Field	Type
4	Area	iRefID
5	killCount	Integer

WIN_ARENA = 32

PLAY_ARENA = 33

Column	Field	Type
4	Map	iRefID

LEARN_SPELL = 34

Column	Field	Type
4	Spell	iRefID

OWN_ITEM = 36

WIN_RATED_ARENA = 37

Column	Field	Type	Notes
4	unused	Integer
5	count	Integer
6	flag	Integer	4=in a row

HIGHEST_TEAM_RATING = 38

Column	Field	Type	Notes
4	teamtype	Integer

REACH_TEAM_RATING = 39

Column	Field	Type	Notes
4	teamtype	Integer
5	teamrating	Integer

LEARN_SKILL_LEVEL = 40

Column	Field	Type	Notes
4	skillID	iRefID	SkillLine.dbc or what?
5	skillLevel	Integer	apprentice=1, journeyman=2, expert=3, artisan=4, master=5, grand master=6

USE_ITEM = 41

LOOT_ITEM = 42

EXPLORE_AREA = 43

This areaReference is NOT the index from AreaTable.dbc. It's from WorldMapOverlay.dbc.

Column	Field	Type
4	areaReference	Integer

OWN_RANK = 44

This rank is NOT the index from CharTitles.dbc

Column	Field	Type
4	rank	Integer

BUY_BANK_SLOT = 45

Column	Field	Type
4	unused	Integer
5	numberOfSlots	Integer

GAIN_REPUTATION = 46

Column	Field	Type	Notes
4	Faction	iRefID
5	reputationAmount	Integer	Total reputation amount, so 42000 = exalted

GAIN_EXALTED_REPUTATION= 47

Column	Field	Type
4	unused	Integer
5	numberOfExaltedFactions	Integer

VISIT_BARBER_SHOP = 48

Column	Field	Type
4	unused	Integer
5	numberOfVisits	Integer

EQUIP_EPIC_ITEM = 49

ItemLevel

Column	Field	Type
4	itemSlot	Integer

ROLL_NEED_ON_LOOT = 50

ROLL_GREED_ON_LOOT = 51

Column	Field	Type
4	rollValue	Integer
5	count	Integer

HK_CLASS = 52

Column	Field	Type
4	Class	iRefID
5	count	Integer

HK_RACE = 53

Column	Field	Type
4	Race	iRefID
5	count	Integer

DO_EMOTE = 54

where is the information about the target stored?

Column	Field	Type	Notes
4	Emote	iRefID
5	count	Integer	count of emotes, always required special target or requirements

HEALING_DONE = 55

GET_KILLING_BLOWS = 56

Column	Field	Type	Notes
4	unused	Integer
5	count	Integer
6	flag	Integer	3 for battleground healing
7	Map	iRefID

EQUIP_ITEM = 57

Column	Field	Type
4	Item	iRefID
5	itemCount	Integer

MONEY_FROM_QUEST_REWARD= 62

LOOT_MONEY = 67

Column	Field	Type
4	unused	Integer
5	goldInCopper	Integer

USE_GAMEOBJECT = 68

Column	Field	Type
4	goEntry	Integer
5	useCount	Integer

SPECIAL_PVP_KILL = 70

Are those special criteria stored in the dbc?

Column	Field	Type
4	unused	Integer
5	killCount	Integer

FISH_IN_GAMEOBJECT = 72

Column	Field	Type
4	goEntry	Integer
5	lootCount	Integer

LEARN_SKILLLINE_SPELLS = 75

Column	Field	Type
4	SkillLine	iRefID
5	spellCount	Integer

WIN_DUEL = 76

Column	Field	Type
4	unused	Integer
5	duelCount	Integer

HIGHEST_POWER = 96

Column	Field	Type	Notes
4	powerType	Integer	0=mana, 1=rage, 3=energy, 6=runic power

HIGHEST_STAT = 97

Column	Field	Type	Notes
4	statType	Integer	4=spirit, 3=int, 2=stamina, 1=agi, 0=strength

HIGHEST_SPELLPOWER = 98

Column	Field	Type	Notes
4	spellSchool	iRefID	SkillLine or Resistances

HIGHEST_RATING = 100

Column	Field	Type
4	ratingType	Integer

LOOT_TYPE = 109

Column	Field	Type	Notes
4	lootType	Integer	3=fishing, 2=pickpocket, 4=disentchant
5	lootTypeCount	Integer

LEARN_SKILL_LINE = 112

Column	Field	Type
4	SkillLine	iRefID
5	spellCount	Integer

EARN_HONORABLE_KILL = 113

Column	Field	Type
4	unused	Integer
5	killCount	Integer

ACCEPTED_SUMMONS = 114

Column	Field	Type
4	unused	Integer
5	Here comes a 1 in, because it's a Statistic	Integer

ACHIVEMENTPOINTS_REACHED = 115

Column	Field	Type
4	unused	Integer
5	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
4	unused	Integer
5	PlayerCount	Integer

Achievement Criteria ​

Structure ​

KILL_CREATURE = 0 ​

WIN_BG = 1 ​

REACH_LEVEL = 5 ​

REACH_SKILL_LEVEL = 7 ​

COMPLETE_ACHIEVEMENT = 8 ​

COMPLETE_QUEST_COUNT = 9 ​

COMPLETE_DAILY_QUEST_DAILY = 10 ​

COMPLETE_QUESTS_IN_ZONE = 11 ​

DAMAGE_DONE = 13 ​

COMPLETE_DAILY_QUEST = 14 ​

COMPLETE_BATTLEGROUND = 15 ​

DEATH_AT_MAP = 16 ​

DEATH_IN_DUNGEON = 18 ​

COMPLETE_RAID = 19 ​

KILLED_BY_CREATURE = 20 ​

FALL_WITHOUT_DYING = 24 ​

DEATHS_FROM = 26 ​

COMPLETE_QUEST = 27 ​

BE_SPELL_TARGET = 28 ​

BE_SPELL_TARGET2 = 69 ​

CAST_SPELL = 29 ​

CAST_SPELL2 = 110 ​

BG_OBJECTIVE_CAPTURE = 30 ​

HONORABLE_KILL_AT_AREA = 31 ​

WIN_ARENA = 32 ​

PLAY_ARENA = 33 ​

LEARN_SPELL = 34 ​

OWN_ITEM = 36 ​

WIN_RATED_ARENA = 37 ​

HIGHEST_TEAM_RATING = 38 ​

REACH_TEAM_RATING = 39 ​

LEARN_SKILL_LEVEL = 40 ​

USE_ITEM = 41 ​

LOOT_ITEM = 42 ​

EXPLORE_AREA = 43 ​

OWN_RANK = 44 ​

BUY_BANK_SLOT = 45 ​

GAIN_REPUTATION = 46 ​

GAIN_EXALTED_REPUTATION= 47 ​

VISIT_BARBER_SHOP = 48 ​

EQUIP_EPIC_ITEM = 49 ​

ROLL_NEED_ON_LOOT = 50 ​

ROLL_GREED_ON_LOOT = 51 ​

HK_CLASS = 52 ​

HK_RACE = 53 ​

DO_EMOTE = 54 ​

HEALING_DONE = 55 ​

GET_KILLING_BLOWS = 56 ​

EQUIP_ITEM = 57 ​

MONEY_FROM_QUEST_REWARD= 62 ​

LOOT_MONEY = 67 ​

USE_GAMEOBJECT = 68 ​

SPECIAL_PVP_KILL = 70 ​

FISH_IN_GAMEOBJECT = 72 ​

LEARN_SKILLLINE_SPELLS = 75 ​

WIN_DUEL = 76 ​

HIGHEST_POWER = 96 ​

HIGHEST_STAT = 97 ​

HIGHEST_SPELLPOWER = 98 ​

HIGHEST_RATING = 100 ​

LOOT_TYPE = 109 ​

LEARN_SKILL_LINE = 112 ​

EARN_HONORABLE_KILL = 113 ​

ACCEPTED_SUMMONS = 114 ​

ACHIVEMENTPOINTS_REACHED = 115 ​

RANDOM_DUNGEON_PLAYERCOUNT = 119 ​