Change log for MySQL and Perl for the Web webdb distribution

This file lists changes to the webdb distribution that accompanies MySQL and Perl for the Web. Changes are listed in reverse chronological order.

Downloads are available at: http://www.kitebird.com/mysql-perl/downloads.php.

Version 1.24 (2004-02-23)

• Point out in mail/README that the scripts in that directory should be run from the command line, not from your Web server.
• Removed unused @bar variable from gen_nav_bar() function in search/staffs.pl.
• In sessions/survey.pl, the $page variable in the process_answer() function should be initialized to the empty string. Otherwise, the function can return undef, resulting in a "Use of uninitialized value in concatenation" warning from Perl when the function result is used.
• In ecom/README, corrected a couple of references to store.pl that should say static.pl.

Version 1.23 (2003-10-11)

• Converted Changes.txt to Changes.xml so that HTML and text versions can be generated from the same source. Changes.xml and related files are located in the Support directory.
• Renamed main README to README.txt.
• Added missing dash in searches/res_search2.pl. (Cosmetic change.)
• Simplify an if-test in send_card() function of ecard/make_ecard.pl.

Version 1.22 (2003-03-16)

• Corrected a typo in 1.21 change note. No code changes.

Version 1.21 (2003-01-10)

• Corrected two errors in basics/escape.pl: The use CGI line needs to name escapeHTML explicitly (some versions of CGI.pm don't include it in the :standard set), and the start_html() line needs to end with a comma, not a semicolon.

Version 1.20 (2002-11-24)

• As distributed, prod_reg/prod_reg.pl would not run unless you had the Mail::Sendmail module installed. I've now split out the email-specific stuff into a second script prod_reg/prod_reg2.pl that is essentially the same but includes the email-sending capability. See prod_reg/README for installation requirements.

Version 1.19 (2002-11-11)

• Corrected typo in basics/fatals.pl.
• Fixed to field name problems in guest/guest.pl. The email address and note fields in display_entry_form() both were named "name" rather than "email" and "note".

Version 1.18 (2002-07-31)

• Better fix for stupid static.pl bug. :-)

Version 1.17 (2002-07-31)

• Fix stupid bug in ecom/static.pl that allows remote user to view any file on server host that Web server has read access to. Pointed out by Andy Taylor.

Version 1.16 (2002-07-19)

• Fix typo in basics/select-user.pl.
• Fix off-by-one error in res_search2.pl in determining whether there is a next page for multiple-page displays.

Version 1.15 (2002-02-28)

• Add missing semicolon in image/load_images.pl.
• Deleted extra space in image/make_thumbnail.pl.
• Deleted a couple of extraneous commas in ecard/make_ecard.pl.

Version 1.14 (2002-02-13)

• Image::Magick is no longer required for loading the images under the image and search directories. The original scripts are still there, but there are now also versions that don't use Image::Magick. (This should allow people who can't get Image::Magick installed to set up the electronic greeting card application in Chapter 5, and the second residential search application in Chapter 7.)
  • Under the image directory, load_image.pl reads an image file, created a thumbnail (using Image::Magick), and stores them both in the database. The script load_image_noim.pl reads the image file and the corresponding thumbnail. This requires that the thumbnails already exist, of course. They're found in the image/Thumbnails directory. See image/README for details.
  • Under the image directory, replaced load_images.sh (a shell script that didn't work under Windows) with load_images.pl and load_images_noim.pl, Perl scripts that should work under either UNIX or Windows. They use load_image.pl and load_image_noim.pl, respectively, to load all the images under the Images directory. The list of images is in the imagemap file.
  • The original load_res_picture.pl script in the search directory used Image::Magick to read the image file. It's been replaced by a version that doesn't use Image::Magick.
  • Under the image directory, replaced load_pictures.sh (a shell script that didn't work under Windows) with load_pictures.pl, a Perl script that should work under either UNIX or Windows. It uses load_res_picture.pl to load all the images under the Images directory. The list of images is in the imagemap file.
• Added records to search/cr_staff_tbl.sql.
• Fixed typo in security/edit_bio.pl.

Version 1.13 (2002-01-11)

• Added items to ecom/pet_catalog.txt
• Cleanup; added some missing start_html()/end_html() calls to scripts in forms directory.
• Removed image/Images/star-of-david.jpg; it appeared to contain a copyright notice.
• Slight change to Content-Disposition: header for ecom/serve_doc.pl.

Version 1.12 (2001-11-15)

• Use escapeHTML in todo/todo6.pl to display the search string, in case it contains something like "<br>".
• Small changes to searches/cr_staff_tbl.sql.
• In the ecom directory, clarified the instructions in README, added some items to pet_catalog.txt, and modified htfiles/contact slightly.

Version 1.11 (2001-07-11)

• Modify security/edit_bio.pl to check for a secure connection by examining $ENV{HTTPS} (which is defined by mod_ssl if the connection is secure) rather than by looking for https at the beginning of the URL.
• Created mail/README and prod_reg/README.
• Deleted prod_reg/load_table.pl (unneeded).

Version 1.10 (2001-07-05)

• Fix to search/res_search2.pl (was selecting extraneous column).
• Cosmetic change to WebDB/TableInfo.pm.

Version 1.09 (2001-06-29)

• Updated auto-form/README.
• Slight changes to several files in auto-form directory; removed several unused files.

Version 1.08 (2001-06-27)

• Clean up residence images a bit.
• Modified records in search/cr_staff_tbl.sql.
• Cosmetic change to guest/guest_digest.pl.
• Cosmetic change to image/upload_image.pl.
• Cosmetic changes to ecard/make_ecard.pl.
• Added guest/README, giveaway/README, image/README files.
• Added todo/todo6.pl (extra script not discussed in book). This differs from todo5.pl in using escapeHTML() to display text of entries.

Version 1.07 (2001-06-25)

• DBI now calls both warn() and die() in succession if PrintError and RaiseError both are enabled. Modified several scripts to not just enable RaiseError, but also to disable PrintError. Otherwise, error messages print twice. This slightly changes most of the scripts in the basics directory, and the WebDB.pm file.
• Added records to search/cr_staff_tbl.sql.
• Added a couple new residence records and images for the residence search.

Version 1.06 (2001-06-20)

• Added records to search/cr_staff_tbl.sql.

Version 1.05 (2001-06-13)

• Cosmetic change to search/res_display.pl.
• Removed extraneous return in store_order() function of ecom/doc_shop.pl and ecom/pet_shop.pl.
• Replaced a couple of pictures in search/Images

Version 1.04 (2001-06-01)

• Modified test data in search/cr_staff_tbl.sql.
• Modified test data in ecom/pet_catalog.txt.

Version 1.03 (2001-05-22)

• Replaced (stat($fh))[7] with -s $fh in image/upload_image.pl and in ecom/serve_doc.pl.
• Cosmetic change to ecom/static.pl.
• Cosmetic change to ecom/doc_shop.pl.
• Cosmetic change to ecom/serve_doc.pl.
• Cosmetic change to ecom/pet_shop.pl.
• Cosmetic change to auto-form/coffee2.pl.
• Cosmetic change to basics/errors2.pl.
• Cosmetic change to sessions/expire_session.pl.
• Removed extraneous escapeHTML() in error() call in sessions/prefs.pl and sessions/survey.pl.

Version 1.02 (2001-05-16)

• Fixed incorrect password in security/cr_bio_tbl.sql.
• Minor modifications to security/edit_bio.pl, mostly cosmetic.
• Further cleanup of read_image_file() in image/upload_image.pl.
• Cosmetic change to guest/guest.pl.
• Cosmetic change to mail/testmail.pl.
• Added .jpe extension to MIME suffix map in image/load_image.pl.

Version 1.01 (2001-05-10)

• Added Changes.txt (this file).
• Minor cosmetic changes to forms/elt_demo.pl.
• Fixed read_image_file() in image/upload_image.pl to handle image uploads from Windows clients. (The Image::Magick Read() function appears not to treat the file upload field properly as a file handle in that case.) Fix is to read the file first, then use BlobToImage() to convert the data to an Image::Magick image.

Version 1.00 (2001-05-07)

• Initial version.