Stand-Alone Utility to Search ITEMS table
 

As an addon to my Excel_eq database editor, I am releasing a utility (.exe)
that allows you to search the ITEMS table and identify items by class and type, etc...

It will also identify which NPC drops the item/s

get it here
http://66.159.225.58/uwe/eqitems.zip

...place contents anywhere, but you must put a copy of your db.ini in the folder.

GeorgeS

Wow , thats really cool thanks ! think theres anyway you could get race in the search options too? Really neat tool how it is now though thanks :)

extra
 

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

Minor Request...
 

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

text file
 

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

George
aka Mr.G

...
 

Thanks Mr G. :)

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

save text file
 

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

(8) 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

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

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


Mr.G

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

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

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

Mr.G

Link update
 

FYI - the program can be found at

http://66.159.225.58/eqemu/eqitems.zip

updated for 0.6.6
 

Works for 0.6.6 PEQ compatible database/s. Of course this tool works best if you have custom items not in any other database.

Remember searches are saved in a text file for your reference (found in root folder), and this data can be used to create merchants or in general spawn items in game.

GeorgeS aka Mr.G

newer version
 

Ok there's a much improved version

Worked hard to bring a few updates to the table.
I've done a total rewrite of the eqitems program, now it not only allows searching of your items, but you can load in any character and change or equip him/her with any items.

Also, to facilitate better version comunication, i've set up a webpage for all my downloads. Check out the files and don't hesitate to email me bugs.

http://66.159.225.58/eqemu/eq.html

GeorgeS