Back-to:Characters
The `gm_tickets` table
This table stores all tickets
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | signed | PRI | NO |
| Auto increment |
| |
int(10) | unsigned |
| NO | 0 |
| Global Unique Identifier of ticket creator | |
varchar(12) | signed |
| NO | NULL |
| Name of ticket creator | |
text | signed |
| NO |
|
| ||
int(10) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
int(10) | signed | NO | 0 | ||||
int(10) | signed | NO | 0 | ||||
int(10) | unsigned | NO | 0 | GUID of admin to whom ticket is assigned | |||
text | signed | NO | |||||
text | signed | NO | |||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 |
'Description of the fields'''
ticketId
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
guid
Player's GUID. See characters.guid
name
The name of the character who created that ticket
message
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
>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, only visible to game masters
response
Requires GM response. 17 = true, 1 = false (17 is default)
completed
field-no-description|14
escalated
field-no-description|15
viewed
0 : no one has viewed the ticket.
>0 : How many times the ticket has been viewed.
haveTicket
Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"