From dce37f458a8803742893549586adcbf6c7c0ff04 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 4 Mar 2019 17:19:06 +0100 Subject: Fix characters table --- docs/characters.md | 1658 +++++++++++++++++++++++++++++++++++++++++++-- docs/characters_table_.md | 1583 ------------------------------------------- 2 files changed, 1583 insertions(+), 1658 deletions(-) delete mode 100644 docs/characters_table_.md (limited to 'docs') diff --git a/docs/characters.md b/docs/characters.md index 68a472f..ea770fe 100644 --- a/docs/characters.md +++ b/docs/characters.md @@ -1,75 +1,1583 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [characters](characters) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Account | int(10) unsigned | -Name | varchar(12) | -Race | tinyint(3) unsigned | -Class | tinyint(3) unsigned | -Gender | tinyint(3) unsigned | -Level | tinyint(3) unsigned | -Xp | int(10) unsigned | -Money | int(10) unsigned | -PlayerBytes | int(10) unsigned | -PlayerBytes2 | int(10) unsigned | -PlayerFlags | int(10) unsigned | -Position_x | float | -Position_y | float | -Position_z | float | -Map | smallint(5) unsigned | -Instance_id | int(10) unsigned | -Instance_mode_mask | tinyint(3) unsigned | -Orientation | float | -Taximask | text | -Online | tinyint(3) unsigned | -Cinematic | tinyint(3) unsigned | -Totaltime | int(10) unsigned | -Leveltime | int(10) unsigned | -Logout_time | int(10) unsigned | -Is_logout_resting | tinyint(3) unsigned | -Rest_bonus | float | -Resettalents_cost | int(10) unsigned | -Resettalents_time | int(10) unsigned | -Trans_x | float | -Trans_y | float | -Trans_z | float | -Trans_o | float | -Transguid | mediumint(8) unsigned | -Extra_flags | smallint(5) unsigned | -Stable_slots | tinyint(3) unsigned | -At_login | smallint(5) unsigned | -Zone | smallint(5) unsigned | -Death_expire_time | int(10) unsigned | -Taxi_path | text | -ArenaPoints | int(10) unsigned | -TotalHonorPoints | int(10) unsigned | -TodayHonorPoints | int(10) unsigned | -YesterdayHonorPoints | int(10) unsigned | -TotalKills | int(10) unsigned | -TodayKills | smallint(5) unsigned | -YesterdayKills | smallint(5) unsigned | -ChosenTitle | int(10) unsigned | -KnownCurrencies | bigint(20) unsigned | -WatchedFaction | int(10) unsigned | -Drunk | tinyint(3) unsigned | -Health | int(10) unsigned | -Power1 | int(10) unsigned | -Power2 | int(10) unsigned | -Power3 | int(10) unsigned | -Power4 | int(10) unsigned | -Power5 | int(10) unsigned | -Power6 | int(10) unsigned | -Power7 | int(10) unsigned | -Latency | mediumint(8) unsigned | -TalentGroupsCount | tinyint(3) unsigned | -ActiveTalentGroup | tinyint(3) unsigned | -ExploredZones | longtext | -EquipmentCache | longtext | -AmmoId | int(10) unsigned | -KnownTitles | longtext | -ActionBars | tinyint(3) unsigned | -GrantableLevels | tinyint(3) unsigned | -DeleteInfos_Account | int(10) unsigned | -DeleteInfos_Name | varchar(12) | -DeleteDate | int(10) unsigned | +# characters (table) + +[<-Back-to:Characters](database-characters.md) + +**The \`characters\` table** + +This table holds vital static information for each character. This information loaded and used to create the player objects in-game. + +**Structure** + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

Unique

Global Unique Identifier

account

int(10)

unsigned


+

NO

0


+

Account Identifier

name

varchar(12)

signed


+

NO

NULL


+


+

race

tinyint(3)

unsigned


+

NO

0


+


+

class

tinyint(3)

unsigned


+

NO

0


+


+

gender

tinyint(3)

unsigned


+

NO

0


+


+

level

tinyint(3)

unsigned


+

NO

0


+


+

xp

int(10)

unsigned


+

NO

0


+


+

money

int(10)

unsigned


+

NO

0


+


+

playerBytes

int(10)

unsigned


+

NO

0


+


+

playerBytes2

int(10)

unsigned


+

NO

0


+


+

playerFlags

int(10)

unsigned


+

NO

0


+


+

position_x

float

signed


+

NO

0


+


+

position_y

float

signed


+

NO

0


+


+

position_z

float

signed


+

NO

0


+


+

map

smallint(5)

unsigned


+

NO

0


+

Map Identifier

instance_id

int(10)

unsigned


+

NO

0


+


+

instance_mode_mask

tinyint(3)

unsigned


+

NO

0


+


+

orientation

float

signed


+

NO

0


+


+

taximask

text

signed


+

NO

NULL


+


+

online

tinyint(3)

unsigned


+

NO

0


+


+

cinematic

tinyint(3)

unsigned


+

NO

0


+


+

totaltime

int(10)

unsigned


+

NO

0


+


+

leveltime

int(10)

unsigned


+

NO

0


+


+

logout_time

int(10)

unsigned


+

NO

0


+


+

is_logout_resting

tinyint(3)

unsigned


+

NO

0


+


+

rest_bonus

float

signed


+

NO

0


+


+

resettalents_cost

int(10)

unsigned


+

NO

0


+


+

resettalents_time

int(0)

unsigned


+

NO

0


+


+

trans_x

float

signed


+

NO

0


+


+

trans_y

float

signed


+

NO

0


+


+

trans_z

float

signed


+

NO

0


+


+

trans_o

float

signed


+

NO

0


+


+

transguid

mediumint(8)

unsigned


+

NO

0


+


+

extra_flags

smallint(5)

unsigned


+

NO

0


+


+

stable_slots

tinyint(3)

unsigned


+

NO

0


+


+

at_login

smallint(5)

unsigned


+

NO

0


+


+

zone

smallint(5)

unsigned


+

NO

0


+


+

death_expire_time

int(10)

unsigned


+

NO

0


+


+

taxi_path

text

signed


+

YES

NULL


+


+

arenaPoints

int(10)

unsigned


+

NO

0


+


+

totalHonorPoints

int(10)

unsigned


+

NO

0


+


+

todayHonorPoints

int(10)

unsigned


+

NO

0


+


+

yesterdayHonorPoints

int(10)

unsigned


+

NO

0


+


+

totalKills

int(10)

unsigned


+

NO

0


+


+

todayKills

smallint(5)

unsigned


+

NO

0


+


+

yesterdayKills

smallint(5)

unsigned


+

NO

0


+


+

chosenTitle

int(10)

unsigned


+

NO

0


+


+

knownCurrencies

bigint(20)

unsigned


+

NO

0


+


+

watchedFaction

int(10)

unsigned


+

NO

0


+


+

drunk

tinyint(3)

unsigned


+

NO

0


+


+

health

int(10)

unsigned


+

NO

0


+


+

power1

int(10)

unsigned


+

NO

0


+


+

power2

int(10)

unsigned


+

NO

0


+


+

power3

int(10)

unsigned


+

NO

0


+


+

power4

int(10)

unsigned


+

NO

0


+


+

power5

int(10)

unsigned


+

NO

0


+


+

power6

int(10)

unsigned


+

NO

0


+


+

power7

int(10)

unsigned


+

NO

0


+


+

latency

mediumint(8)

unsigned


+

NO

0


+


+

speccount

tinyint(3)

unsigned


+

NO

1


+


+

+

exploredZones

longtext

signed


+

YES


+


+


+

equipmentCache

longtext

signed


+

YES


+


+


+

ammoId

int(10)

unsigned


+

NO

0


+


+

knownTitles

longtext

signed


+

YES


+


+


+

actionBars

tinyint(3)

unsigned


+

NO

0


+


+

grantableLevels

tinyint(3)

unsigned


+

NO

0


+


+

deleteInfos_Account

int(10)

unsigned


+

YES

NULL


+


+

deleteInfos_Name

varchar(12)

unsigned


+

YES

NULL


+


+

deleteDate

int(10)

signed


+

YES

NULL


+


+

+ +**Description of the fields** + +### guid + +The character global unique identifier. This number must be unique and is the best way to identify separate characters. + +### account + +The account ID in which this character resides. See [account.id](account_2130004.html#account-id). in the auth database. + +### name + +The name of the character. + +### race + +The race of the character. See [ChrRaces.dbc](ChrRaces) + +### class + +The class of the character: [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrClasses) + +### gender + +The gender of the character. 0 = Male, 1 = Female, 2 = Unknown![(question)](images/icons/emoticons/help_16.png){.emoticon .emoticon-question} + +### level + +The level of the character. + +### xp + +The amount of experience this character has earned towards the next level. + +### money + +The amount of copper this character has. + +### playerBytes + +contains data about the skincolor,facestyle,hairstyle and haircolor of the character + +- skinColor = playerbytes  % 256 +- faceStyle = (playerbytes >> 8) % 256 +- hairStyle = (playerbytes >> 16) % 256 +- hairColor = (playerbytes >> 24) % 256 + +### playerBytes2 + +data about facial hair + +- facialHair = playerBytes2 % 256 + +### 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. + + +++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Flag

Name

Comment

1

0x00000001

PLAYER_FLAGS_GROUP_LEADER

2

0x00000002

PLAYER_FLAGS_AFK

4

0x00000004

PLAYER_FLAGS_DND

8

0x00000008

PLAYER_FLAGS_GM

16

0x00000010

PLAYER_FLAGS_GHOST

32

0x00000020

PLAYER_FLAGS_RESTING

64

0x00000040

PLAYER_FLAGS_UNK7

128

0x00000080

PLAYER_FLAGS_UNK8

256

0x00000100

PLAYER_FLAGS_CONTESTED_PVP

512

0x00000200

PLAYER_FLAGS_IN_PVP

1024

0x00000400

PLAYER_FLAGS_HIDE_HELM

2048

0x00000800

PLAYER_FLAGS_HIDE_CLOAK

4096

0x00001000

PLAYER_FLAGS_PLAYED_LONG_TIME

8192

0x00002000

PLAYER_FLAGS_TOO_LONG

16384

0x00004000

PLAYER_FLAGS_IS_OUT_OF_BOUNDS

32768

0x00008000

PLAYER_FLAGS_DEVELOPER

65536

0x00010000

PLAYER_FLAGS_UNK17

131072

0x00020000

PLAYER_FLAGS_TAXI_BENCHMARK

262144

0x00040000

PLAYER_FLAGS_PVP_TIMER

524288

0x00080000

PLAYER_FLAGS_UNK20

1048576

0x00100000

PLAYER_FLAGS_UNK21

2097152

0x00200000

PLAYER_FLAGS_UNK22

4194304

0x00400000

PLAYER_FLAGS_COMMENTATOR2

8388608

0x00800000

PLAYER_ALLOW_ONLY_ABILITY

16777216

0x01000000

PLAYER_FLAGS_UNK25

54432

0x02000000

PLAYER_FLAGS_NO_XP_GAIN

+ +### position\_x + +The x position of the character's location. + +### position\_y + +The y position of the character's location. + +### position\_z + +The z position of the character's location. + +### map + +The map ID the character is in. + +### instance\_id + +The instance ID the character is currently in and bound to + +### 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. + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + +

Flag

Comment

0

Normal

1

Heroic

16

10 man

32

25 man

+ +### orientation + +The orientation the character is facing. (North = 0.0, South = 3.14159) + +### taximask + +Known taxi nodes separated with space + +### online + +Records whether the character is online (1) or offline (0). + +### cinematic + +Boolean 1 or 0 controlling whether the start cinematic has been shown or not. + +### totaltime + +The total time that the character has been active in the world, measured in seconds. + +### leveltime + +The total time the character has spent in the world at the current level, measured in seconds. + +### logout\_time + +The time when the character last logged out, measured in Unix time. + +### is\_logout\_resting + +Boolean 1 or 0 controlling if the character is currently in a resting zone or not. + +### rest\_bonus + +The cumulated bonus of rested rate for gaining experience. + +### resettalents\_cost + +The cost for the character to reset its talents, measured in copper. + +### resettalents\_time + +`field-no-description|30` + +### trans\_x + +The x position of the transport this character was on when they were last saved. + +### trans\_y + +The y position of the transport this character was on when they were last saved. + +### trans\_z + +The z position of the transport this character was on when they were last saved. + +### trans\_o + +The orientation of the transport this character was on when they were last saved. + +### transguid + +The global unique identifier of the transport this character was on when they were last saved. + +### extra\_flags + +These flags control certain player specific attributes, mostly GM features + + +++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Flag

Name

Description

1

0x00000001

PLAYER_EXTRA_GM_ON

2

0x00000002

PLAYER_EXTRA_GM_ACCEPT_TICKETS

4

0x00000004

PLAYER_EXTRA_ACCEPT_WHISPERS

8

0x00000008

PLAYER_EXTRA_TAXICHEAT

16

0x00000010

PLAYER_EXTRA_GM_INVISIBLE

32

0x00000020

PLAYER_EXTRA_GM_CHAT

64

0x00000040

PLAYER_EXTRA_HAS_310_FLYER

256

0x00000100

PLAYER_EXTRA_PVP_DEATH

+ +### stable\_slots + +The Stable Slots available (bought) at the Stable Master. + +### at\_login + +This field is a bitmask controlling different actions taken once a player logs in with the character. + +| Flag | Name | Description | +|------|------|--------------------------------| +| 1 | 0x01 | AT\_LOGIN\_RENAME | +| 2 | 0x02 | AT\_LOGIN\_RESET\_SPELLS | +| 4 | 0x04 | AT\_LOGIN\_RESET\_TALENTS | +| 8 | 0x08 | AT\_LOGIN\_CUSTOMIZE | +| 16 | 0x10 | AT\_LOGIN\_RESET\_PET\_TALENTS | +| 32 | 0x20 | AT\_LOGIN\_FIRST | +| 64 | 0x40 | AT\_LOGIN\_CHANGE\_FACTION | +| 128 | 0x80 | AT\_LOGIN\_CHANGE\_RACE | + +For multiple actions, add values together. + +### zone + +The zone ID the character is in. + +### 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. + +### taxi\_path + +Stores the players current taxi path ([TaxiPath.dbc](TaxiPath)) if logged off while on one. + +### arenaPoints + +The amount of arena points this character has stored up, and will receive next time arena points are distributed. + +### totalHonorPoints + +The amount of honor points this character has got + +### todayHonorPoints + +The amount of honor points this character has gotten today + +### yesterdayHonorPoints + +The amount of honor points this character got yesterday + +### totalKills + +The amount of players this character has killed + +### todayKills + +The amount of players this character has killed today + +### yesterdayKills + +The amount of players this character killed yesterday + +### chosenTitle + +Current title, using the bit\_index field (InGameOrder in [CharTitles.dbc](CharTitles)) + +### knownCurrencies + +Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see [CurrencyTypes.dbc](CurrencyTypes) + +### watchedFaction + +Tracked faction at experience bar (using reputation ID, see [Faction.dbc](Faction)) + +### drunk + +Character's drunk state, 0-100 + +- 0 = Sober +- 1-49 = Tipsy +- 50-89 = Drunk +- 90-100 = Smashed + +### health + +The characters current health. + +### power + +Current character powers (snapshot from when the character was saved) + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Power name

power1

Mana

power2

Rage

power3

Focus

power4

Energy

power5

Happiness

power6

Runes

power7

Runic Power

+ +### latency + +This characters latency, or ping, in milliseconds, as of the last update. + +### speccount + +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.) + +### activespec + +The currently activated spec for this character, spec = 0 is the first spec, spec = 1 is the second spec. + +### exploredZones + +Bitmasks of explored zones (1 bit for explored, 0 bit for unexplored) + +### equipmentCache + +`field-no-description|58` + +### ammoId + +[Template ID](item_template_2130222.html#item_template-entry) of the ammo item + +### 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](CharTitles), take Archmage title for example: + + +++++++ + + + + + + + + + + + + + + + + +

TitleID

UnkRef?

MaleTitle

FemaleTitle

InGameOrder

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: + +InGameOrder / 32 = X +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". + +Now which bit stores the title? We use modulo to calculate this. + +InGameOrder Modulo 32 = X +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". + +### actionBars + +A bitmask that contains visible actionbars for the player + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + +

Flag

Comment

1

0x00000001

2

0x00000002

4

0x00000004

8

0x00000008

+ +### grantableLevels + + + +### deleteInfos\_Account + +Stores the account id if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. + +### deleteInfos\_Name + +Stores the name of character if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. + +### deleteDate + +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. + +/ptr data-emoticon-name=/tdconfluenceTd/pp diff --git a/docs/characters_table_.md b/docs/characters_table_.md deleted file mode 100644 index ea770fe..0000000 --- a/docs/characters_table_.md +++ /dev/null @@ -1,1583 +0,0 @@ -# characters (table) - -[<-Back-to:Characters](database-characters.md) - -**The \`characters\` table** - -This table holds vital static information for each character. This information loaded and used to create the player objects in-game. - -**Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

Unique

Global Unique Identifier

account

int(10)

unsigned


-

NO

0


-

Account Identifier

name

varchar(12)

signed


-

NO

NULL


-


-

race

tinyint(3)

unsigned


-

NO

0


-


-

class

tinyint(3)

unsigned


-

NO

0


-


-

gender

tinyint(3)

unsigned


-

NO

0


-


-

level

tinyint(3)

unsigned


-

NO

0


-


-

xp

int(10)

unsigned


-

NO

0


-


-

money

int(10)

unsigned


-

NO

0


-


-

playerBytes

int(10)

unsigned


-

NO

0


-


-

playerBytes2

int(10)

unsigned


-

NO

0


-


-

playerFlags

int(10)

unsigned


-

NO

0


-


-

position_x

float

signed


-

NO

0


-


-

position_y

float

signed


-

NO

0


-


-

position_z

float

signed


-

NO

0


-


-

map

smallint(5)

unsigned


-

NO

0


-

Map Identifier

instance_id

int(10)

unsigned


-

NO

0


-


-

instance_mode_mask

tinyint(3)

unsigned


-

NO

0


-


-

orientation

float

signed


-

NO

0


-


-

taximask

text

signed


-

NO

NULL


-


-

online

tinyint(3)

unsigned


-

NO

0


-


-

cinematic

tinyint(3)

unsigned


-

NO

0


-


-

totaltime

int(10)

unsigned


-

NO

0


-


-

leveltime

int(10)

unsigned


-

NO

0


-


-

logout_time

int(10)

unsigned


-

NO

0


-


-

is_logout_resting

tinyint(3)

unsigned


-

NO

0


-


-

rest_bonus

float

signed


-

NO

0


-


-

resettalents_cost

int(10)

unsigned


-

NO

0


-


-

resettalents_time

int(0)

unsigned


-

NO

0


-


-

trans_x

float

signed


-

NO

0


-


-

trans_y

float

signed


-

NO

0


-


-

trans_z

float

signed


-

NO

0


-


-

trans_o

float

signed


-

NO

0


-


-

transguid

mediumint(8)

unsigned


-

NO

0


-


-

extra_flags

smallint(5)

unsigned


-

NO

0


-


-

stable_slots

tinyint(3)

unsigned


-

NO

0


-


-

at_login

smallint(5)

unsigned


-

NO

0


-


-

zone

smallint(5)

unsigned


-

NO

0


-


-

death_expire_time

int(10)

unsigned


-

NO

0


-


-

taxi_path

text

signed


-

YES

NULL


-


-

arenaPoints

int(10)

unsigned


-

NO

0


-


-

totalHonorPoints

int(10)

unsigned


-

NO

0


-


-

todayHonorPoints

int(10)

unsigned


-

NO

0


-


-

yesterdayHonorPoints

int(10)

unsigned


-

NO

0


-


-

totalKills

int(10)

unsigned


-

NO

0


-


-

todayKills

smallint(5)

unsigned


-

NO

0


-


-

yesterdayKills

smallint(5)

unsigned


-

NO

0


-


-

chosenTitle

int(10)

unsigned


-

NO

0


-


-

knownCurrencies

bigint(20)

unsigned


-

NO

0


-


-

watchedFaction

int(10)

unsigned


-

NO

0


-


-

drunk

tinyint(3)

unsigned


-

NO

0


-


-

health

int(10)

unsigned


-

NO

0


-


-

power1

int(10)

unsigned


-

NO

0


-


-

power2

int(10)

unsigned


-

NO

0


-


-

power3

int(10)

unsigned


-

NO

0


-


-

power4

int(10)

unsigned


-

NO

0


-


-

power5

int(10)

unsigned


-

NO

0


-


-

power6

int(10)

unsigned


-

NO

0


-


-

power7

int(10)

unsigned


-

NO

0


-


-

latency

mediumint(8)

unsigned


-

NO

0


-


-

speccount

tinyint(3)

unsigned


-

NO

1


-


-

-

exploredZones

longtext

signed


-

YES


-


-


-

equipmentCache

longtext

signed


-

YES


-


-


-

ammoId

int(10)

unsigned


-

NO

0


-


-

knownTitles

longtext

signed


-

YES


-


-


-

actionBars

tinyint(3)

unsigned


-

NO

0


-


-

grantableLevels

tinyint(3)

unsigned


-

NO

0


-


-

deleteInfos_Account

int(10)

unsigned


-

YES

NULL


-


-

deleteInfos_Name

varchar(12)

unsigned


-

YES

NULL


-


-

deleteDate

int(10)

signed


-

YES

NULL


-


-

- -**Description of the fields** - -### guid - -The character global unique identifier. This number must be unique and is the best way to identify separate characters. - -### account - -The account ID in which this character resides. See [account.id](account_2130004.html#account-id). in the auth database. - -### name - -The name of the character. - -### race - -The race of the character. See [ChrRaces.dbc](ChrRaces) - -### class - -The class of the character: [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrClasses) - -### gender - -The gender of the character. 0 = Male, 1 = Female, 2 = Unknown![(question)](images/icons/emoticons/help_16.png){.emoticon .emoticon-question} - -### level - -The level of the character. - -### xp - -The amount of experience this character has earned towards the next level. - -### money - -The amount of copper this character has. - -### playerBytes - -contains data about the skincolor,facestyle,hairstyle and haircolor of the character - -- skinColor = playerbytes  % 256 -- faceStyle = (playerbytes >> 8) % 256 -- hairStyle = (playerbytes >> 16) % 256 -- hairColor = (playerbytes >> 24) % 256 - -### playerBytes2 - -data about facial hair - -- facialHair = playerBytes2 % 256 - -### 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. - - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

Name

Comment

1

0x00000001

PLAYER_FLAGS_GROUP_LEADER

2

0x00000002

PLAYER_FLAGS_AFK

4

0x00000004

PLAYER_FLAGS_DND

8

0x00000008

PLAYER_FLAGS_GM

16

0x00000010

PLAYER_FLAGS_GHOST

32

0x00000020

PLAYER_FLAGS_RESTING

64

0x00000040

PLAYER_FLAGS_UNK7

128

0x00000080

PLAYER_FLAGS_UNK8

256

0x00000100

PLAYER_FLAGS_CONTESTED_PVP

512

0x00000200

PLAYER_FLAGS_IN_PVP

1024

0x00000400

PLAYER_FLAGS_HIDE_HELM

2048

0x00000800

PLAYER_FLAGS_HIDE_CLOAK

4096

0x00001000

PLAYER_FLAGS_PLAYED_LONG_TIME

8192

0x00002000

PLAYER_FLAGS_TOO_LONG

16384

0x00004000

PLAYER_FLAGS_IS_OUT_OF_BOUNDS

32768

0x00008000

PLAYER_FLAGS_DEVELOPER

65536

0x00010000

PLAYER_FLAGS_UNK17

131072

0x00020000

PLAYER_FLAGS_TAXI_BENCHMARK

262144

0x00040000

PLAYER_FLAGS_PVP_TIMER

524288

0x00080000

PLAYER_FLAGS_UNK20

1048576

0x00100000

PLAYER_FLAGS_UNK21

2097152

0x00200000

PLAYER_FLAGS_UNK22

4194304

0x00400000

PLAYER_FLAGS_COMMENTATOR2

8388608

0x00800000

PLAYER_ALLOW_ONLY_ABILITY

16777216

0x01000000

PLAYER_FLAGS_UNK25

54432

0x02000000

PLAYER_FLAGS_NO_XP_GAIN

- -### position\_x - -The x position of the character's location. - -### position\_y - -The y position of the character's location. - -### position\_z - -The z position of the character's location. - -### map - -The map ID the character is in. - -### instance\_id - -The instance ID the character is currently in and bound to - -### 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. - - ---- - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

Comment

0

Normal

1

Heroic

16

10 man

32

25 man

- -### orientation - -The orientation the character is facing. (North = 0.0, South = 3.14159) - -### taximask - -Known taxi nodes separated with space - -### online - -Records whether the character is online (1) or offline (0). - -### cinematic - -Boolean 1 or 0 controlling whether the start cinematic has been shown or not. - -### totaltime - -The total time that the character has been active in the world, measured in seconds. - -### leveltime - -The total time the character has spent in the world at the current level, measured in seconds. - -### logout\_time - -The time when the character last logged out, measured in Unix time. - -### is\_logout\_resting - -Boolean 1 or 0 controlling if the character is currently in a resting zone or not. - -### rest\_bonus - -The cumulated bonus of rested rate for gaining experience. - -### resettalents\_cost - -The cost for the character to reset its talents, measured in copper. - -### resettalents\_time - -`field-no-description|30` - -### trans\_x - -The x position of the transport this character was on when they were last saved. - -### trans\_y - -The y position of the transport this character was on when they were last saved. - -### trans\_z - -The z position of the transport this character was on when they were last saved. - -### trans\_o - -The orientation of the transport this character was on when they were last saved. - -### transguid - -The global unique identifier of the transport this character was on when they were last saved. - -### extra\_flags - -These flags control certain player specific attributes, mostly GM features - - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

Name

Description

1

0x00000001

PLAYER_EXTRA_GM_ON

2

0x00000002

PLAYER_EXTRA_GM_ACCEPT_TICKETS

4

0x00000004

PLAYER_EXTRA_ACCEPT_WHISPERS

8

0x00000008

PLAYER_EXTRA_TAXICHEAT

16

0x00000010

PLAYER_EXTRA_GM_INVISIBLE

32

0x00000020

PLAYER_EXTRA_GM_CHAT

64

0x00000040

PLAYER_EXTRA_HAS_310_FLYER

256

0x00000100

PLAYER_EXTRA_PVP_DEATH

- -### stable\_slots - -The Stable Slots available (bought) at the Stable Master. - -### at\_login - -This field is a bitmask controlling different actions taken once a player logs in with the character. - -| Flag | Name | Description | -|------|------|--------------------------------| -| 1 | 0x01 | AT\_LOGIN\_RENAME | -| 2 | 0x02 | AT\_LOGIN\_RESET\_SPELLS | -| 4 | 0x04 | AT\_LOGIN\_RESET\_TALENTS | -| 8 | 0x08 | AT\_LOGIN\_CUSTOMIZE | -| 16 | 0x10 | AT\_LOGIN\_RESET\_PET\_TALENTS | -| 32 | 0x20 | AT\_LOGIN\_FIRST | -| 64 | 0x40 | AT\_LOGIN\_CHANGE\_FACTION | -| 128 | 0x80 | AT\_LOGIN\_CHANGE\_RACE | - -For multiple actions, add values together. - -### zone - -The zone ID the character is in. - -### 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. - -### taxi\_path - -Stores the players current taxi path ([TaxiPath.dbc](TaxiPath)) if logged off while on one. - -### arenaPoints - -The amount of arena points this character has stored up, and will receive next time arena points are distributed. - -### totalHonorPoints - -The amount of honor points this character has got - -### todayHonorPoints - -The amount of honor points this character has gotten today - -### yesterdayHonorPoints - -The amount of honor points this character got yesterday - -### totalKills - -The amount of players this character has killed - -### todayKills - -The amount of players this character has killed today - -### yesterdayKills - -The amount of players this character killed yesterday - -### chosenTitle - -Current title, using the bit\_index field (InGameOrder in [CharTitles.dbc](CharTitles)) - -### knownCurrencies - -Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see [CurrencyTypes.dbc](CurrencyTypes) - -### watchedFaction - -Tracked faction at experience bar (using reputation ID, see [Faction.dbc](Faction)) - -### drunk