Tool - Merchant Editor

**GeorgeS** · #1 01-25-2008, 03:24 PM

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** · #2 01-25-2008, 03:58 PM

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 · #3 01-25-2008, 04:21 PM

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** · #4 01-25-2008, 06:33 PM

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 · #5 01-25-2008, 07:53 PM

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** · #6 01-27-2008, 07:19 AM

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 · #7 01-27-2008, 07:46 AM

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...