spell_area

This table is used to apply a specific spell aura to the player within an area in the game. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
spell	int	unsigned	PRI	NO	0
area	int	unsigned	PRI	NO	0
quest_start	int	unsigned	PRI	NO	0
quest_end	int	unsigned		NO	0
aura_spell	int	signed	PRI	NO	0
racemask	int	unsigned	PRI	NO	0
gender	tinyint	unsigned	PRI	NO	2
autocast	tinyint	unsigned		NO	0
quest_start_status	int	signed		NO	64
quest_end_status	int	signed		NO	11

Description of fields

spell

The Spell ID to be casted on the player.  

area

The AreaTable ID where spell should be applied.  

quest_start

The Quest ID which the player must have in the state defined by quest_start_status for the spell to apply.  

quest_end

The Quest ID which the player must not have in the state defined by quest_end_status for the spell to apply. Setting both quest_start and quest_end to the same value is useless.  

aura_spell

If set, this value (plus or minus aura Spell ID) imposes additional condition.

• aura_spell < 0: If the player has aura -aura_spell then spell will not be activated.
• aura_spell = 0: This column is ignored.
• aura_spell > 0: If the player has no aura aura_spell then spell will not be activated.  

racemask

Race mask of ChrRace IDs spell applies to. (0: any race)

Value	Flag	Name		Value	Flag	Name
1	0x0001	Human		2	0x0002	Orc
4	0x0004	Dwarf		16	0x0010	Undead
8	0x0008	Night Elf		32	0x0020	Tauren
64	0x0040	Gnome		128	0x0080	Troll
1024	0x0400	Draenei		512	0x0200	Blood Elf
1101	0x044D	Alliance		690	0x02B2	Horde

 

gender

The player gender this entry applies to.

enum Gender

ID	Name	Comment
0	GENDER_MALE	Male
1	GENDER_FEMALE	Female
2	GENDER_NONE	Any

 

autocast

The spell will be automatically applied when the character enters the area. Also prevents the user from removing it.  

quest_start_status

quest_end_status

Bitmask of different quest statuses.

enum QuestStatus

Value	Flag	Name	Comment
1	0x01	QUEST_STATUS_NONE	Player does not have or had quest at all. He could accept it, but he did not (yet).
2	0x02	QUEST_STATUS_COMPLETE	Player fulfilled objectives, but did not hand it in yet.
8	0x08	QUEST_STATUS_INCOMPLETE	Player did not fulfill objectives yet.
32	0x20	QUEST_STATUS_FAILED	Player failed to fulfill objectives for any reason, e.g. time limit.
64	0x40	QUEST_STATUS_REWARDED	Player handed quest in and this is sort of a post-quest interaction.

 

Examples

• All players are pacified on the Argent Tournament Grounds.
• Factions-specific buffs, e.g. in Icecrown Citadel: H Hellscream's Warsong / A Strength of Wrynn
• A ghost flying mount in zones where the player may be required to fly to reach his corpse.
• A permanent disguise after the player completes an attunement quest.