v1.5.8 (March 8^th, 2012)

This new version of the site was posted mainly to synchronise code from development and production. With the use of incremental updates, much of the new functionality for this version was implemented live in the site progressively. Much streamlining of the navigation and tools in the site were included in this version. And, most importantly, tools for any user to submit changes to the data in the site were introduced within Issues. A new set of tools for editors allow for the reviewing of these submitted changes. And, much more across almost all areas of the site, were implemented incrementally in this version.

The detailed listing of updates for this version follows:

Update core code and import routines to handle additional constraints on numerous data columns throughout the core database.

The following were incremental updates, listed in the order by date they were made available in the site:

Changed the Issue Variants area of the Issue Detail page to have the disclosure interface default to open when not previously set by a logged in user. [posted 20121024]

Changed the display of prices in the listing area of the Series Detail, Issues Listing page to take advantage of the extra space. Each price is now displayed on a separate line. [posted 20121024]

Moved the Expand and Collapse icons on the Icons page from the logged in users section to the public section to account for the new usage these will put towards in the listing of Issue Variants on listing pages. [posted 20121024]

Cleaned up the rollover menu for Views on the Series Detail, Issues Listing page. Views were all given textually descriptive names and organized more logically for further additions to be added soon. [posted 20121026]

Added Issue Variants menu item as a flag to the View rollover menu on the Series Detail, Issue Listing page. This is basically an option that can be turned on and off by selecting it in the menu. [posted 20121026]

Updated the Series Detail, Issues Listing page to now display Issue Variants when the new, core request parameter is enabled (enabled by selecting Issue Variants in the Views rollover menu). Issue Variants are each given a new "row" in the listing area and the Issue Variant Name is displayed after each Issue Number for identification purposes. All functionality on the page was updated to now work properly with Issue Variants (e.g. My Collection, title and counts in header area of listing, etc.). [posted 20121024]

Added core request parameter as a flag to indicate whether Issue Variants should be displayed on a listing page. Obviously, by default, the intent is for this to always be off. [posted 20121027]

Fixed bug in which a hilited Issue Image was not being scrolled to automatically when navigating to an Issue Image Detail page. [posted 201228]

Added new column to all My Collection tables in the database for denormalized storage of Variant ID values for each Issue in My Collection. [posted 20121029]

Updated all table triggers to automatically keep updates the new Variant ID columns in the My Collections tables. [posted 20121029]

Wrote and ran SQL routines to populate all rows in the My Collection tables of the database with proper values for the new Variant ID columns. [posted 20121029]

Update all queries for proper handling of My Collection display with Issue Variants in the listing area of the Series Detail, Issues Listing page. This now finishes the adding of full support for Issue Variants on this page. [posted 20121029]

Updated the interfaces for editors and logged in users when adding (uploading) a new Issue Image. The updates now include all new Issue Image attributes in the interface (position, title page flag, indicia on page flag, and original artwork flag. [posted 20121030]

Added support for Issue Variants in the Content Item Move editor tool. The selection interface now displays all Issues in the current Series along with all Issue Variants. [posted 20121101]

Added support for Issue Variants in the Issue Image Move editor tool. The selection interface now displays all Issues in the current Series along with all Issue Variants. [posted 20121101]

Added the display of Volume data to the selection interface in the Move editor tool for Content Items. [posted 20121101]

Added the display of Volume data to the selection interface in the Move editor tool for Issue Images. [posted 20121101]

Created new page for Incremental Updates. This new page is under the About Us section of the site and is intended to hold, well, what you are reading here. [posted 20121102]

Added "Move Up" editor tool for Issue Images. This allows for Issue Images to now be moved to any Issue in any Series in any Publisher in the site. [posted 20121106]

Added "+" and "-" keyboard equivalent support to the Group Edit tool for Issues' Prices. [posted 20121106]

Added currency formats for the Belgian Franc (BEF) and the Swiss Franc (CHF). [posted 20121106]

Ran query to clean up all sort code values in a Series for Issue Variants. [posted 20121107]

Added trigger to Issues table to maintain the sort code value for Issue Variants. [posted 20121107]

Added Issue Images Viewer to the Issue Variants detail area on the Issue Detail page. This allows now for the viewing of all Issue Variant Issue Images for any single "base" Issue from one page (from any "parent" or "variant" of that Issue). [posted 20121107]

Integrated all external datasets up thru 20121101. [posted 20121112]

Added separate "Sortable Name" column to the Series table. [posted 20121114]

Ran update SQL to initially populate all rows for the new Sortable Name column. [posted 20121114]

Added an index onto the new Sortable Name column for Series. [posted 20121114]

Added new Sortable Name column to the editor interface when editng the name of a Series. [posted 20121114]

Updated all sorting of Series names to now use the new Sortable Name column. [posted 20121114]

Update Create and Clone editor tools for Series to duplicate the value of the new Series Name into the new Sortable Name column. [posted 20121114]

Update the import routines to now support the new Sortable Name column for Series. [posted 20121114]

Add the new Sortable Name column on Series onto the Edit All page for Series. [posted 20121114]

Added new editor privilege to Review Submitted Changes. Added listing of new editor privilege to the View Privileges page. [posted 20121115]

Added Review Submitted Changes page to the editor menu for those editors with privileges to access the page. It is a "list, review, and approve" page for all submitted changes to the data from users. [posted 20121115]

Improved sorting by Object Title on the My Open Tasks and Submitted Changes pages for editors when viewing Issues, Issue Images, and Content Items. The sorting now accounts for different Series of the same name and sorts Issues within the same Series by the ordering of the Issues in the Series. [posted 20121117]

Add the flag for the country of the Publisher to the display for each Issue Image Open Task row on the My Open Tasks page. [posted 20121117]

Added new column to the Users table for handling public access to editing tools for logged in users. Note, this is outside the access to editor privileges. [posted 20121119]

Add Task Notes area to editor tool for Issue Images when the volunteer editor has access to My Open Tasks and the Issue Image is marked for deletion externally. [posted 20121128]

Added automatic resolve of any Open Task for Issue Image when volunteer editor edits the details of an Issue Image and clears any existing marking for deletion externally. [posted 20121128]

Added counts from Issues to display when viewing Issue Images on the My Open Tasks page. [posted 20121128]

Corrected sorting by Series Name on the My Open Tasks page when displaying Series, Issues, Issue Images, and Content Items. [posted 20121129]

Corrected bug where when editing the Price for an Issue, only one Open Task on the Issue's Price would be automatically resolved. Site now correctly resolves automatically all Open Tasks for the Issue's Price. [posted 20121202]

Added new selection when notating an Issue Image for "Markings on Original Cover". [posted 20121203]

Added many missing interface labels used to auto-generate display content in some of the editor management pages. [posted 20121203]

Integrated Object, Attribute, and Action columns into a single column of display on the My Changed Objects page. Added "Name" column to the display of this page for easier identification by the volunteer editor. [posted 20121203]

Corrected bug during import processing in which extraneous tasks are generated when cascading external deletion flags. [posted 20121205]

Cleared out all extraneous tasks that were automatically generated errneously during imports due while cascading external deletion flags. [posted 20121205]

Corrected bug wherein the flagging for deletion using the editor tools was not cascading through the data hierarchy correctly (e.g. deleting a Series was not deleting the Issues in the Series). [posted 20121205]

Updated the My Open Tasks page for editors to display the country of the parent Publisher for any type of data being displayed. [posted 20121206]

Corrected bug on the My Open Tasks and Submitted Changes pages for editors when Publishers are displayed wherein the Indicia Count was not displaying correctly. [posted 20121206]

Removed all extraneous and redundant "note:" lines of text for existing Tasks, both in the Automatic Creation Notes and Automatic Resolution Notes. [posted 20121207]

Modified code throughout site to no longer insert "note:" lines of text for Tasks, both in the Automatic Creation Notes and Automatic Resolution Notes. [posted 20121207]

Updated import routines for integrating changes from the Change Log to respect the acceptance and rejection of individual changes entered in the log. [posted 20121207]

Added red background display of individual Issue Numbers on the Series Detail, List Issues page for editors with access to Delete Issues and Tasks, only for those Issues that have been externally marked for deletion and have an Open Task for the deletion to be reviewed. [posted 20121208]

Added "Delete Many" page for Issues in a Series accessible from the Series Detail, List Issues page. This is all of the Issues and Variants in the Series listed in a display format with checkboxes to delete as many Issues as desired at one time with the submission of the page form. Issues that have been externally marked for deletion and have Open Tasks for the deletion to be reviewed have the Issue Number and Content Items Counts column highlighted in red and the checkboxes are defaulted to checked when the page is displayed. [posted 20121209]

Added currency formats for the Austrian Schilling ATS, Tunisian Dinar TND, Morroccan Dirham MAD, and Brazilian New Cruzado BRN. [posted 20121210]

Corrected the default listing of Publishers (by first letter) to properly determine the first letter of the current Publisher on all Move and Move Up tools for editors. [posted 20121211]

Added "editor preference" tracking to the editor Move Up tool for Issue Images. The last Publisher and last Series that was selected with the tool is now remembered during the current browser session and selected by default on the subsequent opening of the tool. [posted 20121212]

Automatically set the focus in the interface of the editor's Move Up tool for Issue Images to the Issue selection item. [posted 20121213]

Expanding "first letter" selections of Publishers on all Move and Move Up tools for editors. Added "outside standard letter" range options and sectioned off letters 'a', 'c', and 's'. [posted 20121214]

Automatically set the focus in the interface of all editor Move and Move Up tools containing Series and Publishers. [posted 20121217]

Implemented editor preferences in all editor Move and Move Up tools containing Series and Publishers. Distinct memory of Publishers and Series, even distinct memory of Series in Moves and Series within Publishers in a Move Up. [posted 20121217]

Added Move Up tool for Brand Images. New editor tool is on the Brand Detail page. [posted 20121218]

Added "date accepted" column to the Editor Change Log table for tracking exactly when changes have been accepted in the data. [posted 20121226]

Added access for logged in users to change Issue's ISBN and Indicia Frequency data from the Issue Detail page. Pending changes are shown next to each data item using the "Submitted Change Pending" icon. Restricted changes to data with a Submitted Change that is pending to only the original user that submitted the change or to editors. [posted 20121226]

Updated editor tools to show any Submitted Change data that is pending approval. [posted 20121226]

Updated the editor's Review Submitted Changes page to handle approves/rejects on Submitted Changes that are pending. [posted 20121226]

Added Submitted Change icon to the Icons Legends page for Users (Account Holders). [posted 20121226]

Reorganized pulling of Submitted Changes on the Issue Detail page so it could be easily added to the Cover Detail page. Added all new user editing and editor reviewing tools to the Cover Detail page. [posted 20121226]

Added support for Users (Account Holder) editing of UPC/EANs within Issues. [posted 20121227]

Upgraded and improved admin views of users and editors within the site. [posted 20121228]

Added support for Users (Account Holder) editing of Page Counts within Issues. [posted 20121228]

Added support for editors to Move, Move Up, and Delete Issue Images from Issues that have already been deleted. [posted 20121228]

Added currency formats for the Dutch Guilder NLG, Australian Pound AUP, a modified Australian Pound for Pence AUQ, Luxemburg Franc LUF, and the Czech Koruna CZK. [posted 20121229]

Modified the display of all currencies for all countries using the Euro to now display the sourcing country abbreviation after the currency code (e.g. 'EUR (FR)' for the Euro in France). Too many comics are priced separately per country using the Euro to have forced this as a needed feature. [posted 20121229]

Added support for Users (Account Holder) editing of Brands within Issues. [posted 20121229]

Updated deletion of Issues to automatically resolve any Open Tasks for Content Items within the Issue being deleted. [posted 20121229]

Ran routine to update all existing Open Tasks for Content Items to resolved if Issue containing the Content Item was already deleted. [posted 20121229]

Created Issues Extras table in secondary database cluster server for storing secondary information about Issues. [posted 20121230]

Added generic Editor Tools Interface library for separating interface from code within the site for editor tools. [posted 20130102]

Added Issue selection with full hierarchy interface object to new Editor Tools Interface library. [posted 20130102]

Added admin interface for setting Forwarding Issues, including the automation of updating My Collection entries for new Forwarding Issues data that is set. [posted 20130102]

Added Move Up editor tool for Content Items. This now allows a Content Item to be moved to any Issue within any Series within any Publisher. [posted 20130103]

Moved all Issue level editor tools from the header area on the Issue Detail page to being under a single tools rollover menu on the left side of the header area. [posted 20130104]

Moved the tools menu for each Issue Image on the Issue Detail page to now be activated for the rollover menu by merely rolling over an Issue Image directly. Setup interface to dim the Issue Image while access to the rollover menu is available during the rollover. [posted 20130104]

Update Help page for Login and Logout to include documentation for the contextual login and logout functionality available on every page of the XOWComics.com site. [posted 20130104]

Added Issue selection within Series interface object to Editor Tools Interface library. [posted 20130105]

Modified existing editor Cover Move tool to use new Editor Tools Interface library object, thereby reduced a significant amount of code. [posted 20130105]

Added editor tool to Move DCBs using the new Editor Tool Interface library object for selecting an Issue in a Series. [posted 20130105]

Added editor tool to Move Up DCBs using the new Editor Tool Interface library object for selecting an Issue in the data hierarchy. [posted 20130105]

Correct problem with undimming Issue Image after using one of the tools in the rollover menus accessible within the Issue Image. [posted 20130106]

Added support for Users (Account Holder) editing of Volumes within Issues. [posted 20130108]

Created Series Extras table in secondary database cluster server for storing secondary information about Series. [posted 20130109]

Added automatic forwarding handler on the Issue Detail page for Issues that have been set to forward to a different Issue. [posted 20130109]

Moved editor tools on the Series Detail page under tools rollover menu in the header of the detail area. [posted 20130111]

Added editor tools on the Series Detail page to set the Series Forwarding, Series Continued From, and Series Continued In values. [posted 20130111]

Added automatic forwarding handler on the Series Detail page for Series that have been set to forward to a different Series. [posted 20130111]

Added display as links of the Continued From and Continued In values for a Series on the Series Detail page. [posted 20130112]

Corrected bug in which the setting of the first and last Issue within a Series was incorrectly including Variants when determined the ordering of Issues. [posted 20130112]

Moved all Content Item editor tools into rollover "gear" menus to simplify interface. [posted 20130114]

Added display of Content Items Counts from the base Issue when showing a Variant Issue on the Issue Detail page. [posted 20130129]

When showing a Variant Issue on the Issue Detail, List Content Items page, all Content Items from the "base issue" are now displayed. The only exception to this is any Content Items of type 'cover' from the 'base issue' if the displayed Variant Issue already has one or more Content Items of type 'cover'. [posted 20130129]

When selecting a Content Item to link an Issue Image to using the editor tools, all Content Items from the 'base issue" are now available for linking when currently working within a Variant Issue. The only exception to this is any Content Items of type 'cover' from the 'base issue' if the displayed Variant Issue already has one or more Content Items of type 'cover'. [posted 20130129]

Added support for Users (Account Holder) editing of Editors within Issues. [posted 20130129]

Added support for Users (Account Holder) editing of Notes within Issues. [posted 20130130]

Added support to existing REMS Management System to now handle different page types. Existing functionality upgraded to support new functionality. [posted 20130130]

Updated all existing REMS Pages previously retrieved to now have a proper REMS Page Type set for the data. [posted 20130130]

Added support for Users (Account Holders) editing of Indicia Publishers within Issues. [posted 20130131]

Updated REMS Management System to handle external changes listings. This includes the retrieval, storage, tracking, and parsing of the external changes listings. [posted 20130207]

Updated REMS Management System to handle additional external image types. Specifically, this in the retrieval, storage, and linking of the external images. [posted 20130207]

Updated display of Brands and Brand Images throughout the site to support larger range of Brand Image sources. [posted 20130207]

Added comprehensive list of adult terms to the stop words for searching. The progressive addition of more adult content has required steps to be taken to try to adequately protect viewers of all ages and maturity using the site. [posted 20130209]

Created new schema for the stop words used in the site so the data will be available within the code as data and not just the advanced search engine. Loaded all existing stop words into the data schema for use by new, core libraries. [posted 20130210]

Added flags to both Series and Issues for indicating "adult" content. [posted 20130211]

Built and ran admin routines to initially populate new "adult content" flags for Series and Issues. Worked against new listing of adult terms to initially set these new flags. [posted 20130212]

Updated core page display routines to now include special handling for "adult" content. [posted 20130212]

Updated all Series Detail and Issue Detail pages to respect "adult" flags for sourcing and displaying content. [posted 20130212]

Update all data import routines to scan content for "adult" terms and set the "adult" flags for Series and Issues for new data. [posted 20130212]

Added support for Brand Images on the My Open Tasks and My Resolved Tasks pages for editors. [posted 20130213]

Added Brand Image highlighting on the Brand Detail page when navigating from the My Open Tasks or My Resolved Tasks page for editors. [posted 20130213]

Added automatic scrolling to Content Item being worked with when it is added, cloned, or moved with any of the editor tools. Forced open disclosure on the Content Item also after one of these editor tools has been used. [posted 20130215]

Forced the disclosure widgets to be closed initially for the Detail and Issue Images areas on the Content Items sorting page for editors. [posted 20130215]

Corrected bug with maintaining the display type in the links of the Series Continuance values in the detail area of the Series Detail page. [posted 20130217]

Corrected bug with the parsing of titles for newly imported external images. The full title was not being fully decoded for HTML entities. Ran routine to correct previously pulled data for this mistake. [posted 20130218]

Corrected bug with the linking to the base Issue from the Content Item links in the detail area on the Issue Detail page wherein the link was to the Issue Variant and not the base Issue. [posted 20130223]

Corrected bug wherein the Move editor tool for Content Items did not allow access to the tool when within a variant Issue. [posted 20130225]

Removed editor tools for Move, Move Up, and Delete of Content Items for Content Items being displayed from the base Issue when viewing a variant Issue. This makes it a little cleared that changes here affect more than just the variant Issue being viewed. [posted 20130225]

Corrected bug with the Clone editor tool for Content Items not showing variant Issues in a Series in the selection interface for selecting the destination for moving the newly cloned Content Item. [posted 20130225]

Corrected bug in the detail area of the Issue Detail page in which the DCBs and Variants areas were not enclosed within the disclosure widget control for the entire detail area. [posted 20130225]

Added support for Users (Account Holders) editing of Publication Dates within Issues. [posted 20130226]

Added support for Users (Account Holders) editing of Variant Names within Issues. [posted 20130226]

Added "Needs Cropping" as selectable option for Issue Image Notations. [posted 20130226]

Added support for Users (Account Holders) editing of (Issue) Numbers within Issues. [posted 20130227]

Changed sorting by Counts on My Open Tasks page for editors when viewing Issue Images to work only on "has/has not" Content Items of type "cover". [posted 20130228]

Dropped all support for Series Classifications (features never fully implemented in site, anyways). This involves dropping all data structure for it, updating data importing routines, and updating all core Series row creation routines.

Added minimal support for new columns within Series for future data expansion.

Always more coming...