Back to 'spawn_group_template' Return to world Go to 'spell_custom_attr'
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 | bigint | unsigned | PRI | NO | 0 | ||
gender | tinyint | unsigned | PRI | NO | 2 | ||
flags | tinyint | unsigned | NO | 3 | |||
quest_start_status | int | signed | NO | 64 | |||
quest_end_status | int | signed | NO | 11 |
The spell ID of the spell to be casted on the player. See SpellName.db2).
The area ID. Type ".gps" in-game and find the "Area:" number to use for this cell. Also see AreaTable.db2.
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 SpellName.db2) imposes additional condition.
The value has the following effect:
< 0 (negative values) If the player has aura -aura_spell then the spell will not be activated.
0 this column is ignored.
> 0 (positive values) If the player has no aura aura_spell then the spell will not be activated.
Calculate using table below. (ordered by Race ID)
Race | Mask |
---|---|
RACE_HUMAN | 0x1 |
RACE_ORC | 0x2 |
RACE_DWARF | 0x4 |
RACE_NIGHTELF | 0x8 |
RACE_UNDEAD_PLAYER | 0x10 |
RACE_TAUREN | 0x20 |
RACE_GNOME | 0x40 |
RACE_TROLL | 0x80 |
RACE_GOBLIN | 0x100 |
RACE_BLOODELF | 0x200 |
RACE_DRAENEI | 0x400 |
RACE_WORGEN | 0x200000 |
RACE_PANDAREN_NEUTRAL | 0x800000 |
RACE_PANDAREN_ALLIANCE | 0x1000000 |
RACE_PANDAREN_HORDE | 0x2000000 |
RACE_NIGHTBORNE | 0x4000000 |
RACE_HIGHMOUNTAIN_TAUREN | 0x8000000 |
RACE_VOID_ELF | 0x10000000 |
RACE_LIGHTFORGED_DRAENEI | 0x20000000 |
RACE_ZANDALARI_TROLL | 0x40000000 |
RACE_KUL_TIRAN | 0x80000000 |
RACE_DARK_IRON_DWARF | 0x800 |
RACE_VULPERA | 0x1000 |
RACE_MAGHAR_ORC | 0x2000 |
RACE_MECHAGNOME | 0x4000 |
RACE_DRACTHYR_ALLIANCE | 0x10000 |
RACE_DRACTHYR_HORDE | 0x8000 |
Precalculated | Mask |
---|---|
RACEMASK_ALLIANCE | 0xB1214C4D |
RACEMASK_HORDE | 0x4E00B3B2 |
RACEMASK_ALL_PLAYABLE | 0xFFA1FFFF |
The gender type this entry applies to. 0 = Male, 1 = Female, 2 = Any.
Flag | Flag (hex) | 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) |
Quest Status | Flags | Explanation |
---|---|---|
QUEST_STATUS_NONE | 1 | Player does not have or had quest at all. He could accept it, but he did not (yet). |
QUEST_STATUS_COMPLETE | 2 | Player fulfilled objectives, but did not hand it in yet. |
QUEST_STATUS_UNAVAILABLE | 4 | (not used) |
QUEST_STATUS_INCOMPLETE | 8 | Player did not fulfill objectives yet |
QUEST_STATUS_AVAILABLE | 16 | (not used) |
QUEST_STATUS_FAILED | 32 | Player failed to fulfill objectives for any reason, e.g. time limit |
QUEST_STATUS_REWARDED | 64 | Player handed quest in and this is sort of a post-quest interaction |
Back to 'spawn_group_template' Return to world Go to 'spell_custom_attr'