Hunt locationsTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 8: | Line 8: | ||
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) | 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. |