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!

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Night

Pages: [1]
1
Software Development / [TOOL] DBC to SQL Converter
« on: March 20, 2012, 09:38:19 pm »
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/WHXxzC3z

Output:
http://pastebin.com/sDiKyHaW

20 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! :P

2
Serverside Modding / 1.12 spell.dbc min & max damage
« on: August 04, 2011, 11:51:35 pm »
Hey there!
To put it in a nutshell, can somebody explain me how to calculate the damage done by spells from the infos given by the spell.dbc? (1.12 client)
Row 77 (starting from 0) seems to be the min damage -1, but I can't find anything about the max damage. I've already played a lot(!) with the surrounding rows, like taking two bits and add it to the min damage and such crazy stuff... Sometimes it works, sometimes it doesn't, but I need a valid solution for all spells! (and I'm way to lazy to write down 34927 values...)

I hope somebody knows how it is done, or I'm going insane!  :udumb:


Cheers,
Night

PS:
I'll upload an 1.12 spell.dbc just in case somebody want to take a look at it.

Pages: [1]