spell_item_enchantment

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
Name	text			YES	NULL
HordeName	text			YES	NULL
Duration	int	signed		NO	0
EffectArg1	int	unsigned		NO	0
EffectArg2	int	unsigned		NO	0
EffectArg3	int	unsigned		NO	0
Flags	int	signed		NO	0
EffectScalingPoints1	float			NO	0
EffectScalingPoints2	float			NO	0
EffectScalingPoints3	float			NO	0
IconFileDataID	int	unsigned		NO	0
MinItemLevel	int	signed		NO	0
MaxItemLevel	int	signed		NO	0
TransmogUseConditionID	int	unsigned		NO	0
TransmogCost	int	unsigned		NO	0
EffectPointsMin1	smallint	signed		NO	0
EffectPointsMin2	smallint	signed		NO	0
EffectPointsMin3	smallint	signed		NO	0
ItemVisual	smallint	unsigned		NO	0
RequiredSkillID	smallint	unsigned		NO	0
RequiredSkillRank	smallint	unsigned		NO	0
ItemLevel	smallint	unsigned		NO	0
Charges	tinyint	unsigned		NO	0
Effect1	tinyint	unsigned		NO	0
Effect2	tinyint	unsigned		NO	0
Effect3	tinyint	unsigned		NO	0
ScalingClass	tinyint	signed		NO	0
ScalingClassRestricted	tinyint	signed		NO	0
ConditionID	tinyint	unsigned		NO	0
MinLevel	tinyint	unsigned		NO	0
MaxLevel	tinyint	unsigned		NO	0
VerifiedBuild	int	signed	PRI	NO	0

Description of fields

ID

- no description -  

Name

- no description -  

HordeName

- no description -  

Duration

- no description -  

EffectArg1

- no description -  

EffectArg2

- no description -  

EffectArg3

- no description -  

Flags

- no description -  

EffectScalingPoints1

- no description -  

EffectScalingPoints2

- no description -  

EffectScalingPoints3

- no description -  

IconFileDataID

- no description -  

MinItemLevel

- no description -  

MaxItemLevel

- no description -  

TransmogUseConditionID

- no description -  

TransmogCost

- no description -  

EffectPointsMin1

- no description -  

EffectPointsMin2

- no description -  

EffectPointsMin3

- no description -  

ItemVisual

- no description -  

RequiredSkillID

- no description -  

RequiredSkillRank

- no description -  

ItemLevel

- no description -  

Charges

- no description -  

Effect1

- no description -  

Effect2

- no description -  

Effect3

- no description -  

ScalingClass

- no description -  

ScalingClassRestricted

- no description -  

ConditionID

- no description -  

MinLevel

- no description -  

MaxLevel

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