Hunt locationsTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
| No edit summary | mNo edit summary | ||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| {|  | |||
| !  | 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. |