Spell_area - cmangos/issues GitHub Wiki

Back to world database list of tables.

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

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

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

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

Reference to quest_template.. This quest must be available or active and must not be completed. Exact behaviour depends on 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.

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

Reference to conditions..

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

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

Only this gender is target of the spell.

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

Boolean value.