interactivetools.com : CMS Builder

This page lists all updates released for CMS Builder. You can get the latest release at our upgrade page.

CMS Builder (Version History)
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 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.