AzerothCore
Posts (Latest 10 updated) :
Read all
Contents:

{: #git-wiki-toc}

gm_ticket

<-Back-to:Characters

The gm_tickets table

This table stores all tickets.

Note: do not insert directly into most of these columns, else the client won't update the ticket status until table reload and a logout.

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Id

int(10)

signed

PRI

NO


Auto increment


type

tinyint(3)

unsigned


NO

0


0 open, 1 closed, 2 character deleted

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



resolvedBy

int(10)

unsigned


NO

0


GUID of GM who resolved the ticket

'Description of the fields'''

Id

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

type

Type of ticket. Variables: 0 = open, 1 = closed, 2 = character deleted.

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 (not implemented on azerothcore yet)
  • > 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 added with .ticket comment, only visible to game masters. If the command is used twice, it overwrites the previous comment.

response

The string the GM inserted with .ticket response commands to answer the ticket before completing it. If the command is used twice, it appends the new answer at the end of the previous one.

completed

  • 0 = not completed
  • 1 = completed (will inform the user and show what is in response)

escalated

  • 0 = ticket is not currently assigned to a gm
  • 1 = ticket is assigned to a normal gm
  • 2 = ticket has been escalated after completion (a GM is supposed to contact the player back)

viewed

  • 0 = no one has viewed the ticket.
  • >0 = How many times the ticket has been viewed by GMs

needMoreHelp

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

resolvedBy

  • 0 = Open
  • -1 = Resolved by Console (not supported on azerothcore yet cause of datatype in DB)
  • > 0 = Character guid of the GM who resolved it (by closing the ticket or by completing the ticket)