Would I have recognized this page earlier, I would have used tons of creations in here for my MANGOS-Server in 3.0.3. A pity I got a newer Skyfire-emu in the meantime, which is the only not-supportet emulator as it seems.
As I found no link for a skyfire-emu in wow-v item-creator, I decided to create one test-item and download the SQL-batch for MANGOS, which is most famliar with skyfire-database, so that I was able to make a comparison of item_template.
Don't know, if someone did that before, but as I searched for Skyfire-request in the google-search in the upper right corner of the side, I found a archived thread, where it has been asked for a code. So here it is. One in coparison-mode and one final-code to implement items.
- Green: Added column name
Crossed out: Column, which doesn't exist in item_template(skyfire)
Code with highlighted changes:
Code without crap:
With that code the batcher ran the process successfully. But as I add the item, I get a questionmark-symbol in my inventory, which says "Retrieving item information"(see pic below). That's in cause of the "WDBVerified"-column, I think, which tries to get information for this item from the linked MPQ-Data, where the DBC-data is placed.
I guess, there is no way to fix it without adding a mpq-file to the "\\data\cache"-directory?
Thanks in advice!