Natural resourcesTable
Jump to navigation
Jump to search
field | type | foreign key | description |
---|---|---|---|
id | int(10) | ||
lod_sector_id | int(10) | ||
loc_x | double(10,2) | x coord of center | |
loc_y | double(10,2) | y coord of center | |
loc_z | double(10,2) | z coord of center | |
radius | double(10,2) | radius of the resource in centimeters | |
visible_radius | double(10,2) | allow harvesting but with no result | |
probability | double(10,6) | chance of finding an item by harvesting | |
skill | smallint(4) | skill ID used to harvest | |
skill_level | int(3) | skill rank required to harvest | |
item_cat_id | int(8) | item category required for harvesting | |
item_quality | float(10,6) | ??? | |
animation | varchar(30) | animation played while harvesting | |
anim_duration_seconds | int(10) | animation duration | |
item_id_reward | int(10) | item given to player when successful | |
reward_nickname | varchar(30) | name of the item given as used in commands and maps | |
action | varchar(45) | command needed to harvest: dig/harvest/fish | |
amount | int(10) | if not null, items will be spawned as hunt_location | |
interval | int(11) | if amount not null, msec interval for spawning item when picked up | |
max_random | int(11) | Maximum random interval modifier in msecs |