Why don't any of my custom items work? {MANGOS}

[Deathboy312]

I am using a Mangos core, i use WoW vendetta to make custom items. And it doesnt work. Here is the Weapon 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 (900234,2,1,-1,"Alkaznhm","Alkaznhm","Alkaznhm","Alkaznhm",28460,6,0,0,99999999,99999999999,17,-1,-1,70,70,0,0,0,0,0,0,0,50,1,0,1,5000,13,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,10000,0,50000,100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,99,0,0,18060,1,0,0,0,0,36409,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"Alkaznhm god of thunder bringer of death.",0,0,0,0,0,1,3,0,0,0,0,99,0,0,0,0,0,0,1,0,8,0,106,0,0,0,"internalitemhanler",0);

And here is the Error i get with SQLyog:

Error Code : 1054
Unknown column 'RandomProperty' in 'field list'
(0 ms taken)

So what is wrong? Plz tell me how to fix (in an answer for a noob) Because i want to learn how to make my own weps.

[MentaL]

[jeane_vellix]

Use QUICE, you can find it on mangosproject forum,
with QUICE you can do lot costum things...Costum Quest, Item NPC, Creature...

[3nd3r]

and what the hell is quice?

[alexgus]

and what the hell is quice?

if you read the post she/he did carefully you'd see what it is
" with QUICE you can do lot costum things...Costum Quest, Item NPC, Creature..."

[MrPFox]

Or you could just learn to use vendetta :P When you make an item you end up with the code at the bottom. MAKE SURE YOU SELECT YOUR SERVER TAB (theres fantick or something, MangosTBC and Antrix), each tab will give different code so you want the right one. Once you selected the MangosTBC tab there are 3 boxes of code...Dnt be stupid and just grab the first one. Each box supports a different version. My Mangos 2.1.1 server uses the last one. Best way to find out is to copy and paste it to the Query box and hit run. If it errors like you got, its the wrong one. One of those boxes will give "(1 row updated)" or something like that. Congrats, you now have your item. Just remember the entry number to spawn it. (warning, the newest items on thottbot wnt work on your server, these unfortunately include the most shiney of epics) But the new warglavies work fine. :) The old ones are still in the DB if you want those D-IDs (the red long bladed ones)
New Green Warglaives:
Display IDs (45479 Main hand, 45481 Offhand)