[TOOL][WOTLK] Item DB<->DBC

[Amaroth]

ClientItem is a tool which gets all items from server's item_template table and generates a new item.dbc.csv file and items.csv file. Item.dbc.csv can be then converted into item.dbc which is completely up to date with a database, so you won't have to ever again edit this DBC directly, you can just always generate a new one. Items.csv is to be placed into your WMV's enUS (or similiar) folder, and it will update WMV's local item database as well. WMV can't handle unicode characters, so content of items.csv is unaccented on purpouse. To use simply:

- If you've never done so before, consider running ItemDBCToDB first. Explanation is in that tool's description.
- Run ClientItem.
- Fill your credentials and click on Get data.
- Convert generated item.dbc.csv into DBC by using included DBCtoCSV converter DBCUtil and place it into your MPQ and server's dbc folder.
- Place items.csv into your WMV's enUS (or similiar) folder.
- Done.



ItemDBCToDB is here to get list of all items in item.dbc which are missing in your server's item_template and to insert their generated versions into that item_template. This can be useful if you want to give players possibility to use some items which were made for NPCs, but never for players (for example weapon and shield of gnome king, weapons of NE sentinels...). If you don't use this tool at least once before using ClientItem, you'll LOOSE all these NPC items which aren't present in item_template. This will lead into loosing all items held by NPCs which aren't in item_template, and into server error log spam. So consider running this tool once before ever using ClientItem.

- Get your up to date item.dbc. Create its CSV version.
- Run ItemDBCToDB. Select your item.dbc.csv, fill your credentials and click on Insert data.
- Done.

C# src is included. I'm opened to suggestions and feedback, however, I'm quite busy so I'll probably just fix critical bugs if you happen to find any.

Download HERE:
https://www.dropbox.com/s/z87tfudql9xq4 ... m.rar?dl=0

[Amaroth]

Released C# src. A little cleanup of src. Added ItemDBCToDB tool and DBCUtil for DBC to CSV and back conversions.

[Piccolodmq]

Hi there Amaroth.   regarding this tool.    I got everything working, with custom wod items, (got the DB info, and pacthes in clients, but still getting the red ? error, and can´t wear, the items.  So something else must be wrong.

But great tool!

[Amaroth]

In that case, have you put updated Item.dbc into your custom MPQ? It sounds to me like you did not.

[moonpaladin]

Hi, I followed all the steps but by adding the item.dbc to my patch, I do not see some npcs weapons, like the weapons of the orgrimmar guards, etc.

Thanks in advance.

[Amaroth]

You were probably not really following all steps:
"If you've never done so before, consider running ItemDBCToDB first. Explanation is in that tool's description."

And that explanation is here:
"ItemDBCToDB is here to get list of all items in item.dbc which are missing in your server's item_template and to insert their generated versions into that item_template. This can be useful if you want to give players possibility to use some items which were made for NPCs, but never for players (for example weapon and shield of gnome king, weapons of NE sentinels...). If you don't use this tool at least once before using ClientItem, you'll LOOSE all these NPC items which aren't present in item_template. This will lead into loosing all items held by NPCs which aren't in item_template, and into server error log spam. So consider running this tool once before ever using ClientItem."

I made video about usage of this pair of tools, and this fact is mentioned there, too.:

So:
- Use ItemDBCToDB to get all NPC-only items into item_template, making them accessible AND preventing them from being lost in next step.
- Use Client Item to get all item.dbc which is up to date and contains everythig: NPC-only items, original player-accessible items and your new custom items as well.

[moonpaladin]

Thanks alot Amaroth, it works perfect.