Hunt locationsTable - Revision history

Grimston at 14:41, 11 January 2022

2022-01-11T14:41:53Z

← Older revision		Revision as of 14:41, 11 January 2022
Line 7:		Line 7:

	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"		{\| class="wikitable"
Line 26:		Line 28:
	\|		\|
	\|-		\|-
	\|~~DIF~~		\|
	\|x		\|x
	\|double(10,2)		\|double(10,2)
	\|		\|
	\|0		\|0.00
	\|		\|
	\|coordinate on the map ~~Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.~~		\|coordinate on the map
	\|-		\|-
	\|~~DIF~~		\|
	\|y		\|y
	\|double(10,2)		\|double(10,2)
	\|		\|
	\|0		\|0.00
	\|		\|
	\|coordinate on the map ~~Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.~~		\|coordinate on the map
	\|-		\|-
	\|~~DIF~~		\|
	\|z		\|z
	\|double(10,2)		\|double(10,2)
	\|		\|
	\|0		\|0.00
	\|		\|
	\|coordinate on the map ~~Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.~~		\|coordinate on the map
	\|-		\|-
	\|		\|
Line 64:		Line 66:
	\|0		\|0
	\|		\|
	\|time to respawn a new item in seconds		\|time to respawn a new item in seconds
	\|-		\|-
	\|		\|
Line 72:		Line 74:
	\|0		\|0
	\|		\|
	\|random time between 0 and given value added to interval value above		\|random time between 0 and given value added to interval value above
	\|-		\|-
	\|~~DIF~~		\|
	\|sector		\|sector
	\|int(10) unsigned		\|int(10) unsigned
	\|		\|
			\|0
	\|		\|
	\|		\|
	~~\| Type used to be 'varchar(30)' in PSLegacy. Default used to be '' in PSLegacy.~~
	\|-		\|-
	\|		\|
Line 90:		Line 92:
	\|Number of items to spawn in the area		\|Number of items to spawn in the area
	\|-		\|-
	\|~~DIF~~		\|
	\|range		\|range
	\|double(10,2) unsigned		\|double(10,2) unsigned
	\|		\|
	\|0		\|0.00
	\|		\|
	\|radius in centimetres ~~Type used to be 'double unsigned' in PSLegacy. Default used to be '' in PSLegacy.~~		\|radius in centimetres
	\|-		\|-
	\|~~ADD~~		\|
	\|lock_str		\|lock_str
	\|int(5)		\|int(5)
Line 106:		Line 108:
	\|The lock strength of the generated item.		\|The lock strength of the generated item.
	\|-		\|-
	\|~~ADD~~		\|
	\|lock_skill		\|lock_skill
	\|int(2)		\|int(2)
Line 114:		Line 116:
	\|The lock skill used to open the item.		\|The lock skill used to open the item.
	\|-		\|-
	\|~~ADD~~		\|
	\|flags		\|flags
	\|varchar(200)		\|varchar(200)
Line 122:		Line 124:
	\|The flags to apply to the item.		\|The flags to apply to the item.
	\|}		\|}


	[[Category:Engine documents]]		[[Category:Engine documents]]

Grimston at 12:19, 11 January 2022

2022-01-11T12:19:30Z

← Older revision		Revision as of 12:19, 11 January 2022
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)

			{\| class="wikitable"
	{\| ~~border~~="1"		\|+
	! ~~field~~		!UE
	! ~~type~~		!Field
	! ~~foreign key~~		!Type
	! ~~description~~		!Key Type
			!Default
			!Extra
			!Description
	\|-		\|-
	~~\| id~~
	~~\| int(8) unsigned~~
	\|		\|
			\|id
			\|int(8) unsigned
			\|PRI
	\|		\|
			\|auto_increment
			\|
	\|-		\|-
	\| x		\|DIF
	\| double(10,2)		\|x
			\|double(10,2)
	\|		\|
	\| coordinate on the map		\|0
			\|
			\|coordinate on the map Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.
	\|-		\|-
	\| y		\|DIF
	\| double(10,2)		\|y
			\|double(10,2)
	\|		\|
	\| coordinate on the map		\|0
			\|
			\|coordinate on the map Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.
	\|-		\|-
	\| z		\|DIF
	\| double(10,2)		\|z
			\|double(10,2)
	\|		\|
	\| coordinate on the map		\|0
			\|
			\|coordinate on the map Type used to be 'double' in PSLegacy. Default used to be '' in PSLegacy.
	\|-		\|-
	~~\| 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		\|DIF
	\| int(10)		\|sector
			\|int(10) unsigned
	\|		\|
	\|		\|
			\|
			\| Type used to be 'varchar(30)' in PSLegacy. Default used to be '' in PSLegacy.
	\|-		\|-
	~~\| 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		\|DIF
	\| double(10,2)		\|range
			\|double(10,2) unsigned
			\|
			\|0
	\|		\|
	\| radius in ~~centimeters~~		\|radius in centimetres Type used to be 'double unsigned' in PSLegacy. Default used to be '' in PSLegacy.
	\|-		\|-
	\| lock_str		\|ADD
	\| int(5)		\|lock_str
			\|int(5)
			\|
			\|0
	\|		\|
	\| The lock strength of the generated item.		\|The lock strength of the generated item.
	\|-		\|-
	\| lock_skill		\|ADD
	\| int(2)		\|lock_skill
			\|int(2)
			\|
			\| -1
	\|		\|
	\| The lock skill used to open the item.		\|The lock skill used to open the item.
	\|-		\|-
	\| flags		\|ADD
	\| varchar(200)		\|flags
			\|varchar(200)
			\|
			\|
	\|		\|
	\| The flags to apply to the item.		\|The flags to apply to the item.
	\|}		\|}


	[[Category:Engine documents]]		[[Category:Engine documents]]

Talad at 21:26, 27 February 2020

2020-02-27T21:26:35Z

← Older revision		Revision as of 21:26, 27 February 2020
Line 5:		Line 5:

	When one of these items is picked up, we generate a UpsItemSpawnEvent() which will create a new item after "interval"+random("max_random")		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)

Talad at 21:21, 27 February 2020

2020-02-27T21:21:40Z

← Older revision		Revision as of 21:21, 27 February 2020
Line 1:		Line 1:

	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")

Talad at 21:19, 27 February 2020

2020-02-27T21:19:30Z

← Older revision		Revision as of 21:19, 27 February 2020
Line 1:		Line 1:

			This table is loaded by SpawnManager::LoadHuntLocations()


	{\| border="1"		{\| border="1"
	! field		! field

Talad at 21:18, 27 February 2020

2020-02-27T21:18:55Z

← Older revision		Revision as of 21:18, 27 February 2020
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]]

Talad: 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..."

2020-02-27T21:07:06Z

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..."

New page

{| border="1"
! field
! type
! foreign key
! description
|-
| id
| int(8) unsigned
|
|
|-
| x
| double(10,2)
|
|
|-
| y
| double(10,2)
|
|
|-
| z
| double(10,2)
|
|
|-
| itemid
| int(10)
|
|
|-
| interval
| int(11)
|
|
|-
| max_random
| int(11)
|
|
|-
| sector
| int(10)
|
|
|-
| amount
| int(10)
|
|
|-
| range
| double(10,2)
|
|
|-
| lock_str
| int(5)
|
|
|-
| lock_skill
| int(2)
|
|
|-
| flags
| varchar(200)
|
|}

[[Category:Engine documents]]