[Guide] Adding Custom items with WoW-V

[joelieherp]

Hi guys, it's my first guide i made
for MMOwned.com. I know there are more Custim item making
guides out here but i tryed to make a very easy one. Here we go:



Things you will need:
-An account at the WoW-V site.
-Ascent DB access.
-HeidiSQL or NaviCat
-Mozzila firefox or Internet Explorer (I'd prefer Firefox).

Step 1 : obtaining the displayID
The first thing is obtaining your objects displayID. You can obtain your objects displayID by going to WoWHead. And search for an Item, in this case it will be a worn shortsword.
If you have found the item you want to use, you'll be on a page with an item icon and some information 'bout the item. Link. Now just right-click on the screen and hit "View page Source". If you've done that hit <Ctrl>+F and search for: "DisplayID". You will get the following result:
displayId: 1542.
Now you've got your DisplayID, remember it.

Step 2 : Creating the item
Go to WoW-V (WoW-Vendetta). And register/login. Click on "Weapon" (left top corner of the page). This will link you to the weapon creator section of WoW-V.

The first thing you need to do is putting the displayID, so you won't forget that. Then you should need to make a unique Entry #. Why unique? Because the entry is the item identification, and you will need it to spawn your item.
If you've done both you can put a name of the weapon you are going to make. I've put for example "Uber sword". And if you want, it's not necessary.. You can attach a Quote to the weapon. The Quote is the tiny yellow text that will appear at the bottom of the item information.

Now you've done the necessary stuff you would like to put some stats to the weapon? It's pretty simple, just scroll down and fill in the boxes you see.
If you've done that at the bottom of the screen you will see 2 buttons: "Submit" and "Reset". Hit submit. You will see the following things:

All you need to do now is hitting the bug download button and after that the (Depends on your Repack) 2nd button. "Download Batch".

Step 3 : Adding the .Sql file to your DB (DataBase)
All you need to to now is adding your downloaded item (.Sql) to your DataBase. It's pretty simple, All you need to do is double-click the file and a HeidiSQL window will open up. Hit connect and go to the "Query" tab. You will see the following code:

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, ReqDisenchantSkill, unk2)
					VALUES (40000,2,0,-1,"Uber sword","Uber sword","Uber sword","Uber sword",1542,0,0,0000,0000,13,-1,-1,60,0,0,0,0,0,0,0,0,0,1,0, 7,500, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,50,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,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,0,0,0,0,"You are not Prepared!",0,0,0,0,0,1,3,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Change "INSERT INTO items (entry, class, subclass, field4, name, name2,"
to name1, or else there will be a error, and you won't be able to import the code. If you've done all that, you may hit <F9>. If i'm right no errors will come up.

That was the HeidiSQL part. The Navicat part is more annoying if some errors come up, So first (before opening the file) right click your .SQL file. Then open with: Notepad and change name, to Name1,
Then open Navicat and right click your database (Ascent>ascent).
After that click "Exexute batch file...". No errors if i'm right.

Part 4 : Adding the item in-game to your character
Start wow, Log in, and type in-game the following command:

.Additem #id

In this case it's .additem 40000
It can be that the server won't recognize the Gm command.
Then try to use the following command:

.character additem #id

is this case it's .character additem 40000.

Now you're done with your new custom made sword! Enjoy!

[oMSQo]

it's not working it gives me some eror :|

[joelieherp]

what error?