How to make custom items / vendors for your private server (edited name)

[renitharis]

I'm posting this because I used search and it wasnt found on this forum topic, because matt deleted most of the posts so I decided to tell people how!

#1 Go to WoW Vendetta - Wage Your War

#2 Press Tools

#3 Press either Armor Creator, Weapon Creator, Bag Creator, Ammo Creator, or even vendor creator.

#4 Customize the item to how you want, to get the displayID you can go to Wowhead: World of Warcraft Database and search the item you want, look the item's ID up on your items file in Navicat/SQLyog.

#5 Fill the display ID into the right place on wow-v.com.
#6 The entry# can be what ever you want as long as it isnt taken, you can see the highest entry# if you just sort all your item entries on your sqlyog/navicat and go to the highest, then make the number higher then the highest number in your item entries.
#7 Most of the rest of the stuff on there is pretty self explainitory, for the vendor creator find the creature ingame or on wowhead, go into wowhead, search it and do the same thing you did with the items, except in the creatures files.
#8 (forgot this) Save it to a file where you'll remember it, I suggest you make a file called "Custom Weapons" or something in your repack folder, and then go on navicat/SQLyog, and execute the batch file, and open the weapon/armor/vendor file and it should go directly to the designated area.

If you have any questions just ask here.

[Zabitako]

ok, so im new to all this custom items,mysql, etc etc, so yea....anyways, whatcha mean make it into a file? that the only way to like make the item or something? plz help me, im a noob at this >.<

p.s. flame if u must...lol...

[dog6611]

The wow-v.com site has been suspended!!!

[WoWLegend]

Wow-v.com got suspended? oh lord no....

[skepter]

I was literally in the middle of making a weapon, when I realized I couldn't hit Submit so I refreshed the page and it says its suspended.

[renitharis]

Oh christ! You're right! WE'RE FUBAR!

[Zabitako]

WoW-v seems to be working for me right now, doesnt say anything about being suspended

[renitharis]

Okay must have been down for the day =)

[damon161]

sum1 help me i made one but i keep getting an error heres my sql

insert into `items` (`entry`, `class`, `subclass`, `field4`, `name`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `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`, `range`, `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`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('34570001','2','8','-1','Frostmourne','Frostmourne','Frostmourne','Frostmourne','35152','5','0','0',' 0','17','-1','-1','200','70','0','0','0','0','0','0','0','1','1','0','4','135','7','168','5','9 5','32','170','36','125','0','0','0','0','0','0','0','0','0','0','704','921','0' ,'24','52','4','0','0','0','0','0','0','0','0','0','0','0','0','0','15','0','0', '3500','0','0','19260','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','1','Whomsoever takes up this blade shall wield power eternal. Just as the blade rends flesh, so must power scar the spirit.','0','0','0','0','0','1','1','0','0','0','0','500','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0');

[renitharis]

Damon, just save that into some file, go into sql? And idk how to execute batch files, but do so, and find the weapons file, and presto you got your item.

[Bohater]

ok i made a wep, so how do i excexute the batch file? and is there something that needs to be done after that?

EDIT: nvm i fugred it out

[renitharis]

Kk great!!!!

[damon161]

i did execute it and got an error this is the error i get

[Err] 1062 - Duplicate entry '34570001' for key 1
[Err] insert into `items` (`entry`, `class`, `subclass`, `field4`, `name`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `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`, `range`, `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`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('34570001','2','8','-1','Frostmourne','Frostmourne','Frostmourne','Frostmourne','35152','5','0','0',' 0','17','-1','-1','200','70','0','0','0','0','0','0','0','1','1','0','4','135','7','168','5','9 5','32','170','36','125','0','0','0','0','0','0','0','0','0','0','704','921','0' ,'24','52','4','0','0','0','0','0','0','0','0','0','0','0','0','0','15','0','0', '3500','0','0','19260','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','1','Whomsoever takes up this blade shall wield power eternal. Just as the blade rends flesh, so must power scar the spirit.','0','0','0','0','0','1','1','0','0','0','0','500','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

and this is the sql i executed

insert into `items` (`entry`, `class`, `subclass`, `field4`, `name`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `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`, `range`, `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`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('34570001','2','8','-1','Frostmourne','Frostmourne','Frostmourne','Frostmourne','35152','5','0','0',' 0','17','-1','-1','200','70','0','0','0','0','0','0','0','1','1','0','4','135','7','168','5','9 5','32','170','36','125','0','0','0','0','0','0','0','0','0','0','704','921','0' ,'24','52','4','0','0','0','0','0','0','0','0','0','0','0','0','0','15','0','0', '3500','0','0','19260','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','1','Whomsoever takes up this blade shall wield power eternal. Just as the blade rends flesh, so must power scar the spirit.','0','0','0','0','0','1','1','0','0','0','0','500','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0');

fixed just cant add to inventory

[sam2012]

how do i execute

[damon161]

how do i execute

u execute by opening navicat or sqlyog and right clicking on your server name
and look for execute batch file