[Question] DB2 file structure

[VX2]

can anyone link an information about DB2 (of course wow) files structure? can't find no where(( just I can't understand a meanings of some bytes\\
or may be exist some parser, what allow convert back csv to db2?

[schlumpf]

DB2Reader.cs - mywowtools - My Small Tools - Google Project Hosting

[VX2]

thanks. but 4 bytes before locale is not looks as "tableHash" - it's still identical for different versions of same named files with different content.
for sample, for all versions of "Item-sparse.db2" it's always = "4EE59B91".
also header of "KeyChain.db2" looks simple strange - it have a 33 "FieldsCount", 36 "RecordSize" and only one record for "12911" (in "locale-enGB.MPQ"), while for "13623" it have 4 records with same 33 "FieldsCount" and 36 "RecordSize".

[schlumpf]

No idea, never looked at that stuff. The link is to TOM_RUS' svn.

[sitnspinlock]

I wrote one to dump db2 to csv after it is loaded into memory if you are interested. let me know ;p

[VX2]

I already have db2 to scv converter, I need to convert it back - csv to db2.

[sitnspinlock]

what is your goal here? There is probably another way to go about this ;p

[VX2]

I want try to append not available (models without item id), or unused models of equipment (if it exist).

[VX2]

seems I understand all of data, except "tableHash" and how recognize a type/len of field (column). just I have no anymore unknown bytes except "tableHash" and any manipulation with this bytes or file name have no affect on converter. it's always converts all data correctly. it's really confuse me. someone can help in this?

[VX2]

if some one interested - I finished article, where I wrote all what I could understand DB2 - MMOwned Wiki
would be nice if some one would make it "more english" x)

[92eatos]

VX2 the item.db2 has the same structure like the old item.dbc had
basicly itemid, displayid, sheet, type, slotid

item-sparse.db2 well i have seen on some servers it has the structure of item_template table from trinity well (skyfire )

[VX2]

mainly yes. but db2 header have an additional values. also for tables with string fields, db2 have an additional "indexes" section. for converting to csv it's may be just ignored, but to convert it back to db2 it must exist and be correct.