Description of the data field in the `characters` table

From OregonCore Wiki
Jump to: navigation, search


This Is new version of this field Data_field_TBC version 2.4.3

Note: The characters table in OregonCore has been modified and improved to make much of the information in the data field available without having to use the data field directly. If you are looking for a particular value, please check the current table schema. The data you are looking for may be available in a much simpler query.

The 'character_data' field

The following is a table containing indices and what values they contain for characters.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!! This table was last updated for 2.4.1 values.


Index Value Name Comments
0 OBJECT_FIELD_GUID Character GUID (full GUID includes both index 0 and index 1 as 64bit number)
2 OBJECT_FIELD_TYPE
3 OBJECT_FIELD_ENTRY
4 OBJECT_FIELD_SCALE_X Size of how model appears in-game (float value)
5 OBJECT_FIELD_PADDING
6 UNIT_FIELD_CHARM
8 UNIT_FIELD_SUMMON
10 UNIT_FIELD_CHARMEDBY
12 UNIT_FIELD_SUMMONEDBY
14 UNIT_FIELD_CREATEDBY
16 UNIT_FIELD_TARGET
18 UNIT_FIELD_PERSUADED
20 UNIT_FIELD_CHANNEL_OBJECT
22 UNIT_FIELD_HEALTH Current health
23 UNIT_FIELD_POWER1 Current mana
24 UNIT_FIELD_POWER2 Current rage
25 UNIT_FIELD_POWER3 Current focus
26 UNIT_FIELD_POWER4 Current energy
27 UNIT_FIELD_POWER5 Current happiness
28 UNIT_FIELD_MAXHEALTH Max health
29 UNIT_FIELD_MAXPOWER1 Max mana
30 UNIT_FIELD_MAXPOWER2 Max rage
31 UNIT_FIELD_MAXPOWER3 Max focus
32 UNIT_FIELD_MAXPOWER4 Max energy
33 UNIT_FIELD_MAXPOWER5 Max happiness
34 UNIT_FIELD_LEVEL Character level
35 UNIT_FIELD_FACTIONTEMPLATE Currently used faction template ID (<a href="/index.php/FactionTemplate.dbc" title="FactionTemplate.dbc">FactionTemplate.dbc</a>)
36 UNIT_FIELD_BYTES_0 ( race ) | ( class_ << 8 ) | ( gender << 16 ) | ( powertype << 24 )
37 UNIT_VIRTUAL_ITEM_SLOT_DISPLAY
40 UNIT_VIRTUAL_ITEM_INFO
46 UNIT_FIELD_FLAGS
47 UNIT_FIELD_FLAGS_2
48 UNIT_FIELD_AURA
104 UNIT_FIELD_AURAFLAGS
118 UNIT_FIELD_AURALEVELS
132 UNIT_FIELD_AURAAPPLICATIONS
146 UNIT_FIELD_AURASTATE
147 UNIT_FIELD_BASEATTACKTIME
148 UNIT_FIELD_OFFHANDATTACKTIME
149 UNIT_FIELD_RANGEDATTACKTIME
150 UNIT_FIELD_BOUNDINGRADIUS
151 UNIT_FIELD_COMBATREACH
152 UNIT_FIELD_DISPLAYID Current model ID (can be different from regular if character is morphed, etc)
153 UNIT_FIELD_NATIVEDISPLAYID The native model ID. Model always reverts to this number when player is demorphed.
154 UNIT_FIELD_MOUNTDISPLAYID
155 UNIT_FIELD_MINDAMAGE
156 UNIT_FIELD_MAXDAMAGE
157 UNIT_FIELD_MINOFFHANDDAMAGE
158 UNIT_FIELD_MAXOFFHANDDAMAGE
159 UNIT_FIELD_BYTES_1
160 UNIT_FIELD_PETNUMBER
161 UNIT_FIELD_PET_NAME_TIMESTAMP
162 UNIT_FIELD_PETEXPERIENCE
163 UNIT_FIELD_PETNEXTLEVELEXP
164 UNIT_DYNAMIC_FLAGS
165 UNIT_CHANNEL_SPELL
166 UNIT_MOD_CAST_SPEED
167 UNIT_CREATED_BY_SPELL
168 UNIT_NPC_FLAGS
169 UNIT_NPC_EMOTESTATE
170 UNIT_TRAINING_POINTS
171 UNIT_FIELD_STAT0 Base strength (before any item bonuses)
172 UNIT_FIELD_STAT1 Base agility
173 UNIT_FIELD_STAT2 Base stamina
174 UNIT_FIELD_STAT3 Base intellect
175 UNIT_FIELD_STAT4 Base spirit
176 UNIT_FIELD_POSSTAT0
177 UNIT_FIELD_POSSTAT1
178 UNIT_FIELD_POSSTAT2
179 UNIT_FIELD_POSSTAT3
180 UNIT_FIELD_POSSTAT4
181 UNIT_FIELD_NEGSTAT0
182 UNIT_FIELD_NEGSTAT1
183 UNIT_FIELD_NEGSTAT2
184 UNIT_FIELD_NEGSTAT3
185 UNIT_FIELD_NEGSTAT4
186 UNIT_FIELD_RESISTANCES Base armor (before any item bonuses)
187 Base holy resistance
188 Base fire resistance
189 Base nature resistance
190 Base frost resistance
191 Base shadow resistance
192 Base arcane resistance
193 UNIT_FIELD_RESISTANCEBUFFMODSPOSITIVE
200 UNIT_FIELD_RESISTANCEBUFFMODSNEGATIVE
207 UNIT_FIELD_BASE_MANA
208 UNIT_FIELD_BASE_HEALTH
209 UNIT_FIELD_BYTES_2
210 UNIT_FIELD_ATTACK_POWER
211 UNIT_FIELD_ATTACK_POWER_MODS
212 UNIT_FIELD_ATTACK_POWER_MULTIPLIER
213 UNIT_FIELD_RANGED_ATTACK_POWER
214 UNIT_FIELD_RANGED_ATTACK_POWER_MODS
215 UNIT_FIELD_RANGED_ATTACK_POWER_MULTIPLIER
216 UNIT_FIELD_MINRANGEDDAMAGE
217 UNIT_FIELD_MAXRANGEDDAMAGE
218 UNIT_FIELD_POWER_COST_MODIFIER
225 UNIT_FIELD_POWER_COST_MULTIPLIER
232 UNIT_FIELD_MAXHEALTHMODIFIER
233 UNIT_FIELD_PADDING
234 PLAYER_DUEL_ARBITER
236 PLAYER_FLAGS
237 PLAYER_GUILDID Id of guild the player is in (<a href="/index.php/Guild#guildid" title="Guild">guild.guildid</a>)
238 PLAYER_GUILDRANK The player's rank ID (<a href="/index.php/Guild_rank#rid" title="Guild rank">guild_rank.rid</a>)
239 PLAYER_BYTES (skin | (face << 8) | (hairStyle << 16) | (hairColor << 24))
240 PLAYER_BYTES_2 (facialHair | (beared 0x00 << 8) | (0x00 << 16) | (bankslots 0x02 << 24) |(rested status 0x02 << 32))
241 PLAYER_BYTES_3 gender
242 PLAYER_DUEL_TEAM
243 PLAYER_GUILD_TIMESTAMP
244 PLAYER_QUEST_LOG_1_1
245 PLAYER_QUEST_LOG_1_2
246 PLAYER_QUEST_LOG_1_3
247 PLAYER_QUEST_LOG_1_4
248 PLAYER_QUEST_LOG_2_1
249 PLAYER_QUEST_LOG_2_2
250 PLAYER_QUEST_LOG_2_3
251 PLAYER_QUEST_LOG_2_4
252 PLAYER_QUEST_LOG_3_1
253 PLAYER_QUEST_LOG_3_2
254 PLAYER_QUEST_LOG_3_3
255 PLAYER_QUEST_LOG_3_4
256 PLAYER_QUEST_LOG_4_1
257 PLAYER_QUEST_LOG_4_2
258 PLAYER_QUEST_LOG_4_3
259 PLAYER_QUEST_LOG_4_4
260 PLAYER_QUEST_LOG_5_1
261 PLAYER_QUEST_LOG_5_2
262 PLAYER_QUEST_LOG_5_3
263 PLAYER_QUEST_LOG_5_4
264 PLAYER_QUEST_LOG_6_1
265 PLAYER_QUEST_LOG_6_2
266 PLAYER_QUEST_LOG_6_3
267 PLAYER_QUEST_LOG_6_4
268 PLAYER_QUEST_LOG_7_1
269 PLAYER_QUEST_LOG_7_2
270 PLAYER_QUEST_LOG_7_3
271 PLAYER_QUEST_LOG_7_4
272 PLAYER_QUEST_LOG_8_1
273 PLAYER_QUEST_LOG_8_2
274 PLAYER_QUEST_LOG_8_3
275 PLAYER_QUEST_LOG_8_4
276 PLAYER_QUEST_LOG_9_1
277 PLAYER_QUEST_LOG_9_2
278 PLAYER_QUEST_LOG_9_3
279 PLAYER_QUEST_LOG_9_4
280 PLAYER_QUEST_LOG_10_1
281 PLAYER_QUEST_LOG_10_2
282 PLAYER_QUEST_LOG_10_3
283 PLAYER_QUEST_LOG_10_4
284 PLAYER_QUEST_LOG_11_1
285 PLAYER_QUEST_LOG_11_2
286 PLAYER_QUEST_LOG_11_3
287 PLAYER_QUEST_LOG_11_4
288 PLAYER_QUEST_LOG_12_1
289 PLAYER_QUEST_LOG_12_2
290 PLAYER_QUEST_LOG_12_3
291 PLAYER_QUEST_LOG_12_4
292 PLAYER_QUEST_LOG_13_1
293 PLAYER_QUEST_LOG_13_2
294 PLAYER_QUEST_LOG_13_3
295 PLAYER_QUEST_LOG_13_4
296 PLAYER_QUEST_LOG_14_1
297 PLAYER_QUEST_LOG_14_2
298 PLAYER_QUEST_LOG_14_3
299 PLAYER_QUEST_LOG_14_4
300 PLAYER_QUEST_LOG_15_1
301 PLAYER_QUEST_LOG_15_2
302 PLAYER_QUEST_LOG_15_3
303 PLAYER_QUEST_LOG_15_4
304 PLAYER_QUEST_LOG_16_1
305 PLAYER_QUEST_LOG_16_2
306 PLAYER_QUEST_LOG_16_3
307 PLAYER_QUEST_LOG_16_4
308 PLAYER_QUEST_LOG_17_1
309 PLAYER_QUEST_LOG_17_2
310 PLAYER_QUEST_LOG_17_3
311 PLAYER_QUEST_LOG_17_4
312 PLAYER_QUEST_LOG_18_1
313 PLAYER_QUEST_LOG_18_2
314 PLAYER_QUEST_LOG_18_3
315 PLAYER_QUEST_LOG_18_4
316 PLAYER_QUEST_LOG_19_1
317 PLAYER_QUEST_LOG_19_2
318 PLAYER_QUEST_LOG_19_3
319 PLAYER_QUEST_LOG_19_4
320 PLAYER_QUEST_LOG_20_1
321 PLAYER_QUEST_LOG_20_2
322 PLAYER_QUEST_LOG_20_3
323 PLAYER_QUEST_LOG_20_4
324 PLAYER_QUEST_LOG_21_1
325 PLAYER_QUEST_LOG_21_2
326 PLAYER_QUEST_LOG_21_3
327 PLAYER_QUEST_LOG_21_4
328 PLAYER_QUEST_LOG_22_1
329 PLAYER_QUEST_LOG_22_2
330 PLAYER_QUEST_LOG_22_3
331 PLAYER_QUEST_LOG_22_4
332 PLAYER_QUEST_LOG_23_1
333 PLAYER_QUEST_LOG_23_2
334 PLAYER_QUEST_LOG_23_3
335 PLAYER_QUEST_LOG_23_4
336 PLAYER_QUEST_LOG_24_1
337 PLAYER_QUEST_LOG_24_2
338 PLAYER_QUEST_LOG_24_3
339 PLAYER_QUEST_LOG_24_4
340 PLAYER_QUEST_LOG_25_1
341 PLAYER_QUEST_LOG_25_2
342 PLAYER_QUEST_LOG_25_3
343 PLAYER_QUEST_LOG_25_4
344 PLAYER_VISIBLE_ITEM_1_CREATOR
346 PLAYER_VISIBLE_ITEM_1_0 Item ID equipped on head slot
358 PLAYER_VISIBLE_ITEM_1_PROPERTIES
359 PLAYER_VISIBLE_ITEM_1_PAD
360 PLAYER_VISIBLE_ITEM_2_CREATOR
362 PLAYER_VISIBLE_ITEM_2_0 Item ID equipped on neck slot
374 PLAYER_VISIBLE_ITEM_2_PROPERTIES
375 PLAYER_VISIBLE_ITEM_2_PAD
376 PLAYER_VISIBLE_ITEM_3_CREATOR
378 PLAYER_VISIBLE_ITEM_3_0 Item ID equipped on shoulder slot
390 PLAYER_VISIBLE_ITEM_3_PROPERTIES
391 PLAYER_VISIBLE_ITEM_3_PAD
392 PLAYER_VISIBLE_ITEM_4_CREATOR
394 PLAYER_VISIBLE_ITEM_4_0 Item ID equipped on shirt slot
406 PLAYER_VISIBLE_ITEM_4_PROPERTIES
407 PLAYER_VISIBLE_ITEM_4_PAD
408 PLAYER_VISIBLE_ITEM_5_CREATOR
410 PLAYER_VISIBLE_ITEM_5_0 Item ID equipped on chest slot
422 PLAYER_VISIBLE_ITEM_5_PROPERTIES
423 PLAYER_VISIBLE_ITEM_5_PAD
424 PLAYER_VISIBLE_ITEM_6_CREATOR
426 PLAYER_VISIBLE_ITEM_6_0 Item ID equipped on belt slot
438 PLAYER_VISIBLE_ITEM_6_PROPERTIES
439 PLAYER_VISIBLE_ITEM_6_PAD
440 PLAYER_VISIBLE_ITEM_7_CREATOR
442 PLAYER_VISIBLE_ITEM_7_0 Item ID equipped on legs slot
454 PLAYER_VISIBLE_ITEM_7_PROPERTIES
455 PLAYER_VISIBLE_ITEM_7_PAD
456 PLAYER_VISIBLE_ITEM_8_CREATOR
458 PLAYER_VISIBLE_ITEM_8_0 Item ID equipped on feet slot
470 PLAYER_VISIBLE_ITEM_8_PROPERTIES
471 PLAYER_VISIBLE_ITEM_8_PAD
472 PLAYER_VISIBLE_ITEM_9_CREATOR
474 PLAYER_VISIBLE_ITEM_9_0 Item ID equipped on wrist slot
486 PLAYER_VISIBLE_ITEM_9_PROPERTIES
487 PLAYER_VISIBLE_ITEM_9_PAD
488 PLAYER_VISIBLE_ITEM_10_CREATOR
490 PLAYER_VISIBLE_ITEM_10_0 Item ID equipped on gloves slot
502 PLAYER_VISIBLE_ITEM_10_PROPERTIES
503 PLAYER_VISIBLE_ITEM_10_PAD
504 PLAYER_VISIBLE_ITEM_11_CREATOR
506 PLAYER_VISIBLE_ITEM_11_0 Item ID equipped on finger 1 slot
518 PLAYER_VISIBLE_ITEM_11_PROPERTIES
519 PLAYER_VISIBLE_ITEM_11_PAD
520 PLAYER_VISIBLE_ITEM_12_CREATOR
522 PLAYER_VISIBLE_ITEM_12_0 Item ID equipped on finger 2 slot
534 PLAYER_VISIBLE_ITEM_12_PROPERTIES
535 PLAYER_VISIBLE_ITEM_12_PAD
536 PLAYER_VISIBLE_ITEM_13_CREATOR
538 PLAYER_VISIBLE_ITEM_13_0 Item ID equipped on trinket 1 slot
550 PLAYER_VISIBLE_ITEM_13_PROPERTIES
551 PLAYER_VISIBLE_ITEM_13_PAD
552 PLAYER_VISIBLE_ITEM_14_CREATOR
554 PLAYER_VISIBLE_ITEM_14_0 Item ID equipped on trinket 2 slot
566 PLAYER_VISIBLE_ITEM_14_PROPERTIES
567 PLAYER_VISIBLE_ITEM_14_PAD
568 PLAYER_VISIBLE_ITEM_15_CREATOR
570 PLAYER_VISIBLE_ITEM_15_0 Item ID equipped on back slot
582 PLAYER_VISIBLE_ITEM_15_PROPERTIES
583 PLAYER_VISIBLE_ITEM_15_PAD
584 PLAYER_VISIBLE_ITEM_16_CREATOR
586 PLAYER_VISIBLE_ITEM_16_0 Item ID equipped on main hand slot
598 PLAYER_VISIBLE_ITEM_16_PROPERTIES
599 PLAYER_VISIBLE_ITEM_16_PAD
600 PLAYER_VISIBLE_ITEM_17_CREATOR
602 PLAYER_VISIBLE_ITEM_17_0 Item ID equipped on off hand slot
614 PLAYER_VISIBLE_ITEM_17_PROPERTIES
615 PLAYER_VISIBLE_ITEM_17_PAD
616 PLAYER_VISIBLE_ITEM_18_CREATOR
618 PLAYER_VISIBLE_ITEM_18_0 Item ID equipped on ranged slot
630 PLAYER_VISIBLE_ITEM_18_PROPERTIES
631 PLAYER_VISIBLE_ITEM_18_PAD
632 PLAYER_VISIBLE_ITEM_19_CREATOR
634 PLAYER_VISIBLE_ITEM_19_0 Item ID equipped on tabard
646 PLAYER_VISIBLE_ITEM_19_PROPERTIES
647 PLAYER_VISIBLE_ITEM_19_PAD
648 PLAYER_CHOSEN_TITLE
649 PLAYER_FIELD_PAD_0
650 PLAYER_FIELD_INV_SLOT_HEAD
696 PLAYER_FIELD_PACK_SLOT_1
728 PLAYER_FIELD_BANK_SLOT_1
784 PLAYER_FIELD_BANKBAG_SLOT_1
798 PLAYER_FIELD_VENDORBUYBACK_SLOT_1
822 PLAYER_FIELD_KEYRING_SLOT_1
886 PLAYER_FIELD_VANITYPET_SLOT_1
922 PLAYER_FARSIGHT
924 PLAYER__FIELD_KNOWN_TITLES
926 PLAYER_XP Current XP
927 PLAYER_NEXT_LEVEL_XP XP needed to level up
928 PLAYER_SKILL_INFO_1_1
1312 PLAYER_CHARACTER_POINTS1 Number of unused talent points
1313 PLAYER_CHARACTER_POINTS2 Number of free primary professions
1314 PLAYER_TRACK_CREATURES
1315 PLAYER_TRACK_RESOURCES
1316 PLAYER_BLOCK_PERCENTAGE
1317 PLAYER_DODGE_PERCENTAGE
1318 PLAYER_PARRY_PERCENTAGE
1319 PLAYER_EXPERTISE
1320 PLAYER_OFFHAND_EXPERTISE
1321 PLAYER_CRIT_PERCENTAGE
1322 PLAYER_RANGED_CRIT_PERCENTAGE
1323 PLAYER_OFFHAND_CRIT_PERCENTAGE
1324 PLAYER_SPELL_CRIT_PERCENTAGE1
1331 PLAYER_SHIELD_BLOCK
1332 PLAYER_EXPLORED_ZONES_1
1396 PLAYER_REST_STATE_EXPERIENCE
1397 PLAYER_FIELD_COINAGE Character money (in copper)
1398 PLAYER_FIELD_MOD_DAMAGE_DONE_POS
1405 PLAYER_FIELD_MOD_DAMAGE_DONE_NEG
1412 PLAYER_FIELD_MOD_DAMAGE_DONE_PCT
1419 PLAYER_FIELD_MOD_HEALING_DONE_POS
1420 PLAYER_FIELD_MOD_TARGET_RESISTANCE
1421 PLAYER_FIELD_MOD_TARGET_PHYSICAL_RESISTANCE
1422 PLAYER_FIELD_BYTES
1423 PLAYER_AMMO_ID
1424 PLAYER_SELF_RES_SPELL
1425 PLAYER_FIELD_PVP_MEDALS
1426 PLAYER_FIELD_BUYBACK_PRICE_1
1438 PLAYER_FIELD_BUYBACK_TIMESTAMP_1
1450 PLAYER_FIELD_KILLS
1451 PLAYER_FIELD_TODAY_CONTRIBUTION
1452 PLAYER_FIELD_YESTERDAY_CONTRIBUTION
1453 PLAYER_FIELD_LIFETIME_HONORBALE_KILLS
1454 PLAYER_FIELD_BYTES2
1455 PLAYER_FIELD_WATCHED_FACTION_INDEX
1456 PLAYER_FIELD_COMBAT_RATING_1
1456 PLAYER_FIELD_ALL_WEAPONS_SKILL_RATING
1457 PLAYER_FIELD_DEFENCE_RATING
1458 PLAYER_FIELD_DODGE_RATING
1459 PLAYER_FIELD_PARRY_RATING
1460 PLAYER_FIELD_BLOCK_RATING
1461 PLAYER_FIELD_MELEE_HIT_RATING
1462 PLAYER_FIELD_RANGED_HIT_RATING
1463 PLAYER_FIELD_SPELL_HIT_RATING
1464 PLAYER_FIELD_MELEE_CRIT_RATING
1465 PLAYER_FIELD_RANGED_CRIT_RATING
1472 PLAYER_FIELD_SPELL_CRIT_RATING
1473 PLAYER_FIELD_HIT_TAKEN_MELEE_RATING
1474 PLAYER_FIELD_HIT_TAKEN_RANGED_RATING
1475 PLAYER_FIELD_HIT_TAKEN_SPELL_RATING
1476 PLAYER_FIELD_CRIT_TAKEN_MELEE_RATING
1477 PLAYER_FIELD_CRIT_TAKEN_RANGED_RATING
1478 PLAYER_FIELD_CRIT_TAKEN_SPELL_RATING
1479 PLAYER_FIELD_MELEE_HASTE_RATING
1480 PLAYER_FIELD_RANGED_HASTE_RATING
1481 PLAYER_FIELD_SPELL_HASTE_RATING
1488 PLAYER_FIELD_MELEE_WEAPON_SKILL_RATING
1489 PLAYER_FIELD_OFFHAND_WEAPON_SKILL_RATING
1490 PLAYER_FIELD_RANGED_WEAPON_SKILL_RATING
1491 PLAYER_FIELD_EXPERTISE_RATING
1480 PLAYER_FIELD_ARENA_TEAM_INFO_1_1
1480 PLAYER_FIELD_ARENA_TEAM_ID_2v2
1486 PLAYER_FIELD_ARENA_TEAM_ID_3v3
1498 PLAYER_FIELD_ARENA_TEAM_ID_5v5
1498 PLAYER_FIELD_HONOR_CURRENCY Character total honor points
1499 PLAYER_FIELD_ARENA_CURRENCY Character total arena points
1500 PLAYER_FIELD_MOD_MANA_REGEN
1501 PLAYER_FIELD_MOD_MANA_REGEN_INTERRUPT
1502 PLAYER_FIELD_MAX_LEVEL
1503 PLAYER_FIELD_DAILY_QUESTS_1