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!