Terms of Use

This software is Copyright (c) 2008, 2017 Mark Harrison. All rights reserved.

Permission is hereby granted, free of charge, to use and redistribute this software in unmodified form, for non-commercial purposes, and provided that any use or redistribution retains or reproduces, in the documentation and/or other materials, the copyright notice above, this permission and the following disclaimer.

Disclaimer

This software is provided "as is", without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and non-infringement. In no event shall the author be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the software or the use or other dealings in the software.

How to Install

  1. Download Database Query 3.0.2 and extract it to a folder.
  2. Run the Setup.exe program.
  3. As with all plug-ins, you should back your data by going to Backup Database on the File menu.
  4. After you have a good backup created, go to the Tools menu and choose Database Query.

Known Issues

Here's a list of known issues...

  • The loading time is awful. If you have a large collection or slow computer, it's even worse. If you have both, be prepared for a long wait. Hopefully Invelos will provide us with a faster method to access the database in a future release. For now you can speed things up by not loading cast and crew data. Of course then you won't be able run cast or crew queries either.
  • Because of limitations in the plug-in SDK provided by Invelos, if you enable the option to show popups when hovering over a title, you get some odd behavior. It's nothing too bad, but you can turn off that option in the Options screen if you want.
  • While the plug-in is loading its data, it is a very bad idea to make changes to your database. I've tried to program in safeguards. For example, if you edit a profile while the data is loading in the plug-in, it will cancel the load process. But I wasn't able to protect against everything. So if you do something really stupid like restore from a backup while it's trying to read the database, you'll get really nasty results. Trust me, I tested it already. So do yourself a favor and don't change data until the plug-in is done loading.
  • If editing profiles through the plug-in rather than the program you should know that you will not get any warnings if there is a newer profile to download.
  • If you close the Database Query window, it remains running in the background. So if you swich to a new database, you'll get a popup asking if you want to reload the data for example.

History

Version 2.9

New Fields to Query On

  • Received as Gift
  • Gift From
  • Color Type
  • Dimensions
  • Case Slip Cover
  • Variant

New Features

  • Custom collections are now fully supported in Filters.
  • Custom media types are now fully supported in Filters.
  • Updated code to .NET 4.0.
  • Increased audio tracks from 8 to 16.
  • Now handle all 3 Countries of Origin.
  • Added Average Movie Rating to Summary screen (it only counts movies that have been rated).
  • Countries of Origin should now match what is in the main program. And it always should from here on out.
  • Displays the database name in the window title and location.
  • New Filter option to filter out child profiles of combo sets. If the child profile has the same title (i.e. the DVD in a Blu-ray Combo), it will filter it out.
  • Accepted Birth Years tab in Filters now has a Delete All option.
  • Added Edition to popup window to help when edition isn't displayed with the title.
  • New displayable column: Variant
  • Can optionally load both cast and crew head shot data. This takes a VERY long time, so it's been made optional.

Bug Fixes

  • Sorting by Collection Number fixed.
  • Country of Origin bugs fixed.
  • The uninstaller cleans up after itself better now.
  • Fixed a bug with Ratings being reported wrong.
  • The Tags tab in the Filter window no longer jumps to the end of the list when switching to that tab.
  • Fixed a bug with Media Companies that was throwing off all the results.
  • Fixed bug in new Average Movie Rating if no profiles were rated.
  • Miscellaneous bug fixes, spelling changes, performance improvements and other things.
  • Fixed a bug reading disc events when the person in question has only a first or last name.

New Queries

  • Added "Missing Collection Numbers" query to Count As field. To find profiles with count as values but no collection number.
  • Added new field under General called All Profiles. It lists all profiles using the current filters.
  • Added new query to Disc Descriptions called "Descriptions but no disc ID".
  • Added "Price per minute" query to Purchase Price and SRP.
  • Added "Count people by first letter of name" and "Display people by first letter of name" to the Name field in Cast and Crew queries. WARNING These queries take a VERY long time to run.
  • Added "Count loaned by user" to Loaned. This will count how many profiles have been loaned by each user and how long on average they keep things.
  • Added "Count watched by user" to Loaned. This will count how many profiles have been watched by each user.

Fixed / Updated Queries

  • The "Cast/Crew with birth years" queries will now let you search for cast and crew at the same time.
  • Moved video queries to Features & Formats tab to match their location in the main program.
  • When running the Missing Child Profiles query under Box Set Contents, the display updates correctly now when the children are added.
  • Missing Child Profiles query now lists the missing child IDs.
  • Renamed Other to Other Features to match the interface in the main program.
  • Fixed the counts for Media Types.
  • Fixed bug that was causing the counts to be off for Audio queries.
  • "Count profiles by media company" and "Count profiles by studios" now allow you to click the company to drill down further.
  • The Contains function on the Custom Query for Media Companies and Studios now look for an exact match. This helps find things like "Buena Vista Home Entertai" without finding every other company that contains that string.
  • Fixed bug in Duplicate Title searches that was removing duplicates that shouldn't have been.
  • Updated Profile ID queries to recognize variant profile Ids.
  • Pretty much all Cast and Crew queries now display head shot information, if it has been loaded.
  • Pretty much all Cast and Crew queries now have Name and Birth Year in separate columns for easier sorting.
  • The Received as Gift query now returns who gave it as well.
  • The Watched and Loaned queries work now regardless of if your names are ordered First Last or Last, First.
  • The list of users for the Watched and Loaned queries is now sorted properly regardless of name ordering.
  • The list of users for the Watched and Loaned queries now reloads if the ordering of names change.
  • Percent watched now counts actual watched events instead of just events.
  • The Loaned Movies query now lists all the users it has been loaned to and the total number of days it's been loaned out.

Version 2.8 and 2.8.1

Beta releases never publically available.

Version 2.7

New Features

  • Reading the list of accepted birth years now pulls in people with year of death listed.
  • You now have the option to either Overwrite the current list of Birth Year data with the list from the website or Merge the current data with the list from the website.
  • "Ignore Accepted Birth Years" is now renamed to "Include Cast / Crew with accepted birth years". This should cut down on some confusion people were having.

Version 2.6

Bug Fixes

  • Country Of Origin now lists South Korea instead of Korea and adds Iran, Romania and Russia.

Version 2.5

New Features

  • Can now filter out Cast / Crew that have accepted birth years from the List of Accepted Birth Years with Documentation thread at Invelos.

    To edit this list, bring up the Options window. There is a new tab all the way to the right called Accepted Birth Years. This list can be edited manually, or you can right-click and choose Reset Default Data to reset the the list shipped with the plug-in.

    The recommended method to update this data is to right-click and choose Reload Data from Invelos. This will read in the thread listed above and pull in all the data from page 1 and enter it for you.

    Queries dealing with Cast / Crew birthyears now have a new option available to Ignore Accepted Birth Years. This will allow you to use or ignore the list of Accepted Birth Years.

    Special thanks to TheMadMartian for maintaining this list and making this new feature possible.

Version 2.4

Bug Fixes

  • Fixes problems with people using custom genres.

Version 2.3

Bug Fixes

  • Fixes problems with people using custom genres.

Fixed / Updated Queries

  • The new queries to compare currency types will now ignore profiles on the Wishlist.

Version 2.2

New Features

  • New displayable column: Tags

New Queries

  • Added Mismatched Currencies to SRP Currencies and Purchase Prices Currencies to find profiles where the currency types are different.

Bug Fixes

  • Fixed an incompatibility with other plugins.
  • Fixed the version number which was showing up wrong.

Version 2.1

Bug Fixes

  • Fixed an issue reading genres 4 & 5.

Version 2.0

New Fields to Query On

  • Rating System
  • Rating Details
  • Media Companies
  • Collection Type
  • Locks
  • Count As
  • Audio Track Channels
  • Exclusions

New Features

  • New displayable columns: Edition, Last Watched Date, All Watched Dates, Last Watched By, All Watched By, Locks
  • Changed dropdown list for Studios and Media Companies. Can pick from drop down list or hand enter something.
  • Can now list total running time on the Summary page by all/unwatched/watched.
  • The plugin should now automatically reload data in many cases (refreshing profiles, loading new database, restoring from backup, etc).
  • The Summary page now lists a count of orphaned profiles (in red if any are found). Go to "Other -> Collection Type -> Profiles missing collection type" to find these. To fix them, double click on a title in the results, then Save when the editing screen appears. That will place them in your Owned collection and they can be dealt with there.
  • Added a Super Search (on the Other tab) to search multiple fields at one time.
  • Custom genres, media types and collection types are now supported.
  • Added BD-Live, Picture-in-picture, Bonus Trailers & Digital Copy to Features.
  • Added Blu-ray Combos
  • Renamed audio track languages to audio track content to match program.

Bug Fixes

  • The problem where the plugin wouldn't load for some people after the 3.5 upgrade is now fixed.
  • Ratings are now working again after the 3.5 upgrade and should also list the correct rating based on locality.
  • Currency columns should now sort correctly.
  • Running times should now sort correctly.
  • HD DVD & Blu-ray discs are now counted as N/A rather than NTSC.

New Queries

  • Query to count discs by disc size.
  • Query for child profiles that don't have a parent profile in the database.

Fixed / Updated Queries

  • Added Last Watched and Last Watched By to Other -> Watched -> Watched.
  • Added queries to compare disc count vs. count as to the Disc Count and Count As field queries.
  • Fixed: Crash on Find all profiles where: Aspect Ratio is > 1.85 or < 2.40
  • Fixed: Location & slot. Couldn't do a Regex search for ^$
  • Fixed: Crash when selecting General Info => Aspect Ratio => <custom> / Not equal to => 2.55.
  • Fixed: Duplicate collection numbers show up as gaps in the collection numbers query.
  • Fixed: Issues where Find Duplicate Titles was giving bad results.
  • Fixed: Crew now displays dividers on a name search.

Version 1.5

Bug Fixes

  • Doing a better job now of cleaning up old data when you Reload All Data.

New Queries

  • Added a query to find all profiles with uncredited actors to Cast -> Name. Please note that this will only find actors that have the uncredited checkbox checked. It won't find those that have "(uncredited)" listed in their role. To find those, go to Cast -> Role and run the Bad Roles query. Or use the custom query to search for any roles containing "(uncredited)".
  • Added a query to find all profiles with voice actors to Cast -> Name. Please note that this will only find actors that have the voice checkbox checked. It won't find those that have "(voice)" listed in their role. To find those, go to Cast -> Role and run the Bad Roles query. Or use the custom query to search for any roles containing "(voice)".

Version 1.4

New Features

  • SRP, Purchase Price and % Saved are now listable columns. Simply right-click on the results, go to View Columns and choose whichever you prefer.

Bug Fixes

  • Added a missing tooltip on the Options screen.

Fixed / Updated Queries

  • When you list profiles by purchase place, you can now optionally see the total spent at that location.

Version 1.3

New Features

  • There's a new option on the Options window to display names as "First Middle Last" or as "Last, First Middle".
  • Gave the Options window a small overhaul to groups things together better.

Bug Fixes

  • Fixed a small bug with font sizing that would probably never have been notied on the Summary tab.

Fixed / Updated Queries

  • Country of Origin now recognizes Philippines, Ireland and Estonia.
  • The Credited As queries weren't displaying the Credited As value in the results.

Version 1.2

New Features

  • Added the ability to list Profile ID (UPC, Disc ID or manual profile #) as one of the displayed columns. When results are displayed, right-click, choose View Columns and choose Profile ID.
  • Profile ID also now displays on the popup window with all the other disc information.
  • There's a new option on the Options screen to allow you to display Original Title for the titles on the Summary tab.
  • There's a new filter for collection numbers. When checked, you'll only get profiles with collection numbers. When unchecked, you'll only get profiles without collection numbers. When left indetermine (the blue box), you'll get both.

Bug Fixes

  • Tweaked how right-clicks are handled. It's extremely minor and I doubt anyone will notice a difference.

New Queries

  • Added a new query under Box Sets to find box sets where the running time doesn't equal the combined running time of the child profiles (per the rules). Note that if the box sets has bonus disc profiles with running times, you'll get false positives. The box set should have the combined running time of the main child profiles only, not including any bonus discs.
  • Added a new query under Box Sets to find box sets where the production year isn't the production year of the earliest child profile (per the rules).
  • Added a new query under Sort Title to find blank sort titles.

Fixed / Updated Queries

  • The watched and loaned queries were always including items from the Ordered and Wishlist tabs. If you use these tabs as intended, you obviously can't have watched or loaned something you don't physically possess. If you don't use these tabs as intended, you can change the behavior on the Options screen by checking "Treat Ordered / Wishlist profiles as owned".
  • Added an option to the Find Duplicate Titles query for Title and Original Title to ignore the edition if you have it being displayed. With this checked, the plug-in will see "Brazil: Widescreen" and "Brazil: The Criterion Collection" as having the same title.
  • Added two new options to the Top X query for Cast. You can now ignore cast members with Voice and/or Uncredited checked. I wanted to see my top 10 actors and was tired of seeing voice actors showing up.

Version 1.1

New Features

  • Added total Run Time to the Summary tab.
  • You can now copy data from the results to the clipboard. This only works on the datagrids, not the Summary tab. Select the rows you want, or right-click and choose "Select All Rows". Then right-click and choose "Copy" or push the Copy button on the toolbar.
  • You may now change your currency type displayed on the Summary tab.

Bug Fixes

  • Titles with an ampersand weren't displaying correctly on the Summary tab.
  • The filter for Boxsets has been completely re-written. It's a lot more complex now, but it should work more accurately. You should reset filters on that page to clear out the old values.
  • Changed the Collection Type filter. All is gone and the radio buttons are now checkboxes so you can do things like Owned and Ordered, but not Wishlist.
  • Fixed a bunch of queries that would crash and burn if ran when all profiles were excluded by the filters.
  • Added more error checking on the cover scan queries and better error trapping in the plugin itself.
  • Fixed a bug while reading events (watched, loaned) that could give inaccurate results.
  • The Purchase Price numbers on the summary tab now exclude Wishlist items (unless specifically turned in the Options screen).

New Queries

  • Added a new query under Box Sets Contents to show what level (child, grandchild, etc.) profiles are.
  • Added a new query under Discs to break down your profiles by disc count.
  • Added a new query under SRP and Purchase Price to find child profiles that have SRP or Purchase Price information.

Fixed / Updated Queries

  • The "Missing Purchase Price" no longer includes Wishlist items (unless that option is specifically turned on in the Options).

Version 1.0

Original Release