mangos 2.1.3 tbc server custom weapons

[legendkkf]

i need help creating custom weapons for a mangos 2.1.3 server, i've made the weapon on wow-v.com and i don't know what to do next. Can someone help me?

[morgmorg]

1. Open up SQLYOG or w/e u use.
2. Hit execute batch file
3. Find your custom wep
4. Hit execute
5. Then go into wow and use the .additem to add your wep

[jakeiscool]

I did that and it said [Err] 1062 - Duplicate entry '12345' for key 1
[Err] 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, Extra, unk_203, 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 (12345,2,15,-1,"GM Killer","GM Killer","GM Killer","GM Killer",30312,6,0,0,0000,0000,13,-1,-1,999,1,0,0,0,0,0,0,0,2,1,0,1,10000,31,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,999,9 99,0,999,999,5,999,999,6,0,0,0,0,0,0,0,100,100,100,100,100,100,500,0,0,18060,1,0 ,0,0,0,17713,1,0,0,0,0,17713,1,0,0,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,1,"This blade was forged in the depths of Hell",0,0,0,0,0,1,0,0,0,0,0,999999,0,0,0,0,1,0,1,0,1,0,90,0,0,0,"internalitemhan ler",0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[grond]

its probably wrong ID for it or sumthing. must be another wepp by the same ID.

[warsheep]

Grond has answered, but i just gotta ask... Do you even READ the errors? There are tons of questions you can do yourself... I mean, look at the first pieces of text:

I did that and it said [Err] 1062 - Duplicate entry '12345' for key 1

Not to be rude or something, but try to take the time to solve errors yourself. People can answer, and people can help, but if you ignore everything else, and ask for every problem you get, without even trying to solve it, you arent going to get so far...

[Dalamar]

I did that and it said [Err] 1062 - Duplicate entry '12345' for key 1

As said above, the ID is in use, just find an ID that is not used and switch '12345' with that. 123456 would probably be open as blizzard hasn't reached that high yet.