------------------------------------------------------------------------------- *** November 6, 2008 - Version 1.23 Released 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 ------------------------------------------------------------------------------- *** August 15, 2008 - Version 1.22 Released MINOR CHANGES & BUG FIXES - Uploads: Fixed bug where erasing an upload returned errors on some servers ------------------------------------------------------------------------------- *** August 14, 2008 - Version 1.21 Released 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 ------------------------------------------------------------------------------- *** July 14, 2008 - Version 1.20 Released 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 ------------------------------------------------------------------------------- *** July 10, 2008 - Version 1.19 Released 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 ------------------------------------------------------------------------------- *** June 26, 2008 - Version 1.18 Released 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 and data folders 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 ------------------------------------------------------------------------------- *** June 5, 2008 - Version 1.17 Released MINOR CHANGES & BUG FIXES - Code Library: Added new function: getListOptions($tablename, $fieldname) to load pulldown list options - Section Editors: Fixed bug where erasing record caused error. ------------------------------------------------------------------------------- *** June 5, 2008 - Version 1.16 Released 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 - Section Editors: You can now specify an upload field in "List Page Fields" to show the first uploaded thumbnail image 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: 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 now backslashed to avoid errors. \'like this\' - Code Generator: Removed optional XHTML tag 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 tags and code for: textfield, textbox, and wysiwyg fields - Misc Code and other minor improvements ------------------------------------------------------------------------------- *** May 6, 2008 - Version 1.15 Released 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 ------------------------------------------------------------------------------- *** April 18, 2008 - Version 1.14 Released 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 ------------------------------------------------------------------------------- *** April 16, 2008 - Version 1.13 Released 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: