The `gm_tickets` table
This table stores all tickets.
Note: do not insert directly into most of these columns, else the client won't update the ticket status until table reload and a logout.
Structure
| 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) | SIGNED | NO | Name of ticket creator | |||
| description | text | SIGNED | NO | ||||
| createTime | INT | UNSIGNED | NO | 0 | |||
| mapId | SMALLINT | UNSIGNED | NO | 0 | |||
| posX | FLOAT | SIGNED | NO | 0 | |||
| posY | FLOAT | SIGNED | NO | 0 | |||
| posZ | FLOAT | SIGNED | NO | 0 | |||
| lastModifiedTime | INT | UNSIGNED | NO | 0 | |||
| closedBy | INT | SIGNED | NO | 0 | -1 Closed by Console, >0 GUID of GM | ||
| assignedTo | INT | UNSIGNED | NO | 0 | GUID of admin to whom ticket is assigned | ||
| comment | text | SIGNED | NO | ||||
| response | text | SIGNED | 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 | -1 Resolved by Console, >0 GUID of GM |
Description of the fields
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
Type of ticket. Variables:
Player's GUID. See characters.guid.
The name of the character who created that ticket.
The content of the ticket.
The creation time of the ticket as linux timestamp.
Map where ticket has ben created. See Map.dbc.
Position X Where ticket has ben created.
Position Y Where ticket has ben created.
Position Z Where ticket has ben created.
The time when the ticket was closed or deleted by the issuer as linux timestamp.
>
Specify account number of GameMaster that have this ticket assigned.
The comment to the ticket added with .ticket comment, only visible to game masters. If the command is used twice, it overwrites the previous comment.
The string the GM inserted with .ticket response commands to answer the ticket before completing it. If the command is used twice, it appends the new answer at the end of the previous one.
response)>
Requests further GM interaction on a ticket to which a GM has already responded. Basically means “has a new ticket”.
>