AppGini change log

AppGini 5.72, June 11, 2018

  • Fixed: Radio lookups: 'view parent' link not working.
  • Fixed: In-page validation for required radio button lookups/option lists.
  • Fixed: Save flag not triggered when moving field up.
  • Added hide all and toggle buttons to column toggle menu.
  • Fixed count() warning on PHP 7.2.x
  • Fixed vertical spacing of date combos.
  • Added link to YouTube channel on the toolbar.
  • Fixed datetimepicker European date formats.
  • Fixed bug in sql() function causing Notification::placeholder() not to be declared on silent errors.
  • Unified utf8 conversion functions to use to_utf8() and from_utf8()
  • Fixed utf8-related bugs in select2 drop-downs and auto-fill lookups
  • Fixed image caching issues in thumbnail.php

AppGini 5.71, May 24, 2018

  • Implementing datetime picker for datetime fields
  • Unicode-friendly copy/paste of tables and fields
  • Shortening columns cookie name to avoid 'bad request' errors,
  • Improved responsiveness of 'Edit theme' dialog to prevent freezing
  • Fixed: Record permissions are not honored in children view in some cases
  • Fixed: image upload fields don't display the image if no renaming and file name contains a hyphen.
  • Fixed image lookup DV issues
  • Set column hide/show cookies to expire after 30 days rather than on closing the browser.
  • Fixed a bug with image uploads in tables containing 2 or more image upload fields.
  • Fixed an issue with backups on servers having no MySQL password.
  • Fixed bug with show/hide columns dialog in vertical TV layout
  • Cleanup of some obsolete image files no longer used.
  • UX enhancements.
  • Allow long TLDs in email field of the activation window
  • Removed 'DB name' label from project page to avoid confusion
  • Fixing issue with initial values of auto value time fields.
  • Fixing issue with default value for time fields in 12hr mode.
  • Fixed issue with displaying empty time values in DV
  • inserting null in time fields if left empty when inserting a new record.
  • Changed the data type info icon to text, and also the lookup auto data type icon.
  • Updated the data type choice link to use the https version.
  • Added uninstaller icon (in Windows Add or Remove Programs dialog)
  • Prevent adding .alert-link to button links.
  • Fixed an activation bug validating emails with long TLDs.
  • Fixed bugs with sorting of lookup fields in child tables.
  • Fixed a bug where addslashes was incorrectly applied to cached auto-fill lookups, causing escaped quotes
  • Added html_attr_tags_ok() function and applied to cached auto fill data.
  • Added thumbnail caching to thumbnail.php (except for super admin user for administrative purposes)
  • Fixed issue with defining datalist_image_uploads_exist constant in datalist.php
  • Fixed issue with templates/tablename-ajax-cache.php where auto-fill lookups having parent images were not displayed correctly
  • Loading moment.js and bootstrap-datetimepicker in header.php
  • When saving filters, remove the FilterAnd for undefined filters from the filter URL

AppGini 5.70, Jan 23, 2018

  • Added database backup/restore page in the admin area (accessible under the Utilities menu).
  • Option to display the record count of each table in the homepage (to enable, select the table in AppGini and check the option Show record count in homepage).
  • Added 'Show/hide columns' button above table view.
  • Better handling of wide tables in mobile view by allowing users to easily scroll horizontally, one column at a time.
  • Added 'Fix all' button to 'Rebuild fields' page.
  • Added more table icons to choose from.
  • More than 60 enhancements, security and bug fixes.

AppGini 5.62, May 8, 2017

  • Implemented PHPMailer as the mail function for apps, with SMTP support configurable in admin settings.
  • Included hooks/__global.php in admin area.
  • Added new hook in __global.php, sendmail_handler() for intercepting mail sending operations.
  • Fixed PHP 7.1 compatibility issue.
  • Fixed preg_replace calls with /e modifier.
  • Added validation checks to make sure undefined data formats are properly handled.
  • Fixed XSS vulnerability in quick search responsibly reported by Netsparker.
  • Added hooks/README.html.
  • Fixed error with line breaks in emails sent from the admin area.
  • Bug fix with sorting of formatted lookup fields.
  • Bug fix for array_map warning when a record is selected in a table with a non-numeric PK.

AppGini 5.61, April 17, 2017

  • Improved detail view loading performance by preloading lookup values.
  • Bug fixed: Redirects don't work correctly if a non-standard port is used.
  • Configurable detail view template in DataList so that it can be set in hooks.
  • Fixed sorting behavior of lookup fields containing numeric data in table view.
  • Fixed a bug with anonymous users unable to directly access tables that they are allowed to view.
  • Fixed bug with error reporting behavior of unique fields.

AppGini 5.60, Dec 25, 2016

AppGini 5.51, Jun 28, 2016

  • Added support for maintenance mode (where site is accessible only to admin).
  • Better handling of unique value errors through Ajax-based validation.
  • Ensuring PHP 7 compatibility.
  • Keep "Action Button Scrolling" enabled by default for long forms.
  • Bug and security fixes plus usability enhancements.

AppGini 5.50, Dec 15, 2015

  • Added ability to organize tables into separate groups to make it easier for users to access applications with a large number of tables.
  • Added optional printing of child records in the detail view.
  • Added option to keep action buttons visible when scrolling down the detail view form.
  • Added a per-table option to enable/disable 'Add new records' from homepage.
  • Added new option for lookup fields to control the behavior of the link to parent record in detail view.
  • Added language-admin.php to make it easier to translate the admin interface.
  • Many bug fixes and usability enhancements.

AppGini 5.42, Aug 4, 2015

  • Various bug fixes.

AppGini 5.41, Jun 16, 2015

  • Ability to add records directly from the home page
  • Various improvements for RTL (right to left) languages
  • Hiding 'Sign up' link if no groups are set up to allow user registration.
  • Various bug fixes and usability enhancements.

AppGini 5.40, May 19, 2015

  • Support for displaying google maps in your application, just by providing a google map url.
  • Support for displaying youtube videos in your application, just by providing a youtube url.
  • 17 bootstrap themes to choose from, each with a large and a compact version. All 17 themes work in both left-to-right and right-to-left languages .
  • New parent records can be added easily without leaving the child record form.
  • Easier bookmarking of filtered tables.
  • Better UI in filters page.
  • Convenient highlighting of form errors before submitting.
  • Enhanced appearance of download links.
  • Enhanced application security.
  • Improved compatibility with IE.
  • A huge list of UI enhancements and bug fixes.

AppGini 5.31, Jan 12, 2015

  • This is a stabilization release where many bugs have been fixed and many UI and performance enhancements introduced.

AppGini 5.30, June 2, 2014

  • Time fields now display a time picker in the detail view.
  • Time fields now support 12hr and 24hr time formats.
  • Added "Rebuild fields" utility to the admin area to detect and easily fix database schema errors.
  • Users can now select one or more records in the table view and perform batch actions on them.
  • Added support for batch deleting of multiple records in the table view for users with delete permissions.
  • Admin user can now change the owner of multiple records easily from the table view.
  • Added batch_actions hook to create custom batch actions for records.
  • Various bug fixes and usability enhancements.

AppGini 5.23, Feb 4, 2014

  • Auto-fill lookups that have parent captions set as image fields can now display their parent images.
  • Fixed long URL wrapping in table view (See the forum post).
  • Fixed display issues with long fields in table view.
  • Fixed issues with clearing lookup drop-downs.
  • Fixed bugs with modal window in child tabs.
  • In case of setup errors while creating tables, automatic redirection to finish page is disabled and errors are displayed.
  • No zooming of empty image fields.
  • Other minor cosmetic changes.

AppGini 5.22, Nov 30, 2013

  • Fixed a bug with sorting of fields that occurred in some cases.
  • Fixed a bug with custom queries for lookup fields not working correctly.

AppGini 5.21, Nov 10, 2013

  • Added a compact (small fonts, less spaces) Bootstrap theme to the project themes.
  • Ability to specify column alignment (left, right, center) in table view.
  • Layout improvements in admin area.
  • Various bug fixes in lookup drop-downs, user permissions, and several others.

AppGini 5.20, Oct 28, 2013

  • AppGini applications are now mobile-friendly and responsive.
  • Added 13 new themes, including a dedicated RTL theme for right-to-left languages.
  • The new themes are all based on Twitter Bootstrap 3, so you can easily add more themes as thousands are available online.
  • New searchable drop-downs for lookup fields and option list fields.
  • Multiple-choice option lists are much easier to use now.
  • Major usability and UI improvements.
  • Various bug fixes.

AppGini 5.12, Aug 13, 2013

  • Removed unnecessary redirections for non-logged users.
  • Fixed a bug with characters above ASCII 128 not displaying correctly when using Unicode encoding.
  • Fixed a bug with sorting resetting filters if detail view is in the same page as table view.
  • Bug fix where lookup menus didn't display in detail view if user had insert permission but no update permission.
  • Fixed a stack overflow error when generating an application with complicated hierarchical lookup fields.
  • Fixed a bug with header redirection not working in some special cases.

AppGini 5.10, Jun 10, 2013

  • Enhanced and simplified setup page for generated applications.
  • Enhanced and simplified password reset process.
  • One-step application generation by pressing Ctrl key while clicking the "Generate" icon.
  • Added support for --generate command line option to generate AppGini applications without dealing with the GUI. This way, you can use batch files and integration tools to automate creating your application.
  • Enhanced copying/pasting of tables and fields to work across multiple instances of AppGini.
  • Applied pagination alignment to the top buttons to avoid horizontal scrolling to see those buttons on wide tables.
  • Added an option to remove "Powered by AppGini" footer (Pro version only).
  • Implemented displaying grand parent lookup values (lookups that point to caption fields that are in turn lookups now display the exact content of the parent lookups).
  • "Go to page" drop down in the table view now displays a partial list of pages for better performance with huge tables.
  • Lookups are now loaded using ajax to enhance performance for huge lookup lists.
  • Optimized the ownership assignment process (in the admin area) to take much less time when dealing with huge tables.
  • Added a link to download language files beside the encoding drop-down in AppGini.
  • Various bug fixes and usability enhancements.

AppGini 5.00, Dec 23, 2012

  • Support for parent/children views to access all children of a record from one page.
  • Easier and faster design of your database: Ability to copy and paste fields and tables within a project and between 2 projects.
  • Better application interface: Enhanced sign-in and and sign-up forms.
  • Selection of table icons from an icons gallery.
  • Choice between 2 homepage themes (classic and metro).
  • More database search power: users can now search for records owned by them or their group.
  • Control of the alignment of the pagination section below the table view (full-width, left- or right-aligned).
  • Major UI enhancements in both AppGini and the generated applications.
  • If user applies a filter to one or more fields, an indicator icon is displayed in the field title.
  • Many bug fixes, usability enhancements, and elimination of most cross-browser inconsistencies.
  • See the AppGini 5.0 release announcement here.

AppGini 4.81, Aug 8, 2012

  • Bug fix for the MySQL database import utility.
  • Bug fix in some of the generated files to work with PHP installations that don't support short_open_tag

AppGini 4.80, Aug 6, 2012

  • Multi-level cascading drop-downs (for example, selecting a model from the car models drop down filters the car make drop down).
  • New metro-style home page.
  • Redesigned login page (please make sure to apply a theme to your old projects to take advantage of the new design).
  • Member profile page (where users can view and edit their profile, change their password, and view their permissions).
  • Easier page navigation in all views.
  • Sorting of tables in AppGini.
  • Filters pages redesigned.
  • Easier code generation procedure (new folders are automatically created, smarter output folder guesses).
  • New member notification email contains all member info.
  • Various usability enhancements and bug fixes.

AppGini 4.70, Jan 27, 2012

  • Added support for time zones.
  • Added "maxlength" parameter to form inputs to limit input size based on max field length.
  • Easier quick search by just clicking <Enter> rather than having to click the search button.
  • Added option to highlight a field/table in AppGini to easily refer to it later.
  • Updated Prototype and Scriptaculous javascript libraries to the latest release.
  • Various usability enhancements and bug fixes.

AppGini 4.61, Oct 30, 2010

  • This is a maintenance release that includes various bug fixes.

AppGini 4.60, Oct 1, 2010

  • Better themes management: A new theme editor in AppGini makes it much easier to modify the application appearance. Also, we added some new better looking themes.
  • Usability enhancements:
    • Users can now resize text areas by merely dragging their bottom border.
    • Added an automatic description for upload fields showing the allowed upload size and accepted file types.
    • Long drop-down combos are now automatically replaced by auto-complete text fields to make it easier for users to search them by simply typing part of an item.
  • Easier and more powerful customizations:
    • You can now customize the query for lookup fields to control the contents of the drop down.
    • A new hook file to add customized javascript code to control the behavior of forms. Please refer to the hooks documentation for more details.
    • You can now easily customize the filters page for each table, group, and even for each user. Please refer to the hooks documentation for more details.
  • Performance enhancements: drop down fields that contain a large number of items caused pages to slow down. This has now been fixed by automatically using auto-complete text fields if the number of items exceeds a certain limit.
  • Better support for non-Latin characters, and for right-to-left page layouts.
  • Added phone, 12-hour time, and Canadian postal code formatting to the available data formats.
  • Various bug fixes, security, and usability enhancements.

AppGini 4.53, May 7, 2010

  • This is a maintenance release that includes various bug fixes.

AppGini 4.52, Apr 12, 2010

  • This is a maintenance release that includes various bug fixes.

AppGini 4.51, Mar 8, 2010

  • More printing options: Added option to partially select records for printing them as a list (table view) or as details (detail view).
  • Added multiple selection option fields (users can select more than one value from a list box).
  • Create your database fields faster than ever before: When you create a new field and set its name to image, photo, comments, notes, date or id, AppGini smartly guesses the field properties so you don't have to waste time on this.
  • Increased performance and responsiveness of AppGini, various bug fixes and usability enhancements.

AppGini 4.50, Feb 5, 2010

  • Support for automatic creation of thumbnails for uploaded images.
  • Option to zoom thumbnails when clicked using lightbox2.
  • Added a javascript date picker for date fields for easy selection of dates.
  • Easier management of large projects: you can now type a part of the name of any field or table in AppGini to search for it quickly.
  • Enhanced security of data: You can now set lookup fields to inherit permissions of parent tables so that users can only see the data they have access to.
  • More convenient user login experience: Added Remember me option during login to avoid typing the username and password on every visit.
  • More flexibility and power to you: Added hook functions for easier customization of the generated application for adding new functionality. Check the easy-to-follow examples in the online help.
  • Usability enhancements and bug fixes.

AppGini 4.40, June 23, 2009

  • Support for rich HTML text area fields.
  • Implemented a printer-friendly detail view option.
  • Added option to display lookup field data as radio buttons (in addition to the drop-down menu option).
  • Added support for automatic values (values inserted automatically into read-only fields when inserting or updating records).
  • Enhanced the CSV data import feature.
  • Added table description property.
  • Added the option to open the last project from the start screen of AppGini for faster access.
  • For easier member signup, if only one group is available for sign up, it's now set as default in the registration form.
  • Various usability enhancements.

AppGini 4.30, Mar 3, 2009

  • Better support for international encodings and right-to-left languages.
  • The File menu now contains a list of the recently opened projects for quick access to your work.
  • AppGini can now add a table to your project using a CSV file.
  • The Data Format tab enables you to specify a special formatting for the selected field.
  • You can add description to each field in your project. This can be used as a help hint for your application users.
  • In the admin area of the generated applications, you can now populate any table with data imported from a CSV file.
  • Added support for enforcing a pre-selected parent value for a read-only lookup field.
  • Several usability enhancements, and better accessibility support.

AppGini 4.20, Sep 2, 2008

  • Added configurable option to notify admin by email when a new member signs up.
  • Implemented auto selection of appropriate value from lookup drop-down when child table is accessed from parent table.
  • Added option to display sum of column for numeric fields.
  • Support for updates and inserts using GET requests (to simplify integrating AppGini code with third-party scripts).
  • Several usability enhancements.
  • Reported bugs fixed.

AppGini 4.10, July 7, 2008

  • Members can now change or reset their passwords.
  • Auto-fill fields (fields that are automatically populated with data from another table -- see a video demo here).
  • Admin user can now sign in from the members area or the admin area, and an admin group is now automatically created that has full access to all tables.
  • Ability to define custom "quick lists" to be used for "option list" fields.
  • Support for friendly date formats in filters.
  • Changes to database structure after file generation are now applied automatically without having to run the setup script.
  • When performing a quick search, search terms are highlighted in the search results.
  • Various usability enhancements in both AppGini and generated applications.
  • Reported bugs fixed.

AppGini 4.00, March 17, 2008

  • Implemented membership sign-in system with group-based table permissions.
  • New re-organized and enhanced user interface.
  • MySQL2AppGini is now packaged as part of AppGini rather than a separate tool.
  • Table and field captions now support international character sets.
  • When using filters, "like" and "not like" now automatically translate to "contains" and "contains not" if no wildcards (% or _) are used.
  • Default data type for new fields changed to varchar(50) rather than integer.
  • Saving data to CSV files is now enabled in the freeware version.
  • Added full support for SSL connections.
  • Added option to sort generated tables list alphabetically.
  • Reported bugs fixed.

AppGini 3.40, August 18, 2007

  • Easier lookup fields, with the ability to combine 2 parent fields in one drop down.
  • Support for foreign keys that point to the same table.
  • Ability to specify output pages encoding.
  • Ability to search for "empty" and "not empty" fields in filters.
  • Enhanced project styles, with a new 3D look.
  • Fixed a bug where empty lookup field values caused records to be hidden.
  • Fixed a bug where clicking "Cancel" or "Deselect" in a separate detail view page caused resetting of filters.
  • Other reported bugs fixed.

AppGini 3.30, February 14, 2007

  • Ability to specify a default sorting field and direction for each table.
  • Support for check-boxes.
  • Date of today can be easily entered to date fields with one click.
  • Files in the overwrite window during code generation now sorted by file name for easier handling.
  • Alternating row colors in table view.
  • Fixed a bug where quick search with no results causes page numbering errors, plus other bug fixes.

AppGini 3.20, January 7, 2007

  • Ability to specify which files to overwrite and which to skip by checkboxes in a single window before code generation.
  • Option to easily access related children records from parent tables.
  • Support for web and email links.
  • Option to hide detail view till a field is selected, and to hide table view when detail view is selected.
  • Enhanced and more organized field properties page
  • Reported bugs fixed

AppGini 3.10, April 10, 2006

  • Ability to automatically apply field data type changes to your database
  • Ability to add new fields to your tables automatically and without any data loss
  • Better compatibility with PHP5 without changing php.ini settings
  • Ability to create radio buttons and list boxes
  • Enhanced and more organized field properties page
  • Ability to control whether fields are displayed as textarea or text boxes
  • Added a link to index page in the table navigation dropdown
  • Reported bugs fixed

AppGini 3.01, July 2, 2005

  • New XML-based file format (*.AXP) for easier editing and advanced control of code generation
  • Support for file uploads, and control on accepted file types.
  • Added an option to display links to uploaded files so that users can download them.
  • Next/Previous links in table view, and ability to navigate to any page.
  • Tamplate-based table view and detail view for easy customization of appearance.
  • Eastern Asian versions of Windows now fully supported.
  • Added the option to display the first n characters of a long field in the table view.
  • Easier method of ordering fields in AppGini.
  • Hyphens in database names now acceptable.
  • Each row in the table view is highlighted when the mouse passes over it for better readability.
  • Foreign and primary keys are more recognizable in AppGini now as they have different icons.
  • Added a tool to automatically convert old project file format (*.AGP) to the new XML format (*.AXP).
  • Added an option to delete uploaded files from server if the record is deleted.
  • Added an option to not change the name of the uploaded files.
  • Reported bugs fixed.

No change log is available currently for versions of AppGini earlier than 3.01.