Tool - Merchant Editor
 

Finished a comprehensive tool to manage merchant lists.

The program can do things like search for items (by keyword), and asign selected items to selected merchants. You can even assign items by a probability (%chance roll) to selected merchants. Also adding/removing merchant lists is very easy. (spreading a list among merchants)

Finding merchants is done by searching by zone or by (All zones) world.
(It does not create merchants, just manage sell lists - creating merchants is done with my npc edit tool)

Hope you enjoy this tool.
http://66.159.225.58/eqemu/Merchant_Editor.zip

http://66.159.225.58/eqemu/eq.html

GeorgeS

my world editor -
http://66.159.225.58/uwe/uwe.html

Once again GeorgeS an amazing job. And many thanks for your hard work.

Very nice! Bravo!

Good job now to figure out how to use it~

Greate tool!!!!
Keep up the good work man!!
/cheer

Glad you like the tool/s

Still working on them :)

GeorgeS

Awesome job with all the tools. It has cut down on time so much. They're absolutely amazing. I can't get the merchant editor to work though. It simply freezes when I run it.. I get the Lets Start button and it loads editor screen then it freezes every time. I've run the resources many times and downloaded your drivers. All your other tools work fine. This is the only one that has trouble. Any suggestions? Thanks. Even if I can't get it to work, the other tools have been great.

Ok, I am looking into this. The program runs a long query on startup where
it checks for invalid merchants and then fixes them. This can take a while.

I will look at the code to make sure its ok for MySQL 5.x


GeorgeS

You are right about a very long time. One of my friends who uses this only takes a few seconds to load, for some reason it takes mine 20 minutes +/-. We're doing the same database and my computer is vastly faster than his. I did leave it going for about 30 minutes last night while I did other things and it finally stopped Not responding. Maybe just something weird on my end but it works. I've made several merchants. Sorry if I caused you more work. Again, the tools are awesome, thank you.

Not sure why it took a long time, but I rewrote some of the intro code which fixes bad merchant links etc..
My guess is your settings for MySQL are not optimal for iterative sql

Newest version is posted

GeorgeS

A new exciting update has been added - you can now import a tab delimited item list into the merchant tool and assign any or all items to any merchants. You can also "scatter" the items among any merchants as well, so you spread them out among them.
Enjoy the latest update

GeorgeS

regarding the tab delimited file, my eqitems editor exports this file in resources/eqitems.txt, whenever you perform a search. Thus export all Cleric Spells, and import the list and assign the spells to any merchants. That way you can at least buy all your spells. You can also make a complete spells merchant by class

is it posible to use this program to find all merchant who have item X for sale?
and remove item X from all merchants in game with a single click?

thanks!

I'll add this to my workflow. It's a good feature to have. thanks

GeorgeS

thank you GeorgeS!
It woudl be nice feature to have- I am making my own items by re-using old eq items, and I don't want my players to find raid boss loot on some forgotten vendor in Halas =)

Finished the feature request for the merchant editor -

/1/ You can now search for an item and see which merchants sell it.
/2/ You can delete any items from all merchants via a single click.

These are available via the item search button.

ver 1.6 is ready for download.

GeorgeS