Characters SF

From Project Skyfire
Revision as of 14:38, 6 July 2012 by Cheapgamer (talk | contribs) (Created page with "{| align="right" |- | __TOC__ |} {{Back-to:Characters}} <br> <big>'''The `characters` table'''</big> This table holds vital static information for each character. This in...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Back to characters database list of tables.


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 smallint(5) 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
activespec tinyint(3) unsigned NO 0
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. in the auth database.

name

The name of the character.

race

The race of the character. See ChrRaces.dbc

class

The class of the character: ChrClasses.dbc

gender

The gender of the character. 0 = Male, 1 = Female, 2 = Unknown(?)

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 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
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 played long time
8192 0x00002000 PLAYER_FLAGS_TOO_LONG played too long time
16384 0x00004000 PLAYER_FLAGS_IS_OUT_OF_BOUNDS
32768 0x00008000 PLAYER_FLAGS_DEVELOPER <Dev> prefix for something?
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)
262144 0x00040000 PLAYER_FLAGS_PVP_TIMER 3.0.2, pvp timer active (after you disable pvp manually)
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 used by bladestorm and killing spree
16777216 0x01000000 PLAYER_FLAGS_UNK25 disabled all melee ability on tab include autoattack
33554432 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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

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 Defines GM state
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
8 0x00000008 PLAYER_EXTRA_TAXICHEAT Sets taxicheat
16 0x00000010 PLAYER_EXTRA_GM_INVISIBLE Control's GM's invisibly
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
256 0x00000100 PLAYER_EXTRA_PVP_DEATH Store PvP death status until corpse creating

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 Force character to change name
2 0x02 AT_LOGIN_RESET_SPELLS Reset spells (professions as well)
4 0x04 AT_LOGIN_RESET_TALENTS Reset talents
8 0x08 AT_LOGIN_CUSTOMIZE Customize Characters
16 0x10 AT_LOGIN_RESET_PET_TALENTS Reset pet talents
32 0x20 AT_LOGIN_FIRST Set at and removed after first login
64 0x40 AT_LOGIN_CHANGE_FACTION Faction change
128 0x80 AT_LOGIN_CHANGE_RACE Race change

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) 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 got today

yesterdayHonorPoints

The amount of honor points this character has 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 has killed yesterday

chosenTitle

Current title, using the bit_index field (InGameOrder in CharTitles.dbc)

knownCurrencies

Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see CurrencyTypes.dbc

watchedFaction

Tracked faction at experience bar (using reputation ID, see Faction.dbc)

drunk

Character's drunk state, 0-65535

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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

ammoId

Template ID of the ammo item

knownTitles

contains data about known Titles stored in 6 "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 Shattered Sun title for example...

TitleID UnkRef? MaleTitle FemaleTitle InGameOrder
63 6806 %s of the Shattered Sun %s of the Shattered Sun 38

we use the InGameOrder to calculate it: 38/32=1 means you'll have to edit the 2nd integer from left because counting is from 0 to 5 "0 0 0 0 0 0" now that we have selected which integer has the Title stored in we have to calculate in which bit it is stored with modulo 38%32=6 meaning the 7th bit from the right (counting starts from 0, 0000000000000000) will store the Shattered Sun title. This would mean if you only have the Shattered Sun title this row would have: "0 128 0 0 0 0" stored (or simple said 26=128)

actionBars

A bitmask that contains visible actionbars for the player

Flag Comment
1 0x00000001 Bottom Left Bar
2 0x00000002 Bottom Right Bar
4 0x00000004 Rigth Bar
8 0x00000008 Right Bar 2

grantableLevels

{{field-no-description|61))

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 then deleteDate + CharDelete.KeepDays the character will be purged.