Achievement6x

Column

Field

Type

Notes

1

ID

Integer

Achievement ID

2

Faction

Integer

-1: both, 0: Horde or 1: Alliance

3 

MapID

Integer

Only set if achievement is related to a zone, otherwise set to -1

4

Supercedes

Integer

its Achievement parent (can`t start while parent uncomplete, use its Criteria if don`t have own, use its progress on begin)

5

Title_lang

String + Loc

6

Description_lang

String + Loc

If Description is empty, it's not an Achievement but part of the statistics tab

7

Category

Integer

Category ID

8

Points

Integer

reward points

9

UIOrder

Integer

10

Flags

Integer

0-768, if it's 256 only one person per Realm can reach that achievement and if it's 768 it's only reachable for one raid per realm. Perhaps a second category?

11

IconID

Integer

icon (from SpellIcon.dbc)

12

Reward_lang

String + Loc

13

MinimumCriteria

Integer

need this count of completed criterias (own or referenced achievement criterias)

14

SharesCriteria

Integer

referenced achievement (counting of all completed criterias)

15

CriteriaTree

Integer

ID

Name

6

Level 10

7

Level 20

8

Level 30

9

Level 40

10

Level 50

11

Level 60

12

Level 70

13

Level 80

15

Plenty of Pets

16

Did Somebody Order a Knuckle Sandwich?

31

A Simple Re-Quest

32

2000 Quests Completed

33

Nothing Boring About Borean

34

I've Toured the Fjord

35

Might of Dragonblight

36

The Empire of Zul'Drak

37

Fo' Grizzle My Shizzle

38

The Summit of Storm Peaks

39

Into the Basin

40

Icecrown: The Final Goal

41

Loremaster of Northrend

42

Explore Eastern Kingdoms

43

Explore Kalimdor

44

Explore Outland

45

Explore Northrend

46

World Explorer

49

Alterac Valley victories

50

Eye of the Storm victories

51

Arathi Basin victories

52

Warsong Gulch battles

53

Alterac Valley battles

54

Eye of the Storm battles

55

Arathi Basin battles

56

Deaths in Warsong Gulch

57

Deaths in Alterac Valley

58

Deaths from Drek'Thar

59

Deaths in Arathi Basin

60

Total deaths

73

Disgracin' The Basin

94

Quests abandoned

95

Average quests completed per day

97

Daily quests completed

98

Quests completed

99

Ruins of Lordaeron matches

100

Ring of Trials victories

101

Ring of Trials matches

102

Ruins of Lordaeron victories

103

Circle of Blood matches

104

Circle of Blood victories

105

Warsong Gulch victories

107

Creatures killed

108

Critters killed

110

Lich King 5-player boss defeated the most

112

Deaths from drowning

113

Deaths from fatigue

114

Deaths from falling

115

Deaths from fire and lava

116

Professional Journeyman

121

Journeyman Cook

122

Expert Cook

123

Artisan Cook

124

Master Cook

125

Grand Master Cook

126

Journeyman Fisherman

127

Expert Fisherman

128

Artisan Fisherman

129

Master Fisherman

130

Grand Master Fisherman

131

Journeyman Medic

132

Expert Medic

133

Artisan Medic

134

Master Medic

135

Grand Master Medic

137

Stocking Up

141

Ultimate Triage

144

The Lurker Above

150

The Fishing Diplomat

153

The Old Gnome and the Sea

154

Arathi Basin Victory

155

Arathi Basin Veteran

156

Territorial Dominance

157

To The Rescue!

158

Me and the Cappin' Makin' it Happen

159

Let's Get This Done

161

Resilient Victory

162

We Had It All Along *cough*

165

Arathi Basin Perfection

166

Warsong Gulch Victory

167

Warsong Gulch Veteran

168

Warsong Gulch Perfection

178

Enchanting formulae learned

181

Items disenchanted

183

Materials produced from disenchanting

189

Largest heal cast

193

Largest hit dealt

197

Total damage done

198

Total healing done

199

Capture the Flag

200

Persistent Defender

201

Warsong Expedience

202

Quick Cap

203

Not In My House

204

Ironman

206

Supreme Defender

207

Save the Day

208

Eye of the Storm Victory

209

Eye of the Storm Veteran

211

Storm Glory

212

Storm Capper