The `npc_spellclick_spells` table
This table holds information about spells to be cast upon receiving CMSG_SPELLCLICK.
That opcode is sent for quests in which you have to loot creatures, who are already dead at spawning. Examples are Planning for the Future and Rifle the bodies.
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 cast | |
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.
Note that for several quests there are more than one spell per click.
Planing for the Future for example has Planning for the Future: Create Snowfall Glade Pup which will create the item in the player’s inventory
and Planning for the Future: Create Snowfall Glade Pup Cover which despawns the creature.
This creates the illusion that the creature has been looted.
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 |