Gm tickets tc2
|
Back to characters database list of tables.
The `gm_tickets` table
This table stores all tickets
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ticketId | int(10) | signed | PRI | NO | Auto increment | ||
| guid | int(10) | unsigned | NO | 0 | Global Unique Identifier of ticket creator | ||
| name | varchar(12) | signed | NO | NULL | Name of ticket creator | ||
| message | 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 | ||||
| completed | tinyint(3) | unsigned | NO | 0 | |||
| escalated | tinyint(3) | unsigned | NO | 0 | |||
| viewed | tinyint(3) | unsigned | NO | 0 |
Description of the fields
ticketId
The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
guid
Player's GUID. See characters.guid
name
The name of the character who created that ticket
message
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
completed
This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.
escalated
This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.
viewed
0 : no one has viewed the ticket.
>0 : How many times the ticket has been viewed.
