npc_spellclick_spells

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
npc_entry	int	unsigned	PRI	NO			reference to creature_template
spell_id	int	unsigned	PRI	NO			spell which should be casted
cast_flags	tinyint	unsigned		NO			first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit
user_type	smallint	unsigned		NO	0		relation with summoner: 0-no 1-friendly 2-raid 3-party player can click

Description of 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=Clicker, 0=Clickee; higher bit defines target, same mapping as caster bit. You can use that table for the actual value:

Caster	Target	Value
Clickee	Clickee	0
Clicker	Clickee	1
Clickee	Clicker	2
Clicker	Clicker	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