Results 1 to 14 of 14
  1. #1
    Banned
    Reputation
    616
    Join Date
    Feb 2009
    Location
    Holland
    Posts
    1,372
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

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



    Donate to Remove Ads, Get ShoutBawx - Elite Forum Access
    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 01:57 PM.

  2. #2
    Master Sergeant handofoberon's Avatar
    Reputation
    7
    Join Date
    Nov 2006
    Posts
    102
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    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
    Banned
    Reputation
    86
    Join Date
    Mar 2008
    Location
    Incognito
    Posts
    497
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Last edited by Keithh; 05-23-2009 at 06:30 PM.

  4. #4
    Banned
    Reputation
    616
    Join Date
    Feb 2009
    Location
    Holland
    Posts
    1,372
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Quote 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.


    Quote 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
    Banned
    Reputation
    616
    Join Date
    Feb 2009
    Location
    Holland
    Posts
    1,372
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Added some new FAQ questions, and made the ''Add to your server'' a bit more clear .

  6. #6
    New User

    Reputation
    2
    Join Date
    Feb 2009
    Posts
    22
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Thanks for this!

  7. #7
    Member
    Reputation
    1
    Join Date
    Nov 2008
    Posts
    6
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Thanks, i was looking for this. +Rep

  8. #8
    New User

    Reputation
    2
    Join Date
    Aug 2007
    Posts
    22
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Very good guide for noobs +Rep

  9. #9
    Banned
    Reputation
    616
    Join Date
    Feb 2009
    Location
    Holland
    Posts
    1,372
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Bringing
    Up
    My
    Post

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

  10. #10
    New User
    Reputation
    1
    Join Date
    Jul 2009
    Posts
    5
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    I have question. how I use Navicat? Its 1st time when I use it... -.-"

  11. #11
    Banned
    Reputation
    284
    Join Date
    Jan 2009
    Location
    Belgium
    Posts
    484
    Blog Entries
    1
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    WoW-V will be obsolete soon.

  12. #12
    Member
    Reputation
    3
    Join Date
    Jul 2009
    Location
    Canada
    Posts
    101
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    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
    Panda Panda

    CoreCoins User

    Confucius's Avatar
    Reputation
    743
    Join Date
    Oct 2007
    Location
    Portland, OR
    Posts
    2,224
    Blog Entries
    7
    CoreCoins
    9934

    Trade Feedbacks

    Status
    Superior trader
    Positive
    3 (100%)
    Negative
    0 (0%)
    Quote 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.

    Real knowledge is to know the extent of one’s ignorance



  14. #14
    Sergeant Major salsworn's Avatar
    Reputation
    22
    Join Date
    Apr 2008
    Location
    New York City
    Posts
    165
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Quote Originally Posted by Allstar .ιllιlı. View Post
    WoW-V will be obsolete soon.
    Why?......??
    disregard females, acquire currency

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 03:41 AM. Powered by vBulletin® Version 4.2.0
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved. Resources saved on this page: MySQL 5.88%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search