Hey,
I just want to release an old project of mine, which may be usefull for some of you.
With this tool you can convert any given dbc file into a sql file. In order to do so, you have to specify the files format in a .xml file with the same name as the dbc.
For example Achievement.xml
http://pastebin.com/WHXxzC3zOutput:
http://pastebin.com/sDiKyHaW20 more examples (for 3.3.5) are in the attached zip file.
XML Tags:
<primary> - This will tell the converter that this row should be used as the sql tables primary key. Gets parsed as an int.
<int> - Parses an int. Reads DBC.fieldsize bytes from the dbc file
<string x="n"> - This will parse a string. Replace n with the number of the following localisation indices (should be always 16). Nope, localisation isn't supported since I've never got any localized dbcs to play with.
<float> - Parses a float
<charArray x="n"> - Reads n characters directly from the current position in the file stream (not from the string block). Don't know if you actually need this, implemented it for debugging.
How does it work?
->Start the program.
->Klick on the button "choose dir" and select a folder which includes the dbc file you want to convert.
->Klick on the button "Start".
->Done! All converted files are now within the folder "sql".
The whole source code looks rather dirty since I've never finished this program, but maybe one of you guys get in use of it.
So far,
Night
PS: Written in C#. Sorry Linux and Mac users. Better get a proper operating system!