Stand-Alone Utility to Search ITEMS table

[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

[Doodman]

There is always the search from eqitems.13th-floor.org:

User Friendly:
http://eqitems.13th-floor.org/ufsearch.php

Advanced (guru):
http://eqitems.13th-floor.org/advsearch.php

[Belfedia]

But eqitems.13th-floor.org don't search in our custom db with custom item :p

Georges you make a great work
The only bad thing , that we need excel...

[GeorgeS]

This program is a compiled .exe, the database editor is VBA (Excel)

Mr.G