Action locationsTable - Revision history

Grimston at 11:09, 11 January 2022

2022-01-11T11:09:41Z

← Older revision		Revision as of 11:09, 11 January 2022
Line 1:		Line 1:


	{\| class="wikitable"		{\| class="wikitable"
	\|+		\|+
			!UE
	!Field		!Field
	!Type		!Type
			!Key Type
			!Default
			!Extra
	!Description		!Description
	\|-		\|-
			\|
	\|id		\|id
	\|int(10) unsigned		\|int(10) unsigned
			\|PRI
	\|		\|
			\|auto_increment
			\|
	\|-		\|-
			\|
	\|master_id		\|master_id
	\|int(10) unsigned		\|int(10) unsigned
			\|MUL
			\|
	\|		\|
			\|
	\|-		\|-
			\|
	\|name		\|name
	\|varchar(45)		\|varchar(45)
	\|		\|
			\|
			\|
			\|
	\|-		\|-
			\|
	\|sectorname		\|sectorname
	\|varchar(30)		\|varchar(30)
			\|MUL
	\|		\|
			\|
			\|
	\|-		\|-
			\|
	\|meshname		\|meshname
	\|varchar(250)		\|varchar(250)
	\|name of the mesh used to trigger the action location		\|
			\|
			\|
			\|name of the mesh used to trigger the action location
	\|-		\|-
			\|
	\|polygon		\|polygon
	\|int(10) unsigned		\|int(10) unsigned
	\|specific polygon number to use when triggering the action location		\|
			\|
			\|
			\|specific polygon number to use when triggering the action location
	\|-		\|-
			\|
	\|pos_x		\|pos_x
	\|float		\|float
	\|center of the action location		\|
			\|
			\|
			\|center of the action location
	\|-		\|-
			\|
	\|pos_y		\|pos_y
	\|float		\|float
	\|~~as above~~		\|
			\|
			\|
			\|center of the action location
	\|-		\|-
			\|
	\|pos_z		\|pos_z
	\|float		\|float
	\|~~as above~~		\|
			\|
			\|
			\|center of the action location
	\|-		\|-
			\|
	\|pos_instance		\|pos_instance
	\|int(10) unsigned		\|int(10) unsigned
	\|Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all		\|
			\|4294967295
			\|
			\|Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all
	\|-		\|-
			\|
	\|radius		\|radius
	\|float		\|float
	\|radius of the trigger starting from the defined center		\|
			\|
			\|
			\|radius of the trigger starting from the defined center
	\|-		\|-
			\|
	\|triggertype		\|triggertype
	\|varchar(10)		\|varchar(10)
	\|can be SELECT (player need to click to activate) or PROXIMITY (activates automatically based on range)		\|
			\|
			\|
			\|can be SELECT (player need to click to activate) or PROXIMITY (activates automatically based on range)
	\|-		\|-
			\|
	\|responsetype		\|responsetype
	\|varchar(10)		\|varchar(10)
	\|can be EXAMINE (can contain just text displayed to the player as description, or an <Examine> script) or SCRIPT (name of the ~~[[progressionEventsTable\|~~progression_events]].name to run)		\|
			\|
			\|
			\|can be EXAMINE (can contain just text displayed to the player as description, or an <Examine> script) or SCRIPT (name of the progression_events.name to run)
	\|-		\|-
			\|
	\|response		\|response
	\|text		\|text
	\|		\|
			\|
			\|
			\|
	\|-		\|-
			\|
	\|active_ind		\|active_ind
	\|char(1)		\|char(1)
	\|		\|
			\|Y
			\|
			\|
	\|}		\|}

Talad at 23:04, 30 November 2021

2021-11-30T23:04:41Z

← Older revision		Revision as of 23:04, 30 November 2021
Line 55:		Line 55:
	\|responsetype		\|responsetype
	\|varchar(10)		\|varchar(10)
	\|can be EXAMINE (can contain just text displayed to the player as description, or an <Examine> script) or SCRIPT (name of the [[progressionEventsTable\|progression_events]]).name to run		\|can be EXAMINE (can contain just text displayed to the player as description, or an <Examine> script) or SCRIPT (name of the [[progressionEventsTable\|progression_events]].name to run)
	\|-		\|-
	\|response		\|response

Talad at 23:04, 30 November 2021

2021-11-30T23:04:22Z

← Older revision		Revision as of 23:04, 30 November 2021
Line 51:		Line 51:
	\|triggertype		\|triggertype
	\|varchar(10)		\|varchar(10)
	\|can be SELECT or PROXIMITY		\|can be SELECT (player need to click to activate) or PROXIMITY (activates automatically based on range)
	\|-		\|-
	\|responsetype		\|responsetype
	\|varchar(10)		\|varchar(10)
	\|can be EXAMINE or SCRIPT		\|can be EXAMINE (can contain just text displayed to the player as description, or an <Examine> script) or SCRIPT (name of the [[progressionEventsTable\|progression_events]]).name to run
	\|-		\|-
	\|response		\|response

Talad at 22:59, 30 November 2021

2021-11-30T22:59:19Z

← Older revision		Revision as of 22:59, 30 November 2021
Line 4:		Line 4:
	!Type		!Type
	!Description		!Description
	!
	\|-		\|-
	\|id		\|id
	\|int(10) unsigned		\|int(10) unsigned
	\|		\|
	!
	\|-		\|-
	\|master_id		\|master_id
	\|int(10) unsigned		\|int(10) unsigned
	\|
	\|		\|
	\|-		\|-
	\|name		\|name
	\|varchar(45)		\|varchar(45)
	\|
	\|		\|
	\|-		\|-
	\|sectorname		\|sectorname
	\|varchar(30)		\|varchar(30)
	\|
	\|		\|
	\|-		\|-
	\|meshname		\|meshname
	\|varchar(250)		\|varchar(250)
	\|		\|name of the mesh used to trigger the action location
	\|
	\|-		\|-
	\|polygon		\|polygon
	\|int(10) unsigned		\|int(10) unsigned
	\|		\|specific polygon number to use when triggering the action location
	\|
	\|-		\|-
	\|pos_x		\|pos_x
	\|float		\|float
	\|		\|center of the action location
	\|
	\|-		\|-
	\|pos_y		\|pos_y
	\|float		\|float
	\|		\|as above
	\|
	\|-		\|-
	\|pos_z		\|pos_z
	\|float		\|float
	\|		\|as above
	\|
	\|-		\|-
	\|pos_instance		\|pos_instance
	\|int(10) unsigned		\|int(10) unsigned
	\|Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all		\|Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all
	\|
	\|-		\|-
	\|radius		\|radius
	\|float		\|float
	\|		\|radius of the trigger starting from the defined center
	\|
	\|-		\|-
	\|triggertype		\|triggertype
	\|varchar(10)		\|varchar(10)
	\|		\|can be SELECT or PROXIMITY
	\|
	\|-		\|-
	\|responsetype		\|responsetype
	\|varchar(10)		\|varchar(10)
	\|		\|can be EXAMINE or SCRIPT
	\|
	\|-		\|-
	\|response		\|response
	\|text		\|text
	\|
	\|		\|
	\|-		\|-
	\|active_ind		\|active_ind
	\|char(1)		\|char(1)
	\|
	\|		\|
	\|}		\|}

Talad at 22:50, 30 November 2021

2021-11-30T22:50:51Z

← Older revision		Revision as of 22:50, 30 November 2021
Line 1:		Line 1:
	{\| ~~border~~="1"		{\| class="wikitable"
	! ~~field~~		\|+
	! ~~type~~		!Field
	! ~~foreign key~~		!Type
	! ~~description~~		!Description
			!
	\|-		\|-
	\| id		\|id
	\| ~~integer~~		\|int(10) unsigned
			\|
			!
			\|-
			\|master_id
			\|int(10) unsigned
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~master_id~~		\|name
	\| ~~integer~~		\|varchar(45)
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~name~~		\|sectorname
	\| varchar		\|varchar(30)
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~sectorname~~		\|meshname
	\| varchar		\|varchar(250)
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~meshname~~		\|polygon
	\| ~~varchar~~		\|int(10) unsigned
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~polygon~~		\|pos_x
	\| ~~integer~~		\|float
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~pos_x~~		\|pos_y
	\| ~~real~~		\|float
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~pos_y~~		\|pos_z
	\| ~~real~~		\|float
	\|		\|
	\|		\|
	\|-		\|-
	\| ~~pos_z~~		\|pos_instance
	\| ~~real~~		\|int(10) unsigned
	\|		\|Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all
	\|		\|
	\|-		\|-
	\| radius		\|radius
	\| ~~real~~		\|float
	\|		\|
	\|		\|
	\|-		\|-
	\| triggertype		\|triggertype
	\| varchar		\|varchar(10)
	\|		\|
	\|		\|
	\|-		\|-
	\| responsetype		\|responsetype
	\| varchar		\|varchar(10)
	\|		\|
	\|		\|
	\|-		\|-
	\| response		\|response
	\| ~~longvarchar~~		\|text
	\|		\|
	\|		\|
	\|-		\|-
	\| active_ind		\|active_ind
	\| char		\|char(1)
	\|		\|
	\|		\|
	\|}		\|}


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

Talad: Reverted edits by Luca (Talk) to last revision by Ethryn

2010-12-10T22:33:03Z

Reverted edits by Luca (Talk) to last revision by Ethryn

← Older revision		Revision as of 22:33, 10 December 2010
Line 1:		Line 1:
	~~spam~~		{\| border="1"
			! field
			! type
			! foreign key
			! description
			\|-
			\| id
			\| integer
			\|
			\|
			\|-
			\| master_id
			\| integer
			\|
			\|
			\|-
			\| name
			\| varchar
			\|
			\|
			\|-
			\| sectorname
			\| varchar
			\|
			\|
			\|-
			\| meshname
			\| varchar
			\|
			\|
			\|-
			\| polygon
			\| integer
			\|
			\|
			\|-
			\| pos_x
			\| real
			\|
			\|
			\|-
			\| pos_y
			\| real
			\|
			\|
			\|-
			\| pos_z
			\| real
			\|
			\|
			\|-
			\| radius
			\| real
			\|
			\|
			\|-
			\| triggertype
			\| varchar
			\|
			\|
			\|-
			\| responsetype
			\| varchar
			\|
			\|
			\|-
			\| response
			\| longvarchar
			\|
			\|
			\|-
			\| active_ind
			\| char
			\|
			\|
			\|}


			[[Category:Engine documents]]

Luca at 22:08, 10 December 2010

2010-12-10T22:08:51Z

← Older revision		Revision as of 22:08, 10 December 2010
Line 1:		Line 1:
	~~{\| border="1"~~		spam
	~~! field~~
	~~! type~~
	~~! foreign key~~
	~~! description~~
	\|-
	~~\| id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| master_id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| name~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| sectorname~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| meshname~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| polygon~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| pos_x~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| pos_y~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| pos_z~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| radius~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| triggertype~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| responsetype~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| response~~
	~~\| longvarchar~~
	\|
	\|
	\|-
	~~\| active_ind~~
	~~\| char~~
	\|
	\|
	\|}


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

Ethryn: add to category (Engine documents)

2010-10-23T00:20:27Z

add to category (Engine documents)

← Older revision		Revision as of 00:20, 23 October 2010
Line 75:		Line 75:
	\|		\|
	\|}		\|}


			[[Category:Engine documents]]

Talad: Created page with '{| border="1" ! field ! type ! foreign key ! description |- | id | integer | | |- | master_id | integer | | |- | name | varchar | | |- | sectorname | varchar | | |- | mes…'

2010-10-12T22:24:04Z

Created page with '{| border="1" ! field ! type ! foreign key ! description |- | id | integer | | |- | master_id | integer | | |- | name | varchar | | |- | sectorname | varchar | | |- | mes…'

New page

{| border="1"
! field
! type
! foreign key
! description
|-
| id
| integer
|
|
|-
| master_id
| integer
|
|
|-
| name
| varchar
|
|
|-
| sectorname
| varchar
|
|
|-
| meshname
| varchar
|
|
|-
| polygon
| integer
|
|
|-
| pos_x
| real
|
|
|-
| pos_y
| real
|
|
|-
| pos_z
| real
|
|
|-
| radius
| real
|
|
|-
| triggertype
| varchar
|
|
|-
| responsetype
| varchar
|
|
|-
| response
| longvarchar
|
|
|-
| active_ind
| char
|
|
|}

← Older revision		Revision as of 22:08, 10 December 2010
Line 1:		Line 1:
	~~{\| border="1"~~		spam
	~~! field~~
	~~! type~~
	~~! foreign key~~
	~~! description~~
	\|-
	~~\| id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| master_id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| name~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| sectorname~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| meshname~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| polygon~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| pos_x~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| pos_y~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| pos_z~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| radius~~
	~~\| real~~
	\|
	\|
	\|-
	~~\| triggertype~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| responsetype~~
	~~\| varchar~~
	\|
	\|
	\|-
	~~\| response~~
	~~\| longvarchar~~
	\|
	\|
	\|-
	~~\| active_ind~~
	~~\| char~~
	\|
	\|
	\|}


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