Here it is, the latest patch. Works with BC and non BC clients.
CurseGaming Mirror (always up to date)
Local Mirror (version 1.5)
Enjoy, please comment if there are any issues.
WDB to CSV updated (v1.5)
32 Responses
Leave a Comment
Here it is, the latest patch. Works with BC and non BC clients.
CurseGaming Mirror (always up to date)
Local Mirror (version 1.5)
Enjoy, please comment if there are any issues.
March 21st, 2007 at 4:06 pm
Hi, nice work on the program. But… it doesn’t seem to work! It only seems to detect two items…
This is the output:
Signature matches itemcache.wdb
WARNING: Number of fields does not match definition,
Temporarily adjusting fieldsize, this may be an older/newer version.
NEW FIELD INFO:
New fields: 3
2 records loaded.
The items are “Footpad’s Shirt” and “Footpad’s Pants”. But… It seems to start with some sort of offset that’s incorrect. “Footpad’s Shirt” should be ID “49″, which it recognises correctly. “Footpad’s Pants” shoult be ID “48″, but it finds “262144″. There seems to be an offset when reading the second item? Also, name 1 is displayed as “otpad’s Pants”. So it seems to start 2 bytes late?
Also, do you have any idea where I can get a mapping of item-enchantment (”of the Bear”, “of the Eagle”, etc.) and the actual changes?
March 21st, 2007 at 4:10 pm
I can tell your still using an older version because the newer one does not output new field info.
March 21st, 2007 at 5:05 pm
Uhm, then you’re distributing old source
I downloaded it from here, but had to recompile because I’m on a mac 
March 21st, 2007 at 5:12 pm
Ah yes, this is true. I haven’t been putting the latest source in because I’ve started reworking the whole thing so I could implement it into another program I have been working on.
Here it is: http://www.jb55.com/_files/wdbtocsv15src.zip
March 21st, 2007 at 5:25 pm
Thx man! Now to find out how to compile this
March 21st, 2007 at 5:35 pm
Ah, too bad, you’re using strcpy_s, strcat_s, fopen_s and sprintf_s, which aren’t standard C and only work in Windows
Ah well.
March 21st, 2007 at 5:40 pm
It should work just fine by removing the _s and adjusting the parameters, but yeah I never coded it with cross-platform use in mind.
March 21st, 2007 at 5:56 pm
Aye, did that and it works… sort of… Again, only 2 records and the ItemID of the second record is 4294967295, which is about 0xFFFFFFFF I think
Could you point me to the part in the code where I could add a jump forward for 4 bytes?
Kinda proud of myself 
For the record, I’ve never programmed in C , fixed the code by google’ing and IRC
March 21st, 2007 at 5:58 pm
oh and make sure #define _BC is 1
March 21st, 2007 at 6:02 pm
That helped, thx
Mail me if you want a Unix/MacOSX compatible version.
March 22nd, 2007 at 3:36 am
I wouldn’t mind a link to a working unix souce/compile, joefilas@gmail.com. Thanks. Nice work JB.
March 22nd, 2007 at 1:05 pm
Thanks JB, new version works great.
March 29th, 2007 at 5:56 pm
Having some issues parsing (and displaying in Excel) string fields (in questcache) that contain ” chars. \” appears to work for CSV parsers for not excel. Mail me for a sample wdb if desired, JB.
March 30th, 2007 at 8:48 pm
Yeah nested quotes don’t fare well in excel it appears, even with escape characters. I’ll implement the escape character in the next version…
April 17th, 2007 at 7:10 pm
It works great with current WoW, but it fails on PTR for patch 2.1.
Just to inform you.
May 9th, 2007 at 12:01 pm
Can not smoothly conversion not English department crosspiece
example：http://statue.sayya.org/wowdb/itemstats/WDB.rar
May 14th, 2007 at 10:36 am
Darshu, email me, I need to get in touch with you.
June 15th, 2007 at 12:29 pm
wdb2csv 1.5 and wowclient bc v2.1 (enGB)
when using on 5mb itemcache.wdb I only get a single record
..Cache\WDB\enGB>wdbtocsv itemcache.wdb
** WDB to CSV**
by: Jb55
Website: http://www.jb55.com
Contact: jackbox55@gmail.com
Signature matches itemcache.wdb (132 defined fields)
1 records loaded.
I could upload the wdb file if that helps in any way, just curious if there’s any way to get the rest of the data.
July 8th, 2007 at 9:19 pm
I’m getting the same problem. 1 row with latest 2.1 patch. Awesome program though. Hoping you have a v16 in the works. Cheers!
July 8th, 2007 at 11:09 pm
A little more info on my previous post. All the files failed to parse more than one line. I looked at BC v2.1.2 (build 6803). I had an old version of itemcache.wdb (build 6320, two builds old). It looks like there are 4 additional bytes per item record in the latest build. I didn’t have a copy of build 6337 to compare.
August 30th, 2007 at 11:10 pm
Jb55,
Any chance you will be publishing a fix for this converter? I am really reluctant to touch your code and even less so to tackle it when you’re so close to perfection. Also, I really enjoyed that you publish the executable version on Curse. This was a big help to me, even if it didn’t get more than one row.
Thanks,
Minister.Kel’Thuzad
September 18th, 2007 at 10:23 pm
I can not Converts WDB cache files, use your tool of WDB to CSV v1.5.
This tool can not Converts WDB, at Wow of Taiwan (v2.1.3).
Maybe, WDB have many strings of UTF8.
can you help me?
I want data of WDB, build my WowWiki web.
ex.
itemcache.wdb (7573KB) -> itemcache.wdb.csv (4KB)
questcache.wdb (424KB) -> questcache.wdb.csv (2KB)
Why?
September 18th, 2007 at 11:06 pm
my wow WDB Files.
http://www.player.idv.tw/WDB_enTW.zip
September 20th, 2007 at 12:19 am
void parseWDB()
{
CWDBRecord tRec;
wdbfield_t tField;
wdbfield_t recID,recSize;
wdbfield_t *pm_data = (wdbfield_t*)m_data;
wdbfield_t *pm_dataSafe; //安全機制
char *pcm_data;
u16 *psm_data;
u32 sLen;
int i;
// 0xFFFF is just a random number I chose, simply to avoid infinite loops
// which shouldn’t happen anyways…
for(i=0;i= m_datasize)
break;
// break if invalid ID
if(recID.uivalgetNumFields();j )
{
// if the field is a string, the wdbfield will simply contain a pointer to the string
// in the m_data block
if (m_def->getFieldType(j) & t_str)
{
sLen = strlen((char*)pm_data);
tField.pchar = (char*)pm_data;
pcm_data = (char*)pm_data;
pcm_data = sLen 1;
pm_data = (wdbfield_t*)pcm_data;
}
// special case that occurs in creaturecache.wdb
else if(m_def->getFieldType(j) & t_special2byte)
{
u16 sField;
psm_data = (u16*)pm_data;
sField = *psm_data;
tField.uival = (u32)sField;
psm_data ;
pm_data = (wdbfield_t*)psm_data;
} else {
tField = *pm_data; pm_data ;
}
tRec.addField(tField,j);
}
m_records.push_back(tRec);
//安全機制
pm_data = pm_dataSafe;
}
printf(”%i records loaded.\n”,i);
}
September 27th, 2007 at 7:33 am
http://www.player.idv.tw/wow/index.php?title=Wdb-to-csv
I edit some code of this Tool.
December 10th, 2007 at 12:42 pm
I downloaded and unzipped your 1.5v WDB converter into a folder named WBD Converter. I then dragged and dropped my WBD file onto the wdbtocsv.exe file and nothing happened. I searched for the CSV file to see if one was created someplace else but couldn’t find it. Any help would be appreciated.
March 6th, 2008 at 9:13 am
void CWDB::parseWDB()
{
…
u8 *spsm_data;
…
// special case that occurs in creaturecache.wdb
else if(m_def->getFieldType(j) & t_special2byte){
u8 sField;
spsm_data = (u8*)pm_data;
//psm_data = (u16*)pm_data;
sField = *spsm_data;
tField.uival = (u32)sField;
spsm_data ;
pm_data = (wdbfield_t*)spsm_data;
March 6th, 2008 at 9:14 am
void LoadDefinitions(){
CWDBDef def;
// creaturecache.wdb (BOMW)
def.setWDBName(”creaturecache.wdb”);
def.setSignature(”BOMW”);
// 15 fields
//21
def.addField(t_uint,”CreatureID”, 0);
def.addField(t_uint,”Entry Size”, 0);
def.addField(t_str,”Name 1″, 0);
def.addField(t_str,”Name 2″, 0);
def.addField(t_str,”Name 3″, 0);
def.addField(t_str,”Name 4″, 0);
def.addField(t_str,”Description”, 0);
def.addField(t_str,”NA”, 0);
def.addField(t_uint,”", 0); // unknown
def.addField(t_uint,”TypeID”, 0);
def.addField(t_uint,”FamilyID”, 0);
def.addField(t_uint,”FlagID”, 0);
def.addField(t_undefined,”", 0); // unknown
def.addField(t_uint,”SpellDataID”, 0);
def.addField(t_uint,”IconID”, 0);
def.addField(t_undefined,”DisplayID2″, 0); // unknown
def.addField(t_undefined,”DisplayID3″, 0); // unknown
def.addField(t_undefined,”DisplayID4″, 0); // unknown
def.addField(t_uint,”", 0);
def.addField(t_uint,”", 0);
def.addField(t_special2byte | t_uint,”", 0); // stupid 2byte field!
gDefList.push_back(def);
March 6th, 2008 at 9:45 am
Yeah the program hasn’t worked in awhile. I haven’t seen any other programs pop up to replace it yet either… Well since auto-detection of field changes is pretty much impossible at this point I was thinking about rewriting the whole thing to allow the definitions to be modified from an xml file, but due to school I haven’t really gotten around to it.
Check back everynow and then or subscribe to the rss to see my status on the project, I’ll try to make a post to update my progress when I get around to it.
March 6th, 2008 at 10:17 am
Doh! No longer works? Bummer. I REALLY need a library to parse the itemcache.wdb. Guess I’ll keep looking.
March 6th, 2008 at 10:53 am
Well it works, it just needs the definitions updated. Updating the program every patch gets ridiculous (you can’t simply read the header and guess fields like dbc files), so an updating xml file would be ideal.
April 1st, 2008 at 3:18 am
nice to see that u want return back to development,
It’s really needed, coz there is no any wdb converter, and it’s borrows too much time to take info from sites