Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Tutorials => Topic started by: MR. Farrare on November 25, 2015, 03:35:01 am

Title: [TUTORIAL] db3 to csv
Post by: MR. Farrare on November 25, 2015, 03:35:01 am
1. open the db3 file in 010 editor
[attachment=1:32vezx04]11.png[/attachment:32vezx04]

2. change wdb3 to wdb2
[attachment=0:32vezx04]22.png[/attachment:32vezx04]

3. save the file

4 run WoWParser2_ADB_DB2_WDB_DBC_Reader (http://www61.zippyshare.com/v/cn8hN4o3/file.html (http://www61.zippyshare.com/v/cn8hN4o3/file.html" onclick="window.open(this.href);return false;))

5.finish
Title: Re: [TUTORIAL] db3 to csv
Post by: schlumpf on November 25, 2015, 12:26:59 pm
This should go straight into retro-porting hall of fame.

Title: Re: [TUTORIAL] db3 to csv
Post by: Rangorn on November 25, 2015, 01:05:47 pm
Quote from: "schlumpf"
This should go straight into retro-porting hall of fame.

  • The magic changed for a reason: The header format changed, as well as the data blocks.
  • Changing to WDB2 but renaming to .dbc makes no sense at all.
  • even the row formats changed so whatever description that converter has _must_ be out of date
  • ???

I have opened Language.db2 from wod 6.2.2 and from Legion, except the char magic wdb3 and timestamp/min/max in the header, everything was the same, but maybe because that's a small file.

Anyway, did u plane to define the db3 structure on the wikidev pxr ?
Title: Re: [TUTORIAL] db3 to csv
Post by: schlumpf on November 25, 2015, 01:23:34 pm
Quote from: "Rangorn"
I have opened Language.db2 from wod 6.2.2 and from Legion, except the char magic wdb3 and timestamp/min/max in the header, everything was the same, but maybe because that's a small file.
It might work for a very small amount of files, I guess. The renaming-to-dbc part still is absurd.

Quote from: "Rangorn"
Anyway, did u plane to define the db3 structure on the wikidev pxr ?
The fact that I'm apparently the only one who would, makes me sad.
Title: Re: [TUTORIAL] db3 to csv
Post by: Rangorn on November 25, 2015, 01:32:42 pm
Haha, i said that because you are certainly the guy with the best knowledge of WoW, after Blizzard's employees.

About myself, i can easily analyze a file, reading offsets/chunks etc... but i couldn't say what is it for, what does it do, how to do it etc....
So i check the wiki PXR and im always surprised that structures post-wotlk are defined properly, even the CASC system is explained
Title: Re: [TUTORIAL] db3 to csv
Post by: schlumpf on November 25, 2015, 01:53:02 pm
Note that the CASC page has maybe one or two lines by me. There are other people who know shit, but they are mostly not documenting :(
Title: Re: [TUTORIAL] db3 to csv
Post by: Shadowjesper1 on November 25, 2015, 05:56:52 pm
Doesn't seem to work for me. It only returns structure damaged either way.
Title: Re: [TUTORIAL] db3 to csv
Post by: MR. Farrare on November 26, 2015, 12:30:50 am
Quote from: "schlumpf"
Note that the CASC page has maybe one or two lines by me. There are other people who know shit, but they are mostly not documenting :(
many people take there knowledge to their grave  :D
Title: Re: [TUTORIAL] db3 to csv
Post by: MR. Farrare on November 26, 2015, 12:31:52 am
Quote from: "Shadowjesper1"
Doesn't seem to work for me. It only returns structure damaged either way.
what is your db3 file