“spell_area” table¶
The spell_area table holds information on spells applied to
creatures and characters in specific areas under given conditions.
Table 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) 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 |
Fields¶
area¶
An areatrigger identifier. The value has to match with a areatrigger identifier defined in AreaTrigger.dbc.
quest_start¶
This references the “quest_template” table tables unique
ID for which the entry is valid. The quest entry listed here has to be
available to a character or needs to be active for a character. Depends
on the value of quest_start_active.
quest_start_active¶
If set to 0, the quest listed in quest_start has to be available
to a character but not active on the character. If set to 1, the
quest listed in quest_start can be available or active on the
character.
quest_end¶
This references the “quest_template” table tables unique ID for which the entry is valid. The quest listed here must not be completed to apply the spell.
condition_id¶
This references the “conditions” table tables unique ID for which the entry is valid.
aura_spell¶
The aura spell identifier. The value has to match with a spell identifier defined in Spell.dbc. If set to a with a positive value, characters must have this aura to activate the spell, if set to the spell identifier with a negative sign, characters must not have the aura.
racemask¶
A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.
gender¶
The gender of characters to which the spell is applied. The following table list available values.
Gender of the creature
| Value | Gender |
|---|---|
| 0 | Male |
| 1 | Female |
| 2 | Both |
autocast¶
Set to 1 to autocast the spell.