Okay, I've seen alot of people asking how to create a Vendor in my days, so if anybody asks again, I'm gonna lead 'em to this Link Alright, lets get started with:
1) Click on 'Vendor Creator'
2) Name: Pick the Name of your Vendor (e.x. - Josh Romeo)
3) Subname: put what you want him to sell (e.x. - Food & Water Vendor)
4) Display ID: You will have to go on Thottbot or WoW, doesn't matter.
Thottbot way: Type in your wanted Creatures name (e.x. - Xylem) and then click on the correct 'Creature'. Now the Page URL for that mob should look like 'http://thottbot.com/c8379' or something close to it, with ####'s at the end. Now you want to CTRL+C or remember those numbers, then go to NPC Display ID Converter and type in the Code you got from Thottbot. Now a number should pop-up (e.x. - 7591) Now go and type that into your Display ID box on the Vendor Creator.
WoW Way: Log onto WoW (You must be a GM / Admin) and find the wanted Mob. Now .npc info on them and scroll up, looking for 'Display ID: ####' When you find that, the #'s after it are its Display ID, so you can just place them in the Vendor Creator and your done
5) Vendor ID: this is simply the ID that you will Spawn the Vendor with (e.x. .npc spawn #####)
6) Level: make this the Level you want the Vendor to be Spawned at.
7) Faction: there are 9 Factions to chose from, Stormwind, Ironforge, Orgrimmar, Darnassus, Undercity, Thunder Bluff, Silvermoon, Exodar and Neutral, which is the Argent Dawn. Choose one that you wish your Vendor to be.
Health & Mana: this is what Health the Vendor will have when it is Spawned, more HP gives it a bigger chance to not die if it is attacked. Mana is only if the Vendor has a Spell placed in it.
9) Mount Display ID: This is for people who want Vendors on a Mount, if you know the Item Display ID of a Mount (e.x. - 2410 as the SW Charger) then place it in there, only if you know the Display ID of a Mount in-game
10) Inventory: Now, there will be 'Vendor ID' 'Item ID' and 'Quantity', in Vendor ID, put the Vendor ID from Stage 5 there.
11) Item ID: is the .additem #### that you want the Vendor to sell
12) Quantity: For Ascent, you want -1, I am not sure for MaNGOS. I will post here for later Information on MaNGOS!
13) Click 'Submit' and a box should come up, if you are Ascent DL the Rev1 - Current Batch, Antrix the 'Antrix - rev1' and for MaNGOS, you have to click on the MaNGOS tab and then select the 'Project: Silvermoon DB rev. 14' Batch
14) Once Batch is done, HeidiSQL should show up, click 'Connect!'
15) Once inside HeidiSQL, click on the SQL Query
16) Now there are two blue arrows, one saying 'Execute SQL...F9' and the other saying 'Execute Selected SQL....CTRL+F9' click F9 or the first blue arrow pointing >> way
17) If it starts to lag, wait until its done.
1 Congratulations! Your Vendor has been added to your Server!
Hope this helps some Vendor-needy people
Bugs that may occur:
<No Sell Template Found> Bug
If this happens when you try to open up the Inventory of a Vendor to buy something, follow this:
1) Open up HeidiSQL/Navicat/SQLyog
2) Go into the Database 'Ascent' and find the Table 'Vendors'
3) Search for the Entry ID of the Vendor you created
4) Delete ALL Records of that Vendor (All Vendor Records)
5) Click 'Add Record' and fill it in accordingly:
Code:
Entry = #####
Item = #####
Amount = -1
Max_amount = 0
inctime = 0
Keep Max_amount and inctime at 0, and change the others with the correct ID's.
6) Do it until you have all Items in the Vendor
7) Save
Restart Server
9) Start Server and Spawn Vendor, the Items should all be working
10) Congratulations~!