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 7.14)
(→‎Change Log)
 
(45 intermediate revisions by one user not shown)
Line 9: Line 9:
 
[[File:Inventory_search.png|thumb|right|alt=The WinEQDB Inventory Search window.|The WinEQDB Inventory Search window.]]
 
[[File:Inventory_search.png|thumb|right|alt=The WinEQDB Inventory Search window.|The WinEQDB Inventory Search window.]]
 
[[File:wineqdb-gina.png|thumb|right|alt=The WinEQDB GINA Triggers for Missing Spells window.|The WinEQDB GINA Triggers for Missing Spells window.]]
 
[[File:wineqdb-gina.png|thumb|right|alt=The WinEQDB GINA Triggers for Missing Spells window.|The WinEQDB GINA Triggers for Missing Spells window.]]
 +
[[File:Mob_timers.png|thumb|right|alt=The WinEQDB Mob Timmers window.|The WinEQDB Mob Timers window.]]
  
 
== What it Does ==
 
== What it Does ==
Line 19: Line 20:
 
* See a list of your character's missing spells
 
* See a list of your character's missing spells
 
* Find missing spells for one character in the inventories/banks of your other characters
 
* 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
 
* 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
 
* 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
 
* 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
Line 45: Line 48:
 
== Dealing with Updates ==
 
== Dealing with Updates ==
  
−
The current version of WinEQDB is '''7.14'''. (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 56: 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 62: 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.50''' - The Mob Timers window now clears the text fields when you click Add, Save, or Delete.
 +
* '''Version 8.41''' - Added a list (imported on startup if it hasn't been imported yet) of important mob timers.
 +
* '''Version 8.40''' - Added the Mob Timers window, which searches your logs to keep track of mobs' times of death so you can view their respawn windows.
 +
* '''Version 8.30''' - The 'Jump to Character' and 'Jump to Mule' droplists are now available on all tabs of the Character window rather than only on the Character Detail tab, and you no longer have to click a button after making a selection. Additionally, you are asked whether you want to save changes before switching. When opening the character window if 'Automatically Immport Character Data' is selected in the settings window, now ALL data for the character is imported, rather than just inventory, spells, and locations.
 +
* '''Version 8.20''' - Added Needed Spells in Inventory report to the main application window and Character window. This report searches all characters (or just the current character, if selected from the Character window) for spells in their inventories that other characters are currently missing. Fixed some broken links in the Help file.
 +
* '''Version 8.10''' - The main application form now allows you to select multiple characters (or mules) at once so you can use the Tools menu to set them as mules (or vice versa). You now double-click a character or mule to open it in the Character window instead of single-clicking. Added "See Also" sections to all Help pages. Added tooltip pop-ups on nearly every component of WinEQDB. Enabled context-sensitive help on all windows of the application, so that you can press F1 to open the help page for that window. Fixed an issue that was preventing the characters' race from appearing on the Discord-formatted character list.
 +
* '''Version 8.01''' - Added some logging to file for DB troubleshooting.
 +
* '''Version 8.00''' - Completely rewrote the Help file to make it much more useful, including several "How To" sections, as well as explanation pages for each window of the application and a much more useful keyword index. Inventory Search now allows multiple sections of accounts. Added the ability to change a hotkey slot to empty. Added a warning when deleting an account. Added a check for duplicates when creating an account. Removed the Biography section from the "Character Sheet" report when the character does not have a biography. Made minor aesthetic changes to several windows. Added Help; What's New? to the main application window.
 +
* '''Version 7.60''' - Added a field to enter the name of your guild on the Character window, and included the value of that field within the P99 Magelo output. Added the ability to copy one character's UI to all other characters. Added the ability to merge and sync all characters Friend/Ignore lists. Fixed an issue on the Character List report that was resulting in an error if a character hadn't yet selected a class, race or deity at the time the report was run.
 +
* '''Version 7.50''' - You may now select multiple files at once when adding characters in the Settings window.
 +
* '''Version 7.40''' - Eliminated the account reference list on the main application window and moved its data to the Character and Mule lists on that window for better readability. Made the File; Update All Characters menu option update *everything*, including hotkeys, friend lists, and UI. (It takes a little longer, but keeps everything up to date more easily.) Fixed an issue in which item images were not importing for some users, leaving the graphical inventory display blank.
 +
* '''Version 7.31''' - Updated the default database so new users won't have to wait while the program imports skill data, spell data, and item data that had been added after the last default database was generated.
 +
* '''Version 7.30''' - Added graphical display to the Character Sheet report when saved as HTML through File; Save as HTML. Added the ability to save advanced inventory searches. Fixed the rest of the windows that could potentially load off-screen after an update. Now, when loading a saved search or clicking one of the "useful searches" buttons on the Inventory Search window, the rest of the search form is cleared before populating the search form. Fixed an issue preventing the 'Bind Wound', 'Harm Touch', 'Lay on Hands', and 'Mend' skills from being selectable in both the Abilities and Combat Skills drop lists on the Hotkeys and Abilities tab of the Character window.
 +
* '''Version 7.21''' - Fixed an issue in which folks with single monitors sometimes found that the main application window or other windows were opening off-screen after updating. Added a pop-up to remind you to close an existing report window before trying to run a new report. Fixed an issue that could use the application to crash when importing Friends/Ignore lists that contained illegal characters. (It happened to at least one person.)
 +
* '''Version 7.20''' - Added Help; Diagnostics to the main application window to assist in troubleshooting.
 +
* '''Version 7.16''' - Fixed an issue in which an empty inventory slot on the graphical view would cause an error message when that slot was clicked.
 +
* '''Version 7.15''' - Database issues fill me with hate.
 
* '''Version 7.14''' - More compatibility fixes.
 
* '''Version 7.14''' - More compatibility fixes.
 
* '''Version 7.13''' - Stupid version-checking still was giving one user a hard time.
 
* '''Version 7.13''' - Stupid version-checking still was giving one user a hard time.

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

Retrieved from "https://wiki.project1999.com/index.php?title=WinEQDB&oldid=462483"