Item instancesTable
Jump to navigation
Jump to search
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. | |||
ADD | min_faction | int(10) unsigned | 0 | minimum faction score needed to buy this item from a merchant | ||
flags | varchar(200) | MUL | 0 | |||
lock_str | int(5) | 0 | ||||
lock_skill | int(2) | -1 | ||||
openable_locks | varchar(100) | 0 | ||||
item_name | varchar(100) | |||||
item_description | text | |||||
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 |