This is a wiki for a reason. Anyone can contribute. If you see something that is inaccurate or can be improved, don't ask that it be fixed--just improve it.
[ Disclaimer, Create new user --- Wiki markup help, Install P99 ]

Difference between revisions of "WinEQDB"

From Project 1999 Wiki
Jump to: navigation, search
(Version 8.51)
(Change Log)
 
(26 intermediate revisions by one user not shown)
Line 48: Line 48:
 
== Dealing with Updates ==
 
== Dealing with Updates ==
  
The current version of WinEQDB is '''8.51'''. (You can find out what version you're using by checking '''Help; About WinEQDB'''.)
+
The current version of WinEQDB is '''11.01'''. (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 [https://tinyurl.com/WinEQDB download link]. Open the Zip file and overwrite your existing C:\WinEQDB folder with the one in the zip.
 
* You can get the latest version at any time by clicking the [https://tinyurl.com/WinEQDB download link]. Open the Zip file and overwrite your existing C:\WinEQDB folder with the one in the zip.
Line 59: Line 59:
 
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 '''[https://wiki.project1999.com/Magelo_Blue:Kobayashii_Maruu Kobayashii]''' of [https://wiki.project1999.com/Castle <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'''.
 
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 '''[https://wiki.project1999.com/Magelo_Blue:Kobayashii_Maruu Kobayashii]''' of [https://wiki.project1999.com/Castle <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'''.
  
 +
(That said, I'm open to hearing feature requests and/or crash bugs and the like. Use the contact information above.)
  
 
== Change Log ==
 
== Change Log ==
Line 65: Line 66:
 
|-
 
|-
 
|
 
|
 +
* '''Version 11.01''' - Minor bug fixes.
 +
* '''Version 11.00''' - Added a Goals/Tasks tab to the Character detail window, allowing you to set goals for your characters and track your progress.
 +
* '''Version 10.00''' - Added 'Bot' checkbox on the Character Detail window and 'Bot/Shared Character Selection' list on the main application window.
 +
* '''Version 9.44''' - Changed the messy list views on the main application window to data grids for better readability.
 +
* '''Version 9.43''' - The lists on the main application window now include the last zone each character or mule was in, if known.
 +
* '''Version 9.42''' - Fixed a bug that was incorrectly parsing the server for characters on Green (setting them to 'blue' in the database).
 +
* '''Version 9.41''' - Updated the log scan process for the Mob Timers window, which was not recognizing ToD for Kelorek`Dar.
 +
* '''Version 9.40''' - Now, when adding characters from the Settings window, WinEQDB will quickly scan the new characters' logs for a /who that lists the character's name and use that to determine their class, race, and level automatically.
 +
* '''Version 9.31''' - Removed a popup I was using to debug a particular issue in 9.30 that I had forgotten to remove before publishing that version.
 +
* '''Version 9.30''' - When all accounts are selected within Inventory Search, the results will now include characters with no account selected.
 +
* '''Version 9.20''' - Added a Created field to the Character Detail window. Added the ability to reset an Ability, Combat Skill, or Discipline back to 'blank'. Added buttons that allow you reposition socials on socials pages. Added the ability to share entire pages of socials.
 +
* '''Version 9.10''' - Copying a shared social will now replace the name of the character who saved the social (if it's in lines of the social) with the name of the character to which it is copied.
 +
* '''Version 9.06''' - Continued fix related to 9.04/9.06.
 +
* '''Version 9.05''' - Continued fix related to 9.04.
 +
* '''Version 9.04''' - Made slight changes to database connection to resolve a security issue that prevented some users from being able to open the database.
 +
* '''Version 9.03''' - The lists on the main application window now sort first by level and then by XP, and the 'jump to' lists on the Character window now sort by level and then XP as well.
 +
* '''Version 9.02''' - Further improvement to the sync friend/ignored list functionality.
 +
* '''Version 9.01''' - Added database backup and restore functionality. Fixed an issue in which friend/ignored notes were being overwritten when synced across characters. More fixes related to classically misspelled spells.
 +
* '''Version 9.00''' - Added backup and restore functionality.
 +
* '''Version 8.64''' - Fixed an issue where classically misspelled spell names were showing the correct spelling in some lists but the misspelled version in other lists.
 +
* '''Version 8.63''' - Fixed an issue with copying shared socials.
 +
* '''Version 8.62''' - Switching characters should now remember the currently selected tab (except when the tab is 'Spells' and you're switching to a monk, rogue, or warrior).
 +
* '''Version 8.61''' - Fixed an issue in which saved socials were removed from the list when the .INI file was imported for the character(s) whose socials were saved. 'Fixed' an issue in which 'Jump to Character' and 'Jump to Mule' sometimes landed you on a different tab than the one you were on when clicked if either the current or selected character (but not both) was either a monk, rogue, or warrior. (And by fixed I mean for now they always go to the Character Detail tab.)
 +
* '''Version 8.60''' - Added 'Refresh From All' button to the Mob Timers window, which searches all Character logs (skipping mules) for updated mob timers.
 +
* '''Version 8.52''' - Fixed an issue that could cause a database error in one extremely rare circumstance.
 
* '''Version 8.51''' - When opening the Accounts window, any accounts in which the username is blank are updated so that the username is the word 'BLANK', allowing them to be edited or deleted.
 
* '''Version 8.51''' - When opening the Accounts window, any accounts in which the username is blank are updated so that the username is the word 'BLANK', allowing them to be edited or deleted.
 
* '''Version 8.50''' - The Mob Timers window now clears the text fields when you click Add, Save, or Delete.
 
* '''Version 8.50''' - The Mob Timers window now clears the text fields when you click Add, Save, or Delete.

Latest revision as of 02:45, 19 August 2025

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 Character Detail window.
The WinEQDB Spells and Missing Spells tab.
The WinEQDB Spells and Missing Spells tab.
The WinEQDB Character Skills tab.
The WinEQDB Character Skills tab.
The WinEQDB Hotkeys and Abilities tab.
The WinEQDB Hotkeys and Abilities tab.
The WinEQDB Inventory Search window.
The WinEQDB Inventory Search window.
The WinEQDB GINA Triggers for Missing Spells window.
The WinEQDB GINA Triggers for Missing Spells window.
The WinEQDB Mob Timmers window.
The WinEQDB Mob Timers window.

Contents

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 P99 Magelo data you can quickly copy and paste to keep your Magelo up-to-date easily for use at Magelo_Blue, Magelo_Green, or Magelo_Red.
  • Generate GINA triggers to watch for folks selling your missing spells
  • Keep track of mob timers and respawn windows by searching your logs for the mob's time of death.
  • 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 11.01. (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.

(That said, I'm open to hearing feature requests and/or crash bugs and the like. Use the contact information above.)

Change Log