DB/Achievement

Achievement names and descriptions. Referenced from the criterias. This file has been added with WoW 3.0.1.8303

8905

Column	Field	Type	Notes
1	ID	Integer
2	Faction	Integer	-1: both, 0: Horde or 1: Alliance
3	Map	iRefID	Only set if achievement is related to a zone.
4	Previous	iRefID	If the Achievement belongs to a series, this is the ID of the previous one. 0 otherwise.
5	Name	Loc
22	Description	Loc	If Description is empty, it's not an Achievement but part of the statistics tab
39	Category	iRefID
40	Points	Integer	0,5,10,15,20,25,30,50
41	Unknown	Integer	0-111
42	Unknown	Integer	0-111
43	SpellIcon	iRefID	An icon to display.
44	Reward	Loc
61	Unknown	Integer
62	Unknown	Integer

9183

Column	Field	Type	Notes
1	ID	Integer
2	Faction	Integer	-1: both, 0: Horde or 1: Alliance
3	Map	iRefID	Only set if achievement is related to a zone.
4	Previous	iRefID	If the Achievement belongs to a series, this is the ID of the previous one. 0 otherwise.
8	Name	Loc
25	Description	Loc	If Description is empty, it's not an Achievement but part of the statistics tab
39	Category	iRefID
40	Points	Integer	0,5,10,15,20,25,30,50
41	OrderInGroup	Integer	0-111
42	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?
43	SpellIcon	iRefID	An icon to display.
44	Reward	Loc
61	Demands	Integer	Number of things you have to get/fulfill to get this Achievement. For example if you have to get 25 tabards, there is a 25. TrinityCore: "need this count of completed criterias (own or referenced achievement criterias)"
62	ReferencedAchievement	Integer	TrinityCore: "referenced achievement (counting of all completed criterias)"

-- Tigurus