Comparación de páginas

...

This table holds vital static information for each character. This information loaded and used to create the player objects in-game.

Panel
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

NO


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

trans_

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

tinyint

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

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

Panel
Description of the fields

...

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.

...

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)

...

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	Defines GM visibility
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.

...

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.

...

Stores the players current taxi path (TaxiPath.dbc) if logged off while on one.

...

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-100

...

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.

...

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, 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:

...

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

...

Versiones comparadas

Versión anterior 72

Nueva versión Actual

Clave

position_x

orientation

stable_slots

knownCurrencies

watchedFaction

drunk

latency

grantableLevels