Stand-Alone Utility to Search ITEMS table

[GeorgeS]

...Since I am using my own tool so much, I have added a feature I needed - such as finding the spells for my class. I already knew the name of the spell, just needed the 'id', so you can now search for all spells by class.

I did not add race as I did not see a great deal of need for it.

GeorgeS

[Krugus]

George,

I have a minor request. Is there anyway you could have it so what you find could be saved to a text file?

I was just thinking how easy it would be if you could save it to a text file then input those numbers into your EQ Database excel program.

Just a thought...

[GeorgeS]

Yes, I'm sure that's possible. I will look into this and then post the update

George
aka Mr.G

[Krugus]

Thanks Mr G.

I was using it few weeks ago and that thought hit me. It would make creating Merchants very quick and easier

[GeorgeS]

Ok the newest version 1.2 is available with a attached help file with various query examples.

Also by default after each query is run, a tab-delimted file called eqitems.txt is written with item and item#

Mr.G



Sample Queries

(1) Find all weapons for Warrior (will find magical as well)
- Click on Weapon, Class=Warrior, Slot=ALL
notes - selecting slot=ALL means all weapons for every slot will be found


(2) Find all Magical weapons for Warrior (will only find magical)
- Click on Weapon, Class=Warrior, Slot=ALL


(3) Find all Magical weapons for Warrior in Secondary slot
- Click on Weapon, Class=Warrior, Slot=Secondary

(4) Find all SPELLS from Magician class
- Click on Spells, Class=Magician, Slot=ALL

(5) Find all Magical Bags for ALL Classes (only works for all classes)
- Click on Bag/Container, magical, Class=ALL, Slot=ALL

(6) Find all Potions/Food/misc items
- Click on Misc, Class=ALL, Slot=ALL

(7) Find all Potions/Food/misc items For Berserker in Primary Slot
- Click on Misc, Class=Berserker , Slot=Primary

( Find all Armour items For Berserker
- Click on Armour, Class=Berserker , Slot=ALL

(9) Find all Magical Rings/Bands (armour) items For Berserker in Finger Slot
- Click on armour, Class=Berserker , Slot=Left Finger

[Krugus]

Sorry to bother Mr G. but it seems the link is dead

[GeorgeS]

Restarted the server. WinXP update autorebooted the system :(
Anyway, let me know of any other features you all need


Mr.G