Hunt locationsTable: Difference between revisions
Jump to navigation
Jump to search
Created page with "{| border="1" ! field ! type ! foreign key ! description |- | id | int(8) unsigned | | |- | x | double(10,2) | | |- | y | double(10,2) | | |- | z | double(10,2) | | |- | itemi..." |
No edit summary |
||
| Line 13: | Line 13: | ||
| double(10,2) | | double(10,2) | ||
| | | | ||
| | | coordinate on the map | ||
|- | |- | ||
| y | | y | ||
| double(10,2) | | double(10,2) | ||
| | | | ||
| | | coordinate on the map | ||
|- | |- | ||
| z | | z | ||
| double(10,2) | | double(10,2) | ||
| | | | ||
| | | coordinate on the map | ||
|- | |- | ||
| itemid | | itemid | ||
| int(10) | | int(10) | ||
| | | | ||
| | | item to spawn taken from item_stats table | ||
|- | |- | ||
| interval | | interval | ||
| int(11) | | int(11) | ||
| | | | ||
| | | time to respawn a new item in seconds | ||
|- | |- | ||
| max_random | | max_random | ||
| int(11) | | int(11) | ||
| | | | ||
| | | random time between 0 and given value added to interval value above | ||
|- | |- | ||
| sector | | sector | ||
| Line 48: | Line 48: | ||
| int(10) | | int(10) | ||
| | | | ||
| | | Number of items to spawn in the area | ||
|- | |- | ||
| range | | range | ||
| double(10,2) | | double(10,2) | ||
| | | | ||
| | | radius in centimeters | ||
|- | |- | ||
| lock_str | | lock_str | ||
| int(5) | | int(5) | ||
| | | | ||
| | | The lock strength of the generated item. | ||
|- | |- | ||
| lock_skill | | lock_skill | ||
| int(2) | | int(2) | ||
| | | | ||
| | | The lock skill used to open the item. | ||
|- | |- | ||
| flags | | flags | ||
| varchar(200) | | varchar(200) | ||
| | | | ||
| The flags to apply to the item. | |||
|} | |} | ||
[[Category:Engine documents]] | [[Category:Engine documents]] | ||
Revision as of 21:18, 27 February 2020
| field | type | foreign key | description |
|---|---|---|---|
| id | int(8) unsigned | ||
| x | double(10,2) | coordinate on the map | |
| y | double(10,2) | coordinate on the map | |
| z | double(10,2) | coordinate on the map | |
| itemid | int(10) | item to spawn taken from item_stats table | |
| interval | int(11) | time to respawn a new item in seconds | |
| max_random | int(11) | random time between 0 and given value added to interval value above | |
| sector | int(10) | ||
| amount | int(10) | Number of items to spawn in the area | |
| range | double(10,2) | radius in centimeters | |
| lock_str | int(5) | The lock strength of the generated item. | |
| lock_skill | int(2) | The lock skill used to open the item. | |
| flags | varchar(200) | The flags to apply to the item. |