Character_ticket

Back to the characters database list of tables.

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

The GUID of the character sending the ticket. See character.guid

ticket_text

The ticket description text; the text written by the player in describing the problem.

ticket_category

The ticket category:

Ticket Categories

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.