The `npc_spellclick_spells` table
table-no-description
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment' |
int(10) | unsigned |
| NO | NULL |
| reference to creature_template | |
int(10) | unsigned |
| NO | NULL |
| spell which should be casted | |
tinyint(3) | unsigned |
| NO | NULL |
| ||
smallint(3) | unsigned |
| NO | 0 |
| relation with summoner: 0-no 1-friendly 2-raid 3-party player can click |
Description of the fields
npc_entry
Reference to creature_template.entry
spell_id
The spell which should be cast.
cast_flags
On every spellclick event a player and a creature "participate". This field defines who casts the spell on who.
Lower bit defines caster: 1=player, 0=creature; higher bit defines target, same mapping as caster bit.
You can use that table for the actual value:
Caster | Target | cast_flags value |
|---|---|---|
Creature | Creature | 0 |
Player | Creature | 1 |
Creature | Player | 2 |
Player | Player | 3 |
user_type
Relation with summoner: defines who is able to use this spellclick.
Value | Description |
|---|---|
0 | Only self |
1 | Friendly |
2 | Raid |
3 | Party |