Back to 'gm_survey' Return to characters Go to 'group_instance'
This table stores all tickets.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | ||
| type | tinyint | unsigned | NO | 0 | 0 open, 1 closed, 2 character deleted | ||
| playerGuid | int | unsigned | NO | 0 | Global Unique Identifier of ticket creator | ||
| name | varchar(12) | NO | Name of ticket creator | ||||
| description | text | NO | |||||
| createTime | int | unsigned | NO | 0 | |||
| mapId | smallint | unsigned | NO | 0 | |||
| posX | float | NO | 0 | ||||
| posY | float | NO | 0 | ||||
| posZ | float | NO | 0 | ||||
| lastModifiedTime | int | unsigned | NO | 0 | |||
| closedBy | int | signed | NO | 0 | |||
| assignedTo | int | unsigned | NO | 0 | GUID of admin to whom ticket is assigned | ||
| comment | text | NO | |||||
| response | text | NO | |||||
| completed | tinyint | unsigned | NO | 0 | |||
| escalated | tinyint | unsigned | NO | 0 | |||
| viewed | tinyint | unsigned | NO | 0 | |||
| needMoreHelp | tinyint | unsigned | NO | 0 | |||
| resolvedBy | int | signed | NO | 0 | GUID of GM who resolved the ticket |
Unique ticket enumerator.
| ID | Name |
|---|---|
| 0 | TICKET_TYPE_OPEN |
| 1 | TICKET_TYPE_CLOSED |
| 2 | TICKET_TYPE_CHARACTER_DELETED |
The guid of the reporting character.
The character name, who created that ticket.
The content of the ticket.
Unix timestamp when the ticket was submitted.
MapID from Map.dbc where ticket has ben created.
Position X where ticket has ben created.
Position Y where ticket has ben created.
Position Z where ticket has ben created.
Unix timestamp when the ticket was closed or deleted by the issuer.
character guid of the assigned GM, if any.
The GM comment to the ticket, only visible to game masters.
The GMs response to the ticket issuer.
Successful resolution?
| ID | Name | Comment |
|---|---|---|
| 0 | TICKET_UNASSIGNED | ticket is not currently assigned to a gm |
| 1 | TICKET_ASSIGNED | ticket is assigned to a normal gm |
| 2 | TICKET_IN_ESCALATION_QUEUE | ticket is in the escalation queue |
| 3 | TICKET_ESCALATED_ASSIGNED | is a custom value and should never actually be sent |
Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"
Back to 'gm_survey' Return to characters Go to 'group_instance'