August 03, 2006, Version 1.0.2 - restored php4 compatibility by adding a php4 replacement for the php5-only array_combine() function March 12, 2006, Version 1.0.1 - enabled connecting to Firebird 2.0 databases; this is done with an hack to work around a bug in php's ibase_connect function - added czech language file, contributed by pestasoft(at) users.sourceforge.net - removed usage of $_SERVER['HTTP_REFERER'] which may be turned off in the browser - executing sql-scripts with isql if they contain CREATE PROCEDURE or CREATE TRIGGER statements August 21, 2005, Version 1.0 - added hungarian language file, contributed by Zoltán Miklovicz - added extra checks to prevent bypassing of the $HIDE_PANEL setting - improved error_handler takes care for the error_reporting setting - fixed warnings about bad reference assignments with php 4.4.0 - take care for autoincrement fields implemented with before insert triggers and generators when entering data - fixed foreign key definition for character columns with collation - bugfix: enabling '0' as default value for domains June 25, 2005, Version 0.99.3 - respecting the users role privileges for tables - display the login role as part of the info string - accepting db aliases as entries in the $ALLOWED_FILES setting - added a check/warning for the TMPPATH setting at startup - fixed privileges check for delete links on the watchtable panel - fixed warnings about implicit object cloning when running php5 with zend.ze1_compatibility_mode = On - fixed for watchtable configuration for other languages than english - fixed the changing of the blob type in the blob popup window - bugfix for entering data into tables with computed columns January 31, 2005, Version 0.99.2 - fixed tables selection on the watchtable panel for users<>SYSDBA - made panel- and detail-headlines clickable - added a check/warning for register_long_array=On when using php5 - fixed appearance of NOT NULL constraint on the display tables panel - fixed error detection when creating and modifying tables - enclosing table- and columnnames with double quotes in dialect 3 databases when entering, editing and deleting data - fixed browsing tables with method WT_STORED_PROCEDURE for tables with more than 18 columns November 09, 2004 Version 0.99.1 - added polish language file, contributed by Matthias Hryniszak - fixed editing of data for values containing double quotes - fixed trigger-source when modifying triggers - fixed a bug for csv-import of text-blobs - direct editing of textblobs when entering/editing data - added a 'delete all' option to the delete udf selectlist - fixed editing/deleting data from the watchtable panel when cookies are disabled May 31, 2004, Version 0.98 - added spanish language file, contributed by Jose Pichardo - fixed triggers detection for Firebird 1.5 - fixed bug with php-option session.use_trans_sid=On - jsrs fix for IE with ssl-connections - added an option for csv-import to convert empty values to NULL - fixed creating of user defined exceptions - make sure that the info panel is open if an error occured - fixed bug with float and decimal stored procedure parameters - fixed bigint and boolean datatype determination for stored procedure parameters - final fix for the magic_quotes_sybase madness (hopefully) - fixed editing/deleting data with magic_quotes_gpc=1 March 14, 2004, Version 0.97 - added a new panel for user defined exceptions - fixed initialisation of available domains when creating tables - fixed session startup for non standard http ports - fixed fatal error when restoring database from backup - fixed inserting data into tables with domain-based columns - fixed editing of domain-based columns (Bug #908370) February 29, 2004, Version 0.96 - fixed the 'cannot delete temporary file' bug for creating and dropping databases and creating triggers and stored procedures - fixed watching of tables with domain based columns with method WT_STORED_PROCEDURES; changed default watchtable method to WT_SKIP_ROWS for ib<=6.0 (Bug #857263) - combined type, size, prec and scale columns in the tables and in the domains overview to a single column February 03, 2004, Version 0.95 - added a new panel for user defined functions - added russian language file, contributed by Andrej Surkov - tested with php5 b3, all reference warnings removed - the CONFIRM_DELETE config option is now editable by the user on the customizing panel - fixed some database deadlocks - csv-export now trims whitespace from the end of character fields - fixed handling of computed fields when entering or editing data - fixed execution of external commands on windows if the pathnames containing spaces (Bug #860417) - keeping database name in the login panel after logout (Bug #857233) - cleaning up the SQL Output panel if another select statement with an empty result is executed (Bug #855340) - removed php short_open_tags from all files (Bug #857216) November 02, 2003, Version 0.94 - added new Firebase 1.5 dataype BIGINT, new charsets and reserved words - added a file upload element to the sql enter panel - browsing the sql buffers on the sql enter panel without page reload - fixed execution of sql scripts longer than SQL_MAXSAVE lines - 30% speed increasement for csv file import - dropping column based primary key and unique constraints - create, edit, delete foreign keys for table columns - saving panel states beetween sessions - new user customizing panel for color settings and some appearence parameters; a cookie is used to save the values between sessions - fixed '0' values on the system tables panel - added auto refresh on the system tables panel for the IB7 temporary system tables - fixed IB7 related misbehaviors for triggers, domains, stored procs - added a new option for the WATCHTABLE_METHOD configuration setting which is trying to guess the fastest method for browsing tables - added additional reserved words, character sets and temporary system tables for Interbase servers 6.5, 7.0 and 7.1 - added FB_1.0, IB_6.0, IB_6.5, IB_7.0, IB_7.1 entries for the server setting on th login panel August 20, 2003, Version 0.93 - fixed a bug were external commands (isql, gbak, etc.) were not executed on windows August 18, 2003, Version 0.92 - added japanese language file, contributed by shue@xdip.com - added dutch language file, contributed by Michael van Canneyt - better NULL value handling when displaying data - fixed bug that caused unique fields were displayed as pk fields - added a server setting to the login panel and a DEFAULT_SERVER configuration setting - added filter elements to the system tables panel - bugfix for collation handling when adding columns - reworked and enhanced domains-panel - fixed javascript bug with the php setting magic_quotes_sybase=1 - included webfx's selectableelements.js class for selecting tablerows on the systemtable-, watchtable- and sqlresult-tables - added an error_handler() for catchable php errors February 05, 2003, Version 0.91 - comleted procedures panel, creating and modifying of stored procedures is now supported - speed improvement for tables properties lookup - bugfix: check constraints are not longer causing double fields - bugfix: displaying complete source code for big sp and triggers - using jsrs for fetching table-, view-, trigger- and domain-details without reloading the whole page - displaying 'BLOB' instead of the binary handle data in query results - ordering of the triggers table by trigger- and table-name - Volker Rehn contributed a set of icon images with transparent background - new views panel for creating, modifying, deleting views - discard views from the view tables panel - optionally displaying the record counts on the view tables panel - the view tables panel got a reload button - saving the results from entered queries as csv files - displaying the values of foreign keys datasets through links on the watchtable panel (ns6++ and ie5++ browsers only) January 02, 2003, Version 0.90 - own stylesheet file for netscape 4 browsers - new image free tabfolder menu, contributed by Dimo Velev; set TABMENU_STYLE to 'HTML' in inc/configuration.inc.php to use this - new database restore panel - new database backup panel - displaying the content of text blobs in the system tables via links in a separate window - rearranged the column definition form and added a text field for column check constraints - fixed dependencies testing to ignore check constraints for tables - added dhtml to display only the available collations for a selected character set in the column definition form - charset definitions are now fetched from the system tables - viewing metadata is working now with Interbase 6.0 and lower if the environment variables ISC_USER and ISC_PASSWORD are set - fixed check for php's gd/ttf/png support; this had broken startup if gd was supported but without ttf and/or png November 10, 2002, Version 0.83 - new database maintenance panel (interface for the gfix command) - added brazilian-portuguese language file, contributed by Paulo Vaz - fixed users creating/modifying/deleting on windows - does chdir(BINPATH) before executing external commands to satisfy various windows versions (TMPPATH needs to be an absolute path now) - added textfields for the database host to the db-create and the db-delete panels - interpret $ALLOWED_FILES and $ALLOWED_DIRS case-insensitiv on windows - changed the DATABASE_SUFFIX configuration option to an array - checking for isql.exe instead of isql on windows systems - workaround for xitami bug where $PHP_SELF is not set October 20 2002, Version 0.82 - displaying view creation source on the view tables panel - new stored procedures panel for displaying and deleting sp's, but no creating nor modifying yet - checks for existing dependencies before deleting database objects and prints a usefull message instead of silently fail to delete - the new $SQL_DISABLE config setting disables the execution of commands or group of commands on the sql-enter panel - 'clear'-button for the textarea on the sql-enter panel - support for the interbase 6.5 'ROWS x TO y' syntax when browsing tables , see WATCHTABLE_METHOD in inc/configuration.inc.php - internationalisation of all strings, english and german translations are included - configuration settings for removing any panel from the gui, see $HIDE_PANELS and SYSDBA_GET_ALL in inc/configuration.inc.php June 22 2002, Version 0.81 - adding user to roles, removing users from roles - support for the collation order when creating domains - displaying the query plan for queries on the 'Enter Command' panel - caching the content of the sql_output panel to keep the contents during multiple requests - new configuration option SHOW_OUTPUT_ROWS to restrict the count of rows displayed on the sql_output panel by default - selectlist to change the blobs filetype while viewing a blob - new configuration settings DEBUG_COMMANDS and DEBUG_FILES - the modifying table errors are fixed - the login panel got a logout button to disconnect from the database - new role panel for displaying, creating and deleting roles - new server statistics panel (wrapper for gds_lock_print/ iblockpr) - new database statistics panel (wrapper for gstat) - only tables are accessable to the user, where he have sufficient permissions for the according actions - more emphasized appearence of warnings and error messages - checking for the interbase extension on startup May 22 2002, Version 0.80 - caching of the watchtable content to avoid needless and time consumpting recalculations - new basic history mechanism for sql commands - displaying blobs in various formats (text, html, hex, png, jpg, gif) throught links on the watchtables - added support for views on the watchtable panel - displaying view properties on the showtables panel - optional 'where'-restriction for the watchtable-panel - support for the firebird 'SELECT FIRST SKIP'-syntax on the watch- table-panel (see WATCHTABLE_METHOD in inc/configuration.inc.php) - if the config setting CONFIRM_DELETE is set true a confirmation panel pops up before deleting data, tables, databases, ... anything - smoother, more failure safe form handling on the tables page - added text-blob support for csv import and export - new security config options HIDE_SYSTABLE_PANEL, HIDE_USERS_PANEL - enhanced blob handling on the edit data panel January 04 2002, Version 0.72 alpha - fixed the 'Ambiguous field name' bug conspicuous with the release 1.0.0-RC2 of the firebird database server October 23 2001, Version 0.71 alpha - fixed html table on the watch table panel October 19 2001, Version 0.7 alpha - new user panel for creating, modifying, deleting database users - new Admin page for administration functions - added fields for role, buffer cache, charset and sql dialect to the database login form - optional asking for confirmation when deleting rows, set by CONFIRM_DELETE in configuration.inc.php - added blob support to the edit data panel - rearranged the handling and appearence of the watch table panel - new index panel for creating, modifying, dropping indices - new set of smaller icons for the panel handling - a new panel displays the contents of the interbase system tables - prevent attempts to create or modify tables using interbase keywords as column names September 16 2001, Version 0.6 alpha - added edit-data-panels opened by links on the watch-table-panel - added deleting from datasets through links on the watch-tabel-panel - the session/fallback mechanism should now determine the correct settings under all circumstances - new configuration arrays $ALLOWED_DIRS[] and $ALLOWED_FILES[] to restrict the accessible databases April 15 2001, Version 0.5 alpha - changed licence to GPL v2.0, made ibWebadmin a sourceforge project - lot of bugfixes in all sections - niced up the gui - optionally the watch panel can use auto-generated stored procedures - added a 'watch table' panel to the SQL- and to the Data-page - no more warnings when error_reportig = E_ALL & ~E_NOTICE - enabled to run with 'register_globals = Off' in the php.ini - moved the sourcecode into a cvs-repository - cleanup TabMenu.class and added PHPDoc-style comments - added javascript to autofocus some textfields November 3 2000, Version 0.4 alpha - added triggers panel to show/add/modify/delete triggers - cleanup the generated html-code - added displaying of domains to the domains-panel - added precalculated menu graphics in 5 different widths - the menu calculated by TabMenu.class looks much better now - fixed two bugs in the csv import routines - added links for moving panels to top, bottom, next, prev position - added JavaScipt to allow only valid combinations for 'Not Null', 'Unique' and 'Primary' when creating new columns October 18 2000, Version 0.3 alpha - added import and export of csv files - added boolean constants DEBUG abd DEBUG_HTML to configuration and of cause the code to handle them - modify domain function added - fixed bug displaying the wrong charset when modifying columns - added functions for domain creation and domain deletion - removed unused panels Modify Database and Watch Table - fixed file handling for blobs in the Enter Data panel October 11 2000, Version 0.2 alpha - got to know that ibWizard is already an Oracle tool, renaming to ibWebAdmin - displaying current values of generators in the generators panel - now accessing all (?) user input through HTTP_[POST|GET]_VARS[] - added the Enter Data panel with basic functionalities - get_tables() now inquires the segment size for blob fields - table and field init is now outsourced to /inc/get_tables.inc.php - got rid of the errors that occured when not connected to a database - the content of the sql-textarea is now saved in the session, the global constant SQL_MAXSAVE defines the behavior - add function get_panel_index() to avoid the absolut addressing October 3 2000, Version 0.1 alpha - First public upload of ibWizard # Local Variables: # mode: text # End: