database question - The character table data field

Results 1 to 6 of 6
  1. #1
    Enthusiast Fidelite is offline
    MemberRank
    Feb 2007 Join Date
    Canada ... eh!?Location
    33Posts

    database question - The character table data field

    Does anyone know how to decode the data portion of the stored characters? I've found this list on a blog, but I'm not sure if it's applicable / still valid:

    FIELD NAME
    1 OBJECT_FIELD_GUID
    3 OBJECT_FIELD_TYPE
    4 OBJECT_FIELD_ENTRY
    5 OBJECT_FIELD_SCALE_X
    6 OBJECT_FIELD_PADDING
    7 UNIT_FIELD_CHARM
    9 UNIT_FIELD_SUMMON
    11 UNIT_FIELD_CHARMEDBY
    13 UNIT_FIELD_SUMMONEDBY
    15 UNIT_FIELD_CREATEDBY
    17 UNIT_FIELD_TARGET
    19 UNIT_FIELD_PERSUADED
    21 UNIT_FIELD_CHANNEL_OBJECT
    23 UNIT_FIELD_HEALTH
    24 UNIT_FIELD_POWER1
    25 UNIT_FIELD_POWER2
    26 UNIT_FIELD_POWER3
    27 UNIT_FIELD_POWER4
    28 UNIT_FIELD_POWER5
    29 UNIT_FIELD_MAXHEALTH
    30 UNIT_FIELD_MAXPOWER1
    31 UNIT_FIELD_MAXPOWER2
    32 UNIT_FIELD_MAXPOWER3
    33 UNIT_FIELD_MAXPOWER4
    34 UNIT_FIELD_MAXPOWER5
    35 UNIT_FIELD_LEVEL
    36 UNIT_FIELD_FACTIONTEMPLATE
    37 UNIT_FIELD_BYTES_0
    38 UNIT_VIRTUAL_ITEM_SLOT_DISPLAY
    41 UNIT_VIRTUAL_ITEM_INFO
    47 UNIT_FIELD_FLAGS
    48 UNIT_FIELD_AURA
    96 UNIT_FIELD_AURAFLAGS
    102 UNIT_FIELD_AURALEVELS
    114 UNIT_FIELD_AURAAPPLICATIONS
    126 UNIT_FIELD_AURASTATE
    127 UNIT_FIELD_BASEATTACKTIME
    129 UNIT_FIELD_RANGEDATTACKTIME
    130 UNIT_FIELD_BOUNDINGRADIUS
    131 UNIT_FIELD_COMBATREACH
    132 UNIT_FIELD_DISPLAYID
    133 UNIT_FIELD_NATIVEDISPLAYID
    134 UNIT_FIELD_MOUNTDISPLAYID
    135 UNIT_FIELD_MINDAMAGE
    136 UNIT_FIELD_MAXDAMAGE
    137 UNIT_FIELD_MINOFFHANDDAMAGE
    138 UNIT_FIELD_MAXOFFHANDDAMAGE
    139 UNIT_FIELD_BYTES_1
    140 UNIT_FIELD_PETNUMBER
    141 UNIT_FIELD_PET_NAME_TIMESTAMP
    142 UNIT_FIELD_PETEXPERIENCE
    143 UNIT_FIELD_PETNEXTLEVELEXP
    144 UNIT_DYNAMIC_FLAGS
    145 UNIT_CHANNEL_SPELL
    146 UNIT_MOD_CAST_SPEED
    147 UNIT_CREATED_BY_SPELL
    148 UNIT_NPC_FLAGS
    149 UNIT_NPC_EMOTESTATE
    150 UNIT_TRAINING_POINTS
    151 UNIT_FIELD_STR
    152 UNIT_FIELD_AGILITY
    153 UNIT_FIELD_STAMINA
    154 UNIT_FIELD_IQ
    155 UNIT_FIELD_SPIRIT
    156 UNIT_FIELD_RESISTANCES
    163 UNIT_FIELD_BASE_MANA
    164 UNIT_FIELD_BASE_HEALTH
    165 UNIT_FIELD_BYTES_2
    166 UNIT_FIELD_ATTACK_POWER
    167 UNIT_FIELD_ATTACK_POWER_MODS
    168 UNIT_FIELD_ATTACK_POWER_MULTIPLIER
    169 UNIT_FIELD_RANGED_ATTACK_POWER
    170 UNIT_FIELD_RANGED_ATTACK_POWER_MODS
    171 UNIT_FIELD_RANGED_ATTACK_POWER_MULTIPLIER
    172 UNIT_FIELD_MINRANGEDDAMAGE
    173 UNIT_FIELD_MAXRANGEDDAMAGE
    174 UNIT_FIELD_POWER_COST_MODIFIER
    181 UNIT_FIELD_POWER_COST_MULTIPLIER
    188 UNIT_FIELD_PADDING
    189 PLAYER_DUEL_ARBITER
    191 PLAYER_FLAGS
    192 PLAYER_GUILDID
    193 PLAYER_GUILDRANK
    194 PLAYER_BYTES
    195 PLAYER_BYTES_2
    196 PLAYER_BYTES_3
    197 PLAYER_DUEL_TEAM
    198 PLAYER_GUILD_TIMESTAMP
    199 PLAYER_QUEST_LOG_1_1
    200 PLAYER_QUEST_LOG_1_2
    202 PLAYER_QUEST_LOG_2_1
    203 PLAYER_QUEST_LOG_2_2
    205 PLAYER_QUEST_LOG_3_1
    206 PLAYER_QUEST_LOG_3_2
    208 PLAYER_QUEST_LOG_4_1
    209 PLAYER_QUEST_LOG_4_2
    211 PLAYER_QUEST_LOG_5_1
    212 PLAYER_QUEST_LOG_5_2
    214 PLAYER_QUEST_LOG_6_1
    215 PLAYER_QUEST_LOG_6_2
    217 PLAYER_QUEST_LOG_7_1
    218 PLAYER_QUEST_LOG_7_2
    220 PLAYER_QUEST_LOG_8_1
    221 PLAYER_QUEST_LOG_8_2
    223 PLAYER_QUEST_LOG_9_1
    224 PLAYER_QUEST_LOG_9_2
    226 PLAYER_QUEST_LOG_10_1
    227 PLAYER_QUEST_LOG_10_2
    229 PLAYER_QUEST_LOG_11_1
    230 PLAYER_QUEST_LOG_11_2
    232 PLAYER_QUEST_LOG_12_1
    233 PLAYER_QUEST_LOG_12_2
    235 PLAYER_QUEST_LOG_13_1
    236 PLAYER_QUEST_LOG_13_2
    238 PLAYER_QUEST_LOG_14_1
    239 PLAYER_QUEST_LOG_14_2
    241 PLAYER_QUEST_LOG_15_1
    242 PLAYER_QUEST_LOG_15_2
    244 PLAYER_QUEST_LOG_16_1
    245 PLAYER_QUEST_LOG_16_2
    247 PLAYER_QUEST_LOG_17_1
    248 PLAYER_QUEST_LOG_17_2
    250 PLAYER_QUEST_LOG_18_1
    251 PLAYER_QUEST_LOG_18_2
    253 PLAYER_QUEST_LOG_19_1
    254 PLAYER_QUEST_LOG_19_2
    256 PLAYER_QUEST_LOG_20_1
    257 PLAYER_QUEST_LOG_20_2
    259 PLAYER_VISIBLE_ITEM_1_CREATOR
    261 PLAYER_VISIBLE_ITEM_1_0
    269 PLAYER_VISIBLE_ITEM_1_PROPERTIES
    270 PLAYER_VISIBLE_ITEM_1_PAD
    271 PLAYER_VISIBLE_ITEM_2_CREATOR
    273 PLAYER_VISIBLE_ITEM_2_0
    281 PLAYER_VISIBLE_ITEM_2_PROPERTIES
    282 PLAYER_VISIBLE_ITEM_2_PAD
    283 PLAYER_VISIBLE_ITEM_3_CREATOR
    285 PLAYER_VISIBLE_ITEM_3_0
    293 PLAYER_VISIBLE_ITEM_3_PROPERTIES
    294 PLAYER_VISIBLE_ITEM_3_PAD
    295 PLAYER_VISIBLE_ITEM_4_CREATOR
    297 PLAYER_VISIBLE_ITEM_4_0
    305 PLAYER_VISIBLE_ITEM_4_PROPERTIES
    306 PLAYER_VISIBLE_ITEM_4_PAD
    307 PLAYER_VISIBLE_ITEM_5_CREATOR
    309 PLAYER_VISIBLE_ITEM_5_0
    317 PLAYER_VISIBLE_ITEM_5_PROPERTIES
    318 PLAYER_VISIBLE_ITEM_5_PAD
    319 PLAYER_VISIBLE_ITEM_6_CREATOR
    321 PLAYER_VISIBLE_ITEM_6_0
    329 PLAYER_VISIBLE_ITEM_6_PROPERTIES
    330 PLAYER_VISIBLE_ITEM_6_PAD
    331 PLAYER_VISIBLE_ITEM_7_CREATOR
    333 PLAYER_VISIBLE_ITEM_7_0
    341 PLAYER_VISIBLE_ITEM_7_PROPERTIES
    342 PLAYER_VISIBLE_ITEM_7_PAD
    343 PLAYER_VISIBLE_ITEM_8_CREATOR
    345 PLAYER_VISIBLE_ITEM_8_0
    353 PLAYER_VISIBLE_ITEM_8_PROPERTIES
    354 PLAYER_VISIBLE_ITEM_8_PAD
    355 PLAYER_VISIBLE_ITEM_9_CREATOR
    357 PLAYER_VISIBLE_ITEM_9_0
    365 PLAYER_VISIBLE_ITEM_9_PROPERTIES
    366 PLAYER_VISIBLE_ITEM_9_PAD
    367 PLAYER_VISIBLE_ITEM_10_CREATOR
    369 PLAYER_VISIBLE_ITEM_10_0
    377 PLAYER_VISIBLE_ITEM_10_PROPERTIES
    378 PLAYER_VISIBLE_ITEM_10_PAD
    379 PLAYER_VISIBLE_ITEM_11_CREATOR
    381 PLAYER_VISIBLE_ITEM_11_0
    389 PLAYER_VISIBLE_ITEM_11_PROPERTIES
    390 PLAYER_VISIBLE_ITEM_11_PAD
    391 PLAYER_VISIBLE_ITEM_12_CREATOR
    393 PLAYER_VISIBLE_ITEM_12_0
    401 PLAYER_VISIBLE_ITEM_12_PROPERTIES
    402 PLAYER_VISIBLE_ITEM_12_PAD
    403 PLAYER_VISIBLE_ITEM_13_CREATOR
    405 PLAYER_VISIBLE_ITEM_13_0
    413 PLAYER_VISIBLE_ITEM_13_PROPERTIES
    414 PLAYER_VISIBLE_ITEM_13_PAD
    415 PLAYER_VISIBLE_ITEM_14_CREATOR
    417 PLAYER_VISIBLE_ITEM_14_0
    425 PLAYER_VISIBLE_ITEM_14_PROPERTIES
    426 PLAYER_VISIBLE_ITEM_14_PAD
    427 PLAYER_VISIBLE_ITEM_15_CREATOR
    429 PLAYER_VISIBLE_ITEM_15_0
    437 PLAYER_VISIBLE_ITEM_15_PROPERTIES
    438 PLAYER_VISIBLE_ITEM_15_PAD
    439 PLAYER_VISIBLE_ITEM_16_CREATOR
    441 PLAYER_VISIBLE_ITEM_16_0
    449 PLAYER_VISIBLE_ITEM_16_PROPERTIES
    450 PLAYER_VISIBLE_ITEM_16_PAD
    451 PLAYER_VISIBLE_ITEM_17_CREATOR
    453 PLAYER_VISIBLE_ITEM_17_0
    461 PLAYER_VISIBLE_ITEM_17_PROPERTIES
    462 PLAYER_VISIBLE_ITEM_17_PAD
    463 PLAYER_VISIBLE_ITEM_18_CREATOR
    465 PLAYER_VISIBLE_ITEM_18_0
    473 PLAYER_VISIBLE_ITEM_18_PROPERTIES
    474 PLAYER_VISIBLE_ITEM_18_PAD
    475 PLAYER_VISIBLE_ITEM_19_CREATOR
    477 PLAYER_VISIBLE_ITEM_19_0
    485 PLAYER_VISIBLE_ITEM_19_PROPERTIES
    486 PLAYER_VISIBLE_ITEM_19_PAD
    487 PLAYER_FIELD_INV_SLOT_HEAD
    533 PLAYER_FIELD_PACK_SLOT_1
    565 PLAYER_FIELD_BANK_SLOT_1
    613 PLAYER_FIELD_BANKBAG_SLOT_1
    625 PLAYER_FIELD_VENDORBUYBACK_SLOT_1
    649 PLAYER_FIELD_KEYRING_SLOT_1
    713 PLAYER_FARSIGHT
    715 PLAYER_FIELD_COMBO_TARGET
    717 PLAYER_XP
    718 PLAYER_NEXT_LEVEL_XP
    719 PLAYER_SKILL_INFO_1_1
    1103 PLAYER_CHARACTER_POINTS1
    1104 PLAYER_CHARACTER_POINTS2
    1105 PLAYER_TRACK_CREATURES
    1106 PLAYER_TRACK_RESOURCES
    1107 PLAYER_BLOCK_PERCENTAGE
    1108 PLAYER_DODGE_PERCENTAGE
    1109 PLAYER_PARRY_PERCENTAGE
    1110 PLAYER_CRIT_PERCENTAGE
    1111 PLAYER_RANGED_CRIT_PERCENTAGE
    1112 PLAYER_EXPLORED_ZONES_1
    1176 PLAYER_REST_STATE_EXPERIENCE
    1177 PLAYER_FIELD_COINAGE
    1178 PLAYER_FIELD_POSSTAT0
    1179 PLAYER_FIELD_POSSTAT1
    1180 PLAYER_FIELD_POSSTAT2
    1181 PLAYER_FIELD_POSSTAT3
    1182 PLAYER_FIELD_POSSTAT4
    1183 PLAYER_FIELD_NEGSTAT0
    1184 PLAYER_FIELD_NEGSTAT1
    1185 PLAYER_FIELD_NEGSTAT2
    1186 PLAYER_FIELD_NEGSTAT3
    1187 PLAYER_FIELD_NEGSTAT4
    1188 PLAYER_FIELD_RESISTANCEBUFFMODSPOSITIVE
    1195 PLAYER_FIELD_RESISTANCEBUFFMODSNEGATIVE
    1202 PLAYER_FIELD_MOD_DAMAGE_DONE_POS
    1209 PLAYER_FIELD_MOD_DAMAGE_DONE_NEG
    1216 PLAYER_FIELD_MOD_DAMAGE_DONE_PCT
    1223 PLAYER_FIELD_BYTES
    1224 PLAYER_AMMO_ID
    1225 PLAYER_SELF_RES_SPELL
    1226 PLAYER_FIELD_PVP_MEDALS
    1227 PLAYER_FIELD_BUYBACK_PRICE_1
    1239 PLAYER_FIELD_BUYBACK_TIMESTAMP_1
    1251 PLAYER_FIELD_SESSION_KILLS
    1252 PLAYER_FIELD_YESTERDAY_KILLS
    1253 PLAYER_FIELD_LAST_WEEK_KILLS
    1254 PLAYER_FIELD_THIS_WEEK_KILLS
    1255 PLAYER_FIELD_THIS_WEEK_CONTRIBUTION
    1256 PLAYER_FIELD_LIFETIME_HONORABLE_KILLS
    1257 PLAYER_FIELD_LIFETIME_DISHONORABLE_KILLS
    1258 PLAYER_FIELD_YESTERDAY_CONTRIBUTION
    1259 PLAYER_FIELD_LAST_WEEK_CONTRIBUTION
    1260 PLAYER_FIELD_LAST_WEEK_RANK
    1261 PLAYER_FIELD_BYTES2
    1262 PLAYER_FIELD_WATCHED_FACTION_INDEX
    1263 PLAYER_FIELD_COMBAT_RATING_1
    0 PLAYER_END


  2. #2
    Account Upgraded | Title Enabled! EvilRyu is offline
    MemberRank
    May 2006 Join Date
    ScotlandLocation
    571Posts
    Quote Originally Posted by Fidelite View Post
    Does anyone know how to decode the data portion of the stored characters? I've found this list on a blog, but I'm not sure if it's applicable / still valid:

    FIELD NAME
    1 OBJECT_FIELD_GUID
    3 OBJECT_FIELD_TYPE
    4 OBJECT_FIELD_ENTRY
    5 OBJECT_FIELD_SCALE_X
    6 OBJECT_FIELD_PADDING
    7 UNIT_FIELD_CHARM
    9 UNIT_FIELD_SUMMON
    11 UNIT_FIELD_CHARMEDBY
    13 UNIT_FIELD_SUMMONEDBY
    15 UNIT_FIELD_CREATEDBY
    17 UNIT_FIELD_TARGET
    19 UNIT_FIELD_PERSUADED
    21 UNIT_FIELD_CHANNEL_OBJECT
    23 UNIT_FIELD_HEALTH
    24 UNIT_FIELD_POWER1
    25 UNIT_FIELD_POWER2
    26 UNIT_FIELD_POWER3
    27 UNIT_FIELD_POWER4
    28 UNIT_FIELD_POWER5
    29 UNIT_FIELD_MAXHEALTH
    30 UNIT_FIELD_MAXPOWER1
    31 UNIT_FIELD_MAXPOWER2
    32 UNIT_FIELD_MAXPOWER3
    33 UNIT_FIELD_MAXPOWER4
    34 UNIT_FIELD_MAXPOWER5
    35 UNIT_FIELD_LEVEL
    36 UNIT_FIELD_FACTIONTEMPLATE
    37 UNIT_FIELD_BYTES_0
    38 UNIT_VIRTUAL_ITEM_SLOT_DISPLAY
    41 UNIT_VIRTUAL_ITEM_INFO
    47 UNIT_FIELD_FLAGS
    48 UNIT_FIELD_AURA
    96 UNIT_FIELD_AURAFLAGS
    102 UNIT_FIELD_AURALEVELS
    114 UNIT_FIELD_AURAAPPLICATIONS
    126 UNIT_FIELD_AURASTATE
    127 UNIT_FIELD_BASEATTACKTIME
    129 UNIT_FIELD_RANGEDATTACKTIME
    130 UNIT_FIELD_BOUNDINGRADIUS
    131 UNIT_FIELD_COMBATREACH
    132 UNIT_FIELD_DISPLAYID
    133 UNIT_FIELD_NATIVEDISPLAYID
    134 UNIT_FIELD_MOUNTDISPLAYID
    135 UNIT_FIELD_MINDAMAGE
    136 UNIT_FIELD_MAXDAMAGE
    137 UNIT_FIELD_MINOFFHANDDAMAGE
    138 UNIT_FIELD_MAXOFFHANDDAMAGE
    139 UNIT_FIELD_BYTES_1
    140 UNIT_FIELD_PETNUMBER
    141 UNIT_FIELD_PET_NAME_TIMESTAMP
    142 UNIT_FIELD_PETEXPERIENCE
    143 UNIT_FIELD_PETNEXTLEVELEXP
    144 UNIT_DYNAMIC_FLAGS
    145 UNIT_CHANNEL_SPELL
    146 UNIT_MOD_CAST_SPEED
    147 UNIT_CREATED_BY_SPELL
    148 UNIT_NPC_FLAGS
    149 UNIT_NPC_EMOTESTATE
    150 UNIT_TRAINING_POINTS
    151 UNIT_FIELD_STR
    152 UNIT_FIELD_AGILITY
    153 UNIT_FIELD_STAMINA
    154 UNIT_FIELD_IQ
    155 UNIT_FIELD_SPIRIT
    156 UNIT_FIELD_RESISTANCES
    163 UNIT_FIELD_BASE_MANA
    164 UNIT_FIELD_BASE_HEALTH
    165 UNIT_FIELD_BYTES_2
    166 UNIT_FIELD_ATTACK_POWER
    167 UNIT_FIELD_ATTACK_POWER_MODS
    168 UNIT_FIELD_ATTACK_POWER_MULTIPLIER
    169 UNIT_FIELD_RANGED_ATTACK_POWER
    170 UNIT_FIELD_RANGED_ATTACK_POWER_MODS
    171 UNIT_FIELD_RANGED_ATTACK_POWER_MULTIPLIER
    172 UNIT_FIELD_MINRANGEDDAMAGE
    173 UNIT_FIELD_MAXRANGEDDAMAGE
    174 UNIT_FIELD_POWER_COST_MODIFIER
    181 UNIT_FIELD_POWER_COST_MULTIPLIER
    188 UNIT_FIELD_PADDING
    189 PLAYER_DUEL_ARBITER
    191 PLAYER_FLAGS
    192 PLAYER_GUILDID
    193 PLAYER_GUILDRANK
    194 PLAYER_BYTES
    195 PLAYER_BYTES_2
    196 PLAYER_BYTES_3
    197 PLAYER_DUEL_TEAM
    198 PLAYER_GUILD_TIMESTAMP
    199 PLAYER_QUEST_LOG_1_1
    200 PLAYER_QUEST_LOG_1_2
    202 PLAYER_QUEST_LOG_2_1
    203 PLAYER_QUEST_LOG_2_2
    205 PLAYER_QUEST_LOG_3_1
    206 PLAYER_QUEST_LOG_3_2
    208 PLAYER_QUEST_LOG_4_1
    209 PLAYER_QUEST_LOG_4_2
    211 PLAYER_QUEST_LOG_5_1
    212 PLAYER_QUEST_LOG_5_2
    214 PLAYER_QUEST_LOG_6_1
    215 PLAYER_QUEST_LOG_6_2
    217 PLAYER_QUEST_LOG_7_1
    218 PLAYER_QUEST_LOG_7_2
    220 PLAYER_QUEST_LOG_8_1
    221 PLAYER_QUEST_LOG_8_2
    223 PLAYER_QUEST_LOG_9_1
    224 PLAYER_QUEST_LOG_9_2
    226 PLAYER_QUEST_LOG_10_1
    227 PLAYER_QUEST_LOG_10_2
    229 PLAYER_QUEST_LOG_11_1
    230 PLAYER_QUEST_LOG_11_2
    232 PLAYER_QUEST_LOG_12_1
    233 PLAYER_QUEST_LOG_12_2
    235 PLAYER_QUEST_LOG_13_1
    236 PLAYER_QUEST_LOG_13_2
    238 PLAYER_QUEST_LOG_14_1
    239 PLAYER_QUEST_LOG_14_2
    241 PLAYER_QUEST_LOG_15_1
    242 PLAYER_QUEST_LOG_15_2
    244 PLAYER_QUEST_LOG_16_1
    245 PLAYER_QUEST_LOG_16_2
    247 PLAYER_QUEST_LOG_17_1
    248 PLAYER_QUEST_LOG_17_2
    250 PLAYER_QUEST_LOG_18_1
    251 PLAYER_QUEST_LOG_18_2
    253 PLAYER_QUEST_LOG_19_1
    254 PLAYER_QUEST_LOG_19_2
    256 PLAYER_QUEST_LOG_20_1
    257 PLAYER_QUEST_LOG_20_2
    259 PLAYER_VISIBLE_ITEM_1_CREATOR
    261 PLAYER_VISIBLE_ITEM_1_0
    269 PLAYER_VISIBLE_ITEM_1_PROPERTIES
    270 PLAYER_VISIBLE_ITEM_1_PAD
    271 PLAYER_VISIBLE_ITEM_2_CREATOR
    273 PLAYER_VISIBLE_ITEM_2_0
    281 PLAYER_VISIBLE_ITEM_2_PROPERTIES
    282 PLAYER_VISIBLE_ITEM_2_PAD
    283 PLAYER_VISIBLE_ITEM_3_CREATOR
    285 PLAYER_VISIBLE_ITEM_3_0
    293 PLAYER_VISIBLE_ITEM_3_PROPERTIES
    294 PLAYER_VISIBLE_ITEM_3_PAD
    295 PLAYER_VISIBLE_ITEM_4_CREATOR
    297 PLAYER_VISIBLE_ITEM_4_0
    305 PLAYER_VISIBLE_ITEM_4_PROPERTIES
    306 PLAYER_VISIBLE_ITEM_4_PAD
    307 PLAYER_VISIBLE_ITEM_5_CREATOR
    309 PLAYER_VISIBLE_ITEM_5_0
    317 PLAYER_VISIBLE_ITEM_5_PROPERTIES
    318 PLAYER_VISIBLE_ITEM_5_PAD
    319 PLAYER_VISIBLE_ITEM_6_CREATOR
    321 PLAYER_VISIBLE_ITEM_6_0
    329 PLAYER_VISIBLE_ITEM_6_PROPERTIES
    330 PLAYER_VISIBLE_ITEM_6_PAD
    331 PLAYER_VISIBLE_ITEM_7_CREATOR
    333 PLAYER_VISIBLE_ITEM_7_0
    341 PLAYER_VISIBLE_ITEM_7_PROPERTIES
    342 PLAYER_VISIBLE_ITEM_7_PAD
    343 PLAYER_VISIBLE_ITEM_8_CREATOR
    345 PLAYER_VISIBLE_ITEM_8_0
    353 PLAYER_VISIBLE_ITEM_8_PROPERTIES
    354 PLAYER_VISIBLE_ITEM_8_PAD
    355 PLAYER_VISIBLE_ITEM_9_CREATOR
    357 PLAYER_VISIBLE_ITEM_9_0
    365 PLAYER_VISIBLE_ITEM_9_PROPERTIES
    366 PLAYER_VISIBLE_ITEM_9_PAD
    367 PLAYER_VISIBLE_ITEM_10_CREATOR
    369 PLAYER_VISIBLE_ITEM_10_0
    377 PLAYER_VISIBLE_ITEM_10_PROPERTIES
    378 PLAYER_VISIBLE_ITEM_10_PAD
    379 PLAYER_VISIBLE_ITEM_11_CREATOR
    381 PLAYER_VISIBLE_ITEM_11_0
    389 PLAYER_VISIBLE_ITEM_11_PROPERTIES
    390 PLAYER_VISIBLE_ITEM_11_PAD
    391 PLAYER_VISIBLE_ITEM_12_CREATOR
    393 PLAYER_VISIBLE_ITEM_12_0
    401 PLAYER_VISIBLE_ITEM_12_PROPERTIES
    402 PLAYER_VISIBLE_ITEM_12_PAD
    403 PLAYER_VISIBLE_ITEM_13_CREATOR
    405 PLAYER_VISIBLE_ITEM_13_0
    413 PLAYER_VISIBLE_ITEM_13_PROPERTIES
    414 PLAYER_VISIBLE_ITEM_13_PAD
    415 PLAYER_VISIBLE_ITEM_14_CREATOR
    417 PLAYER_VISIBLE_ITEM_14_0
    425 PLAYER_VISIBLE_ITEM_14_PROPERTIES
    426 PLAYER_VISIBLE_ITEM_14_PAD
    427 PLAYER_VISIBLE_ITEM_15_CREATOR
    429 PLAYER_VISIBLE_ITEM_15_0
    437 PLAYER_VISIBLE_ITEM_15_PROPERTIES
    438 PLAYER_VISIBLE_ITEM_15_PAD
    439 PLAYER_VISIBLE_ITEM_16_CREATOR
    441 PLAYER_VISIBLE_ITEM_16_0
    449 PLAYER_VISIBLE_ITEM_16_PROPERTIES
    450 PLAYER_VISIBLE_ITEM_16_PAD
    451 PLAYER_VISIBLE_ITEM_17_CREATOR
    453 PLAYER_VISIBLE_ITEM_17_0
    461 PLAYER_VISIBLE_ITEM_17_PROPERTIES
    462 PLAYER_VISIBLE_ITEM_17_PAD
    463 PLAYER_VISIBLE_ITEM_18_CREATOR
    465 PLAYER_VISIBLE_ITEM_18_0
    473 PLAYER_VISIBLE_ITEM_18_PROPERTIES
    474 PLAYER_VISIBLE_ITEM_18_PAD
    475 PLAYER_VISIBLE_ITEM_19_CREATOR
    477 PLAYER_VISIBLE_ITEM_19_0
    485 PLAYER_VISIBLE_ITEM_19_PROPERTIES
    486 PLAYER_VISIBLE_ITEM_19_PAD
    487 PLAYER_FIELD_INV_SLOT_HEAD
    533 PLAYER_FIELD_PACK_SLOT_1
    565 PLAYER_FIELD_BANK_SLOT_1
    613 PLAYER_FIELD_BANKBAG_SLOT_1
    625 PLAYER_FIELD_VENDORBUYBACK_SLOT_1
    649 PLAYER_FIELD_KEYRING_SLOT_1
    713 PLAYER_FARSIGHT
    715 PLAYER_FIELD_COMBO_TARGET
    717 PLAYER_XP
    718 PLAYER_NEXT_LEVEL_XP
    719 PLAYER_SKILL_INFO_1_1
    1103 PLAYER_CHARACTER_POINTS1
    1104 PLAYER_CHARACTER_POINTS2
    1105 PLAYER_TRACK_CREATURES
    1106 PLAYER_TRACK_RESOURCES
    1107 PLAYER_BLOCK_PERCENTAGE
    1108 PLAYER_DODGE_PERCENTAGE
    1109 PLAYER_PARRY_PERCENTAGE
    1110 PLAYER_CRIT_PERCENTAGE
    1111 PLAYER_RANGED_CRIT_PERCENTAGE
    1112 PLAYER_EXPLORED_ZONES_1
    1176 PLAYER_REST_STATE_EXPERIENCE
    1177 PLAYER_FIELD_COINAGE
    1178 PLAYER_FIELD_POSSTAT0
    1179 PLAYER_FIELD_POSSTAT1
    1180 PLAYER_FIELD_POSSTAT2
    1181 PLAYER_FIELD_POSSTAT3
    1182 PLAYER_FIELD_POSSTAT4
    1183 PLAYER_FIELD_NEGSTAT0
    1184 PLAYER_FIELD_NEGSTAT1
    1185 PLAYER_FIELD_NEGSTAT2
    1186 PLAYER_FIELD_NEGSTAT3
    1187 PLAYER_FIELD_NEGSTAT4
    1188 PLAYER_FIELD_RESISTANCEBUFFMODSPOSITIVE
    1195 PLAYER_FIELD_RESISTANCEBUFFMODSNEGATIVE
    1202 PLAYER_FIELD_MOD_DAMAGE_DONE_POS
    1209 PLAYER_FIELD_MOD_DAMAGE_DONE_NEG
    1216 PLAYER_FIELD_MOD_DAMAGE_DONE_PCT
    1223 PLAYER_FIELD_BYTES
    1224 PLAYER_AMMO_ID
    1225 PLAYER_SELF_RES_SPELL
    1226 PLAYER_FIELD_PVP_MEDALS
    1227 PLAYER_FIELD_BUYBACK_PRICE_1
    1239 PLAYER_FIELD_BUYBACK_TIMESTAMP_1
    1251 PLAYER_FIELD_SESSION_KILLS
    1252 PLAYER_FIELD_YESTERDAY_KILLS
    1253 PLAYER_FIELD_LAST_WEEK_KILLS
    1254 PLAYER_FIELD_THIS_WEEK_KILLS
    1255 PLAYER_FIELD_THIS_WEEK_CONTRIBUTION
    1256 PLAYER_FIELD_LIFETIME_HONORABLE_KILLS
    1257 PLAYER_FIELD_LIFETIME_DISHONORABLE_KILLS
    1258 PLAYER_FIELD_YESTERDAY_CONTRIBUTION
    1259 PLAYER_FIELD_LAST_WEEK_CONTRIBUTION
    1260 PLAYER_FIELD_LAST_WEEK_RANK
    1261 PLAYER_FIELD_BYTES2
    1262 PLAYER_FIELD_WATCHED_GAYPORN=TRUTH/INDEX
    1263 PLAYER_FIELD_COMBAT_RATING_1
    0 PLAYER_END
    Hmm, no idea what your problem could be:S

  3. #3
    Apprentice Nimd@ is offline
    MemberRank
    Oct 2006 Join Date
    24Posts
    Fidelite - did you mean 'data' field from 'character' table from 'mangos' DB ? if yes - well, the beginning looks correct, if no - then what did you mean ?

  4. #4
    Novice mweaver is offline
    MemberRank
    Jan 2007 Join Date
    3Posts
    That looks about right. I found it on https://svn.mangosproject.org/trac/M.../CharacterData and I've confirmed some of them while making a website for my server.

  5. #5
    Apprentice RZ_IS_GAY is offline
    MemberRank
    Feb 2007 Join Date
    22Posts
    THE GREAT DJRavine, Yamachi & Ryu...

    Have All Moved To WoWPS.Org!

    Why you May Ask because of the lack of resources RageZone Has given The Wow Section........








    Please Come Over and Enjoy The Community Where Everyone Is Allowed To Ask Just The Most Simplest Question With Out Getting Abused


  6. #6
    Novice Bendup123 is offline
    MemberRank
    Mar 2007 Join Date
    1Posts

    Re: database question - The character table data field

    Does anybody have a script or something to migrate the data field of 1.12.1 characters to 2.0.8/2.0.10 tbc ?

    Thanks
    Ben



Advertisement