gm_ticket

Back-to:Characters

The `gm_tickets` table

This table stores all tickets

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Id

int(10)

signed

PRI

NO


Auto increment


playerGuid

int(10)

unsigned


NO

0


Global Unique Identifier of ticket creator

name

varchar(12)

signed


NO

NULL


Name of ticket creator

description

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



needMoreHelp

tinyint(3)

unsigned


NO

0



'Description of the fields'''

Id

The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.

playerGuid

Player's GUID. See 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

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.

needMoreHelp

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

td class=