gm_ticket

This table stores all tickets.

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)			NO			Name of ticket creator
description	text			NO
createTime	int	unsigned		NO	0
mapId	smallint	unsigned		NO	0
posX	float			NO	0
posY	float			NO	0
posZ	float			NO	0
lastModifiedTime	int	unsigned		NO	0
closedBy	int	signed		NO	0
assignedTo	int	unsigned		NO	0		GUID of admin to whom ticket is assigned
comment	text			NO
response	text			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		GUID of GM who resolved the ticket

Description of fields

id

Unique ticket enumerator.  

type

ID	Name
0	TICKET_TYPE_OPEN
1	TICKET_TYPE_CLOSED
2	TICKET_TYPE_CHARACTER_DELETED

 

playerGuid

The guid of the reporting character.  

name

The character name, who created that ticket.  

description

The content of the ticket.  

createTime

Unix timestamp when the ticket was submitted.  

mapId

Map ID where ticket has ben created.  

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

Unix timestamp when the ticket was closed or deleted by the issuer.  

closedBy

• 0: ticket is open or was closed by console.
• >0: character guid of the closing GM or issuer.  

assignedTo

character guid of the assigned GM, if any.  

comment

The GM comment to the ticket, only visible to game masters.  

response

The GMs response to the ticket issuer.  

completed

Successful resolution?

• 0: not resolved
• 1: resolved  

escalated

ID	Name	Comment
0	TICKET_UNASSIGNED	ticket is not currently assigned to a gm
1	TICKET_ASSIGNED	ticket is assigned to a normal gm
2	TICKET_IN_ESCALATION_QUEUE	ticket is in the escalation queue
3	TICKET_ESCALATED_ASSIGNED	is a custom value and should never actually be sent

 

viewed

• 0: Not yet viewed
• 1: Ticket has been opened by GM  

needMoreHelp

Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"

• 0: player consideres issue resolved
• 1: player needs followup ticket  

resolvedBy

• 0: ticket is open or was closed by console.
• >0: character guid of the GM who resolved it by closing or completing the ticket.