spell_area

Description of the 'spell_area' table for MaNGOSThree

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

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

spell mediumint(8) unsigned

Spell ID, see Spell.dbc. The spell is either casted on the character or is allowed the character to cast.

area mediumint(8) unsigned

Area ID, see AreaTable.dbc. If equals to 0, is not limited to any zone.

quest_start mediumint(8) unsigned

Quest ID [See quest_template.entry] that should be either active or rewarded.

quest_start_active tinyint(1) unsigned

If set, this flag allows the quest mentioned in the quest_start field to be rewarded, not only be active.

quest_end mediumint(8) unsigned

Quest ID [See quest_template.entry] of the quest that should not be rewarded.

condition_id mediumint(8) unsigned

Condition ID [See conditions.condition_entry] of teh condition which should be fulfilled.

aura_spell mediumint(8)

Spell ID [See Spell.dbc] of the aura spell which the character should already have applied (if positive) or do not have (if negative).

racemask mediumint(8) unsigned

Race mask value. The entries may be combined by simple adding.

gender tinyint(1) unsigned

The gender of characters to which the spell is applied. The following table list available values.

Gender of the creature

autocast tinyint(1) unsigned

If set, this flag requires the spell to be catsed on the character just entered the area. In other case, the spell is enabled for the character to be casted.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module