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

 

NO

0

 

 

EffectMechanic2

tinyint(3)

unsigned

 

NO

0

 

 

EffectMechanic3

tinyint(3)

unsigned

 

NO

0

 

 

EffectImplicitTargetA1

tinyint(3)

unsigned

 

NO

0

 

 

EffectImplicitTargetA2

tinyint(3)

unsigned

 

NO

0

 

 

EffectImplicitTargetA3

tinyint(3)

unsigned

 

Comments