Changes in 4.6 20050316 * new_site templates fixed. * added RSS link to HTML output (Christopher Zorn ) * added REST API (Christopher Zorn ) * added REST API documentation (Christopher Zorn ) * added per configuration templates. (Christopher Zorn ) * in lib/mySiteMaker/Output/Html.pm change subroutines row() and headerrow() to use templates. * added TEMPLATES documentation (Christopher Zorn ) Changes in 4.5 20050304 * Cleaning up and XHTML validating the cgi/templates/ directory * Added strings to language files. Need translations. * Added mysitemaker version to generic footer. * Fixed code for create_menus.cgi to use new-style sitemaker object creation. * JOINING_TABLES-HOWTO docs updated. * Changed db user and pass form input box names to reduce chances of collision with user's column names. * Fixed hide_query bug and hidden columns bug. Changes in 4.4 20050209 * Fixed buggy interaction of default and *_ALLOW authentication * The quest for validated and modern-HTML docs/ continues. Mostly valid. * Now uses Sys::Syslog to log auth messages. More logging may be desirable, please file feature requests Changes in 4.3 20050114 * Fixed bug where 0 causes blank field output * Fixed bugs in searching for null/empty fields. * Better timeout messages, and internationalised. * Translated most of the French phrases using google. Mon Francais est mauvais. * File upload has been working since about 4.2 or 4.1. * COLUMN_HEADERS might be fully implemented. Bug reports needed. * RSS output module * Basic access control-- removed roles. See CONF_MODS How-to in docs/ Changes in 4.2 20041029 * Fixed stupid indirect relations bugs * Removed some extra debugging prints * Caching the statement handles for indirect relations * Enabled searching on indirect relations * New conf file parameters for edit/delete roles. See CONF_MODS How-to. * Fixed the record counts Changes in 4.1 20041018 * Increased field sizes on Edit records page * Reduced debug level to stop spewing * Installer asks for Redhat/Debian/Other (submit your distro's paths!) * General_search might have the help files in the right place now. * Last and first links, in addition to next and previous * COLUMN_HEADERS partially implemented, see the Conf mods howto * Dropped session timeout from 4 hours to 5 minutes changes in 4.0 * Everything. conf files are probably compatible. * docs updated a bit. * new installer. changes since 3.9 * Everything - a complete re-write. changes since mySiteMaker 3.8 * Now export "true" Excel files. * bug fix to properly URL encode "where clause" * Now requires the Perl module Spreadsheet::WriteExcel::Simple changes since mySiteMaker 3.7.1 * Changed install script to allow user to specify relative CGI and HTML directories. * Added feature to limit access to "mysites" to a specific URI. * Now uses relative URL's throughout. * Improved Export changes since mySiteMaker 3.6.1 * Fixed reorganization bugs with limit_fields.cgi changes since mySiteMaker 3.6 * Added sytle sheet support. * Reorganized mySiteMaker perl modules * Friendlier install script changes since mySiteMaker 3.5 * Added option of displaying or editing a primary key. * Added Italian support. * misc bug fixes during configuration process * misc bug fixes with direct and indirect relations * Database support redesign. See DEVELOPERS and README.databases * escaped html data that may be stored in the database before it is printed out. See tab_to_table.pl * escaped tabs in data before it is processed. If you do not escaped tabs bugs occur when you delimit the data with tabs. For example, more fields in row than columns in table. **************************************************************** changes since mySiteMaker 3.2 * Added "Hide query" checkbox to the search page. * Added two new HOWTOs: How to modify the configuration files by hand (CONF_MODS-HOWTO.html) and how to join in data from other tables (JOINING_TABLES-HOWTO.html) * Radical changes to how mySiteMaker handles related tables. You can now join in data from other tables (beyond the limited joins that were made for columns that used pulldown menus and radio buttons for input). * Fixed a bug having to do with browsing through results pages and the NEXT button. The problem was that clicking on the NEXT button would always bring you to the same set of records, depending on what you set the limit to be. Thanks goes to Branko Ivanovic for notification and providing a fix. # Fixed a minor XML output bug that allowed zeros to sneak into the output when there were no values for a given column * XML output now escapes &, <, >, and " characters correctly. * HTML output now does a better job displaying results that contain characters that could be interpreted as HTML (they are more likely to be escaped now) *Fixed a problem with \r\n when outputing the data * Added some character escaping so that you can now search using an apostrophe in the keyword that you are trying to match. * Fixed a minor problem that was causing unnecessary error reporting in "general_search.cgi". **************************************************************** changes since mySiteMaker 3.1.1 * Added a Serbian language translation. Thanks goes to Branko Ivanovic for providing the new files. * Moved nondocumentation HTML files to html directory * Added a feature to allow the presentation of the query on the results screen to be suppressed. Currently there is not a check box on the search screen to access this feature, however, you can still make use of it with canned searches that are in URLs for hyperlinks. For canned searches, the user is almost always just interested in the results and not the details of the search at all. (see CANNED_QUERIES-HOWTO.html for full details). * Fixed a bug that prevented searching on columns involved in many-to-one relations (columns that use checkboxes or multi-select menus for data input) * Consolidated the functionality of "limit_search.cgi" and "next.cgi" into "general_search.cgi". (This resulted in removing both files from the main CVS branch as well) **************************************************************** changes since mySiteMaker 3.1 * Fixed a bug that messed up the sorting variable in next.cgi (this bug popped up when you clicked on the "show next records" button at the bottom of a results screen). **************************************************************** changes since mySiteMaker 3.0 * Added "return results as XML" option to the search page. * Fixed a bug related to the 'edit' and 'delete' links when the results are sorted by a column that uses pulldown menus or radio buttons for input. Thanks goes to Ryan Thomas for pointing out this problem. * Changed the 'add_record.cgi' script so that only fields that have values will be part of the insert statement. This fixes a problem that folks were having with timestamps. Before, if you left the timestamp blank, the initial timestamp value would be 0000000.... Now, if you leave the timestamp blank, the current date/time is inserted. * Modified the 'confirm_delete_record.cgi' script so that it would not send an error to the error log if there is no value for a field that uses a pulldown menu or radio buttons for input. **************************************************************** changes since mySiteMaker 2.6 * Added support for Postgres databases. Please see README.databases * Added hooks in all of the pertinent scripts to allow for query logging. See the file LOGGING-HOWTO.html for more information on how to get mySiteMaker to log who is doing what queries with your mySites. * Now the Edit Record, New Record and Delete Confirmation screens will limit the columns that they display to only be the columns that you do no make hidden when creating the mySite. * Minor optimizations in the confirm_delete.cgi script * Fixed a problem that existed when you configured a column to not allow editing, yet the input for that column was a pulldown menu/multi-select/etc. Before, mySiteMaker would not display any value for that field if it had a multi-select menu or check box buttons for input. Now it displays values the same way the "Delete Record: Confirmation/Authentication" screen does. * Re-wrote the way one-to-one and one-to-many relations are handled. Specifically, this has to do with how pulldown menus and radio buttons work (not multi-select menus or check box buttons). Before, the option selected from the menu or the radio button was just dumped into the main table that the mySite was created for. Now the primary key value for that option is dumped into the main table that the mySite was created for. NOTE: This change means that mySites created with mySiteMaker 2.6 or earlier that use pulldown menus and radio buttons for input/editing will have to have their main table modified in order to work with the current or later versions. The "mySM-3.0-upgrade.pl" utility will automatically make these modifications for you. See the file "UPGRADE_TO_3.0-HOWTO.html" for more information. * Added support for "text", "blob", (tiny, medium and long varieties included) as well as "float", "double", "decimal", "date", "datetime" and "time" datatypes. * Unified the look of the "edit" and "new record" screens. * Replaced some magic numbers relating to the maximum number of 'mySites' you can create for a specific table in the "new_site.cgi" script with global variables. * Fixed many errors related to sorting. There were problems related to re-sorting the results when the user had selected the "show all" option. Thanks to Andrew Bell for pointing this out to me. * Fixed an oddity related to using the "jump to record..." option on the results pages. Before, to jump to the first record (which would usually have a primary key value of '1'), you had to type in that you wanted to jump to record '0'. In doing this I cleaned up the code a lot and fixed a problem related to the "Displaying Records: X-Y" section at the top of the results pages. Thanks to Bill Duncan for notification and advice on how to fix all of these things. * By popular demand, you can now create mySites for tables that do not contain primary keys. However, both editing and deleting are automatically disabled if there is no primary key. * Ever so slight changes to the install script that make the location that MySiteMaker is going to install its HTML files a little more obvious. **************************************************************** changes since mySiteMaker 2.5.3 * We now have a Spanish translation for the strings file! This was done by Sandor Saiz. Mad props to him. * You can now refine your searches by doing searches within result sets. This option allows you to add as many AND style clauses to your search as you would like without over complicating the user interface. * Improved the error reporting when no records are found for a query. * This is embarrassing but true so here you go... When I made the changes to mySiteMaker to correctly handle exporting many-to-one relation data to Excel or Text, I accidentally modified old files and thus, version 2.5.3 had some fixes, but it was missing all of the features I had added to version 2.5.2. I have since reconciled the differences between these versions. Thus, this version has the good stuff from version 2.5.2 and version 2.5.3. William Duncan was the man who pointed out the tip of this iceberg of problems. * Rewrote some of the documentation. **************************************************************** changes since mySiteMaker 2.5.2 * Fixed the "Return results as Excel/Text" option to handle many-to-one relations. * mySiteMaker will now report an error if someone tries to create a mySite for a table that does not have a primary key. Primary keys are needed for editing, deleting and many-to-one relations. * Modified the install script to check for DBI and the correct drivers. changes since mySiteMaker 2.5.1 * It is now much easier to navigate through the results pages. There are buttons to the first and last records returned in a search as well as a text field that lets you specify exactly which record you want to jump to. changes since mySiteMaker 2.5 * Fixed a bug in the install script. * mySiteMaker is no longer dependent on a specific implementation of the 'getopt' program. It now carries with it a module called "Getopts.pm" that takes care of parsing arguments for both 'get_conf_data.pl' and 'tab_to_table.pl'. **************************************************************** changes since mySiteMaker 2.0 * Modified the 'Limit Columns' pop-up window so that items that were previously selected remain selected when you open the window multiple times prior to actually doing a search. * Lots and lots of little fixes all over the place. * Database calls and SQL generation has been abstracted to a single module which allows mySiteMaker to be easily ported to other databases. * The rudiments of multi-language support are now in place. Thanks to Yves. You can help finish or add new translations, see the file "LANGUAGES" for more information. * Pulldown menus, Multi-select menus, Checkboxes and Radio buttons are now easily added to 'new record' and 'edit record' screens. * mySiteMaker now supports many-to-one relations and generates the tables to handle these automatically. * Modified the "edit_record.cgi" script so that the fields for editing match the length of the fields in the database. -- Chris Prosser * Fixed a bug in the "general_search.cgi" script that was introduced in mySiteMaker 2.0 that prevented people from adding additional conditions to the condition menu. -- AGOSTINI Yves **************************************************************** changes since mySiteMaker 1.2 * Fixed a bug in the "edit_record.cgi" script that caused certain characters (i.e. '&', quotation marks, '>', '<') to be displayed incorrectly in the web pages -- Special thanks to Chris Prosser * Re-wrote the "submit_changes.cgi" to use the DBI quote function to escape the fields -- Special thanks to Chris Prosser * When creating a new site, you can now select columns that should be hidden from the user (i.e. you may not want them to see the primary key or other fields). * When creating a new site, you can now select which columns that can not be edited by the user. This is only useful if you are allowing editing but only one users to be able to edit the data in only a few columns but you will want them to be able to see others. * Fixed a bug in the "confirm_delete.cgi" script -- Special thanks to Gene King. * Fixed a bug in the "new_site" scripts that displayed "Add New Record" on the search screen regardless of whether you turned that feature on or not. * Changed the net_site scripts to use tokens in the file "general_search.html" when making changes rather than keeping track of line numbers. * Added a link to the search page from the results pages (you are no longer required to click on the back button an arbitrarily large number of times to do a new search). * Column names, in the HTML results pages, are now hyperlinked so that if you click on one, the search will be re-sorted by that column name. * Updated the "tab_to_table.pl" tool to deal with column names wrapped up in HTML tags. * mySiteMaker will now create sites for databases that have spaces in the user's password. * Removed some of the old, old, backwards compatibility things. * Mild re-writing of a few sections in the scripts **************************************************************** changes since mySiteMaker 1.1 * Added the ability to delete records * Mild debgugging of the tab_to_table.pl script and added a good deal of comments * Added some meta tags to the browser will not chache pages that have data in them **************************************************************** changes since mySiteMaker 1.0 * Added the ability to add new records to the database. * Fixed the "Edit Record" screen so that it no longer appeared like you could edit the primary key (you couldn't before, but it looked like you could). * Fixed some problems with the install script **************************************************************** changes since general_my_db-1.1 * Changed the name to MySQL SiteMaker (mySiteMaker) to avoid confusion with the myDB project * Total rewrite of the code. The CGI scripts now use configuration files to determine their actions so there is only one set of CGI scripts and a bunch of configuration files instead of one CGI script per database table you want to search. * Added a feature to all the user to select which columns they want to view/download * Added a feature to allow users the ability to update entries in the database (although they must have permission within MySQL to do so). **************************************************************** changes since general_my_db-1.0 * Added "find records that match the contents of a file" option. * Added the ability to page through the HTML results rather than having to see them all at once.