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''' |
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
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
0 : Open
-1 : Closed by Console
>0 : player who abandoned ticket or GM who closed ticket
Specify account number of GameMaster that have this ticket assigned.
The comment to the ticket, only visible to game masters
Requires GM response. 17 = true, 1 = false (17 is default)
field-no-description|14
field-no-description|15
0 : no one has viewed the ticket.
>0 : How many times the ticket has been viewed.
Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"
td class=