currency_types

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
Name	text			YES	NULL
Description	text			YES	NULL
CategoryID	int	signed		NO	0
InventoryIconFileID	int	signed		NO	0
SpellWeight	int	unsigned		NO	0
SpellCategory	tinyint	unsigned		NO	0
MaxQty	int	unsigned		NO	0
MaxEarnablePerWeek	int	unsigned		NO	0
Quality	tinyint	signed		NO	0
FactionID	int	signed		NO	0
ItemGroupSoundsID	int	signed		NO	0
XpQuestDifficulty	int	signed		NO	0
AwardConditionID	int	signed		NO	0
MaxQtyWorldStateID	int	signed		NO	0
RechargingAmountPerCycle	int	unsigned		NO	0
RechargingCycleDurationMS	int	unsigned		NO	0
AccountTransferPercentage	float			NO	0
Flags1	int	signed		NO	0
Flags2	int	signed		NO	0
VerifiedBuild	int	signed	PRI	NO	0

 

Description of fields

ID

- no description -
 

Name

- no description -
 

Description

- no description -
 

CategoryID

- no description -
 

InventoryIconFileID

- no description -
 

SpellWeight

- no description -
 

SpellCategory

- no description -
 

MaxQty

- no description -
 

MaxEarnablePerWeek

- no description -
 

Quality

- no description -
 

FactionID

- no description -
 

ItemGroupSoundsID

- no description -
 

XpQuestDifficulty

- no description -
 

AwardConditionID

- no description -
 

MaxQtyWorldStateID

- no description -
 

RechargingAmountPerCycle

- no description -
 

RechargingCycleDurationMS

- no description -
 

AccountTransferPercentage

- no description -
 

Flags1

- no description -
 

Flags2

- no description -
 

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.