This is a complete version history of the XOWComics.com site for the year 2012. Other years are available by using the links listed just below.
You can also use the "Versions" rollover menu, just below also, to quickly jump to individual release version. The release dates for each version are listed in the rollover menu for your convenience.
You can see quite easily how quickly the site has progressed. Your feedback has driven this success and rapid development!
This new version of the site includes many incremental updates that have been made throughout the last few months, particularly dealing with Issue Images and editor tools for managing Issue Images. A lot of prepatory work was included for new features begun in this version and planned to continue with updates through the end of this calendar year. The base management and display of Issue Variants has been included with this version, along with editor tools to fully manage Issue Variants. Also, new attributes for Issue Images have integrated into this update, simplifying considerably the different types of Issue Images within the site.
The detailed listing of updates for this version follows:
Added Variants Count for each Issue on the Series Detail, Issues Listing page as a count balloon next to the issue number of each issue.
Added Variant Name to the detail area of the Issue Detail page. Full editor tools are available to manage the value and it was made available on the Edit All page for Issues, too.
Added Variants detail area within the core Detail area on the Issue Detail page. It is basically a listing of all Issue Variants within the current Issue, editor tools for managing variants, and navigation for viewing the different variants.
Disabled the Clone, Move, Move Up, and Delete editor tools for Issues on the Issue Detail page when currently viewing an Issue Variant. Disabling is indicated in the interface by dimming the displayed icons.
Added editor tool for delete of an Issue Variant.
Added editor tool for clone of an Issue Variant.
Added editor tool for create of an Issue Variant.
Moved all of the tools for each Issue Image into a "Tools Rollover Menu" that is displayed with each Issue Image. This removes considerable clutter from the interface on the Issue Detail and Cover Detail pages.
Added new Issue Image Attributes (Position, Original Artwork, Title Page, and Has Indicia) to the editor tool for Issue Images.
Added display of new Issue Image Attributes (Position, Original Artwork, Title Page, and Has Indicia) to the Issue Detail page for each Issue Image.
Added DCBs area to to detail area on the Cover Detail page, making it the same then as the Issue Detail page for DCBs.
Added Edit Group tools for both ISBN and UPC/EAN values within a Series.
Integated the detail content for Issue Detail and Cover Detail pages into a single code base. This allows for easier updates for these pages that are so very similar.
Ran routines to automatically populate the new attribute columns (Position, Original Artwork, Title Page, and Has Indicia) for Issue Images.
The following were incremental updates, listed in the order by date they were made available in the site:
Corrected bug with Next and Previous navigation of Issues when displaying an Issue with no Content Items [posted 20120812].
Added editor access privileges for Issue Variants: edit, delete, create, and clone [posted 20120814].
Added currency formats for Mexican Nuevo Peso MXN, Colombian Peso COP, Bolivian Boliviano BOB, Venezuelan Bolivar VEB, Venezuelan Bolivar Fuerte VEF, Ecuadoran Sucre ECS, and Chilean Peso CLP [posted 20120823].
Added deletion control column to the Content Item Types table for managing older content item types that will no longer be used [posted 20120828].
Added support for new deletion control column in the Content Item Types table to the import routines [posted 20120828].
Added support for new deletion control column in the Content Item Types table throughout the user interface of the site [posted 20120828].
Import routines updated to handle new Content Item Types from external data sources [posted 20120828].
Correct bug in which cloned Content Items were not always set to the last Content Item in the target issue [posted 20120830].
Updated cloning of Content Items to now allow the title of the Content Item to be changed directly in the interface while cloning [posted 20120830].
Updated the creation of a Content Item to allow for the selection of the Content Item Type in the interface while creating the new Content Item [posted 20120906].
Corrected bug in core function that set the first and last Issue in a Series as it was not respecting the deletion column for Issues [posted 20120907].
Added new "hilite" display for particular Issue Images when navigating for My Open Tasks page to make it clear which Issue Image is being worked with in an individual task [posted 20120918].
Added automatic creation of Open Task when an Issue Image is being replaced externally [posted 20120920].
Modified external replacement of Issue Images to automatically copy over any existing Caption, Notes, and Content Item Links to the replacing Issue Image [posted 20120922].
Run routine to automatically copy in the caption, notes, and linked Content Item for Issue Images that have been previously replaced externally within the site [posted 20120922].
Run routine to create automated Open Tasks for Issue Images that have been previous replaced externally within the site [posted 20120923].
Added checkbox for clearing the externally replaced flag for Issue Images to the interface for editors when working with Issue Image attributes [posted 20120923].
Added "Count(s)" column to the My Open Tasks page. It shows the number of items lower in the data hierarchy that are within the currently displayed item (e.g. for Series, the number of Issues in the Series). Added sorting capabilities for this new column in ther interface [posted 20120928].
Create Issue Images Positions table for storing all of the different positions an Issue Image may occupy within a physical issue [posted 20121006].
Added columns to the Issue Images table for linking to Issue Image Positions, flagging for Title Page, flagging for Has Indicia, and flagging for Original Artwork [posted 20121006].
This update provided a new, incremental updating mechanism for features and upgrades to the site, allowing the posting of individual feature changes into the production site on a continuous basis. Many individual changes listed for this "version" of the site (and for all future versions moving forward) are merely a compilation listing of changes made incrementally since the last full update of code within the site; full code updates will continue less frequently, obviously, now that incremental updates are available.
The detailed listing of updates for this version follows:
Changed Login form to a ModalBox for "on page" login to user accounts.
Changed Logout form to a ModalBox for "on page" logout to user accounts.
Added preferences for users to set the default disclosure setting for the visibility of Content Items by Type in the site.
Added new Gear (i.e. "Tools") icon to the Issue Detail, List Content Items page at the top of the Content Items section to handle the control of the visibility of Content Items by Type.
Added "gears" icon for use as an access point to user tools throughout the site, the content being contextual to the current page obviously.
Added individual disclosure functionality for Content Items on the Issue Detail, List Content Items page.
Moved Content Item Type to just below the Title in the header areas for individual Content Items on the Issue Detail, List Content Items page.
Changed navigation of Views on the Series Detail, List Issues page to rollover menu in the pagination bar of the listing.
Added Issue Image count to Issue Image area on the Issue Detail page.
Added Notes for Issue Images to the ModalBox Issue Image viewer throughout the site.
Combined all of the attributes for editing an Issue Image into a single ModalBox for editors.
Removed Has Image Gallery from the Series Detail page.
Removed Has Gallery from all listing pages for Series.
Added many new currency formats to the site.
Removed brackets around Notes for Issue Prices on the Issue Detail page.
Updated the datestyle input format for the core database for increased compatibility with a couple of uncommon date formats.
Increased parsing and trimming compatibility for entered search strings throughout the site.
Corrected handling of entered searches when the trimming and parsing results in an empty search string for the TSV engine.
Corrected bug with the actual Search Page being broken.
Added Move tool for DCBs.
Added rounded document size column to the Series Detail, List DCBs page.
Skipped directory selection when adding multiple DCBs when only a single directory exists.
Corrected bug with different, denormalized counts in an Issue not being updated when the Type of a Content Item was changed.
Corrected bug in the editor tool for Issue Prices in which the Note for the default, selected Issue Price was being displayed initially in all caps.
Corrected bug with the save button being disabled when using the Group Edit tool for Brands when no Brands exists in the current Publisher.
Corrected bug with some triggers for hierarchical counts (denormalized data) on the Issues table not handling disparate table names during importing.
Updated all import routines to handle the schema for Issue Prices.
Corrected bug in external data sources not providing complete data updates with compatible or syntactically correct SQL.
Added CORS compatibility to the site for proper security across multiple, individual domains.
Filtered all uses of Issues throughout the site to remove the display of Variants. Future updates will handle the display and editing of variants more specifically and correctly, not treating them as "full", individual Issues.
Created column for denormalizing counts of variants within an Issue.
Created triggers for maintaining the new variants count column for Issues.
Update all tools and libraries used throughout the site to the latest releases.
Wednesday, August 8th, 2012: Integrated external data sets dated January 15th, 2012, into site.
This update is a maintenance release providing some specific tweaks in the interface, cleaning up some commonly used code, and adding more administrative tools for DCBs. The detailed listing of updates follows:
Swapped the Browse by interface and social media links in the main navigation bar so the Browse by interface is now more directly below the Search interface.
Changed the Editors menu to an icon and moved to the left side of the navigation bar.
Centralized core routine for generating series name, issue number, volume, etc., as text and HTML. Implemented use of the new routines throughout the site.
Built admin page for managing DCBs that have been marked for replacement.
Built admin page for managing Issues that have multiple DCBs already.
Built admin page for managing DCB documents that have been flagged for deletion.
This update is a maintenance release correcting some specific outstanding bugs in the site and increases support for further expansion of storage for DCBs. The detailed listing of updates follows:
Added support for automatically closing the quotes on a search string if the trailing quote character seemed to be missing (e.g. searching for ["Weird War]).
Added CSS attributes for the SUP and SMALL HTML tags.
Added enterable filter when using the prefill DCBs placement tool.
Added concept of "active working" DCB server to PHP code to indicate the current DCB server used for uploading and placement of DCB documents.
Setup second DCB server within site completely.
Corrected bug with placement of DCB documents to make sure document type checks are completely case-insensitive.
Corrected bug wherein stop words being the sole words as a quoted search (e.g. searching for ["What the"] or ["What If"] gave incorrect results and a syntax error in the SQL.
Corrected bug wherein having stop words in quoted section of a search (e.g. searching for [Archie's Pals 'N' Gals Double Digest Magazine]) gave incorrect results and a syntax error in the SQL.
This update adds a new feature for all account holders: My Search History. Also, almost all of the outstanding updates to the Edit All pages for Editors have been completed with this version. The detailed listing of updates follows:
Added Search History to the main navigation bar for account holders showing last 20 most recent searches.
Added My Search History page under My Account in the navigation hierarchy.
Added indexes on the Search History table for multiple columns to provide improved speed in interface for sorting.
Change Location rollover to "Pin" icon in main navigation bar and moved to far left.
Added Indicia Publisher not Printed, No Brand, No Indicia Frequency, No Volume, Display Volume with Number, No ISBN, Barcode/EAN, No Barcode/EAN, and Page Count Uncertain interfaces to editor's Edit All page for Issues.
Added Years Range Uncertain interface to all Edit All pages for Editors at all levels in the data hierarchy.
Added value attribute to all checkboxes in the HTML interface.
Removed Issue Images from editor's Edit All page for Issues.
Added Host Number column to the DCBs table for expansion storage.
Set value for new Host Number column for all existing rows in the DCBs table.
Update code in site to set Host Number column for all new rows added to DCBs tables.
Added central SQL function to populate "All Below" denormalized column for the Issues table.
Added triggers to populate the "All Below" denormalized column for Issues.
Added triggers to populate the TSV value for "All Below" for Issues.
Removed old PHP code that is now handle in triggers for denormalized columns in the Issues table.
Corrected bug with "HTTP_HOST" value not always being provided in the HTTP request from particular clients.
This update provides significant upgrades to the search engine used throughout the site. In particular, quoted searches are now supported with this version. And, searches for specific issue numbers were added to the new parser feeding the search engine. The detailed listing of updates follows:
Added support for doing quoted searches throughout the site for all searches. Quoted searchs use either single or double quotes, obviously.
Added support for searching for specific Issue Number values when using Search Everything. Format for Issue Number searches is "#xx", without the quotes, where "xx" is numeric digits only.
Changed the Favorites rollover menu for logged in users in the Location line of Main Navigation Bar to an icon (a star) and moved it to the left side of the interface.
Added new Search Notice row in the pagination bar of all Search result pages for displaying details about the search that was run to generated the displayed results. Initially, it shows the parsed values used for the search.
Update Help page for Search to document new features. Also updated the default search page shown when no viable query terms have been entered for a search.
Added denormalized columns to the Issues table for data congregation values of "above" and "below" data.
Added triggers to automatically manage the maintenance of the new, denormalized data congregation columns for Issues.
Added triggers to automatically manage the maintenance of the text search vector column for "above data" for Issues, obviating the need for code to manually manage this denormalized column of data.
Added code to the core PHP routine for editing data to maintain the new, denormalized data column for "below data" for Issues.
Ran update query to initially populate new, denormalized data congregation columns for Issues.
Added denormalized columns to the Issues table for Brand name and Indicia Publisher name.
Added triggers to automatically manage the maintenance of the denormalized name column for Brands within the Issues table, obviating the need for code to manually manage this data.
Added triggers to automatically manage the maintenance of the denormalized name column for Indicia Publishers within the Issues table, obviating the need for code to manually manage this data.
Ran update query to initially populate new, denormalized columns for Brand name and Indicia Publisher name in the Issues table.
Added triggers to automatically manage the maintenance of the denormalized Publisher ID within the Issues table, obviating and supplanting the need for code to manually manage this data.
Added triggers to automatically manage the maintenance of the denormalized name column for Publisher within the Issues table, obviating and supplanting the need for code to manually manage this data.
Added triggers to automatically manage the maintenance of the denormalized name column for Series within the Issues table, obviating and supplanting the need for code to manually manage this data.
Lengthened the denormalized storage columns for Series name and Publisher name in the Issues tables.
Added a full text search parsing engine to the core PHP code for use whenever searches in the site are run.
Updated all search routines used in the site to use the results of the new full text search parsing engine. Accounted for quoted searches and Issue Number searches (the latter only when using Search Everything).
Separated the Version History page into a separate page for each calendar year. Cleaned up content of these pages and added navigation in the interface for these changes.
Corrected bug in the Move Up tool for Issues where the Issue ID values was not always being set correctly.
Corrected bug in the DCBs download page in which there was a missing parameter when setting the volume/issue name for a DCB document being downloaded.
This update finishes the integration of the new columns and options for Issues into the Edit Group tools for volunteer editors. In particualr, the Series Detail, List Issues page has been updated to reflect some of the new options and to make it clearer to all users the data, as availble, within the site for each Issue. Many other minor enhancements and bug fixes were included in this update. The detailed listing of updates follows:
Added discrete Volume column to the Series Detail, List Issues page in the Primary View. Make it a fully sortable column in the interface.
Updated the Edit Group tool for Volume to integrate the No Volume and Display with Issue Number fields.
Added Edit Group tool for Page Count and Page Count Uncertain fields in an integrated tool available from the Series Detail, List Issues page.
Updated the Edit Group tool for Brands and the Edit tool for Brands should resize proportional to the Brand Image being displayed for the currently selected Brand in the interface.
Updated Edit Group tool for Brands to integrate the No Brand field.
Updated the Edit Group tool for Indicia Frequency to integrate the No Indicia Frequency field.
Updated the Edit Group tool for Indicia Publishers to integrate the No Indicia Publisher printed field.
Renamed "Content Items Count" to just "Content Items" throughout the site.
Updated Editor Change Log integration routines used during imports to support the sorting edits for Issues within a Series and Content Items within an Issue.
Added RSS feed from Comic Booked to the Current News page.
Added RSS feed from Newsarama to the News, Previews page.
Added RSS feed from Newsarama to the Current News page.
Corrected bug for uncaught condition in the core RSS parsing library which resulting in some RSS feeds not showing in the site.
Added automatic parsing and movement of UPC data from the Notes field in Issues to the Barcode field during imports.
Ran data movement routine to parse the UPC data from the Notes field in Issues to the Barcode field in the existing data.
Increaed the Job Number field within Content Items from 50 bytes to 100 bytes.
Added currency format for the Danish Krone 'DKK'.
Updated the OS, site tools, and server software to current released version.
This update integrates another new piece of data for Issues into the site: Page Count. This is now available throughout the site, including on the main Issue Listing section of the Series Detail page. Many other minor enhancements and bug fixes were included in this update. The detailed listing of updates follows:
Added Page Count column in the Detail area of the Issues Detail and Cover Detail pages.
Added the Page Count column to the primary view of the Series Detail, Issues Listing page. Added sorting option on page for the new column.
Added editor tool for managing the Page Count and Page Count Uncertain column in the Issues table.
Added core routine for display in HTML of the newly supported Page Count and Page Count Uncertain columns of the Issues table. Obviously integrated usage of this routine throughout the site.
Added index on Page Count column of Issues table to facilitate prompt sorting on the column.
Added distinct editor tool for editing the Volume, and newly supported Display Volume with Issue Number and Volume Not Present, columns. This new editor tool has all of these controls integrated in a single modal form.
Added core PHP routine for displaying the Volume, with the newly supported Display Volume with Issue Number and Volume Not Present, columns from a central, unified location. Obviously integrated usage of this routine throughout the site.
Modified Editor's Years Range edit modal form to prevent the entry of inverted values.
Cleaned the Issues Range display in the Detail area of the Series Detail page to more clearly depict the Issue Numbers from the core routines and to make the Issues Count more distinct.
Modified the editor tool for the selection of Brand in an Issue when there are no Brands in the enclosing Publisher.
Modified the editor tool for the selection of Indicia Publisher in an Issue when there are no Indicia Publishers in the enclosing Publisher.
Corrected bug wherein the First Issue relational value was not being set when the first Issue in a Series was being added.
Ran routine to correct the denormalized First Issue relational value for all Series.
Corrected bug in the trigger for Covers table that resulted in the Series ID relation value to be set incorrectly.
Ran routine to correct the Series ID relational value in Covers table for all of those that had been previously set incorrectly.
Ran routine to correct the values Has Gallery on all Series that had not been set correctly previously.
Corrected bug with the Brand Image Viewer link on the Publisher Detail, Brands Listing page.
Corrected security bug with the display of DCBs on the Issue Detail page.
Corrected bug with the setting of the Stories Indexed column for DCBs from the Edit DCBs editor tool.
Corrected syntax error in the automaton for the storage of the Brand selected for an Issue in the edit tool for editors.
Added CSM tracking codes for all account logins to automate tracking and communications of support requests and communications.
Added CSM tracking codes to all Contact Us forms in the site to speed customer service requests and responses.
Enabled CIDRs reverses on the primary domain in Apache.
Created core CSM tracking codes table for all user accounts.
This update adds to the new options for many of the pieces of data throughout the site. It allows for more discrete options for setting data by volunteer editors. One of the new pieces of data has also been integrated into this update. The detailed listing of updates follows:
Ran routine to automatical set the new Indicia Frequency Uncertain flag if the Indicia Frequency text value contains the word "none".
Added core PHP routine for display the Brand set for an Issue.
Updated Select Brand editor tool to account for the new No Brand column.
Updated data importer to handle clean Brand column in Issues if the No Brand column is set.
Added core PHP routine to display the Indicia Publisher for an Issue.
Updated Select Indicia Publisher editor tool to account for the new No Indicia Publisher column.
Updated data importer to handle clean Indicia Publisher column in Issues if the No Indicia Publisher column is set.
Update import routines to scrub the new Barcode column for Issues.
Added index on the Barcode column for Issues.
Added core PHP routine to display the Barcode for an Issue.
Added new Barcode column in Issues to the Issue Detail and Cover Detail pages.
Added new Barcode column in Issues to the Series Detail, Issues Listing page (Secondary View).
Added editor tool to edit the new Barcode colum within an Issue, accounting for the No Barcode column.
Changed Issue Image importing to automatically overwrite existing documents by their identifier when importing image documents.
Ran correction to fix any existing Issue Image documents that had a length of zero bytes.
Moved the DCBs section to the bottom of the Issue Detail content section of the page.
Added newly support Barcode column for Issues to the extended ASCII scrubbing trigger.
Added scrubbing triggers for the new Barcode column of the Issues table to remove all non-integer ASCII byte values.
This update provides many additional columns of data throughout the site to aid in compatibility with additional data fields. A few of the new columns have been integrated into usage into the site with this update with more to come in future updates. The detailed listing of updates follows:
Added "uncertain" columns for Year Began and Year End columns in the Publishers, Indicia Publishers, Brands, and Series tables.
Added core PHP routine for the formatting and display of Years Range values within HTML for use throughout the site.
Added Years Range editor tool for an integrated interface to enter a beginning and ended year value, with uncertainty checkboxes, to Publishers, Indicia Publishers, Brands, and Series.
Added "Uncertain Year Began" and "Uncertain Year Ended" columns to Publishers, Indicia Publishers, Brands, and Series tables. Integrated support for these new columns and values throughout the site.
Added core PHP routine for the formatting and display of Indicia Frequency data for use throughout the site.
Added support for "no indicia frequency" column in the Series table for use throughout the site. In particular, a specialized editor tool was created for entering the Indicia Frequency value and the No Indicia Frequency checkbox in a single, integrated interface.
Added core PHP routine for the formatting and display of ISBNs within Issues for use throughout the site.
Added support for "no ISBN" column in the Issues table for use throughout the site. In particular, a specialized editor tool was created for entering the ISBN value and the No ISBN checkbox in a single, integrated interface.
Added many new columns to the Series table to support additional data requirements for future features.
Added many new columns to the Issues table to support additional data requirements for future features.
Updated all XOWComics.com logos throughout the site to v021.
Set the auto-focus to the username field on the Login page.
When adding a Series using the editor tools, the target page was changed from the Series Detail page to the Series Detail, Issues Listing page.
Added currency format for ESP currency type.
Made the addition of a Price on the Price entry editor tool automatically set the auto-focus to the price value field.
Handled cleaning of new columns text and string data from external data sources.
Added original document name to the DCBs table for maintaining the original document name with a DCB document when set into the site.
Added new DCBs document name display to the DCBs section of the Issue Detail and Cover Detail pages.
Dynamically increased timeouts when downloading a DCB document to handle increased time needed to transfer to remote clients the large documents.
Corrected encoding of document name values in the drag-n-drop interface for DCBs placement.
Corrected encoding of document name values in the auto-placement interface for DCBs.
Corrected encoding of document name value when individually adding a DCB to an Issue in the DCB area of the Issue Detail and Cover Detail pages.
Setup Apache on primary host expanded hosting capacity and storage.
Moved the DCBs host to the primary production machine for added throughoutput and storage capacity.
Set hostnames for all installations of PostgreSQL for more flexible configurations and growth options.
Added a host number to the DCBs domain.
Opened PostgreSQL to handle remote connections, limited only to internal IPs for proper security.