[QUESTION] [DATABASE] [LIVE MOP - 5.1]

[f0x]

Hi there  

I was wondering if someone would be willing to share some insight into the workings of the item.db2 and item-sparse.db2 files on live production WoW.

First my end goal is to have a complete list of all items in game eventually mapping out to displaydetails, item sets etc.

My issue though is currently my item.db2 file contains entries that have no direct mapping to item-sparse, which of course you know contains item details that one would need.

I'm looking at item2.db inside of patch-enGB-16357.MPQ for item.db2 and item-sparse.db2 as they seem to contain much more info that than the db2 files contained in misc.mpq.

So I guess my question is rather why don't all the items in item.db2 have a detail row in the sparse file even though the item is in game for sure?

Am I missing something about how this file is built? Do I have to see the item in game for it to actually update the sparse db2 file?

Another thing I was wondering is how do people build the definitions for these files, and how can I ensure that my definition of the columns is valid.

TIA,

f0x

[Ascathos]

https://github.com/Shauren/AdbToSqlConv ... -sparse.cs
https://github.com/Shauren/AdbToSqlConv ... ts/Item.cs

Schlumpf refered to it in the wiki. I can not tell you how accurate these are, though.

[f0x]

Thanks for the reply - these are the current definitions that i'm using and seem to be correct;

Just wanted to know how these are extracted so that I can keep my definitions up to date as updates occur to the structure and of course the rest of the questions such as how its built etc.

[schlumpf]

They are extracted by wild guessing most likely. When I'm at home, I'll look for a more up to date version, based on MoP beta leaks.

[f0x]

Would appreciate it a lot, schlumpf - thank you.

Would you have any insight on the other questions or perhaps direct me to somewhere/someone that might know?

Cheers

[Ascathos]

I'd suggest looking at any cataclysm build you happen to find, for example the branch from trinity and try to look at their noted structures. Maybe you can find enough reference that still works to get more of a picture.

[schlumpf]

item-sparse seems to has another int in the end, but else, nothing is different.

Code: [Select]

struct ItemRec_C
{
  int _0;
  int _1;
  int _2;
  int _3;
  int _4;
  int _5;
  int _6;
  int _7;
};
struct ItemRecSparse_C
{
  int _0;
  int _1;
  int _2[2];
  float _3;
  float _4;
  int _5;
  int _6;
  int _7;
  int _8;
  int _9;
  int _10;
  int _11;
  int _12;
  int _13;
  int _14;
  int _15;
  int _16;
  int _17;
  int _18;
  int _19;
  int _20;
  int _21;
  int _22;
  int _23[10];
  int _24[10];
  int _25[10];
  float _26[10];
  int _27;
  int _28;
  int _29;
  float _30;
  int _31[5];
  int _32[5];
  int _33[5];
  int _34[5];
  int _35[5];
  int _36[5];
  int _37;
  const char* _38;
  const char* _39;
  const char* _40;
  const char* _41;
  const char* _42;
  int _43;
  int _44;
  int _45;
  int _46;
  int _47;
  int _48;
  int _49;
  int _50;
  int _51;
  int _52;
  int _53;
  int _54;
  int _55;
  int _56;
  int _57[3];
  int _58[3];
  int _59;
  int _60;
  float _61;
  int _62;
  int _63;
  int _64;
  float _65;
  int _66;
  int _67;
  int _68;
};
On a side note: This is the most one can automatically determine from any build of WoW. This listing is from 15464.
In some builds, one can also get the actual names. Don't have one of those here right now though.

[f0x]

Thanks so much for the definition; will definitely help when I tighten up the data types later on.

Do you perhaps know why there is inconsistencies in the items-sparse file regarding missing items that are listed in item.db2 and in game but no detail in sparse file?

[schlumpf]

I would have to manually investigate that.