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

(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

[Krugus]

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

[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

[mplostcause]

Everytime I try to load the program I get the error "Failed to load control 'cntrl_SKinableForm' from . Your verison of may be outdated. Make sure you are using the verison of the control that was provided with your application." What exactly am I doing wrong? I have a bad feeling its something stupid lol.

[GeorgeS]

Anyone else having a load up issue?
What OS's are you running?

GeorgeS

[Angelox]

Anyone else having a load up issue?
What OS's are you running?

GeorgeS

If you mean the item search utility that works with the npc_loot_edit.exe - works fine for me . Even the ' bug is gone as in Muramite's Shield.

[GeorgeS]

no, it's the item viewer & tool to equip characters

http://66.159.225.58/eqemu/eqitems.zip

GeorgeS

[mplostcause]

I am using windows xp with SP 2 on that computer. All the other utilities I've downloaded from your site work great. I just have the problem with that one.

[Angelox]

It loaded with me , I got a runtime error when I clicked on an item, but I might have done something wrong there.

[GeorgeS]

I've added some error checking so crashing should be less common.
Anyway, I'm going to add a few features to the build this week...

One feature I've added was let's say I wanted to find a ring for my wizard, so I searched for who drops the one I want and then find where the NPC is found - zone ,x,y,z etc.. a usefull feature in my book.

GeorgeS

[GeorgeS]

Let me know if this works for you all.

Some people see a error after clicking on an item - in that case let me know the db your'e running, and the item name it crashed on + the error msg


GeorgeS

[GeorgeS]

Also, if you're getting an error, please report it here.
I need to know if the error occurs after WHICH query - this helps alot!

Some people report a 'armour reference error', when doing a armour query, but what happens when you do a weapon or misc, bags query?

This is important because If I cannot reproduce the error - then cannot fix the code.


GeorgeS

[GeorgeS]

Ok finally found the problem. items.loreflag was pulled from the 0.7.x db schema. Now the program works!!!

I will u/l it tonight.

Also, does anyone know why the serialization fields are 'null' in 0.7.x?

GeorgeS

[Belfedia]

Ok finally found the problem. items.loreflag was pulled from the 0.7.x db schema. Now the program works!!!

I will u/l it tonight.

Also, does anyone know why the serialization fields are 'null' in 0.7.x?

GeorgeS

Perhaps because Eqemu don't use anymore serialization ?

[GeorgeS]

Thanks, I just realised that after I types that in. No more serialisation means making items became much easier to implement.!

GeorgeS

[Thristam]

ummm,

I might be screweing up and not understanding somthing, but umm, where is the exe for this? its not in the DL?

[John Adams]

Re-download, Thristam. I think there was a problem with the most recent package. The exe is now in there.

Thanks GeorgeS!

[GeorgeS]

Correct, the download zip was missing a file for some odd reason..

GeorgeS