Item instancesTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
Magodra (talk | contribs)
863 edits
No edit summary
Grimston (talk | contribs)
156 edits
No edit summary
Line 1: Line 1:
{| border=1
 
 
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(10) unsigned
! description
|PRI
|
|auto_increment
|
|-
|-
| id
|
| int(10) unsigned
|char_id_owner
|int(10) unsigned
|MUL
|0
|
|Key into the CharactersTable for the owner of this item. 
|-
|
|char_id_guardian
|int(10) unsigned
|
|0
|
|Key into the CharactersTable for the guardian of this item. 
|-
|
|parent_item_id
|int(10) unsigned
|
|0
|
|  
|  
|-
|
|
|location_in_parent
|smallint(4)
|MUL
|0
|
|
|-
|-
| char_id_owner
|
| int(10) unsigned
|stack_count
| Y
|int(10) unsigned
| Key into the [[CharactersTable]] for the owner of this item.
|
|0
|
|
|-
|-
| char_id_guardian
|
| int(10) unsigned
|creator_mark_id
| Y
|int(10) unsigned
| Key into the [[CharactersTable]] for the guardian of this item.
|
|0
|
|Key into the CharactersTable for the creator of this item if crafted.  
|-
|
|guild_mark_id
|int(10) unsigned
|
|0
|
|
|-
|-
| parent_item_id
| int(10) unsigned
| Y
|
|
|loc_instance
|int(11) unsigned
|
|0
|
|
|-
|-
| location_in_parent
| smallint(4)
|
|
|loc_sector_id
|smallint(4) unsigned
|
|0
|
|
|
|-
|-
| stack_count
| int(10) unsigned
|
|
|loc_x
|float(14,6)
|
|
|0.000000
|
|
|-
|-
| creator_mark_id
|
| int(10) unsigned
|loc_y
| Y
|float(14,6)
| Key into the [[CharactersTable]] for the creator of this item if craftet.
|
|0.000000
|
|
|-
|-
| guild_mark_id
| int(10) unsigned
| Y
|
|
|loc_z
|float(14,6)
|
|0.000000
|
|
|-
|-
| loc_instance
| int(11) unsigned
|
|
|loc_xrot
|float(14,6)
|
|
|0.000000
|
|
|-
|-
| loc_sector_id
| smallint(4) unsigned
| Y
|
|
|loc_yrot
|float(14,6)
|
|0.000000
|
|
|-
|-
| loc_x
| float(14,6)
|
|
|loc_zrot
|float(14,6)
|
|
|0.000000
|
|
|-
|-
| loc_y
| float(14,6)
|
|
|decay_resistance
|float(3,2)
|
|
|0.00
|
|
|-
|-
| loc_z
| float(14,6)
|
|
|item_quality
|float(5,2)
|
|
|50.00
|
|
|-
|-
| loc_yrot
|
| float(14,6)
|crafted_quality
|float(5,2)
|
|50.00
|
|  
|  
|-
|
|item_stats_id_standard
|int(10) unsigned
|
|
|0
|
|Key into the ItemStatsTable for the standard version of this item.
|-
|-
| decay_resistance
| float(3,2)
|
|
|item_stats_id_unique
|int(10) unsigned
|
|
|0
|
|Key into the ItemStatsTable for unique versions of this item. 
|-
|-
| item_quality
| float(5,2)
|
|
|flags
|varchar(200)
|MUL
|0
|
|
|
|-
|-
| crafted_quality
| float(5,2)
|
|
|lock_str
|int(5)
|
|
|0
|
|
|-
|-
| item_stats_id_standard
|
| int(10) unsigned
|lock_skill
| Y
|int(2)
| Key into the [[ItemStatsTable]] for the standard version of this item.
|
| -1
|
|
|-
|-
| item_stats_id_unique
|
| int(10) unsigned
|openable_locks
| Y
|varchar(100)
| Key into the [[ItemStatsTable]] for unique versions of this item.
|
|0
|
|
|-
|-
| flags
|
| varchar(200)
|item_name
|varchar(100)
|
|
|
|
|
|
|-
|-
| lock_str
|DIF
| int(5)
|item_description
|text
|
|
|
|
|
|  Type used to be 'varchar(255)' in PSLegacy. Default used to be '' in PSLegacy.
|-
|-
| lock_skill
|
| int(2)
|creative_definition
|text
|
|
|
|
|
|This is used for books/sketch.
|-
|-
| openable_locks
| varchar(100)
|
|
|charges
|int(3)
|
|0
|
|
|
|-
|-
| item_name
| varchar(100)
|
|
|prefix
|int(10) unsigned
|
|
|0
|
|Determines the prefix to be used from the loot modifiers table
|-
|-
| item_description
| varchar(255)
|
|
|suffix
|int(10) unsigned
|
|
|0
|
|Determines the suffix to be used from the loot modifiers table
|-
|-
| charges
| int(3)
|
|
|adjective
|int(10) unsigned
|
|0
|
|
|Determines the adjective to be used from the loot modifiers table
|}
|}




[[Category:Engine documents]]
[[Category:Engine documents]]

Revision as of 12:25, 11 January 2022


UE Field Type Key Type Default Extra Description
id int(10) unsigned PRI auto_increment
char_id_owner int(10) unsigned MUL 0 Key into the CharactersTable for the owner of this item.
char_id_guardian int(10) unsigned 0 Key into the CharactersTable for the guardian of this item.
parent_item_id int(10) unsigned 0
location_in_parent smallint(4) MUL 0
stack_count int(10) unsigned 0
creator_mark_id int(10) unsigned 0 Key into the CharactersTable for the creator of this item if crafted.
guild_mark_id int(10) unsigned 0
loc_instance int(11) unsigned 0
loc_sector_id smallint(4) unsigned 0
loc_x float(14,6) 0.000000
loc_y float(14,6) 0.000000
loc_z float(14,6) 0.000000
loc_xrot float(14,6) 0.000000
loc_yrot float(14,6) 0.000000
loc_zrot float(14,6) 0.000000
decay_resistance float(3,2) 0.00
item_quality float(5,2) 50.00
crafted_quality float(5,2) 50.00
item_stats_id_standard int(10) unsigned 0 Key into the ItemStatsTable for the standard version of this item.
item_stats_id_unique int(10) unsigned 0 Key into the ItemStatsTable for unique versions of this item.
flags varchar(200) MUL 0
lock_str int(5) 0
lock_skill int(2) -1
openable_locks varchar(100) 0
item_name varchar(100)
DIF item_description text Type used to be 'varchar(255)' in PSLegacy. Default used to be in PSLegacy.
creative_definition text This is used for books/sketch.
charges int(3) 0
prefix int(10) unsigned 0 Determines the prefix to be used from the loot modifiers table
suffix int(10) unsigned 0 Determines the suffix to be used from the loot modifiers table
adjective int(10) unsigned 0 Determines the adjective to be used from the loot modifiers table
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php?title=Item_instancesTable&oldid=24260"