spell_dbc

spell_dbc

Back-to:World

The `spell_dbc` table

This table contains data regarding serverside spells which are not to be found in Client DBC files.

Note: Not longer used since Warlords of Draenor Expansion (see Hotfixes)

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Id

int(10)

unsigned

PRI

NO

NULL





Dispel

tinyint(3)

unsigned



NO

0





Mechanic

tinyint(3)

unsigned



NO

0





Attributes

int(10)

unsigned



NO

0





AttributesEx

int(10)

unsigned



NO

0





AttributesEx2

int(10)

unsigned



NO

0





AttributesEx3

int(10)

unsigned



NO

0





AttributesEx4

int(10)

unsigned



NO

0





AttributesEx5

int(10)

unsigned



NO

0





Stances

int(10)

unsigned



NO

0





StancesNot

int(10)

unsigned



NO

0





Targets

int(10)

unsigned



NO

0





CastingTimeIndex

tinyint(3)

unsigned



NO

1





AuraInterruptFlags

int(10)

unsigned



NO

0





ProcFlags

int(10)

unsigned



NO

0





ProcChance

tinyint(3)

unsigned



NO

0





ProcCharges

tinyint(3)

unsigned



NO

0





MaxLevel

tinyint(3)

unsigned



NO

0





BaseLevel

tinyint(3)

unsigned



NO

0





SpellLevel

tinyint(3)

unsigned



NO

0





DurationIndex

smallint(5)

unsigned



NO

0





RangeIndex

tinyint(3)

unsigned



NO

1





StackAmount

tinyint(3)

unsigned



NO

0





EquippedItemClass

int(11)

signed



NO

-1





EquippedItemSubClassMask

int(11)

signed



NO

0





EquippedItemInventoryTypeMask

int(11)

signed



NO

0





Effect1

tinyint(3)

unsigned



NO

0





Effect2

tinyint(3)

unsigned



NO

0





Effect3

tinyint(3)

unsigned



NO

0





EffectDieSides1

int(11)

signed



NO

0





EffectDieSides2

int(11)

signed



NO

0





EffectDieSides3

int(11)

signed



NO

0





EffectRealPointsPerLevel1

float

signed



NO

0





EffectRealPointsPerLevel2

float

signed



NO

0





EffectRealPointsPerLevel3

float

signed



NO

0





EffectBasePoints1

int(11)

signed



NO

0





EffectBasePoints2

int(11)

signed



NO

0





EffectBasePoints3

int(11)

signed



NO

0





EffectMechanic1

tinyint(3)

unsigned