Character questsTable - Revision history

Talad at 19:11, 9 April 2022

2022-04-09T19:11:34Z

← Older revision		Revision as of 19:11, 9 April 2022
Line 47:		Line 47:
	\|0		\|0
	\|		\|
	\|		\| When a quest is completed, it stores the total number of seconds the player has. Can be used for lockout quests.
	\|-		\|-
	\|		\|

Grimston at 14:25, 11 January 2022

2022-01-11T14:25:35Z

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


	{\| class="wikitable"		{\| class="wikitable"
	\|+		\|+
Line 65:		Line 63:
	\|		\|
	\|		\|
	\|		\|This field stores the NPC PID who gave the last response. Required for menu filtering.
	\|-		\|-
	\|~~ADD~~		\|
	\|completionOrder		\|completionOrder
	\|int(10) unsigned		\|int(10) unsigned
Line 75:		Line 73:
	\|This field stores the ordering in which this quest was completed from 0 to n.		\|This field stores the ordering in which this quest was completed from 0 to n.
	\|}		\|}


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

Grimston at 11:52, 11 January 2022

2022-01-11T11:52:47Z

← Older revision		Revision as of 11:52, 11 January 2022
Line 1:		Line 1:
	{\| ~~border~~="1"

			{\| class="wikitable"
			\|+
			!UE
			!Field
			!Type
			!Key Type
			!Default
			!Extra
			!Description
	\|-		\|-
	~~! field~~		\|
	~~! type~~		\|player_id
	~~! foreign key~~		\|int(10) unsigned
	~~! description~~		\|PRI
			\|0
			\|
			\|
	\|-		\|-
	\| ~~player_id~~		\|
	\| ~~integer~~		\|quest_id
			\|int(10) unsigned
			\|PRI
			\|0
			\|
	\|		\|
			\|-
			\|
			\|status
			\|char(1)
			\|
			\|O
			\|
	\|		\|
	\|-		\|-
	\| ~~quest_id~~		\|
	\| ~~integer~~		\|assigner_id
	\|		\|int(10) unsigned
			\|
			\|0
			\|
	\|		\|
	\|-		\|-
	\| ~~status~~		\|
	\| ~~char~~		\|remaininglockout
	\|		\|int(10)
			\|
			\|0
			\|
	\|		\|
	\|-		\|-
	\| ~~assigner_id~~		\|
	\| ~~integer~~		\|last_response
	\|		\|int(10)
			\|
			\| -1
			\|
	\|		\|
	\|-		\|-
	\| ~~remaininglockout~~		\|
	\| ~~integer~~		\|last_response_npc_id
	\|		\|int(10) unsigned
			\|
			\|
			\|
	\|		\|
	\|-		\|-
	\| ~~last_response~~		\|ADD
	\| ~~integer~~		\|completionOrder
	\|		\|int(10) unsigned
	\|		\|
			\|0
			\|
			\|This field stores the ordering in which this quest was completed from 0 to n.
	\|}		\|}


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

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

2010-12-10T23:29:42Z

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

← Older revision		Revision as of 23:29, 10 December 2010
Line 1:		Line 1:
	~~spam~~		{\| border="1"
			\|-
			! field
			! type
			! foreign key
			! description
			\|-
			\| player_id
			\| integer
			\|
			\|
			\|-
			\| quest_id
			\| integer
			\|
			\|
			\|-
			\| status
			\| char
			\|
			\|
			\|-
			\| assigner_id
			\| integer
			\|
			\|
			\|-
			\| remaininglockout
			\| integer
			\|
			\|
			\|-
			\| last_response
			\| integer
			\|
			\|
			\|}


			[[Category:Engine documents]]

Luca: spam

2010-12-10T21:40:08Z

spam

← Older revision		Revision as of 21:40, 10 December 2010
Line 1:		Line 1:
	~~{\| border="1"~~		spam
	\|-
	~~! field~~
	~~! type~~
	~~! foreign key~~
	~~! description~~
	\|-
	~~\| player_id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| quest_id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| status~~
	~~\| char~~
	\|
	\|
	\|-
	~~\| assigner_id~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| remaininglockout~~
	~~\| integer~~
	\|
	\|
	\|-
	~~\| last_response~~
	~~\| integer~~
	\|
	\|
	\|}


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

Ethryn: add to category (Engine documents)

2010-10-23T00:13:40Z

add to category (Engine documents)

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


			[[Category:Engine documents]]

Talad: Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | player_id | integer | | |- | quest_id | integer | | |- | status | char | | |- | assigner_id | integer | | …'

2010-10-12T22:12:59Z

Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | player_id | integer | | |- | quest_id | integer | | |- | status | char | | |- | assigner_id | integer | | …'

New page

{| border="1"
|-
! field
! type
! foreign key
! description
|-
| player_id
| integer
|
|
|-
| quest_id
| integer
|
|
|-
| status
| char
|
|
|-
| assigner_id
| integer
|
|
|-
| remaininglockout
| integer
|
|
|-
| last_response
| integer
|
|
|}