Natural resourcesTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
Created page with " {| border="1" ! field ! type ! foreign key ! description |- | id | int(10) | | |- | lod_sector_id | int(10) | | |- | loc_x | double(10,2) | | x coord of center |- | loc_y | d..."
 
No edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{| class="wikitable"
{| border="1"
|+
! field
!UE
! type
!Field
! foreign key
!Type
! description
!Key Type
!Default
!Extra
!Description
|-
|-
| id
| int(10)
|
|
|id
|int(10) unsigned
|PRI
|
|
|auto_increment
|
|-
|-
| lod_sector_id
| int(10)
|
|
|loc_sector_id
|int(10) unsigned
|
|
|0
|
|
|-
|
|loc_x
|float(10,2)
|
|0.00
|
|x coord of center
|-
|
|loc_y
|float(10,2)
|
|0.00
|
|y coord of center
|-
|
|loc_z
|float(10,2)
|
|0.00
|
|z coord of center
|-
|-
| loc_x
| double(10,2)
|
|
| x coord of center
|radius
|float(10,2)
|
|0.00
|
|radius of the resource
|-
|-
| loc_y
| double(10,2)
|
|
| y coord of center
|visible_radius
|float(10,2)
|
|0.00
|
|allow harvesting but with no result
|-
|-
| loc_z
| double(10,2)
|
|
| z coord of center
|probability
|float(10,6)
|
|0.000000
|
|chance of finding an item by harvesting
|-
|-
| radius
| double(10,2)
|
|
| radius of the resource in centimeters
|skill
|smallint(4) unsigned
|
|0
|
|skill ID used to harvest
|-
|-
| visible_radius
| double(10,2)
|
|
| allow harvesting but with no result
|skill_level
|int(3) unsigned
|
|0
|
|skill rank required to harvest
|-
|-
| probability
| double(10,6)
|
|
| chance of finding an item by harvesting
|item_cat_id
|int(8) unsigned
|
|0
|
|item category required for harvesting  
|-
|-
| skill
| smallint(4)
|
|
| skill ID used to harvest
|item_quality
|float(10,6)
|
|0.000000
|
|min tool quality required
|-
|-
| skill_level
| int(3)
|
|
| skill rank required to harvest
|animation
|varchar(30)
|
|
|
|animation played while harvesting
|-
|-
| item_cat_id
| int(8)
|
|
| item category required for harvesting
|anim_duration_seconds
|int(10) unsigned
|
|0
|
|animation duration
|-
|-
| item_quality
| float(10,6)
|
|
| ???
|item_id_reward
|int(10) unsigned
|
|0
|
|item given to player when successful
|-
|-
| animation
| varchar(30)
|
|
| animation played while harvesting
|reward_nickname
|varchar(30)
|
|0
|
|name of the item given as used in commands and maps
|-
|-
| anim_duration_seconds
| int(10)
|
|
| animation duration
|action
|varchar(45)
|
|
|
|command needed to harvest: dig/harvest/fish
|-
|-
| item_id_reward
| int(10)
|
|
| item given to player when successful
|amount
|int(10) unsigned
|
|
|
|if not null, items will be spawned as hunt_location
|-
|-
| reward_nickname
| varchar(30)
|
|
| name of the item given as used in commands and maps
|interval
|int(11)
|
|0
|
|if amount not null, msec interval for spawning item when picked up
|-
|-
| action
| varchar(45)
|
|
| command needed to harvest: dig/harvest/fish
|max_random
|int(11)
|
|0
|
|Maximum random interval modifier in msecs
|-
|-
| amount
|UEADD
| int(10)
|trace_mesh
|varchar(100)
|
|
| if not null, items will be spawned as hunt_location
|
|
|specify which foliage mesh is recognized by line trace
|-
|-
| interval
|UEADD
| int(11)
|spawn_mesh
|varchar(100)
|
|
|
|
| if amount not null, msec interval for spawning item when picked up
|specify which static mesh to spawn
|-
|-
| max_random
|UEADD
| int(11)
|item_group
|int
|
|
|
|
| Maximum random interval modifier in msecs
|Used when we have multiple items associated to this resource. points to group_id in natural_resource_items
|}
|}


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

Latest revision as of 15:48, 18 January 2025

UE Field Type Key Type Default Extra Description
id int(10) unsigned PRI auto_increment
loc_sector_id int(10) unsigned 0
loc_x float(10,2) 0.00 x coord of center
loc_y float(10,2) 0.00 y coord of center
loc_z float(10,2) 0.00 z coord of center
radius float(10,2) 0.00 radius of the resource
visible_radius float(10,2) 0.00 allow harvesting but with no result
probability float(10,6) 0.000000 chance of finding an item by harvesting
skill smallint(4) unsigned 0 skill ID used to harvest
skill_level int(3) unsigned 0 skill rank required to harvest
item_cat_id int(8) unsigned 0 item category required for harvesting
item_quality float(10,6) 0.000000 min tool quality required
animation varchar(30) animation played while harvesting
anim_duration_seconds int(10) unsigned 0 animation duration
item_id_reward int(10) unsigned 0 item given to player when successful
reward_nickname varchar(30) 0 name of the item given as used in commands and maps
action varchar(45) command needed to harvest: dig/harvest/fish
amount int(10) unsigned if not null, items will be spawned as hunt_location
interval int(11) 0 if amount not null, msec interval for spawning item when picked up
max_random int(11) 0 Maximum random interval modifier in msecs
UEADD trace_mesh varchar(100) specify which foliage mesh is recognized by line trace
UEADD spawn_mesh varchar(100) specify which static mesh to spawn
UEADD item_group int Used when we have multiple items associated to this resource. points to group_id in natural_resource_items