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!

Menu
Pages: [1]

Author Topic: [HELP] Item-Sparse to item_template  (Read 2436 times)

soublast1337

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 17
    • View Profile
[HELP] Item-Sparse to item_template
« 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 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!
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

Amaroth

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 1219
    • View Profile
    • Amaroth's Tools
Re: [HELP] Item-Sparse to item_template
« Reply #1 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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged
English YT tutorial channel. Check it out if you preffer videos over walls of text.:
https://www.youtube.com/AmarothEng

Want to support me for my releases and/or tutorials? You can send donation via Paypal to:
jantoms@seznam.cz

Milly

  • Contributors
  • Creator of Worlds
  • *****
  • Posts: 503
    • View Profile
Re: [HELP] Item-Sparse to item_template
« Reply #2 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.
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged

soublast1337

  • Registred Member
  • GM Isle Explorer
  • *****
  • Posts: 17
    • View Profile
Re: [HELP] Item-Sparse to item_template
« Reply #3 on: December 16, 2014, 03:31:58 am »
Thanks milly. I will try that :)!
« Last Edit: January 01, 1970, 01:00:00 am by Admin »
Logged
Pages: [1]