1
Miscellaneous / [QUESTION] [DATABASE] [LIVE MOP - 5.1]
« on: January 10, 2013, 10:27:13 am »
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
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