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.

Navegador incompatible