Hunt locationsTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
This table is loaded by SpawnManager::LoadHuntLocations() | This table is loaded by SpawnManager::LoadHuntLocations() | ||
At server startup we spawn into the world an "amount" of "itemid" for each line in the given "range". | |||
{| | When one of these items is picked up, we generate a UpsItemSpawnEvent() which will create a new item after "interval"+random("max_random") | ||
! | |||
! | Today only X and Y coordinates are randomized, the vertical coordinate stays as specified in the database entry. (this should be CHANGED to collide on the ground) | ||
! | |||
! | Areas to spawn items, like apples or mushrooms | ||
{| class="wikitable" | |||
|+ | |||
!UE | |||
!Field | |||
!Type | |||
!Key Type | |||
!Default | |||
!Extra | |||
!Description | |||
|- | |- | ||
| | | | ||
|id | |||
|int(8) unsigned | |||
|PRI | |||
| | | | ||
|auto_increment | |||
| | |||
|- | |- | ||
| | | | ||
| coordinate on the map | |x | ||
|double(10,2) | |||
| | |||
|0.00 | |||
| | |||
|coordinate on the map | |||
|- | |- | ||
| | | | ||
| coordinate on the map | |y | ||
|double(10,2) | |||
| | |||
|0.00 | |||
| | |||
|coordinate on the map | |||
|- | |- | ||
| | | | ||
| coordinate on the map | |z | ||
|double(10,2) | |||
| | |||
|0.00 | |||
| | |||
|coordinate on the map | |||
|- | |- | ||
| | | | ||
| item to spawn taken from item_stats table | |itemid | ||
|int(10) | |||
| | |||
|0 | |||
| | |||
|item to spawn taken from item_stats table | |||
|- | |- | ||
| | | | ||
| time to respawn a new item in seconds | |interval | ||
|int(11) | |||
| | |||
|0 | |||
| | |||
|time to respawn a new item in seconds | |||
|- | |- | ||
| | | | ||
| random time between 0 and given value added to interval value above | |max_random | ||
|int(11) | |||
| | |||
|0 | |||
| | |||
|random time between 0 and given value added to interval value above | |||
|- | |- | ||
| | | | ||
|sector | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | | | ||
| | |||
|- | |- | ||
| | | | ||
| Number of items to spawn in the area | |amount | ||
|int(10) unsigned | |||
| | |||
|1 | |||
| | |||
|Number of items to spawn in the area | |||
|- | |- | ||
| | | | ||
| radius in | |range | ||
|double(10,2) unsigned | |||
| | |||
|0.00 | |||
| | |||
|radius in centimetres | |||
|- | |- | ||
| | | | ||
| The lock strength of the generated item. | |lock_str | ||
|int(5) | |||
| | |||
|0 | |||
| | |||
|The lock strength of the generated item. | |||
|- | |- | ||
| | | | ||
| The lock skill used to open the item. | |lock_skill | ||
|int(2) | |||
| | |||
| -1 | |||
| | |||
|The lock skill used to open the item. | |||
|- | |- | ||
| | | | ||
| The flags to apply to the item. | |flags | ||
|varchar(200) | |||
| | |||
| | |||
| | |||
|The flags to apply to the item. | |||
|} | |} | ||
[[Category:Engine documents]] | [[Category:Engine documents]] | ||
Latest revision as of 14:41, 11 January 2022
This table is loaded by SpawnManager::LoadHuntLocations()
At server startup we spawn into the world an "amount" of "itemid" for each line in the given "range".
When one of these items is picked up, we generate a UpsItemSpawnEvent() which will create a new item after "interval"+random("max_random")
Today only X and Y coordinates are randomized, the vertical coordinate stays as specified in the database entry. (this should be CHANGED to collide on the ground)
Areas to spawn items, like apples or mushrooms
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| id | int(8) unsigned | PRI | auto_increment | |||
| x | double(10,2) | 0.00 | coordinate on the map | |||
| y | double(10,2) | 0.00 | coordinate on the map | |||
| z | double(10,2) | 0.00 | coordinate on the map | |||
| itemid | int(10) | 0 | item to spawn taken from item_stats table | |||
| interval | int(11) | 0 | time to respawn a new item in seconds | |||
| max_random | int(11) | 0 | random time between 0 and given value added to interval value above | |||
| sector | int(10) unsigned | 0 | ||||
| amount | int(10) unsigned | 1 | Number of items to spawn in the area | |||
| range | double(10,2) unsigned | 0.00 | radius in centimetres | |||
| lock_str | int(5) | 0 | The lock strength of the generated item. | |||
| lock_skill | int(2) | -1 | The lock skill used to open the item. | |||
| flags | varchar(200) | The flags to apply to the item. |