AzerothCore
Posts (Latest 10 updated) :
Read all

spell_ranks

<-Back-to:World

The `spell_ranks` table

Table used by the core to group different ranks of spells (the gray text seen on ranked spells) into one "spell stem". This partly involves checks for aura stacking (e.g. different levels of the same spell). One spell can not be linked to multiple rank chains (they are "unique").

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

first_spell_id

int(10)

unsigned

PRI

NO

0

 

 

spell_id

int(10)

unsigned

 

NO

0

 

 

rank

tinyint(3)

unsigned

PRI

NO

0

 

 

Description of the fields

first_spell_id

SpellId from Spell.dbc which is first rank of spell rank chain. It identifies the whole chain.

spell_id

SpellId from Spell.dbc.

rank

An integer which ranks the spell within the chain of spell ranks for the given `spell_id`. It can differ from the rank text in game (for example, some ranks in client start with level 0, while the server always starts from level 1 onward). Several conditions have to be fulfilled:

  • At least two levels are required
  • There can be no jumps between ranks (e.g. one spell being level 3 and one being level 5 while level 4 is missing altogether)
  • There can be no duplicates in ranks.