Download

Current Stable Version

Notes:
English language only.
No known bugs. If you find any, please report them to recipants-bugs@pantsblazing.com

Revision History

v1.2 - 27 April, 2004

• Oracle support: ReciPants now supports Oracle databases.

• Temperature converter converts between Centigrade and Farenheit.

• Sweetness converter converts between Brix and Baumé.

• Database connection tester uses your database configuration parameters to see if ReciPants can talk to your database. Located at util/test-db-connection.cgi

• Security improvements, see below under Tweaks

• Dates now display the correct month.

  Thanks to Jon McClintock for reporting and fixing this bug.

• The email address validator has been fixed to allow hyphens in mailbox names (the part before the @ sign).

  Thanks to Brad Fritz for reporting and fixing this bug.

• Single quotes are escaped and no longer cause a SQL error in recipe search.

  Whoever reported this bug forged the From: address as my own and didn't sign their email so I have no idea who is was, but thanks, whoever you are!

• Security: Certain inputs are filtered as Cross-Site Scripting prevention measures: numeric format is enforced for ID numbers (user id, recipe id, category id, etc.) and potentially malicious characters are escaped.

  Thanks to Jon McClintock for suggesting and providing code for this.

• Security: Cookies are now IP address-validated (the user must be using ReciPants from the same address they signed in from), making effective cookie theft much more difficult. This is a configurable option.

• Added $db_host and $db_port options for connecting to remote databases.

  Thanks to George Howell for suggesting and providing code for this.

• The Password Reminder now validates the email address format before querying the database.

• You can now supply a custom database connect string, which is useful with Oracle's vast array of connection options.

• Changed instructions.step_text column size (and therefore maximum individual instruction length) from 4096 to 4000 to accomodate Oracle's 4000 byte limit on VARCHAR2 columns.

• SQL errors now get logged to the Web server error log (STDERR) instead of showing the query to the user.

v1.1.1 - 5 December, 2003

• Ingredient quantity column type in MySQL schema: The NUMERIC type only stores whole numbers in MySQL, causing all fractional values entered for ingredient quantities to be rounded off to the nearest whole number (e.g. "1 1/2" gets rounded off to 0. Fixes ingredient quantity column type in MySQL that caused fractional quantities to get rounded off to the nearest whole number (e.g. 1/2 got rounded off to 0).

  Alternatively, you can issue the following SQL command:

  ALTER TABLE 'ingredients' CHANGE 'qty' 'qty' DECIMAL(10, 5) NOT NULL;

  ...and update your existing ingredient quantities.

  You do not need to upgrade if you're using Postgres as your database.

  Thanks to Steve Moore for reporting and fixing this bug.

v1.1 - 2 December, 2003

• SMTP support: you can now choose between SMTP and sendmail for sending email. Uses the Net::SMTP Perl module.

• Wildcard searches: you can now use a standard asterisk (*) as a wildcard character in recipe and user searches.

• Module detector: checks to see if you have the required Perl modules installed. Located at util/test-modules.cgi

• Added an entry for pounds to the units table. Ingredients measured in pounds actually show up now.

  Thanks to marcottej for reporting this bug.

• Fixed orphaned recipe. If a recipe was submitted with all data present and valid but with a bad ingredient format, an orphaned recipe with incomplete or no ingredient entries would result.

• Fixed the regular expression that checks the format of ingredients. Mixed fractions (e.g. 1 1/2) are now accepted as they should be.

  Thanks to marcottej for reporting this bug.

• Apparently AUTO_INCREMENT column values in MySQL 4.x start with 1 instead of 0. As the default master category's ID number must be 0, it caused the category system to barf on said database. This has been fixed (with a work-around in ReciPants, not in MySQL itself).

  Thanks to marcottej for reporting this bug.

• Added necessary config options and flags for SMTP support.

• The Instructions formatter is a little more forgiving now as it translates any number of contiguous line breaks into one.

• Added more character escapess to the file name escaper for exported recipes, making it more robust.

• Embedded CSS in printer-friendly HTML exported recipes to make saving easier (each exported file is now self-contained).

v1.0.1 - 23 September, 2003

• Added regex check to ingredient format

• Database schema: Fixed ingredients.qty column type (int -> numeric)

• Database schema: Added index on ingredients.recipe_id

v1.0 - 23 September, 2003