Character ticket
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
(→ticket_category) |
||
| (3 промежуточные версии не показаны) | |||
| Строка 41: | Строка 41: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#response_text|response_text]] |
| - | | | + | |text |
|NO | |NO | ||
| | | | ||
| - | | | + | |None |
| | | | ||
|- | |- | ||
| Строка 59: | Строка 59: | ||
<big>'''Description of the fields'''</big> | <big>'''Description of the fields'''</big> | ||
====ticket_id==== | ====ticket_id==== | ||
| - | + | Уникальный идентификатор ID тикета. | |
| + | |||
====guid==== | ====guid==== | ||
| - | + | Уникальный идентификатор GUID персонажа, приславшего тикет. См. [[characters#guid|characters.guid]] | |
| + | |||
====ticket_text==== | ====ticket_text==== | ||
The ticket description text; the text written by the player in describing the problem. | The ticket description text; the text written by the player in describing the problem. | ||
| + | |||
| + | ====response_text==== | ||
| + | Ответ администрации (игротехника) на тикет. | ||
| + | ''Поле добавлено в 9136.'' | ||
| + | |||
====ticket_category==== | ====ticket_category==== | ||
| + | ''Данное поле было удалено в 6387.'' | ||
| + | |||
The ticket category: | The ticket category: | ||
{| border=1 cellspacing=0 cellpadding=3 | {| border=1 cellspacing=0 cellpadding=3 | ||
| Строка 88: | Строка 97: | ||
| 8 || Account/Billing | | 8 || Account/Billing | ||
|} | |} | ||
| + | |||
====ticket_lastchange==== | ====ticket_lastchange==== | ||
Stores the time when this ticket was last changed. | Stores the time when this ticket was last changed. | ||
Текущая версия на 17:42, 5 октября 2011
|
К описанию таблиц базы данных 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 | ||
| response_text | text | NO | None | ||
| ticket_lastchange | timestamp | NO | CURRENT_TIMESTAMP |
Description of the fields
ticket_id
Уникальный идентификатор ID тикета.
guid
Уникальный идентификатор GUID персонажа, приславшего тикет. См. characters.guid
ticket_text
The ticket description text; the text written by the player in describing the problem.
response_text
Ответ администрации (игротехника) на тикет. Поле добавлено в 9136.
ticket_category
Данное поле было удалено в 6387.
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.
