WinEQDB

WinEQDB is a Windows application that reads files created by the /note and /outputfile commands as well as your logs to create an out-of-game reference to all of your characters. (It's essentially a more feature-rich version of my EQHTML parser.)

Download Link: https://tinyurl.com/WinEQDB

The WinEQDB Character Detail page.

What it Does

WinEQDB reads the inventory and spellbook outputfiles to pull together your complete equipped/bagged/banked inventory, your entire spellbook, and if you're a caster, a list of spells you are missing. It also reads your log file to find out where you are bound and where you last parked your character. Finally, it reads the file created by the /note command, and even lets you edit that file while out-of-game. (Notes are shared among all of your characters.)

With all of that data, you can:

• Search all of your characters' inventories (including banked items) at once
• See a list of your character's missing spells
• Generate GINA triggers to watch for folks selling your missing spells
• View and edit the in-game Notes file
• Keep track of your various accounts, so you know which account each character is on, and can look up account information if you forget it
• Generate a portable HTML file with your character's information

How to Set it Up

1. Make make sure you have Log=TRUE set in the [Defaults] section of your eqclient.ini file (found in the Everquest game folder).

2. Within the game itself (for each of your characters), set up an Output hotkey and get in the habit of clicking it before you camp. It should look something like this (substituting "charactername" for your character's name):

   /outputfile inventory charactername_inventory.tab

   /outputfile spellbook charactername_spellbook.tab

   /charinfo

   Note: If you already have a hotkey set up for outputfiles, you may just need to edit it to change from .txt to .tab.)

3. After creating the hotkey, click it to generate your first outputfiles.

4. Download the zip file and extract it into a folder on your computer. Within, you'll find an installer called SQLLOCALDB.MSI, which you should install first. Afterwards, copy the WinEQDB folder to C:\ so that the program is in C:\WinEQDB. (It won't run correctly anywhere else right now, but in a future version I'll try to make it more flexible.)

5. Run WinEQDB.EXE from the folder to launch the program, and then go to File; Settings to identify key folders and then to add your characters. View the Help file for more instructions.

Dealing with Updates

The current version of WinEQDB is 1.0. (You can find out what version you're using by checking Help; About WinEQDB.)

• If you're installing a new version and you've already been using the program, unzip the file elsewhere and remove the \Data folder from the new version FIRST, and then copy the rest of the files/folders into C:\WinEQDB (or else you'll overwrite your data with an empty database).

Contacting Me

I mean, don't, if it's just for help setting it up or to tell me you don't like this tool. I'm not going to do tech support for this - if you need help getting it set up, ask one of your grandkids or something. But if you feel like saying "hey, I tried that thing you made and kind of like it a little bit", you can find me in game on Blue on Kobayashii of <Castle> (or any of the alts listed on that Magelo_Blue page), on Discord as kobayashiimaruu, or in the Facebook Everquest P99 group as LenPal.

Change Log

• V1.0 BETA 2 - The character window no longer needs to close and be reopened every time you import inventory, spells, or locations. Added a menu to View; Refresh the main window after adding characters so you don't need to close and reopen the application to see characters you just added.
• V1.0 BETA 1 - Initial version, but pretty complete.