[Guide]How to make custom vendors, and add items to it later on! menu

User Tag List

Results 1 to 7 of 7
  1. #1
    FrozenWoW 01's Avatar Member
    Reputation
    9
    Join Date
    Jul 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Guide]How to make custom vendors, and add items to it later on!

    In this guide, I will show you how to make custom vendors, add items to them, keep those custom items there, and how to add more if you ever need to.

    In this first part, I will show you how to make custom vendors...

    1.) Go to WoW Vendetta
    That link will take you directly to the vendor creator.

    2.)

    Name: Name for your vendor
    Subname: Name that appears under the NPC name.
    Display ID: This can be found in creature_names DB or in-game by selecting a NPC and typing .npc info, then scroll up until you find "Display ID"
    Vendor ID: ID for the vendor (e.g .npc spawn [vendor id])
    Level: Level of the vendor
    Faction: The faction of the vendor (I recommend Neutral Faction if you are putting it in a horde/alliance mall)
    Health: Amount of HP the vendor has
    Mana: Amount of Mana the vendor has
    Mount Display: If you want your vendor on a mount, put the display ID for the mount here (The display ID for mounts would be the same as any other creature)
    Vendor Type: The type of vendor you want (e.g Just Purchase, or you can repair at that vendor as well.)


    Now that you are done with that section of the vendor creator, lets move on down to the adding the items part.

    3.)

    Vendor ID: The same ID you put above in the Vendor Details (.npc spawn [ID])
    Item ID: The ID for the item you want to put in the vendor
    Quanity: How many of this item do you want in your vendor? (Keep this blank or at 0 to make it unlimited)

    Now if you want to have more than 1 item, just press "Add Item", in the small green letters.

    If you do add another item, put the same vendor ID you did above, and a different item ID.

    4.) Adding the vendor to your server...


    In this picture I am using Navicat.

    This is a SQL executer. The SQL file for your new vendor will be at the bottom of the WoW Vendetta page (the same page where you created the vendor).

    You have 2 options..
    1. Copy and paste the text in the box under the "Ascent Core Query" in to your SQL executer.
    2. You can press the "Download Batch" button. Downloading the batch will save the SQL file to your computer.

    If you do save it to your computer, you can load it in into the SQL Executer by pressing the "Load" button in your SQL Executer (4th button on the navigation bar)

    Locate the SQL file on your computer and press load. This will load all the text from the SQL file into your SQL Executer.

    Once the text is in the SQL Executer, press "Run" (First button on navigation bar)

    If you were sucessful, it will say something like..
    "Affected rows: 1
    Time: 0.001ms"


    5.) Once you have executed the SQL file into your database, enter game and type ".server reload creature_names" and ".server reload creature_proto"

    Now your vendor is on your server! Type ".npc spawn [id for your new vendor] to spawn him. It will require a server restart for the items to appear. Now the items will stay in the vendor, instead of dissapearing after a server restart/crash.


    --------------------------------------------------------------------------------------------------------------------------------------------------------

    In this last part, I will show you how to add more items to the vendor, and keeping them there...

    1.) Go into your "ascent_world" database and find the database, open it.

    2.)

    Entry: Your vendor ID (.npc spawn [vendor id])
    Item: An item ID
    Amount: How many of that item you want in the vendor (0 is unlimited)
    max_amount: How many can you carry of this item? (0 is unlimited, 1 is unique)
    inctime: I dont really know what this is, leave at 0
    extended_cost: Again, dont know what this is. Leave at 0

    3.) Save all that by pressing the check mark at the bottom of the screen.

    4.) Restart your server and the items should show up in the vendor! and unlike doing .npc vendoradditem [item id], the items will actually stay in the vendor!





    Thank you for reading my guide! Enjoy!
    Last edited by FrozenWoW 01; 08-10-2008 at 03:18 AM.

    [Guide]How to make custom vendors, and add items to it later on!
  2. #2
    FrozenWoW 01's Avatar Member
    Reputation
    9
    Join Date
    Jul 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No replys? =[

  3. #3
    LJN's Avatar Member
    Reputation
    273
    Join Date
    Jun 2007
    Posts
    731
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very nice +Rep
    Sorry that you are not getting replys.
    ahhhh

  4. #4
    Herleybob's Avatar Contributor
    Reputation
    178
    Join Date
    Jul 2007
    Posts
    663
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Another way to add items, is in game, Tpye .vendoradditem #####

    Nom Nom Nom :P

  5. #5
    FrozenWoW 01's Avatar Member
    Reputation
    9
    Join Date
    Jul 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Herleybob View Post
    Another way to add items, is in game, Tpye .vendoradditem #####
    Actually, I made this guide because whenever I did that., the items would disappear after a crash or restart. And yes, I did try putting a 1 at the end. They would still disappear. So the command does not add the item to the vendor database. and I even said at the end of my guide.. "and unlike doing .npc vendoradditem [item id], the items will actually stay in the vendor!"
    Last edited by FrozenWoW 01; 08-12-2008 at 10:42 PM.

  6. #6
    wraith619's Avatar Member
    Reputation
    10
    Join Date
    Aug 2008
    Posts
    10
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome guide, good pics and easy to use +Rep

  7. #7
    yodat's Avatar Member
    Reputation
    1
    Join Date
    Aug 2008
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    gr8 guide man thanks alot

Similar Threads

  1. [Guide] How to make Custom Vendors [Noob Edition]
    By Mango Jerry in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 11-12-2010, 05:05 AM
  2. [Guide] How to make custom vendors and items!
    By Azshaz in forum WoW EMU Guides & Tutorials
    Replies: 11
    Last Post: 07-31-2009, 04:31 PM
  3. [Guide]How to make Custom Class Trainers and Npc.
    By Xcynic in forum WoW EMU Guides & Tutorials
    Replies: 56
    Last Post: 07-28-2009, 02:43 PM
  4. [Guide]How to make Custom Class Trainers and Npc.
    By glh290 in forum WoW EMU Guides & Tutorials
    Replies: 4
    Last Post: 12-25-2008, 04:19 PM
  5. [Guide] How to make Custom Vendors with ADE
    By Greensponge in forum WoW EMU Guides & Tutorials
    Replies: 22
    Last Post: 05-07-2008, 11:33 PM
All times are GMT -5. The time now is 04:49 AM. 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