SpellsTable
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| id | int(8) unsigned | PRI | auto_increment | The unique ID for this spell. | ||
| name | varchar(30) | UNI | The name of the spell. | |||
| way_id | int(8) unsigned | 0 | The ID of the way of magic | |||
| realm | tinyint(3) unsigned | 0 | The level in the way the spell is. | |||
| casting_effect | varchar(255) | Name of visual/sound effect on the caster for casting spell. | ||||
| image_name | varchar(100) | |||||
| spell_description | text | The description of the spell. | ||||
| offensive | tinyint(1) | 1 | Flag (0/1) if this is an offensive spell. | |||
| max_power | float(4,2) | 1 | ||||
| target_type | int(4) | 32 | Bitmask of valid target types. | |||
| cast_duration | text | |||||
| range | text | |||||
| aoe_radius | text | |||||
| aoe_angle | text | |||||
| outcome | text | |||||
| cstr_npc_spell_category | varchar(200) | Name of spell category which is sent to npc perception system. | ||||
| npc_spell_power | float(10,3) | 0.000 | 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