Hello all! For this guide I will teach you how to make custom vendors and items! (Please note this is assuming you have HediSQL.)
Step 1) Go to the Mob/NPC Creator | WoW-V.com
Step 2) Enter the info. The entry ID should be 50000 if you've never made a vendor/npc before.
Step 3) Once you've entered all the info, if you're running ArcEmu download the *ASCENT* one (the ArcEmu one doesn't work for me)
Step 4) Open HediSQL, connect, and go to "Import -> Load SQL-File ..." then open your file, then press f9 on your keyboard.
You now have your vendor, but its empty! We have to add items to the sell template. To add items to your vendor do the following.
Step 1) Go to the Vendor Creator | WoW-V.com
Step 2) Enter all the info. The "Vendor EntryID" MUST match your npc's ID.
Step 3) Look on wowhead for items. To find the ID number, look in the address bar and at the very end are some numbers. That is the ID. (For example: You will see "?item=192" at the end of the address for Martin Thunder.)
Step 4) Once you've added all the items you want, download the ArcEmu SQL File. (I know I said Ascent for the last one but the one for ArcEmu works on this file)
Step 5) Open HediSQL, connect, go to "Import -> Load SQL-File ..." then open the file. Press f9 ONCE (you'll be sorry if you press it again, you will have extra copies in the sell template and we all know that doesn't look good!)
Go into WoW and login. Once you're in type .npc spawn id (assuming you used 50000 as the ID you'd type .npc spawn 50000). Talk to him to see if he sells and then if it works, congratulations.
Now I will teach you how to make custom items!
Step 1) Go to the Weapon Creator | WoW-V.com or the armor creator Armor Creator | WoW-V.com
Step 2) Put in the information. (As before make sure the entryID is 50000 or above)
Step 3) Download the file.
Step 4) Open HediSQL, connect, and go to "Import -> Load SQL File ..." then select the file and press open.
Step 5) Press f9 and its in the database!
Thanks for reading everyone! I truly hope this guide has helped you. If you have any questions (or you want me to change the damn color scheme) reply with your question! Also, you must restart your server for the changes to apply.