Hunt locationsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
No edit summary
Grimston (talk | contribs)
mNo edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{| border="1"
 
! field
This table is loaded by SpawnManager::LoadHuntLocations()
! type
 
! foreign key
At server startup we spawn into the world an "amount" of "itemid" for each line in the given "range".
! description
 
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
|
|
|id
|int(8) unsigned
|PRI
|
|
|auto_increment
|
|-
|-
| x
| double(10,2)
|
|
| coordinate on the map
|x
|double(10,2)
|
|0.00
|
|coordinate on the map  
|-
|-
| y
| double(10,2)
|
|
| coordinate on the map
|y
|double(10,2)
|
|0.00
|
|coordinate on the map  
|-
|-
| z
| double(10,2)
|
|
| coordinate on the map
|z
|double(10,2)
|
|0.00
|
|coordinate on the map  
|-
|-
| itemid
| int(10)
|
|
| item to spawn taken from item_stats table
|itemid
|int(10)
|
|0
|
|item to spawn taken from item_stats table
|-
|-
| interval
| int(11)
|
|
| time to respawn a new item in seconds
|interval
|int(11)
|
|0
|
|time to respawn a new item in seconds  
|-
|-
| max_random
| int(11)
|
|
| 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)
|
|
|sector
|int(10) unsigned
|
|0
|
|
|
|-
|-
| amount
| int(10)
|
|
| Number of items to spawn in the area
|amount
|int(10) unsigned
|
|1
|
|Number of items to spawn in the area
|-
|-
| range
| double(10,2)
|
|
| radius in centimeters
|range
|double(10,2) unsigned
|
|0.00
|
|radius in centimetres
|-
|-
| lock_str
| int(5)
|
|
| The lock strength of the generated item.
|lock_str
|int(5)
|
|0
|
|The lock strength of the generated item.  
|-
|-
| lock_skill
| int(2)
|
|
| The lock skill used to open the item.
|lock_skill
|int(2)
|
| -1
|
|The lock skill used to open the item.  
|-
|-
| flags
| varchar(200)
|
|
| 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.