v3.0.7 o BUGFIX: Temp files from images destined to go in to the database are now cleaned up. o BUGFIX: If the images are stored in the database, the generated thumbnails are now stored in the database. o BUGFIX: With the move of the install directory out of the lib directory, the location of the final_steps.txt file is properly referenced. o BUGFIX: Removed the dependency on defaults.sql as this file is no longer needed. o Added submitted utilities by Bob Apthorpe. o Application now checks for the existance of the config file prior to proceeding further in to the application. o BUGFIX: Fixed an extra apostrophe in the help.sql file. o BUGFIX: Fixed the installer to properly initialize the default values. o BUGFIX: IMDB lookups work again. o BUGFIX: Download of cover image works again. v3.0.6 o Implemented a separate variable for the default search and the default master database. o Moved some image content to the template's CSS file for easier customization. o Moving to CSS for the banner fixed the alignment differences for the menu items between browsers. o Updated Amazon URL parameters in both the amazon module and the install script to fix the Amazon Update functionality. o BUGFIX: Images which were moved to the themes directory needed to be referenced via the new location. o Migrated the login form to be primarily css based. o BUGFIX: Fixed the transparancy on a couple of the GIFs. o CSS cleanup to the banner. o Minor image cleanup for themes. o Created a theme based upon the WordPress installer template. o BUGFIX: Updated the installer application to only connect to the mysql database if we have to. o Minor HTML code cleanup to the header. o Rebuilt the installer to simplify the installation process. o Moved all installer defaults to an sql file. o BUGFIX: xml and pdf output work again. o BUGFIX: assigning a user as an admin to a collection works again. o Tweaked the upgrade script to perform all of the manual functions. o Updated the UPGRADE documentation accordingly. o Pulled all of the install and upgrade files out from the main distribution. v3.0.5 o Migrated to a CSS and standard html based template scheme. Simple substituition is made prior to the display. o All pages are now XHTML 1.0 Transitional compliant. o Migrated all dynamically generated javascript to a separate link call. o BUGFIX: Renaming a collection now works again. o Added some support for having the apostrophe in the name of a collection. o Updated ROADMAP and LIMITATIONS documentation. o Updated the footer to contain a customized copyright notice, dependent upon what options have been enabled within the application. o Automatic updates of the Region1 table are now supported under Windows. o Updated the help documentation accordingly. v3.0.4 o BUGFIX: The Loan table no longer gets deleted when the configuration page is re-saved. o Added the ability to rename a collection. o BUGFIX: User request queues can be displayed again. o BUGFIX: Updating via the web interface would break if a space existed within a column name. o BUGFIX: Some client installations cannot handle performing multiple queries at the same time. This was only the case when performing a region1 update. o Added the ability to adjust PHP's max_execution_time variable to handle situations where uploads run longer than 5 minutes. o BUGFIX: Updated the sql statement for fast database loads to specify that the file to be uploaded is local to the web server. o Extended the unzip functionality to handle keywords in order to support other unzip utilities, especially on the Windows platform. o Added the ability to display web-search information within a new window. o Minor error and debug display fixes. o When attempting to add a DVD that already exists in the collection, the appropriate notification is displayed. v3.0.3 o BUGFIX: The install and upgrade scripts now add the proper loan variable to the systempref table. o BUGFIX: Custom entries can now be loaned and returned. o BUGFIX: Secondary collections can be created and hosted again. o BUGFIX: The help link to the help image now points to the current theme. o BUGFIX: The images within the on-line help documentation now point to the images within the current theme. o Removed auto-redirect from the install script to allow for displaying some final recommended steps, notes, and tips. o BUGFIX: Fixed typo in help.sql which prevented the last on-line help entry from being added. o Added a check to make sure that the user always has a theme set. v3.0.2 o Updated the optimizer to process wishlists and the request queue tables. o Updated the configuration update routine to always update all fields rather than selected ones. This eliminates garbage from creeping in to the systempref table and keeps the contents consistent as new items get added. o Added the ability to track and handle loaning out DVDs to users. o Updated PDF generation to handle loan output. o Newly created users now get the default preferences as defined by the admin. o The search field now defaults to the default sort column. o Improved the javascript handling of spaces in collection names on the search form. o Updated the help documentation. o Fixes to the installer and the upgrader to reflect the new functionality. o BUGFIX: The IMDB Title URL now gets set properly upon installation. o When displaying loaned items, the summary title displays the total results and, if applicable, the borrowing user. o BUGFIX: Moved the get_dvd_upc function out of the Amazon module since it is now used in other parts of the app. o Added action images for loaning and returning entries. v3.0.1 o Minor javascript change to cycle the display to show the totals of all of the collections in the top left corner of the page. o Added additional session variables for netflix. o Changed the variables for Amazon, IMDB, and Netflix for simplicity and easier control by implementing variables within the URLs for ease of substitution. o Added the ability to control what wishlist elements will link to. o Minor fix to the install and upgrade procedure when checking access to the configuration file. o BUGFIX: The installer did not properly connect to the database at the completion of an install and, hence, did not properly set up the database. o Tweaked the database export/backup function to exclude the Region1 table and to allow it to run for up to 5 minutes before timing out. v3.0.0 o Added Amazon image URL settings to compensate for the frequent changes that Amazon seems to make to their pages. o Changed the summary results to indicate the total number of pages, and the current page number being displayed rather than listing the raw number of results. o BUGFIX: When using IMDB as the default search tool for summary listings, the IMDB link is now generated correctly. o A valid user log in with the correct permissions is now required in order to perform an upgrade. o Code clean up: Eliminated the need for the "start" and "summary" variables. o Reworked the results display to show the results in "pages" rather than a range of results. o Added the ability to jump to a paticular page of results. o Cleaned up the Amazon module and fixed it to work with the recent Amazon site and search tool changes. o BUGFIX: When a corresponding Amazon entry is not found, we now abort all attempts at gathering Amazon information for that record. o Added and updated DVD update notices for Amazon and IMDB updates. o Added text summarizing the action used to generate the current listing results. o Fixed the date display when viewing a DVD entry. Also updated the results listings to display dates only with the year, month, and day. o BUGFIX: After updating a DVD, the viewer is now returned to the DVD edit page. o Began the implementation for the support of themes. o Updated the on-line help documentation. o Minor fix to not display the "Created" and "Updated" information when that information is not available. o BUGFIX: The "Generate Thumbnail" can now be turned on or off. o BUGFIX: The installer now properly creates the "Generate Thumbnail" systempref option in the table. o Implemented the "Finalize Install" feature which automatically downloads and installs the Region1 table and tweaks the configuration options to allow for immedate use of the application. o Numerous changes to the installer to handle the new options. o Updated the screen scraping code to handle cookies. o Fixed and cleanup to the automatic PDF generation. o Updated the screen-scraping code to handle cookies. o Updated fpdf class library to 1.53. o File cleanup and created the modules directory. o Made all calls to the net search routines for IMDB to be completely generic. o Implemented a Netflix module using the generic calls. o Added action buttons to the dvd display. o Added a "go back" link to all of the dvd display/update pages. o Reworked the core screen scraping code to simplify it and make it work again. o Added the use of rawurlencode for the title links in the listing output. o Created a simple index.php redirector o Incorporated a number of HTML releated fixes to make the application much more HTML compliant. o If it exists in the wishlist, adding the same item to the current collection will always be removed from the wishlist. o Updated documentation. o Added GPL text to the web installer. v2.9.11 o BUGFIX: Displaying all entries based upon a specific starting letter now works when going beyond the first page of results. o Changed the way IMDB genres are set. Multiple genres are now set as a comma delimited list. o BUGFIX: User request queues no longer display all user requests. o BUGFIX: Fixed the display of the changelog dates. o BUGFIX: User request queues can now be updated by the administrator. v2.9.10 o BUGFIX: Creation Log entries are now retained after an update is performed. o BUGFIX: Last Update Log entries are now saved. o BUGFIX: Creation of new collections now creates the Change and Creation Log columns. o BUGFIX: The installer now properly creates the Change and Creation Log columns. o BUGFIX: The Creation Date Log column no longer gets displayed in the customize menu. o BUGFIX: All columns display their proper values again. v2.9.9 o Added in the feature of saving and retrieving the date and time of the last update to a dvd record, including the date it was added to the collection. o Increased the max_execution_time when performing a full database update against Amazon. o BUGFIX: Display of customized fields works again. o BUGFIX: Fixed the search link for IMDB in the listings. o Added in debugging around the Amazon lookup code to prevent attempts to download images and parse page data that do not exist. o Added in the management function to check to see if a newer version of myDVDs is available. o Added in new code to utilize the MySQL built-in functionality of LOAD DATA INFILE, and updated the configuration page to display its use as an option. o BUGFIX: dynamic calculation of the myDVDs temporary directory was fixed to properly deal with Windows-style backslash characters. o BUGFIX: corrected the arguments to ImageJpeg in order to properly preserve the image quality when generating thumbnails. o The automatic thumbnail generation can now be toggled, forcing the browser to perform the image resize on the fly. o Updated the help files. o Incorporated the database backup feature in to the full application. v2.9.8 o Added the ability to choose the behavior of how PDF files get sent to the client browser. IE and the Acrobat plugin tend to have problems in some rare instances with handling inline PDF files. o Updated the printer graphic. o PDF generation modifications to put the header on each page. o Code cleanup to the listing generation functionality. o Code cleanup to the XML and PDF generation. o Added the functionality of updating the collection data for a particular DVD to match that of the Region 1 data. o Minor tweak to the image download o BUGFIX: Users can be added again. o BUGFIX: Cookies are now working again. o Replaced the "Get Region 1" Admin menu option with a "Management" menu providing more options than just Region 1 related. o Added support to allow for collection names containing spaces. v2.9.7 o BUGFIX: We now only update fields from Amazon or IMDB if we have values to put in there. o Moved all mapping menu options under a single Admin menu option. o Updated the mapping page to handle multiple forms, one for each type of column mapping. o BUGFIX: The summary display preferences are now properly parsed on a per- collection basis to display only the fields desired. o Renamed the display_prefs column to "print_prefs" to be used to determine which columns get displayed when showing PDF results. o Renamed the summary_prefs column to "display_prefs" and updated the code to utilize that column name. o Updated the preference page to allow for the defining of columns to be displayed when generating a PDF of listing results. o Updated the search routine to properly select the preferences if a PDF is selected to be generated. o Minor formatting fixes to the results listings. o Formatting and image adjustments to make the login table and the banner table to display properly. o The Default Prefs page displays the default user preferences again. o Minor code cleanup to the listing results. o Minor cleanup to the menubar. o Code cleanup for the request queue display. o Re-worked the request queue listing code. o BUGFIX: The upgrade script and install script now add all of the necessary entries to the systempref table. o BUGFIX: Performing an Amazon Update on an individual DVD now auto-updates the selected mapped fields. o The size of the thumbnail that gets generated can now be selected in three different hardcoded sizes. o The upgrade script will make the necessary changes to the conf.php file. v2.9.6 o Added support for linking to Amazon or IMDB in the results listing based upon stored values and a new configuration option. o BUGFIX: Bulk uploads now work again. o Broke apart the default search link and the IMDB search link. o Minor reorganization of the configuration page. o BUGFIX: The installer now adds the Amazon_URL field to the systempref table. o BUGFIX: The "Customize Your Collection" form now displays the differences if only one custom field has been added. o Changed the cookie code to set the cookie specific to the host rather than to the domain. o Updated the "Requests" menu to be a pull down rather than another page. o Added in the ability to disable the use of cookies upon login. o Added rudimentary server detection to set the cookie appropriately for https and http server installations. o Added a random string generator to generate the default encryption key for the installer. o Minor fix to the search results when a search is performed against another collection or the Region 1 to display the edit button properly for items in the current collection o Created the Admin menus for mapping Amazon and IMDB columns to columns within the collection. o Added the ability to auto-update DVD information upon adding to a collection with the information found via an Amazon lookup. o Amazon or IMDB updates per DVD also update the DVD information within the collection based upon the user defined mapping. v2.9.5 o Minor code cleanup to elimate some PHP Notices. o Updated the Configuration menu to include Amazon support. o Added Amazon support for grabbing the cover image when an item is added to the collection. o The DVD Title is now displayed as part of the output when it has been successfully added to the collection. o Fixed the focus on the login form. o Added a table to store the amazon related data for new DVD entries. o Added the necessary routines to store the data from Amazon. o Reworked the administrative configuration page. o Added a language column to the help table. o Front cover images are now fixed to 100x133 when displaying the dvd information page. o Enabled encryption of database values in the configuration file. o Extended the encryption to all user passwords. o Added an "Amazon Update" button to individually grab DVD information from Amazon, when enabled. o Added Amazon entries to the systemprefs table. o Added Amazon options to the configuration menu. o When enabled, cover art and related information is grabbed from Amazon when a dvd is added to a collection. o Minor fix to one of the banner background images. o Minor fix to the wishlists add routine to handle obscure characters. o The upgrade tool, by default, now backs up the database before upgrading. o Merged the code together from the preferences and default preferences form. o Minor formatting fix to the admin pages. v2.9.4 o BUGFIX: Updating a DVD in a collection now brings the user back to the listing page successfully. o BUGFIX: The upgrade script now adds the new database entries correctly. o BUGFIX: DVD Updates now work again. o Added an override to the max_execution_time PHP variable when importing the Region1 database. o BUGFIX: When thumbnails are enabled but a thumbnail has not been generated, they now get properly generated when displaying summary results. o BUGFIX: Thumbnails are now properly removed when a front cover is removed. o Forced the display of the full results when performing an IMDB search. o Minor alteration to the structure of the IMDB table. o With IMDB enabled, front cover images are automatically downloaded from IMDB when setting an IMDB ID. o The plot, cast, title, director, rating, runtime, and genres now get set in the IMDB table when setting an IMDB ID. o If IMDB is enabled, the plot outline is displayed when viewing an individual dvd. o The IMDB plot outline will be used if no plot summary exists. v2.9.3 o All uploaded cover images are now converted in to JPEG by default. o Added in the ability to display thumbnails of the cover images in the summary display. Thumbnails are generated automatically. o Re-worked the cover image locations when they are stored as files. o Implemented support for storing and viewing additional images. o Added additional fields to the images table to handle thumbnails, front and back case cover images, full cover images, label images, and inserts when the images are stored in the database. o Re-worked the Add menu to create it as a pull-down for Add, Add Custom, bulk adds, and adding to wishlist. o Split apart the UPC add and the custom add to different pages. o Implemented a bulk-add feature for UPC's. o Updated the add_dvd code to grab the information from the proper table. o An add will not take place unless valid data has been found. This will eliminate ID 0 entries from creeping in to the database. o Moved the "custom wishlist" add to the new Add menu. o Additional lanugage localization. o Fixed the upgrade.php application to properly recognize the current running version of myDVDs. o Added in the feature of displaying an estimated "value" of a collection based upon a fixed "price" field within the collection table. o IMDB query fix. o Added the ability to load the new Region 1 CSV file from a local file within the installation tree for those installations that do not have access to any form of unzip. o BUGFIX: We now supress the displaying of the ID field in the admin form for the "Column to sort on" selection. v2.9.2 o Code cleanup to Region 1 updates o Added ability to override the downloading of the incremental update to the Region 1 database. o Updated the UPGRADE document. o BUGFIX: Fixed the installer to actually allow the userpref table to be properly initialized. o BUGFIX: The logout button now appears when the user is logged in. o BUGFIX: Removed the common conditions which would cause mysql warning messages to appear. o The "Get Region 1" option now only shows up when "Region 1" is enabled in the configuration menu. o BUGFIX: The User Management form now displays properly. o BUGFIX: The Admin menu now only displays what the user has access to. o BUGFIX: The customize page can now handle collection names that contain spaces in them. o BUGFIX: Another fix to the unique ID detection and generation. o Suppressed the SQL warning messages when initializing the system with the first download of the Region 1 database. o BUGFIX: Properly suppressed the display of the ID field on the Alter form in non-Region1 installations. o More language localization changes. o BUGFIX: New User accounts get their display preferences correctly set up. o Updated install.php to handle situations where the installer does not have the ability to create a new database or create a new database user. o BUGFIX: We no longer display the alpha navbar where there is only one page of results to be displayed. v2.9.1 o BUGFIX: Alpha Navbar now works when the number of DVD's displayed is more than what exists within the listing. o Trimmed down the unused files from the FPDF library. o Moved all of the admin options to the drop-down layers menu and eliminated the administrative pane. o A fair amount of code clean up. o Implemented the foundation for language localization. o BUGFIX: Unique ID's now work again. o Re-worked the conf.php file format and updated the installer accordingly. o Modularized all of the code to control when things get displayed. Everything now gets built and loaded into a variable which gets echo'ed at the end of the script's execution. o Added a link header to include the RSS to the page (if one exists). o Moved all of the static CSS and JS information to meta links to increase page draw performance for browsers that take advantage of http pipelining. o Added a favorite icon to be displayed in the URL field on browsers that support it and added in the necessary code. o The language used with myDVDs can now be set on a per-user basis. o Increased the size of the banner images to properly display using the default fonts on most browsers. Cleaned up the images as well. o Relocated the Logout button to be in the same location as the Login button for consistency sake. o BUGFIX: IMDB searches now work again. o Suppressed the warning when no results are returned. o The top menu now gets generated properly when the system preferences are updated. o Clicking on the myDVDs logo brings you back to the main myDVDs page for the installation rather than back to the myDVDs home page. o Log in now brings you back to the search page by default. o Changed the way the CHANGELOG is displayed through the application. o BUGFIX: rss/xml feeds now work with Mozilla Firefox's Live Bookmarks. o Updated the UPC_IMPORT.php utility according to the new conf.php changes. o BUGFIX: adds via UPC scan work again. o BUGFIX: Searches which included characters that needed to be escaped no longer cause a mysql error. o Updated the upgrade.php script to make it a little smarter. v2.9 o Updated the upgrade.php script to know what to do for the different versions of the 2.8.x release tree. o Updated the INSTALL document to include better documentation for getting the system up and running with the Region1 table. o BUGFIX: Minor tweaks to the wishlist query/delete routines to get wishlists working again. o Added setup error checking to the install.php script. o Implemented a language template system for easy porting to other languages. This is only within the installer and upgrade scripts, but it will be expanded out to the rest of the web-app. o BUGFIX: The updater didn't create the other wishlist tables. o Cleaned up the code to handle CSV exports for collections. o Cleaned up some code in the adminstrative forms. o Minor fix to the layers stylesheet to left-justify the elements. o New edit.gif image. o Fixed rotating banner to not directly reference the table 'collection' but to use the SESSION variable instead. o BUGFIX: The unique ID determination was not being handled properly resulting in multiple entires with the same unique ID. o Reworked the "get_dvd" function. All users can now view the details of dvds in all collections. o Changed the "Remove Image" text formatting. o Removing or Uploading an image returns you back to the screen you were on. o Re-worked the wishlist system. It now contains a copy of the record if the entry has been added from another list. o Custom entries can now be added to the Wishlist. o Updated the help documentation. o Updated the WISHLIST document. o BUGFIX: After adding an item to the wishlist from the search results, the resulting page no longer contains another search box at the bottom. o Updated the upgrade program to handle upgrades from previous 2.8.x versions. o Moved the images, when stored in the database, in to a table of their own. o Removing an item from the wishlist returns you back to the updated wishlist. o Viewing a wishlist can now be sorted. v2.8.5 o Added support for multiple wishlists. One wishlist per collection. o Updated the upgrade procedure to preserve the previous wishlist table. o Fixed the fonts in the pull-down menus to match the rest of the elements. o Re-worked the wishlist display code to allow for proper navigation. o Deletions from the wishlists now bring the user back to the wishlist. o Added rudimentary support for the ability to export the collections in CSV format. v2.8.4 o BUGFIX: CSS change to help with the drop down menu navigation under IE. o Tweaks to the layers CSS to make the pull down flow with the page. o Incorporated the "alpha navbar" code submission with some heavy changes and enhancements to make it work. o Additional minor GUI enhancements. v2.8.3 o BUGFIX: The focus is now set properly on the "add" form. o BUGFIX: RSS feeds now work when an ampersand (&) shows up in a title. o Created a background image for all submission buttons. o Implemented a pull-down menu layer system for the "List" button to allow for the displaying of any of the lists on the system not just the default list. o Minor fixes to the code for the search page. o Updated the FAQ and TODO. v2.8.2 o BUGFIX: Sessions are now completely destroyed upon logout in order to prevent situations where outdated information is hanging around in session. o IMDB Search now has the option for manually entering the IMDB ID. o IMDB Search form selects, by default, the match which is currently saved. o Integrated the fpdf class to allow for PDF-style printing of results and lists. o Created ability to have XML-style output from results and lists. o BUGFIX: Users can now add/delete from their request queue from any of the search results, listings, or direct from the queue listing. o BUGFIX: The Region1 database does not get added in to the collections table each and every time the system settings are updated. o BUGFIX: Users can now page through all of their requests. o BUGFIX: Admins can now delete from a user's request queue. o Minor coding changes to the summary display. o Updated the UPGRADE, INSTALL, TODO, WISHLIST, and ROADMAP documentation. v2.8.1 o BUGFIX: focus is now set on the search form any time it is displayed. o BUGFIX: javascript for updating the search form has been fixed. o BUGFIX: New user accounts now have their display settings defined by default. o BUGFIX: User request queues now work again. o Some major code cleanups. o Login failures now return you to the Login screen. o Fixed a couple of situations where the user was left stranded. o Worked on the button logic again to make it work as expected for different level users. v2.8 o Cleaned up the "Advanced Search" Functionality. o Fixed the "Previous" button's functionality within the installer. o Added a wishlist icon. o Added the functionality to allow the admin to remove items from any user's request queue. o Moved the IMDB stuff to a table all of its own since it is installation specific and not collection specific. o Ending php tags are ?> NOT php?> o Reworked the logic surrounding the action buttons on the summary form. This adds mini tables for the buttons themselves, making life easier, but making the page draws slower. o Added the ability to toggle the Request option. o Completed the enable/disable functions for IMDB. o Wishlist, IMDB, and Region1 are now defaulted to OFF during install. o Included some minor sanity checking with regards to dealing with the Region1 table download and the potential chaos caused by failures. o Added the PHP code to download the Region1 table and removed all references to any external apps. o Better use of $_REQUEST in situations where values can be set via $_POST or $_GET. o Minor bugfixes to the installation process. o Cleaned up the IMDB ID mapping process. o BUGFIX: Narrowed down and eliminated a problem with DVD additions and other key features which was due to a global variable dependency. o The relative URI is now calculated automatically based upon the SERVER variable REQUEST_URI contents. o Added toggle to enable/disable wishlist feature. o Added beginnings of the wishlist functionality. o Added in the ability to store the images either within the database or on the filesystem. o Cleaned up the installation procedure. o Tweaked the upgrade script. o Updated and added to the help documentation. o Modified the way DEBUG works. o Fixed some of the noisy warnings generated during the install process. o Added some rudimentary IMDB mapping features. o Added master toggles for enable/disable Region1 and IMDB. o BUGFIX: DVD Information updates now work again. o BUGFIX: The user level was not always being set properly in register_globals=off environments. Moved from the global variable to the session namespace. o The user display preferences have now been reversed to make more sense. It is now based upon what you wish to view rather than what you wish not to view. o Changed the IMDB variable to "Web_Search" and updated help docs as well as the input fields. o The DVD Title links no longer include things in parenthesis. o Updated the administrative configuration page to allow for altering the cookie name and life. o Added corresponding help information to the administrative page. o Added the ability to see the CHANGELOG via the web interface. o Removed all code and references to the built-in download/unzip option since PHP no longer supports any of the ZIP functions. o Searches using quotations and apostrophies now work consistently. o Major cleanup of the install script, added summary review before starting the setup procedure as well as added some friendly images. o Cleaned up the "Add" page. o Updated listing display to handle automatically returning to the display after performing an "Add" or a "Remove". o Finished the cleanup with the Region1 dependency removal. This includes fixing the extend_table function and the removal of old code. o Moved the filenames of the Region 1 CSV files for the full and updated lists into the systempref table. o Fixed the search function when performing searches that yield a large number of results. o Fixed the sort ordering of the columns for listing results. o Added checking to omit the javascript functions when performing an install. o Moved all relative GLOBALS variables into the _SESSION superglobal. o Changed all short php tags to full tags for greater compatibility. o Minor fix to the form for barcode entry. o Changed the actions images to make them a little easier to interpert. o Fixed the ability to upload images. o Fixed the javascript code around the displaying of the collection information in the top banner. o Incorporated the set_focus javascript in to the search and add pages. o Re-wrote the function to handle the displaying of the dvd 'card' (all of the stats about a particular DVD). o BUGFIX: Uploads of images now work again. o Continued code cleanup on myDVDs.php to utilize the $_REQUEST variable. v2.7 o Fixed Next/Previous within the administrative view of the RequestQueue. o Updates to TODO, INSTALL, WISHLIST, and UPGRADE documents. o First rudimentary attempt at setting a default column to sort all results against. o Searching, listing, and sorting are no longer dependent upon the Region 1 table. Unique entries are now only added to the individual collection. This speeds up all SQL queries. o Reworked the way underscores are handled. Basically, if an underscore exists in a column name, it is replaced with a space. This was done to make things look pretty. o Reworked the entire installation procedure. o Updated the "update.php" script. o Removed numerous dependencies upon the Region1 table being in place. This is not yet complete, but the dependency upon the Region1 database being in place is no longer a requirement. o Unique/Custom entries now get an ID > 20,000,000. o The ID field is now an INT rather than a TEXT field in order to support faster sorting, listing, and searching. o Re-built the systempref table to make it easier to modify and extend over time as well as making is more logical overall. o Reworked the header and footer code. o Fix to the image upload to utilize _POST rather than GLOBALS for greater compatibility with installations. o Walked through the entire web app and insured that it worked with register_globals set to "off"! o Fixed all of the forms to properly address the use of GLOBALS. o Fixed the myDVDs.php script to remove a rogue global dependency. o Fixed the startup.php script remove a lingering register_globals dependency. o The ID field from the Region1 table will ALWAYS be an INT. This will improve performance signifigantly. o Added a little intelligence in the search string parsing to handle quoted values, AND, and OR. o Added the javascript code to handle the pop-up help dialog. o Reworked the header and footer files to play more nicely. o Added help information. o Created the help table and populated it. o Added a "Close Window" button icon. o Removed specific dependencies on the Region1 database o Updated the options page to include the ability to define the default master database. v2.6 o Fixed a bug in the search process which prevented going past the first page of results (introduced in 2.5) o The search form now displays at the top of all results pages making it easier to perform searches. o Moved the version number in to the systempref table. o Fixed the upgrade.php script to actually connect to the database. o Fixed the upgrade.php script to update all old root ACLs to the new schema. o DVD Updates now happen without errors and the system now remembers what you were doing prior to the DVD Update. o Fixed the informational message when a DVD was successfully updated. o Minor global variable code cleanup. o SQL error messages display only when DEBUG is on. o Supressed additional SQL error messages which were generated by calling sqlquery (expecting results) as opposed to sqlinsert (not expecting results). o Removed the ability to update DVD information for items not in the collection. o An admin can now only remove or re-adjust permissions for users of equal or lesser access. o The user gets returned to the Search or List after updating the DVD information. o Changed the add form to do a post rather then a get. o Downloaded Region1 CSV files now get saved in the tmp dir within the source tree rather then the system-wide /tmp dir. o Fixed a bug in the SQL code which determined the next available unique ID number for a custom dvd entry. o Adds via the 'Add DVD' page now automatically add the entry and bring the user back to the 'Add DVD' page. o Created a collections table to house the list of collections. This made more sense then the continual exclusions needed when parsing the output of "SHOW TABLES". o Re-worked the display of the 'Show DVD Information' page. v2.5 o More fixes to remove dependencies upon register_globals. o Fixed the cookie detection code. o Modified the login process to set the cookie then refresh the page. o Included a UPC_IMPORT.php utility to import new entries in to the collection table from other programs if you have the UPC list. o Fixed the use of the table variable such that it actually is used as opposed to the user's collection variable setting in the database when showing a full listing. o Finally fixed the startup routine to properly connect to the new database and create the tables within that new database. o Moved the database connection link into the global space to reduce the overall amount of database connections made. We really only need to make one at the start of the session rather then one for every query. v2.4 o Cleaned up the file structure dramatically. This was for organizational purposes only. The project has gotten too large for a simple file structure layout. o Fixed the default permissions for the startup.php script. o Removed all extra (non-used) files from the distribution tree. o Underscores are now automatically removed (for display purposes only) from the field/column names. o Updated the style sheets. Removed old entries and incorporated some new field definitions. o Fixed the "update" option for downloading the master region 1 dvd list. o Searches with no results now display the search form rather then putting the user at a dead end. o Users now have the ability to change their passwords. o Fixed the sorting ability of the user's request queue in the user's view. o More code cleanup. o Added an "Admin Options" menu and reworked the "Admin" page. o Update the create user form to include the associated collection. o Created a "Collections" interface to allow for the creation of additional collection tables. o Tweaked some of the HTML in the header. o Modified the levels for the list admin and the program admin in order to accomodate the ability of handling multiple collections. o Sorting now works on all of the summary listings, including request queues. o Cleaned up the log in form to match the theme of the rest of the pages. o Added an "Advanced Search" capability which takes advantage of some of the more unique field entries in order to narrow down the searching. o Some minor attempts at making all of the page submissions bring the user back to the page they were originally on. o The ability to alter user's access permissions and associated collection table has been added. o Moved the IMDB setting in to the database to allow for admins to point it off to the site of their choice rather then forcing IMDB on everyone. o Fixed the sorting of the search output when searches were done against the local collection. o Cleanup of the install process. v2.3 o BUGFIX: Image uploads now work again. o Added in images to display the current sorting order. o Added in support for downloading the incremental update versus the full Region1 database update. o BUGFIX: Fixed the form on the admin page to display the "Save System Settings" button again. o Extended the database to handle the support for the incremental updates, including a "last update" field and the definition for the location of the incremental source location. o Cleaned up some of the informational messages. o Updated the command-line Region1 Import script. o Updated the README, INSTALL, TODO, and UPGRADE documentation. o Altered the upgrade.php file accordingly. v2.2 o Included the global_fix.php piece of code to remove the dependency on the "register_globals" php.ini variable. o max_execution_time gets increased to 300 seconds (5 minutes) only when a new Region1 CSV file is being downloaded and installed. o Added usage information for the Region1_IMPORT.php command line tool. o The sorting of the resulting tables from searches and lists can now be toggled (ascending/descending). o BUGFIX: All users are now listed in the admin "Requests" interface. o The interface now auto-detects native and hacked :cuecat: entries within the "add" interface. o Updated the link to the mydvds homepage v2.1 o BUGFIX: updated calls to grab_scan() as reported by Michael Blandford o BUGFIX: search routine utilized old undefined variable which generated a warning when no match was found, as reported by Michael Blanford. o BUGFIX: startup.php had its permissions incorrectly set to 000. o BUGFIX: no error checking was performed when trying to display request queues when there are no users. o Fixed the size of the links to be 8pt rather then x-small to fix the display under IE. o Removed a trailing space in variables.php which was hosing cookies under older versions of PHP4. Cookie problem reported by Bill Atkinson. o Fixed the display of the Queue after an item has been removed from the Queue. v2.0 o Fixed the warning when performing Region1 CSV imports. o Fixed the search field so that simply hitting enter on the keyboard works as opposed to having to move the mouse and hit the search button. o Shifted the entire page into the corners of the screen. Works for IE and NS7. o Re-worked the search results display to have forward/back buttons at the top and bottom of the results display. o Only display the Add/Remove/Update action buttons if the user is logged in. o Only display Add/Logout/Prefs/Admin header options if the user is logged in. o Redesigned the background layout and header. o Added javascript to show and cycle between the Region1 database size and the collection database size. o Reworked the banner graphics. o Only display the Add button when displaying search results if the user is logged in. o Only display the Remove/Update buttons when displaying search results that are in the collection database. o Code cleanup to remove most major dependencies on GLOBALS. o Ability to display the full DVD information of items not in the collection. o Functions to handle display of request queue. o Created the request_queue table. o Users can now keep a "Request list" of DVD's. o Moved some of the files around to clean things up a little. o Administrator can now view the Request lists of registered users. o Various startup modifications and fixes. v1.9 o BUGFIX: Startup sequence is now properly called and initialized. o BUGFIX: Link to IMDB displays properly when UPC field is hidden. o Changed default listing to display in order of DVD Title. o Extended user preferences to include toggle for displaying barcodes as part of the results listing. o Extended the system preferences and the upload process to handle the situation where --zziplib has not been compiled in. This should automate the process entirely if the host system has a download program (wget is good) and an unzip program (unzip works). o Added additional customizable options to the Admin page to make it easier to alter the system behavior after the initial startup procedure has been completed. o System now removes the temporary files it leaves in /tmp. o Rebuilt the startup sequence to walk through the setup procedure. o Pulled the startup code out of the main application and into a file of its own to simplify the startup sequence. o Changed the Prefs page to display a clickable list as opposed to a bunch of checkboxes. o Seperated the default preference settings from the current user settings. o Extended the "systempref" and "userpref" tables accordingly. o Updated the upgrade script as well. o Created UTILITIES document defining the uses of the included utilities. o Updated makedb.sql and the admin_libs.php script to reflect the DB changes. v1.8 o Added the ability to generate the barcode for each DVD. o Changed the color scheme slightly. o Cleaned up the style sheets. o Kludge to fix sorting and searches for custom DVD entries. o Fixed sort of results when changing paged views. o Updated the UPGRADE document. v1.7 o BUGFIX: Customized columns now do not break searches, listing the collection, displaying a single DVD's entry, or updating a single DVD's entry. o BUGFIX: Updating a DVD's entry information does not wipe out an existing DVD image. o Rewrote the routine for displaying an individual DVD's information to optimize the SQL call. o Minor code cleanup. o Fixed typo in SQL statement for updating a DVD entry. v1.6 o Modified SQL queries to provide for sorting ability of searches against the Region1 table and the individual collection. o Updated documentation to include minimum of PHP 4.2.0. o Tweaked the main myDVDs.php script to handle the different output resulting from the way that different version of PHP handle "array_search". o Included a script to do manual imports of the CSV file. o README changes v1.5 o Corrected variable typo in the search field. v1.4 o Fixed the display of custom DVD entries (DVD entries that do not exist in the Region1 database) o Cleaned up and optimized the search routine for the collection table. v1.3 o Minor bugfix to correct the name of the master Region1 DVD database. v1.2 o Major fixes to the selection logic to improve performance. Basic usage of the built-in MySQL "IFNULL" functionality to reduce individualized SELECT calls on the database. o Slight alteration of the listing/search results page layout to compress the icons for the invididual actions. v1.1 o Bugfix to the default display settings for users not logged in. It now actually reads the defaults from the database as it was intended to. v1.0 o You can now simply have the system get and upload the latest Region1 DVD Master list without any additional steps. o Put in a quick check to see if the manually uploaded file is a ZIP file or not. If not, it treats it as a text file. o Added some javascript code to the search form to automatically update the search fields according to what fields exist in the corresponding table. o Commented all of the code. o Some code cleanup. o Reworked the search form slightly. o Changed the "img" column in the 'collection' table to be a BLOB in order to handle the binary data of an image. o Added in the necessary form for inserting/removing an image into/from an existing entry in the personal DVD 'collection' table. o Image uploads now work. o Removed the "initialize" feature from the default display on the Admin page. This can only be enabled if DEBUG is set to 1. o Extended the user features a little more to allow for changing the password and removing the user. o Reworked the administrative page again to make it more usable. o The ability now exists to remove a user from the system. o Reworked the logic on the search routine for searches on the personal collection in order to signifigantly improve performance. o Permanantly removed the ID field from the display listing and hid it from the preferences. o Sorting of the summary display of the Region1 results works. o If no match is found, it now simply states that no matches were found rather than drawing the table with no entries. o Corrected bugs in the initializaton (startup) sequence forcing it to use the "root" database user to create everything first rather than just using it to connect and create the database user, then have the database user create everything from there. MySQL seemed sporadic as to that being successful, while acting as the root user always works for the init process. v0.9 o Custom adds now work. They get assigned their own unique ID number, and the Region1 is still the 'master' in regards to missing information from the 'collection' table. o Custom adds now also display properly based upon the fields within the table. o The "update" display works and updates can only occur on elements within the collection table. o Updates now work completely as they update the information within the collection table. o Added in fuzzy IMDB searches based upon the titles. o Up'ed the required version of zziplib to 0.10.64 because of the format that the Region1 list is now being distributed in. o Cleaned up the screens so as to allow it to process then bring you back to the correct page rather than giving you an empty page. o Created the ability for user display preferences in the search results as well as the collection listing. Users can now turn off columns that they do not want to see. DO NOT HIDE the ID field! o The "img" and "ID" fields are now always hidden from the "Add" form. o Extended the "userpref" table to include the name of the table for the personal collection. This is the main building block for handling multiple collections within the interface. Not sure if anything will come of it, but if requested, it should be rather easy to do. o Added the ability to define the length of time the cookie is active for and the domain of the cookie via the startup sequence. This information is now saved in a "systempref" table. o Added in tooltips for most images in order to properly display under IE. o Searches of tables other than the Region1 table now work proplery. o Debugged the "startup" routine for new installs. o Created a redimentary interface to handle extending the columns in the summary display and in the custom addition display. o Cleaned up the cookie code. v0.8 o Columns in the "collection" table will now be added and dropped according to the columns in the Region1 table. This will make adding DVD's not in the Region1 database to a collection easier to keep in sync. Data for custom DVD entries will get a unique ID and the data will get entered into the collection table. o Removed the form from the header and replaced it with links. It seems the form works properly under Mozilla, but not under Netscape 6.x, 4.x, or IE. o Removed the similar form from the footer of the search/list page for handling the next/previous buttons for the same reason. o Modified the summary listing page and the forms within for the same reason. o Fixed the search form. It was missing some HTML. o Fixed a critical bug when the database was re-initialized and a valid cookie was still in place. o Updated the administrative functions to allow for the 'collection' table to contain the "master" information. This will allow for modifications and extensions to the fields and field contents without altering the master Region1 table. v0.7 o Created the "userpref" table o All database/table modifications now require a login before proceeding. This will prevent accidental modification of the database/table contents. o Added in a bunch of Javascript "Are You Sure" pop-ups. o The system now recognizes startup situations and walks the installer through all of the needed items in order to get the database established. v0.6 o Added next/previous buttons. o Fixed a bug in the summary listing form. o Summary listing now knows which DVDs are in your collection. o Added a link to the Admin page to point to the site of the master Region 1 list. v0.5 o Initial release. o This is BETA code! o This is the first stage in which the application is actually usable AS IS. It is rough around the edges, but the basic functionality is there. o More cleaning to the interface. o Everything that is there, works. No bugs that I am aware of as everything got a once-over. v0.4 o Added the concept of displaying the summaries for 10 DVD's per page in the search area. This will prevent a search from bogging down the browser by allowing the user to use a simple "previous" or "next" button. o Added the same concept to the listing of the personal collection of DVDs. This used the same routine as the search, except that there were originally no limits. Since DVD collections are becoming like CD collections, they tend to get VERY large. It made sense to extend the limits to the listing of the collection to make it easier to browse. o Turned the top bar into a form with graphical buttons. Placeholder images are there currently until something better comes along. o Tweaked the code for the Cue::Cat and the behavior of the application to make scanning in the barcodes of the DVD's work VERY well with the program. o Cleaned up the display of a single DVD's information, including a place-holder image for future use of a per-dvd custom image. v0.3 o Added the requirement for --with-zip to be compiled in to mod_php. o Uploading the CSV text file worked great, but the file, in total, is greater than 2MB. Most web servers have a 2MB upload limit, and it seemed silly to make the requirement for others to up that. Since the DVD Region1 Master List is distributed in ZIP format, it just made sense to take advantage of PHP's ability to read ZIP files. o Created the necessary routines to handle the ZIP upload. o Created a button and routine to completely drop and re-initialize the entire database. This is mainly because of the variety of tests that need to be done, and doing it by hand was getting annoying. o Added style_sheets.php to control how things look on the screen. o Added buttons to the search results to make it easy to add to the collection table. v0.2 o Added the myDVDs graphic to the header. o Got searches working within the Region1 database. o Made things a bit more dynamic since the maintainers of the Region1 database keep adding fields, so the system now gets it list of fields directly from the table itself, and works with those. o Uploads now work. The Region1 table will always be dropped and re-added because new fields are being added by the Region1 database maintainer. Dropping and re-creating is easier than dynamically extending the database. o Modularized the phatcat (Cue::Cat) code to make it work in this scenerio. v0.1 o Initial conceptual design. Mainly proof-of-concept. Little if any of this original code exists in v0.2.