TrinityCore : gm_tickets

Back-to:Characters

The `gm_tickets` table

This table stores all tickets

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ticketId	int(10)	signed	PRI	NO		Auto increment
guid	int(10)	unsigned		NO	0		Global Unique Identifier of ticket creator
name	varchar(12)	signed		NO	NULL		Name of ticket creator
message	text	signed		NO
createtime	int(10)	unsigned		NO	0
mapId	smallint(5)	unsigned		NO	0
posX	float	signed		NO	0
posY	float	signed		NO	0
posZ	float	signed		NO	0
lastModifiedTime	int(10)	signed		NO	0
closedBy	int(10)	signed		NO	0
assignedTo	int(10)	unsigned		NO	0		GUID of admin to whom ticket is assigned
comment	text	signed		NO
response	text	signed		NO
completed	tinyint(3)	unsigned		NO	0
escalated	tinyint(3)	unsigned		NO	0
viewed	tinyint(3)	unsigned		NO	0
haveTicket	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=