spell_effect

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
EffectAura	smallint	signed		NO	0
DifficultyID	int	signed		NO	0
EffectIndex	int	signed		NO	0
Effect	int	unsigned		NO	0
EffectAmplitude	float			NO	0
EffectAttributes	int	signed		NO	0
EffectAuraPeriod	int	signed		NO	0
EffectBonusCoefficient	float			NO	0
EffectChainAmplitude	float			NO	0
EffectChainTargets	int	signed		NO	0
EffectItemType	int	signed		NO	0
EffectMechanic	int	signed		NO	0
EffectPointsPerResource	float			NO	0
EffectPosFacing	float			NO	0
EffectRealPointsPerLevel	float			NO	0
EffectTriggerSpell	int	signed		NO	0
BonusCoefficientFromAP	float			NO	0
PvpMultiplier	float			NO	0
Coefficient	float			NO	0
Variance	float			NO	0
ResourceCoefficient	float			NO	0
GroupSizeBasePointsCoefficient	float			NO	0
EffectBasePoints	float			NO	0
ScalingClass	int	signed		NO	0
EffectMiscValue1	int	signed		NO	0
EffectMiscValue2	int	signed		NO	0
EffectRadiusIndex1	int	unsigned		NO	0
EffectRadiusIndex2	int	unsigned		NO	0
EffectSpellClassMask1	int	signed		NO	0
EffectSpellClassMask2	int	signed		NO	0
EffectSpellClassMask3	int	signed		NO	0
EffectSpellClassMask4	int	signed		NO	0
ImplicitTarget1	smallint	signed		NO	0
ImplicitTarget2	smallint	signed		NO	0
SpellID	int	unsigned		NO	0
VerifiedBuild	int	signed	PRI	NO	0

Description of fields

ID

- no description -  

EffectAura

- no description -  

DifficultyID

- no description -  

EffectIndex

- no description -  

Effect

- no description -  

EffectAmplitude

- no description -  

EffectAttributes

- no description -  

EffectAuraPeriod

- no description -  

EffectBonusCoefficient

- no description -  

EffectChainAmplitude

- no description -  

EffectChainTargets

- no description -  

EffectItemType

- no description -  

EffectMechanic

- no description -  

EffectPointsPerResource

- no description -  

EffectPosFacing

- no description -  

EffectRealPointsPerLevel

- no description -  

EffectTriggerSpell

- no description -  

BonusCoefficientFromAP

- no description -  

PvpMultiplier

- no description -  

Coefficient

- no description -  

Variance

- no description -  

ResourceCoefficient

- no description -  

GroupSizeBasePointsCoefficient

- no description -  

EffectBasePoints

- no description -  

ScalingClass

- no description -  

EffectMiscValue1

- no description -  

EffectMiscValue2

- no description -  

EffectRadiusIndex1

- no description -  

EffectRadiusIndex2

- no description -  

EffectSpellClassMask1

- no description -  

EffectSpellClassMask2

- no description -  

EffectSpellClassMask3

- no description -  

EffectSpellClassMask4

- no description -  

ImplicitTarget1

- no description -  

ImplicitTarget2

- no description -  

SpellID

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