# gm\_ticket [<-Back-to:Characters](database-characters.md) **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][1] | INT | UNSIGNED | PRI | NO | | Auto increment | | | [type][2] | TINYINT | UNSIGNED | | NO | 0 | | 0 open, 1 closed, 2 character deleted | | [playerGuid][3] | INT | UNSIGNED | | NO | 0 | | Global Unique Identifier of ticket creator | | [name][4] | VARCHAR(12) | SIGNED | | NO | | | Name of ticket creator | | [description][5] | text | SIGNED | | NO | | | | | [createTime][6] | INT | UNSIGNED | | NO | 0 | | | | [mapId][7] | SMALLINT | UNSIGNED | | NO | 0 | | | | [posX][8] | FLOAT | SIGNED | | NO | 0 | | | | [posY][9] | FLOAT | SIGNED | | NO | 0 | | | | [posZ][10] | FLOAT | SIGNED | | NO | 0 | | | | [lastModifiedTime][11] | INT | UNSIGNED | | NO | 0 | | | | [closedBy][12] | INT | SIGNED | | NO | 0 | | -1 Closed by Console, >0 GUID of GM | | [assignedTo][13] | INT | UNSIGNED | | NO | 0 | | GUID of admin to whom ticket is assigned | | [comment][14] | text | SIGNED | | NO | | | | | [response][15] | text | SIGNED | | NO | | | | | [completed][16] | TINYINT | UNSIGNED | | NO | 0 | | | | [escalated][17] | TINYINT | UNSIGNED | | NO | 0 | | | | [viewed][18] | TINYINT | UNSIGNED | | NO | 0 | | | | [needMoreHelp][19] | TINYINT | UNSIGNED | | NO | 0 | | | | [resolvedBy][20] | INT | SIGNED | | NO | 0 | | -1 Resolved by Console, >0 GUID of GM | [1]: #id [2]: #type [3]: #playerguid [4]: #name [5]: #description [6]: #createtime [7]: #mapid [8]: #posx [9]: #posy [10]: #posz [11]: #lastmodifiedtime [12]: #closedby [13]: #assignedto [14]: #comment [15]: #response [16]: #completed [17]: #escalated [18]: #viewed [19]: #needmorehelp [20]: #resolvedby **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](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](map). ### 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)