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_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` tableThis table stores all tickets Structure
'Description of the fields''' idThe ticket global unique identifier. This number must be unique and is the best way to identify separate tickets. type- playerGuidPlayer's GUID. See characters/guid nameThe name of the character who created that ticket descriptionThe content of the ticket createTimeThe creation time of the ticket as linux timestamp mapIdMap where ticket has ben created. See Map.dbc posXPosition X Where ticket has ben created. posYPosition Y Where ticket has ben created. posZPosition Z Where ticket has ben created. lastModifiedTimeThe time when the ticket was closed or deleted by the issuer as linux timestamp closedBy0 : Open -1 : Closed by Console >0 : player who abandoned ticket or GM who closed ticket asvorzeichenbehaftetToSpecify account number of GameMaster that have this ticket asvorzeichenbehaftet. commentThe comment to the ticket, only visible to game masters responseRequires GM response. 17 = true, 1 = false (17 is default) completed
escalated
viewed0 : no one has viewed the ticket. >0 : How many times the ticket has been viewed. needMoreHelpRequests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket" resolvedBy- |
Datenbank 'characters'
Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
Stimme zählen für Account: