Tool - Merchant Editor

[Chrono]

Nice work GeorgeS.

Another addition I think would be useful, is after the Merchant ID name, perhaps the zone name aswell?

[ChaosSlayer]

ah amazing =)
one final request.
Please allow to select multyple items from the list so when I click Find or Delete it will find/delete all currently selected items from all merchants.

Another good feautre would be searching by item ID, specificly by range of IDs

thank you mcuh George =)

[GeorgeS]

Finished adding the multi-select feature

Merchant Editor
ver 1.6.5 In item search box, you can now Multi Select and find ALL selected items sold by merchants AND Delete Multi-Selected Items now - per request.

Enjoy

GeorgeS

[GeorgeS]

Forgot to add, you can now also search items by partial name as in "RUSTY", a item# as in "1001" or a range as in "1001-1050"

Enjoy
GeorgeS

[ChaosSlayer]

Geogre, I can't seem to figure out how to do the "1001-1050" search thing.

The find all and delete all on multyple select works flawlessly thanks again =)

[GeorgeS]

For the searches by range, its just 1001-1050. i.e - low number hyphen hi number with no spaces in between. It should work as is.

GeorgeS

[ChaosSlayer]

umm nope- can't seem to get it find anything this way.

tried:

1001-1050 - nothing found
1001 1050 - nothing found
"1001-1050" - crashes the program

[GeorgeS]

The code for this is bullet-proof - checked and re-checked again. Sql it spits out is fine. What is does is run a query like this
sql="Select * from ITEMS where id BETWEEN 1000 AND 1999"

Make sure you have the recent dl for this. If it still does not work, then the above sql must not work. I have no idea beyond this

I'm on mysql 4.xx

GeorgeS

[ChaosSlayer]

well I have mySQL 5.(something) installed

i run these comands in my mySQL browser all the time, so something must have happening in bitween...

[Astaldoath]

Why is it that the merchant editor adds the items I select too all the merchants in the zone? Instead of just one merchant? Tool is unusable for me like this.

Edit: Yeah any item i add or remove goes on all the merchants in the list

[Astaldoath]

Ahh george I see a bug, you need them Item Query List to refresh each time you select a new merchant. It is giving a false reading so it looks like every merchant has the same item. Really really annoying hehehe

[Astaldoath]

Originally Posted by Astaldoath

Ahh george I see a bug, you need them Item Query List to refresh each time you select a new merchant. It is giving a false reading so it looks like every merchant has the same item. Really really annoying hehehe

Sorry. When the merchant is empty you click on the list wont refresh, it works if the merchant has items

[GeorgeS]

Originally Posted by Astaldoath

Ahh george I see a bug, you need them Item Query List to refresh each time you select a new merchant. It is giving a false reading so it looks like every merchant has the same item. Really really annoying hehehe

I changed a few lines of code to refresh the list. Obviously the program worked fine before on my pc, so I hope this compile helps. If not please describe the issue in greater detail.

GeorgeS

[Warking]

Link isn't working anymore for the merchant editor. Is there an updated link?

[GeorgeS]

Merchant Editor is now integrated with and NPC and Loot Editor. This makes the stand alone obsolete.

GeorgeS