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: 'characters'The `characters` tableThis table holds vital static information for each character. This information loaded and used to create the player objects in-game. Structure
Description of the fieldsguidThe character global unique identifier. This number must be unique and is the best way to identify separate characters/ accountThe account ID in which this character resides. See account.id. in the auth database. nameThe name of the character. raceThe race of the character. See ChrRaces.dbc classThe class of the character: ChrClasses.dbc genderThe gender of the character. 0 = Male, 1 = Female, 2 = Unknown levelThe level of the character. xpThe amount of experience this character has earned towards the next level. moneyThe amount of copper this character has. playerBytescontains data about the skincolor,facestyle,hairstyle and haircolor of the character
playerBytes2data about facial hair
playerFlagsA bitmask that represents what Player flags the player has. Each bit controls a different flag and to combine flags, you can add each flag that you want, in effect activating the respective bits.
position_xThe x position of the character's location. position_yThe y position of the character's location. position_zThe z position of the character's location. mapThe map ID the character is in. instance_idThe instance ID the character is currently in and bound to instance_mode_maskThe current dungeon difficulty that the player is in. This field is bitmask. Values are put together, however, only two of four should be used at once. This description may not be 100% correct.
orientationThe orientation the character is facing. (North = 0.0, South = 3.14159) taximaskKnown taxi nodes separated with space onlineRecords whether the character is online (1) or offline (0). cinematicBoolean 1 or 0 controlling whether the start cinematic has been shown or not. totaltimeThe total time that the character has been active in the world, measured in seconds. leveltimeThe total time the character has spent in the world at the current level, measured in seconds. logout_timeThe time when the character last logged out, measured in Unix time. is_logout_restingBoolean 1 or 0 controlling if the character is currently in a resting zone or not. rest_bonusThe cumulated bonus of rested rate for gaining experience. resettalents_costThe cost for the character to reset its talents, measured in copper. resettalents_time
trans_xThe x position of the transport this character was on when they were last saved. trans_yThe y position of the transport this character was on when they were last saved. trans_zThe z position of the transport this character was on when they were last saved. trans_oThe orientation of the transport this character was on when they were last saved. transguidThe global unique identifier of the transport this character was on when they were last saved. extra_flagsThese flags control certain player specific attributes, mostly GM features
stable_slotsThe Stable Slots available (bought) at the Stable Master. at_loginThis field is a bitmask controlling different actions taken once a player logs in with the character.
For multiple actions, add values together. zoneThe zone ID the character is in. death_expire_timeTime when a character can be resurrected in case of a server crash or client exit while in ghost form, measured in Unix time. taxi_pathStores the players current taxi path (TaxiPath.dbc) if logged off while on one. arenaPointsThe amount of arena points this character has stored up, and will receive next time arena points are distributed. totalHonorPointsThe amount of honor points this character has got todayHonorPointsThe amount of honor points this character has gotten today yesterdayHonorPointsThe amount of honor points this character got yesterday totalKillsThe amount of players this character has killed todayKillsThe amount of players this character has killed today yesterdayKillsThe amount of players this character killed yesterday chosenTitleCurrent title, using the bit_index field (InGameOrder in CharTitles.dbc) knownCurrenciesKnown currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see CurrencyTypes.dbc watchedFactionTracked faction at experience bar (using reputation ID, see Faction.dbc) drunkCharacter's drunk state, 0-100
healthThe characters current health. powerCurrent character powers (snapshot from when the character was saved)
latencyThis characters latency, or ping, in milliseconds, as of the last update. speccountThe number of specs this character has access to. Default value is 1. Maximum currently supported value is 2. Should never be 0 (this is a sign of a character created before the dual spec system.) activespecThe currently activated spec for this character, spec = 0 is the first spec, spec = 1 is the second spec. exploredZonesBitmasks of explored zones (1 bit for explored, 0 bit for unexplored) equipmentCache
ammoIdTemplate ID of the ammo item knownTitlesContains data about known Titles stored in 6 x 16bit integers. To calculate where a knownTitle is in one of those 6 integers you do the following: We select one of the titles from CharTitles.dbc, take Archmage title for example:
We use the InGameOrder to calculate in which one of the 6 (16bit) integer is the title stored: InGameOrder / 32 = X so the 1st integer stores the title. Because counting starts from 0 to 5, it would be "0 TITLE_BIT 0 0 0 0". Now which bit stores the title? We use modulo to calculate this. InGameOrder Modulo 32 = X so the 29bit stores the title. This would be 2 ^ 29 = 536870912.This bit stores the Archmage title. This would mean if you only have the Archmage title, characters/knownTitles would be "0 5368709120 0 0 0". A bitmask that contains visible actionbars for the player Flag Comment {{field-no-description|61)) Stores the account id if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. Stores the name of character if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. Stores the date when the character was deleted and CharDelete.Method in worldserver.conf is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. |
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: