Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => "Retro-Porting" => Topic started by: soublast1337 on December 15, 2014, 04:37:12 pm

Title: [HELP] Item-Sparse to item_template
Post by: soublast1337 on December 15, 2014, 04:37:12 pm

Hello modcraft.


I got some awesome help earlier with models and I have a request again (sorry, im the noob trying to learn xD)

So I have googled for HOURS litereally trying to find a way to populate the item_template.

I have extracted all the CATA and MOP item models to 3.3.5 but I need to create the items in item_template.

I only found this: viewtopic.php?f=59&t=7522 (http://modcraft.io/viewtopic.php?f=59&t=7522" onclick="window.open(this.href);return false;) but that doesnt work properly and only gives 1 item per 1.

Does anyone have a tutorial on how to get a MIST OF PANDARIA english item-sparse converted so I can add some of the data into item_template? I basically just need the entry, class, subclass, name, displayid and inventorytype thats it :)

I hope some of you can help me. And do any of you have a new MOP DBC folder? I do not feel like downloading 20GB just to get 11mb of data. Thanks guys!

Title: Re: [HELP] Item-Sparse to item_template
Post by: Amaroth on December 16, 2014, 02:18:29 am

Item_template is database table, it has nothing to do with client, thats just server side (MySQL DB) editing. But I can't advice you any further, never worked with MoP. Just look into your server world database for item related tables.

Title: Re: [HELP] Item-Sparse to item_template
Post by: Milly on December 16, 2014, 02:48:00 am

After WotLK, Item-Sparse.db2 became the new way to manage items in WoW. Item_Template is basically empty. So what soulblast1337 is asking to do is to populate his 3.3.5a database with Cata and MoP item values from Item-Sparse.db2. And unfortunately there's no magical tutorial for this.

Best thing I could suggest is to follow my tutorial which is linked in the same thread you posted. Convert Item-Sparse to a csv file, and then use Notepad++ and rearrange the columns so that it fills all the criteria for the Item_Template database table. Then import the csv file into MySQL.

All of that should be explained in my tutorial. I left a note at the bottom of the thread about DB2 to CSV conversion. Then you can read the rest from there. Only thing you would have to do is rearrange the columns so it fits.

And have fun with that cause it sounds tedious as hell.

Also I should note that I can't really speak much for MoP. If they changed Item-Sparse.db2 then this might not work.

Title: Re: [HELP] Item-Sparse to item_template
Post by: soublast1337 on December 16, 2014, 03:31:58 am

Thanks milly. I will try that :)!