I reorganized this one AGAIN. I fixed those capitalization errors, but I was doing some further testing with it again today and it was building the query wrong if you selected certain search criteria together. It was putting FROM arguments in the WHERE clause.

Anyway I went in and re arranged it all to make more sence, and so that it could have new things more easily added to it in the future.

I already added several things to the Availability section. It Was:

More +

-
Mob Dropped
Merchant Sold

now it is:

More +

All
Mob Dropped
Merchant Sold
Ground Spawn
Fished
Combined

Combined is a little ambiguous so I will say that it returns items that are a result of a successful tradeskill combine.

So please.... what other search criteria would be nice?

P.S.

I already intend on adding Quested items to it, I just have some work to do on quest parser first.