Natural resourcesTable
| 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 |