[Guide] How to: WoW-V & Adding those items (Navicat) menu

User Tag List

Results 1 to 14 of 14
  1. #1
    Aldun's Avatar Banned
    Reputation
    616
    Join Date
    Feb 2009
    Posts
    1,365
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Guide] How to: WoW-V & Adding those items (Navicat)

    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)
    Last edited by Errage; 05-17-2011 at 12:57 PM.

    [Guide] How to: WoW-V &amp; Adding those items (Navicat)
  2. #2
    handofoberon's Avatar Member
    Reputation
    7
    Join Date
    Nov 2006
    Posts
    102
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I made a chance on hit ability for a staff to do Dragons breath but when I try to import it says it has an error in the SQL Syntax
    Nubbzorz 4 Li4e =D

  3. #3
    Keithh's Avatar Banned
    Reputation
    86
    Join Date
    Mar 2008
    Posts
    493
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Last edited by Keithh; 05-23-2009 at 05:30 PM.

  4. #4
    Aldun's Avatar Banned
    Reputation
    616
    Join Date
    Feb 2009
    Posts
    1,365
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by handofoberon View Post
    I made a chance on hit ability for a staff to do Dragons breath but when I try to import it says it has an error in the SQL Syntax
    Did you choose the right download link at WoW-v? If youre sure you did, theres probably a mistake like no damage on the staff, or no speed. Those are required stats. Otherwise you probably made a typo by accident in the script.


    Originally Posted by Keithw View Post
    Why don't you whine about the million ''Set up your server'' guides too then? Also, he doesn't explain well how to add the item into your DB.
    Last edited by Aldun; 02-17-2009 at 05:05 AM.

  5. #5
    Aldun's Avatar Banned
    Reputation
    616
    Join Date
    Feb 2009
    Posts
    1,365
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Added some new FAQ questions, and made the ''Add to your server'' a bit more clear .

  6. #6
    nubblez's Avatar Member
    Reputation
    2
    Join Date
    Feb 2009
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for this!

  7. #7
    Walkerz's Avatar Member
    Reputation
    1
    Join Date
    Nov 2008
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, i was looking for this. +Rep

  8. #8
    krual's Avatar Member
    Reputation
    2
    Join Date
    Aug 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very good guide for noobs +Rep

  9. #9
    Aldun's Avatar Banned
    Reputation
    616
    Join Date
    Feb 2009
    Posts
    1,365
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bringing
    Up
    My
    Post

    Because I don't see any other of those guides somewhere at the top >;]

  10. #10
    alfa206's Avatar Member
    Reputation
    1
    Join Date
    Jul 2009
    Posts
    5
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have question. how I use Navicat? Its 1st time when I use it... -.-"

  11. #11
    Allstar .ιllιlı.'s Avatar Banned
    Reputation
    284
    Join Date
    Jan 2009
    Posts
    481
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    WoW-V will be obsolete soon.

  12. #12
    Sheldrake's Avatar Member
    Reputation
    3
    Join Date
    Jul 2009
    Posts
    101
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    great guide, thank you!

    and here i was trying to just do the "Excecute batch file"... no wonder it didn't work xD

  13. #13
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1389
    Join Date
    Oct 2007
    Posts
    2,591
    Thanks G/R
    265/283
    Trade Feedback
    7 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Keithh View Post
    And your's is a repost of mine http://www.mmowned.com/forums/emulat...ers-guide.html don't flame.

  14. #14
    salsworn's Avatar Active Member
    Reputation
    22
    Join Date
    Apr 2008
    Posts
    162
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Allstar .ιllιlı. View Post
    WoW-V will be obsolete soon.
    Why?......??
    disregard females, acquire currency

Similar Threads

  1. [Guide] - How to WOW: An in depth analysis
    By falarious in forum World of Warcraft Guides
    Replies: 2
    Last Post: 08-30-2008, 12:07 AM
  2. [Guide]How to make custom vendors, and add items to it later on!
    By FrozenWoW 01 in forum WoW EMU Guides & Tutorials
    Replies: 6
    Last Post: 08-16-2008, 04:25 PM
  3. [Guide] How to get Gold quick (On those Battle Realms)
    By Chenquie in forum WoW EMU Exploits & Bugs
    Replies: 0
    Last Post: 07-21-2008, 01:24 AM
All times are GMT -5. The time now is 04:07 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search