characters (table)

Back-to:Characters

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



activesp data-base-url=confluenceTdpec

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(pregunta)

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_FL