What's new
  • Happy Cataclysm gaming! The long-awaited 4.3.4 Cataclysm Repack V19.0 is now live - and downloadable from our brand-new Emucoach App.
    Download it now
  • Mists of Pandaria is calling! Heya - did you know that the newest 5.4.8 MoP Repack - version 7.0 - is now live?
    Download now

Help Me

Astraroth

Veteran Member
41
2014
0
Location
Spain
I have a Problem Importing this Shield That I Myself have Created from WoW-V

Error :
Query:INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, 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, 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, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_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, ScriptName, DisenchantID, StatsCount)
VALUES (659599, 4, 4, -1, "Legendary Shield Overlord", 45653, 5, 0, 1, 500000000, 5000000000, 14, 1, 1, 160, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 2000, 3, 2000, 7, 3500, 12, 2000, 13, 2000, 14, 2000, 15, 2000, 35, 2000, 41, 2000, 46, 2000, 0, 0, 0, 0, 0, 0, 3550, 500, 500, 500, 500, 500, 500, 0, 0, 0, 174926, 1, 0, 0, 0, 0, 23920, 1, 0, 0, 0, 0, 871, 1, 0, 0, 0, 0, 2565, 1, 0, 0, 0, 0, 93322, 1, 0, 0, 0, 0, 1, "The Legendary Shield Overlord", 0, 0, 0, 0, 0, 6, 4, 0, 0, 500, 0, 165, 0, 0, 0, 0, 1, 0, 1, 0, 8, 0, 3307, 0, 0, 0, 'internalitemhanler', 0, 10)


Error occured at:2014-12-21 18:02:17
Line no.:2
Error Code: 1054 - Unknown column 'unk0' in 'field list'

Shield :
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, 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, 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, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_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, ScriptName, DisenchantID, StatsCount)
VALUES (659599, 4, 4, -1, "Legendary Shield Overlord", 45653, 5, 0, 1, 500000000, 5000000000, 14, 1, 1, 160, 85, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 2000, 3, 2000, 7, 3500, 12, 2000, 13, 2000, 14, 2000, 15, 2000, 35, 2000, 41, 2000, 46, 2000, 0, 0, 0, 0, 0, 0, 3550, 500, 500, 500, 500, 500, 500, 0, 0, 0, 174926, 1, 0, 0, 0, 0, 23920, 1, 0, 0, 0, 0, 871, 1, 0, 0, 0, 0, 2565, 1, 0, 0, 0, 0, 93322, 1, 0, 0, 0, 0, 1, "The Legendary Shield Overlord", 0, 0, 0, 0, 0, 6, 4, 0, 0, 500, 0, 165, 0, 0, 0, 0, 1, 0, 1, 0, 8, 0, 3307, 0, 0, 0, 'internalitemhanler', 0, 10);
 
Back
Top