quest_tracker
Stores quest completion and abandonment data to help finding out bugged quests.
requires worldserver.conf
Quests.EnableQuestTracker = 1
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | NO | 0 | |||
| character_guid | int | unsigned | NO | 0 | |||
| quest_accept_time | datetime | NO | |||||
| quest_complete_time | datetime | YES | NULL | ||||
| quest_abandon_time | datetime | YES | NULL | ||||
| completed_by_gm | tinyint(1) | signed | NO | 0 | |||
| core_hash | varchar(120) | NO | 0 | ||||
| core_revision | varchar(120) | NO | 0 | ||||
Description of fields
id
The tracked quest ID.
character_guid
The character guid on the quest.
quest_accept_time
Unix timestamp when the quest was accepted.
quest_complete_time
Unix timestamp when the quest was completed.
quest_abandon_time
Unix timestamp when the quest was abandoned.
completed_by_gm
Flag if .quest complete command was used.
- 0: player completed the quest on his own
- 1: GM completed the quest for the player
core_hash
current _HASH (see revision_data.h)
core_revision
current _DATE (see revision_data.h)