Character data

Материал из YTDB DataBase

The following is a table containing indices and what values they contain for character.data. The source of this data is UpdateFields.h

The .getvalue and .setvalue commands deal with the indices in this table. To modify any of the values in this table in real time, use the .setvalue command with the correct index (eg. .setvalue 4 2 0 sets the target's size to 2.00 (notice that it is a float, hence the 0 at the end)).

All objects in the game (game objects, creatures, and players) share the OBJECT_* fields while only creatures and players share the UNIT_* fields while only players use the PLAYER_* fields.

If you want to use direct SQL to extract a single value from this rather large blob, the syntax to use is this:

SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', <index + 1>), ' ', -1) AS UNSIGNED) AS `fieldName` FROM `characters`;

Just replace <index + 1> with the index in this table and add one to it.
The reason why you are adding one is because of how the nested SUBSTRING_INDEX syntax works. Let's analyze the function calls. Working from the inside out, the first function called is SUBSTRING_INDEX(`data`, ' ', <index + 1>). The SUBSTRING_INDEX function creates a substring from the big data blob after <index + 1> spaces. Notice that if we used just <index>, the substring would be everything up to the value we want but not including it. The second function call is SUBSTRING_INDEX(<substring from inner function>, ' ', -1). This function call uses -1 as the count, meaning that it will substring from the end to the front. Since it is a count of one, it will create a substring that is exactly the value we want because the value we want is sandwiched between the end of the string and a space. The final function call CAST(<substring> AS UNSIGNED) casts the final string into an unsigned integer. This is because the data blob contains only numbers and if we cast the string into an integer, we can use integer operations on it (say if we use it in a WHERE clause to compare to another integer).

An example of the syntax in use is the following query where we are making a list of characters and their levels who have more than 1000 gold.

SELECT `guid`, `name`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) AS `level` FROM `characters` 
   WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1398), ' ', -1) AS UNSIGNED) > 10000000;

If you want to edit the value of one of these fields, the query to do that is the following but don't forget to backup your table first:

UPDATE `characters` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', <index>) AS CHAR), ' ', <value>, ' ', 
   CAST(SUBSTRING_INDEX(`data`, ' ', <-(max index - index) - 1>)AS CHAR)) [WHERE ...]

Replace "<index>" with the index that you want to change (look at table below), "<-(max index - index) -1>" with the negative of the subtraction of the last index (look at table) minus the index that you want to change and finally minus one. Finally replace "<value>" with the new value you want to put.

For example, to reset gold to zero for all characters with level higher than 70, you can use the following query:

UPDATE `characters` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 1397) AS CHAR), ' ', 0, ' ',
CAST(SUBSTRING_INDEX(`data`, ' ', -131) AS CHAR)) WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX
(`data`, ' ', 35), ' ', -1) AS UNSIGNED) > 70; 

Again, don't forget to backup first!!

3.0.3 Character Data Table

This table was last updated for 3.0.3 values. (Some indexs for 3.1.3 (MANGOS_494))

PLAYER_STATE_NONE              = 0
PLAYER_STATE_SIT               = 1
PLAYER_STATE_SIT_CHAIR         = 2
PLAYER_STATE_SLEEP             = 3
PLAYER_STATE_SIT_LOW_CHAIR     = 4
PLAYER_STATE_SIT_MEDIUM_CHAIR  = 5
PLAYER_STATE_SIT_HIGH_CHAIR    = 6
PLAYER_STATE_DEAD              = 7
PLAYER_STATE_KNEEL             = 8

PLAYER_STATE_FORM_ALL          = 0x00FF0000

PLAYER_STATE_FLAG_ALWAYS_STAND = 0x01             // byte 4
PLAYER_STATE_FLAG_CREEP        = 0x02000000
PLAYER_STATE_FLAG_UNTRACKABLE  = 0x04000000
PLAYER_STATE_FLAG_ALL          = 0xFF000000

SHEATH_STATE_UNARMED  = 0 // non prepared weapon
SHEATH_STATE_MELEE    = 1 // prepared melee weapon
SHEATH_STATE_RANGED   = 2 // prepared ranged weapon

UNIT_BYTE2_FLAG_PVP         = 0x01
UNIT_BYTE2_FLAG_UNK1        = 0x02
UNIT_BYTE2_FLAG_FFA_PVP     = 0x04
UNIT_BYTE2_FLAG_SANCTUARY   = 0x08
UNIT_BYTE2_FLAG_UNK4        = 0x10
UNIT_BYTE2_FLAG_UNK5        = 0x20
UNIT_BYTE2_FLAG_UNK6        = 0x40
UNIT_BYTE2_FLAG_UNK7        = 0x80

UNIT_RENAME_NOT_ALLOWED = 0x02
UNIT_RENAME_ALLOWED     = 0x03

FORM_NONE               = 0x00
FORM_CAT                = 0x01
FORM_TREE               = 0x02
FORM_TRAVEL             = 0x03
FORM_AQUA               = 0x04
FORM_BEAR               = 0x05
FORM_AMBIENT            = 0x06
FORM_GHOUL              = 0x07
FORM_DIREBEAR           = 0x08
FORM_CREATUREBEAR       = 0x0E
FORM_CREATURECAT        = 0x0F
FORM_GHOSTWOLF          = 0x10
FORM_BATTLESTANCE       = 0x11
FORM_DEFENSIVESTANCE    = 0x12
FORM_BERSERKERSTANCE    = 0x13
FORM_TEST               = 0x14
FORM_ZOMBIE             = 0x15
FORM_METAMORPHOSIS      = 0x16
FORM_FLIGHT_EPIC        = 0x1B
FORM_SHADOW             = 0x1C
FORM_FLIGHT             = 0x1D
FORM_STEALTH            = 0x1E
FORM_MOONKIN            = 0x1F
FORM_SPIRITOFREDEMPTION = 0x20

rested = 0x01
normal = 0x02

2.4.1 Character Data Table

This table was last updated for 2.4.1 values.

(с)udbwiki