AzerothCore
Pages :

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

Table Structure

Field Type Attributes Key Null Default Extra Comment
first_spell_id INT UNSIGNED PRI NO 0
spell_id INT UNSIGNED NO 0
rank TINYINT 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.