Added the ability to search by focus types.
Added the ability to search by equipment type of any or a specific type like armor, shield, jewelery or instruments. Previous search just included all in the armor search.
Added the ability to search by any weapon type in addition to the individual types.
Fixed a bug that caused item search to fail when the "range" slot was selected.
Fixed a bug with invalid weapons coming up in weapon searches.
Invisibility versus Animals has been added to the database for Druid and Shaman. Thank you Tyler for the heads up.
Added about 750 classic items that were either missing a flag of misflagged. A lot of craftable and questable items have now been added.
The item search results now include weapon damage and weapon delay. These are also now fixed and are able to be searched just like the rest of the stats.
Also added are some more search options: you can now search by weapon ratio, item slot and haste percent!
Tightened up the item grid a bit and fixed the header appearance... also restored the sort functionality on the tables which I had working but was broken due to a really strange bug!
Click the table headers to sort by that column.
Also, about the item search I know there is damage/delay on the results grid... I will get that soon. Also plan to add class/race filters once I figure out how that works in the database. Also the ability to search by multiple weapon types.
How the item search fields work: If you leave an item filter blank it is not used in the query. If you include a value it gives you everything greater than or equal to that value.
Small update to EQStats to add the main page with news and a beta version of the item search.
Currently the item search will return items that are dropped from NPC's only. Since I have to manually flag items into eras from the database I have and dropped items are the easisest as I can add all items that drop from NPC's in a zone and flag them for the expansion it was released in. It's a good way to get a large chunk of items added, but is not 100% accurate. Please report any items that are listed incorrectly or dropped items only that are not showing up.