Hey,
As Im sick of my leecher status, I'm going to make a small guide about how to add custom items or NPC's to your private server, with Navicat.
However, I'm not going to tell you about how to set up your server or database, as there are enough other guides for this.
Making the item/npc
Go to ''www.wow-v.com''. Register if you haven't got an account yet, and login. Now, click on Items / Jewelery / Vendor / Mob, whatever you want to make. I'm telling you about how to make an armor piece now, making a npc or weapon is almost the same.
Name: name of the item
Quote: this will be the flavor text (orange text you sometimes see on an item).
Quality: this represents the item's color, like ''epic'' or ''uncommon''.
DisplayID: enter the display ID of the item you want your item to look like. You find the DisplayID the following way:
Go to Wowhead: We brake for dataz. and search for your item. Look into your browser to ''item=<ID>''. Copy this ID, and paste it on the DisplayIDfinder you see on WoW-v.
EntryID: the ID you use to spawn the item ingame. Choose a high number, with max 5 numbers.
Equip: where you equip it (ex. head or shoulders).
Material: choose if its cloth/leather/mail/plate.
Repair: choose if its repairable, or not.
Durabilty: the max durability, like 300.
Binds: when it binds (never, on use, on equip or on pickup).
Block: the block rating on the item.
Armor: the armor rating on the item.
Required level: the level you need to be able to use it.
Item level: the level of the item. Matters for enchants etc.
Max Number allowed: the max amount you may have of that item.
Allowable class: choose something if you want a class restriction.
Stackable: 0 or 1 for unstackable. Otherwise a number for the amount it can stack in.
Stat type: choose the amount of stats it have. Im not going to explain each stat, as I assume you know what they all do.
Item Resists: the resistance the item adds against magic schools.
Item bonusses: you can do this in 2 modes. Easy, and advanced.
With Easy, you can add small bonusses like +crit rating or +spellpower.
With Advanced mode, you can add effects like ''chance on hit'' or ''use:''. To choose what the effect is, look up the spellID on Wowhead: We brake for dataz.
Sockets:
You can add sockets to your item, with a max of 3. You can also choose from a big list with Socket Bonusses. You get this bonus if you put in gems with the corresponding colors.
Buy Price: the price the item costs if you add it to a vendor.
Sell price: the price you get for your item if you sell it to a vendor.
Now, click on Submit and check if everything went well. As you want to add it to your server, click on ''Download''. Choose the right Ascent or Mangos (depending on your server, I assume you know what you have). It will now open a notepad. Theres a chance it will automaticlly open it with Adobe or some other program. If this happens, save it to anywhere, rightclick it and choose ''Open as..''. Dont forget to tick ''always open as'', or whatever it is in your language =).
You will see a little script in your notepad. Select and copy this.
Add to your server
Now, to add it to your server, open Navicat. Connect, and click on ''Query''. Go a bit down and click on ''New Query''.
A new window will pop up, where you can write in. Paste the little script in there. Then click on ''Run''. If everything went well the item is added to your server. Restart your server or use a command to reload items (differs for everyone).
To see if it worked, log ingame and use 1 of these commands:
.lookup item <itemname>
.char additem <item ID>
Also, be sure to backup all your custom items much, otherwise much will be gone if something happens. You will find a Backup icon in Navicat.
Thats it, easy, not ?
F.A.Q.
Q: I get the error ''Duplicate entryID Found'' in Navicat.
A: Use another entryID, as yours is used already
Q: I get the error ''You have an error in your MySQL stynax, check the manual blablabla''.
A: You probably entered something in the script by accident which made the script unuseable, re-copy it.
Q: I get the error ''1146 - Table ''anything'' doesn't excists.''
A: You connected to the wrong tables, reconnect to the right one (world) at the starting screen of Navicat.
Q: I can't save my items on wow-v!
A: You have to pay money for that.
Q: I fill in the Id of an item to get its displayID, but I get the displayID from a npc!
A: Re-open the displayID finder.
Q: How can I create totems/librams/sigils/relics on wow-v?
A: Sorry, you can't.
Q: I made loads of items, but I forgot to add ''stat x'' or ''bind on x''. Do I have to make them all over?
A: No, however it can be a bit annoying. Go to the table in Navicat with all your items. There, go to the item(s) where you want to add/delete something. Look for what number to edit (which can be annoying to find), and edit those all.
Note from Errage:
Please do not post in this thread; while you may have found it through Google, it's over 2 years old. (Note added due to repeated bumping)