Tool - Merchant Editor

[GeorgeS]

Glad you like the tool/s

Still working on them

GeorgeS

[Aethor]

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.

[GeorgeS]

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

[Aethor]

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.

[GeorgeS]

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

[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

[ChaosSlayer]

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!