Spell_area

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
condition_id	mediumint(8)	NO	PRI	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.

condition_id

Reference to conditions..

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 CharRaces.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.