数据库:characters数据库:characters
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
| 数据库:characters数据库:characters [2023/09/24 11:30] – 创建 admin | 数据库:characters数据库:characters [2023/09/24 12:19] (当前版本) – [characters 表] admin | ||
|---|---|---|---|
| 行 7: | 行 7: | ||
| **表结构** | **表结构** | ||
| ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ||
| - | |[[#id|id]]|INT|UNSIGNED|PRI|NO| | | | | + | |[[#guid|guid]]|INT|UNSIGNED|PRI|NO|0|Unique|Global Unique Identifier| |
| - | |[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | | + | |[[#account|account]]|INT|UNSIGNED| |NO|0| |Account Identifier| |
| - | |[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | | + | |[[# |
| - | |[[#comment|comment]]|VARCHAR(255)|SIGNED| |YES|' '| | | | + | |[[# |
| + | |[[#class|class]]|TINYINT|UNSIGNED| |NO|0| | | | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[#xp|xp]]|INT|UNSIGNED| |NO|0| | | | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[#activeTalentGroup|activeTalentGroup]]|TINYINT|UNSIGNED| |NO|0| | | | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| 行 16: | 行 91: | ||
| ---- | ---- | ||
| - | guid | + | ==== guid ==== |
| The character global unique identifier. This number must be unique and is the best way to identify separate characters. | The character global unique identifier. This number must be unique and is the best way to identify separate characters. | ||
| - | account | + | ==== account |
| The account ID in which this character resides. See account.id in the auth database. | The account ID in which this character resides. See account.id in the auth database. | ||
| - | name | + | ==== name ==== |
| The name of the character. Max length is 12 characters. | The name of the character. Max length is 12 characters. | ||
| - | race | + | ==== race ==== |
| The race of the character. See ChrRaces.dbc. | The race of the character. See ChrRaces.dbc. | ||
| - | class | + | ==== class ==== |
| The class of the character: ChrClasses.dbc. | The class of the character: ChrClasses.dbc. | ||
| - | gender | + | ==== gender |
| The gender of the character. | The gender of the character. | ||
| - | Id Gender | + | ^Id^Gender^ |
| - | 0 Male | + | |0|Male| |
| - | 1 Female | + | |1|Female| |
| - | 2 Unknown (?) | + | |2|Unknown (?)| |
| 2 is seen in table creature_model_info notably. | 2 is seen in table creature_model_info notably. | ||
| - | level | + | ==== level ==== |
| The level of the character. | The level of the character. | ||
| - | xp | + | ==== xp ==== |
| The amount of experience this character has earned towards the next level. | The amount of experience this character has earned towards the next level. | ||
| - | money | + | ==== money ==== |
| The amount of copper this character has. | The amount of copper this character has. | ||
| - | skin | + | ==== skin ==== |
| Contains data about the skincolor of the character. skinColor = playerbytes | Contains data about the skincolor of the character. skinColor = playerbytes | ||
| - | face | + | ==== face ==== |
| Contains data about the facestyle of the character. faceStyle = (playerbytes >> 8) % 256 | Contains data about the facestyle of the character. faceStyle = (playerbytes >> 8) % 256 | ||
| - | hairStyle | + | ==== hairStyle |
| Contains data about the hairStyle of the character. hairStyle = (playerbytes >> 16) % 256 | Contains data about the hairStyle of the character. hairStyle = (playerbytes >> 16) % 256 | ||
| - | hairColor | + | ==== hairColor |
| Contains data about the haircolor of the character. hairColor = (playerbytes >> 24) % 256 | Contains data about the haircolor of the character. hairColor = (playerbytes >> 24) % 256 | ||
| - | facialStyle | + | ==== facialStyle |
| Contains data about facial hair of the character. facialHair = playerBytes2 % 256 | Contains data about facial hair of the character. facialHair = playerBytes2 % 256 | ||
| - | bankSlots | + | ==== bankSlots |
| field-no-description|15 | field-no-description|15 | ||
| - | restState | + | ==== restState |
| field-no-description|16 | field-no-description|16 | ||
| - | playerFlags | + | ==== playerFlags |
| A 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. | A 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. | ||
| - | Flag Name Comment | + | ^Flag^ ^Name^Comment^ |
| - | 1 0x00000001 PLAYER_FLAGS_GROUP_LEADER | + | |1|0x00000001|PLAYER_FLAGS_GROUP_LEADER| | |
| - | 2 0x00000002 PLAYER_FLAGS_AFK | + | |2|0x00000002|PLAYER_FLAGS_AFK| | |
| - | 4 0x00000004 PLAYER_FLAGS_DND | + | |4|0x00000004|PLAYER_FLAGS_DND| | |
| - | 8 0x00000008 PLAYER_FLAGS_GM | + | |8|0x00000008|PLAYER_FLAGS_GM| | |
| - | 16 0x00000010 PLAYER_FLAGS_GHOST | + | |16|0x00000010|PLAYER_FLAGS_GHOST| | |
| - | 32 0x00000020 PLAYER_FLAGS_RESTING | + | |32|0x00000020|PLAYER_FLAGS_RESTING| | |
| - | 64 0x00000040 PLAYER_FLAGS_UNK7 | + | |64|0x00000040|PLAYER_FLAGS_UNK7| | |
| - | 128 0x00000080 PLAYER_FLAGS_UNK8 pre-3.0.3 PLAYER_FLAGS_FFA_PVP flag for FFA PVP state | + | |128|0x00000080|PLAYER_FLAGS_UNK8|pre-3.0.3 PLAYER_FLAGS_FFA_PVP flag for FFA PVP state| |
| - | 256 0x00000100 PLAYER_FLAGS_CONTESTED_PVP Player has been involved in a PvP combat and will be attacked by contested guards | + | |256|0x00000100|PLAYER_FLAGS_CONTESTED_PVP|Player has been involved in a PvP combat and will be attacked by contested guards| |
| - | 512 0x00000200 PLAYER_FLAGS_IN_PVP | + | |512|0x00000200|PLAYER_FLAGS_IN_PVP| | |
| - | 1024 0x00000400 PLAYER_FLAGS_HIDE_HELM | + | |1024|0x00000400|PLAYER_FLAGS_HIDE_HELM| | |
| - | 2048 0x00000800 PLAYER_FLAGS_HIDE_CLOAK | + | |2048|0x00000800|PLAYER_FLAGS_HIDE_CLOAK| | |
| - | 4096 0x00001000 PLAYER_FLAGS_PLAYED_LONG_TIME played long time | + | |4096|0x00001000|PLAYER_FLAGS_PLAYED_LONG_TIME|played long time| |
| - | 8192 0x00002000 PLAYER_FLAGS_TOO_LONG played too long time | + | |8192|0x00002000|PLAYER_FLAGS_TOO_LONG|played too long time| |
| - | 16384 0x00004000 PLAYER_FLAGS_IS_OUT_OF_BOUNDS | + | |16384|0x00004000|PLAYER_FLAGS_IS_OUT_OF_BOUNDS| | |
| - | 32768 0x00008000 PLAYER_FLAGS_DEVELOPER prefix for something? | + | |32768|0x00008000|PLAYER_FLAGS_DEVELOPER|prefix for something?| |
| - | 65536 0x00010000 PLAYER_FLAGS_UNK17 pre-3.0.3 PLAYER_FLAGS_SANCTUARY flag for player entered sanctuary | + | |65536|0x00010000|PLAYER_FLAGS_UNK17|pre-3.0.3 PLAYER_FLAGS_SANCTUARY flag for player entered sanctuary| |
| - | 131072 0x00020000 PLAYER_FLAGS_TAXI_BENCHMARK taxi benchmark mode (on/off) (2.0.1) | + | |131072|0x00020000|PLAYER_FLAGS_TAXI_BENCHMARK|taxi benchmark mode (on/off) (2.0.1)| |
| - | 262144 0x00040000 PLAYER_FLAGS_PVP_TIMER 3.0.2, | + | |262144|0x00040000|PLAYER_FLAGS_PVP_TIMER|3.0.2, pvp timer active (after you disable pvp manually)| |
| - | 524288 0x00080000 PLAYER_FLAGS_UNK20 | + | |524288|0x00080000|PLAYER_FLAGS_UNK20| | |
| - | 1048576 0x00100000 PLAYER_FLAGS_UNK21 | + | |1048576|0x00100000|PLAYER_FLAGS_UNK21| | |
| - | 2097152 0x00200000 PLAYER_FLAGS_UNK22 | + | |2097152|0x00200000|PLAYER_FLAGS_UNK22| | |
| - | 4194304 0x00400000 PLAYER_FLAGS_COMMENTATOR2 | + | |4194304|0x00400000|PLAYER_FLAGS_COMMENTATOR2| | |
| - | 8388608 0x00800000 PLAYER_ALLOW_ONLY_ABILITY used by bladestorm and killing spree | + | |8388608|0x00800000|PLAYER_ALLOW_ONLY_ABILITY|used by bladestorm and killing spree| |
| - | 16777216 0x01000000 PLAYER_FLAGS_UNK25 disabled all melee ability on tab include autoattack | + | |16777216|0x01000000|PLAYER_FLAGS_UNK25|disabled all melee ability on tab include autoattack| |
| - | 33554432 0x02000000 PLAYER_FLAGS_NO_XP_GAIN | + | |33554432|0x02000000|PLAYER_FLAGS_NO_XP_GAIN| | |
| - | position_x | + | |
| + | ==== position_x | ||
| The x position of the character' | The x position of the character' | ||
| - | position_y | + | ==== position_y |
| The y position of the character' | The y position of the character' | ||
| - | position_z | + | ==== position_z |
| The z position of the character' | The z position of the character' | ||
| - | map | + | ==== map ==== |
| The map ID the character is in. | The map ID the character is in. | ||
| - | instance_id | + | ==== instance_id |
| The instance ID the character is currently in and bound to. | The instance ID the character is currently in and bound to. | ||
| - | instance_mode_mask | + | ==== instance_mode_mask |
| The 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. | The 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. | ||
| - | Flag Comment | + | ^Flag^Comment^ |
| - | 0 Normal | + | |0|Normal| |
| - | 1 Heroic | + | |1|Heroic| |
| - | 16 10 man | + | |16|10 man| |
| - | 32 25 man | + | |32|25 man| |
| - | orientation | + | |
| + | ==== orientation | ||
| The orientation the character is facing. (North = 0.0, South = 3.14159) | The orientation the character is facing. (North = 0.0, South = 3.14159) | ||
| - | taximask | + | ==== taximask |
| Known taxi nodes separated with space. | Known taxi nodes separated with space. | ||
| - | online | + | ==== online |
| Records whether the character is online (1) or offline (0). | Records whether the character is online (1) or offline (0). | ||
| - | cinematic | + | ==== cinematic |
| Boolean 1 or 0 controlling whether the start cinematic has been shown or not. | Boolean 1 or 0 controlling whether the start cinematic has been shown or not. | ||
| - | totaltime | + | ==== totaltime |
| The total time that the character has been active in the world, measured in seconds. | The total time that the character has been active in the world, measured in seconds. | ||
| - | leveltime | + | ==== leveltime |
| The total time the character has spent in the world at the current level, measured in seconds. | The total time the character has spent in the world at the current level, measured in seconds. | ||
| - | logout_time | + | ==== logout_time |
| The time when the character last logged out, measured in Unix time. | The time when the character last logged out, measured in Unix time. | ||
| - | is_logout_resting | + | ==== is_logout_resting |
| Boolean 1 or 0 controlling if the character is currently in a resting zone or not. | Boolean 1 or 0 controlling if the character is currently in a resting zone or not. | ||
| - | rest_bonus | + | ==== rest_bonus |
| The cumulated bonus of rested rate for gaining experience. | The cumulated bonus of rested rate for gaining experience. | ||
| - | resettalents_cost | + | ==== resettalents_cost |
| The cost for the character to reset its talents, measured in copper. | The cost for the character to reset its talents, measured in copper. | ||
| - | resettalents_time | + | ==== resettalents_time |
| field-no-description|34 | field-no-description|34 | ||
| - | trans_x | + | ==== trans_x |
| The x position of the transport this character was on when they were last saved. | The x position of the transport this character was on when they were last saved. | ||
| - | trans_y | + | ==== trans_y |
| The y position of the transport this character was on when they were last saved. | The y position of the transport this character was on when they were last saved. | ||
| - | trans_z | + | ==== trans_z |
| The z position of the transport this character was on when they were last saved. | The z position of the transport this character was on when they were last saved. | ||
| - | trans_o | + | ==== trans_o |
| The orientation of the transport this character was on when they were last saved. | The orientation of the transport this character was on when they were last saved. | ||
| - | transguid | + | ==== transguid |
| The global unique identifier of the transport this character was on when they were last saved. | The global unique identifier of the transport this character was on when they were last saved. | ||
| - | extra_flags | + | ==== extra_flags |
| These flags control certain player specific attributes, mostly GM features. | These flags control certain player specific attributes, mostly GM features. | ||
| - | Flag Name Description | + | ^Flag^ ^Name^Description^ |
| - | 1 0x00000001 PLAYER_EXTRA_GM_ON Defines GM state | + | |1|0x00000001|PLAYER_EXTRA_GM_ON|Defines GM state| |
| - | 2 0x00000002 PLAYER_EXTRA_GM_ACCEPT_TICKETS NO LONGER USED Defines if tickets are accepted | + | |2|0x00000002|PLAYER_EXTRA_GM_ACCEPT_TICKETS|NO LONGER USED Defines if tickets are accepted| |
| - | 4 0x00000004 PLAYER_EXTRA_ACCEPT_WHISPERS Defines if whispers are accepted | + | |4|0x00000004|PLAYER_EXTRA_ACCEPT_WHISPERS|Defines if whispers are accepted| |
| - | 8 0x00000008 PLAYER_EXTRA_TAXICHEAT Sets taxicheat | + | |8|0x00000008|PLAYER_EXTRA_TAXICHEAT|Sets taxicheat| |
| - | 16 0x00000010 PLAYER_EXTRA_GM_INVISIBLE Defines GM visibility | + | |16|0x00000010|PLAYER_EXTRA_GM_INVISIBLE|Defines GM visibility| |
| - | 32 0x00000020 PLAYER_EXTRA_GM_CHAT Show GM badge in chat messages | + | |32|0x00000020|PLAYER_EXTRA_GM_CHAT|Show GM badge in chat messages| |
| - | 64 0x00000040 PLAYER_EXTRA_HAS_310_FLYER Marks if player already has 310% speed flying mount | + | |64|0x00000040|PLAYER_EXTRA_HAS_310_FLYER|Marks if player already has 310% speed flying mount| |
| - | 256 0x00000100 PLAYER_EXTRA_PVP_DEATH Store PvP death status until corpse creating | + | |256|0x00000100|PLAYER_EXTRA_PVP_DEATH|Store PvP death status until corpse creating| |
| - | stable_slots | + | |
| + | ==== stable_slots | ||
| The Stable Slots available (bought) at the Stable Master. | The Stable Slots available (bought) at the Stable Master. | ||
| - | at_login | + | ==== at_login |
| This field is a bitmask controlling different actions taken once a player logs in with the character. | This field is a bitmask controlling different actions taken once a player logs in with the character. | ||
| - | Flag Name Description | + | ^Flag^ ^Name^Description^ |
| - | 1 0x01 AT_LOGIN_RENAME Force character to change name | + | |1|0x01|AT_LOGIN_RENAME|Force character to change name| |
| - | 2 0x02 AT_LOGIN_RESET_SPELLS Reset spells (professions as well) | + | |2|0x02|AT_LOGIN_RESET_SPELLS|Reset spells (professions as well)| |
| - | 4 0x04 AT_LOGIN_RESET_TALENTS Reset talents | + | |4|0x04|AT_LOGIN_RESET_TALENTS|Reset talents| |
| - | 8 0x08 AT_LOGIN_CUSTOMIZE Customize Characters | + | |8|0x08|AT_LOGIN_CUSTOMIZE|Customize Characters| |
| - | 16 0x10 AT_LOGIN_RESET_PET_TALENTS Reset pet talents | + | |16|0x10|AT_LOGIN_RESET_PET_TALENTS|Reset pet talents| |
| - | 32 0x20 AT_LOGIN_FIRST Set at and removed after first login | + | |32|0x20|AT_LOGIN_FIRST|Set at and removed after first login| |
| - | 64 0x40 AT_LOGIN_CHANGE_FACTION Faction change | + | |64|0x40|AT_LOGIN_CHANGE_FACTION|Faction change| |
| - | 128 0x80 AT_LOGIN_CHANGE_RACE Race change | + | |128|0x80|AT_LOGIN_CHANGE_RACE|Race change| |
| - | For multiple actions, add values together. | + | |
| + | |||
| + | ==== zone ==== | ||
| - | zone | ||
| The zone ID the character is in. | The zone ID the character is in. | ||
| - | death_expire_time | + | ==== death_expire_time |
| Time when a character can be resurrected in case of a server crash or client exit while in ghost form, measured in Unix time. | Time when a character can be resurrected in case of a server crash or client exit while in ghost form, measured in Unix time. | ||
| - | taxi_path | + | ==== taxi_path |
| Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. | Stores the players current taxi path (TaxiPath.dbc) if logged off while on one. | ||
| - | arenaPoints | + | ==== arenaPoints |
| The amount of arena points this character has stored up, and will receive next time arena points are distributed. | The amount of arena points this character has stored up, and will receive next time arena points are distributed. | ||
| - | totalHonorPoints | + | ==== totalHonorPoints |
| The amount of honor points this character has got. | The amount of honor points this character has got. | ||
| - | todayHonorPoints | + | ==== todayHonorPoints |
| The amount of honor points this character has gotten today. | The amount of honor points this character has gotten today. | ||
| - | yesterdayHonorPoints | + | ==== yesterdayHonorPoints |
| The amount of honor points this character got yesterday. | The amount of honor points this character got yesterday. | ||
| - | totalKills | + | ==== totalKills |
| The amount of players this character has killed. | The amount of players this character has killed. | ||
| - | todayKills | + | ==== todayKills |
| The amount of players this character has killed today. | The amount of players this character has killed today. | ||
| - | yesterdayKills | + | ==== yesterdayKills |
| The amount of players this character killed yesterday. | The amount of players this character killed yesterday. | ||
| - | chosenTitle | + | ==== chosenTitle |
| Current title, using the bit_index field (InGameOrder in CharTitles.dbc). | Current title, using the bit_index field (InGameOrder in CharTitles.dbc). | ||
| - | knownCurrencies | + | ==== knownCurrencies |
| Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see CurrencyTypes.dbc. | Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see CurrencyTypes.dbc. | ||
| - | watchedFaction | + | ==== watchedFaction |
| Tracked faction at experience bar (using reputation ID, see Faction.dbc). | Tracked faction at experience bar (using reputation ID, see Faction.dbc). | ||
| - | drunk | + | ==== drunk ==== |
| Character' | Character' | ||
| - | 0 = Sober | + | * 0 = Sober |
| - | 1-49 = Tipsy | + | |
| - | 50-89 = Drunk | + | |
| - | 90-100 = Smashed | + | |
| - | health | + | ==== health |
| The characters current health. | The characters current health. | ||
| - | power | + | ==== power ==== |
| Current character powers (snapshot from when the character was saved). | Current character powers (snapshot from when the character was saved). | ||
| - | Field Power name | + | ^Field^Power name^ |
| - | power1 Mana | + | |power1|Mana| |
| - | power2 Rage | + | |power2|Rage| |
| - | power3 Focus | + | |power3|Focus| |
| - | power4 Energy | + | |power4|Energy| |
| - | power5 Happiness | + | |power5|Happiness| |
| - | power6 Runes | + | |power6|Runes| |
| - | power7 Runic Power | + | |power7|Runic Power| |
| - | latency | + | |
| + | ==== latency | ||
| This characters latency, or ping, in milliseconds, | This characters latency, or ping, in milliseconds, | ||
| - | talentGroupsCount | + | ==== talentGroupsCount |
| The 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). | The 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). | ||
| - | activeTalentGroup | + | ==== activeTalentGroup |
| The currently activated spec for this character, spec = 0 is the first spec, spec = 1 is the second spec. | The currently activated spec for this character, spec = 0 is the first spec, spec = 1 is the second spec. | ||
| - | exploredZones | + | ==== exploredZones |
| Bitmasks of explored zones (1 bit for explored, 0 bit for unexplored). | Bitmasks of explored zones (1 bit for explored, 0 bit for unexplored). | ||
| - | equipmentCache | + | ==== equipmentCache |
| Character' | Character' | ||
| - | ammoId | + | ==== ammoId |
| Template ID of the ammo item. | Template ID of the ammo item. | ||
| - | knownTitles | + | ==== knownTitles |
| Contains 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, | Contains 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, | ||
| - | TitleID UnkRef? | + | ^TitleID^UnkRef?^MaleTitle^FemaleTitle^InGameOrder^ |
| - | 93 0 Archmage %s Archmage %s 61 | + | |93|0|Archmage %s|Archmage %s|61| |
| - | We use the InGameOrder to calculate in which one of the 6 (16bit) integer is the title stored: | + | |
| + | We use the InGameOrder to calculate in which one of the 6 (16bit) integer is the title stored: | ||
| + | < | ||
| InGameOrder / 32 = X | InGameOrder / 32 = X | ||
| 61 / 32 = **1,90625** (1 - Do **NOT** round the value!) | 61 / 32 = **1,90625** (1 - Do **NOT** round the value!) | ||
| + | </ | ||
| so the 1st integer stores the title. Because counting starts from 0 to 5, it would be "0 TITLE_BIT 0 0 0 0". | 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. | Now which bit stores the title? We use modulo to calculate this. | ||
| + | < | ||
| InGameOrder Modulo 32 = X | InGameOrder Modulo 32 = X | ||
| 61 Mod 32 = **29** | 61 Mod 32 = **29** | ||
| + | </ | ||
| 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 536870912 0 0 0 0". | 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 536870912 0 0 0 0". | ||
| - | actionBars | + | ==== actionBars |
| A bitmask that contains visible actionbars for the player. | A bitmask that contains visible actionbars for the player. | ||
| - | Flag Comment | + | ^Flag^ ^Comment^ |
| - | 1 0x00000001 Bottom Left Bar | + | |1|0x00000001|Bottom Left Bar| |
| - | 2 0x00000002 Bottom Right Bar | + | |2|0x00000002|Bottom Right Bar| |
| - | 4 0x00000004 Rigth Bar | + | |4|0x00000004|Rigth Bar| |
| - | 8 0x00000008 Right Bar 2 | + | |8|0x00000008|Right Bar 2| |
| - | grantableLevels | + | |
| + | ==== grantableLevels | ||
| Recruit A Friend stuff. | Recruit A Friend stuff. | ||
| - | order | + | ==== order ==== |
| A field used to change the order in which the characters appear in the character selection screen. The order field is used first, then the characters.guid, | A field used to change the order in which the characters appear in the character selection screen. The order field is used first, then the characters.guid, | ||
| - | creation_date | + | ==== creation_date |
| Character' | Character' | ||
| - | deleteInfos_Account | + | ==== deleteInfos_Account |
| Stores the account id if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. | Stores the account id if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. | ||
| - | deleteInfos_Name | + | ==== deleteInfos_Name |
| Stores the name of character 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. | ||
| - | deleteDate | + | ==== deleteDate |
| Stores the date when the character was deleted and CharDelete.Method in worldserver.conf.dist is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf.dist. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. | Stores the date when the character was deleted and CharDelete.Method in worldserver.conf.dist is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf.dist. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. | ||
数据库/characters数据库/characters.1695526218.txt.gz · 最后更改: 2023/09/24 11:30 由 admin