Stand-Alone Utility to Search ITEMS table

[GeorgeS]

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

[Sakrateri]

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

[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

[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

[GeorgeS]

FYI - the program can be found at

http://66.159.225.58/eqemu/eqitems.zip

[GeorgeS]

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

[GeorgeS]

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