EZVendor - Create custom vendors from Wowhead search data!

[DarkVanir]

EZVendor is a cool new program, what allows you to make Vendor NPCs with WoWHead search Data. Works for ArcEmu/MaNGOS/Aspire.
The program is made by yuffles, all credits goes to him.

The following quote is from yuffles:

EZVendor is a tool I have written and released under the GNU GPLv3 (for details please see COPYING) to generate an SQL dump file containing creature_template entries and npc_vendor_item entries for MaNGOS, and with some quick changes in the SQL Template folder you can adapt this to ArcEmu/Trinity or practically any other format. (However I do not have experience with projects other than MaNGOS so I cannot do that)

How does it work?

You create a global "vendor prototype." All vendors you create from then on are based on that and can be edited from those values (at the moment certain prototype options are projected across all vendors and cannot be changed)

Each vendor you create has its own search URL. This URL is a wowhead item search results URL that you can paste in or use the built in web browser (Embedded IE6 ) to change. Items are added to the vendor in the order they appear on this page. Your items will be sorted on your vendor simply by using Wowhead's sort by columns features which are incredibly powerful. Combined with wowhead's filtering features you can add practically ANY collection of items you could imagine to a vendor.

When you want to add the information to a database click "export sql." The SQL is generated on the fly from your template files and wowhead search data. If you have a lot of vendors this may take some time as each wowhead page needs to be fully downloaded.

I will not go into too much detail here because the source is available, but wowhead uses a javascript list of items (all items found up to 200, not just the ones displayed on that page) and it is loaded, executed, and parsed by this program to produce a list of item-IDs.

Github repo (C#/.NET): Slurm's EZVendor at master - GitHub
Binaries Download: Downloads for Slurm's EZVendor - GitHub

I've made some SQL templates for Arcemu and Aspire. They are available from the repository as well (gzipped in the root directory) so you may export SQL for those databases as well.

I am not responsible if you mess up your database with garbage from bogus search URLs, if it doesn't start with "http://www.wowhead.com/items" use at your own risk.

As always I would love feedback, suggestions, criticism, etc.

Enjoy people. It's really useful.

[TheDefile]

Any chance of this working for trinity?

[DarkVanir]

If it works for Mangoz, it will work for Trinity too. I think the batch is almost the same, so... But when I get some free time (I'm going for a 3 day holiday) I'll do a Trinity SQL too.