SpellsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
VisualWikitext
Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer | N | The unique ID for this spell. |- | name | varchar | N | The name of the spell. |- | way_id |…'
 
Grimston (talk | contribs)
156 edits
mNo edit summary
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{| border="1"
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(8) unsigned
! description
|PRI
|
|auto_increment
|The unique ID for this spell. 
|-
|-
| id
|
| integer
|name
| N
|varchar(30)
| The unique ID for this spell.   
|UNI
|
|
|The name of the spell.   
|-
|-
| name
|
| varchar
|way_id
| N
|int(8) unsigned
| The name of the spell.
|
|0
|
|The ID of the way of magic 
|-
|-
| way_id
|
| integer
|realm
| Y [[WaysTable]]
|tinyint(3) unsigned
| The ID of the way of magic
|
|0
|
|The level in the way the spell is.
|-
|-
| realm
|
| tinyint
|casting_effect
| N
|varchar(255)
| The level in the way the spell is.  
|
|
|
|Name of visual/sound effect on the caster for casting spell.
|-
|-
| caster_effect
|
| varchar
|image_name
| N
|varchar(100)
| Name of visual/sound effect on the caster for casting spell.
|
|
|
|  
|-
|-
| target_effect
|
| varchar
|spell_description
| N
|text
| Name of visual/sound effect on the target for casting spell.
|
|
|
|The description of the spell.  
|-
|-
| image_name
|
| varchar
|offensive
| N
|tinyint(1)
|  
|
|1
|
|Flag (0/1) if this is an offensive spell. 
|-
|-
| spell_description
|
| longvarchar
|max_power
| N
|float(4,2)
| The description of the spell.
|
|1
|
|
|-
|-
| offensive
|
| tinyint
|target_type
| N
|int(4)
| Flag (0/1) if this is an offensive spell.
|
|32
|
|Bitmask of valid target types.
|-
|-
| progression_event
|
| varchar
|cast_duration
| N
|text
| Script event name which is fired when the spell is cast.
|
|
|
|  
|-
|-
| saved_progression_event
|
| varchar
|range
|text
|
|
|
|  
|  
|-
|
|aoe_radius
|text
|
|
|
|  
|  
|-
|-
| saving_throw
|
| varchar
|aoe_angle
|  
|text
|
|
|
|  
|  
|-
|-
| saving_throw_value
|
| integer
|outcome
|  
|text
|
|
|
|  
|  
|-
|-
| max_power
|
| integer
|cstr_npc_spell_category
| N
|varchar(200)
| The power level cap of this spell.
|
|-
|
| target_type
|
| integer
|Name of spell category which is sent to npc perception system.  
| 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
|npc_spell_power
| N
|float(10,3)
| Relative power of spell as hint for the npc perception system.
|
|0.000
|
|Relative power of spell as hint for the npc perception system.  
|}
|}


== Additional Notes ==
== Additional Notes ==
Line 106: Line 159:
* TARGET_GM = 0x80
* TARGET_GM = 0x80
* TARGET_PVP = 0x100
* TARGET_PVP = 0x100
[[Category:Engine documents]]

Latest revision as of 15:12, 11 January 2022

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
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php?title=SpellsTable&oldid=24366"