spell_misc

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
Attributes1	int	signed		NO	0
Attributes2	int	signed		NO	0
Attributes3	int	signed		NO	0
Attributes4	int	signed		NO	0
Attributes5	int	signed		NO	0
Attributes6	int	signed		NO	0
Attributes7	int	signed		NO	0
Attributes8	int	signed		NO	0
Attributes9	int	signed		NO	0
Attributes10	int	signed		NO	0
Attributes11	int	signed		NO	0
Attributes12	int	signed		NO	0
Attributes13	int	signed		NO	0
Attributes14	int	signed		NO	0
Attributes15	int	signed		NO	0
DifficultyID	tinyint	unsigned		NO	0
CastingTimeIndex	smallint	unsigned		NO	0
DurationIndex	smallint	unsigned		NO	0
PvPDurationIndex	smallint	unsigned		NO	0
RangeIndex	smallint	unsigned		NO	0
SchoolMask	tinyint	unsigned		NO	0
Speed	float			NO	0
LaunchDelay	float			NO	0
MinDuration	float			NO	0
SpellIconFileDataID	int	signed		NO	0
ActiveIconFileDataID	int	signed		NO	0
ContentTuningID	int	signed		NO	0
ShowFutureSpellPlayerConditionID	int	signed		NO	0
SpellVisualScript	int	signed		NO	0
ActiveSpellVisualScript	int	signed		NO	0
SpellID	int	unsigned		NO	0
VerifiedBuild	int	signed	PRI	NO	0

Description of fields

ID

- no description -  

Attributes1

- no description -  

Attributes2

- no description -  

Attributes3

- no description -  

Attributes4

- no description -  

Attributes5

- no description -  

Attributes6

- no description -  

Attributes7

- no description -  

Attributes8

- no description -  

Attributes9

- no description -  

Attributes10

- no description -  

Attributes11

- no description -  

Attributes12

- no description -  

Attributes13

- no description -  

Attributes14

- no description -  

Attributes15

- no description -  

DifficultyID

- no description -  

CastingTimeIndex

- no description -  

DurationIndex

- no description -  

PvPDurationIndex

- no description -  

RangeIndex

- no description -  

SchoolMask

- no description -  

Speed

- no description -  

LaunchDelay

- no description -  

MinDuration

- no description -  

SpellIconFileDataID

- no description -  

ActiveIconFileDataID

- no description -  

ContentTuningID

- no description -  

ShowFutureSpellPlayerConditionID

- no description -  

SpellVisualScript

- no description -  

ActiveSpellVisualScript

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