Character ticket
Материал из YTDB DataBase
Версия от 17:28, 5 октября 2011; Кот ДаWINчи (Обсуждение | вклад)
|
К описанию таблиц базы данных characters.
The `character_ticket` table
Holds ticket information from tickets written through the client help request -function.
Structure
| Field | Type | Null | Key | Default | Extra |
| ticket_id | int(11) | NO | PRI | None | auto_increment |
| guid | int(11) unsigned | NO | 0 | ||
| ticket_text | text | YES | None | ||
| ticket_category | int(1) | NO | 0 | ||
| ticket_lastchange | timestamp | NO | CURRENT_TIMESTAMP |
Description of the fields
ticket_id
A unique ticket ID.
guid
Уникальный идентификатор GUID персонажа, приславшего тикет. См. characters.guid
ticket_text
The ticket description text; the text written by the player in describing the problem.
ticket_category
The ticket category:
| ID | Category |
|---|---|
| 0 | Item |
| 1 | Behavior/Harassment |
| 2 | Guild |
| 3 | Character |
| 4 | Non-quest/Creep |
| 5 | Stuck |
| 6 | Environmental |
| 7 | Quest/Quest NPC |
| 8 | Account/Billing |
ticket_lastchange
Stores the time when this ticket was last changed.
