Datenbank 'characters'
account_data
account_instance_times
account_tutorial
addons
arena_team
arena_team_member
auctionhouse
banned_addons
bugreport
calendar_events
calendar_invites
channels
characters
character_account_data
character_achievement
character_achievement_progress
character_action
character_arena_stats
character_aura
character_banned
character_battleground_data
character_battleground_random
character_declinedname
character_equipmentsets
character_gifts
character_glyphs
character_homebind
character_instance
character_inventory
character_pet
character_pet_declinedname
character_queststatus
character_queststatus_daily
character_queststatus_monthly
character_queststatus_rewarded
character_queststatus_seasonal
character_queststatus_weekly
character_reputation
character_skills
character_social
character_spell
character_spell_cooldown
character_stats
character_talent
corpse
creature_respawn
gameobject_respawn
game_event_condition_save
game_event_save
gm_subsurvey
gm_survey
gm_ticket
groups
group_instance
group_member
guild
guild_bank_eventlog
guild_bank_item
guild_bank_right
guild_bank_tab
guild_eventlog
guild_member
guild_member_withdraw
guild_rank
instance
instance_reset
item_instance
item_loot_items
item_loot_money
item_refund_instance
item_soulbound_trade_data
lag_reports
lfg_data
mail
mail_items
petition
petition_sign
pet_aura
pet_spell
pet_spell_cooldown
pool_quest_save
pvpstats_battlegrounds
pvpstats_players
quest_tracker
reserved_name
updates
updates_include
warden_action
worldstates
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'characters'

Tabelle: 'gm_ticket'

The `gm_ticket` table

This table stores all tickets

Structure

Field Type Attributes Key Null Default Extra Comment
id int(10) vorzeichenlos PRI nein Auto increment
type tinyint(3) vorzeichenlos nein 0 0 open, 1 closed, 2 character deleted
playerGuid int(10) vorzeichenlos nein 0 Global Unique Identifier of ticket creator
name varchar(12) vorzeichenbehaftet nein Name of ticket creator
description text vorzeichenbehaftet nein

createTimeint(10)vorzeichenlosnein0
mapIdsmallint(5)vorzeichenlosnein0
posXfloatvorzeichenbehaftet

NO

0
posYfloatvorzeichenbehaftetnein0
posZfloatvorzeichenbehaftetnein0
lastModifiedTime int(10) vorzeichenlos nein 0
closedBy int(10) vorzeichenlos nein 0
asvorzeichenbehaftetTo int(10) vorzeichenlos nein 0 GUID of admin to whom ticket is asvorzeichenbehaftet
comment

textvorzeichenbehaftetnein
responsetextvorzeichenbehaftetnein
completedtinyint(3)vorzeichenlosnein0
escalatedtinyint(3)vorzeichenlosnein0
viewedtinyint(3)vorzeichenlosnein0
needMoreHelp tinyint(3) vorzeichenlos nein 0
resolvedBy int(10) vorzeichenlos nein 0 GUID of GM who resolved the ticket

'Description of the fields'''

id

The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.

type

-

playerGuid

Player's GUID. See characters/guid

name

The name of the character who created that ticket

description

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

asvorzeichenbehaftetTo

Specify account number of GameMaster that have this ticket asvorzeichenbehaftet.

comment

The comment to the ticket, only visible to game masters

response

Requires GM response. 17 = true, 1 = false (17 is default)

completed

field-no-description|14

escalated

field-no-description|15

viewed

0 : no one has viewed the ticket.

>0 : How many times the ticket has been viewed.

needMoreHelp

Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"

resolvedBy

-


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum