gm_ticket
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
Id
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
type
Type of ticket. Variables:
- 0 = open
- 1 = closed
- 2 = character deleted
playerGuid
Player's GUID. See characters.guid.
name
The name of the character who created that ticket.
description
The content of the ticket.
createTime
The creation time of the ticket as linux timestamp.
mapId
Map where ticket has ben created. See Map.dbc.
posX
Position X Where ticket has ben created.
posY
Position Y Where ticket has ben created.
posZ
Position Z Where ticket has ben created.
lastModifiedTime
The time when the ticket was closed or deleted by the issuer as linux timestamp.
closedBy
- 0 = Open
-1 = Closed by Console(not implemented on azerothcore yet)- >0 = player who abandoned ticket or GM who closed ticket
>
assignedTo
Specify account number of GameMaster that have this ticket assigned.
comment
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.
response
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.
completed
- 0 = not completed
- 1 = completed (will inform the user and show what is in
response)
escalated
- 0 = ticket is not currently assigned to a gm
- 1 = ticket is assigned to a normal gm
- 2 = ticket has been escalated after completion (a GM is supposed to contact the player back)
viewed
- 0 = no one has viewed the ticket.
- >0 = How many times the ticket has been viewed by GMs
>
needMoreHelp
Requests further GM interaction on a ticket to which a GM has already responded. Basically means “has a new ticket”.
resolvedBy
- 0 = Open
-1 = Resolved by Console(not supported on azerothcore yet cause of datatype in DB)- >0 = Character guid of the GM who resolved it (by closing the ticket or by completing the ticket)
>