Character questsTable: Difference between revisions
Jump to navigation
Jump to search
Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | player_id | integer | | |- | quest_id | integer | | |- | status | char | | |- | assigner_id | integer | | …' |
No edit summary |
||
| (5 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
{| | {| class="wikitable" | ||
|+ | |||
!UE | |||
!Field | |||
!Type | |||
!Key Type | |||
!Default | |||
!Extra | |||
!Description | |||
|- | |- | ||
| | |||
|player_id | |||
|int(10) unsigned | |||
|PRI | |||
|0 | |||
| | |||
| | |||
|- | |- | ||
| | | | ||
| | |quest_id | ||
|int(10) unsigned | |||
|PRI | |||
|0 | |||
| | |||
| | | | ||
|- | |||
| | |||
|status | |||
|char(1) | |||
| | |||
|O | |||
| | |||
| | | | ||
|- | |- | ||
| | | | ||
| | |assigner_id | ||
| | |int(10) unsigned | ||
| | |||
|0 | |||
| | |||
| | | | ||
|- | |- | ||
| | | | ||
| | |remaininglockout | ||
| | |int(10) | ||
| | | | ||
|0 | |||
| | |||
| When a quest is completed, it stores the total number of seconds the player has. Can be used for lockout quests. | |||
|- | |- | ||
| | | | ||
| | |last_response | ||
| | |int(10) | ||
| | |||
| -1 | |||
| | |||
| | | | ||
|- | |- | ||
| | | | ||
| | |last_response_npc_id | ||
| | |int(10) unsigned | ||
| | | | ||
| | |||
| | |||
|This field stores the NPC PID who gave the last response. Required for menu filtering. | |||
|- | |- | ||
| | | | ||
| | |completionOrder | ||
| | |int(10) unsigned | ||
| | | | ||
|0 | |||
| | |||
|This field stores the ordering in which this quest was completed from 0 to n. | |||
|} | |} | ||
[[Category:Engine documents]] | |||
Latest revision as of 19:11, 9 April 2022
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| player_id | int(10) unsigned | PRI | 0 | |||
| quest_id | int(10) unsigned | PRI | 0 | |||
| status | char(1) | O | ||||
| assigner_id | int(10) unsigned | 0 | ||||
| remaininglockout | int(10) | 0 | When a quest is completed, it stores the total number of seconds the player has. Can be used for lockout quests. | |||
| last_response | int(10) | -1 | ||||
| last_response_npc_id | int(10) unsigned | This field stores the NPC PID who gave the last response. Required for menu filtering. | ||||
| completionOrder | int(10) unsigned | 0 | This field stores the ordering in which this quest was completed from 0 to n. |