3 replies to this topic

[Cerreth]

First comment: Great idea and wonderful item-creator, my +reps to the wow-v team. ;)

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.

The |CODE|

Legend:

• Green: Added column name
  
• Crossed out: Column, which doesn't exist in item_template(skyfire)

Code with highlighted changes:

Spoiler

INSERT INTO item_template (entry, `class`, subclass, unk0, `name`, displayid, Quality, Flags, FlagsExtra, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, ScalingStatDistribution, ScalingStatValue, damageType, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, Duration, Item-LimitCategory, HolidayId, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, WDBVerified, StatsCount)

Code without crap:

Spoiler

INSERT INTO item_template (entry, `class`, subclass, unk0, `name`, displayid, Quality, Flags, FlagsExtra, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, ScalingStatDistribution, ScalingStatValue, damageType, delay, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, Duration, ItemLimitCategory, HolidayId, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, WDBVerified)
VALUES (60100, 4, 2, -1, "ITEMNAME", 72592, 4, 0, 0, 1, 100000000000, 1000000000, 1, -1, -1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,  7, 70,  3, 70,  13, 100,  42, 200,  15, -50,  0, 0,  0, 0,  0, 0,  0, 0,  0, 0, 0, 0, 0, 0, 0, 7600, 1, 0, 0, 0, 0, 0, 14056, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "QUOTES", 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, 0, 4, 0, 3351, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Known Issue:
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.


The |Question|
I guess, there is no way to fix it without adding a mpq-file to the "\\data\cache"-directory?

Thanks in advice!

[Santewi]

Thanks for this info. If you (or someone else) can come up with a solution to the "Retrieving item info" problem, WoW-V could finally support Skyfire.

[Iguanadon]

very nice find, i hope this can be perfected and implemented soon. keep up the great work guys.

[gogasos]

if ur lazy you can just delete the item and replace it with an item with the same entry id. and it's recommended that it is from the same type "Dagger, 1h Sword.".

But. ofc the newly replaced item will appear in the same loot as the prev, item so don't get surprised if an dagger with 346945074 dmg appears when you kill an Molten Boar

Edited by gogasos, 15 July 2012 - 08:31 AM.