Difference between revisions of "WinEQDB"

Revision as of 07:38, 28 August 2024

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.3. (You can find out what version you're using by checking Help; About WinEQDB.)

• You can get the latest version at any time by clicking the download link. Open the Zip file and overwrite your existing C:\WinEQDB folder with the one in the zip.
• You don't have to install SQLLOCALDB.MSI when upgrading to a new version; you only need to install it the first time you set up WinEQDB.
• You no longer have to worry about overwriting your database file; newer versions will check your database version and update it if necessary, and will create one if it doesn't exist, but will not overwrite one if it does exist.

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

• Version 1.3 - Added the ability to search for multiple items within the same search (such as for any Velious quest armor drops your characters may have tucked away in their banks). Fixed an issue where the drop lists and grid views on the Character Detail window were doubling up each time you imported inventory, spells, or locations. Rearranged the Attributes window so that WIS comes before INT like it is everywhere else. Neatened up all of the grid views so the columns fill the available area. Updated the default (empty) database to the current version.
• Version 1.2 - Added the ability to edit and delete account records. Added the ability to delete characters. Fixed an issue that let you save an empty account info record. Fixed a bug that crashed the application when trying to save a search term. Fixed an issue that prevented the bind point from being imported in some cases. Fixed an issue that caused the wrong column titles to be displayed on the Accounts window. Fixed an issue that allowed multiple instances of the Character Detail window to be displayed at once (even for the same character).
• Version 1.1 - Fixed some bugs, mostly. No longer in beta after a beta testers were able to run it successfully.
• V1.0 BETA 4 - Added the ability to save (and delete) a search term on the Search window. Added the ability to populate the Notes window with some basic character data (name, level, class, account nickname, last zone, bind point, and notes) to create a quick in-game reference for all of your characters.
• V1.0 BETA 3 - Added a field called 'Notes' to the character window to keep track of goals and other details. (Eventually the Notes window will optionally import each character's notes so you can have an in-game reference. Added a check to verify that the database version is current and to update it with missing tables/fields if necessary. Stopped a crash from happening if you tried to import from external files that did not exist. Set the character form to automatically save the form fields when importing from external files.
• 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.