Difference between revisions of "WinEQDB"

Revision as of 16:08, 23 September 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 window.

The WinEQDB Spells and Missing Spells tab.

The WinEQDB Character Skills tab.

The WinEQDB Hotkeys and Abilities tab.

The WinEQDB Inventory Search window.

The WinEQDB GINA Triggers for Missing Spells window.

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
• Find missing spells for one character in the inventories/banks of your other characters
• 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
• Copy your INI file and UI file content from one character to another to get that new alt up and running fast

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.

Installation Troubleshooting

If you get database errors when you first run the program, note the following:

• Make sure you ran SQLLOCALDB.MSI before trying to run the program.
• Check to see whether a folder exists called C:\WinEQDB\Data - If not, create it (and follow the next step)
• Check to see whether there's a file inside C:\WinEQDB\Data called EQDB.mdf. If not, copy EQDB.md_ from C:\WinEQDB into the data folder and rename it to EQDB.mdf

Then try running the program again.

Dealing with Updates

The current version of WinEQDB is 7.13. (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.
• Version 5.53 and later will let you know if you're not on the latest version.

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