gm_tickets
This table contains the tickets for the ticketsystem.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| ticketid | int(11) | ||
| playerGuid | int(11) | ||
| name | varchar(200) | Empty String | |
| level | int(6) | 0 | |
| map | int(11) | 0 | |
| posX | float | 0 | |
| posY | float | 0 | |
| posZ | float | 0 | |
| message | text | ||
| timestamp | text | This seems to be the wrong row type for a timestamp. | |
| deleted | int(10) | 0 | |
| assignedto | int(11) | 0 | |
| comment | text |
ticketid
The ID of the ticket.
playerGuid
The character guid from characters table.
name
The name of the ticket creator.
level
The level of the ticket creator (at the moment the ticket was created).
position
The position (mapid, and x-, y-, z-position).
message
The ticket message.
timestamp
The time of the ticket creation.
deleted
0 = not deleted (default)
1 = deleted
backgroundcolour
The background colour.
rating
The rating of the arena team.
assignedto
The guid of the gamemaster from characters table.
comment
The comment to this ticket inserted by the gamemaster.