Skip to content

spell_area Table

Defines spells that apply auras when entering a specific area, based on quests, race, gender, etc.

Schema Summary

Field Type Key Null Default Extra
spell smallint(5) unsigned PRI NO 0
area mediumint(8) unsigned PRI NO 0
quest_start mediumint(8) unsigned PRI NO 0
quest_start_active tinyint(1) unsigned PRI NO 0
quest_end mediumint(8) unsigned NO 0
aura_spell smallint(6) PRI NO 0
racemask mediumint(8) unsigned PRI NO 0
gender tinyint(1) unsigned PRI NO 2
autocast tinyint(1) unsigned NO 0

Field Breakdown

  • spell - Primary Key. Spell that applies the aura (→ spell_template.entry).
  • area - Primary Key. Zone/area ID. (see AreaTable.dbc)
  • quest_start - Primary Key. Quest that must be active (from quest_template.entry).
  • quest_start_active - Primary Key. If 1, quest must be active; if 0, quest must be complete.
  • quest_end - Quest that ends the aura (from quest_template.entry).
  • aura_spell - Primary Key. Aura requirement: positive = aura must be present, negative = aura must be absent.
  • racemask - Primary Key. Race mask.
  • gender - Primary Key. 0 male, 1 female, 2 both.
  • autocast - If 1, spell is auto-applied on entering the area; if 0, it is only allowed to be cast there.