Gm tickets

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table handles GM tickets.


Contents



ticketid

The id of the ticket.


playerGuid

The guid of the player.


name

The name of the player.


level

The level of the player who created the ticket.


map

the mapId where the player created the ticket.


posX

The X position of where the player created the ticket.


posY

The Y position of where the player created the ticket.


posZ

The Z position of where the player created the ticket.


message

The message the player wrote.


timestamp

deleted

Shows 1 if the tickets is deleted.

Shows 0(default) if the ticket is not deleted.


assignedto

The Guid of the gm which the ticket is assigned to.


comment

A comment on the ticket.


SQL Structure

CREATE TABLE `gm_tickets` (
  `ticketid` int(11) NOT NULL,
  `playerGuid` int(11) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `level` int(6) NOT NULL DEFAULT '0',
  `map` int(11) NOT NULL DEFAULT '0',
  `posX` float NOT NULL DEFAULT '0',
  `posY` float NOT NULL DEFAULT '0',
  `posZ` float NOT NULL DEFAULT '0',
  `message` text NOT NULL,
  `timestamp` text,
  `deleted` int UNSIGNED NOT NULL DEFAULT '0',
  `assignedto` int(11) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  UNIQUE KEY `guid` (`ticketid`),
  UNIQUE KEY `guid_2` (`ticketid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;    
Personal tools