Home

 
 
Overview
12 Reasons to Choose Us
90-day money back guarantee
Privacy Policy
Conditions of Use

Product Changelog

The page lists the changes made in each version of our products.

Article Manager
CMS Builder
Listings Manager (also Auto & Realty Manager)

<< Return to Upgrade page

Article Manager (Version History)
Version 2.16 

Released: October 3, 2007
- Recommended update for sites using MySQL 5

CHANGES
- Set default MySQL engine type to (faster) MyISAM engine. Previous versions used the server's default, which was usually (but not always) MyISAM.

BUG FIXES
- Added code to disable new error messages generated by MySQL 5 'strict mode'
- Fixed an obscure issue where changing category filename would generate a "file exists" error when a publish rule used only the category num

Version 2.15 

Released: July 2, 2007

MINOR UPDATE
- Added config.ini flag "allowSSIsInInput" to allow writers to enter SSIs (requested feature).
Version 2.14 

Released: June 11, 2007

CHANGES
- WYSIWYG: Updated to latest version (2.9.8) from WYSIWYG Editor Vendor
- WYSIWYG: "Paste from Word" feature improved
- Templates: Fixed various minor HTML errors, updated to be more standards compliant (both interface and published templates).
- Image Gallery: Default installation now includes "Image Gallery" field for articles.
- License: Added ability to change Product ID of installations with expired licenses.
- License: Updated license agreement REGISTRATION and TERMINATION clauses.
- Database: Current field length is now displayed on field length error messages.

BUG FIXES
- Database: Added 'submit' and 'target' to list of reserved fieldnames that aren't allowed (used by javascript)
- WYSIWYG: Fixed a content duplication bug
Version 2.13 

Released: April 17, 2007

Minor Update
- Template editor (admin function) no longer disables PHP/ASP code blocks
- Template editor no longer lists zip files in template directory

Version 2.12 

Released: March 14, 2007

Minor Update
Templates: fixed articleLists/categoryIndex.html to correctly pass the category.num to the next/previous links

Version 2.11 

Released: March 13, 2007

- convertToUnicode.cgi: fixed mysql bug that could sometimes prevent tables from being renamed properly in final step
- Templates: Updated publish templates with seperate footer file as include to make editing footer easier
- Templates: Updated publish template headers with <link rel="alternate"...> to the RSS feed
- Publishing: Fixed bug where a static index.html in publish dir would get erased when a new category was added

Version 2.10 

Released: March 7, 2007

IMPORTANT: Make sure you have Perl 5.8
IMPORTANT: Run /utils/convertDataToUnicode.cgi if you have existing non-english content or characters

NEW FEATURES
- Articles: Multi-category articles, Articles can now be added to unlimited categories
- Field Editor: Added "Field Separators" to Field Editor as separate field type
- Publishing Rules: New "External Script" rule for running other programs after publishing
- Admin Menu: Added Template Editor
- Publishing: Improved Publishing Speed
- Templates: New modifier defaultValue() added. Displays value if placeholder is undefined, blank or zero.
- New default template set (old set available in "classic.zip")
- Unicode Support: Non-english and other special characters are stored and displayed correctly. If you use non-english characters, you need to update your publish templates to support UTF-8 characters - add the following tag to your publish templates under the title tag:

<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">

MISC IMPROVEMENTS
- Publishing Rules: Added additional error checking for invalid placeholder, filename and category settings
- Publishing Rules: Other miscellaneous enhancements
- Templates: Default templates/stylesheet updated accomodate multi-cats
- Import: Checkboxes fields are now imported from v1.41 as numeric "integer" fields so they sort correctly.
- Import: Improved conversion of v1.41 next/previous links.
- Publishing: Added customPatches.pl reload delay option for servers with low "server CPU usage thresholds" - Errors: Improved error messages when a directory isn't writable
- Added new menu placeholders $category.listItemStart$ and $category.listItemEnd$ for creating menus as unordered html lists, for example:

<!-- template insert : <ul>$categoryList$</ul> -->
<!-- templatecell : categoryRow -->
$category.listItemStart$$category.name$$category.listItemEnd$
<!-- /templatecell : categoryRow -->

BUG FIXES
- General: Added workaround for bug in Microsoft IIS/5.0 that sometimes prevents cookies from being set (http://support.microsoft.com/kb/q176113/)
- Admin Menu: Fixed the "Upload Directory" browse button in Server Settings (button was controlling the Publish Directory field).
- Database Moves: Improved data migration errors, database writes now enabled after reporting an error
- Field Editor: Fixed bug where date field would display an error when no date field options were enabled
- Field Editor: Fixed beta 2 bug - IE Javascript error "Couldn't find element: undefined"
- Field Editor: Fixed bug where changing "Stored As" type would erase field contents with file databases (not mysql)
- Search: Unlinked categories now display in search engine category list as intended (check "hide from search" in category editor to hide them)
- wysiwyg: html code examples and entities now re-load correctly in the interface (eg: '&lt;')
- wysiwyg: unneeded "<br>" or "<p>" tags are now removed when a blank field is submitted.
- wysiwyg: Added workaround for "duplicating content" bug that sometimes occured in IE
- wysiwyg: Fixed Mozilla/Firefox javascript console bug 'Javascript component does not have a method named: "shouldProcess"...'
- search: All search fields now support quoted multi word phrases "like this"
- Other miscellaneous bug fixes

Version 2.02 

Released: November 3, 2006

NEW FEATURES
- Publish Rules: added "Copy Rule" button to make it easier to add new rules based on existing ones
- Publish Rules: global article lists can now be limited to specified categories only
- Publish Rules: global category menus can now be limited to specified categories only
- Publishing: Added "Cancel Publishing" link to defer publishing when making lots of edits
- Publishing: Improved file collision error messages when adding/editing Articles and Categories.
- Templates: Added new templateIf operator "isMultipleOf" and "isNotMultipleOf" to make multi column layouts easier
- Templates: Added new features "Convert SSIs to PHP includes" and "Convert PHP includes to SSIs"
- Templates: Added new placeholder modifier :fileAttribute() to access specific image attributes (backward compatability with v1.41)
- Templates: Added new article list placeholder $articleList.currentResultNumber$
- Search: Made new placeholders $keyword$ and $keywordSearchFields$ available from search.cgi (and added to searchResults.html template)
- Support: added support for running optional customPatches.pl file (allows support staff to more easily work around mis-configured or non-standard servers and make custom changes to software)
- Upload Options: Made default image alignment available to be modified with customPatches.pl
- WYSIWYG Editor: added "Paste From Word" button to default WYSIWYG toolbar

MISC.
- Publishing: Changed timeout counter to 60 seconds from 30 and added 30 second option to "Max Process Time" in Admin Menu
- General: Improved directory detection code, resolves "filepath './config.ini' must be an absolute path" error
- Search: Specifying keywordSearchFields with underscores now works. fixes: "couldn't find field 'art\_field1'" error
- Templates: Removed double slash ("//") from css, javascript, image, etc links (caused 404 on some servers)
- Templates: re-organized admin menu template files for easier editing (split some up into multiple files and renamed or moved others)
- Many general improvements and fixes to Admin, Search, and Upgrade programs

Version 2.01 

Released: October 26, 2006
Maintenance Release

New Features
- added support for UNC network filepaths and webhosts that use them (e.g. \\SERVER_NAME/path/)
- added auto login support so you can login and jump to a page with one link. eg: admin.cgi?loginUsername=USERNAME&loginPassword=PASSWORD&action=loginSubmit

Fixes
Many general bug fixes and improvements, including:
- Upgrade Script: Improved importing from Article Manager 1.41
- General: Fixed "Unable to initialize ReadForm Module! (Check settings)" error caused when uploads/incoming directory couldn't be created
- Publishing: "One-Level Category Menus" now publish as they did in version 1 (extra categories no longer showing) - Publishing: Added menu format options from version 1.
- Publishing: Resolved issue where non-admin users would get error on second page of publishing
- Publishing: Improved handling of multiple publish rules with the same placeholder name and different categories
- Default templates: Added keyword placeholder to search "next page" links to subsequent pages display search results and not every article
- Interface templates: Updated admin style-sheet to fix IE7 text alignment issue where everything was centered

Version 2.00 

Released: October 19, 2006
New Main Features:
- New Intuitive User Interface
- mySQL database support
- Image thumbnailing and resizing
- Improved Template System
- Enhanced Image/Media Management - unlimited uploads per article
- Unlimited Article and Category Fields
- Syndicate your content with RSS
- Email My Password (retrieve lost passwords easily)
- Localize date, time, and number settings
- Bulk Article and File Deletion
- My Placeholders (create your own global placeholders)
- Ability to import Article Manager 1.41 data, uploads and templates
- and much more...

Version 1.41  Released: December 5, 2005
Maintenance release
- Fix for WYSIWYG editor issues in Firefox 1.5
- Fixed a pathing issue in the interface that prevented the WYSIWYG from loading on a few rare servers
Version 1.40  Released: June 16, 2005
New cross-browser WYSIWYG editor!
- WYSIWYG now compatible with Mozilla based browsers on both PC and Macintosh OS X
- Supports: Firefox 1.0+, Mozilla 1.7+, Netscape 7.1+, Internet Explorer 5.5+ (Windows only)
- Login Account screen now unchecks all boxes when the "All Categories" box is unchecked
Version 1.38  Released: February 11, 2004
Recommended Upgrade.
Users of 1.37 should upgrade to 1.38
- fixed a defect from 1.37 where manually refreshing the browser after deleting a category could delete category/article data
Version 1.37  Released: February 4, 2004
New Feature:
- Subcategories added (see the subcategories documentation for more info)
Other Changes:
- Server side script parsing now compatible with publishing to an IP address on UNIX servers
- Default templates now include a single external style sheet for ease of updating
- New visual style for default templates (original style available with the "classic.css" style sheet)
- The htmlarea folder has been renamed to wysiwyg
Version 1.36  Released: December 8, 2003
Fixes:
- fixed server side script parsing errors on uncommon servers (including a "doubling" of linebreaks on some servers)
Version 1.35  Released: November 27, 2003
Fixes:
- improved HTTP header forwarding behavior with search.cgi and view.cgi server-side script parsing (fixes serveral search.cgi issues occuring with 1.34 on some servers)
- re-added 'version' info to setup options page (removed in 1.34)
Version 1.34  Released: November 24, 2003
Private Label Version
- software can now be fully rebranded
- no hardcoded references to the program name - modifying the Titlebar text in Setup Options will update all occurences
- modifying vendor profile will display sublicense agreement (with vendor) instead of license agreement (with interactivetools.com) when installing
- "upgrade available" removed from Setup menu
- updated the Software License Agreement
Fixes:
- fixed an issue with server-side script parsing and subdomains
Version 1.33 
Released: October 9, 2003
- New setup option to provide basic authentication when using Server Side Parsing with password protected "publish/" directories
- Added a config.ini flag (bcc_to set the email separator for notification. This is to resolve incompatibilities between some mail programs and certain delimiters (semicolon sometimes rejected).
Version 1.32 
Released: September 23, 2003
New Features
- added rendering of SSI and server side script (PHP, ASP, etc.) in pages generated dynamically by search.cgi and view.cgi
- search.cgi can now search multiple categories (i.e. cat=1,3,4)
- new $publishdir_virtualpath$ placeholder, deprecating $virtual_*$ placeholders
- new $publishdir_filepath$ placeholder
Templates
- added the "Maple PHP" template set (default publish templates using PHP includes)
Fixes
- re-enabled $url_publish$ in several templates (disabled in 1.30)
Version 1.31 
Released: July 10, 2003
- Fixed an issue where image height and width were lost when moving an article from a category with a custom upload directory to another category.
Version 1.30 
Released: June 18, 2003
New features:
- added ability to specify category upload and publish directories
- added new "$virtual_" placeholders (required for category specified directories)
- added config.ini setting to allow duplicate article filenames
Enhancements:
- new filelocking protocols now compatible with Sun Solaris
- improved detection of conflicting filenames
- added thumbnail preview to Category Edit page
Version 1.29 
Released: April 30, 2003
- Writers submitting articles will now trigger email notification events
Version 1.28 
Released: April 23, 2003
- Recommended upgrade.
- improved file system error checking when rewriting database files. This will prevent you from losing data if your hard drive is full.
- added email notifications
- fixed issue where erasing a category wouldn't delete category-specific pages from website
- improved filelock handling
- filelock timeouts can be configurable via config.ini
Version 1.27  Released: February 27, 2003
- resolved a WYSIWYG editor issue where content entered in non-IE 5.5+ browsers with auto-format checked would display in IE 5.5+ WYSIWYG as a single line.
- resolved an incompatibility issue with some servers running Perl 5.004
Version 1.26  Released: February 18, 2003
- XSS filter now permit relative URLs
Version 1.25  Released: February 13, 2003
- resolved issue where extra <br> tags were being added to WYSIWYG textareas
- resolved issue where writers received missing template cell message on login
Version 1.24  Released: February 12, 2003
- search.cgi can search the specified fields listed in the "fields" query parameter
- the category list in category editor is displayed properly after a sort or re-order
- default image caption font reduced for webfeeds
- invalid article dates (eg Feb 31) now replaced by last day of month
- spare field content is now HTML encoded
- pulldown art fields now support HTML
- $cat_image$ will now display in dynamic (search.cgi) content
- spare fields now support image placeholders in search.cgi
- category index now republished for all categories (hidden or not)
- modified Arctic Template set to display correct headlines on the Advanced Search page
- templatecell for img_caption and img_nocaption added to all 3 template sets
- added XSS filtering - configurable through xssfilter.ini
- auto format checkbox now displays in browsers other than IE 5.5+ when WYSIWYG editor chosen for summary, content or spare textarea art_fields.
- WYSIWYG editor upgraded to version 2.03
- archive list will now display 11+ archives when you have over 10 archives
- art_field checkbox type will now display if incorrect dropdown syntax is entered
- added umask setting option to the config.ini file
Version 1.23  Released: September 23, 2002
- article's time is formatted according to time_format option from config.ini
Version 1.22  Released: September 17, 2002
- archiving will not publish printer redirect pages if Printer Pages are turned off
- webfeed generator will not show hidden categories
- option to turn off publishing of hidden category's index and syndicated content
- individual article filenames can contain dashes
Version 1.21  Released: August 23, 2002
- wysiwyg editor has been updated to be much faster
- fixed "sort by title" bug under setup options
- $url_index$ is now defined by the search engine
- fixed problem causing blank articles without date to sometimes be created
- updated upgrade routine to remove any articles without date and title
- search engine, new placeholder $url_search_category$ available
- search engine, new placeholders, $in_xxxxx$ added for all form keys/values
Version 1.20  Released: August 16, 2002
- New WYSIWYG editor! (requires IE5.5+ on Windows)
- User may now specify article filenames
- spare fields increased to 20
- new spare field types: text field, textarea, WYSIWYG, pulldown, checkbox
- image placeholders now parsed in spare fields
- Summary and Content fields may now be disabled, or changed into WYSIWYG fields
- uploaded image max now increased to 25
- archiving can now be done by date range AND category name
- admin program templates can now be modified
- global article sorting order can be modified by user
- renamed "Entire Site" to "All Categories" on search templates
- INI setting now available to hide "Upgrade Available" section in Setup Options
Version 1.11  Released: July 30, 2002
- New Archiving Feature!
- Rebranding functionality!
- Added ability to disable meta generator tags in published pages
- Allow editing of interface full titlebar text and footerbar text
- Login images now customizable by editing or replacing the login images in the image directory
- Image captions can now safely include HTML tags
- XHTML <br /> tags are now generated for summary and content fields
- Javascript Encoding "_je" placeholder suffix now works on all pages
- Browsing directories on a Mac OS/X server now works correctly
Version 1.09  Released: May 16, 2002
- Added error checking for "disk quota exceeded". Program will not attempt to update its data files and will display an error when insufficient disk space is available.
Version 1.08  Released: April 26, 2002
- Fixed logoff problem where users who just logged off were sometimes unable to immediately log back in.
Version 1.07  Released: April 23, 2002
- Fixed a bug that, when creating an article and clicking the "Preview" button, sometimes caused documents to publish.
Version 1.06  Released: April 16, 2002
- Added additional filtering to prevent malicious HTML and cross site scripting.
Version 1.05  Released: November 30, 2001
- now includes Webfeed Generator so site owners can display syndicated content
- fixed output dates for $global_updated$ and $cat_updated$ placeholders
Version 1.04  Released: October 23, 2001
- beginning and ending year can now be overridden in INI settings (max 1980 - 2032)
- fixed autoformatting problem in the search engine results
Version 1.03  Released: September 4, 2001
- fixed grammar error in /templates/readme.txt ("are modification" changed to "or modification")
- fixed rare javascript error on login page (caused when attempting to login directly with URL)
- added text files to empty dirs to make sure they get created when unzipping
- removed an extra slash displayed in filepaths by some error messages
- fixed search engine which wasn't displaying some spare field placeholders
- fixed error routine to no longer display ' chars as \'
Version 1.02  Released: August 29, 2001
- all templates: added "internet link" link below summary instead of having title link
- all templates: added "uploaded file" link below summary instead of having title link
- all templates: updated headlines to link to index summary with anchor links
- maple templates: fixed a Mac IE4/IE5 spacing problem
- arctic templates: fixed a netscape bgimage repeating issue
Version 1.01  Released: August 29, 2001 (internal only, not released)
- removed error message displayed on bottom of preview page
- changed search.cgi to use #!/usr/bin/perl as the default perl path (for Unix)
- removed unneeded image data from interface.dat (reduced filesize by 200k)
Version 1.00  Released: August 24, 2001

<< Return to Upgrade page



CMS Builder (Version History)
Version 2.05  Released: July 6, 2010 (View Menus)

NEW FEATURES
- Added new "View" menu option to record lists (enabled under Admin > Section Editors)
- Added new "View" menu option to Related Records lists (enabled in Field Editor)
- Field Editor: List fields may now have a Default Value
- Category Sections: Added new setting: Section Editor > Advanced > Max level of depth for categories

MINOR CHANGES
- Plugin System: Added new filter edit_buttonsRight to add or modify buttons on edit page
- Plugin System: Added new filter view_buttonsRight to add or modify buttons on view page
- Plugin System: Added new filters: home_title, home_content for post-login homepage
- Plugin System: Added new filters: listHeader_thAttributes, viewer_output_rows
- Plugins: Added Norwegian characters to "Remove Viewer Link Accents" plugin
- Viewers: Added _hasSiblings to getCategories() viewer function output
- Code: Upgraded tinyMCE to version 3.3.7 (Released 2010-06-10)
- Code: Added internal function saveUploadFromFilepath() for importing local files
- Code: Improved DOCUMENT_ROOT auto-detection code
- Code: Wysiwyg now automatically generates new cache file when tiny_mce.js changes

BUG FIXES
- Compatibility: Added workaround for hosts with safe-mode set incorrectly (PHP Bug #23663)
- Wysiwyg Spellchecker: Fixed error "Please specify: spellchecker_rpc_url"
- Editors: Pressing Save after a login session has timed out now redirects to the login page
- Misc Code and other minor improvements

Version 2.04  Released: April 27, 2010 (Viewer Pseudo-fields)

NEW FEATURES
- Editor Search: You can now add custom search fields based on record owner with: Owner|createdBy.fullname
- Viewers: Added new option 'loadPseudoFields' for adding fields below (defaults to on).
- Viewers: Added pseudo-field *:unixtime for date fields with unix time of date (for passing to date()). Example: $record['startdate:unixtime']
- Viewers: Added pseudo-field *:text for checkboxes that displays checked or unchecked text. Example: $record['hidden:text']
- Viewers: Added pseudo-field *:label for single-value list fields that displays the label of the selected option. Example: $record['category:label']
- Viewers: Added pseudo-field *:values for multi-value list fields with an array of values for the selected options. Example: $record['categories:values']
- Viewers: Added pseudo-field *:labels for multi-value list fields with an array of labels for the selected options. Example: $record['categories:labels']
- Wysiwyg: You can now insert any of the thumbnail sizes, not just the first one.

MINOR CHANGES
- Code Generator: Viewers now automatically locate CMS libraries, even if you've moved servers or filepaths have changed
- Code Generator: New "Expert mode" under: Admin > General for hiding instructions and extra html in output
- Viewers: Added _isFirstChild and _isLastChild to getCategories() viewer function output (named after similar CSS2 selectors)
- Viewers: _match searches on multi-value list fields now match single values as well (if field was converted from single to multi-value)
- Admin > General: Timezones are now sorted by GMT offset and no longer include legacy timezone names from:
- Admin > Regional: Language settings can be hidden with hideLanguageSettings in settings file (for regional distributors)
- Plugin System: All record save plugin hooks are now passed $oldRecord when updating an existing record
- Plugin System: 'section_init' is now passed the current $action
- Plugin System: 'record_postsave' is now passed record_num
- Plugin System: Added new hook for: upload_saved, upload_adopted
- Plugin System: Added new filter uploadModify_infoFieldHTML to modify how the upload info fields look
- Code: Added helper functions for external upload forms: removeUpload(), getUploadInfoArrays()
- Code: Added /3rdParty/ to the PHP include path so Zend library will work (for possible future use)
- Code: Upgraded tinyMCE to version 3.3.2 (Released 2010-03-25) and removed safari plugin (now built-in)
- Code: Upgraded to jQuery 1.4.1
- Code: Included JSON Javascript library

BUG FIXES
- Editor List: List field labels are now displayed for list values of zero
- Password Reminder Emails: Added extra line breaks where PHP was removing them and causing text to run together
- Categories: Made it impossible to select invalid parent categories (by setting option to be disabled)
- Categories: When creating new category menus 'name' is now a system field since it's required for categories
- Categories: Made it possible to explicitly set selectedCategoryNum to 0 (avoiding issues with getLastNumberInUrl())
- Validation: Fixed some XHTML validation issues
- sendMessage() no longer UTF-8 encodes 'Content-Type' headers (valid, but triggered some anti-spam systems)
- Compatibility: Added work-around for htscanner php extension bug #10623 that caused extra backslashes to be added to content
- Compatibility: We now blank out session.cookie_domain on load to work-around servers that have it set incorrectly in php.ini
- Editors: "Create" button now uses url to link to add form so you can easily reload while developing without "repost form data?" message
- Editors: Created and updated dates are now shown on add and edit pages even if createdByUserNum or updatedByUserNum fields aren't defined
- Editors: Field values are now html encoded when displayed on list page (So <b> appears as <b> and isn't interpreted as HTML)
- Code: emailValidate() function now allows usernames with + chars such as example+example@gmail.com
- Code: inCLI() improved PHP command-line detection code
- Misc Code and other minor improvements

Version 2.03  Released: March 1, 2010 (Related Records)

NEW FEATURES
- New field "Related Records" lists records from related tables on edit page
- Custom JS: You can now define your own upgrade-safe Javascript by creating a file named: cmsAdmin/custom.js

MINOR CHANGES
- Plugin System: Added filters for: upload_saveAsFilename - Plugin System: Added filters for: listRow_trStyle, listRow_tdAttributes, listRow_displayValue, listRow_actionLinks
- Plugin System: Plugins are now sorted alphabetically under: Admin > Plugins
- Field Editor: Added "Field Prefix" option that is displayed before or above most field types.
- Field Editor: Added "Description" option this is displayed after or below most field types.
- Docs: Added readme documents to program root folder: custom.css.readme and custom.js.readme
- Viewers: whereRecordNumberInUrl() now ignore campaign tracking utm_* values when determining record number
- Categories: Added _hasParent and _hasChild to getCategories() viewer function output
- Languages: Added french language file for wysiwyg
- Install: Added php.ini to correct common server misconfigurations

BUG FIXES
- Fixed code that auto-detects DOCUMENT_ROOT on install or upgrade for Microsoft-IIS Servers
- Fixed error on Microsoft-IIS Servers: "Undefined index: SCRIPT_FILENAME"
- Fixed error on Windows Servers: "PHP Warning: shell_exec(): Unable to execute"
- Fixed error on some PHP installs: "PHP Warning: shell_exec() has been disabled"
- Fixed error on Windows Servers where "Please set 'Website Root Directory'" always showed if root dir wasn't readable
- Fixed error when using viewers from command-line or cronjobs "Notice: Undefined index: SCRIPT_NAME"
- Fixed error on PHP 5.0.0 to 5.1.2 "Warning: http_build_query() expects at most 2 parameters, 3 given"
- Fixed error on PHP 5.3.0 where trailing $ in schema ini files caused errors: http://bugs.php.net/bug.php?id=48660
- Compatibility: Added work-around in .htaccess for htscanner php extension bugs: #16891, #16130
- Fixed wysiwyg error where spellcheck suggestions would get double utf8 encoded and not display correctly
- Errors: Added error message for when mbstring extension isn't installed
- Misc Code and other minor improvements

Version 2.02  Released: January 26, 2010 (Multi-File Uploads & Viewer Enhancements)

NEW FEATURES
- Uploads: You can now upload multiple files at once with uploadify flash upload component
- Viewers: Sort ordering can now be defined in viewer urls with orderBy=fieldname or fieldname DESC
- Viewers: min/max date searches now support date without time formatted as: YYYY-MM-DD
- Custom CSS: You can now define your own upgrade-safe CSS by creating a file named: cmsAdmin/custom.css

MINOR CHANGES
- Settings: Custom settings files can be created for dev domains, such as: /data/settings.localhost.php
- Viewers: Added the following options to getRecords() for advanced MySQL users: 'groupBy' and 'having'
- Viewers: Added utility function mysql_escapef(), example: mysql_escapef("num = ? AND name = ?", $num, $name);
- Viewers: getPrevAndNextRecords() rewritten and optimized for large record sets (10k+)
- Viewers: getPrevAndNextRecords() now supports 'orderBy' option
- Editors: Record lists can now display up to 1000 records per page
- Plugin System: Added filters for: list_where (for record list page in cms)
- Languages: Updated Hebrew language translation file
- Admin > General: "Server Resource Limits" is now displayed on the bottom of the page (Unavailable on Windows servers)
- Admin > General: Added option "Disable Flash Uploader" under: Admin > General Settings > Advanced Settings
- Interface: Add meta tag so Chrome Frame will be used if installed in browser (Fixes IE rendering issues)

BUG FIXES
- Viewers: Fixed an issue with searching for a keyword containing multi-byte characters
- Viewers: Prev/Next page links now support multi-value fields, like this: ?colors[]=red&colors[]=blue
- Demo Mode: Fixed "invalid characters" in tablename error in Admin > Section Editors > Modify
- Demo Mode: Added build info (version, execute time, etc) to html source of "Creating demo (please wait a moment)" page
- Demo Mode: Added "Creating demo" text to language files so it can be translated
- Compatibility: Fixed disabled sockets error "getPage: Error opening socket: Operation timed out (60)"
- Compatibility: Fixed some problems with running the program on https:// urls
- WYSIWYG: Wysiwyg compressor no longer compresses output if server compression is already enabled - caused wysiwyg to not work
- Misc Code and other minor improvements

Version 2.01  Released: December 14, 2009 (Date Field Enhancements)

NEW FEATURES
- Date Fields: Default date field values can now be: blank, current date, specified date, or values such as "+2 weeks" or "next Thursday"
- Date Fields: Short month names used in date pulldowns can now be updated in the language files in /lib/languages/
- Viewer Functions: Added advanced option 'addSelectExpr' for generating pseudo-fields or calculated values

MINOR CHANGES
- Install: Admin Email is automatically saved as the program "Admin Email" under general settings so you don't have to enter it twice
- Compatibility: Updated code to prevent conflicts with WordPress and to allow side by side installations (for advanced users)
- Admin Field: Added new required field for "Website Root Directory"
- Standards: All pages now validate as standard xhtml.

BUG FIXES
- Compatibility: Added workaround for issue where a trailing separator in php.ini's include_path caused header/footer includes not to load
- Error Checking: Tablenames starting with a number can no longer be created (caused errors in the code generator)
- WYSIWYG: Fixed javascript errors caused when using advimage tinymce plugin
- Misc Code and other minor improvements

Version 2.00  Released: December 4, 2009 (New User Interface)

NEW FEATURES
- User Interface: we've completely redesigned and updated the user interface

MINOR CHANGES
- User Interface: interface color can now be changed under: Admin > General > Color / Theme (Blue, Green or Red)
- Editors: Users with "Editor" access can now change owners of a record (also called "Created By" user)
- Editors: Text field descriptions can now contain PHP code
- Editor: Added Advanced Command: "Admin: Code Generator" to jump to Code Generator
- Password Reminder: Added support for non-English characters in the subject line
- Plugin System: Plugins can now be organized in subdirectories under the /plugins/ directory
- Field Editor: Header separators now show the header message instead of "--- separator ---" in the field list
- Errors: The database down error page now sends a 503 "Service Temporarily Unavailable" so search engines will retry later
- Menu bar: Menu links under active menu group can be styled with: #sidebar #main-nav li.current ul li { background-color: #333 !important; }

BUG FIXES
- Field Editor: Made 'page' a reserved fieldname (rename existing 'page' fields if needed)
- Field Editor: Fixed Input Validation: Allow/Disallow characters
- Admin: Disk Space now displays "Unavailable" instead of "Value too large for defined data type" error on unsupported servers
- Database Settings: Increased mysql connect timeout from 3 to 6 seconds to support sometimes slow database servers

Version 1.36  Released: September 25, 2009 (Bug Fix Release)

BUG FIXES
- Windows PHP: Fixed rename error that occured when saving settings on older PHP versions (less than 5.2.9)
- Editors: Fixed another error "Warning: preg_match(): Unknown modifier" when allowed/disallowed charset contains /

- Misc Code and other minor improvements

Version 1.35  Released: September 23, 2009 (Plugin Enhancements)

MINOR CHANGES
- Plugin System: Added hooks for: init_complete, viewer_postinit, section_unknownAction

BUG FIXES
- Editors: Multi-value list fields now show as labels on list page
- Editors: Fixed error "Warning: preg_match(): Unknown modifier" when allowed/disallowed charset contains /
- Editor Add Record: Fixed bug where "default content" wasn't showing for textboxes or wysiwyg fields

- Misc Code and other minor improvements

Version 1.34  Released: September 16, 2009 (Backup & Restore)

NEW FEATURES
- Backup & Restore are now available under: Admin > General Settings > Database Settings
- WYSIWYG: Added Spellchecker button to wysiwyg editor (experimental)
- Debugging: Added showme() function for displaying readable variable contents.
  Example: <?php showme( $records ); ?>

MINOR CHANGES
- WYSIWYG: Upgraded tinyMCE to version 3.2.6 (Released 2009-08-19)
- Admin Menu: Added option "Always Show Expanded Menu" under: Admin > General Settings > Advanced Settings
- Admin Menu: The maximum number of connections MySQL allows is now displayed under: General Settings > Server Info
- Special Fields: Creating 'showExpandedMenu' field in user accounts allows you to specify menu setting on a per user basis
- Viewers: Added pseudo-field *:text for checkboxes that displays checked or unchecked text. Example: $record['hidden:text']
- Admin Menu: Mysql settings can no longer be updated through Admin menu (edit them in cmsAdmin/data/settings.dat.php)
- Filepaths: Moved all 3rd party components to /3rdParty/ folder (tinymce, jquery, jquery plugins)
- Filepaths: Moved /lib/plugins/ to /plugins/
- Filepaths: Other directory and path changes
- Section Editors: Added new option "Required Plugins" to Advanced tab of "Section Editors"
- Default Data Support: Files named data/schema/sectionName.defaultSqlData.php are imported when new sections are created.
- Plugin System: Added actions for: admin_prelogin, plugin_actions
- Settings: Host specific database settings can be set in settings.dat.php as [mysql:hostname] (for staging/development environments)

BUG FIXES
- Section Editors: Fixed error "Undefined index: _indent" when saving Menu Groups
- Date Fields: Single digit hour-24, minute, and second options are now zero padded.
- Date Fields: 12pm dates in the editor are now re-displayed as 12pm instead of 12am.
- Misc Code and other minor improvements

Version 1.33  Released: August 24, 2009 (Menu Enhancements)

NEW FEATURES
- Menu Groups allow grouping, hiding and showing of related menu items
- Menu Text Links allow you to add external links to the menu bar
- Menus can now be indented if desired: Admin > Section Editors > Section Name > Indent

MINOR CHANGES
- Admin: Removed admin 'home' page as it's no longer needed with new menu layout
- Admin: Regional Settings have now been moved to Admin > General
- Editors: Created and Updated dates now display in format from: Admin > General > Date Field Format
- Editors: Added "Disable Modify" option under section editors to prevent users from modifying records
- Accounts: Added "change" link to edit page so "Created By" user can now be changed by admins
- Plugin System: Added actions for: admin_preadd, admin_preedit, record_save_posterrorchecking, section_init, admin_postlogin
- Plugin System: Added filters for: record_saved_message

BUG FIXES
- Fixed error on *.previewdns.com hosts: "ob_start(): Cannot use output buffering ..."
- Forgot your Password: Fixed IE8 javascript error on form 'document.getElementById(...)' is null or...
- Misc Code and other minor improvements

Version 1.32  Released: August 4, 2009 (My Account Menu)

NEW FEATURES
- Users can now modify their own account details (username, password, email, etc) with new "My Account" menu
- Field Editor: New advanced option for Accounts section 'My Account - Show this field in "My Account" section'

MINOR CHANGES
- Admin > General: "Free Disk Space" is now displayed on the bottom of the page
- Plugin System: Added hooks for: admin_preerase, admin_posterase
- Viewers: New option 'includeDisabledAccounts' shows records otherwise hidden with: Section Editors > Advanced > Disabled Accounts
- Editors: Administrators can now access all menus by url, even if they haven't been given access under "User Accounts"

BUG FIXES
- Code Generator: Fixed some 'undefined index' errors that appeared when no options were selected
- Compatibility: Fixed error with new PHP 5.3 release "Function split() is deprecated" on field drag sort.
- Editor Search: Searching now resets page number to 1 (instead of staying on last page number)
- Viewers: Added extra spaces so multiple leftJoin's didn't cause mySQL error.
- Fixed issue where user would get incorrectly forwarded to https urls on some servers
- Misc Code and other minor improvements

Version 1.31  Released: July 6, 2009 (Bug Fix Release)

MINOR CHANGES
- Viewers: New option 'requireSearchSuffix' allows you to ignore fieldname=value searches without _match suffix

BUG FIXES
- Editors: Fixed "Erase" and "Erase Selected" actions so they now work again.
- Editors: Fixed php 'undefined variable' errors
Version 1.30  Released: July 3, 2009 (Advanced Editor Search Filters)

NEW FEATURES
- Added advanced editor search and filter options (See: Admin > Section Editors > Searching)

MINOR CHANGES
- PHP sessions are now used instead of cookies to store admin search preferences and login credentials
- Viewers: New option 'ignoreHidden' allows you to display hidden records
- Viewers: New option 'ignorePublishDate' allows you to display records before their publish date
- Viewers: New option 'ignoreRemoveDate' allows you to display records after their remove date
- Viewers: Function getNumberFromEndOfUrl() now lets you specify a default num if no number found in url
- Category Viewer: Added new option 'defaultCategory' (enter 'first', category number, or blank '' for none)
- Category Viewer: Added new option 'rootCategoryNum' to show only part of the category tree (defaults to showing all)
- Category Viewer: Added new option 'ulAttributes' for adding attributes to generated ul tags
- Category Viewer: Added new category format 'breadcrumb' for displaying select menu path in breadcrumb format
- Category Viewer: Added new pseudofield _isBreadcrumb to make it easier to display breadcrumb menu for selected category

BUG FIXES
- Password reminder emails are not sent with UTF8 charset so international characters display properly
- Viewers: getListValues() and getListLabels() didn't work if the list field wasn't a multi-value field
- Viewers: getPrevAndNextRecords() fixed error message: "Undefined variable: errors"
- Viewers: getCategories() fixed error message: "Undefined offset: 0" when no category selected
- Editor List: After drag sorting any previously selected sorting columns are reset so new order shows as expected.
- User Accounts: Hidden menu sections are now visible in section access list
Version 1.29  Released: June 16, 2009 (Demo Mode Support)

NEW FEATURES
- Demo Mode: program can now be run in demo mode where data is copied and resets every hour

MINOR CHANGES
- WYSIWYG: Upgraded tinyMCE to version 3.2.4.1 (Released 2009-05-25)
- WYSIWYG: Word content is now automatically detected and cleaned up without need for the paste dialog popup window.
- Editors: List Fields now show previously entered database values even when they are no longer in list options
- Editors: Added "Date Field Format" to Admin > Regional Settings to allow displaying date fields as "Day Month Year"
- Viewers: Added 'pageNum' option to viewers to allow you to specify exact page number to display
- Multi Table Search: Added 10 fields that can be passed from each table searched by searchMultipleTables() as field1, field2, etc

BUG FIXES
- WYSIWYG: Wysiwyg compressor now automatically disables old php feature 'magic_quotes_runtime' - caused wysiwyg to not work
- Categories: Fixed bug with _isAncestorSelected that caused it to be incorrectly set sometimes
- Usability: Added workaround for *.previewdns.com urls to prevent them from injecting Javascript that breaks interface code
- Usability: Made rename error more clear for windows servers with incorrect file permissions.
- User Accounts: Fixed MySQL Error when non-admin users would add new user accounts: "Column 'isAdmin' cannot be null"
- Compatibility: Fixed error "urlencode() expects parameter 1 to be string" caused by some 3rd party php code and scripts
- Compatibility: Updated internal program redirects to support and maintain https:// urls
- Compatibility: CSS file improvements (replaced more hard coded colors with CSS classes)
- Compatibility: Fixed disabled sockets error "getpage: Error opening socket: Operation not permitted (1)"
Version 1.28  Released: April 8, 2009 (Plugin System Enhancements)

NEW FEATURES
- Plugin System: Updated system to emulate WordPress plugin system
- Plugin System: Added hooks for: admin_head, admin_footer, record_presave, record_save_errorchecking, record_postsave
- Plugin System: Added filters for: header_links, execute_seconds, viewer_link_field_content
- New Plugin: Example Header links - shows how to add custom links to header of CMS without modifying code
- New Plugin: Footer License Link - shows how to add custom links or html to CMS footer
- New Plugin: Remove Accents From Viewer Links - shows how to dynamically rewrite viewer links
MINOR CHANGES
- WYSIWYG: Upgraded tinyMCE to version 3.2.2.3 (Released 2009-03-26)
- Editors: Min length and max length for WYSIWYG editor fields will only count characters (not the HTML)
- Editors: Added CSS classes for menuAccounts and menuAdmin for users that want to style those menu items differently
- Languages: Added some new language strings (check your language file in /lib/languages/)
- Categories: Changed _isSelectedBranch in getCategories() output to apply to all records in branch, not just ancestor records
- Categories: Added _isAncestorSelected and _isDescendantSelected to getCategories() viewer function output
- Viewer SEO: Paging variables firstPageLink, prevPageLink and lastPageLink no longer use different url for page 1 (eg: viewer.php instead of viewer.php?page=1) to prevent duplicate content urls
- Admin Settings: Added field for Header Image URL to display image in program header
- Admin Settings: Added field for Footer HTML to display extra text or html in program footer
- Compatibility: Added flag to .htaccess to disable (the old deprecated php feature) register_globals for old php installations
- Compatibility: Url encoded & as & in urls generated by viewer functions for HTML standards compliance
- Usability: You can now link to the license agreement (even if not logged in) with the url: admin.php?menu=license
- Misc Code and other minor improvements
BUG FIXES
- Re-creating thumbnails no loger gives an "Undefined variable: tableNameWithoutPrefix" error
- Added workaround for server bug with Microsoft-IIS/5.0 where users couldn't logoff: http://support.microsoft.com/kb/q176113/
- Fixed wysiwyg upload bug that would display the "add record" page if the section was set to only allow one record
Version 1.27  Released: February 24, 2009

NEW FEATURES
- WYSIWYG: Upgraded tinyMCE to version 3.2.1.1 (Released 2008-11-27)

MINOR CHANGES
- Categories: Added _isSelectedBranch field to getCategories() viewer function output
- Editors: Blank values are now saved as "NULL" for numeric MySQL column types
- Templates: Moved default Realty templates and schemas to Realty focused product
- Code Generator: Content-type header is now included in generated code (for servers that override meta charset tags)
- Code Generator: Added "Record Not Found!" error message to detail page for when a record isn't found.
- Editor Menus: Created/Updated fields now display account 'username' instead of account 'fullname'
- Editor Menus: Created/Updated fields now display even if dates were zero'd out in database (caused after adding field or upgrading)
- User Accounts: Program required fields are now set as "System Fields" to avoid accidental modification
- User Accounts: Renamed user roles Writer and Manager to Author and Editor
- Misc Code and other minor improvements
BUG FIXES
- Code Generator now escapes UNC paths properly in generated code (example: \\SERVER/path/viewer_functions.php)
- Editors: MySQL errors when saving records (due to incorrect column type) no longer create blank records

Version 1.26  Released: February 2, 2009

MINOR CHANGES & BUG FIXES
- Fixed issue where Cyrillic character sets such as Russian weren't saving correctly
- Fixed upgrade error: MySQL Error: Table 'database.cms__accounts' doesn't exist

Version 1.25  Released: January 30, 2009

NEW FEATURES
- Field Editor: Added new advanced option "MySQL Column Type" for advanced users
- Languages: Added Hebrew (he) language files

BUG FIXES
- Fixed incorrect error "Temp Upload dir '' does't exist!" for servers with default (blank) php upload dir
- Fixed issue where old /lib/menus/accounts/* files would prevent accounts from showing after upgrade
- Fixed error on installs without cms_ table prefix: MySQL Error: Table 'database.cms_accounts' doesn't exist
- Fixed error checking to check for PHP 4.3.2 (raised from PHP 4.3.0 in v1.23)

Version 1.24  Released: January 20, 2009

NEW REQUIREMENTS
- PHP 4.3.2 or newer is now required (PHP 4.3.2 was released in May 2003)
(The previous version required was PHP 4.3.0 so this version is only slightly newer)

NEW FEATURES
- Image Uploads: Transparency is now maintained when resizing GIFs and PNGs
- Section Editors: Added 'Advanced' option to hide sections from appearing on menu
- User Accounts: User accounts menu has moved out of admin area onto menu bar
- User Accounts: Users can now be given access to manage accounts without full admin access
- Section Editor: New "Advanced Filter" option added for creating dynamic list fields.
- Uploads: Added special wildcard "*" to allow any file extension (only use with trusted users)
- Editor List Page: Added Advanced Command: "Admin: Edit Section" to jump to Section Editor
- Editor Edit Page: Added Advanced Command: "Admin: Edit Section" to jump to Section Editor
- Login: After logging in you will now be redirected to the last page you tried to access
- Category Viewers: Category viewers now load uploads if there are any
- Viewer Code: Added left join capability to viewer functions

MINOR CHANGES & BUG FIXES
- Field Editor: Section Editors "Add Field" popup now scales to fit smaller screen sizes
- Field Editor: Date field now has a default year range start of 2008 and end of 2016
- Field Editor: Field edit form now has buttons on bottom as well (for ease of use)
- Upload Form: Improved upload error message when upload folder doesn't exist
- Upload Form: Uploads remaining now shows total remaining instead of total upload field count (10)
- Upload Form: Fixed error "Undefined variable: uploadsRemaining" that occurred on some servers
- Upload Lists: Upload list field will now expand to up to 600px height for easy access
- Schema Files: Set date fields to have year range start of 2008 and end of 2016 for default schema files
- Category Sections: Fixed bug where category order would sometimes get mixed up when uping up/dn sorting links
- Error Checking: Added error check for required thumbnail function imagecreatefromjpeg()
- User Accounts: Users can now be given manager access to category sections
- Record Editor: Fixed issue where wysiwyg couldn't be named 'main'. (Added "field_" prefix to wysiwyg id names)
- Record Editor: Fixed issue where some fieldnames (such as 'for') would be sorted in list view
- Browser Compatibility: Updated CSS to work in IE6
- Editor Forms: Sections with only a num and upload field no longer display error when saving
- Timezones: Fixed issue where admin could select invalid timezone names on servers without timezone lists
- Viewer Searching: _min and _max viewer field searching now supports decimal values: field_min=1.5
- Misc Code and other minor improvements

Version 1.23  Released: November 6, 2008

NEW FEATURES
- Admin Design: Change admin menu design to have left navigation menu
- CSS Stylesheet: Made huge improvements to program CSS stylesheet making it easier to re-style and change colors
- Languages: Added Portuguese translations (thanks to jamtc in the forums)
- WYSIWYG: Upgraded tinyMCE to version 3.2.0.2 (2008-10-02)
- Program Urls: Help Url and Website Url can now contain PHP code (to specify values on per user basis, for example)
- Usability: If a user is one allowed to edit one record in a section they are redirected straight to edit page (instead of list page).

MINOR CHANGES & BUG FIXES
- Compatibility: Loading viewer PHP from 3rd party scripts no longer produces "Undefined variable: SETTINGS" error
- Compatibility: Added PHP4 compatibility function for array_combine()
- Compatibility: Program cookies are now set at webroot level and use new 'cookiePrefix' setting (in settings.dat.php)
- Compatibility: Fixed disabled sockets error "getpage: Error opening socket: Invalid argument (22)"
- Compatibility: Upload file permissions are automatically changed for servers that save uploads with read permissions
- Compatibility: Added PHP workaround for issue where set_include_path() doesn't work when already set in httpd config
- Compatibility: CMS Builder now works when installed on Windows UNC network path (\\SERVER\path\to\www\)
- Compatibility: Zip no longer contain directory entries (Vista's unzip created extra files)
- Usability: Swapped width and height field order in field editor to be consistent with common standard
- Field Validation: Minimum and Maximum length restrictions no longer apply to blank fields (check "required" to require a value)
- Upgrade Docs: Added /uploads/ to the list of files and folders to upload
- Database: Dropped MySQL connection timeout to 5 seconds from PHP's default of 60 seconds (too long)
- BugFix: Category sections no longer show categories owned by other users in "Parent Category" pulldown for users with writer access
- BugFix: Recreating secondary thumbnails no longer erases primary thumbnails
- BugFix: Date fields now have proper range of 0 to 59 for seconds pulldown
- Dialogs: Dialog (popup) windows now are modal meaning they won't close unless you click cancel
- Misc Code and other minor improvements
Version 1.22  Released: Auguest 15, 2008

MINOR CHANGES & BUG FIXES
- Uploads: Fixed bug where erasing an upload returned errors on some servers
Version 1.21  Released: August 14, 2008

NEW FEATURES
- Field Editor: Added 3 new optional thumbnail fields for up to 5 images sizes per upload
- Accounts Menu: Accounts menu is now editable through section editors
- Viewers: Added search suffix "_prefix", used in url like this: viewer.php?title_prefix=a
- Viewers: Added advanced function getCategories() to display category trees or UL/LI lists
- Record Lists: Added checkboxes and "Erase Checked" option to Advanced Commands (bottom left)
- Plugins Menu: Added plugins section to Admin Menu for future use and custom plugins.

MINOR CHANGES & BUG FIXES
- Upgrade Files: Renamed accounts schema file with .default to prevent accidental overwriting during upgrades
- Uploads: Fixed bug where uploads wouldn't get removed when record was erased.
- Viewers: Fixed bug that caused multiSearch function to stop working
- Section Editors: Section name is now displayed in page heading breadcrumb
- Languages: Added more text to language translation files.
- Preset Menus: Fixed issue in "Products" preset where it allowed uploads but had no allowed file extensions
- Preset Menus: Fixed issue in "Contact Us" preset where email caused "range out of order" errors on some PHP installs
- Field Editor: "allowed characters" field now only allows dash at end of character list to prevent "range out of order" errors
- Field Editor: After "Quick Add"ing a field focus is given to the Quick Add Label Field again to speed up field entry.
- Alerts & Notices: Non-error alerts are now shown with a green border.
- Section Editors: "Quick Add" fields now support unicode characters - replaced escape() with encodeURIComponent() in javascript
- Languages: Added new language strings for French and Spanish (needs translating)
- Help Link: Help link now opens in new window
- Misc Code and other minor improvements
Version 1.20  Released: July 14, 2008

NEW FEATURES
- List Preview - Added Preview button to editor list page

MINOR CHANGES & BUG FIXES
- Section Editors: Fixed cookie issue so editors remember last keyword search, page number, and perpage value when returning to a section.
- Bugfix: Fixed disabled sockets error "getpage: Error opening socket: The operation completed successfully. (0)"
- Bugfix: Added "language" value to default settings.dat.php.default file
- Bugfix: Fixed "Couldn't find ini file" error on install
- Misc Code and other minor improvements
Version 1.19  Released: July 9, 2008

NEW FEATURES
- Multi Language - Added language packs for: french and spanish
- Multi Language - Added support for creating your own language files

MINOR CHANGES & BUG FIXES
- Viewer Search: Fixed issue where field1,field2_query searches with unrecognized fields caused error
- Field Editor: Year range fields for dates are now textfields so you can specify dates before 1971
- Field Editor: Made internal 'action' a reserved fieldname (rename existing 'action' fields if needed)
- Admin Menu: Added "Show Server Upload Limits" under Upload Fields in Admin > General Settings
- Admin Menu: Section Editors "<< Viewer Code Generator" button now passes section name to save time
- Error Checking: Helpful error now displayed when installing on windows servers without 'erase' file permissions
- Misc Code and other minor improvements
Version 1.18  Released: June 26, 2008

NEW FEATURES
- Speed: Optimized code to improve speed by up to 50% or more
- Editors: Added column sorting, click a column header to sort by it
- Editors: Added multi-value fields: multi-select and checkboxes
- Field Editor: Added option to change size and "recreate thumbnails" for uploads
- Password Reminder: Added email password reminder to login menu

MINOR CHANGES & BUG FIXES
- Viewers: Fixed error on some windows hosts "... Undefined index: QUERY_STRING ..."
- Viewers: Fixed errors 'Undefined index: createdByUserNum' for section viewers without 'createdByUserNum' field
- Viewers: Added experimental getPrevAndNextRecords() function (see forum for details)
- Viewers: Added experimental incrementCounterField() function (see forum for details)
- Editor List: List fields now show field label instead of field value (when those are different)
- Admin Program: Fixed bug where PHP 4 sometime wouldn't display program run times greater than 1 second.
- Field Editor: Numeric only field named (such as "123") no longer cause errors.
- Field Editor: Added extra error checking for invalid sorting or searching fieldnames
- Field Editor: Uploads - Added note: Resized images maintain proportions, height and width are "maximum" values.
- Field Editor: Added extra error checking for image and thumbnail max height and width fields.
- Section Editor: Added extra error checking for invalid sorting or searching fieldnames
- Section Editor: Searching for nothing ("") now resets search and shows all results
- Preset Menus: Remove default orderBy of "title" from contact and about us presets (caused error)
- Security: Password cookies are now sent as httpOnly for PHP4 and PHP5 (prevents access by javascript)
- Security: Password cookies are now stored as MD5 checksums instead of plaintext
- Security: Added index.html to admin folder to prevent viewing of directory listing
- Security: Added meta tags to prevent search engines from indexing admin pages
- Admin Menu: Added new field for "admin email" under general settings (for addons that send emails)
- WYSIWYG: Moved all wysiwyg code into /lib/wysiwyg.php to make it easier to find and edit.
- WYSIWYG: Added support for wysiwyg_custom.php file that won't get overwritten during upgrades
- WYSIWYG: Upgraded tinyMCE to version 3.0.10.1 (2008-06-18)
- WYSIWYG: Updated tinyMCE to store it's cache files in /data/ instead of /tinymce3/
- WYSIWYG: tinyMCE no longer requires that the /tinyce3/ folder be writable (caused errors on some servers)
- Upgrades: Renamed default settings file to prevent users from accidentally overwriting it when upgrading
- Misc Code and other minor improvements
Version 1.17  Released: June 5, 2008

NEW FEATURES
- Code Library: Added new function: getListOptions($tablename, $fieldname) to load pulldown list options

MINOR CHANGES & BUG FIXES
- Section Editors: Fixed bug where erasing record caused error.
Version 1.16  Released: June 5, 2008

NEW FEATURES
- Editors: Administrators can now change the creator or "owner" of records
- Viewers: Updated urls to use dashes instead of underscores for better search rankings (SEO)
- Section Editors: New "Add Menu" popup menu for creating menus
- Section Editors: Added new "Categories" menu type (beta) - category code generator coming soon
- WYSIWYG: Added language packs for: Spanish, Dutch, German and Norwegian
- WYSIWYG: The wysiwyg language can now be specified in Admin > Regional Settings
- Websites: Added /sampleTemplates/realty-simple/ with sample templates and schema for Realty website

MINOR CHANGES & BUG FIXES
- Editors: "Created By" & "Updated By" now show users full name instead of their username
- Editors: Updated dragSortOrder so it's faster when sorting 100 records at a time on list page.
- Section Editors: Fixed "congratulations" typo on sorting tab
- Section Editors: TableNames no longer allow dash character ("-").
- Section Editors: Menu Types can no longer be changed once setup (shouldn't be required)
- Section Editors: Options that are not-applicable for the current menu type are now hidden
- Section Editors: New Multi-Page menus now have drag sorting enabled by default
- Section Editors: List field options now have extra whitespace automatically removed from end (fixed Firefox issue with pulldowns not remembering values)
- Section Editors: Custom Upload Paths are now only saved to schema files if "Use custom upload directory" is checked
- Section Editors: Editors now default to last keyword search and page number during session.
- Section Editors: You can now specify an upload field in "List Page Fields" to show the first uploaded thumbnail image
- Section Editors: Added "pdf" to the list of default valid upload extensions displayed when creating a new field
- Section Editors: Updated preset editors
- Code Generator: Fixed "Notice: Undefined offset: 0" error when loading single records that don't exist
- Code Generator: Where and Order By values with single quotes are no backslashes to avoid errors \'like this\'
- Code Generator: Removed optional XHTML tag <?xml version='1.0'?> from code generator output to prevent confusion and errors
- Uploads: Images that don't need to be resized are copied instead of processed (reduces memory and maintains gif transparency)
- Install: Added .htaccess to correct common server misconfigurations
- Admin: Fixed IE7 positioning bug that caused thickbox (popup window) to not always be centered correctly
- User Accounts: Renamed user roles to reduce confusion: General is now "Writer", Admin is now "Manager"
- Viewers: Added new option 'orWhere' for adding a MySQL "OR ..." to end of where clause
- Viewers: Fixed bug where url keyword searches were ignored when a 'where' option was specified.
- Viewers: Added new option 'requireSearchMatch' to show no records when there is no search keywords submitted
- Field Editor: Default field values now accept <?php ?> tags and code for: textfield, textbox, and wysiwyg fields
- Misc Code and other minor improvements

Version 1.15  Released: May 6, 2008

NEW FEATURES
- Code Generator: New code generator form makes it easier to create different types of viewers without editing any code.
- Section Editors > Admin Tab: New option to auto-hide listings from expired, disabled, or deleted users (for subscription and pay sites)
- WYSIWYG: Word content is now automatically cleaned (IE) or popup appears on paste (non-IE browsers)
- Field Editor: Added "Checked Value" and "Unchecked Value" to fields to checkboxes

MINOR CHANGES & BUG FIXES
- WYSIWYG: Upgraded tinyMCE to version 3.0.8 (2008-04-30)
- Viewers: Added new viewer function getRecords()
- Viewers: New variables available with getRecords(): createdBy.num, createdBy.fullname, createdBy.username, createdBy.email
- Viewers: Added function thisPageUrl() to make it easy to get current page url for email links
- Editors: New variables available for "List Page Fields": createdBy.num, createdBy.fullname, createdBy.username, createdBy.email
- Editor Manager: Added tabs to organize section editor fields and better field descriptions
- Editor Manager: Added options for 'List Page Url', 'Detail Page Url', and 'Filename Fields'
- Editor Manager: Added new section setting "Max records per user"
- Field Editor: Quick adding special fieldnames keep proper case now (dragSortOrder instead of dragsortorder)
- Field Editor: Made 'length' a reserved fieldname to prevent IE javascript errors (rename existing 'length' fields if needed)
- Field Editor: Alert is now displayed when field editor can't save because of false positive errors from mod_security
- Code Generator: Removed vendor "powered by" text and link (removed from settings as well)
- Code Generator: Added "Email this page" mailto: link to default page viewers
- Errors: Added error message when uploads can't be removed because of file permissions
- Bugfix: Fixed disabled sockets error "getpage: Error opening socket: Connection refused (111)"
- Misc Code and other minor improvements
Version 1.14  Released: April 18, 2008

BUG FIXES
- Viewers: Fixed undefined index error where Page Viewers were setting _link value even if no record was found
- Home Menu: Fixed bug with optional homepage menu (enabled in /lib/menus/home.php) where it wasn't displaying
Version 1.13  Released: April 16, 2008

NEW FEATURES
- Wysiwyg: Added "Insert Media" button for inserting: QuickTime, Flash, ShockWave, RealPlayer or Windows Media Player files
- Viewers: Added multi-section search engine (see forum for examples)
- Viewers: Page Viewers now default to the first record in list (sorted by orderBy) rather than record number 1

MINOR CHANGES & BUG FIXES
- Bugfix: Fixed disabled sockets error "getpage: Error opening socket: Connection timed out (110)"
- Bugfix: Fixed issue where files uploaded through WYSIWYG couldn't be erased
- Compatibility: Memory limit is automatically increased to 64M for hosts that support changing memory limit
- Compatibility: Emulated PHP 5.1.0+ function timezone_abbreviations_list() for server that don't have it
- Compatibility: Updated code to detect correct script url on hosts running PHP in CGI mode
- Usability: PHP Viewer code now display message when incorrectly saved as .html file: "Rename this file to .php"
- Usability: Improved message that is displayed when admin.php is viewed as html or text: "Ask you host to enable PHP..."
- Usability: Improved upload error messages
- Viewers: Autogenerated links (_link) no longer have trailing slashes
- Viewers: Autogenerated links (_link) now includes full url starting with http:// (for email this page links)
- Viewers: Autogenerated links (_link) are now generated on detail page viewers as well (for email this page links)
- Viewers: Added listDetails placeholders: pageResultsStart and pageResultsEnd
- Viewers: Added orderBy option to page viewers
- Field Editor: Field names can no longer start with an underscore (_fieldnames are reserved for program use)
- Field Editor: If you 'Quick Add' a separator and enter a field label it will now create a "Header Bar" separator instead of a blank line separator
- Admin Menu: Added new section "Regional Settings" for timezone settings (and for future options)
- Home Menu: Added menu list on home page for those who want it. Set 'showHomeMenu' in /lib/menus/home.php to enable.
- Wysiwyg: <form> and other tags and attributes are no longer automatically removed from wysiwyg content
- Code Generator: Variables are now prefixed with section table name to make it easier to have multiple viewers on one page
- Code Generator: Added 'orderBy' option to generated page viewer code
Version 1.12  Released: March 21, 2008

MINOR CHANGES & BUG FIXES
- Bugfix: "Call to undefined function timezone_abbreviations_list()" error on some PHP installs
- Bugfix: Fixed error where numbers in filename would cause viewers to load wrong record on some PHP installs
- Bugfix: Changed misnamed listpage field 'date' to 'closing_date' in 'Jobs' schema preset
- Bugfix: Fixed "There was an error sending request!" error when drag sorting records on some servers.
- Bugfix: Added error message for when schema file can't be read/updated because it's already being updated
Version 1.11  Released: March 20, 2008

NEW FEATURES
- Special Fields: Added 'dragSortOrder' field which allows user to drag records to re-order them and stores order values
- Field Editor: Added "Save & Copy" button to field editor for faster entry of similar fields
- Viewers: Added automatic search suffix "_query" for google style searches. Example: +word -word "multi word phrase"
- WYSIWYG: Added "Paste From Word", "Paste As Plain Text", and "Create Anchor" buttons

MINOR CHANGES & BUG FIXES
- WYSIWYG: Upgraded tinyMCE to version 3.0.5 (Released 2008-03-12)
- WYSIWYG: relative links are now converted to absolute links from the website root (page.html > /page.html)
- WYSIWYG: fixed bug that prevents custom wysiwyg stylesheet(/css/wysiwyg.css) from loading
- WYSIWYG: Updated /css/wysiwyg.css to be compatible with tinymce 3
- Compatibility: Fixed issue where PHP couldn't find script because some servers returned SCRIPT_NAME as /cgi-bin/php441
- Compatibility: Fixed issue where PHP couldn't find script because some servers returned SCRIPT_NAME as /cgi-system/php.cgi
- Compatibility: Drag sorting uploads and fieldnames now work with hundreds of items (switched ajax queries to POST to avoid browser url length limits)
- Compatibility: Fixed E_STRICT not defined error message for PHP 4
- Compatibility: Fixed error "undefined index SCRIPT_FILENAME" for servers that don't have that value defined.
- Compatibility: Added error message for when uploads don't work because server doesn't have temp PHP upload folder configured
- Compatibility: Removed error checking for 'disable_functions' php setting - caused more errors than it fixed.
- Compatibility: Added utf-8 header to /lib/header.php for servers that send other charset headers
- Special Fields: Added popup message, hardcoded column and field type (checkbox) for special fieldname "hidden"
- Section Editor: Renamed "List Order" to "Order By" so it has the same name as viewer code and MySQL "ORDER BY" clause it represents
- Section Editors: Editor List now shows date only for date fields with "Specify Time" unchecked
- Section Editors: Fixed bug where single-page section uploads couldn't be edited by different users without admin access
- Field Editor: Made 'order' a reserved fieldname to prevent MySQL errors (rename existing 'order' fields if needed)
- User Access: Updated "Max Records" so zero ("0") means zero and not unlimited (leave blank for unlimited).
- User Access: Fixed "Max Records" so it only applies to "regular" access users, not "admin" users.
- User Access: Setting access level to "Admin" not greys out (disables) the "Max Records" field
- Presets: Removed special fields from section presets: hidden, publishDate, removeDate, neverRemove (can be re-added manually if needed)
- Docs: Fixed typo in "how to upgrade.txt". Changed "/[cmsAdmin]/data/uploads/" to "/[cmsAdmin]/uploads/"
- Section Editors: "Admin Only" fields now get "default value" from field editor when being created by non-admins
- Section Editors: Added error checking so "regular" users can't access section editors if there is no createdByUserNum field.
- Section Editors: Single-page sections now show current username instead of "Unknown" for Created/Updated By when first being created
- Viewers: Viewers now display nice error message if you try to access them before installing program (instead of numerous MySQL errors)
- Error Checking: Added extra error checking to check all file permissions are correct before installing
Version 1.10  Released: March 3, 2008

New Features
- User Access: You can now restrict users to only edit their own records and limit how many records they can create (by section)
- Special Fields: 'createdDate' stores date record was created
- Special Fields: 'createdByUserNum' stores 'num' of user who created record
- Special Fields: 'updatedDate' stores date record was last updated
- Special Fields: 'updatedByUserNum' stores 'num' of user who last updated record
- Special Fields: 'publishDate' stores start date that viewers should display record (renamed from 'autoPublishStartDate')
- Special Fields: 'removeDate' stores end date that viewer hide record after (renamed from 'autoPublishEndDate')
- Special Fields: 'neverRemove' stores option on whether removeOn date should be ignored (renamed from 'autoPublishNeverExpires')
- Settings: Added option to set image resize quality under: Admin > General > Advanced Settings
- Settings: Added wysiwyg option to use full url with domain for local links under: Admin > General > Advanced Settings
- Settings: Added timezone offset (hours, minutes) fields for PHP4 users (PHP4 has limited timezone support)
- Field Editor: Separator html code now parses <?php ?> tags and code
- Field Editor: Section Admins can now view and modify "Admin Only" fields.

MINOR CHANGES & BUG FIXES
- WYSIWYG: Upgraded tinyMCE to version 3.0.2.1 (Released 2008-02-26)
- Field Editor: When "List Field" option are loaded from another database they are now sorted with section sorting order
- Field Editor: Changed MySQL column type for checkbox fields to be "NOT NULL" so only numeric values are stored
- Field Editor: Changed MySQL column type for date fields to be "NOT NULL" so only date values are stored
- Compatibility: Coded around "Permission denied" error on servers with disabled sockets
- Compatibility: Added note to admin.php to turn on php for hosts that show .php files as text
- Compatibility: Added quotes to tablenames in code to avoid reserved MySql keyword errors
- Compatibility: Added error message for when PHP safe_mode is enabled
- Compatibility: On install - specified database name is now created if it doesn't already exist.
- Compatibility: Set default_charset to utf-8 for php output pages.
- Compatibility: Fixed issue where PHP couldn't find script because some servers returned SCRIPT_NAME as /bin/php.cgi
- Compatibility: Added code to check for servers with sockets disabled and issue warning (checks on install only)
- Compatibility: Added code to check for servers with disable_functions PHP setting and issue warning
- Section Editors: Fixed "Use of undefined constant mysql_affected_rows" error
- Web Standards: Added labels for checkboxes on install page (clicking text toggles checkbox)
- Web Standards: The code generator now includes blank alt="" tags for image tags
- Code Generator: Change default date format from incorrect "G:H:s a" to correct "g:i:s a" (can still be customized by user)
- Code Generator: Change default date format from incorrect "G:H:s a" to correct "g:i:s a" (can still be customized by user)
- Viewers: SEO urls for viewers in the root of the website are no longer created with extra leading slash ("/")
- Viewers: Fixed error where $TABLE_PREFIX wasn't available when viewer was called inside a user defined function
- Uploads: Thumbnails are now created in a subdirectory called /thumb/ to be compatible with popular gallery software
- Uploads: Fixed bug that prevented new upload dirs from automatically being created on some servers
Version 1.09  Released: January 24, 2008

MINOR CHANGES & BUG FIXES
- Uploads: Fixed bug where uploading flash SWF files returned 'Unknown image type!' when thumbnailing was enabled
- Field Editor: List fields now save default options when being quick added instead of being blank
- Field Editor: Custom upload directories now get automatically created when accessed
- Compatibility: Fixed issue where PHP couldn't find script because some servers returned SCRIPT_NAME as /shared-cgis/php
- Compatibility: Fixed "Invalid Product ID" on older PHP version (floating point error with =* operator)
- Compatibility: Reset umask to 0 for restrictive hosts that default to making created files unreadable
- Compatibility: Coded around php bug: fsockopen() "php_network_getaddresses: getaddrinfo failed: Name or service not known"
- Compatibility: display_errors and display_startup_errors now enabled by default (can be commented out in lib/init.php)
- Error Messages: Changed typo "File is writable, check permissions" to "File isn't writable, check permissions"
Version 1.08  Released: January 20, 2008

NEW FEATURES
- Viewers: Added automatic date search suffixes (_year, _month, _day). Example: viewer.php?date_year=2008&date_month=1
- Compatibility: Lowered PHP required to v4.3.0+ (over 5 years old)
- Compatibility: Lowered MySql required to v4.1.7+ (over 3 years old)
- Compatibility: Switched to 'mysql' extension (from less popular 'mysqli' extension)

MINOR CHANGES & BUG FIXES
- WYSIWYG: foreign (extended) characters are no longer saved as entities (was causing keyword search to fail)
- WYSIWYG: Re-added fullscreen edit plugin files (removed in upgrade to tinyMCE 3)
- WYSIWYG: Fixed bug where you couldn't add images when wysiwyg was in fullscreen mode
- Compatibility: Added workaround for "Call to undefined method mysqli::set_charset()" error on some servers
- Compatibility: Program and Field settings can now store double-quotes (") in ini files
- Compatibility: Added workaround for servers that don't have current directory in include_path
- Compatibility: Added automatic code to disable 'magic_quotes_gpc' for servers that have it left on
- Field Editor: added 'menu' as a reserved fieldname
Version 1.07  Released: January 11, 2008

NEW FEATURES
- Section Editors: You can now reorder uploads by dragging them.
- Section Editors: Re-added fullscreen edit button to wysiwyg (removed in upgrade to tinyMCE 3)
- Field Editor: List fields can now have different values for values and labels (entered as: value|label)
- Field Editor: List fields options can now be loaded from another table, or from an sql query (advanced)
- WYSIWYG: Upgraded tinyMCE to the latest version (Released 2008-01-08)
- Viewers: Added automatic search suffix "_keyword", used in url like this: viewer.php?myField_keyword=blue
- Viewers: Added automatic search suffix "_match", used in url like this: viewer.php?myField_match=red
- Viewers: Added automatic search suffix "" is an alias for "_match", like this: viewer.php?myField=blue
- Viewers: Added automatic search suffix "_min", used in url like this: viewer.php?myPrice_min=100
- Viewers: Added automatic search suffix "_max", used in url like this: viewer.php?myPrice_max=999
- Viewers: Page numbers are now passed as ?page=1 and "/page-1/" instead of "page1" to support searching

MINOR CHANGES & BUG FIXES
- Field Editor: fixed jQuery bug where IE6/7 would always show radio buttons as unselected. http://dev.jquery.com/ticket/1095#comment:4
- Schema Files: renamed "listOptions" to "optionsText" to support new list option features
- Viewers: Extra search arguments are now automatically passed forward in page links (such as ?city=Vancouver or /city-Vancouver/ for SEO urls)
- Viewers: You no longer have to enter the absolute url to the page viewer when useSeoUrls is on, the program figures it out.
- Errors: Added error message for when GD2 extension isn't installed
- Validation: Misc XHTML and CSS validation improvements
Version 1.06  Released: January 3, 2008

NEW FEATURES
- WYSIWYG: Wysiwyg now support image and file uploads
- WYSIWYG: Upgraded wysiwyg editor to tinyMCE v3.0b3 (from v2.1.2)
- Field Editor: Added "Field Width" option for text fields
- Field Editor: Added "Field Description" option for text fields (displayed after field)
- Field Editor: Added "Unique" option for list fields
- Field Editor: Added "Admin Only" option for all fields (only admins can view or change field)
- Section Editor: Added "Max Records" option to limit max allowed records in sections
- Section Editor: Added "Disable Add" option to prevent user from adding records to a section
- Section Editor: Added "Disable Erase" option to prevent users from removing records from a section
- Viewers: Option 'titleField' supports multiple fieldnames (first defined field is used for url keywords)

MINOR CHANGES & BUG FIXES
- FieldEditor: Renamed 'checkboxDescription' attribute to 'description'
- Viewers: Moved "Page not found" error into list viewer code so users could modify it
- Viewers: Added $listDetails[] placeholders: noRecordsFound, invalidPageNum, firstPageLink, lastPageLink
- Viewers: Changed how paging works: Invalid page numbers are displayed (page 5 of 2) and prev link goes to last valid page num
- Usability: 'View Website' link is now hidden if it's set to blank in admin.
- Code Generator: Extra code added so uploads are only displayed for valid record numbers (and no error is displayed)
- Uploads: Clicking upload after selecting 0 files refreshes upload form instead of producing an error
Version 1.05  Released: December 19, 2007

MINOR CHANGES & BUG FIXES
- Uploads: Uploads now have non-alphanumeric characters replaced with underscores on save.
- Upload Lists: Added save button to bottom of page in addition to top (reduce scrolling)
- Upload Lists: "modify" link is now only shown if there are extra upload detail fields (title, caption, etc)
- Upload Lists: Previous uploads with single quotes ("'") now be modified and removed correctly.
- Upload Lists: Doubled maximum height of upload list (to 300px when full of images)
- Section Editor: Minor usability improvements (reducing clicks, making things more intuitive, etc)
- escapeMysqlWildcards() now works correctly (escaping MySQL wildcard search chars)
- Field Editor: Erasing a field would sometimes hide additional fields until the page was reloaded.
- Code Generator: Added list of upload fields to generated upload viewer code
- Code Generator: Default viewer order is now set to "List Order" from the Section Editor so both sort the same
- Login Security: Login password cookies are now set as 'httponly', so they can't be access through javascript
- Viewers: Added new upload field 'extension' with upload extension (eg: gif, jpg, doc, etc)
- Viewers: Updated code to give better error message in (unsupported) PHP4
- Viewers: Removed some unneeded characters from Page Viewer code (\n";)
- Section Editor Presets: Fixed the FAQ preset by removing a trailing space from the listPageFields value ("questions " was causing an interface error in FAQs)
- Section Editor Presets: Minor tweaks and edits
Version 1.04  Released: December 10, 2007

NEW FEATURES
- Private Labeling: Added "Private Labeling" menu to admin to make private labeling faster and easier.
- Field Editor: Different upload fields can now have different upload directories
- Field Editor: Upload fields can each have up to 5 different info fields (eg: Title, Caption, etc)

MINOR CHANGES
- Private Labeling: Sublicensing clause in license is no longer displayed after private labeling.
- Field Editor: Advanced Options are now always hidden until you click "show"
- Field Editor: Clicking show or hide now displays or hides all option groups at once (to reduce clicks).
- Field Editor: Option groups will stay opened for all fields until you close them again (or you close your browser).
- Field Editor: Improved formatting and display of various options in IE7 ("display: table" css was unsupported in IE7)
- Compatibility: Lowered required MySQL version to v5.0.15 for web hosts with older versions (First official MySQL 5 production release)
- Compatibility: Added workaround for bug in MySQL v5.0.37 that prevents user from updating single menu records. http://bugs.mysql.com/bug.php?id=27210
- Compatibility: Removed hardcoded references to "admin.php" so web hosts requiring .php5 extension will work.
- Section Editor: Renamed "Menu Editor" to "Section Editors"
- Section Editor: Tablenames with leading underscores ("_likeThis") are no longer allowed and reserved for future use
- Section Editor: Tablenames must now be all lowercase for compatibility (some servers are case sensitive, some aren't)
- Upload Fields: Fixed an interface error with non-image file uploads that displayed a "division by zero" error message
- Misc: Program version is now updated in settings when you install an upgrade
Version 1.03  Released: December 3, 2007

BUG FIXES
- Fixed "preg_match() expects" error for servers with 'allow_url_fopen' set to false in php.ini
Version 1.02  Released: November 30, 2007

MINOR CHANGES
- Private Label: Added new key to settings file and code generator footer "vendorPoweredBy"
- Interface: Removed extra line break that appears on top of some pages in IE7
- Interface: Menu Editor List now shows message when no menus added "There are no menus. Try adding one below."
- Interface: Upload Lists now display "No Uploads..." after erasing last upload instead of just empty box
- Interface: Field Editor: table prefix is now shown in front of tablename field instead of being required to be entered.
- Interface: Field Editor height now adjusts to be 80% of window height so Save button isn't hidden on lowres monitors
- Interface: Linked logo.gif to "home", removed "home" link from navigation bar
- Error Messages: Improved message that is displayed when MySQL table exists but schema is missing
- Viewers: Added tableName to viewer errors to make it easier to track down problems with multiple viewers
- Viewers: Code Generator no longer sets titleField option to "title" unless that field exists in table
- Install: Added .htaccess file to disable unsupported PHP setting 'magic_quotes_gpc'
- Admin General: MySQL table prefix is now displayed but not editable

BUG FIXES
- Fixed error where different column name CaSe in schema and mySql would cause error.
Version 1.01  Released: November 26, 2007

CHANGES
- Viewer Code: Added function escapeMysqlString() for escaping viewer keyword searches
- Viewer Code: Added function escapeMysqlWildcards() for escaping viewer keyword searches
- WYSIWYG Field: Added "Edit HTML Source" button
- Uploads Field: Now automatically adjusts height when there are no or few uploads.
- Uploads Field: Turned off border for Internet Explorer
- Menu Pre-sets: Removed unintentionally pre-installed News and Contact Us menus (both are still available as pre-set menus)
- Menu Pre-sets: Reorganized the blog menu pre-set fields
- Moved tinyMCE (WYSIWYG editor) from /cmsAdmin/lib/ into the /cmsAdmin/ folder (the program root)

BUG FIXES
- Added/fixed maxlength setting for text fields (limits characters accepted to max length value from field editor)
- Resized images sometimes wouldn't save properly with "Error saving file!" error
- Thumbnails wouldn't get created if uploaded image wasn't automatically resized by program first
- Fixed issue where page load time (at bottom of page) sometimes showed negative value

Version 1.00  Released: November 21, 2007

CMS Builder launched.

<< Return to Upgrade page



Listings Manager (and Realty/Auto Manager) (Version History)
Version 2.52  - Released: April 21, 2004
Minor Update:
- fixed a bug in the /generic/_search_results.html template (templatecell row_image had $listing_url$ twice when linking to the listing)
- version number now displayed in Setup Options : General (removed in 2.51)
- updated all copyright notices to 1999-2004
Version 2.51  - Released: November 24, 2003
Private Label Version
- software can now be fully rebranded
- no hardcoded references to the program name - modifying the Titlebar text in Setup Options will update all occurences
- modifying vendor profile will display sublicense agreement (with vendor) instead of license agreement (with interactivetools.com) when installing
- "upgrade available" removed from Setup menu
- updated the Software License Agreement
Version 2.50 - Released October 17, 2003
Program Changes:
- incorporated both Realty Manager and Auto Manager into Listings Manager
- main executable name changed to admin.cgi
- added ability to install using .pl script file extension
Interface Changes:
- new "display only" interface templatecell for homepage/listings add/edit pages
- sort order for homepage and listings fields
- printable reference of homepage and listings placeholders
- added autoformatting to text box fields
- added Save/Cancel buttons to the top of many interface pages
User Changes:
- superusers and admininstrators can no longer accidentally lock themselves out of the program by deleting, demoting, or disabling their own accounts
- superuser and administrator accounts can't be set to expire
Version 2.30
- Released: June 13, 2003 (Released as Realty and Auto Manager)
-Recommended Update:
- improved file system error checking when rewriting database files. This will assist in preventing data loss if your hard drive is full
- improved filelock handling
- filelock timeouts can be configured via config.ini
- added heartbeat config.ini option to reduce server timeout when recreating thumbnails
Version 2.29
- Released: May 15, 2003
New features:
- thumbnails for uploaded images can be created automatically
- added htmlArea wysiwyg editor
- listings can be marked as hidden (individually or by user)
- listing index updated after a dealer/agent is removed
- added setup option to change file extensions on published files
Enhancements:
- publish-all of listings is now 2-10x faster
- _publish_homepage "$hfieldX" placeholders available in _publish_listing template
- listing_file placeholder available in publish_listing
- user's listings are republished if changes made to homepage
- search template validation works on more systems
- added "heartbeat" config.ini options to reduce server timeout when publishing listings
Rebrandability:
- removed branding from run-time source
- program interface templates now stored in separate files in templates/interface/
Version 2.28  - Released: December 4, 2002
- search can specify the name of a template file from the template/ directory for all functions
- search can view an individual listing
- when checking for new listings, search will only look at the created date if check_created field is set
- search_homepage_url placeholder is automatically set to the search_homepage addon
- image and no_images templatecells in homepage and listing templates can contain general placeholders
- Listing Editor's keyword field is cleared when a user logs off
Version 2.27  - Released: November 4, 2002
- added $listing_num$ placeholder, available on listing detail page (_publish_listing.html template)
- added support for a new type of listing/homepage field: checkboxes
Version 2.25  - Released: July 3, 2002
- Added feature to the setup options which allows users to disable the meta generator tag and timestamp from being written to the published pages.
Version 2.24  - Released: June 27, 2002
- Search optimization resulting in faster searching and less memory usage.
- Realty Manager now supports a recommended total of 2000 listings.
Version 2.22  - Released: May 16, 2002
- Added error checking for "disk quota exceeded". Program will not attempt to update its data files and will display an error when insufficient disk space is available.
- Fixed double-html encoding of the quotation mark character (") in listing fields and other instances
Version 2.21  - Released: April 5, 2002
- Fixed a bug that prevented the search engine from linking to the "next" or "previous" search results.
Version 2.20  - Released: April 3, 2002
- Added additional filtering to prevent malicious HTML and cross site scripting.
Version 2.19a  - Released: March 25, 2002
- Maintenance release
Version 2.19  - Released: March 20, 2002
- improved filelocking system
- super user can now change license key in program
Version 2.18  - Released: February 07, 2002
- "European number" support in search engine (range searching, etc)
Version 2.16  - Released: September 21, 2001
- changed all copyright notices to 1998 - 2001
- increased the number of listing fields to 75
- Minor bug fixes
Version 2.15  - Released: July 10, 2001
- Minor bug fixes
- Template Changes:
- Fixed space encoded on map link URL (didn't work in netscape)
- "View my listings" on homepage template didn't link to the right place, fixed.
- "user_match" was replaced with "user_num" on search query page to fix searching by user.
- removed hardcoded "../image" path in install and help templates
- Search Engine changes:
- numeric sorts now ignore everything but 0-9 and "." so "$" won't affect sort order
- New numeric sort called "123eu" ignores everything but 0-9 and "," for euro countries
- exact match sorts with "field_match" now work as expected
Version 2.11
through
Version 2.14 
- Maintenance releases, minor bug fixes.
Version 2.10  - Released: May 4, 2000
- Initial version of Auto Manager used the Realty Manager v2.10 "engine"
Version 2.01
through
Version 2.09 
- Maintenance releases, minor bug fixes.
Version 2.00  - Released: June 28, 1999
- 3 user access levels (regular, admin, superuser)
- regular users can login and only update their own listings
- all users can now have their own agent homepage
- improved image uploading (upload 10 images at a time)
- new interface and better layout of functions
- many more options can be configured in setup options
- listing and homepage index pages are now generated
- enhanced ability to link to external map sites
- and much much more (see website for feature list...)
Version 1.00  - Released: December 15, 1998

<< Return to Upgrade page