kandi
23-08-10, 02:29 PM
ALL Credits for this go to yuffles from wow-v.com I did not create any of this it is simply a share because I found it extremely useful and wanted other people to be able to use it
http://img641.imageshack.us/img641/1378/screenshotyk.jpg (http://img641.imageshack.us/img641/1378/screenshotyk.jpg)
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 http://wow-v.com/forums/Smileys/classic/undecided.gif) 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 (http://github.com/Slurm/EZVendor)
Binaries Download: Downloads for Slurm's EZVendor - GitHub (http://github.com/Slurm/EZVendor/downloads)
I am not responsible if you mess up your database with garbage from bogus search URLs, if it doesn't start with "Items - World of Warcraft (http://www.wowhead.com/items)" use at your own risk.
As always I would love feedback, suggestions, criticism, etc.
Update:
DarkVanir has made some very nice 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.
http://img641.imageshack.us/img641/1378/screenshotyk.jpg (http://img641.imageshack.us/img641/1378/screenshotyk.jpg)
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 http://wow-v.com/forums/Smileys/classic/undecided.gif) 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 (http://github.com/Slurm/EZVendor)
Binaries Download: Downloads for Slurm's EZVendor - GitHub (http://github.com/Slurm/EZVendor/downloads)
I am not responsible if you mess up your database with garbage from bogus search URLs, if it doesn't start with "Items - World of Warcraft (http://www.wowhead.com/items)" use at your own risk.
As always I would love feedback, suggestions, criticism, etc.
Update:
DarkVanir has made some very nice 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.