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
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
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
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
|
… 