This is a read only copy without any forum functionality of the old Modcraft forum.
If there is anything that you would like to have removed, message me on Discord via Kaev#5208.
Big thanks to Alastor for making this copy!

Menu

Author Topic: [TUTORIAL] db3 to csv  (Read 3158 times)

MR. Farrare

  • Registred Member
  • Creator of Worlds
  • *****
  • Posts: 963
    • View Profile
[TUTORIAL] db3 to csv
« 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)

5.finish
« Last Edit: November 26, 2015, 12:09:54 am by Admin »

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #1 on: November 25, 2015, 12:26:59 pm »
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
  • ???
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Rangorn

  • Contributors
  • Model Change Addict
  • *****
  • Posts: 291
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #2 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 ?
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #3 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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Rangorn

  • Contributors
  • Model Change Addict
  • *****
  • Posts: 291
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #4 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
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

schlumpf

  • Administrator
  • Creator of Worlds
  • *****
  • Posts: 2967
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #5 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 :(
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

Shadowjesper1

  • Registred Member
  • LUA Script Tinker
  • *****
  • Posts: 41
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #6 on: November 25, 2015, 05:56:52 pm »
Doesn't seem to work for me. It only returns structure damaged either way.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »

MR. Farrare

  • Registred Member
  • Creator of Worlds
  • *****
  • Posts: 963
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #7 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
« Last Edit: November 26, 2015, 12:53:38 am by Admin »

MR. Farrare

  • Registred Member
  • Creator of Worlds
  • *****
  • Posts: 963
    • View Profile
Re: [TUTORIAL] db3 to csv
« Reply #8 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
« Last Edit: January 01, 1970, 01:00:00 am by Admin »