SpellsTable

field	type	foreign key	description
id	integer	N	The unique ID for this spell.
name	varchar	N	The name of the spell.
way_id	integer	Y WaysTable	The ID of the way of magic
realm	tinyint	N	The level in the way the spell is.
caster_effect	varchar	N	Name of visual/sound effect on the caster for casting spell.
target_effect	varchar	N	Name of visual/sound effect on the target for casting spell.
image_name	varchar	N
spell_description	longvarchar	N	The description of the spell.
offensive	tinyint	N	Flag (0/1) if this is an offensive spell.
progression_event	varchar	N	Script event name which is fired when the spell is cast.
saved_progression_event	varchar
saving_throw	varchar
saving_throw_value	integer
max_power	integer	N	The power level cap of this spell.
target_type	integer	N	Bitmask of valid target types.
cstr_npc_spell_category	integer		Name of spell category which is sent to npc perception system.
npc_spell_power	real	N	Relative power of spell as hint for the npc perception system.

Additional Notes

target_type

The target-type values for the bitmask are defined in src/server/client.h. At the time of writing these are:

• TARGET_NONE = 0x01
• TARGET_ITEM = 0x04
• TARGET_SELF = 0x08
• TARGET_FRIEND = 0x10
• TARGET_FOE = 0x20
• TARGET_DEAD = 0x40
• TARGET_GM = 0x80
• TARGET_PVP = 0x100