The `spell_area` table
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.
Some examples:
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
mediumint(8) | unsigned | PRI | NO | 0 | |||
mediumint(8) | unsigned | PRI | NO | 0 | |||
mediumint(8) | unsigned | PRI | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | ||||
mediumint(8) | signed | PRI | NO | 0 | |||
mediumint(8) | unsigned | PRI | NO | 0 | |||
tinyint(3) | unsigned | PRI | NO | 2 | |||
tinyint(3) | unsigned | NO | 3 | ||||
int(11) | unsigned | NO | 64 | ||||
int(11) | unsigned | NO | 11 |
Description of the fields
The spell ID of the spell to be casted on the player. See Spell.dbc.
The area ID. Type ".gps" in-game and find the "Area:" number to use for this cell. Also see AreaTable.dbc.
The entry of the quest which the player must have in the state defined by quest_start_status. See quest_template.id.
The entry of the quest which the player must not have in the state defined by quest_end_status. See quest_template.id. Setting both quest_start and quest_end to the same value is useless.
If set, this value (plus or minus aura spell ID from Spell.dbc) imposes additional condition.
The value has the following effect:
This ID is automatically called from ChrRaces.dbc. The bitmask is entered here.
MASTER:
0, 52430847 = All Races
33555378 (2 + 16 + 32 + 128 + 256 + 512 + 33554432) = Horde Only
18875469 (1 + 4 + 8 + 64 + 1024 + 2097152 + 16777216) = Alliance Only
3.3.5:
0, 1535 = All Races
434 (2 + 16 + 32 + 128 + 256 ) = Horde Only
1101 (1 + 4 + 8 + 64 + 1024 ) = Alliance Only
The gender type this entry applies to. 0 = Male, 1 = Female, 2 = Any.
Flag | Name | Comment | |
---|---|---|---|
1 | 0x01 | SPELL_AREA_FLAG_AUTOCAST | If the spell should be automatically applied when the character enters the area. Also prevents the user from removing it. |
2 | 0x02 | SPELL_AREA_FLAG_AUTOREMOVE | If the spell should be automatically removed when the character is inside the area (only works with quest updates) |
Note: Spell is allways removed on leaving area, SPELL_AREA_FLAG_AUTOREMOVE does not effect this.
Example:
flags = 1 : Spell is automatically applied on enter, not automatically removed on quest update, but removed on leave.
flags = 2 : Spell must be applied manually (not added on enter), automatically removed on quest update and removed on leave.
flags = 3 : (Default) Spell is automatically applied on enter, automatically removed on quest update and removed on leave.
Within quest_start_status, you can define the mask of quest status required for quest_start.
Within quest_end_status, you can define the mask of quest status required for quest_end.
Example:
Area 257 is a cavern on Teldrassil. What we want is simple : When the player take the 28725 quest, he have the aura in the cavern. When he finish the 28727 quest, the aura disappear.
You should have the spell 92237 when entering the cavern IF :
The start quest 28725 is incomplete, complete or rewarded (2 | 8 | 64 = 74)
The end quest 28727 is not taked (none), incomplete or complete BUT not rewarded (1 | 2 | 8 = 11)
Here is the SQL for this example :
INSERT INTO spell_area (spell, area, quest_start, quest_end, autocast, quest_start_status, quest_end_status) VALUES (92237, 257, 28725, 28727, 1, 74, 11);
Quest Status | Flag | Explanation |
---|---|---|
QUEST_STATUS_NONE = 0 | 1 | Player does not have or had quest at all. He could accept it, but he did not (yet). |
QUEST_STATUS_COMPLETE = 1 | 2 | Player fulfilled objectives, but did not hand it in yet. |
| 4 (NOT USED) | (Not used) |
QUEST_STATUS_INCOMPLETE = 3 | 8 | Player did not fulfill objectives yet |
| 16 (NOT USED) | (Not used) |
QUEST_STATUS_FAILED = 5 | 32 | Player failed to fulfill objectives for any reason, e.g. time limit |
QUEST_STATUS_REWARDED = 6 | 64 | Player handed quest in and this is sort of a post-quest interaction |
For a `quest_end_status` that should contain QUEST_STATUS_NONE (1), QUEST_STATUS_COMPLETE (2) and QUEST_STATUS_INCOMPLETE (8):
|