*********************************************************************************** DaDaBIK (DaDaBIK is a DataBase Interfaces Kreator) http://www.dadabik.org Copyright (C) 2001-2002 Eugenio Tacchini This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. If you want to contact me by e-mail, this is my address: eugenio@pc.unicatt.it *********************************************************************************** I am instructor and Web developer at the Master of MiNE (Management in the Network Economy) Program, a Berkeley-style program in Italy. If you want to know more about it please visit: http://mine.pc.unicatt.it/ *********************************************************************************** Novermber 9, 2002 v. 2.2.1 beta The bug that caused the lost of the correct search results when the user click on a page number, supposed to be fixed in the previous release, is now completely fixed. The version of the MySQL server is now correctly checked, in this way the "Your database is empty" bug, supposed to be fixed in the previous release, is now completely fixed. A known bugs document is now available. ------------------------------------- ------------------------------------- October 22, 2002 v. 2.2 beta Support for file uploading (images and other) is now available. The bug that caused the lost of the results order when the user click on > has been fixed. The bug that caused the lost of the correct search results when the user click on a page number has been fiexed. Fixed the bug that prevented the internal table manager to work correctly when the result order is changed. The version of the MySQL server is now checked, in this way the "Your database is empty" bug has been fixed. The numeric type now accepts also float and other numeric fields. ------------------------------------- ------------------------------------- July 31, 2002 v. 2.1b beta Web and e-mail fields weren't display correctly in the version 2.1 beta. The bug is fixed with tihs version. ------------------------------------- ------------------------------------- July 30, 2002 v. 2.1 beta A new, lighter and easier to use administration interface (related to the internal table manager) is available. The form has now a better layout, all the fields are correctly aligned, including dates. All the translations are now up-to-date. It is now possible, for select_single fields, to choice "other" during an insert and fill a textbox by hand with an alternative value. That value also update the select options, unless option had driven with a custom query ("SQL:......"). It is now possible to choice if a field has to be displayed in the details page or not. Completely fixed the bug the caused the warning message: "Warning: Call-time pass-by-reference has been deprecated......" with particular php.ini settings It is now possible to use the "-" sign and other allowed signs in MySQL table and field names. Fixed a bug that prevent some text to be displayed if written after a special html char (e.g. <). Fixed a bug that prevent to choose more than 999 characters as maxlength of a field. Fixed a bug related to the use of the double quote in the include statements, that can cause error messages. Textbox and password fields are now checked for max lenght also server side. Select_single fields are now checked for length and type, this improve security because a malicious user could change the html of the form and then post it. ------------------------------------- ------------------------------------- Jun 28, 2002 v. 2.0.1 beta DaDaBIK is now compatible with PHP 4.2, and works also with register_global directive set to off. Added two new date display formats, which fix the problem of displaying dates before 1970 Fixed a bug that caused the insert of a separator if a select_multiple_menu or a select_multiple_checkbox were empty The "Any/all" conditions menu now appers also in Netscape and other browsers. Fixed some minor bugs that caused warnings and notices. ------------------------------------- ------------------------------------- Jun 1, 2002 v. 2.0 beta Support for multiple tables available. "View all records" feature. It is now possible to order a group of record by a field clicking on the corrisponding coloumn. The pages navigation tool has been improved. Fixed a bug about size of input field in Netscape. Fixed a bug that about the color of the required fields in the search form. ------------------------------------- ------------------------------------- Apr 21, 2002 v. 1.9.1 Fixed a bug that allowed an attacker to execute arbitrary sql query on the database (e.g. insert or delete records even if insert and delete feature were disabled). Fixed a bug about double quotes handling in the search function. All DaDaBIK users are encouraged to update to the latest version. ------------------------------------- ------------------------------------- Apr 15, 2002 v. 1.9 Fixed the bug that caused an error during the insert if you didn't enable the check similiarity for any fields. Fixed the bug that caused a "Required field" message even if a date field was filled by the user. Fixed the bug the caused a warning message if allow_call_time_pass_reference is set to false in php.ini. Added Spanish and French versions. ------------------------------------- ------------------------------------- Mar 18, 2002 v. 1.8 The algorithm that scans existing records during an insert in order to find similar records is now more efficient (e.g. for a table with >8000 records, 2 fields to check, it is now 5 times faster than before). Update now works also with a MySQL version < 3.23.x Fixed the bug that caused an error if a date field was initally null. ------------------------------------- ------------------------------------- Feb 28, 2002 v. 1.7 New features: A new administration interface is now available and allows you to manage the internal table without any other software!! So you don't need PHPMyAdmin any more in order to customize DaDaBIK. Configuration is now easier. Debug mode added. ------------------------------------- ------------------------------------- Feb 11, 2002 v. 1.6 New features: It is now possible to disable the functions: insert, update, delete and details; in this way you can safety use DaDaBIK in a public site. New administration interface for the internal table. The installation procedure is now more explicative. New customizable graphic icons for edit/delete/details buttons. You can now choice the coloumn at which a text, textarea, password or select sinlge field will be wrapped in the results. It is now possible to choice the target window for edit/details (self or new). The graphic layout of the form looks now better with Netscape. German translation added. ------------------------------------- ------------------------------------- Jan 27, 2002 v. 1.5b In the version 1.5 I missed the code line that allow to use the dutch version, the version 1.5b include a fix to that bug together with a config.php file more precise. ------------------------------------- ------------------------------------- Jan 26, 2002 v. 1.5 DaDaBIK is now considered out of beta and has some important new features, for this reason I decided to call this release 1.5 (the last was 1.1 beta) New features _________________ Partial foreign key support: it is now possibile to drive the possible options of a "select_multiple" or "select_single" field from another table, even with a customized SQL query!! It is now possible to select between any/all the conditions during a search It in now possible to display a select_multiple field also with a menu (HTML select multiple tag) For each field you can now specify a prefix value (e.g. http://) and a default value For each field you can now specify which operator the user can use, including exactly, like, >, < A Dutch version of DaDaBIK is now available An on-line demo is now available Minor bug fixed ___________________ The results of a search are now displayed taking the carriage return (\n) into account. ------------------------------------- ------------------------------------- Jan 14, 2002 v. 1.1 beta New features: According to user's needs, now the internal table and the main table are in the same database, so you don't need two databases in order to run DaDaBIK. It is now possible to specify the order of a field in the form. Fixed bugs: Required fields message now apper only if there are at least one required field. Search of a "select single" field with exact/like feature enabled now works. Some updates didn't work, now the bug has been fixed. Bug about searching by date fixed, now you can search properly a record by date using < or >. Time generated by insert_date and update_date are now in 0-24 format. ------------------------------------- ------------------------------------- Dec 9, 2001 v. 1.0.5 beta Documentation: The configuration file is now more explicative. The readme file is now more explicative. A new document about the internal database is now available. New features: Now you can select between an "exact match" or a "like" search also in the form, on the fly. (You can also disable this feature) Hints are now visible even during the update procedure Bugs fixed: The maxlength property in the internal database now works A very small part of the function build_form() rewritten in order to make DaDaBIK more flexible. ------------------------------------- ------------------------------------- Dec 5, 2001 v. 1.0.4 beta The readme file is now more explicative. Two HTML-related bugs fixed: the background of an empty cell now appears even with Netscape the select input field now appear correctly even with Netscape ------------------------------------- ------------------------------------- Dec 1, 2001 v. 1.0.3 beta Italian version added Some english mistakes fixed Configuration option (display the "I think that x is similar to y......" statement during duplication check) added ------------------------------------- ------------------------------------- Nov 24, 2001 v. 1.0.2 beta One bug fixed (creation of the internal database didn't work due to bug in db_functions.php) ------------------------------------- ------------------------------------- Nov 24, 2001 v. 1.0.1 beta Several bugs fixed (creation of the internal database didn't work, navigation buttons didn't work) ------------------------------------- ------------------------------------- Nov 21, 2001 V. 1.0 beta The first release of DaDaBIK. ------------------------------------- -------------------------------------