Spell area tc2

Back to world database list of tables.

The `spell_area` table

This table is used to apply a specific spell aura to any area in the game. When any players enter this area, this aura will be buffed on those players.

Some examples:

• Pacify all players (spell 39331)
• Heal to full every 1 second (spell 48591)
• Teleport player out of an area (spell 53141)

Be careful, some areas are zone-wide, such as area 440 - Tanaris.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
spell	mediumint(8)	unsigned	PRI	NO	0
area	mediumint(8)	unsigned	PRI	NO	0
quest_start	mediumint(8)	unsigned	PRI	NO	0
quest_start_active	tinyint(1)	unsigned	PRI	NO	0
quest_end	mediumint(8)	unsigned		NO	0
aura_spell	mediumint(8)	signed	PRI	NO	0
racemask	mediumint(8)	unsigned	PRI	NO	0
gender	tinyint(1)	unsigned	PRI	NO	2
autocast	tinyint(1)	unsigned		NO	0

Description of the fields

spell

The spell ID. See Spell.dbc.

area

The area ID. Type ".gps" in-game and find the "Area:" number to use for this cell. Also see AreaTable.dbc.

quest_start

The quest entry which must be available or active and must not have been completed. See quest_template.id.

quest_start_active

If this value is true then quest start can be active (not only rewarded).

quest_end

The quest entry which must not have been completed. See quest_template.entry.

aura_spell

The ID of the spell comes from Spell.dbc

Player must have this aura_spell to activate the spell above.

Negative values stand for "must not have aura_spell to activate spell".

racemask

ChrRaces.dbc

0, 1791 = All Races

690 (2 + 16 + 32 + 128 + 512) = Horde Only

1101 (1 + 4 + 8 + 64 + 1024) = Alliance Only

gender

The gender type this entry applies to. 0 = Male, 1 = Female, 2 = All.

autocast

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