Npc spellclick spells SF

Back to world database list of tables.

The `npc_spellclick_spells` table

This table has no description. You can help SFDB wiki by clicking here to describe this table, if you have permissions.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment'
npc_entry	int(10)	unsigned		NO	NULL		reference to creature_template
spell_id	int(10)	unsigned		NO	NULL		spell which should be casted
cast_flags	tinyint(3)	unsigned		NO	NULL		first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit
user_type	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