What's wrong with adding this item?
Hell once again, i come back with another issue. I got my server running fine with MaNGOS, ok so im using SQLyog to try to add items, i copy the code from the wow vandetta website into the "Querys" Tab and add them. Then i run this code:
Code:
INSERT INTO item_template (entry, class, subclass, unk0, name, name2, name3, name4, 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, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, 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, ExtendedCost, RequiredDisenchantSkill, ScriptName, DisenchantID)
VALUES (90000,2,7,-1,"Illidarin sword","Illidarin sword","Illidarin sword","Illidarin sword",1542,6,0,0,50009999,999999999,13,-1,-1,70,70,0,0,0,0,0,0,0,50,1,0,1,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,10000,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,9331,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,0,0,"Illidans general sword.",0,0,0,0,0,1,3,0,0,0,0,999,0,0,0,0,0,0,1,0,2,0,0,0,0,0,"internalitemhanler",0);
And then i get this:
Code:
Error Code : 1054
Unknown column 'RandomProperty' in 'field list'
(0 ms taken)
What is wrong?
Re: What's wrong with adding this item?
Have u tried to put 0 in the null slots instead of leavin blank?