Skip to content

gm_tickets Table

Open and archived GM tickets written by players.

Schema Summary

Field Type Key Null Default Extra
ticket_id int(10) unsigned PRI NO auto_increment
guid int(10) unsigned NO 0
name varchar(12) NO
message text NO
create_time bigint(20) unsigned NO 0
map smallint(5) unsigned NO 0
position_x float NO 0
position_y float NO 0
position_z float NO 0
last_modified_time bigint(20) unsigned NO 0
closed_by int(10) NO 0
assigned_to int(10) unsigned NO 0
comment text NO
response text NO
completed tinyint(3) unsigned NO 0
escalated tinyint(3) unsigned NO 0
viewed tinyint(3) unsigned NO 0
have_ticket tinyint(3) unsigned NO 0
ticket_type tinyint(3) unsigned NO 0
security_needed tinyint(3) unsigned NO 0

Field Breakdown

  • ticket_id - Primary Key. Unique ticket number.
  • guid - Authoring character guid + name snapshot (characters.guid).
  • name - Authoring character guid + name snapshot.
  • message - Ticket text written by the player.
  • create_time - Timestamps.
  • map - Player location at submission (for .go to reporter).
  • position_x - Player location at submission (for .go to reporter).
  • position_y - Reporter position at ticket creation.
  • position_z - Reporter position at ticket creation (Z).
  • last_modified_time - Timestamps.
  • closed_by - Who closed it (0 = open; -1 = console; character guid of the player who abandoned it or the GM who closed it).
  • assigned_to - Staff character guid handling the ticket (0 = unassigned).
  • comment - Internal staff comment.
  • response - Answer sent back to the player.
  • completed - Completion flag.
  • escalated - Ticket status (GMTicketEscalationStatus): 0 unassigned, 1 assigned, 2 in escalation queue, 3 escalated+assigned.
  • viewed - Whether staff opened it already.
  • have_ticket - Player requested further GM interaction on a ticket that was already responded to ("need more help").
  • ticket_type - Ticket category (TicketType): 1 stuck, 2 harassment, 3 guild, 4 item, 5 environmental, 6 non-quest creep, 7 quest/quest NPC, 8 technical, 9 account/billing, 10 character.
  • security_needed - Minimum security level required to handle this ticket.