Skip to content
Schmoozerd edited this page Apr 14, 2013 · 2 revisions

Back to world database list of tables.

The `spell_area` table

This table holds information on what spells are applied to npcs/players in some areas.

Structure

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

Description of the fields

spell

The spell ID that will be castet. Reference to Spell.dbc..

area

Reference to AreaTable.dbc.. Player must be in this area.

quest_start

Reference to quest_template.. This quest must be available or active and must not be completed. Exact behaviour depends on quest_start_active.

quest_start_active

Boolean value. If set to 0 the quest quest_start must be available and not activ. If set to 1 the quest quest_start must be available or active in players’ log.

quest_end

Reference to quest_template.. This quest must not be completed.

aura_spell

Reference to Spell.dbc.. Player must have this aura to activate the spell. Negativ values stand for "not has aura" requirement.

racemask

Only these races are target of the spell.

Race

These values are 2^ID taken from ChrRaces.dbc

Examples

0,1791 = All Races

(2 + 16 + 32 + 128 + 512) = 690 = only Horde

(1 + 4 + 8 + 64 + 1024) = 1101 = only Alliance

gender

Only this gender is target of the spell.

  • 0: Male
  • 1: Female
  • 2: Both

autocast

Boolean value.

Clone this wiki locally