File: ChangeLog

package info (click to toggle)
opendb 0.62p9-3
links: PTS
area: main
in suites: sarge
size: 3,544 kB
ctags: 3,560
sloc: php: 26,575; sql: 1,982; sh: 250; makefile: 54
file content (6842 lines) | stat: -rw-r--r-- 285,042 bytes
0.62p9
------
* lang/english.inc.php
	Missed changes to this file when applying changes for 0.62p8.
	Refer to docs/lang-patch/english.inc.php-0.62p9.php for more
	information.

0.62p8
------
* functions/parseutils.php::is_nonword_char($c)
	Minor fix to include '.' as non-word character.

* site/freedb/functions.php
	Integrate patch #935991 and minor fix for Initcap of roman numerals
	as well.

	Minor fix for when DYEAR= and/or DGENRE= are not defined.

* site/imdb/index.php
	Minor update.

* site/imdb/functions.php
	Fixed to parse image correctly due to minor change to IMDB page code.
	Updated to support new imdb listing format for Show All Items functionality.
	
* functions/email.php
	Fix Bug #863880 to ensure \r\n line endings for all email.
		
0.62p7
------
* item_display.php & listings.php
	Minor update to reorder the actions to correspond with the
	changes made in 0.80.  The Update Item Instance action is
	first, to make it more accessible.
	
* functions/Snoopy.class.inc
	Replaced with v1.01 in file named Snoopy.class.php

* functions/http.php
	Updated to use the new Snoopy class.
	
* patch/install/opendb.sql
	Updated user table definition to be in line with the
	0.5X to 0.62 patches for the language and theme columns.

* item_add.php
	Minor fix to support titles with double quotes.

* functions/Listing.class.inc
	Fix for alphalist problem when run with a theme like
	obsidian.  Supercedes patch #823369.

* functions/widgets.php & admin/s_attribute_type/config.php
	Added support for the 'star_rating' widget, as used to display
	the IMDBRATING attribute.

* lang/english.inc.php
	Minor updates as part of the rename to 'Open Media Lending Database'.
	See the docs/lang-patch/english.inc.php-0.62p7.php for more information.
	
0.62p6
------
* stats.php
	Fix for s_item_type's with a '+' character, such as 'DVD+R'

* functions/site.php::get_site_blurb_chooser(...)
	Added nl2br(...) around the blurb, so it displays in way that is approximate
	to how it will be displayed in item_display.

* export.php, backup.php & logfile.php
	Modified headers to work around an IE SSL problem with downloading
	attachments.  The workaround was identified in the following
	article:
		http://www.squirrelmail.org/wiki/en_US/InternetExplorerDownloads
	and is related to Microsoft KB article:
		http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B323308

* theme/default/index.php & theme/default/index.framed.php, theme/horizontal/index.php
	Added a theme_graph_config() function with configuration matching the recommendations
	in the docs/notes/themes.txt document.

* functions/widgets.php
	Updated format_help_block(...) _format_help_list(...) functions to remove
	initial UL for top level, as it was superfluous, and caused unecessary
	indenting.
	
* item_input.php::get_edit_form(...)
	Added a trim around call to format_title_grammar_article, to ensure that
	refresh is not indicated, just because of a whitespace.
	
* site/imdb/index.php & site/imdb/functions.php
	Modify so that if get_imdb_title_id(...) returns a page, it is passed into the 
	get_imdb_common_titles_list(...), which queries the same page anyway.  Also
	modified All titles listing, so it does not return anything for 'Video Games',
	since the IMDB plugin is not configured to support them.  Added IMDB User rating
	as attribute 'imdbrating', while there is currently no s_attribute_type in OpenDb, for
	this value, it may be required in the future.

* item_review.php
	Added 'Back to Listing' links to item review page, so its easier to review a whole
	set of items, without having to go back to item_display, just to get back to the
	listing page.
	
* site/freedb/functions.php::get_freedb_entry_details($cat, $id)
	Updated to use regular expression matching which is easier to maintain.  Also
	fixed a bug, where a second DTITLE= line was not being appended to the 
	item title.  

* site/freedb/functions.php::get_freedb_entry_details($cat, $id)	
	Modified to remove any extra space between words, as for entry: 
		http://www.freedb.org/freedb/blues/dc12170f

* patch/install/opendb.sql, patch/0.60/patch.php, patch/0.54/patch_before.sql
	Updated s_status_type descriptions for 'A' - 'Available' and 'N' - 'Inactive',
	to correspond with the text of the button.

* logfile.php
	Added @set_time_limit(600); in appropriate place.

* admin/s_attribute_type/index.php
	A minor fix	to the 'delete' option to remove extra Attribute Dropdown list
	widget.
	
* admin/s_item_type/index.php
	Moved SQL link to a button as it improves the interface.  Removed the
	admin/s_item_type/sql.gif image as a result.
		
0.62p5
------
* site/imdb/functions::parse_imdb_data($id)
	Minor fix for cast parsing problem.

0.62p4
------
* site/imdb/functions.php::parse_imdb_list_block($block, &$offset)
	Fixed a parsing error introduced by IMDB site changes.

* patch/lang/english.sql
	Removed reference to s_item_type.title_prompt which was removed from
	the table in 0.60.
	
0.62p3
------
* stats.php, chart.php, functions/chart.php (new)
	Updated the stats.php to generate the charts itself, so that the chart data does
	not have to be included in the IMG tag, and break IE as a result.

0.62p2
------
* site/imdb/functions.php
	Updated to support new IMDB page format changes.

0.62p1
------
* functions/widgets.php::filter_input_field($s_attribute_type, $input_type, $value)
	Added a $value = replace_newlines($value); statement to remove all windows / mac
	newlines - this should be done before the insert_item process, as we want to do
	things like compare items (for refresh op, etc)

* functions/theme.php::get_user_theme_r()
	Updated to support themes with a '.' in them.

* functions/site.php::get_site_type_r()
	Updated to support site plugins with a '.' in them.
		
0.62
----
* patch.php & patch/*/patch.php
	Minor change, from 'display=true' for preview, to 'preview=true', which makes a bit
	more sense.
	
* functions/Listing.class.inc
	Minor addition for endListing(...) method, to include an alternate No Records found
	message.  Also fixed a minor bug with alphaListing and navigation.	

* user_admin.php
	Minor update to support $CONFIG_VARS['email.use_php_mail']=FALSE

* borrow.php
	Minor change, to utilise Listing.class.inc support Checkbox column.
		
0.62rc4
-------
* user_admin.php
	The user theme and user language input fields should default to the value specified
	in the include/config.php file ($CONFIG_VARS['site.theme'], $CONFIG_VARS['site.language'])
	not the values currently in use by the Administrator.  This has been fixed.

0.62rc3
-------
* user_admin.php
	Added if(is_user_author($uid)) before executing delete_author_reviews($author_id)

* functions/review.php
	Updated delete_author_reviews($author_id) and delete_reviews($item_id) to ignore the
	number of items updated by the delete, but to just check the status of the operation
	when logging.  Zero items affected just means there were no items to delete that
	matched the where clause.
	
* functions/item.php::delete_item($item_id)
	Minor opendb_log call update.	
	
* listings.php & include/config.php
	Introduced support for some new variables:
		$CONFIG_VARS['listings.show_reserve_action'] = [TRUE | FALSE ];
		$CONFIG_VARS['listings.show_add_to_reserve_basket_action'] = [TRUE | FALSE | 'IF_NOT_EMPTY' ];
		
	These will be used to control what Reserve/Reserve basket operations
	should be available on the listings page, now that multi page selection
	capabilities are available.  Check the include/config.php for more information.

0.62rc2
-------
* include/menu.php
	Minor bug with menu logic added in rc1.  The 'My Reserve Basket' was
	permanently disabled.  Minor bugs in the All Reserved Items and
	All Borrowed Item logic were also fixed.
	
* include/config.php
	Had accidentally disabled reservation basket, which is why I did not
	indentify the above bug either.	

* functions/borrowed_item.php
	The is_exists_borrower_reserved, is_exists_borrower_borrowed, 
	is_exists_borrower_history and is_exists_borrower_borrowed_item
	did not actually do what they were supposed to.  THis has been
	rectified.
	
0.62rc1
-------
* listings.php, functions/listings.php, functions/Listing.class.inc,
  borrow.php, admin/s_atttribute_type_lookup/index.php, item_display.php,
  item_borrow.php, functions/user.php, email.php, functions/borrowed_item.php
  	Replaced listings logic with Listings.class.inc.

	Added the following configuration variables for the various pages that
	use Listings.class.inc.  They allow the control of what type of
	listings are generated, specifically to do with the navigation controls,
	such as Alpha List, Item Type select, next/previous, page no's, etc.  The
	values are 'POST' (Default) or 'GET'.  The original functionality within
	OpenDb had the navigation controls using a GET form, so that the browser
	BACK button could be easily used to facilitate navigation back from
	item_display.php to the listings page.  But now with the full introduction
	of 'Back to Listing', 'Back to Item', etc links, this is not seen as
	being as important anymore.  Administratorss can restore original function,
	by setting these variables to 'GET'.
		$CONFIG_VARS['user_admin.navigation_form_method'] = [ 'POST' | 'GET' ];
		$CONFIG_VARS['listings.navigation_form_method'] = [ 'POST' | 'GET' ];
		$CONFIG_VARS['borrow.navigation_form_method'] = [ 'POST' | 'GET' ];

* functions/Snoopy.class.inc
	Patched to support PHP 4.3.2
	
* logfile.php
	Minor updates.  When doing Backup operation will not display
	logfile after operation, whether success or failure.  This
	has always been annoying, and thus I have removed it.
	
* item_borrow.php
	Added support for $CONFIG_VARS['borrow.reserve_email_only'] = TRUE;  If set,
	the reservations will proceed as normal, except no actual reservation records
	will be inserted.
	
* admin/s_attribute_type_lookup/index.php, admin/s_item_type/index.php
	Simplified interface slightly, and removed dependence on functions/listings.php
	
* borrow.php & functions/borrowed_item.php
	Added 'Reserved' Date column for Reservations listing.
	
* item_display.php, listings.php, item_borrow.php
	Added support for $CONFIG_VARS['borrow.allow_multi_reserve'] and
	$CONFIG_VARS['borrow.allow_reserve_if_borrowed']

* include/menu.php & functions/borrowed_item.php
	Updated Menu to remove menu items which do not have any underlying data present.
	Only done for Borrow functionality at this point.
	
* function/function.php, include/menu.php, theme/default/index.php, theme/default/index.framed.php,
  theme/orange/index.php, theme/horizontal/index.php
  	Small modification to better support $CONFIG_VARS['site.public_access.enable']

* patch.php & item type patches
	Moved Item Type patches (DIVX, Game, Book, etc) to a separate section in the patch
	page.

* patch/0.54/patch_before.sql, patch/0.60/patch.sql, patch/0.61/patch.sql
	Increated size of language and theme columns in user table from varchar(10) to varchar(20)
	size.  This is to support theme and language which might breach this limit, for example
	'orangecream' is already a problem for pre-0.62 versions of OpenDb.
	
* functions/theme.php::is_legal_user_theme($theme) & functions/language.php::get_language_r()
	Updated functions which generate theme and language listings to enforce new 20 character
	limit for the naming of themes and languages.  All names which exceed this 20 character
	limit will be ignored.
	
* functions/parseutils.php
	Updated expand_item_title_mask(...) to use expand_type_title_mask(...) which allows the
	$CONFIG_VARS['item_display.title_display_mask'] to support the same s_item_type/s_item_type_group
	specific mask configuration as $CONFIG_VARS['listings.title_display_mask'].

0.61p4
------
* item_input.php::get_edit_form(...)
	Line 353:
	
	From:
		ifempty($new_value, $old_value));
	To:
		ifempty($new_value, $old_value===FALSE?NULL:$old_value));

* backup.php
	Fix for encoding problem when saving output as file.  Html entities
	were being encoded, when this is unecessary and just plain wrong when
	sabing as file.
	
0.61p3
------
* include/menu.php
	Updated 'Add New Items' drop down list, to select the context s_status_type, if present
	in the $HTTP_VARS array.

0.61p2
------
* listings.php
	Added check for whether item is borrowed/reserved, before including Delete action.  
	This was already in a previous version of OpenDb, but was removed by mistake.

* functions/item_input.php & item_input.php
	Minor update to handle setting borrow duration or status comment to NULL value.  This
	was previously being ignored in update mode.  Modified to specify 'warning' as second
	argument to format_error_block where required.
	
* functions/widgets.php::single_select(...)
	Minor update, to ensure only one option SELECTED.
	
* functions/widgets.php::format_error_block(...)
	Updated to support second argument, indicating the type of error, with options:
	'error', 'warning', 'information'.
	
* item_add.php & functions/site.php
	Minor change to get_ordered_site_type_rs call.
	
* functions/site.php
	Updated so that the order of the site plugin links, match the include/config.pbp
	$CONFIG_VARS['item_add.site_plugin_order']
	
0.61p1
------
* functions/widgets.php::format_listing_link(...)
	Updated to include " around search term, with whitespace.  For example Actor attribute,
	would need to use whitespace, so that if we were looking for Patrick Stewart, we
	do not find Patrick or Stewart, but "Patrick Stewart".
	
* functions/http.php::get_url_fields(...)
	Updated to htmlspecialchars(...) the values, to avoid problems with quotes, etc.  
	Browsers are required to decode entities, before transport, so we can do this without
	concern.

* email.php
	Minor improvements to ensure correct passing of data between requests, especially
	in relation to htmlspecialchars (html entity encoding)

* functions/site.php::get_site_plugin_submit_form(...)
	Modified code to use htmlspecialchars instead of urlencode for Form input fields, this
	change was made, to make this function conformant with http.php::get_url_fields(...)

* email.php
	For security reasons, removed caching of $HTTP_VARS['user_id_rs'] for $op == 'send_to_all',
	as this could allow a user to email to users who are not activated, which is not the
	intention.

0.61
----
* functions/item_input.php::handle_item_delete(...)
	Fixed bug, which prevented linked item being deleted, if parent item, is set to a 
	s_status_type with delete_ind = N.
	
* item_borrow.php::handle_checkout(...)
	Modified to allow checkout of item, even if its s_status_type is borrow_ind=N.  The
	logic behind this type, is that it is up to the Owner at this point to decide whether
	to checkout or not.  The idea of changing an item status_type to one with borrow_ind=N,
	should only prevent new reservations or Quick Checkout.  An existing reservation
	record was obviously created when the item_instance had a s_status_type which 
	had a borrow_ind=Y.
	
* functions/status_type.php, functions/item_input.php, item_display.php
	Changed logic, to allow borrow functionality to be used against items with a s_status_type, that
	has borrow_ind=N, as long as the item is reserved or borrowed.  So the item can be checked out,
	but it cannot be reserved with this status.

* admin/s_status_type/index.php & admin/s_status_type/functions.php
	Modified validations, so as to only be concerned with changing an s_status_type borrow_ind from
	Y or N to X, whereas before we were worried about changing from Y to N or X.  There is no need to
	care about changing to 'N', as items can still be checked out, where borrow_ind=N, as long as
	reservation already exists.

* admin/s_status_type/index.php, admin/s_status_type/functions.php & admin/s_status_type/config.php,
  functions/item.php, item_input.php, functions/item_input.php, functions/status_type.php
	Added support for borrow_ind='B'.  Where item is reserved, and s_status_type borrow_ind=B, do not
	display 'Reserved' Status, but display underlying s_status_type information.  This is because the
	item cannot be checked out, so the reservation is pointless at this point.

* item_display.php, listings.php, borrow.php, item_borrow.php
	If item is set to s_status_type, where borrow_ind=B, ignore Reserved, and display Status type
	info instead.
	
* item_display.php
	Included separate Status Comment column in Instance Info block, as looks a little nicer.	
	
* admin/s_status_type/config.php
	Aesthetic error fixed.
	
* item_add.php
	Minor aesthetic change.
	
* functions/email.php::opendb_email(...)
	Minor change, so that the opendb_log logs the actual From address, as included in the email
	header, including any friendly formatting if added.
	
* logfile.php
	Minor aesthetic change.
	
* patch/0.54/index.php
	Changed order of steps, '3. Update Item Types' and '2. Copy S_FIELD_TYPE values to Attribute Type', as
	the Copy S_FIELD_TYPE values to Attribute Type operation, will actually copy the existing CATEGORY
	s_field_type over, preventing an error being displayed in step, three because it is missing.
	
* item_display.php, listings.php & borrow.php
	Support Quick Check Out for items with s_status_type, where borrow_ind=N.  The logic of this change, is
	that the owner is initiating this operation, and it is almost as if a reservation already exists,
	so if we allow Check Out, for such items, we should allow Quick Check Out as well.

* borrow.php & item_display.php
	New include/config.php variable $CONFIG_VARS['borrow.include_borrower_column'], is provided to control
	whether the Borrower column is displayed.  This variable will only control the 'list_all_reserved',
	'list_all_borrowed' options in borrow.php, but will fully control whether the borrower column appears
	in item_display.php.  This variable is added for privacy/security reasons.
	
* borrow.php & listings.php
	Minor update to have the page footer, outside of the main table, when in Print mode.  Makes the listing
	look a lot neater.
	
* item_display.php
	Added check for whether item is reserved/borrowed before including Status Info delete option.
	
* item_input.php
	Where item delete fails, include Back to Item link.
	
* user_admin.php
	Minor bugfix, to close input type 'Add User' button, with '>'.
	
* listings.php & borrow.php
	Added @set_time_limit(600); when $HTTP_VARS['mode'] = 'printable', so that the complete listing
	can be returned, even if thousands of items.
	
* functions/widgets.php
	Added new function format_confirm_form($PHP_SELF, $confirm_message, $form_field_rs, $HTTP_VARS)

* item_display.php
	Added 'Add Linked' action to Linked Items block, if displayed.
		
* functions/item.php, functions/item_input.php, item_input.php
	Improved Clone Item support, to clone between item types, as well as more control over how
	child items are cloned to the new type.
	
* item_add.php, item_input.php
	Fixed some inconsistencies with the 'Back to Parent', 'Back to Item' links.  From now on
	'Back to Parent' will always be a link to the parent, in item_display, as Back to Item
	currently is.  A new link 'Edit Parent', will be provided where necessary, to provide
	a item_input.php link for the parent.
		
0.60p6
------
* user_admin.php, item_borrow.php, login.php
	Updated tests from $CONFIG_VARS['email.use_php_mail']===TRUE to 
		$CONFIG_VARS['email.use_php_mail']!==FALSE

	This means that the user has to explicitly set this value to FALSE to disable
	it, whereas before it had to be explicitly set to TRUE.

0.60p5
------
* borrow.php
	Modified Printable Version listing link to include all $HTTP_VARS instead
	of hardcoding.  Copied the code from listings.php.  The Thumbnails were not
	being included in the Printable version of the page.

0.60p4
------
* listings.php
	Minor fix to Search Query table, for Category prompt was not being
	displayed.
	
* borrow.php
	Fix for bug #722236, where 'Display Images:' radio button options was
	being displayed for Item History, which does not make sense because
	Item History do not include a Title column.	

0.60p3
------
* functions/http.php::get_site_url()
	Changed:
	//$path = get_http_env("SCRIPT_NAME");
	$path = ifempty(get_http_env("PATH_INFO"),
					ifempty(get_http_env("PHP_SELF"),
					get_http_env("SCRIPT_NAME")));
					
* patch/0.54/patch_before.sql
	The UPDATE item_instance SQL was also causing the update_on column
	to be updated.  Added a update_on = update_on to prevent this.
					
0.60p2
------
* site/freedb/index.php
	Showstopper bugfix to get_site_blurb_chooser call, to use $entry array instead
	of $attributes one.
	
* functions/BooleanParser.inc.class
	Added an extra set of brackets around NOT condition, in build_boolean_clause function.	

0.60p1
------
* admin/s_attribute_type/functions.php
	Bug, where s_field_type was being set to lowercase, in Attribute update.
	
* patch/extras/book.sql
	Minor fix to include delete for s_item_type

* admin/s_item_type/config.php
	Help entry removed, as it no longer applies.  System Item Attribute Types can
	be deleted, even if they have a system s_field_type.

* patch/0.54/patch_before.sql
	Added statement to fix admin/s_attribute_type/functions.php problem:
		UPDATE s_attribute_type SET s_field_type = UPPER(s_field_type) WHERE s_field_type IS NOT NULL;
	
* patch/0.54/index.php
	Added check for CATEGORY s_field_type s_item_attribute_type link.  If missing, display a warning
	with instructions to use System Admin 'Types' tool after upgrade.
	
* functions/item.php
	Modified include for functions/BooleanParser.class.inc
	
* include/begin.inc.php
	Removed newline at end of file
		
0.60
------
* Minor doco changes, and removal of extra whitespace at end of include/begin.inc.php

0.60rc2
-------
* functions/http.php
	Added new is_register_globals_enabled() function, to encapsulate ini_get logic.  This
	logic can then be overruled with a OpenDb config option, so the ini_get() calls are
	not made.
	
* user_admin.php, functions/function.php, logout.php, login.php, listings.php, item_borrow.php,
  borrow.php
	Updated to use is_register_globals_enabled() instead of calling ini_get directly.  A
	new include/config.php variable $CONFIG_VARS['register_globals_enabled'] can be used to
	avoid calling the ini_get(...) function.

* chart.php
	Added @ prefix to ini_get(...), extension_loaded(...), dl(...) calls, to avoid warnings being
	displayed.
	
0.60rc1
-------
* item_add.php, item_input.php, admin/s_status_type/config.php, admin/s_status_type/functions.php,
  admin/s_status_type/index.php, functions/s_status_type.php, functions/item_input.php,
  item_display.php, listings.php
	Removed default s_status_type processing.  If no s_status_type specified, then
	user is looking to make a choice in the item_input.php script from a list of
	s_status_type's.
	
* patch/install/opendb.sql & patch/0.54/patch_before.sql
	Removed activate_to_status & update_to_status columns
	
* functions/widgets.php
	Modified functionality of format_display_value for what circumstances missing %img% 
	is replaced with either display or value.  If %display% is not in mask, then replace
	missing image with display, else if %value% is not in mask, replace with value,
	otherwise replace with empty string.  The original functionality was to replace with
	value.  The 'none' image lookup field option still works.
	
* admin/s_status_type/*.php, item_display.php, functions/item_input.php, functions/s_status_type.php,
  patch/install/opendb.sql & patch/0.54/patch_before.sql
	Updated to support s_status_type.borrow_ind = 'X', to indicate that this s_status_type can not
	have ANY borrowed item records attached.  Whereas borrow_ind = 'N', cannot have any active
	borrowed item records.
	
* functions/email.php
	Updated to support either SMTP or Sendmail type delivery.  The $CONFIG_VARS['email.win32_smtp_email']
	variable will include a To: header, and add no formatting to the mail(...) $to argument.  The
	$CONFIG_VARS['email.friendly_email_format'] variable, controls whether friendly formatting is
	added to From and To addresses.

* functions/status_type.php & patch/dvddbp/index.php
	Removed default retrieve from fetch_status_type_r function.  Only place it was being used, after
	previous revisions in this version was the the DVDDBP patch.  Removed dependency, and enforced
	more strict checking while upgrading, to ensure no items are inserted with a s_status_type that
	the user does not have insert access to.
	
* newuser.php
	The URL to create the user would not actually work, because the confirmpwd value was not being
	supplied.
	
* item_input.php & functions/item_input.php
	Update to force confirmation step for Clone Item.  This is an interim update, for the full
	functionality, to clone to another s_item_type.  Probably will not happen as part of 0.60,
	but at least the user's will be used to having to confirm the Clone action anyway.
	
* functions/widgets.php
	Minor fix, in the event that an attribute has extra spaces in between attribute lookup values,
	they will actually become separate array elements, when explode(...)'d, so they will be
	ignored when building the form.

0.60-dev42p1
------------
* export.php, functions/export.php & item_display.php
	Added new include/config.php variable $CONFIG_VARS['item_display.export_link']
	to configure whether an Export Record link is included in the item_display
	page.

0.60-dev42
----------
* patch/prefix/index.php
	Fix for prefixing, to include s_status_type table.
	
* patch/install/opendb.sql & patch/0.54/patch_before.sql
	Updated some of the indexes to be a bit more efficient.
	
* functions/item.php, patch/install/opendb.sql & patch/0.54/patch_before.sql	
	Increased the size of the item.category field to 100 characters.

* patch/0.54/index.php
	Added an extra step to the 0.54 process.  This step: 5. Lookup Record(s) whitespace removal
	will remove all whitespace from s_attribute_type_lookup.value column.  Any 
	item_attribute's or item.category's that reference the existing value will be updated as
	part of the process.  This patch is intended to pave the way for completely assuming
	no whitespace in lookup values.  We can then automatically explode the item_attribute.attribute_val
	column for lookup values, and process the options from the array, instead of selecting all
	records from the s_attribute_type_lookup table, and seeing if there is a match.
		
* listings.php
	Removed 'list-link' argument from display_type for all
	'Search Query' display widgets.
	
* patch/extras/game.sql
	Updated some of the s_attribute_type_lookup columns to
	remove spaces.
	
* functions/item_input.php
	Minor update
	
* import.php, import/csv.php & include/menu.php
	Merged import.php and import/csv.php into importcsv.php.  The Import plugin 
	architecture will be redesigned as part of a future release.  The existing
	import.php structure was a waste of time.  Updated include/menu.php to point
	to new script importcsv.php.
	
* functions/item_attribute.php & functions/widgets.php::get_display_field(...)
	Because we have provided a patch to remove all whitespace from s_attribute_type_lookup
	value columns, and item_attribute.attribute_val that reference it, we can now safely
	assume that the space is being used purely as a value delimiter in the 
	item_attribute.attribute_val.  So the logic to display things like 'category' now
	selects only those lookup values it needs to.  The comparison is being powered off
	the value itself, instead of the lookup.  We can even manage to display portions of
	the value not found in the lookup table now.  This change will be migrated to the
	rest of the widget functions that need it.

* item_display.php
	Removed 'XML Record' link for child items.  The export.php does not currently support
	exports starting at a child item.  It is easier to remove the option, from item_display.php
	than add support for child items at this point.
	
* include/menu.php & listings.php, theme/default/style.css, theme/horizontal/style.css, 
  theme/orange/style.css
	Updated some CSS class stuff.
	
* functions/parseutils.php
	Added support for specifying 'item_id' as a title mask element.
	
* logfile.php
	Minor aesthetic change.
	
* functions/widgets.php, patch/install/opendb.sql, admin/s_attribute_type/index.php
	Removed check_boxes(...) and radio_group(...) input widgets, in favour of
	checkbox_grid(...) and radio_grid(...) widgets.

* functions/widgets.php
	Updated to support displaying extra attribute values, that do not appear in the
	s_attribute_type_lookup table.	 Formally this would only occur where no
	matches for s_attribute_type_lookup records were found.  The widgets that were
	changed included checkbox_grid & multi_select.
	
* functions/widgets.php, admin/s_attribute_type/config.php
	Added new widget type value_radio_grid.
	
* admin/s_status_type/index.php & admin/s_status_type/functions.php
	Fixed a few problems with the input form, and modified the indicator fields to use
	the new value_radio_grid, instead of the value_select widget.
	
* functions/item_input.php, item_display.php, listings.php, functions/status_type.php,
  item_borrow.php, functions/item.php, item_add.php, functions/whatsnew.php, search.php,
  stats.php
	Fixed some serious bugs with Status Type functionality.
	
* email.php
	Restored the personal naming formatting for the From value.
	
* export.php, export/*.php
	Updated to support displaying a friendly name for the export plugin.  Any occurence
	of an underscore '_' in the export plugin file name, will be replaced with a space
	when the name is displayed.  All the plugins were renamed, to be a bit more friendly.

* admin/s_status_type/index.php
	Added some extra validation when updating the default_ind/closed indicators and when 
	deleting a record, which has default_ind = 'Y).  Also validation when changing 
	the Minimum Create Type, to a type with more access (ie. Normal to Administrator) if
	their are users with items, who have a lesser user type, than the proposed new type
	for Minimum Create Type.
	
0.60-dev41
----------
* user_admin.php & newuser.php
	Implemented some consistency in the User info form.

* stats.php
	As part of the phase out of the Location field, the Location column was
	removed from the Statistics page.  The location, including address 
	information for users will be introduced in a improved fashion as part
	of 0.80.
	
* user_admin.php, functions/borrowed_item.php, user_listing.php, 
  functions/review.php
	Updated User Delete logic to be much clearer.  Also added some new config
	variables to configure how much cleanup is possible to delete a user, before
	too much information is removed, and we should deactivate instead.  Also 
	modified the Deactivate operation for a delete, to not delete any items,
	where a user cannot be deleted.  A user still cannot be deleted where
	borrowed items exist, but there is the option to allow deletes where
	users reviews and inactive borrowed item (Cancelled, Closed) records
	exist.  The include/config.php variables that control this are:
		$CONFIG_VARS['user_admin.user_delete_with_reviews']
		$CONFIG_VARS['user_admin.user_delete_with_borrower_inactive_borrowed_items']
		$CONFIG_VARS['user_admin.user_delete_with_owner_inactive_borrowed_items']
	
* theme/orange/style.css
	Minor aesthetic change.
	
* listings.php
	Minor aesthetic change.

* search.php
	Minor aesthetic change.
	
* functions/excelgen.class.inc & export.php & export/excel.php
	Updated export routine, to dump out to browser after each item has
	been exported, not caching all items to be dumped at the very end. This
	should improve performance, because there is less of a memory requirement.
	
* patch/install/opendb.sql & patch/0.54/patch_before.sql
	Included new audio language options:
		ENGLISH_6.1_DTS_ES - English (6.1 DTS ES)
		ENGLISH_6.1_EX - English(6.1 EX)
		ENGLISH_6.1 - English(6.1)
		
0.60-dev40
----------
* functions/Snoopy.class.inc
	Remove newline at end of file, as appeared to be causing problems in some
	installs.  Also refixed my original Redirect fix for Snoopy, at lines
	817-827.  The value was not getting assigned to the $this->_redirectaddr
	so the redirect was not working correctly.
	
* functions/email.php::opendb_email(...)
	Updated as a result of bug #701160.  According to the 
	http://www.php.net/manual/en/function.mail.php the $to argument to mail(...)
	function should not include formatting.
	
* backup.php
	Fixed bug #702847
	
* logfile.php
	Minor aesthetic change
	
* listings.php
	Owner email back to listing was including some variables that are not normally
	included in a back to listing link.  I removed them as a a result.
	
* functions/parseutils.php
	Minor refactor.
	
* functions/widgets.php
	Changed $file_upload_type_included flag variable in widgets.php to something that
	will stand out a bit more: $_OPENDB_FILE_UPLOAD_WIDGET.

* item_input.php & widgets.php
	Encapsulated the FILE type upload logic, into a function is_file_upload_form().
	Changed item_input.php to use this function, instead of checking the 
	$_OPENDB_FILE_UPLOAD_WIDGET variable.
	
* functions/utils.php & include/menu.php
	Moved get_db_results_array(...) function from utils.php to include/menu.php as this
	is the only place it is used.	

* functions/widgets.php, functions/parseutils.php, listings.php, borrow.php
	Updated format_help_block(...) function to support an image.  Updated parse_title_mask(...)
	to record each occurence of a theme_img, so it can be displayed in the 
	footer of the page, if required.

* user_admin.php
	Updated so that New User password is obsfucated.  I also added a Confirm field
	as a result.
	
* import/csv.php, admin/s_attribute_type/index.php, admin/s_attribute_type_lookup/index.php,
  admin/s_item_type/index.php, admin/cache_admin/index.php, item_borrow.php, item_display.php,
  item_input.php, stats.php, user_listing.php
	Updated to use format_help_block(...) function.
	
* functions/widgets.php
	Bugfix for format_help(...)
	
* images/dts.jpg
	Replaced with dts.gif - smaller size image.  The patch/0.54/patch_before.sql and 
	patch/install/opendb.sql scripts were update to support this.
	
* admin/s_status_type/index.php & admin/s_status_type/config.php
	Updated to include better help.  Also changed most of the input fields from checkboxes
	to Value Select lists.  This is a bit more logical, and also makes it easier to add
	more value options for the indicator fields in the future.
	
* functions/widgets.php
	Updated format_list_from_array(...) to handle empty lines in a cleaner way.  Now most of
	the list types, will actually add a <br> tag for an empty line, instead of a list 
	line.
	
* admin/cache_admin/index.php
	Minor aesthetic change.
	
* listings.php, functions/item.php, functions/widgets.php::format_listing_link(...),
  item_input.php
	Title and Attribute matches are by default Exact.  This was not clear in the listings
	Search Query block, and there are a few issues with how it works now we have introduced
	the BooleanParser library.
	
* site/imdb/index.php & site/freedb/index.php
	Use get_site_blurb_chooser instead of get_site_plot_chooser(...) which has been
	deprecated.	
	
0.60-dev39b
-----------
* login.php
	Added closing _theme_footer(...) call, when user is already logged in,
	this was causing Netscape 4.x to not display anything, as there was
	a hanging table present.

0.60-dev39
----------
* admin.php, functions/admin.php, admin/*/config.php
	Removed $menu_link_image, now it is 'icon.gif'
	
* admin/s_status_type/*
	New Admin Tool for System Status Type functionality.
	
* functions/user.php
	New function get_user_types_rs() added	

0.60-dev38
----------
* functions/theme.php::_theme_header(...), item_display.php, listings.php
	Support $HTTP_VARS['inc_menu'] as second argument.

* user_listing.php, stats.php, listings.php, borrow.php, import/csv.php
	Minor code cleanup
	
* user_listing.php, login.php, patch.php, search.php, item_display.php,
  listings.php, functions/site.php, functions/widgets.php, borrow.php, 
  admin/lang_diff/index.php, admin/cache_admin/index.php
  	Minor code cleanup
	
* logout.php
	Minor update

* newuser.php
	Minor update to include user_add_help
	
* login.php
	Minor update

* search.php
	Minor reformat of layout
	
* functions/widgets.php::format_footer_links($footer_links_rs)
	Minor fix
	
* item_input.php
	Minor fix

* functions/user.php
	Updated both fetch_user_rs and fetch_user_cnt to include logic to exclude 
	deactivated users, but also provided ability to include them via a new 
	argument.

* item_borrow.php & user_listing.php
	Changed arguments for call to fetch_user_rs(...)
	
* item_input.php
	Minor update
	
* functions/http.php
	Minor fix
	
* functions/site.php
	Updated to support more functionality for the $site_attribute_map, including
	s_item_type specific mappings.	Also replaced get_site_plot_chooser(...)
	with more generic get_site_blurb_chooser(...).  A stub for the get_site_plot_chooser
	has been added, to support old plugins.
	
* listings.php
	Minor fix for the s_item_type chooser, which was not working properly, because
	the s_item_type_group LOV was misnamed.
	
* include/language.php
	Support merging $LANG_VARS and $lang_var arrays if they are both defined.  For performance
	reasons only the $lang_var OR $LANG_VARS should be defined.
	
* patch/install/opendb.sql
	Removed AMAZONASIN s_attribute_type from all s_item_attribute_type statements, as Amazon.com
	plugin is not included as part of the default installation for OpenDb, and so including
	this attribute is superfluous.
	
* functions/utils.php::array_search2($needle, $haystack, $strcasecmp=FALSE)
	Updated to support case compare argument.  If $strcasecmp=TRUE, then we use
	the strcasecmp function, which is case INSENSITIVE.

* include/config.php & functions/listings.php
	The $CONFIG_VARS['listings.no_image'] is now a themeable image.  Also moved the images/no-image.gif
	to the theme/default/images directory.
	
* theme/orange/style.css
	Minor change
	
* admin/cache_admin/index.php
	Minor change
	
* item_input.php::is_value_refreshed(...)
	Updated to do case-insentitive comparison for lookup value checking.	
	
0.60-dev37
----------
* include/begin.inc.php, include/menu.php, functions/function.php & login.php
	Added support for public Guest user access to all applicable functionality
	within OpenDb.  To enable, the include/config.php variable $CONFIG_VARS['site.public_access.enable']
	should be set to TRUE, and the $CONFIG_VARS['site.public_access.user_id'] set to a valid AND
	active 'guest' user.
	
* functions/function.php::is_opendb_valid_session()
	Changed to call is_user_active(...) instead of is_user_valid(...)
	
* admin/s_item_type/index.php
	Minor aesthetic changes
	
* theme/orange/style.css
	Minor change to colour sceme for BODY and navbar backgrounds
	
* logfile.php
	Minor aesthetic changes
	
* newuser.php
	Introduced ability to specify password when entering user details.  If the
	password, and Confirm field match, the password specified will be used, otherwise
	the password will be ignored and a password generated.
	
	Modified Email Add User URL, to go via login.php.  The user_admin.php URL to
	add the user is encoded into the 'redirect' URL parameter.
	
* login.php
	Updated New Password function to generate 8 character passwords instead of 5.
	
* user_admin.php
	Added logic into Add User functionality to generate the password, if not specified.

0.60-dev36
----------
* listings.php, item_display.php, item_input.php, borrow.php, user_listing.php,
  stats.php, admin/cache_admin/index.php, import/csv.php
  	Standardised listing header and toggle functionality.
	
* import/csv.php
	Removed 'None' option for Status type column
	
* functions/status_type.php
	When the functions are being used for building a widget, the default_ind column
	needs to be aliases to 'checked_ind'

* functions/widgets.php::get_display_field(...)
	Fixed bug #585349 - 'format_mins' widget is always english
	
* functions/function.php::is_opendb_valid_session() & login.php
	Included if($CONFIG_VARS['site.enable']!==FALSE) to enforce site disable
	option for all pages.  The login.php now checks whether the $CONFIG_VARS['site.enable']
	is set to FALSE, and if so displays an alternative to the normal session is
	invalid message.
	
* include/menu.php
	Fix the get_hierarchical_menu_options(...) function
	
* borrow.php
	Included Reserve Basket help
	
* theme/default/index.php, theme/horizontal/index.php & theme/orange/index.php
	Minor fix
	
0.60-dev35
----------
* include/menu.php
	Fixed Bug #696917 and restructured the if statements to be more
	efficient.

* images/mp3.gif
	Added image contributed by "Luigi" <auracent@bellatlantic.net> 
		
0.60-dev34
----------
* functions/BooleanParser.class.inc
	Fixed BooleanLexer->_nextToken() method, to pass through
	any \\ escaped characters, with \\ retained, regardless
	of what other characters were involved.
	
	Fixed build_boolean_clause(...) to handle NOT for negating 
	string comparisons.

* functions/borrowed_item.php
	Minor update

* functions/widgets.php
	For listing links from item_display.php, include linked items
	as well.
	
* listings.php
	Minor update to Query Search display table.
	
* item_display.php
	Added Edit links for linked items.  Uses context item_instance for
	edit linked item permissions.
			
0.60-dev33
----------
* functions/item.php::from_and_where_clause(...)
	Minor update for matching wildcards in attributes.

* listings.php
	Aesthetic changes
	
* include/menu.php
	With introduction of the 'Status' Drop down list in the
	listings page itself, we could get rid of all but one LOV
	in the menu.  This cleans up the menu a lot.
	
* theme/horizontal/index.php
	Minor Aesthetic change

* listings.php, search.php & item_display.php
	Changed $LANG_VARS['status'] to $LANG_VARS['s_status_type']

* functions/item.php && functions/BooleanParser.class.inc
	Added boolean query search functionality.
	
* functions/widgets.php, search.php
	A new format_help(...) function has been added to widgets script.  Replaced
	custom help code in search.php with call to this function.  Other scripts
	will follow suit, as I get to them.
	
0.60-dev32
----------
* logfile.php
	Minor aesthetic updates.  Also replaced call to custom get_filename function with
	PHP basename(...) function.

* admin/lang_diff/index.php
	Replaced print_r call with custom function to display the $LANG_VAR entries in
	a more accessible way.  Also added the ability to do a diff against the current
	OpenDb language pack, without specifying it.
	
* include/menu.php
	Updated logic to allow links even if no-one is authenticated.  The individual themes
	will have to be updated to generate the menu options from get_menu_options(...)
	even if $HTTP_SESSION_VARS['user_id'] is empty.
	
* theme/default/index.php, theme/default/index.framed.php & theme/orange/index.php

* functions/whatsnew.php::whats_new($update_on, $user_id=NULL)
	Minor aesthetic changes.
	
* functions/status_type.php::fetch_newitem_status_type_rs($owner_id)
	Fix to include s_status_type's with a activate_to_status column value by default, but
	a second parameter '$inc_activate_to_status_types' when set to FALSE, will include
	an extra clause 'AND LENGTH(IFNULL(sst.activate_to_status,''))=0' to remove all
	non-activated s_status_type's from the list returned.  This was broken in 0.60-dev31.
	
* item_input.php
	Updated to use second parameter to fetch_newitem_status_type_rs, to remove all
	non-activated s_status_type's from set returned.  Added 'Add {s_status_type} Item'
	link once an Insert operation is successful, to allow a user to add a new item
	of the same type straight away.
	
* item_input.php & functions/item_input.php
	Replaced is_user_owner_of_item(...) calls with direct owner_id = user_id comparison
	checks, which saves a database check.	

* functions/utils.php & include/menu.php
	Renamed function prc_db_results_to_array(...) to get_db_results_array(...), and added
	extra parameter, to allow the prefixing of an element to the array.	

* listings.php & functions/listings.php
	Refactored the Item Type & Group Lov's section to include a Status and Owner LOV.
	
0.60-dev31
----------
* item_input.php, item_display.php & listings.php
	Revised the Activate/Update item functionality to be more generically Update item
	functionality, with special support for a different message if the s_status_type
	goes from deactivated (length(activate_to_status)>0) to activated.
	
* export/xml.php
	Change to use custom escape_xml_entities function instead of addslashes, as addslashes
	does not produce valid XML.
	
* export.php
	Removed all replace_newlines(...), as we can assume that the data should have gone into
	OpenDb with replace_newlines(...) applied against it.  This is not true for older
	versions of OpenDb, but since the import / update functionality does it, this will
	soon be true for old data as well.  Slight performance improvements would be a result
	of this decision.

* functions/utils.php & functions/widgets.php
	Moved replace_newlines(...) to functions/utils.php.  Removed trim functionality from
	this function, as that was not its intention.
		
* functions/item_attribute.php, item.php, functions/review.php, widgets.php
	Moved replace_newlines(...) processing back into the low level insert functions,
	as it should happen in all cases, and is not a high level filtering function,
	like the widget specific filters that need to be applied.
	
* item_input.php & functions/item_input.php
	Removed much of the specific 'Activate' logic in favour of a more generic solution,
	including better 'Update Item Instance' functionality, to allow a user to update
	things like the status type and status comment without updating anything else.
	
	The only mention of 'Activate' will be when an item is updated from being a 
	non-activated item to a activated item.
	
* functions/status_type.php
	With the changes to do update instead of activate specific logic, the current
	s_status_type can be displayed in the form.  So the logic for the 
	fetch_update_status_type_rs(...) and fetch_activate_status_type_rs(...) functions
	was updated to support this.  Also some other revisions to actually make the
	logic always return the current s_status_type even if it no longer fits the 
	configuration, or is closed.
	
0.60-dev30
----------
* item_input.php::handle_confirm_item_instance_activate(...)
	A fix that was preventing non-admin owners from activating their items
	
* functions/item_input.php::handle_activate_item_instance(...)
	Fixed problem with issueing warning when status comment is used for
	s_status_type's that do not support it.
	
* include/menu.php::get_table_menu_options(...)
	Minor aesthetic change
	
* listings.php & item_display.php
	Minor modification to allow use of this script without the menu
	being included.  This is a requirement for the duplicate title support
	being added to item_Input.php.
	
* functions/item.php::is_exists_title(...)
	Fixed check, so that an item is not visible, unless s_status_type' of the
	item is visible to the current user.
	
* functions/item.php::fetch_child_item_rs(...)
	Altered order_by so that linked items are ordered by item id (ordered added to parent),
	instead of by title.
	
* functions/widgets.php::format_footer_links(...)
	Added support for a javascript popup link
	
* item_input.php
	Completed duplicate title support.  Added 'List Duplicate Item(s) link.
	
* admin/cache_admin/index.php
	Added update_who to opendb_log calls	
	
0.60-dev29
----------
* include/menu.php
	Renamed get_menu_options_with_images(...) to get_menu_options(...). Replaced
	get_menu_options_with_images(...) with stub to call new get_menu_options(...)
	
* listings.php, search.php, functions/item.php
	Added ability to order by s_status_type
	
* admin/cache_admin/cache_admin.gif & admin/lang_diff/lang_diff.gif
	Added transparent background, so it fits more seamlessly into
	non-white background themes.
	
* theme/horizontal/index.php
	Removed theme_image_src(...) override function, as this was a silly idea.

* functions/theme.php::_theme_image_src($src)
	Updated to logic, to look in 'default' theme directories for images, if not
	found in context theme, before resorting the the images/ directory.
	
* functions/widgets.php::format_action_links(...)
	Modified logic, so that a NULL return from a theme specific theme_image function
	will cause the default
	
* include/config.php & functions/item_input.php
	Removed include/config.php $CONFIG_VARS['item_input.confirm_duplicate_not_owner_insert'],
	instead using the original $CONFIG_VARS['item_input.confirm_duplicate_insert'] for this
	site wide duplicate confirmation, and added a new $CONFIG_VARS['item_input.confirm_duplicate_owner_insert']
	variable for owner duplicates.  This will require users to update their configuration, as this
	is not the original intention of the $CONFIG_VARS['item_input.confirm_duplicate_insert'] configuration
	variable, but does make sense.  Added new configuration variable $CONFIG_VARS['item_input.confirm_duplicate_linked_item_insert']
	for configuring whether linked item duplicate title inserts should be confirmed or not.

* item_display.php & item_input.php
	Added title mask support for titles in Linked Item section.  Also did some minor reformatting of the
	item_input Linked Item table.	
	
0.60-dev28
----------
* functions/http.php
	Minor fix

* listings.php
	Minor refactoring
	
* functions/Snoopy.class.inc
	Minor bugfix

* borrow.php & include/config.php
	Removed $CONFIG_VARS['borrow.show_item_image'] include/config.php variable.  The
	$CONFIG_VARS['listings.show_item_image'] variable can be used to configure both.
			
* listings.php & borrow.php
	Added Display Images: 'Yes' / 'No' functionality.
	
* login.php & logout.php
	Minor update
	
* email.php
	Removed display of Site Admin Name/Email in favour of generic 'Site Administrator'
	to value instead.  The email gets sent to the site administrator, but this way
	the email address of the admin user is not available to non-opendb users.

* item_borrow.php, borrow.php, listings.php, user_admin.php, login.php & logout.php,
  functions/function.php
	Updated to support PHP 4.3.0 with register_globals=Off
	
* functions/borrowed_item.php, borrow.php, item_borrow.php
	Added Borrow Duration extension logic.  Also modified get_borrow_details function
	in item_borrow.php to specify a days value for Borrow Duration (check-out,reminder,extension),
	instead of the display value from DURATION attribute.  This allows for borrow_durations
	not available in the lookup table.
	
* import/csv.php, functions/item.php, functions/item_input.php
	Updated is_exists_title, so that both $parent_id and $owner_id are
	optional parameters.  Also swapped order of parent_id and owner_id
	parameters, so that parent_id is last.
	
* functions/item_input.php & item_input.php
	Updated to support duplicate title checking across owners.  Functionality to
	list the duplicate titles has not yet been added.  It should be there in time
	for dev29 or dev30.	  You can enable this functionality by setting the include/config.php
	variable $CONFIG_VARS['item_input.confirm_duplicate_not_owner_insert'] = TRUE.
	
* export/xml.php
	Minor update
		
0.60-dev27
----------
* functions/patchutils.php, patch/0.54/index.php & patch.php
	Renamed functions with backwards compatible stub:
	
		exec_sql(...) to exec_patch_sql(...)
		exec_sql_file(...) to exec_patch_sql_file(...)
		print_sql_file(...) to echo_patch_sql_file(...)
		
* functions/function.php::parse_sql_statement(...)
	Updated to support complete ALTER TABLE and RENAME TABLE syntax.
	
* functions/listings.php, borrow.php, listings.php, user_listing.php, 
  admin/s_attribute_type_lookup/index.php
	Renamed functions:
		print_footer to get_list_footer 
		print_alphanumeric_sorter to get_list_alpha_sorter
		display_lov_of_types to get_list_lov_of_types
	and return a buffer string, instead of echo that out as part of the function.
		
* listings.php, borrow.php
	Moved printable link below help section.
	
* user_listing.php
	Minor aesthetic change
	
* include/begin.inc.php & include/end.inc.php
	Added support for output buffering.  This will be especially useful when used in
	conjunction with the ob_gzhandler which compresses the web page for transmission.
	The ob_gzhandler was added to PHP in 4.0.4.  This functionality is configured
	via the new include/config.php variables $CONFIG_VARS['output_buffer.enable'] and
	$CONFIG_VARS['output_buffer.handler'].  The functionality is disabled by
	default.
	
* include/begin.inc.php & functions/function.php
	Updated the $CONFIG_VARS['session_handler.?????'] set of variables to be a complete
	set of information for a database connection, instead of getting the run_opendb_query
	function to fill the missing information from the $CONFIG_VARS['db_server.?????']
	variables.  This should improve performance slightly for session operations.
	
* include/session.php, patch/session/index.php, include/begin.inc.php
	Updated to default variable $CONFIG_VARS['session_handler.session_table'] to 'php_session'
	once in the include/begin.inc.php script.  This allowed the removal of the default
	logic from everywhere else.
	
* patch.php
	Minor fix	
	
0.60-dev26
----------
* search.php, include/menu.php & item_input.php
	If only one s_status_type record defined for OpenDb, no s_status_type
	selection widgets will be generated.  This will allow sites, who are
	not interested in multiple status types to more conveniently ignore
	them.
	
* theme/default/index.php, theme/default/index.framed.php, theme/horizontal/index.php & 
  theme/orange/index.php
	Updated to generate menu using tables.

* functions/menu.php deleted
	Function moved back to include/menu.php
	
* item_borrow.php
	Added functionality to expand the item_r title mask according to the
	$CONFIG_VARS['item_display.title_display_mask'] variable.
	
* functions/review.php, item_review.php
	Use $CONFIG_VARS['item_display.title_display_mask'] for title display.
	
* functions/item_input.php
	Updated handle_item_update to support refreshing for title,category,etc
	as well as normal attributes.		

0.60-dev25
----------
* admin/s_item_type/index.php
	This tool would not allow the insert of new attributes, as a result of the
	0.60-dev21 changes.  Also the STATUSTYPE and STATUSCMNT fields were not being
	inserted correctly.  All this has been fixed.

0.60-dev24b
-----------
* borrow.php
	Minor bug with 'All Reserved Items' / 'All Borrowed Items' introduced as part of
	0.60-dev24, has been fixed.

* item_display.php
	Fix to include Borrow links into Instance Info section.  These were accidentally 
	disabled as far as the 0.60-dev21 changes.

0.60-dev24
----------
* item_input.php, admin/s_item_type/functions.php, admin/s_attribute_type_lookup/functions.php,
  admin/s_attribute_type/functions.php, functions/item_input.php, functions/user.php,
  functions/review.php, functions/item_attribute.php, functions/item.php, functions/borrowed_item.php,
	Moved the update_who to the end of the opendb_log value list.

* login.php
	Disabled new password request functionality for guest users.
	
* functions/email.php
	Minor aesthetic changes.
	
* email.php
	Introduction of a new operation send_to_site_admin to allow non-opendb users to
	send email to the site Administrator.  This is the only email access
	available to non-opendb users.
	
* patch/install/opendb.sql
	Minor bug with the S_DURATION 'Undefined' lookup value.  It should be an empty string,
	but it was set to a '0'
	
* patch.php
	Allow Administrator users to access the patch facility even if disabled, as long as
	the new include/config.php variable $CONFIG_VARS['patch.allow_admin_override'] === TRUE. 		

* export/csv/index.php
	Updated to export Prompt instead of data headers.	
	
* import/csv.php
	Changed functionality of 'Define CSV Column mappings' page, so that if the first row in
	the CSV file has columns names which patch the Item attribute $fieldname or the item 
	attribute prompt, that column is automatically chosen.  This allows users to export
	their items via CSV, and Import them into another database with a minimum of fuss.
	Obviously once Import XML is supported this process will be even easier.
	
* borrow.php, listings.php, functions/listings.php & item_display.php
	New function get_list_username(...) in functions/listings.php added to the other scripts
	to replace the same owner/borrower listing code used in all of them.
	
* borrow.php
	Added Owner column to 'All Reserved Items' & 'All Borrowed Items' listings
	
* include/menu.php, include/theme.php, functions/menu.php
	Moved get_menu_option_form($option) to functions/menu.php.  Updated include/theme.php
	to include functions/menu.php
	
* theme/horizontal/index.php
	Updated theme_menu(...) for a neater layout using a borderless table.
	
* admin.php
	Added include for 'include/end.inc.php'.

* admin/cache_admin/index.php & admin/lang_diff/index.php
	Removed any includes for 'include/begin.inc.php', 'include/end.inc.php', etc.
	
0.60-dev23
----------
* login.php
	Disabled New Password operation for deactivated users.

* user_listing.php, user_admin.php & include/config.php
	Added configuration variable $CONFIG_VARS['user_admin.user_delete_support'],
	with options [FALSE | TRUE | 'deactivate'].
	
	If TRUE, then a user delete process is possible, but if any items have
	borrowed items attached, or the user has authored reviews, the user
	will be deactivated instead, after all items that can be removed, are.
	
	If 'deactivate', will only cancel reservations and clear user password, thus
	causing the user to become deactivated.
	
* email.php, functions/email.php & config.php
	Modified logic for $CONFIG_VARS['email.format_email_addr'].  By default this
	variable is disabled, but if set to FALSE, it disables the 'Name <email@host.com>'
	formatting, in favour of just the 'email@host.com' formatting.  This is directly
	opposite to its original functionality.  The original use of this variable was
	illogical, and did not make sense, because the default was to include formatting,
	whereas the name of this variable was indicating otherwise.  I also removed the
	double quotes around the name, as I do not believe they are necessary.
	
	Also fixed small error in send_email(...) function where the errors coming from
	opendb_email(...) were not being displayed.

* include/begin.inc.php & include/end.inc.php
	Updated the error_reporting call to try and enforce the removal of E_NOTICE error
	messages, which has not worked in some cases so far...
	Updated it to: 
		error_reporting(E_ALL & ~E_NOTICE);	
		
* functions/user.php & user_admin.php
	Added a new function deactivate_user($uid) which calls update_user_passwd with a
	NULL password at this point.  The user_admin.php script uses this function to
	deactivate the user instead of calling update_user_passwd directly.
	
0.60-dev22
----------
* admin/s_attribute_type/index.php, admin/s_attribute_type/functions.php,
  admin/s_item_attribute_type/index.php, admin/s_item_attribute_type/functions.php,
  admin/s_item_type/index.php, admin/s_item_type/functions.php
	Updated to remove $uid parameter from insert/update/delete functions in favour
	of using $HTTP_SESSION_VARS['user_id']

* admin/s_attribute_type/index.php
	Modified functionality to allow editing of reserved (S_ prefixed) s_attribute_type's,
	but only the prompt.

* export.php, functions/item_input.php, import/csv.php, item_input.php
	Where the item_type structure is incorrect, the language variable being displayed
	was ambiguous.  All references to $LANG_VARS['invalid_item_type'] have been replaced
	with $LANG_VARS['invalid_item_type_structure'], where the is_valid_item_type_structure(...)
	function returns false.
	
* stats.php
	Minor aesthetic changes.
	
* functions/parseutils.php
	Removed 'active_ind' title mask variable backwards compatibility support.  This variable
	was added as part of 0.55-dev anyway, so its removal will not affect those still on
	0.54.  All the other people who have upgraded to 0.55/0.60 were warned of its lack
	of support and instability, so I do not have to concern myself with maintaining
	backwards compatibility for them.
	
* stats.gif, listings.gif, item_display.php, borrow.php
	Renamed unavail.gif to borrowed.gif to better represent the meaning of this status
	image.  The unavail.gif images in the themes were renamed as a result.
	
* item_display.php
	Changed Instance Info Borrower column logic, to display 'Current User' language variable
	if the current user is the borrower.
	
* functions/widgets.php::saveurl(...)
	Updated Saveurl	checkbox CHECKED logic, to check for is_url_absolute(...) instead of
	$local_url being empty, which may mean the existence of a invalid local url because
	the image has been deleted outside of OpenDb.
	
0.60-dev21
----------
*.php,*.sql
	All references to 'status_ind' and 'status_ind_desc' have been
	updated to 's_status_type' and 's_status_type_desc' respectively

* chart.php
	Applied patch provided by Andrew Donkin, to fill the bar graphs, 
	relative to the largest graph.  So for instance where there are 
	a lot of bars, and the largest is 40%, it normally sits near the
	bottom of the graph.  Now the 41% graph is the height of the graph
	itself, and the rest of the graphs are relative to this tallest 
	one.

* docs/notes/session_handler.txt
	Updated documentation.
	
* include/menu.php
	Updated some of the menu entries, in relation to Status Indicator
	listings.

* search.php, functions/widgets.php & listings.php
	Revised Status Indicator Listing, Search Listing and Attribute 
	Listing operations.
	
* item_input.php, functions/item_input.php, functions/item.php, listings.php, 
  search.php
	Renamed call to is_valid_s_status_type(...) from is_valid_active_ind(...)
		
* user_listing.php, stats.php, borrow.php, export.php, item_add.php, item_display.php,
  item_input.php, listings.php, search.php, site.php, include/menu.php, export/xml.php,
  import/csv.php, include/config.php, docs/opendb-items.dtd, docs/title_masks.php,
  docs/item_instance.txt, functions/item_input.php, functions/widgets.php, functions/item.php
  functions/whatsnew.php,functions/export.php,functions/borrowed_item.php, functions/item.php 
    Updated to use s_status_type, instead of active_ind
    
* patch.php
    Updated layout and structure of patches, as well as comments, regarding
    upgrade path options.
		
 * import/csv.php
    Changed CSV import to use fgetcsv function, instead of custom
    function.  This function supports Excel CSV format, where any
    column value which includes the delimiter, will be enclosed in
    double quotes.  Any value which includes a double quote, will have
    the double quote escaped.

 * export/csv.php & export/excel.php
    function row_item($rows), should be function row_item($columns)
    And function data_header($headrow) should be data_header($columns)
    
* patch/install/opendb.sql
	Updated item_instance table definition with 's_status_type' instead of
	'active_ind'

* listings.php & borrow.php
	Updated to use is_user_allowed_to_borrow, instead of !is_user_guest
	
* functions/user.php
	New function get_min_user_type_r($user_type)
	
* listings.php, functions/status_type.php, search.php, backup.php,
  item_add.php, item_borrow.php, item_display.php, export.php,
  functions/export.php, stats.php, functions/item.php, functions/whatsnew.php,
  user_admin.php
	Updated to support new s_status_type table functionality.		
		
* email.php
	Replaced is_user_at_usertype(...) call with get_min_user_type_r(...)
	and in_array comparison.
	
* functions/borrowed_item.php
	Removed function fetch_item_location($item_id, $instance_no)

* functions/item.php
	Removed is_item_instance_active($item_id, $instance_no)	
	Updated fetch_item_instance_rs(...) to join to s_status_type
	
* chart.php
	Minor fix, for barchart generation, where no categories are
	defined for the s_item_type.  An empty pie chart was being
	generated, this has been fixed.
	
* functions/user.php
	Updated fetch_user_rs(...) to return a 'D' for type, if user
	has been deactivated.	
	
* include/config.php
	Removed the following variables:
		$CONFIG_VARS['wishlist.enable']
		$CONFIG_VARS['wishlist.new_instance_wishlist_support']
		$CONFIG_VARS['item_input.confirm_wishlist_activate']
		
* functions/whatsnew.php & include/config.php
	Added new variables to configure what gets shown in the
	whatsnew page.
	
	To disable the Reviews Added status:
		$CONFIG_VARS['whatsnew.review_stats'] = FALSE;
	To disable Borrow Returns / Reserves, etc:
		$CONFIG_VARS['whatsnew.borrow_stats'] = FALSE;

* functions/item_type.php, functions/item_attribute.php,
admin/s_attribute_type/*.php, admin/s_item_type/*.php
	Updated to support move of s_field_type column from
	s_item_attribute_type to s_attribute_type table.
	
* import/csv.php, functions/item_input.php, item_input.php,
  item_display.php, admin/s_item_type/functions.php,
  item_borrow.php, borrow.php,
	Replaced:
		fetch_title_attribute_type_r($s_item_type)
		fetch_status_attribute_type_r($s_item_type)
		fetch_category_attribute_type_r($s_item_type)
		fetch_duration_attribute_type_r($s_item_type)
		fetch_image_attribute_type_rs($s_item_type)
		fetch_title_attribute_type($s_item_type)
		fetch_category_attribute_type($s_item_type)
		fetch_duration_attribute_type($s_item_type)
		
* item_input.php, functions/item_input.php, import/csv.php,
patch/dvddbp/index.php, functions/item.php
	Added initial support for status_comment column in
	item_instance.  The item_input support will have to be
	finalised along with the s_status_type.
	
* include/menu.php
	Removed Wishlist specific logic.  Updated to show a LOV for
	Add New Item, List All Items, List My Items, List Other Items
	links.  These lov has all applicable s_status_type's.  Have
	only modified get_menu_options($uid, $user_type)

* item_review.php, functions/review.php
	Updated to support Update/Edit operations.  The 0.54 patch was
	also augmented to convert the review table, to include a 
	sequence_number column.
	
* widgets/format_display_value(...)
	Updated so if an img value is specified, but it does not resolve
	to a _theme_image, will replace the %img% variable with the
	display column, or if display not defined, the value column.  This
	is is contrast to when an img is not specified, and value is used
	to replace the %img% variable.
	
* Copied images/wishlist.gif, images/images/hidden.gif,images/ordered.gif, 
  images/avail.gif, images/unavail.gif, images/inactive.gif, images/reserved.gif
  to themes/default and themes/horizontal
  Deleted from the images/ directory.  From now on each theme, will have to provide
  their own.  The status' stuff will still work, because a text value will be
  displayed instead.

* chart.php
	Modified code to load 'gd' extension library, as configured by the 
	$CONFIG_VARS['chart.gd.library'] include/config.php variable.  Thanks to
	Terry Dwyer for this suggestions.
	
* functions/item.php & functions/item_input.php
	Updated the following functions to use $HTTP_SESSION_VARS['user_id'] for uid
	in logging, instead of a parameter passed in.
		insert_item($parent_id, $s_item_type, $title, $category)
		insert_newitem_instance($item_id, $s_status_type, $status_comment, $borrow_duration, $owner_id)
		insert_item_instance($item_id, $s_status_type, $status_comment, $borrow_duration, $owner_id)
		update_item_instance($item_id, $instance_no, $s_status_type, $status_comment, $borrow_duration)
		update_item($item_id, $title, $category)
		delete_item_instance($item_id, $instance_no)
		delete_item($item_id)
	
	Updated the following functions to pass in the $owner_id of the item and/or item_instance being
	inserted, that can be different from the $HTTP_SESSION_VARS['user_id']
		insert_item($parent_id, $s_item_type, $title, $category)
		insert_newitem_instance($item_id, $s_status_type, $status_comment, $borrow_duration, $owner_id)
		insert_item_instance($item_id, $s_status_type, $status_comment, $borrow_duration, $owner_id)
		
* functions/item_attribute.php & functions/item_input.php & patch/dvddbp/index.php
	Updated the following functions to use $HTTP_SESSION_VARS['user_id'] for uid
	in logging, instead of a parameter passed in.
		delete_item_attributes($item_id)
		delete_item_attribute($item_id, $s_attribute_type, $order_no)
		update_item_attribute($item_id, $s_attribute_type, $order_no, $attribute_val)
		insert_item_attribute($item_id, $s_attribute_type, $order_no, $attribute_val)
	
* functions/borrowed_item.php & item_borrow.php & user_admin.php
	Updated the following functions to use $HTTP_SESSION_VARS['user_id'] for uid
	in logging, instead of a parameter passed in.
	
		delete_my_inactive_borrowed_items($borrower_id)
		delete_item_instance_inactive_borrowed_items($item_id, $instance_no)
		check_in_item($sequence_number)
		check_out_item($sequence_number, $borrow_duration)
		quick_check_out_item($item_id, $instance_no, $borrower_id, $borrow_duration)
		cancel_reserve_item($sequence_number)
	
* functions/review.php
	Updated the following functions to use $HTTP_SESSION_VARS['user_id'] for uid
	in logging, instead of a parameter passed in.
	
		update_review($sequence_number, $comment, $rating)
		delete_review($sequence_number)
		delete_reviews($item_id)
		
* functions/user.php & login.php & user_admin.php
	Updated the following functions to use $HTTP_SESSION_VARS['user_id'] for uid
	in logging, instead of a parameter passed in.
		
		update_user_passwd($uid, $pwd)
		update_user_type($uid, $type)
		update_user($uid, $fullname, $location, $email, $language, $theme, $type)
		insert_user($uid, $fullname, $pwd, $type, $location, $email, $language, $theme)
		delete_user($uid)
		
* functions/theme.php & admin/s_attribute_type_lookup/index.php & 
  admin/s_item_type/index.php
	Renamed theme_image_src function to _theme_image_src		
	
* functions/item.php, item_display.php, borrow.php, export.php, item_add.php, 
  item_borrow.php, item_input.php
	Renamed fetch_item_r, to fetch_item_instance_r
	
* item_review.php & item_display.php
	Added Edit/Update review support.	
	
0.55-dev20b
-----------
* stats.php
	Changed to use 'review' display widget, for average rating display.
	Updated Owner Information: section, to remove listings links for
	item counts of zero.
	
* item_borrow.php
	Remove print_r from check_out section, that had inadvertantly been
	left in.
	
0.55-dev20
----------
* stats.php
	Fix for instance where Wishlist functionality is disabled.  Also added
	MYSQL_ASSOC argument to mysql_fetch_array call.

* admin/s_item_type/index.php, admin/s_item_type/config.php & 
  admin/s_item_type/functions.php
  	Updated all these scripts to clean up the s_field_type functionality, in
	the case where a new type is being created, and the required (STATUS_IND, 
	TITLE, CATEGORY, DURATION) s_field_type's were not configured for the type at
	setup time.  Will often happen with old types, or types created with SQL
	scripts.
	
* include/menu.php::get_hierarchical_menu_options(...)
	Minor bugfix
	
* functions/whatsnew.php::whats_new(...)
	Update to $LANG_VARS['cnt_item(s)_added_updated'] caused update to this
	function.  Changed {active_ind_desc} variable to {status_ind_desc},
	to conform with other language variables.

* item_add.php, include/menu.php, item_input.php
	Replaced LANG_VARS:
		$LANG_VARS['add_wishlist_item'] 	=> $LANG_VARS['add_status_ind_item']
		$LANG_VARS['update_wishlist_item']	=> $LANG_VARS['update_status_ind_item']
		$LANG_VARS['delete_wishlist_item']	=> $LANG_VARS['delete_status_ind_item']
		$LANG_VARS['refresh_wishlist_title']=> $LANG_VARS['refresh_status_ind_title']
		$LANG_VARS['edit_wishlist_title']	=> $LANG_VARS['edit_status_ind_title']
  	
	This will enable the addition of new status indicators in the future.
	
* import/csv.php
	Added Checkbox, to allow ignoring of Duplicate titles when Importing.  Replaced
	all the CSV specific language variables with more generic ones, with the intention
	of being able to use these new variables in the new import architecture planned
	for the near future.
	
* admin.php
	Introduced mode=printable support almost the same as that provided by 
	Christophe Vrignaud in the Plugin Manager.  Extended somewhat to provide
	support for parameters:
		inc_menu=[Y|N]  - If N, FALSE will be specified as include_menu argument to _theme_header(...) call.
		inc_theme=[Y|N] - If N, neither _theme_header(...) or _theme_footer(...) will be called.
		inc_header=[Y|N] - If N, _theme_header(...)  will not be called.
		inc_footer=[Y|N] - If N, _theme_footer(...)  will not be called.
	
* admin/s_attribute_type/index.php & admin/s_item_type/index.php
	As a result of changes to admin.php, these scripts were updated.
	
* functions/item_input.php
	Updated to support updating hidden attributes.  This is primarily so that refresh operations
	from site plugins for items which were added manually, will populate the site plugin 
	attributes.  Updated some of the opendb_log calls to include UID
	
* admin/s_attribute_type/index.php & functions/parseutils.php
	Removed functions format_function_args(...) & format_function_spec(...) and replaced with new
	generic get_rebuilt_function(...) which was added to functions/parseutils.php
	
* functions/item.php::from_and_where_clause(...)
	Minor update
	
* functions/item_attribute.php
	Added new function fetch_attribute_type_cnt($s_attribute_type)

* functions/widgets.php & item_display.php
	Added a new display_type of 'review'.  This option will display a single
	review entry, and optionally any S_RATING s_attribute_type_lookup information
	if a mask is specified.  Modified item_display.php to use this new widget for
	displaying the Rating.
	
* functions/widgets.php, search.php & listings.php
	Overhauled the listings page, when used from Search.php and item_display.php, 
	A Search Query table, is displayed with all effective search terms, when 
	initiated from either of these pages.
	
* item_display.php & functions/widgets.php::format_action_links(...)
	Updated format_action_links(...) function to allow arrays without img to be
	specified, but to still take advantage of the formattting functionality this
	function provides.  Updated item_display.php to use this function to format
	the links.
	
* functions/item.php::from_and_where_clause(...)
	A fair while ago, code was introduced to restrict Category matches, to the specified
	category s_attribute_type.  However this code was not working due to a minor
	logic bug.  This bug has been corrected.
			
0.55-dev19
----------
* patch.php
	If no index.php in from directory, will provide default functionality,
	which is simply to generate a set of buttons for each SQL file in
	the from directory, allowing the execution/preview of these files.

* functions/item_input.php
	Fixed bug #661576.  Renamed handle_upload and handle_saveurl, to
	handle_item_upload and handle_item_saveurl respectively.  However
	some of the code was still using the old function names.  The
	name changes were made to avoid conflicts, when a lot of the
	functionality was moved from item_input.php to functions/item_input.php,
	and user_admin.php started using functions/item_input.php for
	deactivating users.  Thanks to Christophe Vrignaud for reporting this
	bug.
	
0.55-dev18
----------
* functions/item_input.php::validate_item_attributes(...)
	Updated $HTTP_VARS argument, so it is passed by reference.
	Bug #659675, Thanks to Laurent CHASTEL.
	
* patch/install/opendb.sql
	Minor updates to remove duplicate insert statements. 
	Bug #659192
	
* admin/cache_admin/index.php
	Minor layout reformat.
	
* functions/Snoopy.class.inc
	Introduced version with fix for relative redirects.	

0.55-dev17
----------
* functions/parseutils.php
	Updated is_nonword_char($c) and prc_args($args) to enclose the
	\r, \t, \n escape sequences in double quotes, as they are not
	being recognised by PHP with single quotes.
	
* functions/function.php
	Added a new function remove_sql_ws($sql), which replaces all
	repeated whitespace, as well as \r \n \t with a single space,
	except where that whitespace is enclosed in single quotes.  This
	function is now used by parse_sql_statement($sql, $prefix) instead
	of:
		$sql = preg_replace("/[\s]+/", " ", $sql)
		
	which fixes a bug, where all newlines in textarea attributes were
	being removed.  More testing of this new functionality will need
	to be carried out, before we can be certain of its stability,
	but preliminary testing seems positive.
		

0.55-dev16
----------
* admin/s_attribute_type/index.php
	Minor revision, to fix problem with two headings being displayed,
	when deleting an s_attribute_type.
	
	Also revised the delete,insert,update operations, so that the
	s_attribute_type chooser is actually generated after all the
	operations are processed, so that any changes will be reflected
	in the chooser.

* user_listing.php
	Added a 'Email User' action, and changed the link for the User
	column, to the same as that for stats.php - a list of all items
	owned by the owner.
	
	If user has no items, then their name will not be linkable to the
	listings.php page.
	
* export.php, import/csv.php, borrow.php, user_listing.php, search.php
  item_borrow.php, email.php
  
	Altered User formatting from %user_id% (%fullname%) to %fullname% (%user_id%)
	
* functions/borrowed_item.php
	Added new functions:
			fetch_item_borrower($item_id, $instance_no), 
			is_exists_item_instance_borrowed_item($item_id, $instance_no),
			is_exists_borrower_borrowed_item($borrower_id),
			delete_my_inactive_borrowed_items($borrower_id, $uid),
			delete_item_instance_inactive_borrowed_items($item_id, $instance_no, $uid)
			
	Updated fetch_owner_reserved_item_rs(...) & fetch_my_reserved_item_rs(...)
	to make all but the first argument, optional.
	
* item_display.php
	Removed Location column from Instance Info, in place of a specific Borrower
	column, which was all the Location column was ever meant for anyway.  This
	makes it much clearer where the item is, at any given time.
	
* item_display.php, listings.php, borrow.php, user_listing.php
	Changed Owner column to user new $LANG_VARS['user_name'] variable, which allows
	the user to include the user_id as well.
	
* borrow.php, listings.php, item_display.php
	Changed page titles, that specify a fullname, to allow the inclusion of a 
	user_id as well.  The $LANG_VARS affected are:
	
		$LANG_VARS['on_date_name_wrote_the_following']
		$LANG_VARS['type_export_for_name_item_type']
		$LANG_VARS['type_export_for_name']
		$LANG_VARS['borrower_history_for_fullname']
		$LANG_VARS['item_listing_for_name']
		$LANG_VARS['status_ind_item_listing_for_name']
		
* item_borrow.php, functions/borrowed_item.php
	Moved logging of Reserve,Cancel,Checkin,Checkout to the functions/borrowed_item.php
	which is the standard way all other updates are done.
	
* item_input.php
	Moved the main handler functions into new functions/item_input.php.  Caused
	$HTTP_VARS and $HTTP_POST_FILES arrays to be passed as arguments to these handlers,
	so that these handlers can be used by other scripts, including user_admin.php (for
	deactivating users) and the planned new import functionality.
	
	Also fixed a bug, whereby attribute values were not being correctly identified, if
	they were array based.
	
* user_admin.php
	Minor fix, so that the Language Select Box, is not displayed if only one language
	pack available.  This was the original intention, but there was a logic bug, 
	which meant it was always displayed.
	
* functions/review.php
	Added new function fetch_author_review_cnt($author_id)
	
* functions/user.php
	Added new function is_user_active($uid).  Updated function update_user_passwd
	to allow setting of empty passwords, for the deactivate functionality.
	
	Updated fetch_user_rs(...) and fetch_user_cnt(...) to include 'AND LENGTH(pwd)>0'
	WHERE clause, where a set of user_types is specified.  Where a set of usertypes
	is not specified, it is assumed that all users should be displayed regardless
	of status.
	
* login.php
	Added is_user_active(...) check before allowing login to proceed.
	
* functions/item_input.php::handle_item_delete(...)
	Previously when an item_instance was deleted, it could theoretically leave
	orphaned borrowed_item records, with a status of 'C' or 'X'.  This bug has
	been fixed.	
	
0.55-dev15
----------
* functions/utils.php
	Added new ends_with(...) function
	
* item_input.php
	Refresh operation was not functioning correctly, it was reporting
	that all fields were refreshed, because the old_value was not
	being passed in correctly.	

* admin/cache_admin/index.php
	Minor formatting change	

* patch/extras/game.sql
	Minor fix
	
* functions/http.php
	Minor update to some of the logging messages.
		
0.55-dev14
----------
* export/xml.php
	Added DOCTYPE specification to header of exported xml, and created a 
	opendb-items DTD, which can be found in the docs/ directory or
	http://opendb.i-am-vegan.net/dtd/opendb-items.dtd
	
	Also thanks to Christophe Vrignaud:
	- fixed bug in header, need a ?> instead of >
	- added encoding
	- added outclosing tag <opendb-items> to handle xml import properly
	- fixed bug in item_attribute function, CDATA close tag is ]]> and not ]]!>
	- added file_footer function to handle the new <opendb-items> tag

* include/menu.php
	Reformat some of the menu items and added/removed some
	separators.
	
* export.php
	function send_as_file updated to handle file_footer addin.
	Thanks to Christophe Vrignaud
	
	Updated page_title to include the item title, where item_id and/or
	instance_no specified.

0.55-dev13
----------
* tbl_dump.php deleted

* backup.php
	Removed CSV export option, as this particular format, can now
	be exported via the Export facility.  The backup facility is
	purely for Administrators to backup the database structure itself,
	and this is most appropriately done with SQL inserts.  All the
	function in tbl_dump.php has been integrated into the backup.php
	script, to simplify maintenance of this facility, and its possible
	integration as an Export plugin.
	
* export.php
	Added @set_time_limit(600);, where the actual export process is
	taking place within the code, to ensure we do not timeout in the
	middle of an export operation.
	
0.55-dev12b
-----------
* item_borrow.php
	Removed $CONFIG_VARS['borrow.email_notification'] and replaced
	with:
		$CONFIG_VARS['borrow.reserve_email_notification'] = TRUE;
		$CONFIG_VARS['borrow.cancel_email_notification'] = TRUE;
		$CONFIG_VARS['borrow.checkout_email_notification'] = TRUE;
		$CONFIG_VARS['borrow.quick_checkout_email_notification'] = TRUE;
		$CONFIG_VARS['borrow.checkin_email_notification'] = TRUE;

0.55-dev12
----------

* item_borrow.php
	Replaced the following config.php variables:
	
	$CONFIG_VARS['borrow.reserve_custom_email'] with 
			$CONFIG_VARS['borrow.reserve_more_information']
	$CONFIG_VARS['borrow.cancel_custom_email'] with 
			$CONFIG_VARS['borrow.cancel_more_information']
	$CONFIG_VARS['borrow.checkout_custom_email'] with 
			$CONFIG_VARS['borrow.checkout_more_information']
	$CONFIG_VARS['borrow.checkin_custom_email'] with 
			$CONFIG_VARS['borrow.checkin_more_information']

	Added a new config.php variable:
		$CONFIG_VARS['borrow.email_notification']
		
	This variable can be used to disable the Email portion of
	the more information form, if you do not want any notification
	email to be sent.
	
* functions/datetime.php::get_localised_timestamp(...)
	Minor bugfix	

0.55-dev11
----------
* export.php
	Updated to call replace_newlines(...) on title, category and all
	attribute columns before they are exported.  Updated page_title
	configuration, to provide a bit more information.
	
* export/csv.php
	Updated to include quotes around fields with newlines.	

* item_display.php
	Moved the Export XML link to the footer links section.
	
0.55-dev10
----------
* export.php
	Minor fixes to ensure all attributes are exported correctly, and no
	item or item_instance column mapping attributes (such as s_field_type
	'ITEM_ID') attributes are exported.

* export/csv.php
	Fixed so that it conforms to export format of MSEXCEL 2000, by escaping
	double quotes (by having an extra double quote), and enclosing columns 
	that have commas in double quotes.
	
0.55-dev9
---------
* export.php & functions/export.php
	Revised functionality and added new CSV and Excel plugins.

* item_display.php
	Added [XML] Export link to Instance Info heading.  This link will export
	the item and any item_instance records to a XML format file.  This link
	may be moved, or removed later on, I have it here, merely as a trial.

* functions/item.php::is_user_owner_of_item($item_id, $instance_no, $uid)
	Updated so that the function will check for item_id link only
	if instance_no is not numeric.

* export.php & export/xml.php
	Updated interface, and completed Linked Item include/exclude
	support.

* functions/export.php::fetch_export_item_rs(...)
	Refined query, so no join to item_instance is performed, unless
	an owner_id is specified.

0.55-dev8
---------
* include/menu.php, export.php, export/xml.php
	Added initial Export support.  Currently only XML support
	is provided, but is not finalised as yet.  CSV, Excel,
	PDF, etc will be added as the export plugin infrastructure
	is finalised.

* newuser.php
	Completed language support for this script, and added
	password generation.

* functions/datetime.php::get_localised_timestamp(...)
	Updated to support abbreviated month mask variables:
		Mon - Abbreviated month, Initcap
		MON - Abbreviated month, UPPERCASE.

* logfile.php
	Updated to include date suffix for backup file, instead
	of the word backup.  The config.php variable:
	$CONFIG_VARS['logging.backup_ext_date_format'] was added
	to allow the configurion of the suffix, with a region
	specific date mask.
	
	Modified logic, so check for $CONFIG_VARS['logging.file']
	defined, and also that the logfile exists, and is readable
	before processing anything else.
		
0.55-dev7
---------
* include/language.php, login.php, logout.php, user_admin.php,
  functions/language.php, include/config.php
	Added code for user level language support.  The following new
	include/config.php variables are available to configure this
	support.
		$CONFIG_VARS['user_admin.user_language_support'] = [TRUE|FALSE]
			Configure whether language update option is available in
			user_admin.php
			
		$CONFIG_VARS['login.user_language_support'] = [TRUE|FALSE]
			Whether any user language setting will be used.

* functions/widgets.php
	Modified custom_select so that the $size parameter can be used
	to stop the opening and ending SELECT tags from being generated
	along with the options.
	
* search.php & import/csv.php
	Changed display format of Owner ID list of values, to include 
	user_id.
	
* item_borrow.php & borrow.php
	Changed display format of Borrower ID list of values, to include
	user_id.

* functions/widgets.php
	Update get_input_field(...) & get_display_field(...) to use the
	new get_lookup_order_by($widget['args']['0']) function based on
	the display mask.  So if the display mask references %display%
	mask variable first, then we will order by display before we
	order by value.  However order by order_no will always be the
	first column we order by.
	
* chart.php
	Added dynamic loading logic for GD library, thanks to 
	Laurent CHASTEL (lchastel).
	
* include/menu.php
	Added Alternate text for My Wishlist Items/Other Wishlist Items
	menu options.

* include/language.php
	On a trial basis, include english.inc.php variables first, so that
	older non-english language packs can still work properly.  This will
	only work successfully where non-english language packs properly
	define array based variables using array(...) syntax and not 
	$lang_var['...'][] = ... syntax.
	
0.55-dev6
---------
* site/imdb/functions.php::parse_imdb_data($id)
	Fixed bug with Plot parsing.

* functions/http.php::open_url(...)
	Removed die(...) command, and replaced with RETURN FALSE.  The
	idea is that an administrator should check the log file in the 
	instance where a opendb_url(...) call returns FALSE, and it
	is expected to return a page.  This is more elegant than the
	previous change, but may be further modified in the future.

* newuser.php
	Refined the interface a bit more, and converted some of the text
	to existing language variables.	 Added support for sites where
	$CONFIG_VARS['borrow.enable'] = FALSE.
	Introduced support for two new include/config.php variables:
		$CONFIG_VARS['newuser.signup_enable']
		$CONFIG_VARS['newuser.include_address_fields']
		
* functions/item_attribute.php::fetch_attribute_type_lookup_rs(...)
	Modified to include a $order_by clause.		
	
* functions/widgets.php	
	Small modification to review_options section to support new argument
	to functions/item_attribute.php::fetch_attribute_type_lookup_rs(...).
	
0.55-dev5
---------
* admin/s_item_type/index.php::generate_s_item_type_sql($s_item_type)
	Fixed a bug where duplicate s_attribute_type INSERT statements
	where being produced, in the case where there was more than one
	s_item_attribute_type record defined for it.  For example CDTRACK
	has 15 instances in the 'CD' type.  Also revised some of the 
	headings used in this generation script as well.

* functions/borrowed_item.php
	Added new functions fetch_all_borrowed_item_cnt() & 
	fetch_all_borrowed_item_rs(...)	

* borrow.php & include/menu.php
	Added support for Listing 'Al Borrowed Items and/or All Reserved items.
	Controlled by include/config.php variables:
		 $CONFIG_VARS['borrow.list_all_borrowed']
		 $CONFIG_VARS['borrow.list_all_reserved']

* email.php
	Updated to allow a minimum of borrow user to send email using the 'send_to_uid' 
	operation.  The other operations remain unchanged.

* item_display.php, borrow.php and listings.php updated to call 
	is_user_allowed_to_borrow($HTTP_SESSION_VARS['user_id'], $HTTP_SESSION_VARS['user_type'])
	before generating Owner email link.
	
* borrow.php
	Where $op == 'owner_reserved' and item is currently borrowed out, the checkbox is now
	removed.  This is because a check-out operation would not succeed at this point.
		
0.55-dev4
---------
* functions/user.php
	Added several new functions to this script, as well as adding MYSQL_ASSOC
	argument to all mysql_fetch_array calls.

* item_display.php, listings.php, borrow.php & include/config.php
	Added 'Send Email' anchor to Owner column.  This is configurable via
	the include/config.php:
		$CONFIG_VARS['item_display.owner_email_link']
		$CONFIG_VARS['listings.owner_email_link']
		$CONFIG_VARS['borrow.owner_email_link']

* include/menu.php & search.php
	Added not_owner_id to Other Wishlist Items link, so the current users
	items are not displayed.  This is how the All Other Items link works,
	so it should be consistent.

* user_admin.php, user_listing.php & menu.php
	Changed $op = 'edit_user' to 'edit'.  
	
* user_listing.php
	Modified listing to include an Actions column.  Also the Username column
	no longers opens the User Info form for editing, but instead initiates
	an Email session.  The Email column is no longer linkable.
	
	Removed checkboxes if $CONFIG_VARS['email.use_php_mail'] is FALSE.  This is
	because there is no way to properly support emailing multiple users with the
	mailto: protocol.  From now on the mailto: protocol in email.php script will
	only be supported for the $op = 'send_to_uid'.
	
* email.php
	Complete rewrite of this script to support more operations.  Also removed
	any support for non-opendb user use.  Removed support for the include/config.php
	variable $CONFIG_VARS['email.users_only'] as a result.
	
* functions/email.php
	Because the email.php script no longer supports emailing non-opendb users, there
	was no point in checking the $CONFIG_VARS['email.users_only'] and whether the
	$to email address equals the $CONFIG_VARS['site.admin_email'].

0.55-dev3
---------
* functions/widgets.php, functions/review.php, item_input.php
	Added strip_tags with allowable_html variable, for limited html markup 
	in textareas.  A new widget 'htmlarea' has been added to allow for
	this.  The widget type for the comments input field in item_review.php
	has been changed to htmlarea.

* include/language.php
	Bugfix for languages other than english.  Thanks to Laurent CHASTEL
		
0.55-dev2
---------
* item_input.php, lang/english.inc.php & item_display.php
	Added item_clone support.

0.55-dev
--------
* search.php
	Moved javascript functions into include/search.js
	Added support for Wishlist item searches.
	
* include/menu.php
	Added Wishlist links	
	
* functions/widgets.php
	Moved many of the validation functions into include/validation.js	

* import/csv.php
	Updated to allow population of 'hidden' attribute fields.

* functions/item_type.php
	Removed fetch_item_type_prompt($s_item_type).  Remove title_prompt
	reference from fetch_item_type_r($s_item_type)

* functions/site.php
	Updated to support $lang_var backwards compatibility.

* borrow.php & listings.php
	Removed $page_override_theme logic, and moved to include/theme.php

* include/theme.php
	Removed $theme backwards compatibility.
	
* include/begin.inc.php
	Removed backwards compatibility for $opendb['timeout'] & $use_php_mail

* include/language.php
	Removed $language backwards compatibility.
			
* item_borrow.php
	Updated to display items that are being operated on, in the More Information
	screen.  Also updated quick_check_out and check_out functionality to be 
	more flexible about what borrow duration to use.  Where more than one item
	is being checked out, and a single DURATION s_attribute_type is applicable for
	all s_item_type's, a borrow_duration select list will be generated with
	the minimum duration of all items (including Undefined) selected by default.
	In this case checkbox indicating whether the select list should be an 
	complete override of all item_instance borrow_durations is also provided.
	For Quick Checkout and Checkout where only one item checked out, no checkbox
	will be provided because the select list will already have the specific item
	instance borrow duration selected by default.

* item_display.php & listings.php
	Moved Quick Checkout link after input actions, as I was finding it easy to
	accidentally start off a Quick Checkout process, which was not as easy to
	recover from as an Edit operation for instance.

* logfile.php
	Added wordwrap for details section.  Wrapped to 80 characters, by inserting
	a <br> character.

* site/imdb/functions:parse_imdb_data(...)
	A minor fix to force the removal of double quotes, where they are defined
	as HTML entities, &#34; for instance.

* functions/site.php & functions/utils.php
	Moved format_title_grammar_article(...) from site.php to utils.php so it
	can be used by item_input.php

* site.php & functions/http.php
	Removed the check_url($external_link), as it is a waste of time, and often
	causes searches to take longer anyway.  The open_url(...) function in 
	http.php, now calls die(...) with an error indicating that the URL could
	not be opened, so that the user is fully aware that there was a problem.

* functions/http.php & functions/fileutils.php
	Moved from http.php to fileutils.php: 
		get_file_ext($filename), 
		get_valid_extension($filename, $extensions),
		save_url_file($url, $save_dir, $filename, $dooverwrite), 
		save_upload_file($http_tmp_name, $save_dir, $filename, $dooverwrite)

* functions/function.php::run_opendb_query(...)
	Updated error handling in the event the MySQL server or database is not accessible.
	It also seems that the database was being selected twice, which may have been
	causing performance issues, the second call has been removed.

* borrow.php, functions/parseutils.php, listings.php, item_display.php, item_add.php,
  item_input.php
	Updated 
		expand_item_title_mask(...)
		expand_type_title_mask(...)
	
	 to include $active_ind column, so we can use
	the value of active_ind in tests.

* logfile.php, functions/item.php, functions/item_attribute.php, 
	functions/review.php, functions/user.php, admin/s_item_type/functions.php,
	login.php, admin/s_attribute_type/functions.php, admin/s_attribute_type_lookup/functions.php,
	
	Updated opendb_log(...) calls format, to include (uid=...) at the end
	of the log string in the parameters section, instead of in the main message.

* stats.php
	Updated to include Wishlist items

* functions/whatsnew.php
	Updated to include Wishlist item added/updated.

* functions/item.php
	Functioning of listings.php has changed.  Now all status' of items
	will be displayed in 'List My Items' and 'All Other Items', whereas
	originally only Active items would be displayed.  Wishlist items will
	not be displayed by these links, but will be displayed for the 
	Search ???? for '....' listings, initiated from item_display,etc.

* item_display.php & listings.php
	Updated to support Admin users editing/deleting items of other users,
	as well as their own.

* import/csv.php
	Fixed support for $widgets['enable_javascript_validation']==FALSE
	setting.

* admin/s_item_type/index.php & admin/s_item_type/functions.php
	Removed support for title_prompt, as it is being phased out of the
	database structure, in favour of a s_attribute_type prompt, and
	s_field_type 'TITLE'.
	
* admin.php, admin/s_item_type/index.php, admin/s_attribute_type/index.php,
  admin/s_attribute_type_lookup/index.php
  	Replaced specific error messaging logic with format_error_block(...)
	function from functions/widgets.php
	
* listings.php & search.php
	Removed any mention of linked items if disabled via the include/config.php
	variable $item_input['linked_item_support'].  This change was made for
	consistency.

* item_borrow.php, borrow.php, item_display.php, listings.php & 
  include/menu.php, functions/whatsnew.php

	Added logic to disable borrow functionality if 
	$borrow['enable'] == FALSE

* email.php
	Revised to support 'Send email to All users' functionality, as well
	as refining the messaging functionality.

* functions/email.php
	Moved get_site_url() to functions/http.php
	
* user_admin.php & user_listing.php
	The User Listing functionality was moved from user_admin.php to 
	new script user_listing.php.  This will allow easier maintenance
	of both scripts, and provide a nice separation of two different
	functions.
	
	The user_admin.php & user_listings.php scripts were heavily
	revised to be more consistent with the rest of the scripts, as
	far as validation, page listings and messaging goes.

* item_review.php, item_input.php, widgets.php, lang/english.inc.php
	Removed javascript quote handling from lang_var.  Where in javascript,
	the quotes will be added to the {prompt} value passed in, instead.

* listings.php
	Updated to remove Action column, if user is not at least
	a borrower user.

* item_add.php
	Revised some of the logic, both for elegance and useability.
	
* item_display.php
	Updated Item Instance functionality, so that 'New Copy' link
	will not be available where user is a guest.

* item_borrow.php
	For handle_reminder(...), handle_checkin(...), handle_checkout(...)
	the check for whether the item is active, has been removed.  It
	does not make any sense to not perform these operations when a
	active borrow record already exists for the item.  This allows
	the owner to set their item to inactive, so that no other users
	can reserve it, but to keep current reservations, etc available
	to act on.

* functions/item_type.php
	Updated to include s_field_type 'TITLE' support functions
	Updated to include s_field_type 'STATUS_IND' support functions
	
	
* functions/item_attribute.php
	Add MYSQL_ASSOC arguments to fetch_mysql_array(...) function,
	for efficiency purposes.   Also a new function is_exists_lookup_value
	was added.
	
* functions/utils.php
	Added a 'starts_with(...)' function

0.54p2
------
* site/imdb/functions.php::get_imdb_all_titles_list(...)
	Small modification to fix issue with IMDB all titles listing, repeating
	the logic for the first block.

* admin/s_item_type/index.php, admin/s_attribute_type_lookup/index.php 
	Moved Delete column to left side, for more elegant layout.
	
* admin/s_item_type/index.php, admin/s_attribute_type/index.php & 
  admin/s_attribute_type_lookup/index.php 	
	Perform strip_tags, then remove whitespace & illegal characters from 
	pk values before allowing insert.
	
* admin/s_attribute_type/functions.php & admin/s_attribute_type_lookup/index.php
	Added new function fetch_attribute_type_rs(...) to select all 
	attribute_type's not just types without a S_ value.  This is because
	we want to allow users to modify the lookup	values for system attribute
	types, but not to edit anything else about them.

0.54p1
------
* item_borrow.php::handle_quick_checkout(...) & lang/english.inc.php
	Added validations for $borrower_id, to ensure that it is actually
	a valid user, and also that it is not of type guest.

* functions/widgets.php::custom_select(...)
	Small modification, to fix issue with invalid ResultSet
	being passed in for $lookup_results.

0.54
----
* item_borrow.php
	Fix for Quick Checkout, where the Due Date details were
	not being included because the borrowed_item sequence_number
	was not being correctly returned.

* item_review.php, item_display.php, item_input.php
	Better passing $HTTP_VARS['listing_link'] via the 
	[Back to Item] link, so we do not lose the Back to 
	Listing functionality.

* functions/borrowed_item.php, borrow.php & item_display.php
	Added Item Borrow history functionality.

* themes/default/images/action_*.gif
	New set of images for image action functionality provided 
	by Marcus <theevilflow@users.sourceforge.net>

* item_input.php, item_display.php, listings.php, functions/theme.php,
  functions/widgets.php
  	The 'Action' column in each of the user scripts, now supports
	themeable images for the action, instead of text.  
	See the docs/notes/theme.txt for more information.  
	(Refer Section 7 - "Action" images)
		
* functions/http.php, item_display.php
	Removed get_opendb_url(...)	

* functions/listings.php, borrow.php, listings.php, 
  admin/s_attribute_type_lookup/index.php
  	Updated print_footer(...) to take a $items_per_page 
	parameter.
	
* listings.php & borrow.php
	Updated to display total items footer for printable listing
	as well as normal listing.	
	
* listings.php & include/config.php
	Added $listings['category_display_type_args'] config option, so
	that users can configure the Category column, for list links,
	or not at their option.  The default display_type_args if not
	specified will be '%display%'.  The reason you only have the
	option to specify the args, is because it should be constrained
	to a 'category' widget type, but the arguments are negotiable.

* admin.php & admin/*
	Fixed several bugs where fileUpload=No, and also introduced
	feature to extract SQL for s_item_type's.
		
* functions/widgets.php
	Updated url(...) & saveurl(...) functions so that filenames
	without extensions will be accepted if no extensions are
	specified.
	
* functions/widgets.php & admin/s_attribute_type/config.php & 
  theme/*/style.css
	A new display_type widget of 'popupurl', originally contributed
	by Torsten Will, but significantly modified to be a little 
	more integrated.  The <a href ...> link has a class="popuplink", 
	and all the standard themes were updated to include this new
	style class.
	
* functions/email.php::opendb_email(...)
	Changed headers to specify \r\n for line ending, instead
	of just \n.  This is to fix support for some windows
	SMTP servers, which seem to get confused over \n header 
	line endings.
	
	Added $opendb_email['format_email_addr'] check to
	disable the formatting of the 'to' and 'from' email 
	addresses.  By default this variable is never used, but
	is provided for those users who have experienced problems.
	
* listings.php & admin/s_attribute_type_lookup/index.php
	Updated page_no and start_index logic to fix a bug, which
	occurs when you delete the $listings['items_per_page']+1 
	item in the listing.
	
* login.php
	Renamed 'from' url variable to 'redirect', as a clearer
	indication of its use.  The 'from' will still work, as
	I have maintained backwards compatibility.
	
* external.php
	Updated to support a specific title for the window.  Also
	updated $lang_var['external_header_text'] to support 
	extra {vars}.  {site}, {url}, {title} are all now supported.		
	
* functions/site.php & item_display.php
	Updated to pass title into external.php call.
	
* functions/listings.php::display_lov_of_types(...)
	Remove auto change of group depending on Type selected.
	
* functions/parseutils.php::expand_type_title_mask(...)
	Updated to support specifying mask configuration for item_type's
	as a group.  The groups are configured via the 
	$listings['s_item_type_groups'] variable.
	
* include/begin.inc.php & include/end.inc.php
	Explicitly set error_reporting to exclude E_NOTICE, as OpenDb
	will generate various 'Unitialised variable' warnings, which
	should be ignored.	
	
* item_input.php, item_display.php & listings.php
	Removed the [...] for actions, now that they have their own column.
		
* listings.php, item_display.php, 
	Removed &nbsp; from the following variables:
		$lang_var['current_user']
		$lang_var['item_reserve_list']
		$lang_var['not_active']
	
	We now add them programatically, which allows their use in more
	than one spot, without risking problems with &nbsp; causing formatting
	issues.  The &nbsp; was originally added to prevent wrapping, but this
	is something that should be done in the php itself, not in the language
	files.
	
	The code:
		str_replace(" ", "&nbsp;", $lang_var['current_user'])	

0.53p4
------
* site/imdb/functions.php
	Further updates to fix Runtime match problem.

0.53p3
------
* site/imdb/functions.php
	Further updates for some more minor issues with matching the
	movie poster.

0.53p2
------
* site/imdb/functions.php
	Updated to support new IMDB page format.

* login.php
	Minor update to support redirect to page even if logged in.
	Removed get_site_scriptname() function in favour of using
	$PHP_SELF which is easier and far more flexible.

* admin/s_attribute_type_lookup/index.php, import/csv.php & item_input.php
	Updated to check if(is_file_upload_enabled()) before
	presenting a FORM with enctype=\"multipart/form-data\"	
	
	csv.php and item_input.php were supposed to have been updated as part of
	0.53 but it was missed.
	
	
0.53p1
------
* functions/Snoopy.class.php
	Fix issue with Amazon.com plugin. Thanks to Mark Nagel for
	identifying the problem.

0.53
----
* functions/http.php, item_input.php & import/csv.php
	Added 'is_file_upload_enabled()' function so we can 
	more easily handle the file_upload = Off configuration
	option safely and elegantly.  The import.php will
	be completely disabled, as it relies on file uploads,
	while in item_input.php, the file upload field will be
	completely ignored.

* functions/function.php::run_opendb_query(...) & 
  functions/patchutils.php::check_table(...)
	Added extra parameter $alt_db_server to function, to allow
	connection to a different database.

* patch.php
	Added 'Add Session Table' patch link
	
* patch/session/index.php (New), include/session.php (New) &
  include/begin.inc.php (Changed)
	New database session functionality.  Please refer to the
	docs/session_handler.txt document for more information
	on configuring support for the database session handler.
	By default it is disabled.
	
* functions/theme.php
	Reduced default fontsize = 2, and increased imgsize = 175
	
* chart.php
	Further minor changes contributed by David Pyke.
	
* include/begin.inc.php & include/end.inc.php
	Modified $_OPENDB_MAGIC_QUOTES_RUNTIME variable name.
	
0.52p5
------
* functions/theme.php
	Modified size of stats graphs to 150 as it fits nicely 
	on the page.
	
* stats.php
	Reordered user list table.
	
* item_input.php, import/csv.php & include/begin.inc.php
	Fixes for file upload problems with Windows servers.
	
* functions/http.php, functions/utils.php, tbl_dump.php,
  login.php. 
	Moved get_http_env(...) from utils.php to http.php
	and updated include statements in client scripts.
	
* functions/email.php
	Updated get_site_url(...) to use 'SCRIPT_NAME' 
	instead of 'REQUEST_URI' which appears to not be 
	vailable on all windows setups.
	
* login.php
	Updated get_site_scriptname(...) to use 'SCRIPT_NAME' 
	instead of 'REQUEST_URI' which appears to not be 
	vailable on all windows setups.
		
0.52p4
------
* functions/theme.php, stats.php & chart.php
	Integrated patch by David pyke for themeable stats image size.  
	Also added font size as well.

* patch/install/opendb.sql & patch/0.50/patch.sql
	Included a IMAGEURL for CD

* functions/item.php
	All title, category and attribute_val queries where '='
	is being used, will not remove any '\_' and replace with
	'_'.  The '=' query does not recognise escape sequences.

0.52p3
------
* functions/widgets.php
	Minor fix for 'format_mins' display widget to fix 
	regression problem introduced with 0.52 initial release.  The
	format_mins will not work very well if the %h is after the
	%H or the %m is after the %M

0.52p2
------
* listings.php
	Added logic to reduce database calls by only having to
	check the 'is_legal_site_type' once for each s_item_type.  The
	logic is similiar to that used for s_item_type images.
	
* patch/install/opendb.sql & patch/extras/divx.sql
	New separate divx.sql script for users to update their divx
	type definitions with new Video,Audio codecs, etc.  The
	install script DIVX support has also been revised.	

* functions/item.php::from_and_where_clause(...)
	Added logic to support an array of s_item_type's as a restriction
	for the results to be listed.
	
* search.php & listings.php
	Updated variable name 'item_status_r' to 'item_status_rs' to
	better indicate the fact that it is a set of item_status values,
	not just an array describing one.
	
* functions/widgets.php, listings.php, borrow.php, functions/listings.php
	Updated to support type grouping.
	
* item_display.php
	Fix for linked item category display.	Modified 'Quick Check Out' link
	to be in the same '[' ... ']' as the edit / refresh / delete links.
	
* lang/english.inc.php
	Disabled:
		$lang_var['alpha_listing']

* borrow.php
	Fixed printable listing bug with 'Reserve List'
	
0.52p1
------
* lang/english.inc.php
	Updated:
  		$lang_var['page_listing_index']

	Added:
		$lang_var['screenshots']

* functions/listings.php::print_footer(...)
	Minor aesthetic update.

* functions/item_type.php, item_display.php, item_input.php, listings.php
	Added new function is_item_legal_site_type(...) which checks each
	s_item_type site_type with is_legal_type(...).  If none of the types
	are considered legal this new function returns FALSE.  Modified the
	call in item_display.php, item_input.php and listings.php to use
	is_item_legal_site_type instead of the old is_item_site_type.  This
	ensures that a 'Refresh' link is not provided unless appropriate.  
	This fixes a problem with GAME & BOOK with the default Amazon
	site link only plugin delivered with OpenDb.

* item_add.php
	Functionality to handle the case where a Refresh is requested
	for an item, which has no legal matching site_type.  The 
	case of 'Amazon.com' as delivered in OpenDb by default 
	is such as case, and it effects GAME & BOOK types.  The 
	script will display an error and a back to listings link.

* patch.php
	Minor update to OpenDb version text

* site/amazon/config.php
	New Screenshots link added for Games.

* functions/widgets.php
	Due to changes in 0.52, to the get_display_field, the $prompt is now
	being passed in.  The logic within several functions to get the $prompt
	from the database has subsequently been removed.

* item_display.php
	Fixed a small problem with display_type's with an empty value.  Normally
	if the input_type is also hidden, it should be treated as hidden. There
	was a minor logic error.
	
0.52
----
* listings.php
	Minor fix for item reserve link, using ']' instead of '['

* functions/fileutils.php::get_file_list(...)
	Minor update to the regular expression.

* functions/site.php::format_title_grammar_article(...)
	Modified function to ensure that the articles occur
	at the start of the title, and include at least one
	space after it, so we do not match the start of
	a non-article title word by mistake.

* borrow.php::sort_item_reservation_rs(...)		
	Added function_exists("create_function") check, for
	pre php 4.0.1 support.  Probably will never be an issue,
	but I like to cover all bases.

* site/imdb/functions.php
	Removed get_imdb_plot_chooser(...) function as no longer
	required.
		
* site/freedb/index.php, site/imdb/index.php
	Modified to use new get_site_plot_chooser(...) function.
	
* functions/site.php
	Added new function get_site_plot_chooser(...) which should
	now be used by all site plugins to display plot chooser.
	
	If no plots available the user will automatically be redirected
	to item_add.php with the data obtained from the site plugin.	
	
* functions/widgets.php
	Added new 'url' widget.  This widget is like 'saveurl', but does
	not provide for saving the url locally.  But does provide the 'View'
	feature.
	
	Updated get_display_field(...) function in widgets.php to format the 
	complete field, like get_input_field(...) does.
	
	Removed the 'onchange_event' from 'single_select', 'multi_select',
	'value_select'.  Added $onchange_event as last argument to 
	get_input_field instead.  Updated all the basic widgets to pass
	in the $onchange_event variable.  
	
	The onchange event is passed to widgets:
		'textarea', 'text', 'url', 'saveurl', 'filtered', 'number', 'email',
		'simple_checkbox', 'checkbox', 'single_select', 'multi_select',
		'value_select'

	Removed get_attribute_field(...) as it was no longer necessary.
	
	Changed get_field_name(...) so that order_no is no longer a 
	required parameter.
	
	Updated 'format_mins' so that %h and %m can be used with plain
	text, such as 'hour(s)' and 'minute(s)'
	
	Modified 'endsWith' javascript function to do a case INSENSITIVE
	check.
	
* item_input.php * patch/dvddbp/index.php
	Replaced call to get_attribute_field(...) with get_input_field(...)
		
* admin/s_attribute_type/config.php
	Added 'url' function to input_type functions array.
	
* functions/item_attribute.php
	Added new function fetch_siat_with_prompt_and_val_r(...) for 
	use in item_display.php
	
* functions/item_type.php & item_display.php
	Item display will now display all item_attributes which have a
	s_field_type (from s_item_attribute_type) of 'IMAGE'.  The
	image tag will include the s_item_attribute_type or s_attribute_type
	prompt.  Also reduced size of the popup window to something a little
	more reasonable based on the average size of the images.
	
	Modified item_display.php so that it will not display the prompt
	for a field, if the get_display_field(...) function does not return
	anything.
	
* borrow.php, item_input.php, item_borrow.php, listings.php
	Changed call to get_display_field(...) to support new format.
	
* admin/s_attribute_type_lookup/index.php, admin/s_item_type/index.php,
	Removed the onchange_event argument from value_select and added
	it to the call to get_input_field itself.	

* item_input.php
	Fixed a minor bug with the display of the parent title, when adding
	a linked item.
	
* item_add.php, import/csv.php
	Modified call to single_select(...) function, because the order of
	parameters have changed, and onchange_event is now optional.

* patch/dvddbp/index.php
	Updated input fields for 'Ratio','Format','Region' to be inline with
	those used in 0.51 of OpenDb.
	
* site plugins
	Removed $translate_plots_with_google variable from all site plugins.
	A new include/config.php variable $site_plugins['translate_plots_with_google']
	has been added, to control the translation of ALL plots.  Specific
	site plugins that do not require translations, because they are already
	in another language, would specify FALSE for the get_site_plot_chooser(...)
	$english_plots parameter.
	
* functions/theme.php, include/theme.php, theme/*/index.php, include/language.php,
  user_admin.php, external.php
  
  	Updated all scripts to use $_OPENDB_THEME and $OPENDB_LANGUAGE instead of
	$theme and $language respectively.  This is because these variables are
	far too general and may be reused or reset by mistake.
	
* admin/s_attribute_type_lookup/index.php
	Added javascript validation so that if an Image is added, then No Image
	checkbox will be unchecked.  If the No Image checkbox is checked, the
	Image field will be set to empty.
	
* import/csv.php
	Added @set_time_limit(600); to start of script so it can run for more than
	the default of 30 seconds.  Also modified $category value to replace any
	'/' or '\' separators.
	
	Updated logic so that error conditions are records as $error_no and displayed
	along with the error message to aid analysis.
	
	Also updated the initial form to enforce extensions and the specification of
	a delimiter value.
	
* patch/extras/book.sql
	Updated to support Amazon plugin.
	
* functions/email.php::get_site_url(...)
	Ability to override the Apache servername:port information with
	hard coded values.  New include/config.php variables $opendb['hostname']
	and $opendb['hostport']
	Change provided by Carl Seutter <cseutter@insightbb.com>    
	
* borrow.php
	A rather annoying bug with 'Reserve Basket' when register_globals=Off was
	fixed.
	
* functions/whatsnew.php
	Fixed a rather strange error with the 'Whats New' page where new items
	were added.  The 'not_owner_id' variable did not get passed as 
	'not_owner_id', the 'not_' bit was lost.  This was happening with
	IE 5.0 on Windows 2000 sp2.  I did not test other IE versions.
	
* listings.php & functions/listings.php
	Reinstated old functionality, where the $HTTP_VARS['total_items'] value
	is not recalculated if moving between pages or reordering items.  The
	total items value will be reset if the items are restricted via type,
	letter, etc.
					
* patch/extras/book.sql
	Updated ISBN input_type to allow the uppercase character 'X', which
	apparently is the roman numeral 10, in place of the number 10, which
	would be counted as two characters.
						
0.51p3
------
* functions/fileutils.php
	Small fix with get_file_list.
	
* patch/extras/game.sql
	Updated to support link to Amazon.com and other minor additions.
	Marc Powell contributed these additions.

* user_admin.php
	Remove any '>' characters if they exist in email value after strip_tags
	has been applied.  It seems that strip_tags will only consider the '>'
	part of a tag, if it is matched with a '<' tag.  it will howerver consider
	'<' on their own to be tags anyway!
		
* functions/email.php
	Updated is_valid_email_addr(...) to check for '>' in email which is
	considered an invalid character, because we add the < and > when the
	'mail' function is actually called.
	
	Updated opendb_email(...) to check if the $to address equals the
	$opendb['admin_email'] admin email address, where 
	$opendb_email['users_only'] = TRUE.  Before email could not be sent
	unless the administrators email address was actually in the database,
	which is not necessarily so!

0.51p2
------
* admin/s_item_type/index.php & admin/s_attribute_type_lookup/index.php
	Fixed a annoying bug where if no s_item_type or s_attribute_type_lookup
	records for a particular editing session, then no new records could be
	added either.

* item_input.php & item_add.php
	Added checking to ensure the s_item_type specified for a new operation
	is a legal type.

* admin/s_item_type/functions.php
	Moved is_exists_item_type($s_item_type) to functions/item_type.php so
	it can be used elsewhere in the system.

0.51p1
------
* admin/s_item_type/index.php & admin/s_attribute_type_lookup/index.php
	Improvements to messaging in both of these scripts.  But more
	importantly a check added to s_item_type script to ensure that 
	item_attribute_type relationships cannot be modified without first
	checking for the existence of dependant item_attribute records.  If
	an s_item_attribute_type record's order_no is updated, this causes
	a delete of the existing record and an insert of a new one.  Because
	of this it was simple to add a validation when deleting a
	s_item_attribute_type record to check if there are any item_attributes
	linked to item of the same s_item_type with the same s_attribute_type
	and order_no.  If so the delete is aborted and a message delivered to
	the user.  In the future functionality may be added to allow all
	existing item_attribute records to be migrated to the new order_no,
	but not in the current release.

0.51
----
* login.php
	DISABLED REDIRECT LOGIC AS SOME PEOPLE WERE HAVING PROBLEMS
	WITH IT.  ONCE WE WORK OUT WHAT THE PROBLEM IS IT WILL BE
	REENABLED.

* listings.php
	Further minor fixes for borrow links where 
	$borrow['reserve_basket'] = TRUE and 
	$listings['show_borrow_links'] = TRUE

* functions/parseutils.php
	Moved expand_display_mask(...) to functions/widgets.php
	as this is the only place it is used.

* patch/extras/game.sql
	Added 'Nintento64' & 'Gameboyadvance' gamesystem types and images.  
	Thanks to David Pyke.

* functions/themes.php::theme_image_src(...)
	Updated to check that $src is not empty, before trying 
	to find anything.

* functions/item.php::from_and_where_clause(...) &
  functions/item_attribute.php
  	Added functionality so that when a category list link
	is activated, only those item types that have the same
	category s_attribute_type will be returned in the
	query.

* admin/s_attribute_type_lookup/index.php::display_table_row(...)
	Updated to include a 'No Image' link, which will insert
	a 'none' value into the img record.

* listings.php, user_admin.php, borrow.php
	Added 'nowrap' to the heading <TD...> so that the
	asc desc graphics are on the same line as the
	text.

* functions/widgets.php::format_listing_link(...)
	Updated to display 'linked' items as well.

* item_input.php
	Fixed a problem with refreshing linked items.  The 
	title and category would always be considered changed,
	because the block which setup the comparison was being
	skipped for linked items.

* site/freedb/functions.php::get_freedb_entry_details(...)
	Updated formatting for DTITLE so that all words in the
	title are INITCAP only, not all uppercase.

* site/freedb/index.php
	Cleaned up the 'Next Page / Previous Page' logic to look
	more like listings.php and also fixed a small issue with
	'offset' being included twice in the URL.

* functions/borrowed_item.php::quick_check_out_item(...)
	Updated to include the borrow_duration in the insert
	statement.

* functions/parseutils.php::get_mask_variable_value(...) &
  functions/widgets.php::format_display_value(...) & 
  admin/s_attribute_type_lookup/index.php::display_table_row(...)
	Updated call to _theme_image to include $display for
	'title' argument.

* item_display.php & listings.php
	Modified the 'Quick Checkout' link format, so that it is
	self-contained and logically separated from the Input
	links (Edit/Delete/Refresh)

* admin/s_attribute_type/index.php
	Rearranged the columns, so that the help link appears after
	the function and argument columns, which make it a little
	easier to understand.

* functions/function.php::parse_sql_statement(...)
	Added support for ALTER TABLE, to support most patches.

* functions/patchutils.php & patch/???/index.php
	Updated print_sql_file(...) to not add prefixes to the
	table names.  This will be done on the fly when executing
	the statements, but is not displayed in the output.  Removed
	the $do_prefix argument as a result from patch index.php
	that included it.

	Updated exec_sql(...) to display the sql with the prefixes
	added, so that users can see exactly what is happening in
	the patch execution.

* include/menu.php
	Updated the get_menu_options functions to check the 
	$borrow['reserve_basket'] variable before displaying the
	Reserve Basket menu option.

* borrow.php
	Updated to enforce no reserve basket if explicitly disabled
	via $borrow['reserve_basket'].  Previously the functionality
	was only disabled from item_display.php and listings.php,
	which meant that users could manually access it if they
	wanted to.  This has been rectified.

* include/config.php, item_display.php, listings.php
	Replaced include/config.php $listings['show_reserve_basket'] 
	variable with more suitable $borrow['reserve_basket']

* item_borrow.php, borrow.php & item_display.php
	Fixed up the 'back to listings' links, and cleaned up when they
	are actually to occur.  Also added a 'Back to Item' link if
	item_borrow or borrow is activated from item_display.php with
	a single 'item_id','instance_no' combination.

0.51rc6
-------
* item_display.php::get_item_status_row(...)
	Added support for 'Quick Checkout'.  The
	$listings['show_quick_checkout'] config variable
	controls whether the links are displayed for 
	Quick Checkout in listings.
	
* functions/user.php::fetch_user_rs(...)
	Modified to include an $exclude_user argument.
	
* item_borrow.php
	Added functionality for quick check out.  The
	$borrow['quick_checkout'] config variable controls
	whether this functionality is available.

* functions/borrowed_item.php
	Added quick_check_out_item(...) function

* lang/english.inc.php
	Added:
		$lang_var['item_quick_check_out']
		$lang_var['quick_check_out']

0.51rc5
-------
* functions/parseutils.php & site/imdb/config.php
	Updated the 'ifdef' and 'if' mask functions to support an optional
	else_mask.  Removed the 'ifelsedef' mask function as it is no longer
	required.

* listings.php & borrow.php
	If mode == 'printable' the $start_index needed to be set to NULL, so that
	all the items would be displayed, not just the first page.

* functions/widgets.php, item_display.php, admin/s_attribute_type/index.php
	Renamed widgets.php function get_utils_javascript() to 
	get_popup_javascript()

* functions/listings.php, user_admin.php, borrow.php, listings.php, 
  admin/s_attribute_type/index.php, admin/s_attribute_type_lookup/index.php 
  
	Updated to use specific 'navigate' form for the Page number / order by 
	functionality.  This is so that for most operations we can use a 
	GET instead of a POST.

* item_display.php & listings.php
	Changed the link to be 'Add to Basket' if $listings['show_reserve_basket']
	functionality enabled. The $lang_var['add_to_reserve_list'] variable
	can be modified to be something different if this change is not
	desired.

* functions/item.php
	Removed get_instanceno_text(...) function.

* functions/parseutils.php
	Updated to support numeric comparison tests and use of 'instance_no'
	in such tests.

* item_add.php, item_input.php, borrow.php, item_display.php
	All updated to use expand_item_title_mask instead of 
	get_instanceno_text function for formatting titles.
	
* lang/english.inc.php
	Added:
		$lang_var['add_to_reserve_list']
		$lang_var['delete_from_reserve_list']

	Removed:
		$lang_var['display_title']
		$lang_var['list_title']

	Modified:
		$lang_var['edit_title']
		$lang_var['refresh_title']
		$lang_var['confirm_delete_title']

0.51rc4
-------
* functions/parseutils.php 
	Minor fix to expand_type_title_mask(...) and expand_title_mask(...),
	for a potential issue uncovered by changes to 0.51rc3.

* site/imdb/functions.php & site/imdb/config.php
	Renamed mapping variable to $usa_age_certification_map as it is
	really intended for USA mappings.  Also modified so that the mapping
	_only_ occurs when processing USA ratings.  Thus the $age_certification_codes
	array can be used in combination.  So you can specify your preferred
	certification system (for example 'Australia') and if the last value in 
	this array is 'USA' (or the array is not defined at all), the 
	$usa_age_certification_map array will be used to map between USA and 
	the specified ratings from 'AGE_RATING' s_attribute_type_lookup values.

0.51rc3
-------
* site/imdb/functions.php & site/imdb/config.php 
	functions.php::parse_imdb_data(...)
		Added functionality to convert IMDB age certification ratings to
		local equivalents.  This requires configuration of the mappings in
		the new site/imdb/config.php variable $age_certification_map.

	config.php:
		Updated the 'title' refresh_mask to use the new ifelsedef mask function,
		to allow the use of 'alt_title' attribute instead of title if defined.

* functions/parseutils.php
	Updated expand_type_title_mask(...) so that the '$mask_configuration' and
 	'$parsed_title_mask_r' are both passed-by-reference to avoid reparsing
	the same mask more than once per listings/borrow page.

	Updated expand_title_mask(...) && parse_title_mask(...) to support new
	mask function 'ifelsedef(varname, if_mask, else_mask)'

0.51rc2
-------
* borrow.php,item_borrow.php,functions/borrowed_item.php
	Updates so that borrow_duration has to be numeric and >0 for it to be
	considered a valid duration value.

0.51rc1
-------
* listings.php
	Updated script to format a title using $lang_var['search_prompt_for_value']
	when loaded for 'list-link' operation.

* lang/english.inc.php
	Added:
		$lang_var['external_url_error']
		$lang_var['external_header_text']
		$lang_var['external_noframes_link_text']
		$lang_var['search_prompt_for_value']

* functions/widgets.php
	Updated so that the lookup table input widgets, check for !$value_found
	before using the checked_ind value.  This is so that users can
	specify a 'EMPTY' lookup value as an option.  This works because the
	empty value will always be first because of the way the sort works.

	This update will not work for 'Borrowed Duration' which expects a 
	numeric value.

	Also updated get_display_field(...) function to insert &nbsp; for
	display values when widget == 'category' 

* item_add.php, functions/site.php, site.php, site/imdb/index.php, 
  site/imdb/functions.php, site/freedb/index.php, site/freedb/functions.php
  	Updated to support 'Back to Listing' in refresh operations

* site/imdb/functions.php::parse_imdb_data(...)
	A fix for an error when parsing Runtime.  An example of the problem,
	was with 'Aliens', because of the '(director's cut)' text is 
	being appended.

* functions/site.php
	Updated get_site_links_table(...) to call external.php when
	generating the site links.

* external.php
	New script to open an external url link, within a frame
    structure so that it is clear we are still in OpenDb.

	For those wondering, I have copied some of the Hotmail
	formatting, but I have always wanted to have an external.php
	script for external links so that users would not get lost
	when clicking on a site link, for instance.

* admin.php & admin/ directory
	Restructure of this to something similiar to themes and
	site plugin structure.

* admin/s_attribute_type/index.php
	Added validation to prevent s_attribute_type's being deleted
	if linked to s_item_type's.

* Game support updated with Ratings and Plot fields thanks to 
	Marc Powell.

* Updated some of the patches to use new widget types.

* include/menu.php
	Added new get_menu_options_with_images($uid, $user_type) function
	for themes that want to use images instead of text for their
	menus.

0.51-dev11b
-----------
* borrow.php
	Updated the borrow.php script to support order by functionality
	for 'Reserve Basket'.

0.51-dev11
----------
* Many of the php scripts (both runnable and functions)
	Replace the use of 'empty' with strlen(...) and is_not_empty_array.
	Some uses still remain but most have been replaced.  This is due
	to the annoying issue with empty(..) recognising '0' as being
	empty, when attributes in OpenDb may have a zero '0' value.  I
	performed a 'diff' against all the scripts to make sure the
	conversion was carried out correctly, and everything was in order.
													   
* search.php
	Updated so that no attributes with a defined 's_field_type' would
	be included.  This is a bit excessive, but it is future proof.

* item_input.php
	A few fixes to the saveurl and upload checking logic, which was
	allowing the upload of illegal files if the javascript was
	bypassed.  Also added some more messages so it was clear when
	an error occurred.  Also a small fix when 'Save' checkbox was 
	checked as the image was being inserted.  The {item_id} was
	being incorrectly passed.

* functions/widgets.php
	Removed support for old 'checkbox', now it can be accessed
	using 'simple_checkbox'

* listings.php & functions/widgets.php
	Updated 'list-link' functionality to include the specific 
	$lang_var['list_items_with_same_prompt'] page title.

* functions/parseutils::prc_function_spec(...)
	If a function spec is specified without arguments, originally
	I was assigning the type as the first argument as well.  I have
	decided against this and disabled it.  Now if no arguments specified,
	there will be no arguments full stop.

* functions/theme.php::_theme_header(...)
	Added a new optional parameter '$include_menu', which defaults to
	TRUE.  All the included themes have been updated to check that
	it does = TRUE.  If not the menu should not be included.  However
	existing themes will still work as expected, except where new
	functions rely on using $include_theme=FALSE to achieve a
	certain display structure.

* functions/site.php * item_add.php
	Renamed get_site_type_rs() to get_site_type_r()

* functions/theme.php, user_admin.php
	Removed get_theme_list() and replaced with call to 'custom_select'
	widget.

* borrow.php & import/csv.php
	Updated 'Borrower History' to use the new custom_select function from
	functions/widgets.php instead of the hard coded one.

* functions/widgets.php & item_input.php
	Modified functionality of 'upload' so it can be used nicely on its own,
	without automatically appending the '_upload' suffix, which can ruin
	its use elsewhere.  Only when used with 'upload_or_saveurl' is the
	suffix '_upload' added.

* functions/widgets.php
	Moved formatting from upload(...) function to upload_or_saveurl(...) function,
	so that when 'upload' is used by itself there is no extra formatting.

	Added new function custom_select

0.51-dev10
----------
* item_borrow.php
	When processing 'Reserve' operation, I have added a check to make sure the
	item_id_and_instance_no combo actually exist.  If they don't they will be
	ignored.

* borrow.php
	Updated 'Reserve Basket' logic so that even if an item is invalid, it
	will not stop the list displaying.  Added logic to avoid displaying the
	record if it is invalid.  A minor fix for printable version of this
	page.

* functions/whatsnew.php
	Added a 'class=\"whatsnew\"' to the <a href=...> for showing updated
	items, so its text-decoration attribute can be set to 'underline'

* stats.php
	Change threshold for images to 3

0.51-dev9
---------
* user_admin.php & include/config.php
	Added $user_admin['user_passwd_change_allowed']	variable to allow
	disable of password change for users.  This does not disable
	passwd change for admin users though.  This variable is useful for
	demo sites.

* listings.php
	Added "Reserve Basket' logic to individual reserve links.

* listings.php
	Reenabled check in listings to reset listing_reservations if 
	$listings['show_reserve_basket'] is disabled.

0.51-dev8
---------
* item_display.php
	If $listings['show_reserve_basket'] == TRUE, the 'Borrow Item' and 
	'Reserve Item' links will load the Reserve Basket instead of directly
	borrowing the item.

* user_admin.php
	Added 'userid' column to the user list.

* email.php, item_borrow.php, login.php, user_admin.php, include/begin.inc.php,
  include/config.php

  	The include/config.php variable $use_php_mail has been replaced with
	$opendb_email['use_php_mail'], which is the standard approach for
	all other configuration information in OpenDb.  The include/begin.inc.php
	maintains backwards compatibility, by checking for $use_php_mail, and
	setting $opendb_email['use_php_mail'] to it.

* borrow.php & listings.php
	Implemented a 'Reserve Basket'.  This list will load
	when a user clicks the 'Reserve Item(s)' button and will display
	a list of all items reserved by the user.  They then have the
	option of removing any of the items they have reserved.  There
	is _no_ option of adding any items though.  The new config
	parameter $listings['show_reserve_basket'] can be used to
	disable this functionality if required.

	Also improved support for building up a list of reserved items accross
	multiple instances of running listings.  Now the reservations array
	is not reset if you run listings from the menu.  A new menu item
	has also been added 'Reservation Basket' to allow you to bypass
	the 'Reserve Item(s)' button in listings if you want to reserve
	items you have already chosen.

* item_borrow.php::display_borrow_results(...)
	Updated to sort successful emails by user, so that only one
	email is sent to each person.

* borrow.php, item_borrow.php, import/csv.php
	Removed '>' and '<' from buttons for $lang_var['back']
	and $lang_var['continue'].  This allows sites to configure
	this for themselves if they want it, or not if not.

0.51-dev7
---------
* functions/theme.php, theme/*/index.php, chart.php
	Updated to support 'themeable' graphs.  Refer to 
	docs/notes/themes.txt section 3) for more information.

* chart.php & stats.php
	Updated to fix some formatting problems.  Also added option
	to 'stripe' the piechart slices with alternating colours.

	Added class=\"graph\" to all generated images, so we can
	control for instance the border width and color.  All
	the themes delivered with OpenDb have been updated to
	include this in their style.css.

0.51-dev6
---------
* theme/printable/index.php::theme_image(...)
	Updated to check $type == "borrowed_item", instead of
	referencing the image names directly.

* borrow.php, stats.php, listings.php, item_display.php, 
	Updated all references to 'avail.gif', 'inactive.gif', 
	'reserved,gif', 'unavail.gif', to pass $type parameter of
	'borrowed_item' to _theme_image.  If any more status' are
	added to the system the calls to _theme_image should include
	this type as well.

* listings.php & borrow.php
	Moved some more of the 'printable' specific formatting stuff to
	the 'printable' theme itself.  This time the 'heading' went.

* lang/english.inc.php
	Updated:
		$lang_var['not_active'] = 'Not&nbsp;Active';
		$lang_var['current_user'] = '<i>Current&nbsp;user</i>';

	This is to prevent wrapping when these values are displayed in 
	listings.

* functions/theme.php::_theme_image(...)
	New arguments added:
		$class - originally in the _theme_image, but now added to the
		call to theme specific 'theme_image' call.

		$type - Specifies the origin of the image.  
				Current types being	used are:
					s_item_type - for 's_item_type' table images.
					borrowed_item - Borrow system status images.

	The spec of the theme specific 'theme_image' now looks like this:
		theme_image($src, $alt, $title, $align, $type, $class, $width, $height)

	Changed the logic so that the $alt text will be displayed if no image
	found if it is NOT NULL.  The test used to be !empty($alt).  The calls 
	to _theme_image in the main code have been updated, so that instances 
	where the $alt text can be used, it will be specified.  Where the alt
	text cannot be specified, and nothing else is suitable, an alt value 
	of "", will be specified instead.  This indicates that the image
	is not required and can be safely ignored.  You can override the new
	functionality in your own theme 'theme_image' functions anyway.

* functions/parseutils.php::get_mask_variable_value(...)
	Replaced $lookup_attr_r['display'] (as $alt parameter) in call to _theme_image
 	with NULL.  This will indicate to themes that these images cannot be replaced
	with 'text', and to do so is risky.

* functions/widgets.php::format_display_value(...)
	Replaced $value (as $alt parameter) in call to _theme_image with NULL.  This
	will indicate to themes that these images cannot be replaced with 'text',
	and to do so is risky.

* login.php, email.php
	Changed _theme_image call for 'email.gif' $alt argument from NULL to "".

* borrow.php, listings.php, item_input.php, functions/item.php
	Changed $alt parameter for 'rs.gif', from "*" to NULL.  
	Changed $alt parameter for 'linked.gif', from "L" to NULL.  
	Changed $alt parameter for 'ticks.gif', from "!" to NULL.  
	
	It makes more sense to include this image even in a text theme.

* borrow.php, listings.php
	Changed _theme_image call for 'printable.gif' $alt argument from NULL to "".

* functions/theme.php::_theme_image(...)
	Small logic fault fixed.  Would only be encountered where _theme_image called
	with an empty $alt value.

* functions/item.php::get_item_image(...)
	Removed parenthesis from around $s_item_type when used as $alt value to
	_theme_image.  This formatting can be manually specified by specific 
	themes if required.

0.51-dev5
---------
* functions/site.php::convert_html_numeric_codes(...)
	Updated function to pass in a $lookup_table for unknown html entities.  Used
	specifically by Amazon.fr for &#8211; ('-') characters.

* item_display.php
	Modified display of attributes and category, so that only attributes/categories
	that are NOT empty will be shown.  Originally the test was for NULL, which 
	meant attributes in the database with an empty value would be displayed. This
	honestly makes no sense and has been fixed.

* functions/item.php, functions/item_attribute.php, functions/review.php
	Added logic to replace WINDOWS & MAC newlines with UNIX newlines.  This will
	ensure consistent data.  However there is no logic in the database that can
	rely on UNIX newlines only, as OpenDb has been in use for a while now.  This
	is just for convenience sake.

* item_input.php
	Removed $HTTP_VARS['op'] == "abort_operation" block, as not used.
	Updated refresh functionality again to perform the same trimming and conversion
	to the site plugin variables as to the original attribute value, so we ensure
	we are comparing the same thing.  This removes the need to rely on site plugins
	returning the correct information.  Added the same trimming, etc to the 'new'
	and 'site' op's for new items as well, so everything is standard.

	Updated refresh functionality to include 'refresh' indicator for title if
	updated.

* patch.php
	Updated to notify users that older patches will no longer upgrade them to 0.51.
	This is because I am sick of having to test all these older patches, and keep
	adding all these new upgrade statements to them.  Now I don't have to :-),
	and for the user the result will still be the same, a full 0.51 environment,
	for one extra step.

	Also updated script to include a ''?? Rows affected)' statement next to
	'Update successful message', to notify users of whether a patch actually
	updated a row.  The fact it did not, only indicates that either the row
	does not exist, or already had the required value set.

* stats.php & chart.php
	Andrew Donkin contributed changes to stats.php & chart.php to fix some small
	display problems with the graphs.  The changes also included options to
	sort the graphs and generate bar charts instead of pie charts.

* functions/widgets.php
	Updated checkEmail(...) javascript function to do more checking, so that we
	do not get to a state where the user can enter an invalid email on update/insert,
	but the functions/email.php script complains because it does a more exact
	check.  The check done by the javascript is now the same as that done in php,
	(even if we do it manually in javascript to avoid using regular expression matcher
	which I don't like being committed to!)

* item_input.php, user_admin.php, import/csv.php
	Moved all mysql_errors into their own <div class="smerror"> for nicer formatting.

* item_input.php,item_review.php,user_admin.php 
	Updated insert/update operations to ensure that minimum required fields are
 	specified.  This is to defeat attempts to bypass javascript on client side.
	Not all validation is performed.  For instance in item_input.php, only
	$title validation is done, even though there may be compulsory attributes.

* borrow.php, user_admin.php, tbl_dump.php, stats.php, login.php, listings.php,
  item_display.php, item_borrow.php, add_item.php, functions/widgets.php,
  functions/listings.php, functions/email.php, site/imdb/functions.php, 
  item_input.php
  	Updated to use new replace_lang_vars version.  This version is preferred
	because it should be a little quicker.  (only one array instantiated,
	vs. two for the original version)

* functions/language.php::replace_lang_vars(...)
	Updated this function to support specifying a single array of
	keys/values.  The keys will be used to search the lang_var,
	and the matching value will be the replacement text.  The
	old functionality is still supported.

* item_input.php, $item_add.php
	Updated to ensure that we specify the {instance} value for
	$lang_var['refresh_title'] and $lang_var['edit_title']

* item_display.php
	Changed title display to use new $lang_var['display_title'] variable.

* $listings.php, borrow.php
	Changed title display to use new $lang_var['list_title'] variable.

* lang/english.inc.php
	Updated:
		$lang_var['edit_title'] = 'Edit "{title}" {instance}';
		$lang_var['refresh_title'] = 'Refresh "{title}" {instance}';

	Added:
		$lang_var['display_title'] = '"{title}" {instance}';
		$lang_var['list_title'] = '{title} {instance}';

* functions/widgets.php
	Modified display widget 'split', to be a bit clever about the type of
	attr_match to use.  For split(...) calls which specify a non-space
	delimiter, we specify 'partial', as it is assumed that the value is
	being split for the purpose of list links alone, and that it is not
	actually a multi-value attribute (Each value is space separated!)

	Modified arguments to 'split' widget.  Now the second argument can be
	one of 'nl2br, ordered, unordered, ticks' and the list will be formatted
	similiar to the '??????_list' with the same prefix.  The 'list-link'
	can still be specified as argument 2, in which case original functionality
	will still work as expected.  Now 'list-link' can be specified as argument
	3, if required as well.

	Added class="listlink" to all list-link Anchors, so that themes can specify
	underline for these links to make them stand out.

* item_input.php
	Added 'Back to Item' link for 'Delete Aborted' operation.  The 'Back to Item'
	will return to the item for which the deletion was aborted.

	When editing/inserting a linked item, the instance_no of the parent (if >1), 
	was not being included in the title.  This has been rectified.

* item_display.php::get_item_status_row(...)
	Removed references to $item_r, which were causing invalid tests, and allowing
	'Reserve' links to be displayed even though the user has already borrowed
	the item.

* themes functionality
	Moved the theme/default/images and theme/default/templates/ contents into
	the $OPENDB/images directory.  Now all themes without images or a 'theme_image'
	function will default to use these images.  As a result of this I removed the
	images subdirectory from the 'horizontal' theme and 'default2' theme
	distribution which both use the 'default' images already.

* include/menu.php
	Added a new function to menu.php called get_hierarchical_menu_options.  This
	function returns the menu structure formatted into a hierarchy, with the 
	following structure:
	
		+Item
			Add New Item
			Import My Items
			List All Items
			List My Items
			All Other Items
		+Borrow
			My History
			Items Borrowed
			Items Reserved
			Item Check Out
			Item Check In
		+User
			Edit My Info
	
		-Item Search
		-Statistics

		+Admin
			Borrower History
			List All Users
			Add New User
			Import Items
			View Log File
			Backup Database

		-Logout

	This function is provided to give theme designers more flexibility in
	the design of their menus, without resorting to reimplementing the
	functions in include/menu.php.  (In some cases this will still be
	required, especially when images are involved.)

* images/ New images for GAME (Both for item_type and game-system) & BOOK
have been provided by Marc Powell.  Please rerun the 'game.sql'
system data from the 'Extras' section of the Patch utility to
see all the new images.

0.51-dev4
---------
* functions/theme.php::_theme_image
	Minor error in formatting an IMG tag fixed.
	
* import/csv.php
	Hardcoded 'type' input field in initial form of the csv script. Removed
	reference to the $lang_var['upload_failure'] in favour of the same
	one used for 'upload' and 'upload_or_saveurl' widgets, specifying 'CSV'
	as the prompt.

* functions/widgets.php:saveurl(...)
	Modified functionality where a local filespec is saved as an attribute,
	but no longer exists.  In 0.51-dev3, I was setting the attribute to
	empty, without informing the user.  Now I will leave as is, but no
	logic for preventing the use of the 'Save' checkbox.  But in the
	case of non-absolute URL's this value will be ignored anyway.

* functions/item_attribute.php & functions/review.php
	Updated insert_item_attribute(...), update_item_attribute(...) & 
	insert_review(...) to replace windows/mac line endings with unix 
	single character ones.  This will not affect existing database records,
	but only help to standardise what goes into the database in the future.
	item_display.php already handles WINDOWS, MAC & UNIX line endings
	anyway.

* item_input.php
	Fixed a small problem with refresh functionality.  Also fixed issue with
	'Back to Item' link for Linked items.  It should include parent_id, and
	parent_instance_no, as well as item_id.

0.51-dev3
---------
* All styles & item_input.php, stats.php, functions/widgets.php
	All input fields now use 'prompt' class for the prompt field,
	and 'data' class for the data field.
	Replaced all references to 'failure' class with .'error'

	A lot of changes to remove style classes that were not being
	consistently used.  Now the 0.51-dev3 default theme style.css
	should be used as a resource for creating your own themes.

		New		-> Old
		--------------------------------------------------------------------
		.smsuccess	-> is .small
		.prompt		-> includes the .top background color.
		.data		-> includes top2 & .head (except for color)
		.navbar		-> includes the .head class, added text-align: center
		.menutext	-> is .plain
		.help		-> is .footer
		.printtitle	-> is .blocktitle
		.alphalist	-> is like .footer

* user_admin.php, stats.php, search.php, patch.php, listings.php,
  item_input.php,item_display.php, import/csv.php, borrow.php
  	Changed the div class="footer" to class="help" for all help
	text.

* logfile.php, functions/listings.php
	Modified some of the formatting so that themes can make better use
	of style sheets.

* New images added for 'DTS' and 'DOLBY' Audio language types.  They
are only available to new users at the moment however, because I have
only modified the original install.sql script to reference them.

0.51-dev2
---------
* functions/theme.php
	Separated the image location logic into theme_image_src function so
	it can be used separately inside themes themselves for automating
	multi-language support.

0.51-dev
--------

* site/imdb/functions.php::parse_imdb_data(...)
	In the genre portion of the logic, added a preg_replace statement to
	get rid of excess whitespace between the genre items, so that the
	refresh operation would function correctly.

* item_input.php & functions/widgets.php
	Revised functionality for 'upload', 'saveurl' and 'upload_or_saveurl' 
	widgets.  The logic is much more elegant now, and even the layout
	of the widgets in item_input.php looks a lot better.

	Updated item_input.php to provide improved support for Refreshing
	items.  Now an attribute can be refreshed if the new value is
	larger than the current one.  Included a 'Star' image beside
	each attribute that was updated as a result of the refresh
	operation.

	In order to display the 'Refresh' star image in the prompt
	area of a field, I added a optional $prompt_mask parameter
	to get_attribute_field(...) and get_input_field(...).  This
	mask looks for %prompt% to decide how to format the final
	prompt cell.

* user_admin.php, borrow.php, listings.php, functions/listings.php,
  include/menu.php
	Added Heading sorting for 'All User' listings.  Also modified 
	functions/listing.php to do all the sortorder logic internally.  
	Updated borrow.php, listings.php calls to get_column_header(...) 
	to support this change.  Updated menu link for 'List All Users'
	to include the order_by=fullname&sortorder=ASC logic, which
	is required so that the sort order stuff does not get confused.
	Also updated user_admin.php to display the user type even when
	'Normal'

* functions/site.php & site/imdb/config.php & site/imdb/functions.php
	Inclusion of EXPERIMENTAL support for automatically translating
	IMDB plots to another language.  Uses the Google language tools
	which currently only support {german,spanish,french,italian,portuguese}

* *.php
	Almost all php runnable scripts were changed to include a new parameter
	in call to theme_header(...) for the page title.  This often required
	a restructure of the calls to theme_header(...) as well.  Whereas 
	previously there might have been only one call in the whole script, now
	there will be one in each block, that actually gets run, so we can set
	a context title.

* functions/item.php::from_and_where_clause(...) & 
  functions/user.php::is_user_valid(...)
  	The UPPER sql keyword was being used incorrectly to strtoupper the values
	being passed into the function.  Such as $uid, $title, $attribute_val.  This
	was inefficient, and also caused problems for LIKE clauses.

* login.php
	Added logic to allow redirection from login.php to original script
	if login was required because of 'invalidsession'.  This will not
	work if login attempt was made from login.php because of a new
	login or because of a log out action.  Thanks to Andrew Donkin
	for this feature.

* include/invalidsession.php
	Instead of specifying 'op' = 'invalidsession', now specify 
	'invalidsession' = 'true'.  This is so that we can redirect users
	to the actual page they wanted without getting into trouble where
	'op' is being use.

* functions/http.php::get_url_string(...)
	Added extra $exclude_keys_r variable to exclude particular elements
	from the first argument.

* site/imdb/index.php
	Modified to use $HTTP_VARS['imdb_id'] if specified to refresh item,
	instead of going through the whole search for title process.

* include/begin.inc.php
	Now includes reference to $HTTP_SESSION_VARS if $_SESSION is not empty 
	and $HTTP_SESSION_VARS is.

* functions/theme.php::get_user_theme_r()
	Updated to return empty array if no themes found.
	
* functions/site.php::get_site_type_rs()
	Updated to return empty array if no themes found.
	
* item_add.php
	Added functionality so that site plugins can specify
	more than one field, but specify it as 'hidden' if
	it is only required for refresh operations.

* lang/english.inc.php
	Added:
		$lang_var['site_search']

0.50p3
------
* include/config.php
	A few minor issues reported in Bug #569512

0.50p2
------
* include/menu.php
	Minor fix for 'Backup Database' link which included two 'alt' entries in
	the menu item array.

* import.php
	Still using $GLOBALS reference.  Updated to use $HTTP_VARS instead.

* include/config.php & listings.php
	The config variable $listings['show_reserve_link'] was incorrect.  Changed
	to $listings['show_refresh_links']

* login.php
	$op = "login" was using strtolower on $http_vars['uid'] instead of $HTTP_VARS['uid'],
	this was causing problems if someone tried to login using their user id, and it
	had a uppercase letter in it.

* functions/whatsnew.php
	Minor fix of url format.

0.50p1
------
* item_display.php
	Minor update to increase size of popup window to avoid scrollbar - for local
	images where imagesize is known.

* site/freedb/functions.php & site/freedb/index.php
	Implemented functionality to being able to navigate through more than one page
	of titles.  This is in response to feature request 
	551271::Better searching of freedb.org

* borrow.php
	A small fix for 'Check Out' item status where items are reserved.

* functions/http.php
	Revised get_valid_extension(...) logic to use native php functions for better
	performance.

	Revised get_file_ext(...) to be a bit more explicit in the if test, so as to
	avoid any confusion or latent bugs in php versions.

0.50
----
* patch/extras/game.sql
	Modified the order of attributes in system data.

* item_input.php
	Added link to item_display.php for Update / Refresh operations.  But only when
	user is owner of item they are attempting to update.

* docs/*
	Many documents revised as part of 0.50 final release.

* theme/default/style.css, theme/horizontal/style.css, theme/orange/style.css &
  theme/simpsons/style.css
  	Updated A:active to remove font-weight:bold; in favour of text-decoration:none; 

* patch/extras/no_discs.sql
	Added a new script for recording number of discs in an item.

* functions/listings.php::print_alphanumeric_sorter
	Added class=\"alphalist\" to the <a href ...> alpha list links to provide more
	flexibility for themes.  The format of the alpha list should be the same as
	that for the links in the footer.

* login.php
	Backing out change from 0.50-dev27 where the strtolower statement against the
	$uid was removed.  All userid's should be lowercase.  I will supply a script
	to set all userid's to lowercase in the database.

* functions/whatsnew.php & login.php
	Included a $not_owner_id link so that the current users own items are not 
	included in the 'Items Updated' count.

* listings.php
	A few small fixes for problems with the display of titles and Borrow / Edit
	options.  The title was actually wrapping in a strange place.

	A small problem with the logic to maintain checked reservations across pages.
	If all the checked items saved in session were on the current page and they
	were subsequently all unchecked the page would still be submitted even though
	there were no items left to reserve.  This has been fixed.

0.50rc2
-------
* functions/http.php::save_upload_file(...)
	Fixed problem with images being corrupted when downloaded on Windows servers.
	Specifying "wb" to the fopen call was all that was required.

* functions/patchutils.php::get_file_list()
	Now returns an Empty array if no files found that match extension.  This
	is instead of a null variable, which causes exceptions.

0.50rc1
-------
* logfile.php
	When using 'Show more hightlight fields' or 'Show Less highlight fields' the
	logfile was also being displayed.  This has been fixed.

* listings.php
	If items enough items were deleted that the last page listed no longer 
	contained items, the 'Back to Listing' link would return an empty page
	without providing the ability to migrate back a page.  Now listings
	will check the page_no and modify it, if it is too large for the
	current total_items count.

* functions/listings.php
	Modified the sortOrder javascript function to reset the page_no = 1.  This
	was to restore original functionality, where a reorder of the the items 
	based on a column should reset the LIMIT specified to the SQL command.

* item_review.php
	Changed $op to $HTTP_VARS['op']

* functions/item.php::get_instanceno_text(...)
	Modified the format of the instances > 1.  Originally the instance was
	formatted (#?).  I modified this to [#?] as '(...)' is being used for
	include the YEAR, or Artist, etc.  The '[' brackets make it stand out
	a bit more.

* patch/dvddbp/index.php
	Updated to ensure that $db_server['table_prefix'] is NOT defined when this
	patch is run.  Parts of the process will not work if this variable is set.

* patch/prefix/index.php
	Small fix to ensure both buttons are disabled if $db_server['table_prefix']
	config variable is not defined.

* stats.php
	Changed 'threshold' url parameter from 0 to 1 for 'Item Types:' graph, as
	it was causing '0%' values to be displayed for some types.

* functions/email.php::get_site_url()
	Small modification to improve support for https protocol.

* item_input.php
	Modified 'Back to Listings' functionality to work for 'Update','UpdateInstance',
	'Delete', 'DeleteAbort','AbortOperation' as long as listing_link=y.

* import/csv.php::get_file_type(...)
	Fix to ensure file extension is NOT matched in a case sensitive
	way, so that both csv and CSV will be matched, as well as CsV, etc.

	Replaced original get_initcap_field(...) function with a call to the new
	checkbox(...) widget which supplies a value even when the checkbox is
	unchecked.  This allows the checked status of the INITCAP checkboxes to
	be retained, when the Back button is hit.
	
	Updated get_field_value(...) to use the default value if CSV column value
	is specified but empty.  Previously if a CSV column was defined, then the
	default would have been ignored.
	
	Updated main section to check for the 'Item Type CSV Field' when register_globals
	=Off.

* functions/widgets.php::is_lookup_value_found(...)
	Fix to ensure match is NOT case sensitive.  Also modified matching logic
	slightly for performance improvement.

0.50-dev38
----------
* login.php
	Update to allow configuration of a message for logged in users when accessing
	the start page (often the login.php script).  You must define a variable 
	$lang_var['logged_in_welcome'] which will be used instead of 
	$lang_var['login_welcome'] when a person successfully logs in, or is
	already logged in.

* lang/english.inc.php
	Updated:
		$lang_var['borrow_help'][]

	Added:
		$lang_var['logged_in_welcome']

* functions/email.php, functions/function.php, tbl_dump.php & include/begin.inc.php
	Updated these scripts to use get_http_env(...) in place
	of getenv(...) and specific logic for $HTTP_SERVER_VARS
	or $_SERVER arrays.

* functions/utils.php
	Added a new function get_http_env(...) function to do the
	work of getenv in both php 4.0.x and 4.1.x/4.2.x environments.

* functions/email.php:get_site_url()
	Updated to support SSL protocols.

0.50-dev37
----------
* patch/install/opendb.sql
	Minor grammar fix

* functions/widgets.php & item_input.php
	Moved get_item_attr_filename(...) from widgets.php to item_input.php
	as this is the only place it is used.

* functions/user.php::fetch_user_cnt(...)
	Added a space between 'FROM user' and start of 'WHERE' which
	was causing the stats page to not display a current count of
	users.

* site/imdb/functions.php
	Small fix for Actors block provided by Dick Balaska

* functions/widgets.php
	Updated saveurl(...) widget to display Current value of field as
	a readonly value.  The 'View' button has been removed in favour
	of a more integrated link where the display only value is positioned.
	This can all be rearranged by modifying the $lang_var['saveurl_prompt']

* lang/english.inc.php
	Modified:
		$lang_var['add_title_artist']
		$lang_var['user_deleted']
		$lang_var['user_not_deleted']
		$lang_var['saveurl_prompt']

	Added:
		$lang_var['site_page_redirect']

	Removed:
		$lang_var['view']

* site/freedb/index.php
	Updated to automatically load item_input.php script.

0.50-dev36
----------
* item_input.php
	Yet another fix to the refresh / site logic for linked items.  This has
	been tested a bit more now, so should be all working satisfactorily.

0.50-dev35
----------
* include/begin.inc.php
	Added a reference to $HTTP_POST_FILES if $_FILES is not empty, and $HTTP_POST_FILES
	_is_ empty.  This is because the import and item_input routines make reference to the
	$HTTP_POST_FILES array.

* item_input.php
	When using 'refresh' operation and an input field is set to 'upload', 'saveurl' or
	'upload_and_saveurl', the imageurl passed from the site plugin was being ignored.

0.50-dev34c
-----------
* item_input.php
	A very minor bug when using for refresh operation against site plugin.  Would only ever
	be a problem if category was not defined, because title would be reset.  And then this
	would only ever be a problem if you chose a different title in the refresh operation.

0.50-dev34b
-----------
* import/csv.php
	The is_exists_title(...) test was broken.  This was allowing duplicate titles to be
	imported by the same owner without even so much as a warning.  This has now been
	changed back to the original functionality of not allowing duplicates whatsoever.

0.50-dev34
----------
* listings.php & include/config.php
	New configuration variable $listings['show_reserve_link'] added to configure whether
	the refresh links are shown.  The addition of refresh links to the listings.php
	page will currently slow it down (I will improve logic later on, but not now!),
	so for users interested in performance this variable should probably be set to FALSE.

* listings.php
	Small bug with title display for linked items, where the parent_id was being used
	for gathering item_attribute stuff.

* item_display.php & item_input.php & listings.php
	Backed out the addition of op=refresh in calls to item_add.php due to new changes to
	item_add.php.

* item_add.php
	Changed in dev33 to move most of the logic into a separate function required the addition
	of a global reference to $lang_var.

0.50-dev33
----------
* patch.php
	A small fix to the notes, because the explanation of which patch to use was erroneous.

* borrow.php
	A small fix to display the status image instead of text, because of an invalid text
	for "mode" == "printable"

	A small fix to the Borrower History section, to specify 'Borrower' instead of 'Owner'
	prompt.  Reported by Andrew Donkin.

* lang/english.inc.php
	Removed duplicates:
		$lang_var['available']
		$lang_var['backup_database']
		$lang_var['borrower']
		$lang_var['delimiter']
		$lang_var['unavailable']

	Modified:
		$lang_var['item_add_intro']
		$lang_var['backup_help'] entry
		$lang_var['upload_csv_file_help'] entry
		$lang_var['thanks_for_using']

	Added:
		$lang_var['refresh_linked_title']

* import/csv.php
	Call to prc_format_type was changed to new function name prc_function_spec.

* functions/item.php
	Small fix when no http parameters specified when calling listings.php

* item_add.php
	Restructured a lot of this script to support refreshing linked items.  Cleaned
	the code up a lot to make it more understandable and maintainable.

* item_input.php
	Modified script to support refreshing linked items as well.

0.50-dev32
----------
* search.php
	Still some hardcoded 'ALL' options in the category SELECT functionality.  I replaced
	with the $lang_var equivalent.

	The unique list of attributes was being sorted based on key, which meant that
	the CD categories were at the end of the list, as the values were all in lowercase.
	I have changed the sort to sort by value instead.

* listings.php
	Updated script to register the 'Back to Listings' session variable at the end of
	the script, so I can set the 'total_items' variable to null, because if I modify
	an item (for instance change the status) to something different so that it would
	normally be not displayed in the original list, the presence of the total_items
	variable means that the totals, page numbering, etc are incorrect.

* borrow.php
	A small bug with displaying the titles, due to a function name change in
	dev31.

0.50-dev31
----------
* functions/listings.php, import/csv.php, listings.php, item_add.php, site.php,
  parseutils.php
  	Added new functionality for conditional mask inclusions.  Currently only
	support "ifdef(s_attribute_type, 'mask')" function, but others may be
	added.  Also changed some function names to remove the _display_ bit.

* formatext.php renamed parseutils.php
	The prc_args, etc functions moved here from functions/widgets.php	

* import/csv.php
	Fixed a bug introduced during 0.50 development where the '< Back' button
	option on the 'Trial' page would actually load the Upload 'Preview' page
	instead of going back to part 1 of the 'Process CSV File'

* stats.php
	Split up the Not Available / Inactive headings so that you can see 
	exactly what is borrowed out and what is set to inactive.

	Modified the calculation of Category percentages to correctly 
	calculate based on the number of occurences of categories, not on 
	the number of items.

* site.php
	Updated to only do the check_url($site_external_link) check when 
	the plugin is first loaded.  The first call to the site plugin is
	for the $op == "search".  Changed suggested by Andrew Donkin.

* item_display.php
	Modified call to get_item_image(...) to include check for whether
	linked item or not ($parent_id not empty in $item_r record)

	Also modified logic to remove check_url() call for Cover image.  If
	the cover image does not exist, a broken link will be displayed
	instead.  This is an attempt to improve the performance of the
	item_display.php script and reduce traffic through the OpenDb
	web server.  Changed suggested by Andrew Donkin.

* include/begin.inc.php
	Added an include for include/local_config.php.  This was added
	after the include statement for include/config.php.  This allows
	sites to maintain their own local configuration which will not
	be overwritten by installing a new distribution.  Changed suggested
	by Andrew Donkin.

* functions/item.php::get_item_image() to include the linked.gif
	if $islinked parameter = TRUE.
	
* item_input.php
	Changed the 'Back to Item' links to point to item_display.php
	instead of to item_input.php.  Somewhere along the line this
	was changed from 0.39 where is was acting correctly.
	
* functions/listings.php, borrow.php & listings.php
	Stole the idea from phpMyAdmin to include a asc_order.gif
	or desc_order.gif image beside column headings when the
	listing is sorted by that column.  The images are themeable.

	Modified so that if a new column is selected to order by, the
	current sortorder is used instead of switching it.

0.50-dev30
----------
* functions/theme.php
	Moved get_menu_options function to new script include/menu.php.  This is to
	make this function more accessible to modification until a more flexible
	menu configuration system is worked out.
	
	The include/config.php variables $menu_config['list_all_items_link'] and
	$menu_config['list_others_items_link'] have been removed.  These variables
	were too much of a hack for my liking and so I have removed them before people
	really start to get used to them.
	
* functions/item.php::get_item_image(...)
	Updated to specify the s_item_type.description for the IMG title
	text.  The alt text is still the s_item_type.
	
* All root scripts, include/language.php, include/theme.php & functions/whatsnew.php
	Removed include_once("./include/config.php"); statement.  Moved this
	statement into include/begin.inc.php.  This makes sense because each
	of these scripts includes begin.inc.php anyway.  This will make it
	easier in the future to get the configuration information from the
	database or somewhere similiar because it will all be done in begin.inc.php.
	
	The require_once("./include/begin.inc.php"); statement must occur before
	any other include_once statements.  Especially before any includes for
	include/theme.php or include/language.php.
	
* functions/site.php & item_add.php
	Added a new include/config.php variable $item_add['site_plugin_order']
	which can be used to specify the display order of site types.
	
	A new function has been added to site.php::get_ordered_site_type_rs(...)
	and a call added to item_add.php to accomplish this functionality.
	
	The $item_add['site_plugin_order'] variable does not have to include
	a array element for every site plugin, but only those that you want
	to appear first.  This means that new plugins can be added without
	the need to add an entry to this variable.

* patch/extras/book.sql, patch/extras/mp3.sql, patch/extras/game.sql

	book.sql:
		Updated the s_item_attribute_type order_no for a more logical layout
		of input/display fields.  There is no update script for existing users
		of the BOOK type though, so be wary of using this updated script.

	All of the scripts were updated to include DELETE statements to allow
	the reinsert of the system data.
	
* functions/formatext.php
	Updated expand_title_display_mask(...) to support specifying a option to
	any {s_attribute_type} variables which hooks into the s_attribute_type_lookup
	table.  The use of these options will slow down the generation of the
	listings page, but it does add quite a bit of flexibility.
	
	You can now specify .img, .display, .value options in the following way:
		{s_attribute_type.img}
		{s_attribute_type.display}
		{s_attribute_type.value}
		
	This functionality will ONLY work for item_attribute records which have
	an EXACT match to a value in the s_attribute_type_lookup table.  Generally
	you should only use for fields populated with radio_group/single_select

* functions/widgets.php
	Moved my_explode(...) function to functions/utils.php.  This function is
	not currently being used, so this was not a serious change.
	
	Moved parse_title_display_mask(...), expand_title_display_mask(...),
	is_legal_code_char(...), initcap(...), ucword(...), is_roman_numeral(...),
	is_nonword_char(...), is_alpha(...) to new formatext.php script.
	
	Disabled test "if($size == $maxlength)" in favour of always setting $size++.
	This is so we can use filtered length and maxlengh in particular ways to 
	ensure all fields line up, even if they do not accept the same number of 
	characters.  For instance we might want a field that accepts 4 characters 
	to actually be displayed the same size as a field that accepts 6, so they
	line up nicely.  Unfortunately the previous logic would increase the field
	that accepts 6 characters to a length of 7, but would leave the field that
	accepts 4, at a length of 6 characters as originally specified.  If Mozilla
	fixes this problem we may remove.

* functions/email.php::get_email_footer()
	Replaced call to custom function explode_lines with the
	standard explode("\n", ...) function.  The beauty of this
	is that any white space either side of a newline is respected
	and included in the calculation of the biggest line length
	for the addition of the dashed horizontal lines.

0.50-dev29
----------
* functions/email.php::get_email_footer()
	Updated to support language configuration for the email footer.  The $lang_var['email_footer']
	will configure the complete footer minus the dashed lines that separate the message
	content from the footer.  The variable recognised are {site},{version},{site_url}

* lang/english.inc.php
	Added:
		$lang_var['email_footer']

* functions/email.php::get_site_url()
	Updated function to support PHP 4.2.0.  Also changed 4.0.x support to reference the
	$HTTP_SERVER_VARS array instead of using getenv(...) function.

* patch/install/index.php
	A small fix to this patch which was broken in dev22 from what I can tell.

0.50-dev28
----------
* lang/english.inc.php
	Added:
		$lang_var['list_others_items']

* functions/theme.php
	Included logic to configure inclusion of 'List All Items' and 'List Others Items'
	links.  The default is to include the 'List All Items' but not the 'List Others
	Items' links.
	
* include/config.php
	Added new configuration variables:
		$menu_config['list_all_items_link'] = TRUE; // Include the 'List All Items' link
		$menu_config['list_others_items_link'] = TRUE; // Include the 'List Others' Items link

* functions/item.php
	Added ability to specify a $not_owner_id so that a list
	of all items _except_ a single owner can be displayed.  Will
	be used for new menu item 'List Others' Items'
	
* docs/*
	Reformat some of the documentation.  Moved some of the
	older more confusing documentation into the notes/ 
	subdirectory. Updated the Readme to reflect new structure
	and remove old erroneous statements.
	
0.50-dev27
----------
* include/begin.inc.php
	Started testing OpenDb for compliance with recommendation
	to set register_globals php setting to Off.  Discovered that
	$PHP_SELF is no longer registered in this case.  What a pain'
	in the ass this is. To get around it, I register this variable
	in begin.inc.php now.

* functions/function.php & functions/utils.php
	New utils.php script has been created and the general utility
	functions originally in function.php have been moved here.  
	Include statements for functions/utils.php have been added
	to all the scripts that use these general utility functions.
	
* item_add.php
	A few minor changes to cleanup the code a bit.  No longer call
	is_exists_item_instance(...) function for the parent_id/parent_instance_no
	for performance reasons.  Changed some isset(...) tests to empty(...)
	tests to be more explicit.
	
* item_display.php
	A error in the display of Item Instances has been fixed.  Only occurred
	when register_globals = Off.
	
* item_input.php
	The display of child items displayed the headers in the wrong order,
	this has been fixed.
	
* user_admin.php
	Fixed a problem with the theme not being updated for the current session
	when changed.  This only happened when register_globals = Off.  The variable
	had to be set using the $HTTP_SESSION_VARS array now.
	
	Modified logic to trim and strip_tags for $uid before checking if user
	exists.  Otherwise a condition where a user could enter a new userid with
	html code that would be stripped before insert, but which is originally left
	in for is_user_valid test.  The is_user_valid(...) test in user_admin.php
	when a new user is being added will do a case INSENSITIVE test to ensure
	that two users with the same userid, only differing in case cannot exist
	in the system.  For performance the rest of the comparisons will be done
	without case comparisons though.
	
	The insert_user operation first sets the new Uid to lowercase before
	inserting into the database.	

* patch/dvddbp/index.php
	Updated this script to set owner_id for review,item,item_instance,user to
	_lowercase_ before inserting into the new opendb tables.  This is inline
	with the changes to user_admin.php which sets the user id to lowercase when
	inserting new user.
	
* functions/user.php
	Updated fetch_user_r(...) and fetch_user_cnt(...) to be more explicit
	with the arguments being passed, rather than just using booleans to
	indicate whether only Owners or Borrowers/Owners should be selected.
		Scripts affected: 
			stats.php
			search.php
			import/csv.php
			user_admin.php
			borrow.php

* functions/user.php, functions/item_type.php, functions/item_attribute.php
	The user of if(length(ifnull(column,''))>0 is unecessary as what we want can
	be achieved	without the ifnull bit as if a column is null, the if test will
	return false, thus returning the default anyway.  All occurences of this
	test will have the ifnull bit removed.
	
* lang/english.inc.php
	Updated the $lang_var['site']['freedb'] input fields text to include a 
	title / artist hint.
	
* site/freedb/index.php,logfile.php & import/csv.php
	Problems with HTTP global variables being referenced.  This is has 
	now been fixed.
				
0.50-dev26
----------
* item_borrow.php::send_notification_email(...)
	Modified to support being passed more than one item for a
	To: user.  This is the first step to allow for much more
	efficient Reserve/Cancel/Checkout/Checkin email notification.

* functions/listings.php::remove_session_array_values(...)
	A bug was closed, which caused errors in listings.php in some
	cases.

* functions/http.php
	The is_url_absolute updated to support more than just http://
	protocol.

	Added a get_opendb_url(...) function as a start to the provision
	of a transparent resource cache for OpenDb images and site plugin
	pages.

* functions/formatfield.php
	Renamed to widgets.php

	Updated all the scripts that include_once("functions/formatfield.php")
	to include_once("widgets.php").  I made this change as this script
	has a lot of stuff in it that is very generic and no longer necessarily
	all to do with formatting fields.  A lot of utility functions are going
	into this script too now.

* functions/widgets.php
	Added a new 3 argument version of checkbox to ensure that even if checkbox
	is unchecked, that a value is transferred.  An update of the prc_args(...)
	function was necessary to allow for placeholder ',' for parameters, so
	that overloaded widgets could be supported.

	Here is the function prototype:
		checkbox(checked-val,unchecked-val,display_mask)

	You can however use it like this:
		checkbox(Y,N,)

	Where the display_type is missing, but an extra ',' is used as a placeholder,
	this is required, otherwise you would get the older version of checkbox,
	which is useless for s_attribute_type input_type use.

0.50-dev25
----------
* functions/function.php
	Added new function is_not_empty_array(...) which returns true if only argument
	is array and has count>0.  It was really starting to piss me off that I had
	to always use the combination of is_array(...) && count(...)>0 to ensure a
	valid array object.
	
		Scripts updated:
			listings.php
			functions/listings.php
			item_borrow.php
			
	Probably more as I continue the major overhaul of all the scripts for 0.50.
	
* functions/listings.php, listings.php, item_borrow.php
	I finally worked out how to allow unchecking checkboxes of session saved items
	in listings.php.  I generate a list of items that are checked as a set of
	hidden variables.  Then when the page is submitted I check if there are
	any differences between this list and the newly submitted list.  Any items in
	the old list not in the new are removed from the session array before
	merging the new list with the session list.

* functions/function.php:is_opendb_session_valid(...)
	Updated this function to actually do what I claimed it would do with the changes
	to session duration.  A problem with the local session variable definition has 
	been sorted out.  Also removed the passing in of the $HTTP_SESSION_VARS as it
	was superfluous, as we can use global $HTTP_SESSION_VARS instead.
	
0.50-dev24
----------
* item_borrow.php, listings.php, functions/listings.php
	Updated to support reservations accross multiple pages.  Stores reservations in
	session variable and does intersect on this session variable against newly selected
	reservations and processes all together.  
	
	No support for multi-page checkout/checkin/cancel as yet.  Still some issues to 
	iron out.  For one thing there is no support for deselecting items once they have
	been added to the session variable.  I will investigate the options for this and
	update logic as required.

* login.php, logout.php, include/config.php, functions/function.php
	Updated login.php to set a login_time and last_access_time session variables.  The
	last_access_time variable will be updated on each successful access to a page.
	The last_access_time/login_time variables will be compared against the new
	include/config.php variables $opendb['idle_timeout'], $opendb['login_timeout'].
	The $opendb['idle_timeout'] variable will be used to configure how long a session
	remains active when idle.  If set the $opendb['login_timeout'] configures how long
	the session can remain active overall.  The $opendb['login_timeout'] variable acts
	just like the original $opendb['timeout'] variable.  If $opendb['timeout'] is
	encountered instead the $opendb['idle_timeout'],$opendb['login_timeout'] are
	both assumed to be the same as $opendb['timeout'].  If the $opendb['login_timeout']
	variable is not set, no maximum session time is configured.  If $opendb['idle_timeout'],
	$opendb['login_timeout'] and $opendb['timeout'] are _not_ set the session will never
	expire.

* site/freedb/config.php
	Updated $max_titles_list = 250.  This is a hack for how.  I will need to look at
	improving the display of matches returned from this site plugin.
	
0.50-dev23
----------
* borrow.php, listings.php, functions/listings.php
	Updated to use a single form for navigation.  This is the start of the functionality
	to store reservations,cancel_reservations,check-in,check-out items between pages in
	borrow.php and listings.php so they can be checked out all at once.  The first 
	process was to convert the functionality to use a form for navigation which has
	been completed to a satisfactory level.

* functions/function.php
	The is_opendb_valid_session(...) had references to logfile still.  These have been
	replaced with opendb_log(...)

* import/csv.php
	A slight bug in 'Process CSV File (Part 1)' section where the 'Extras' field was
	displaying a defaults LOV based on the most recent $default_field value.  Now
	set $default_field = NULL, where no defaults are required.

* functions/http.php::get_url_fields(...)
	Modified function to include fields even if empty values.

0.50-dev22
----------
* site/amazon/*
	Started adding site extraction capability.  As yet no support for Plots or CD,BOOK
	formats.  This will be added before 0.50(final)

* lang/english.inc.php
	Added:
		$lang_var['site']['amazonfr']
		$lang_var['site']['amazon']

* item_borrow.php
	Fixed a problem when $use_php_mail is FALSE, where the $default_borrow_duration is not used
	when checking out items.

* functions/function.php
	As part of general cleanup for 0.50 I have decided (after a comment from a contributor) that
	some of the function names could be renamed to better indicate they are OpenDb and not php
	supplied ones.

	Renamed:
		logfile(...) => opendb_log(...)
			Scripts updated:
				patch/dvddbp/index.php
				functions/item.php
				functions/http.php
				functions/item_attribute.php
				functions/user.php
				functions/review.php
				functions/email.php
				functions/item_borrow.php
				item_input.php
				logfile.php
				login.php
				logout.php

		is_valid_session(...) => is_opendb_valid_session(...)
			Scripts updated:
				site/amazonfr/index.php
				site/imdb/index.php
				site/freedb/index.php
				backup.php
				borrow.php
				email.php
				import.php
				item_add.php
				item_borrow.php
				item_display.php
				item_input.php
				item_review.php
				listings.php
				logfile.php
				login.php
				menu.php
				site.php
				stats.php
				tbl_dump.php
				user_admin.php
				search.php

		runquery(...) => run_opendb_query(...)
			Scripts updated:
				patch/prefix/index.php
				patch/0.33-dev3/index.php
				patch/dvddbp/index.php
				patch/0.30/index.php
				functions/item.php
				functions/item_attribute.php
				functions/user.php
				functions/review.php
				functions/patchutils.php
				functions/borrowed_item.php
				functions/item_type.php
				tbl_dump.php

* functions/email.php
	Renamed:
		email(...) => opendb_email(...)
			Scripts updated:
				user_admin.php
				email.php
				login.php
				item_borrow.php
			

0.50-dev21
----------
* functions/function.php
	Updated is_valid_session(...) to do a bit more checking to ensure the user is
	valid.  This now requires a is_valid_user check as well.  This was due to the
	possibility of a user logging into a OpenDb site on the same host, and automatically
	being able to connect to other OpenDb sites on that same host, if the security_hash
	was the same.  The user is not checked until the security_hash's are compared,
	so this is still the first line of defence against this problem.  If we get the
	cookies working correctly so they are only available to a single install of
	OpenDb, we will remove this check; for now it stays.

* search.php
	Removed CHECKED indicator from 'Not Active' status option.

* functions/listings.php
	Updated print_footer(...) to underline the current page number in the page number
	section.  This was previously working, but I must have broken it in a subsequent
	release.  Now working properly once again.

* site.php
	Include include_once(...) statments for functions/function.php, functions/site.php and
	functions/http.php,

* functions/site.php
	Moved convert_html_numeric_codes(...) from site/imdb/functions.php to here.  Added
	an extra line found in site/amazonfr/functions.php so it can support both plugins.

* site/imdb/index.php, site/imdb/functions.php, site/freedb/functions.php, site/freedb/index.php
	Modified function names to include $site value.  Unique function names will avoid
	problems later on if we want to chain site plugins.

* item_add.php
	OpenDb-0.50-dev20 broke the Refresh feature.  I have since fixed it again.

* site/amazonfr/*
	New site plugin initially added by Laurent Chauvin <lchauvin@yahoo.com>
	A development version which I cleaned up a little bit.

0.50-dev20
----------
* functions/patchutils.php
	Removed get_url_query(...) function as this is a similar function to
	functions/http.php::get_url_string(...).

* patch.php
	Replaced call to get_url_query(...) with get_url_string(...)

* functions/theme.php
	Update get_menu_options(...) to include order_by and sortorder for List My Items
	option.

* functions/item.php
	Updated fetch_item_listing_rs(...) to expand order_by logic.

* login.php
	Fixed Bug #540114.  Now the 'An error occured...' message is only being displayed
	if a VALID user does not have an email address, or for some reason the update of
	the password did fail.  The 'Your new password has been sent...' message will be
	displayed in cases where a user is not even in the system to avoid some malicious
	person from working out which userid's actually exist in the system.

* functions/formatfield.php & search.php
	Updated logic to escape any '_' encountered in attribute_val, attribute_vals.  The
	'_' is escaped by specifying it twice.  An attempt to use \_ became far too complex,
	but may be attempted at a later date.

* include/begin.inc.php & functions/function.php
	Added stripslashes_array(...) function to recurse through an array an stripslashes off all
	values in the array.   Added a call to this function to stripslashes from $HTTP_VARS in
	include/begin.inc.php.
	
* chart.php, email.php, functions/item.php, functions/item_attribute.php,
  functions/user.php, functions/review.php, patch/dvddbp/index.php.
  patch/0.30/index.php
	Removed stripslashes calls because of changes to include/begin.inc.php.
	
* item_display.php, item_add.php & item_input.php
	Enforced explicit test:
		is_exists_item_instance($HTTP_VARS['parent_id'], $HTTP_VARS['parent_instance_no'])
	instead of just checking that the parent_id and parent_instance_no are defined.  Did
	the same in many instances for item_id/instance_no to ensure that the combination is
	a valid record.  This may slow things down a little, but it is only done as part of
	the display of a record which is not as intensive as displaying listings.php...

* item_input.php, import/csv.php, item_borrow.php, functions/listings.php, functions/http.php
	Added a new function get_url_fields(...) to build a list of hidden form fields from
	an arrays elements.  Removed code to do this in item_input.php and replaced with call
	to function.
	
* item_display.php, item_input.php, include/invalidsession.php, login.php, user_admin.php,
  patch/install/index.php, patch/extras/index.php, patch/country/index.php, patch/lang/index.php,
  patch/prefix/index.php, patch/0.30/index.php, patch/0.33-dev3/index.php, patch/0.34p2/index.php,
  patch/0.35p2/index.php, patch/0.36/index.php, patch/0.37/index.php, patch/0.38/index.php,
  patch/dvddbp/index.php, patch.php
	Converted to use $HTTP_VARS references
	
* functions/patchutils.php
	The function check_table(...) was checking for records when all that is necessary is the
	existence of the table.  This is especially important for the upgrade from DVDDBP.	
	
0.50-dev19
----------
* login.php
	Moved logfile call before update_lastvisit, as it looked really weird for the
	users lastvisit time to be updated before the user actually logged in.

* item_display.php & item_input.php
	Added some <a name="..."> links to be used from listings page.

* item_add.php, item_input.php, item_display.php & functions/formatfield.php
	Added format_footer_links(...) function to formatfield.php and added call
	to this function to the bottom of the other scripts.  This enforces a formal
	look and feel for the links.

* listings.php
	A rethink of the Linked item support for listings script.  When a linked item
	is displayed it should in most cases provide links to its parent item.  For
	borrow/reserve/display this is what happens.  For checking whether the item
	has been reviewed the linked item id is used.  The same goes for the Delete/Edit
	operations.  Also added a linked icon to entries and footer.

* listings.php, search.php & borrow.php
	Reformat of footer and printable version link.

* lang/english.inc.php
	Added:
		$lang_var['listings_help'] entry.

	Modified:
		$lang_var['error_sending_email']
		$lang_var['id_like_to_join']

0.50-dev18
----------
* search.php
	Changed Rating block to be just like that in item_review.php itself.
	Included a Status restriction block.  
		Includes 'Active', 'Not Active' and 'Linked'

* functions/item.php
	Modified from_and_where_clause(...) to use item.id instead of item_instance.item_id
	where possible for join conditions.

	Also modified to optionally support searching linked items as long as count_distinct_support
	allowed and item_status[] of 'L' is specified.

	Modified to support restricting by item_instance status.  This actually looks at the
	item_instance.active_ind where the item_status = 'Y' or 'N'.  If item_status = 'L' then
	only items which have parent_id IS NOT NULL will be displayed.

* functions/listings.php
	Updated print_footer(...) to ensure that the page number navigation does not list
	pages beyond $total_pages.

	==> Perhaps we can put this into listings.php itself and ignore any rows which do
	not have the particular item_status specified.  If no item_status[] array found,
	the query will assumes ALL 'Active','Not Active' items, but no 'Linked'.

* lang/english.inc.php
	Added:
		$lang_var['linked_item']

* item_input.php
	Modified formatting to get 'Back to Listing' 'Back to Parent' on the same line if they
	both appear.

	When a new linked item is added, a 'Add Linked' link will be included so it is easier
	to add multiple linked items in a row.

0.50-dev17
----------

* functions/formatfield.php
	Updated get_display_field(...) to nl2br($value) where
	$widget['type'] == 'display' or '' and argument is %value%
	
	Also did the same thing for when get_display_field(...)
	returns default $value.

	Added is_lookup_value_found(...) function and modified
	all functions which allow more than one s_attribute_type_lookup
	value match.

* patch/install/opendb.sql
	Backed out update to script made in 0.50-dev16, as new
	defaults for $value display made this change unecessary.
		
0.50-dev16
----------

* item_display.php
	Fixed display of reviews to include any newlines.
	
* listings.php
	Fixed problem with printable listing being considered
	last listing for 'Back to Listing' links.	

* patch/install/opendb.sql
	Updated display_type for MOVIE_PLOT s_attribute_type to be 'nl2br'
	to ensure newline formatting is maintained.

* site/imdb/functions.php & site/imdb/config.php
	Updated config.php to include "USA" Certification,
	so at the very least this certification value will be
	returned.
	
	Also updated parse_imdb_data($id) function to get rid of
	any 'country:' prefix from the RUNTIME value.
	
	Modified get_all_titles_list(...), parse_header_block(...)
	parse_list_block(...) to correctly parse the block.  Previously
	multi-character matches were attempted with the [^...] regular
	expression construct; unfortunately this does not work.
	
	Also modified parse_list_block to include the ...aka entries.
	This involved updating get_common_titles_list(...) and 
	get_all_titles_list(...) to use this extra information.

0.50-dev15
----------
* lang/english.inc.php & logfile.php
	Added:
		$lang_var['apply_to_usagelog']
		
* functions/listings.php
	I modified the page number listing, to only display 10 at a time.  Much like AltaVista
	type logic.

* item_borrow.php & listings.php
	After a bug report regarding the print listing functionality I discovered that the 
	$HTTP_VARS['index'] is still being set when mode = "listing".  So in this case I set
	it to null and all works as expected.

* item_borrow.php & item_input.php & listings.php
	The [Back to Listings] functionality has been fixed in item_borrow.php and added to
	item_input.php. I removed the session_unregister for the listings_url_vars, as it
	did not serve any purpose.

0.50-dev14
----------
* functions/listings.php
	Added page number navigation.  This automatically made it appear in listings.php
	and borrow.php

* item_add.php, site/imdb/config.php & site/freedb/config.php
	Added ability to specify a refresh_mask for the search field in item_add.php.
	This is especially useful for CD's where the "Artist / Title" combination is
	more likely to find the item.  The same is true for DVD "Title (Year)" is
	a useful search format.

0.50-dev13
----------

* Many scripts - replaced $http_vars with $HTTP_VARS to better highlight the use
of the array in scripts.

* site/imdb/functions.php
	Rewrite of much of the parsing logic to get rid of all extraneous text that
	was included directly from IMDB.  Now all we get is the titles themselves as
	well as the plots, etc.  The heading text is now generated from OpenDb via
	$lang_vars.

* lang/english.inc.php
	Added:
		$lang_var['most_popular_titles']
		$lang_var['cnt_titles_found']
		$lang_var['show_all_cnt_titles']
		$lang_var['the_following_titles_matched']

0.50-dev12
----------
* functions/borrowed_item.php
	The LIMIT clause was not being set properly for borrow listings.  This
	has now been fixed.

* listings.php & include/config.php
  	Provide a LOV so you can restrict to a certain type when listing.
	
	Added include/config.php variable to control whether s_item_type LOV
	is displayed.  
	
	Variable: $listings['show_type_lov'] = TRUE;

* functions/item_type.php and item_display.php
	Added is_item_site_type($s_item_type) to ensure that at least one 
	site plugin is defined for the s_item_type before displaying a
	'Refresh' link in item_display.php

* Continued conversion to $http_vars as part of finalisations for
version 1.0.  Many of the old patch/ (including dvddbp) will not
be converted, as they need to be phased out anyway.  Check out
docs/http_vars.txt for information on progress.

0.50-dev11
----------

* functions/theme.php & user_admin.php
	Added a is_legal_user_theme(...) function to remove 'printable'
	theme from that list.
	
	Also renamed get_theme_r() to get_user_theme_r() to better 
	indicate its purpose.

0.50-dev10
----------

* functions/formatfield.php
	Updated get_input_field(...) to escape htmlspecial characters for display in
	input form.

* functions/item.php & functions/item_attribute.php & functions/review.php
	Added strip_tags(...) call for title, category item attributes and
 	review comments.

* lang/english.inc.php
	Modified:
		$lang_var['add_title_artist']

0.50-dev9
---------
* functions/function.php
	Removed my_strpos(...) from functions/formatfield.php to here.  Renamed as
	laststrpos(...)

* functions/formatfield.php
	Updated call to my_strpos to call laststrpos(...)
	
* item_add.php, site/imdb/functions.php & site/imdb/index.php & site/freedb/functions.php & site/freedb/index.php
	& functions/site.php & item_input.php

	To support refreshing items.  This is the initial support first provided by Brian, but partially rewritten
	to fit nicely into structure.

* lang/english.inc.php
	Added:
		$lang_var['refresh']
		$lang_var['refresh_title']

0.50-dev8
---------
* patch/* & patch.php
	Disabled prefixing for all patches prior to 0.50.  (All of them!)
	Included notice to this affect in patch.php

* functions/patchutils.php
	Added prefixing for print sql scripts.

* functions/function.php
	Updated the sql parse routine to support CREATE TABLE and DROP TABLE [IF EXISTS] commands.

0.50-dev7
---------
* include/config.php & search.php
	Renamed variable $search['datatime_filter'] to $search['datetime_filter']

* functions/user.php & email.php
	Added is_email_valid(...) function.  If include/config.php $opendb_email['users_only'] = TRUE
	then only email addresses that exist are found in the user table will be considered valid.

* listings.php
	A small fix for IE with the alignment of the checkboxes.

* item_borrow.php
	Modified check-out to support specifying a Borrow Duration for multiple
	items as long as they all use the same DURATION type.
	
* functions/function.php, patch.php & functions/patchutils.php
	Added functionality to support table prefixes.  Added new include/config.php
	variable $db_server['table_prefix']

* functions/formatfield.php
	Modified explode_lines($value) to support empty lines used for separating text
	into paragraphs.

0.50-dev6
---------
* include/config.php
	Added listings['show_multi_reserve'] to configure to display of the checkboxes and Reserve Item(s) button. 
	This way the old borrow links can be displayed instead of or as well as the new functionality. The 
	original functionality for borrow links has been reenabled in listings.php so you have much more control
 	over everything.
	
* lang/english.inc.php	

	Added:
		$lang_var['cancel_reservation(s)']
		$lang_var['check_out_item(s)'] = 'Check Out Item(s)';
		$lang_var['check_in_item(s)'] = 'Check In Item(s)';
		$lang_var['send_reminder(s)'] = 'Send Reminder(s)';

	Removed:
		$lang_var['send_reminder_email']

0.50-dev5
---------
* listings.php
	Removed [Cancel / Reserve / Borrow ] links from the title column in favour of allowing
	multiple borrow functionality.  In order to support this, the ability to 'Cancel' has
	been removed from listings.php.  You can do this in borrow.php via 'Items Reserved'
	anyway, so there did not seem to be a lot lost by having this functionality changed.

	The changes to listings.php are a bit of a hack, and I will probably clean it up a
	bit more in the future.

* lang/english.inc.php
	Added:
		$lang_var['reserve_item(s)']

* functions/formatfield.php
	Added logic to upload(...) and upload_or_saveurl(...) to set a global variable 
	$file_upload_type_included=TRUE.  This can then be checked in item_input.php to
	decide whether to include a multipart enctype for the form.

* item_input.php
	Modified to check for status of file_upload_type_included before outputting form.

* item_borrow.php
	Cancel operation from listings.php was not working.  Fixed now.  Also did a lot of minor
	logic changes to the if-elseif-else structure to test for the right things, and ensure
	that the right data is being passed, otherwise 'Operation Not Available' should be displayed.

	Also fixed updated cancel-reserve/reserve to support multiple item_id/instance_no combinations
	via an array of {item_id}_{instance_no} variables.  These will be broken up much like arrays
	of sequence_no are for borrow.php.  Nothing done to listings.php yet.

0.50-dev4
---------
* listings.php, borrow.php and functions/listings.php
	Moved the title formatting logic into functions/listings.php::parse_type_title_mask(...) so it
	can be called from both listings.php and borrow.php.  Made changes to support a 'DEFAULT' array
	option to configure all other types where not explicitly defined.

* functions/formatfield.php
	Fixed radio_grid(...) function.  Added cellpadding=1 to radio_grid(...), checkbox_grid, to space
	things out a little nicer.  Updated radio_group, checkbox_group and review_options functions to
	use a table for layout, instead of &nbsp; and <br>.

* patch/extras/game.sql
	A few problems with this script, now it should be working fine.  This script will delete the
	records that I have changed and reinsert them, so you can rerun this script if you have already
	installed from a previous version.

0.50-dev3
---------
* functions/item.php & item_input.php
	Updated update_item_instance(...) to check whether $borrow_duration should be updated or not.
	The $op == "updateinstance" was updated to specify FALSE for borrow_duration.

* user_admin.php
	Modified user listing section to use get_localised_timestamp function with new include/config.php
	variable $user_admin['datetime_mask'].

	Also modified update/delete sections for changes like to $lang_vars.  Previously it was possible
	to reduce a user from Normal to Borrower/Guest.  This had the potential to cause huge integrity
	issues, as the now guest/borrower might still have items in the database.  Now a user cannot be
	reduced below Normal if they have any items active.

* lang/english.inc.php
	Added:
		$lang_var['usertype_updated']
		$lang_var['usertype_not_updated_for_user_with_items']
		$lang_var['usertype_not_updated_for_user_with_borrow_or_reserve_items']

	Modified:
		$lang_var['user_deleted']
		$lang_var['user_not_deleted']
		$lang_var['user_updated']
		$lang_var['user_not_updated']

* functions/user.php
	Updated fetch_user_rs function to support list owners or borrowers.  Also modified lastvisit
	to return a UNIX_TIMESTAMP instead of a msql date format.

* functions/user.php & borrow.php
	New 'Borrower History' link had an error where it would only display Normal and Admin users.
	It has been updated to display 'Borrower' users as well.

* stats.php
	Modified to include totals.  This update was originally contributed by David Pyke 
	<eselle@users.sourceforge.net>.  I just cleaned it up a little to make it fit within the
	existing display.

* functions/http.php
	Modified check(...) function to actually use Snoopy->fetch(...) method, as the check(...)
	method using the HEAD http request is not supported by freedb.

* functions/formatfield.php
	Fixed problem where s_attribute_type.display_type field '%display%' where being
	incorrectly treated as %value%

0.50-dev2
---------

* listings.php & borrow.php updated
  print_listing.php & print_borrow.php deleted
	Updated listings.php & borrow.php to check for mode="printable" which makes for easier 
	maintenance in the future.  Added a dedicated theme 'printable' for these two scripts when
	mode=printable.

	Added support for custom title display, just like what was added for listings.php/print_listings.php
	in 0.50-dev.

* listings.php, item_borrow.php functions/http.php
	Added support for returning to the last listings page, from which a Borrow/Cancel request
	was initiated.

* lang/english.inc.php
	Added:
		$lang_var['back_to_listing']

* borrow.php
	Updated to use $HTTP_SESSION_VAR['user_type'] in call to is_user_admin.
	This was causing problems if user type was changed to 'Normal' during current session.  (Not sure
	why you would want to do this, but it looks strange).  All other is_user_????? tests pass in the
	$HTTP_SESSION_VAR['user_type'].

* user_admin.php
	Fixed a small bug, where if the user-type of the current user was changed, it could not be
	reset to the old type during the current session.

0.50-dev
--------
Owing to the overall stability and maturity of the product, the version of OpenDb has been
skipped ahead considerably to better represent the current stage of development.

* listings.php, print_listings.php and new functions/listings.php
	Added functionality to format the display of the 'Title' column in listings.  You can now
	include masked text or item_attribute values.  You specify {s_attribute_type} which will
	be expanded to the actual item_attribute value for the particular item.  No support
	provided for specify a %display% value from s_attribute_type_lookup.  Only the actual
	item_attribute.attribute_val will be displayed.

0.39p2
------
* functions/formatfield.php
	Added logic to upload(...) and upload_or_saveurl(...) to set a global variable 
	$file_upload_type_included=TRUE.  This can then be checked in item_input.php to
	decide whether to include a multipart enctype for the form.

* item_input.php
	Modified to check for status of file_upload_type_included before outputting form.

0.39p1
------
* functions/item.php & item_input.php
	Updated update_item_instance(...) to check whether $borrow_duration should be updated or not.
	The $op == "updateinstance" was updated to specify FALSE for borrow_duration.

* functions/user.php & borrow.php
	New 'Borrower History' link had an error where it would only display Normal and Admin users.
	It has been updated to display 'Borrower' users as well.

* functions/http.php
	Modified check(...) function to actually use Snoopy->fetch(...) method, as the check(...)
	method using the HEAD http request is not supported by freedb.

0.39(final)
-----------
* Moved language packs into their own package.

0.39rc8
-------
* lang/$language.inc.php
	Renamed:
		$lang_var['comfirm_delete_title'] to $lang_var['confirm_delete_title']
		$lang_var['cvs_file'] to $lang_var['csv_file']

	Removed duplicates:
		$lang_var['import_items']
		$lang_var['import_my_items']

* item_input.php
	Fixed a small problem where the Duration was being displayed for linked items, which makes no
	sense.

0.39rc7
-------
A small fix to item_borrow.php where pass-by-reference set off.  Also the lang/french.inc.php
language file has been added to the release.  This version is missing variables from 0.39rc6
and does not have the patch/lang/french.sql, but is a _very_ welcome contribution to the
release nonetheless.  Thanks to Marc Powell for this contribution.

This release is now waiting final language pack updates from Marc and Eduardo before we
can get to 0.39 final.

0.39rc6
-------
* lang/english.inc.php
	Added:
		$lang_var['check_in_reminder']
		$lang_var['check_in_reminder_for_items']
		$lang_var['check_in_reminder_not_for_items']

* borrow.php & item_borrow.php
	Support for sending reminder emails.

0.39rc5
-------
* print_borrow.php
	New script.  Link added to borrow.php.  Will display printable version of 
	borrower listing.  Same idea as for print_listing.php.
	
* borrow.php & functions/borrowed_item.php
	Added order_by/sortorder to Type,Title,Owner/Borrower headings
	Added ability to view history of other users if an administrator.

* functions/theme.php
	Added new 'Borrower History' menu option

* lang/english.inc.php, spanish.inc.php & german.inc.php
	Added:
		$lang_var['days_abbrev']
		$lang_var['months_abbrev']
		$lang_var['days_full']
		$lang_var['months_full']
		In anticipation of full local language support for dates.

	Copied $lang_var['borrower_history'] to new $lang_var['my_history']
	
* lang/english.inc.php
	Added:	
		$lang_var['borrower_history_for_fullname']
	
	Updated:
		$lang_var['borrower_history'] = 'Borrower History';
		
	Removed duplicates:
		$lang_var['item_check_in']
		$lang_var['item_check_out']

* functions/datetime.php, functions/review.php, functions/borrow.php, borrow.php, 
item_borrow.php, item_display.php
	All SQL now returns UNIX_TIMESTAMP where before it returned a formatted datetime,
	based on masks.  Now all the work is done in functions/datetime.php by the
	get_localised_timestamp(...), which is also passed a mask to format.  Now 
	month/day names are language specific.	
	
0.39rc4
-------
* functions/formatfield.php & functions/function.php
	Moved ifempty(...) funtion from formatfield.php to function.php script.

* print_listing.php
	Enforced the use of the 'default' theme for displaying images.  Added new include/config.php
	variable $print_listing['datetime_mask'] to format the datetime displayed under the title
	in print_listing.php.  This uses the same format as the $borrow['date_mask'] and 
	$item_display['review_datetime_mask'] masks.

0.39rc3
-------
* listings.php
	Where listing is for a single owner, the Owner column has been removed.  Added a 'Printable version'
	link for calling print_listing.php script.

*  print_listing.php script added.  A copy of listings.php with all the href links, images and 
	formatting stuff stripped out of it.  Will display listings of items based on parameters
	passed from the 'Printable version' link in listings.php.  In future the 'date' text printed
	below the title will be configurable for other languages, for now you will have to put up
	with it as is!

* lang/english.inc.php
	Added:
		$lang_var['printable_version'] 
		$lang_var['printable_version_notes']

0.39rc2
-------
* borrow.php
	Commented out the 'Send Reminder' as it might cause confusion.  Will reenable once the actual
	working logic is implemented.  A minor display bug was also fixed in this script.

* login.php
	Added logic to disable the 'Forgot your Password' link and associated logic for resetting
	forgotten passwords.  The new config.php variable $login['enable_new_pwd_gen'] was added
	to configure this.

0.39rc1
-------

* patch/install/opendb.sql & all patch.sql scripts
	Modified s_attribute_type_lookup 'value' column length from varchar(255) to varchar(100) 
	characters length.  This was done for several reasons.  It was first identified as a problem
	with older versions of MySQL and max index lengths.  It was change because in the end it
	was a design flaw to have such a large indexed column!

* borrow.php
	Split into item_borrow.php for actual operations of reserve,cancel,check-out,check-in and
	new borrow.php which display borrow listings.  Added display of total_duration for 
	history items.  Also added display of Cancel reservations for history page.

* search.php
	Added a filter for the arbitrary update_on date field.  At some time in the future
	this will be further restricted to legal dates only.   The filter characters are configured
	in the new config variable $search['datatime_filter'].  This variable may be removed or augmented
	in future when the full date filtering is implemented.

* functions/item.php
	Modified the way attributes are queried for when selected from the lookup LOV on search.php.
	Previously an IN('') match was performed which would not match composite attributes, when
	many are.  So it was changed to a 'word' match instead.
	
* stats.php and chart.php
	Added support for more than just PNG charts in statistics page.  The
	config variable $stats['image_type'] was added.  Options are 'png', 'jpeg' or 'gif'.  GIF may not
	be supported by all sites.  In fact I think GIF was removed from GD at some point, because of
	copyright problems.

* item_input.php
	Added the ability to edit the item title.  An new variable $item_input['edit_item_title']
	controls whether this is available or not.

* theme/$theme/style.css
	Added .small class

* lang/english.inc.php. 
	Added:
		$lang_var['list_items_with_same_prompt']
		$lang_var['total_duration']
		$lang_var['item_insert_aborted']
		$lang_var['linked_item_insert_aborted']
		$lang_var['confirm_item_same_type_insert']

		//borrow.php additions!
		$lang_var['to_user_email_intro']
		$lang_var['item_title_listing']
		$lang_var['borrow_error_detail']
		$lang_var['borrowed_item_not_found']
		$lang_var['notication_email_sent']
		$lang_var['notication_email_not_sent']
		$lang_var['item_reservation']
		$lang_var['item_cancel_reservation']
		$lang_var['items_have_been_registered']
		$lang_var['items_have_not_been_registered']
		$lang_var['reserve_items_have_been_cancelled']
		$lang_var['reserve_items_have_not_been_cancelled']
		$lang_var['items_have_been_checked_in']
		$lang_var['items_have_not_been_checked_in']
		$lang_var['items_have_been_checked_out']
		$lang_var['items_have_not_been_checked_out']
		$lang_var['check_in_detail']
		$lang_var['due_date']
		$lang_var['borrow_duration']
		$lang_var['no_items_checked']
		$lang_var['already_cancelled']
		$lang_var['already_checked_in']
		$lang_var['send_reminder_email']

	Modified:
		$lang_var['current_user']
		$lang_var['item_same_type_exists']
		$lang_var['reservation_cancelled']

	Removed:
		$lang_var['reservation_for_title']
		$lang_var['cancel_reservation_for_title']
		$lang_var['check_out_for_title']
		$lang_var['check_in_for_title']
		$lang_var['check_out_details']
		$lang_var['name_has_reserved_item']
		$lang_var['name_cancelled_your_reserve_for_item']
		$lang_var['name_cancelled_reserve_for_item']
		$lang_var['item_checked_out']
		$lang_var['name_has_checked_out_item']
		$lang_var['item_checked_in']
		$lang_var['name_has_checked_in_item']
		$lang_var['borrower_has_been_notified']
		$lang_var['borrower_has_not_been_notified']
		$lang_var['owner_has_been_notified']
		$lang_var['owner_has_not_been_notified']
		$lang_var['reservation_registered']

	Also modified item_display.php and listings.php to allow the use of {fullname} variable
	in $lang_var['current_user'] variable.

0.38rc2
-------
* Fixed a bug in email.php, thanks to a user report.
* Added title="..." for many images where alt="" is also defined.  This is to support
Mozilla tooltips.  http://bugzilla.mozilla.org/show_bug.cgi?id=25537

0.38rc1
-------
* Modified tbl_dump.php to include output into theme structure properly.  Also fixed up
the CSV output to actually produce correct CSV files.  Any columns which have the
separator in them, are enclosed in double quotes.  Any occurences of double quotes
are escaped, by doubling them.  This makes it compatible with Excel 2000.  I am not
sure how newlines/tabs/nulls are meant to be handled though.

* Renamed functions/function.php validsession(...) function to is_valid_session(...) and
changed argument list to pass in all $HTTP_SESSION_VARS.  This way the function can be
changed easily if we introduce any other session checks.

* Added include/config.php variable $item_display['review_datetime_mask'] to allow
sites to configure the display of dates in the reviews in item_display.php page.

* Modified several include/config.php variables.
	$borrow['borrow_duration_support'] changed to $borrow['duration_support']
	$borrow['borrow_date_mask'] changed to $borrow['date_mask']
	$search['datetimemask'] changed to $search['datetime_mask']

* A fix to 'delete' operation for linked items, previously was displaying
parent item title.

* Added include/begin.inc.php and include/end.inc.php.  All runnable scripts now
have require_once("./include/begin.inc.php"); at the beginning and 
require_once("./include/end.inc.php"); at the end of the script.  The begin.inc.php
script will check which $HTTP_?_VARS array is set, and assign it to $http_vars, which can then
be referenced in the script.  The begin.inc.php also has a call set_magic_quotes_runtime(false)
if get_magic_quotes_runtime() returns TRUE.  The end.inc.php script will perform a test to reset
this configuration variable to its default if it was changed.

* Updated functions/http.php, functions/formatfield.php, item_input.php, item_display.php to
support local cover images.  Added two new variables to include/config.php as well:

	// Must be relative to install directory.
	$item_input['item_attr_save_dir'] = "upload/";
	// Defines the save file mask for attributes which are "upload" or "saveurl" widgets!
	$item_input['item_attr_file_mask'] = "{fieldname}_item{item_id}.{ext}";
	
At this point, there is no way to delete images once they have been assigned.  If you 
choose to save an image locally, there will no longer be any record of the original URL
populated by IMDB or some other site plugin!

You need to update the input_type of IMAGEURL to enable this functionality.  A patch will
be provided to do this.

	NOTE: Images saved locally will not be automatically deleted,when parent item is deleted,
		this is future functionality.

* Updated item_display.php to move the 'New Copy', 'Edit' and 'Delete' operations into the
Instance Info block.  Also you can now click on the Cover image to popup up a new window
with the image with its normal proportions.  If I can work out how to get the size of the
image without too much trouble, I will change the popup window to actually specify the
exact size, so it looks a little neater!

* Exported "user.type" to SESSION variable, so that we can avoid all these is_user_??????($uid)
calls to database. Have modified fetch_user_r(...) to set type to 'N' if empty, so there is
no confusion.

* Added a S_ITEM_ID s_attribute_type and links into s_item_attribute_type with s_field_type
set to 'ITEM_ID'.  Updated item_display.php to allow display of the item.id when a 
attribute with s_field_type of 'ITEM_ID' is encountered.

* Updated functions/item.php.  Removed fetch_item_site_type_rs(...).  Updated item_display.php
to use functions/item_type.php fetch_site_type_rs(...) function instead.  This function will
get all site_types value for a particular s_item_type, rather than an instance of item.  The 
plugins themselves are responsible for deciding whether they should display themselves or
not.  If no s_item_attribute_type relationships exist, then the s_item_type.default_site_type
value will be used instead (as before).  The way site plugins are linked into item_types may
seem a little strange, but it works nicely in most cases.  The cases where it does not work
so nicely is for plugins which do not want to be involved in populating items, but which
can display links based on other values, such as title, year, etc.

* Updated functions/formatfield.php.  When using get_display_field(...) function and 
the format mask equals %value%, no query on the s_attribute_type_lookup table is performed,
as it is not necessary.  A patch is provided for all s_attribute_types where the %value%
should be specified.  Example: MOVIE_PLOT!  Changed function get_display_type_value(...) to
get_display_field(...) to be in line with get_input_field(...)

* Updated functions/site.php to include a is_legal_site($site) function.  This will return true
if the site directory has an index.php file.  The get_site_type_r(...) function is only used in
item_add.php anyway.  For site plugins that will only be used for displaying links, only the
config.php file need exist.  Also updated site plugin structure.  The $site_item_link_block
variable has been replaced in favour of a $site_item_link_rs, which corresponds to an array of
arrays that are available for the particular site plugin.  The format of the
each array in site_item_link_rs is array(link=>"Link text",url=>"url_of_link")

A link block will be formatted by the functions/site.php get_site_item_link(...)
function based on this information.

	Added Trailers link to IMDB
	Added Amazon.com site plugin.  But no support for populating records from Amazon, only
	linking to it.

* Added include/config.php variable $db_server['debug-sql'] = [TRUE|FALSE].  If variable is set
and equal to TRUE, all SQL statements will be sent sent with the page output.  The $listings['debug']
variable has been removed as a result!  The interesting thing about this debug functionality, is
that it will allow us to tune OpenDb for better performance.

* Replaced all input fields that use prompt/data cell type structure with functions/formatfield.php
format_field or a combination of format_data,format_prompt.  search.php,user_admin.php,backup.php,
formatfield.php all updated.

* Removed all references to global Session variables.  Now all referenced via the $HTTP_SESSION_VARS
array.  This required updates to all scripts.  This change will need to be tested thoroughly before
release.

* search.php, listings.php, functions/item.php.
	Added support for specifying the type of match you want to perform for 'Title' and 'Attribute'
	searches.  When no type is selected, the 'Category' LOV contains a unique set of Categories from
	all types.

	A small fix in the attributes section, so that no hidden/category/item_id attributes are 
	selectable.  These attributes were previously only excluded from the unique attribute list.
	
* functions/item.php
	from_and_where_clause(...)
		Even though MySQL defaults to case-insensitive comparisons, this has been enforced with the
		use of UPPER for all comparisons where the data being provided is not sourced directly from
		database lookups,etc.  This is with the view to supporting multiple databases in the future.

	fetch_item_listing_cnt(...)
		A fix for count when multiple instances of same item occur.  Added ii.instance_no: 
		count(DISTINCT ii.item_id,ii.instance_no)!
 
* Spanish language pack added.  Thanks to Eduardo Diaz.
* German language pack added.  Thanks to Friedrich Joos.

* patch/lang/english.sql
	Added S_ITEM_ID s_attribute_type definition
	Added AMAZONASIN s_attribute_type definition

* patch/language directory renamed patch/lang to match root lang/ directory and better indicate
  that these two are related and form the language packs.
  	
* lang/english.inc.php. 
	Added:
		$lang_var['initcap'], $lang_var['alpha_listing'], $lang_var['user_theme'],
		$lang_var['process_csv_preview'], $lang_var['word_match'],
		$lang_var['partial_match'], $lang_var['exact_match'], $lang_var['trailer'],
		$lang_var['filename_is_not_valid'], $lang_var['url_is_not_valid'], $lang_var['view'],
		$lang_var['save'], $lang_var['clear'],$lang_var['saveurl_prompt'], $lang_var['upload_prompt'],
		$lang_var['file_upload_error'], $lang_var['url_save_error'], $lang_var['file_not_found'],
		$lang_var['confirm_user_delete']  
		
		new $lang_var['search_help'][], $lang_var['upload_csv_file_help'][] and $lang_var['prc_csv_p1_help'][] variables.
 	
	Modified:
		$lang_var['confirm_user_type_change']
		$lang_var['uid_no_valid_email']

* Themes support added for users.  Now users can choose their own theme!  Added an include/config.php 
variable so you can disable it if you want.  By default user themes support is enabled.  There is currently
no functionality to enable different groups of users, such as Normal, but not Borrower/Guest.  This may
be added in the future, but is not a priority at this stage...  Please note that when the theme is updated
in user_admin.php, you will have to refresh the page once, for it to be effective... However theme will
change immediately upon login/logout!

* Initial implementation of themes functionality.  Removed $login['reload_menu_frame'] variable
from include/config.php.  Removed menu.php, include/header.php and include/footer.php.  Added
include/theme.php which is used to ascertain the actual theme, and then include the
theme/$theme/index.php script.  This script contains functions such as: theme_index(), theme_menu(),
theme_header(), theme_footer(), theme_error(), theme_refresh_menu() and theme_image($image). 
These functions contain custom logic depending on the theme.  

Some changes to index.php to include theme_index(), where $opendb['enable']!==FALSE or theme_error(...)
when disabled!

	Added .prompt class to use for all input field prompts instead of 'head', which is reserved
	for headers.  The .prompt class will have the same color as .head has now, and head is being
	changed to prompt.

	All class="plain" references for table headers will now be changed back to class="head"

listings.php, item_display.php and stats.php, item_input.php, borrow.php, email.php, import/csv.php,
updated to add support for theme_image(...) calls.  All images within the main system can now be
overriden with theme specific images.

Almost all root level scripts were updated to add support for theme_header(),theme_footer(),theme_error(),
etc.  A lot of scripts were also updated to standardise the look and feel, so it would be much
easier to provide scripts.

The include("./include/header.php"); REPLACED WITH echo theme_header();
The include("./include/footer.php"); REPLACED WITH echo theme_footer();

* patch.php.  Removed the .upgrade_success, .upgrade_failure and .querytitle CSS classes from the 
theme/$theme/style.css style sheets, and put them into the patch.php header. They are not used anywhere
else, so this made sense!

* import/csv.php.	Added ability to INITCAP titles and attributes.  The initcap functionality will 
recognise and maintain case of roman numerals between I and XX.  It will also recognise brackets as
word separators.  Cleanup up display of input fields.  Also added option to Preview form where you
setup the mappings between CSV columns and item attributes.

0.37p3
------
* Updated the 0.36 patch for minor fix to ensure all s_item_attribute_type prompts for MOVIE_PLOT are
set to null.  Also updated 0.37p1 patch to do this as well.

* Fixed a bug in login.php where invalidsession would never allow you to log back in to the db,
unless you refreshed all pages first.

* Added include/config.php variable $login['reload_menu_frame'] to control whether the reload
of the parent frame actually occurs.  This variable may be removed in a future version when themes
are supported, but was added so users could implement their own look and feel for OpenDb that
may not include a menu!  In a future version this may be removed to a function in theme.php!

* Fixed a problem in import/cvs.php where any lines skipped because they had the wrong type were
not being displayed.

* patch/install/opendb.sql & patch/language/english.sql.  Two new AUDIO_LANG variables added for
"English(2.0)" and "English(Surround)".  These have not been added to any of the other patches!

0.37p2
------
* functions/item.php.  Where the borrow_duration is not a number, the insert/update explicitly
	set the column to NULL, because MySQL will insert 0 into the numeric column, when value is
	set to ''.  Functions in functions/item.php updated:
		insert_item_instance(...)
		update_item_instance(...)
		insert_newitem_instance(...)

* borrow.php.  Ability to make borrow duration undefined for items with a default defined borrow duration 
at checkout time.

* A new patch/0.37p1 for the 'Undefined' option added to S_DURATION lookup.

* patch/language/english.sql.  An extra SQL update for S_DURATION.

0.37p1
------
* Fixes for patch/extras/alternate_title.sql, patch/language/english.sql

* Fixed imdb site plugin problem with alternate titles.  Added this support to freedb.

* Updated functions/borrowed_item.php::fetch_overdue_duration(...) to return null even
if borrow_duration is numeric but not greater than zero!

0.37
----
* lang/english.inc.php.  
	Removed:
		$lang_var['return_to']
		$lang_var['login_page_will_be_loaded']

	Replaced:
		$lang_var['uid_has_checked_in_item']	with 	$lang_var['name_has_checked_in_item']
		$lang_var['login'] 						with 	$lang_var['site_login'] (This one includes a {site} variable!}
		$lang_var['item_listing_for']			with 	$lang_var['item_listing_for_name'] (Now includes {fullname} variable!)
		
	Added:
		$lang_var['borrow_help'][]
		$lang_var['due_date_or_duration']
		$lang_var['check_out_details']
		$lang_var['due_date_detail']
		$lang_var['borrower_history']
		$lang_var['overdue_duration']
		$lang_var['return_date']
		$lang_var['unknown']

	Modified:
		First $lang_var['upload_csv_file_help'][] entry.  This is because the CSV parser has been improved so that it supports
		the Excel standard way of dealing with ',' that occur in a column value, by surrouding the whole value with "...".  

* tbl_dump.php.  Backed out of change made in 0.36rc1.  When streaming back to browser, the Content-Type is now text/html
again.  The whole page is wrapped in a <pre>...</pre>, but no other formatting is sent...

* user_admin.php.  A minor fix to user admin, for the 'Forgot your password!' function.  For some reason the session
variable $user_id was being specified.

* Modified site/imdb plugin to prefix a 'http://' to IMAGEURL values.  The 0.36 and previous patches includes a SQL
statement to update all IMAGEURL with a http:// prefix, this is in anticipation of the feature that will be added to
0.38, where you will be able to specify a local image for your cover.

* import/csv.php	Finally worked out how to avoid having to escape any occurences of the delimiter in columns!  Excel
actually encloses such cells in double quotes.  So the logic will actually ignore any delimiters that occur in double
quotes.  Two double quotes occuring together in a CSV file, indicate that a quote is actually being escaped.

* login.php/logout.php.  Moved parent.frames[0].location.reload() statement into section 
where it is actually required: Only when logout or login actually happens!  This should
solve problems with users having to reload when coming back from the patch section, if
already logged in.  There are probably other situations that this fixes as well.

* include/invalidsession.php.  Now this script sets the $op == "invalidsession" and
loads login.php.  login.php has been modified to check for this $op and display the
invalidsession information inside the login page.

* Added 'order_no' column to s_item_type to allow ordering of s_item_types in
item_add.php and search.php.  Updated functions/item_type.php to add 
'order by order_no' as a result.

* Code Cleanup:
	Updated functions/item_attribute.php:
		=> fetch_item_attribute_type_rs(...) & fetch_item_attribute_type_with_val_rs(...)
			Moved $fullrecords parameter to last, and set to default of FALSE.
			Removed this parameter where set to FALSE in item_input.php,item_display.php
			and import/csv.php.
			
		=> fetch_attribute_type_lookup_rs(...)
			Set default value for $s_attribute_type = NULL, $order = "asc".  Removed 
			in code where set to NULL in stats.php, search.php, import/csv.php, 
			functions/formatfield.php

	Updated functions/item.php
		=> get_item_image(...)
			Made $item_id & $islinked parameters default.  Removed code where set to default
			in borrow.php, item_add.php, item_input.php, item_display.php, item_review.php,
			listings.php, import/csv.php
			
* search.php. Fixed bug where s_item_type has no attributes associated with it.
	Updated search.php to cleanup the php logic and rename some of the javascript objects
	to better represent what they are for.  Also removed the display of "hidden" attributes
	from list of values.  The attributes are only removed if 
		(strlen(display_type)==0 && input_type="hidden") OR display_type == "hidden"
	
* item_display.php.  Originally a check against the s_attribute_type.input_type column was done
to check for 'hidden' anywhere in the column.  This has been changed a bit.  Now it must match
exactly (not case sensitive) except for whitespace, and the display_type column must be empty,
except for whitespace.	Also you can now set the display_type to 'hidden' and this will 
accomplish the same thing.  This also offers some new functionality.  You can now display 
attributes that were populated by site plugins.  For example change the display_type of 
IMDB_ID to '%value%' and you will see the IMDB id displayed in the item record.

* item_input.php.  If input_type == "hidden", no <input type="hidden" ...> field will be 
included in $op == "edit" mode, as it is not necessary.  Also any fields of input_type =="hidden"
will be ignored in the update process.

* stats.php.  Updated to use functions/item.php::get_item_image(...) function instead of fetch_item_image
and some extra logic.

* patch/language/english.sql International language database patch was missing the updates for
the s_item_attribute_type table for s_item_type = 'CD' and s_attribute_type = 'CDTRACK'.  You will need
to update your patch/language/$language.sql scripts with these additions.

* Had to add a s_field_type column to the s_item_attribute_type table, rather than add another
???????_ind column for duration which is what I was considering.  The s_field_type column
replaces the category_ind and image_ind columns.  The scripts functions/item_attribute.php,
functions/item_type.php, import/csv.php, item_display.php, item_input.php and search.php all
had to updated.  The replacements looked like this:

	$s_attribute_type['image_ind'] == 'Y' REPLACED WITH $s_attribute_type['s_field_type'] == 'S_IMAGE'
	$s_attribute_type['category_ind'] == 'Y' REPLACED WITH $s_attribute_type['s_field_type'] == 'CATEGORY'
	
* functions/borrow.php.  Added include/config.php variable $borrow['borrow_date_mask'] for use in
new fetch_item_duedate(...) function.

0.36p1
------

* functions/email.php.	Added a new parameter to email function $append_site_to_subject (default:TRUE),
when set to FALSE, no [OpenDb] will be appended to subject line.  This was added for the benefit of
user_admin.php Welcome email, because it looked silly: "Welcome to OpenDb [OpenDb]"

* user_admin.php.  The welcome email would never be sent due to an error in if($email_user=="yes") check.  
Should be if($email_user=="Y").  Thanks to 'ediaz' for this.  

* International language support.  A few scripts had to be updated to fix errors with {varname} references.
The scripts were logout.php, menu.php and user_admin.php.  

	The $lang_var to be updated in lang/english.inc.php were:

	All of these had {title} replaced with {site}
		$lang_var['welcome_email']
		$lang_var['thanks_for_using']
		$lang_var['backup_db_blurb']

	Removed duplicates
		$lang_var['owner_has_been_notified']

	Added several new variables:
		$lang_var['borrower_has_not_been_notified']
		$lang_var['owner_has_not_been_notified']
		
0.36
----
* There were a few small changes to include/english.inc.php that could not be avoided.  Only one
really needs to be represented in any new language files:
	Added a $lang_var['upload_csv_file_help'] entry to the lang/english.inc.php for import/csv.php!
	Modified value of $lang_var['new_item_instance'] from 'New Instance' to 'New Copy'
	Modified value of $lang_var['comfirm_delete_title'], to add {instance} variable.  This will
	resolve to (#2), etc if the instance_no of the current item is above 1.  You do not have to
    use it though.

* Removed include/config.php $debug['item-listing'] variable in favour of a more specific
$listings['debug'] variable.  The downside of this is the whatsnew.php no longer displays
the queries generated by functions/item.php.  Queries will also not include the SELECT clause,
but it should be enough to diagnose problems with the search page,etc.

* Updated functions/item.php and stats.php.  Renamed function fetch_item_cnt, to fetch_item_instance_cnt,
as this better represents what we are after.  Also change the SQL slightly.  If no $s_item_type,
then no need to join to item table.  Did the same for fetch_owner_item_cnt(...), 
fetch_owner_active_item_cnt(...), fetch_owner_inactive_item_cnt(...).

* Tuned the stats.php page a bit.  Things like fetch_item_instance_cnt() do not not need to
be executed more than once.  They were being executed 4 distinct times, I change this.  I also
modified functions/review.php, functions/item.php, functions/user.php to use default parameters,
so that for instance fetch_item_instance_cnt() can be called without specifying the $s_item_type,
whereas before you had to manually specify NULL as the argument.

* Problems with duplicate items coming up in listings as a result of running search (For reviews
and attributes) caused me to rethink the use of count(DISTINCT ...) which was removed in an
earlier version to maintain compatibility with MySQL versions below 3.23.2 !!!.  I have since
added this functionality back into 0.36.  However to maintain compatibility, I have added a
new include/config.php variable, $listings['count_distinct_support'], which when set to FALSE,
will execute a separate query on item_attribute/review first to get the distinct list of
item_id's which will then be passed into the main query as a IN(...) clause.  Please do not
resort to using this unless ABSOLUTELY necessary.  The default for the parameter when not
set is TRUE, so existing users with MySQL below 3.23.2, will have to manually set it to FALSE!

* Added addslashes(stripslashes(....)) around $title and $attribute_val, etc in functions/item.php
for functions such is_title_exists, etc.

* Changed listings.php to display $lang_var['current_user'], when $item_r['owner_id'] matches current
user.  This is to be consistent with Instance Info section in item_display.php.  Also did a few
performance changes to listings.php.  The $total variable is passed in the 'Previous' / 'Next' urls,
as the query is exactly the same. This should improve performance when you are navigating through
a list of items, as the results query will be executed!

Also went through import/csv.php and tested a lot more.  Picked up a lot of minor issues and
managed to make the script more usable.  Added the ability to upload Data Interchange Format
(DIF) files, as exported from Excel.  Some characters such as `'` and `-` do not always appear to
be supported, they come out as `?`

0.36rc3
-------

* Modified CSV import script to display all s_attribute_type_lookup default fields
as SELECT fields.  This way the user can see exactly what the lookup value & display
fields are.  Where the value is different from display, the LOV displays %value% - %display%,
otherwise it just shows %value%.  A comment beside the field will indicate this as well.

* A few minor modifications to the lang/english.inc.php script.

* Updated some of the doco.

* An improvement to the SQL Preview mode.

* A few modifications to the sql scripts in the patches area.

* Added check in functions/item.php for whether the item type image actually exists before
trying to display it.  I have used a @file_exists(...) so we can ignore any exceptions.

* Added $item_display['item_image_size'] variable to config.php.  This variable is used to
set the size of all item images displayed in item_display.php.  You can set this variable
to an empty string to make item_display.php display images at their actual size.  If
this variable is not set, the default of "width=\"100\" height=\"140\"" will be used.

* Included an 'example of what not to do': A lang/jibberjabber.inc.php language script.  Change
the include/config.php $opendb['language'] = 'jibberjabber' and see what I mean.  Some of the
language variables have not been converted as the process was scripted and it missed the 
variables that use the array keyword!  A bit of fun!

0.36rc2
-------
* Updated many of the patches so that they are all uniform.  I did not however touch the 
0.30 or DVDDBp patches, as these are just too complex.  All the other patches and any added
in the future will be of a standard form.  All patches from now on will generally be one
or more SQL scripts, so it was easy to arrive at a standard format.  I added the ability to
preview the SQL scripts before being executed, by the 'Display SQL only' checkbox before 
clicking any of the button(s).

* Updated listings.php to remove repeated call to fetch_category_attribute_type. This should
improve performance greatly.


0.36rc1
-------

* Patch functionality updated:

	1) Included 'Customize for Country', which allows you to configure your ENGLISH language OpenDb
	for particular countries.  Configuration for Age Recommendation and DVD Region encoding, etc
	included.

	2) International language support infrastructure provided.  A single language.sql script will
	be provided for each language, to update the prompts,descriptions,display,etc for that language.
	No language packs, besides the template (which is incomplete) have been included as yet!

	4) Included 'Extras' option.  This has any extra scripts that you may want to apply for
	extra functionality.  I suggest previewing such scripts with 'Display SQL only' option first.

	5) sql/ directory removed.  All scripts have been moved to the relevant patch/ subdirectories.

* Finished Item Instance functionality.  See the docs/item_instance.txt file for more information.

* Modified item_display.php,item_review.php,item_input.php to lessen the restrictions on what you
can do with linked items.  You can now add reviews for linked items, where as before
you could not.  The Linked Items listing in item_display.php and item_input.php will now display
the type of the linked item as well.  You can now add linked items of different types to parent
items.  BUT CHILD ITEMS ARE STILL NOT VISIBLE IN THE ITEM LISTING AND THE SEARCH PAGE WILL NOT
DISPLAY THEM.  This is how it will remain for the present.  You can disable this ability by
setting the config variable $item_input['link_same_type_only'] = FALSE.  By default it is 
assumed to be true. As part of this I also modified item_review.php to include a 'Back to Item'
link once you have successfully inserted the review. This will take you back to item_display.php.
In item_input.php when you insert a new item the 'Back to Item' link has also been added.  In
this case it takes you back to item_input.php instead!

* Small change to the internationalisation support in search.php.  Also added support for searching
for items according to their Review Rating.  If you specify a particular rating level, only items
with a review rating equal or better will be shown.

* Site plugins underwent another minor redesign, to make it easier to provide international support.
All the common text that is part of each plugin has been moved as much as possible into the site.php
script.  This includes the check for if the site is available, etc.  Some of the information
originally contained in each site/$site/config.php has had to be moved into the lang/$language.inc.php
files.  The format of the entries is $lang_var['site'][$site]['description'],
$lang_var['site'][$site]['input_fields'],etc.

	Variables removed/altered in the site/$site/config.php include:
		$site_description removed
		$input_fields 'title' element removed.  This is now defined in the $lang_var['site'][$site]['input_fields']
			variable.  The functions/site.php adds the language title to the input_fields array before returning to
			item_add.php.

* Some nifty new icons for avail.gif, unavail.gif,inactive.gif and reserved.gif have been contributed by
Jon Petrovski.  The original ones have been moved to the images/old subdirectory.  You can move them 
back if you prefer the old ones.

* Added a Contributors file

* Updated whatsnew.php to include {count} of reviews,items,etc actually in the language variable, so
that the order of the text can be rearranged if required.

* Updated borrow.php,item_input.php,item_add.php to provide more flexible language variables.

* Updated CSV Import script.  if owner_id and user_id are the same, do not display the Owner Name.

* Changed tbl_dump.php to always return plain text if not sending to file.  No html formatting
whatsoever is returned and content-type is set to 'text/plain'

* Added @set_time_limit(600); statement to patch.php so as to avoid problems with longish operations
timing out.  It should never take this long, but we will leave as safetly margin.  This value was
sourced from tbl_dump.php.

* Fixed a bug in formatfield.php 'format_mins' display_type widget, where a whole hour value, such
as 60, 120 or 180 would only display 1, 2, 3, and not 1 hour, 2 hours, or 3 hours.

* Updated site/imdb/functions.php to support parsing the 'Runtime' value from imdb.org.

* Added $debug section to include/config.php file.  Currently only $debug['item-listing'] is provided.
When set to TRUE, the queries used in listings.php and whatsnew.php will be displayed so you can
work out if there is anything wrong with your sql statement.

* Added a new display widget type 'category' to do the same in item_display.php.  Updated listings.php
& item_input.php/item_display.php (For linked items categories).  System data updated as a result.

* An overhaul of the user_admin.php script as part of international conversion.  Added some extra
input_field types to functions/formatfield.php so they could be used to build the input fields
used in user_admin.php.  This means that all the formatting and validation for the fields are
done in the same way as for item_input.php.

* Added $item_input['confirm_item_delete']/$item_input['confirm_linked_item_delete'] variables to 
include/config.php, where you can turn off item deletion confirmation.  The defaults for these
variables (when not set) are in the config file. 

0.35p2
------
A few fixes to email.php, which was not fully converted to support international languages.

0.35p1
------
* Fixed some bugs with borrow.php where the wrong action was being displayed for 'Cancel'.  This
was due to a mistake in the internationalisation conversion procedure.
* A fix to search.php introduced in 0.35, where an extra search row was added which should
have been removed.
* A few more scripts were converted for international language support.  A few aesthetic changes
to make it easier to do this same conversion were also performed to various scripts.

0.35
----
* Aesthetic changes to login.php, listings.php, stats.php, email.php, user_admin.php.
* Updated search.php to expand <script> to <script language="javascript"> to
ensure browsers know exactly what to do.
* Removed xmserorr class from include/style.css as no longer required.
* Added Item Import functionality.  Initially the only import functionality
  provided is for CSV files.  This import plugin interface is not finalised
  as yet, because I am not sure what will be required in future plugins.  
  Once this has been worked out the existing csv import plugin will be
  modified to fit in with the finalised format.
* Disabled 'Sourceforge Project' link on menu.php to make room for extra Import Item
links. 
* A fix to user_admin.php to fix javascript validation when User type is
  changed from Normal to Borrower.
* A fix for listings.php to encode the $update_on date properly.
* Updated functions/item.php item listing select to support start_item_id.  Updated
  listings.php,whatsnew.php as a result.

* Remove session variables from site plugins.  The sites/$site/config.php
$site_attribute_types variable is no longer required and has been removed.
	Scripts modified were site/freedb/index.php, site/imdb/index.php, 
	site/imdb/functions.php, functions/site.php, item_input.php, item_add.php

* Moved get_new_search_link function from functions/site.php to site.php in root directory,
as this will allow it to be easily converted for use with international languages.

* Moved is_found function from functions/item.php to functions/function.php as it can be
used by all scripts.

* Changed formatfield s_attribute_type_lookup widgets to test the value against the resultset
in a case INSENSITIVE way.  This is different from previous versions of the product.

* Added Genre parsing for IMDB site plugin.  Works best if you have the input_type
for MOVIEGENRE set to "checkbox_grid(%display%, 4)".  (Run the 0.34p2 patch script!)

* Updated search page to allow custom date time.  Added $search['datetimemask'] variable to
include/config.php as a result.  The $datetimemask also has to be passed to the functions/item.php
script so it can be used in the SQL listing statement.

* Added functions/datetime.php for any date/time functions.

* Updated user_admin.php.  Added strip_tags for $uid,$fullname,$location so that users can
not 'get clever' by using html code to try to screw up the display of data.

* A few small changes to functions/formatfield.php to the logic that matches values against
s_attribute_type_lookup column values.

0.34p2
------
Another very minor fix to email.php, to fix a problem introduced in 0.34p2.
Also a small aesthetic fix to listings.php

0.34p1
------
Small fix to email.php

0.34
----

* Support for Composite categories was the primary objective of this release.

* functions/formatfield.php.  Removed order_no parameter from get_item_attr_col_value(...) function,
as not even used.  Also updated get_display_type_value(...) function to check if a lookup value
is the last item in the list as well.

* Updated patch/dvddbp/index.php to remove order_no parameter from get_item_attr_col_value(...) call.

* Updated item_input.php for the new get_item_attr_col_value call.  Also modified processing of 
category, so that it can be used with different input fields besides single_select.

* Updated sql/opendb.sql input_type/display type for MOVIEGENRE.  With the fixes in 0.33p1, The category
can now be displayed as a checkbox grid.

* Updated functions/item.php fetch_category_item_cnt(...) function to do a LIKE comparison of the
category.  So that "Action" and "Adventure matches "Action Adventure" as well.  The item_where_clause
function was also updated to match '%$category%' as well.  The stats page takes a little longer to run,
but it is more flexible now.

* A small aesthetic bug on item_add.php fixed.

0.33
----
* Finished item_display.php, item_input.php, item_add.php, item_review.php conversion to use $lang_var 
variables.

* Added a new patch for versions prior to 0.33-dev, but after 0.30rc5

* Updated functions/review.php, functions/item_type.php, functions/input_type.php to use preferred while(...) syntax.

* Updated functions/item_attribute fetch_attribute_type_lookup_rs function to add a $order parameter to control
the order of columns returned if necessary.  stats.php, search.php, functions/input_type.php all had to be updated
to include new parameter.  Most set it to NULL.

* Renamed functions/input_type.php to formatfield.php to better indicate its generic purpose.
  Replaced vertical_check_boxes/horizontal_check_boxes with a check_boxes function and an extra
  parameter for orientation.  Did the same for vertical_radio_group/horizontal_radio_group.  Now you
  can also specify radio_group(display_mask, HORIZONTAL), radio_group(display_mask, VERTICAL), etc
  in the s_attribute_type input_type column.  Default is HORIZONTAL.

* Updated item_review.php to use functions/formatfield.php for the Review and Ratings input fields.  The rating
options are now configured in the s_attribute_type/s_attribute_type_lookup tables.  The s_attribute type reserved
for this is "S_RATING".  s_attribute_types starting with "S_" are now reserved for internal use, although this
is not enforced.  

* Added new SniffBrowser.php to functions for use with patch.php.  Now all buttons are generated via print_button
function.  In the case of Netscape 4.x the DISABLED option is not available for submit type buttons, so in this
case the type of the button is changed to "button" and a DISABLED message appended to the value.  The 
SniffBrowser function was taken from a Engineering College of Copenhagen , Department of Electronics and 
Information Technology page.  No copyright information is available, so it may have to be replaced at a later
date.

* Updated search.php to fix a bug introduced in 0.33-dev3, whereby only half of the Owner Id were actually 
available in the SELECT list.

* Updated borrow.php to use get_input_field for the more information textarea.

* A few minor aesthetic changes to the IMDB site plugin.

* Added a new smerror & xsmerror classes to include/style.css for email.php

* Added support for bulk email to email.php.  Pass in an array of $ids[] and this will be split up into a
$cvsids which will be passed through to the actual action part of the script.  The script will then do a
separate email to each user in the list, fetch their email details from the database first.  The functions
/email.php will not allow you to submit a message with a invalid email, so the userid must be valid.  The
message is considered successful if at least one message succeeds.  Perhaps later we will augment the 
functions/email.php to accept multiple email addresses instead of calling it multiple times, but for
now it should suffice.

* Updated user_admin.php list_users function to allows the Administrator to send a bulk email to any
number of users.  You can select the whole list of users much like in Hotmail.  Uses javascript so will/may
not work on KDE Browser.

* A fix for borrow.php where email is not sent if you do not specify a detail message.

* Changed the [Add Linked], [Back to Parent] to use smlink class.  The [Add Linked] was only modified
where it appeared on its own.

* Updated user_admin.php to do extra checking when updating passwords.  If at least one of the passwords
is empty, a message will be displayed, otherwise the normal checks apply.

0.33-dev3
---------
Support for DIVX added thanks to Eduardo Diaz

site/imdb site plugin updated to support populating a specified title attribute as well as the main item
title.  Added $title_attribute to site/imdb/config.php.  Modified functions/site.php get_site_attribute_r
function to push the $title_attribute onto $site_attribute_types if set.

Updated item_display.php, item_input.php, search.php, borrow.php to change the way while loops process
result sets.  Now the actually mysql_fetch_array is in the while (...) condition, which makes it
easier to understand and maintain.

* item_input.php A fix for site operations, where the category was not being populated.

0.33-dev2
---------
* Fixed site/imdb/index.php (Bug #494013)

* functions/user.php.   Added fetch_user_theme, fetch_user_language.  Updated fetch_user_rs, fetch_user_r,
update_user, insert_user to support the new language/theme columns.

* user_admin.php as a result of changes to functions/user.php

* login.php/logout.php.  Added support for languages and themes.  Set session variables for both of these
so database access is not required to be made after login.  If the user updates their theme/language in the
session it will be up to the user_admin.php to reset the session variables.  At this point we are only
preparing the code for the final implementation of languages and themes, nothing is provided in the visual
layer for this release.

* Overhall of the patch functionality.  Now there is coordinated support for upgrading from whatever
previous version you are currently using.  Added include/config.php $patch['enable'] to enable/disable
patch scripts to provide much better security.

   Moved upgrade.php to patch/dvddbp/index.php.  A lot of changes made to fit in with new structure
   Moved patch.php to patch/0.30/index.php.  Quite a few changes to fit in with new structure.

* include/style.css Add .querytitle class for patch facility.

* Small update to item_display.php.  Reversed order of Edit Item/Delete Item.  Also closed table row for
these two buttons.

0.33-dev
--------

* Updated item_display.php to center the Edit and Delete buttons.

* Added a new configuration item $item_input['linked_item_support'] for use in item_input.php.
If this variable is explicitly set to false (its default is TRUE), then the Add Linked
operation in item_input will be disabled.  Existing linked items will still be visible, but
you will not be able to create new ones.  This is useful for sites which have no use for
linked items and perhaps find even the presence of the item linked block obtrusive.

* Updated functions/user.php to change 'iud' references to 'uid'.

* Had to modify functions/item_input.php.  Function wrap_field has been replaced by
format_field which has an extra variable $dowrap.  If $dowrap===FALSE then the table structure
will not be included in the field formatting.  Added the $dowrap variable to call to 
get_input_field, so we can disable wrap_field if necessary.  Modified get_attribute_field as
well to pass in $dowrap.  This has meant modifying item_input.php and upgrade.php to support
different call.

* Added fetch_borrowed_item_status_atdate_cnt($status, $update_on) to functions/borrowed_item.php
to be used in whatsnew.php.  Added fetch_review_atdate_cnt() function to functions/review.php
for the same reason.

* A fix to functions/item.php to actually support the update_on stuff, which had been added here
earlier, but had never been tried, and as such was broken, because of a couple of typos!  

* Added a .blocktitle class which is for the moment the same as H2.

* Changed the class of the borrow/cancel/reserve block in item_display to colortext,
as it looks much better.

* A very minor fix to borrow.php to remove an extra space in emails for cancel reservations.

* Fixed a problem with borrow.php for cancel-reserve where the messages were incorrect.

* Added is_item_borrowed_or_returned_by_user function to check if user has BORROWED or RETURNED
a particular item.  Added $listings['show_borrowed_or_returned'] to config for enable/disable
of Borrowed/Returned By User checks for item listing.  A silly looking image of an eye is displayed, to
indicate item has already been borrowed or returned by user.  This can probably be improved upon for
a future release, but for now it will do!

*  Added Borrow/Reserve/Cancel links for non-owner items to listings.php, much as Edit / Delete
links were added for owner items.  The config.php variable $listings['show_borrow_links']
can be used to enable/disable this functionality.

* Added functionality to provide a detail message when Reserving/Borrowing/Cancelling items via
borrow.php.  Each of Check-in,Check-out,Reserve,Cancel can all be configured for whether the
custom message form should be displayed or not.  Check out the $borrow variables in include/config.php.

* Modified all functions/???????.php that have include("include/config.php") to instead specify global
?????; for the variables they want to access from the config.php file.  This should help to reduce the
amount of work php does.   The scripts changed in functions/ are: borrowed_item.php, email.php, item.php,
http.php, function.php.

* Included a bit of legend on the listings page to indicate what the images mean.  

* A small modification to functions/function.php logfile to ensure that no entry in the log goes over
4000 characters.  This just my paranoid side showing now!

0.32
----
Updated patchutils.php to display mysql_error if SQL query fails.  Moved some of the common patch
related functions out of upgrade.php,patch.php and install.php to functions/patchutils.php where
they can be utilised by all future patches as well.  A few small changes to install.php,
patch.php,upgrade.php to fit in with move of functions to patchutils.php and also for cosmetic reasons.
A few small changes to index.php, include/header.php and menu.php to ensure that the <TITLE>...</TITLE>
is being set correctly.  A very minor change to sql/opendb.sql.  A small fix for backup.php as it
was not including the name of host and database as the references were still to the old config file
format.  Also modified backup.php to have all user tables SELECTED by default.  The user tables are
item, item_instance,item_attribute,user,review,borrowed_item.  Modified user_admin.php a little to
clean up the messages when user has items, items borrowed,items reserved, so they make a little
more sense.  Added a Connected to database@hostname in the admin section of menu.php so it is easy
to tell what your admin operations will affect.  Good for sites with more than one OpenDb site. Changed
logfile "Entry" header to "Details".  Modified email.php to use failure class for main failure message and
error class for error details.  Show probably change in other scripts (if applicable) as well!  Moved
psd image into lower templates directory under images.

0.31rc6
-------
A fix for functions/item_attribute.php fetch_attribute_type_rs function to use s_item_attribute_type
prompt first instead of defaulting to s_attribute_type.  A small fix to patch.php for displaying the
correct version.  Plus a very basic install.php script to make the task of installing OpenDb easier.
This script is for NEW users only.

0.31rc5
-------
A fix for the sql/patch_before.sql script.  The RUN_TIME input_type/display_type were configured 
incorrectly.

0.31rc4
-------
A very minor fix for errors with headers.  In actuality this was the removal of a single line from
the end of include/config.php, but enough to cause some people problems.

0.31rc3
----------
A fix to patch.php that actually updates all item_attributes, instead of just id=30.  Sorry about
this!

0.31rc2
----------
A cleanup of the start_session() stuff, including the removal of start_session() statement from
functions/function.php which was not needed.  Also modified the upgrade.php script to use the
new functions/patchutils.php script, which also provides a nice SQL script parser to remove
comments etc.  The patch.php script can now perform all the steps necessary to update to OpenDb 0.3.1.0
from OpenDb-0.30rc5 or earlier.

0.31rc1
----------

* Withdrawn final 0.30 release due to rather drastic database changes.

* The category_attribute_type and image_attribute_type columns removed from s_item_type.  
Replaced with s_item_attribute_type category_ind(='Y') and image_ind(='Y') respectively.  These
changes were made so that we can identify (exactly) the s_item_attribute_type record which
stores the category and image values (in item_attribute records).  Whereas before we could only
identify via the first s_item_attribute_type with the matching s_attribute_type, now we can
identify exactly.  In the case of the category_ind, this one is not actually used to identify the
category item_attribute, because the primary category value is still stored in item record.  The
category_ind is used to properly order the item_display and item_input forms.  Before this the
category input/display field was always straight after the title, now this is not necessary.

* As part of the introduction of category_ind/image_ind columns to s_item_attribute_type, the 
existing records had to be altered to put the category_ind record in the correct location according
to the order_no.  This required all the s_item_attribute_type records to be replaced.  A patch.php
has been provided to convert existing item_attribute records to match the new s_item_attribute_type
order_no's.

* Modified MUSICGENRE to shorten the display values of rock option to "Rock" added a "pop" Popular 
entry and remove the data one.  This will be a more generic set of lookups, and let CDDB choose
the default only.  Removed the CDDBGENRE from the s_item_attribute_type table.  

* Removed display values for RATIO s_attribute_type_lookup records.

* Modified search.php,stats.php to call fetch_category_attribute_type function instead of referencing
the $item_type_r['category_attribute_type'].  Also modified the search.php to include a CategoryType
array so we can use the arrayOfAttributes to match the category_type for a s_item_type. 

* Removed index.html.old as all web servers should support using index.php as Index Page.

* Updated backup.php to select both item and item_attribute tables as these are the two tables that
change the most.

* Updated listings.php to expand category value to the s_attribute_type_lookup value if available.

* Modified format_mins display widget.  The %H and %M now no longer include the actual hours or
minutes value.  The %H and %M only contain the "hour[s]" or "minute[s]" word.  So you will need
to prefix the %H with %h and %M with %m to get what you previously had.  This is to provide more
flexibility for the display because you can separate the %h/%m from the %H/%M.  Modified sql/opendb.sql
as a result.

* Removed single_select_or_value input widget as now the single_select/multi_select will add an extra
option to the SELECT object (and select it as default) if value is not found in lookup values.  The
same will occur for radio and checkbox groups.

* All input widgets driven off the s_attribute_type_lookup now have the same logic as the new single_select,
where if the value is defined and is not found in the lookup resultset, an extra field will be added.
Unfortunately in this situation the specified format mask is ignored, as all we have is value.  (We do
not have img or display)

* Provided a patch.php/patch.sql scripts to make it easier to migrate from 0.30rc5 to 0.3.1.0

* A lot of updates to upgrade.php to support new database changes.  Also enforced the order of operations
for the upgrade so it all works correctly.

* Renamed include/common.php to include/config.php to better reflect purpose of file, and to also ensure
that new and different config items are updated by older users.  Modified a lot of the configuration
variables, including database config.

List of options changed, or removed:

Removed:
	$server_name
	$path

Replaced:
	$dbhost with $db_server['host']
	$dbuser with $db_server['username']
	$dbpass with $db_server['passwd']
	$dbname with $db_server['dbname']
	
	$timeout_in_seconds with $opendb['timeout']
	$header_title with $opendb['title']
	$version with $opendb['version']
	$your_name with $opendb['admin_name']
	$your_email_adress with $opendb['admin_email'] 

	$logging with $logging['enable'] (Also changed to TRUE|FALSE instead of yes|no)
	$logfile with logging['file']
	
	$show_item_image with $item_display['show_item_image']
	$max_number_items_per_page with $listings['items_per_page']

* Modified all table integer columns to be unsigned to provide the maximum capacity possible without 
increased size requirements. Reduced item.id and foreign key links from bigint(20) to integer(10), which
provides a maximum of 4,294,967,295 records in a database instance.  Once we get to this many records,
the database will be so slow that no more should be added anyway :-).  This reduces the size requirements
of the database by 4 bytes per record.  The item_instance will be a smallint(5) unsigned giving a maximum
of 65536 instances for each item.

* Modified review table to be indexed on item_id alone.  This was changed because item_instance now allows
more than one item to be recorded against a single title, which is why we were linking review to title
previously.  This completes what has been a drastic and fairly complex change of database structure, but one
that was necessary!

* Quite a few new functions added to various functions/*.php that I have forgotten about.  A lot of changes
to support instance_no as well as item_id.  Also the site plugins have been changed to pass this information
back into item_input, etc.  The rest of the item_instance functionality will be implemented in a future release,
it is sufficient for now to have all the required database structures in place.

* user_admin.php
	Included support for deleteconfirm, so that whenever a delete request is made, the user is asked to
	confirm delete before it is made.  This idea came from phpMyAdmin.  Also added updateinstance operation,
	so that listings.php can include active_ind toggle functionality.

* index.php 
	Because of the addition of $opendb array of configuration items, a $opendb['enable'] = TRUE|FALSE has also
	been added.  If $opendb['enable'] is explicitly set to FALSE, then instead of the menu and main frame
	being displayed, the index.php will generate an information page informing visitors that the site is
	currently unavailable.

* Logfile.php
	- Finished syntax highlighting and setup options
	- Default behavior upon first click is to use "highlighted log" with
	a number of keywords..

* Login.php
	- Added option to "email new password" on incorrect login

* User_admin.php
	- Added option to send "welcome email" on new account creation
	- Fixed bug for selection of "borrower" type
	- Added header for $op=="delete"

* functions/User.php
	- Added fetch_user_email() function
	- Added generate_password() function

* sql/canada.sql
	- The default VID_FORMAT should be set to NTSC

* include/style.css
	- Fixed mistake with css bold property with A:active

* functions/site.php - Added get_new_search_link(...) function for use by
individual site plugins when they want ot go back to item_add.php.  Updated imdb and
freedb to use this.

* site/imdb/functions.php - fixed a problem with matches that do not have a image
associated.  Moved the -100 offset inside check for whether ALT="cover" is actually
found.

* Heaps of other stuff I have forgotten!

0.30rc5
-------

* Remove session_unregister("site_session_vars"); stuff from item_input when $op="site", and
moved to $op="insert".  Also added session_unregister(...) to item_add.php.  This means
that the last site variables registered will be available until the next time an item
is to be inserted, or until the item currently being edited is inserted.  

* Added borrower level user.  Also added protection to item_input when user is borrower/guest.
Modified menu.php for borrower stuff as well.  A few changes to user.php including adding
a new is_user_borrower.php, etc.  Other modified files include item_add.php and item_input.php.

* Modified stats.php to only display users who can own items, did the same for search page Owner
LOV. 

* Modified search.php to allow order by Update date.  This also meant a few changes to item.php
as well.  Added ability to search on update_on as well.  Also added SELECT object for attributes
that are sourced from the s_attribute_type_lookup table.

* Replaced direct link to logfile with logfile.php.  This is an interim solution, while Marc
Powell works on a final version of this idea.  I added it because this was really the only obvious
security hole left.

0.30rc4
-------

* Updated some of the input widgets to support a display mask.  The widgets text, textarea
and number, now support an extra parameter, which should include the %field% format specifier,
to include the actual field.  This allows extra text to be included with the field in the form.
An example of this is the RUN_TIME input field, which in the sql/opendb.sql now includes a 
italics minutes string, which allowed the removal of the (min) part of the prompt.

* Updated format_min display widget, for the event where minutes equals zero.  Now in this
event everything after the last occurence of %h/%H will be discarded.

* Replaced the tokenise function with my_explode(...) which supports the inclusion of , in 
an argument by \, escaping them.

* Small fix to freedb.org site plugin to prefix seconds <10 with a zero.  Also added INITCAP
for all tracks and title.

* Small fix to imdb site plugin where Cast overview, is not necessarily first billed, as for
"Twist of Fate".  Now the actors block starts with "Cast overview" string, which is the common
block start for most titles, as far as I can tell.

* Renamed invalidsession.html to invalidsession.php and moved to include directory.  Also
moved style.css to include directory as well.  Modified all php files appropriately.

* A few changes to stats page, including a Number of Reviews entry, plus a fix of a potential
bug if an s_item_type image is not defined.

* A few cosmetic changes to the upgrade.php script.

0.30rc3
-------
* A fix for email.php, where the from address was actually being displayed with the same
value as the to one.  A fix to listings.php, when run from search, linked items were being
displayed, if the search page was not altered from its default values, this has been fixed.

* Added a new display widget (format_mins) for displaying hours and minutes values from a 
minutes value.  The sql/opendb.sql was changed to add this new widget to the s_attribute_type
RUN_TIME.  

* Addition of some new ratings images, with associated updates to the sql/*.sql scripts

* Changes to chart.php
-	Allows a "threshold" variable to be passed to the script to control the
 	minimum wedge size to label (defaults to 3%)
- 	This might be useful for the s_type item graph since there are very few
	wedges and the threshold could be low or even zero.
-	Also removed the extra wedge line for 100% graphs and also for empty
 	graphs (to show continuous circle)
 
* The biggest addition is functionality for restricted "Guest" users.  This allows you to add
guest users with known passwords and usernames if required, which can only view the data, but
cannot update it.  For this functionality, borrow.php, item_add.php, item_display.php, 
item_review.php, functions/user.php, menu.php and user_admin.php were all modified. 
user_admin.php underwent the  most changes, and also included some unrelated cosmetic changes.

Also moved all the documentation into the subdirectory docs, so it will be easy to keep addding
to it as we go along.  Added a couple of new docs: 
	typefunctions.txt - to describe the input_type and display_type formatting function options
	naming_standards.txt - Details naming standards for the project.


0.30rc2
-------

Added a variable to include/common.php $show_item_image so that the display of the item image
in item_display.php can be disabled.  This is especially useful in situations where external
network access is disabled and the images are located on an internet site such as IMDB.  Also
made a few mods to the stats.php script, plus some aesthetic changes that are insignificant.

0.30rc1
-------
Substantial changes occurred for this release.  First of all the reviews were modified so that
reviews are uniquely identified by title as well as s_item_type, so that we do not get in the
situation where a title review for a DVD accidentally gets connected to a CD of the same
title as well.  For instance the DVD or VHS video Forrest Gump should have different reviews
to the Forrest Gump CD.  A new column s_item_type was added to the review table as a result.

A new column 'parent_id default NULL' was added to the item table to support linked items.
This is especially useful for titles which will be borrowed as a single unit, but actually have
more than one item to be described, for instance a double CD, or double feature DVD.  The 
linked (or child) items are only visible from the item_display and item_input forms.  You will
not be able to search for these items in any way.  The total item count in the statistics form
will also not register these linked items as contributing towards the total.

Thanks to Marc Powell the Statistics form has undergone a major revamp to give a lot more
information.  There are now s_item_type specific graphs for breakdowns of ownership and
categories.  A new graph for breakdown s_item_type for all items has also been added.

Also from Marc Powell is a cool upgrade.php script for migrating from DVDDBP.  Read the
upgrade.readme.1st document for more information.

Some general cleanups of code...


0.20p3
------
Small cleanup of functions/input_type.php get_display_type_value(...) including the addition of 
new dedicated do_list(...) function for generating the new unordered_list, ordered_list.
The logic no longer uses <ul> and <ol> for generating lists as this tabbed the stuff in
and made it look strange.  Added a new list widget ticks_list which looks pretty cool.
I have updated sql/opendb.sql to use this for DVD_EXTRAS.  If more than one line of
extras is included for an item you will see the ticks, otherwise not.

0.20p2
------
Changed item_input.php to enforce a maximum of 255 for title, which is the limit of the
database column.  But the most important delivery for this patch release is to close a 
MAJOR security hole in tbl_dump.php which not only allows access to non-admin users, but
also to non-authenticated users as well.  This has been fixed.

0.20p1
------
Small change to tbl_dump.sql to fix problems with the changes to support escaping
of newlines.  Uses addcslashes($row[$j], "\'\"\\\0\r\n") for the insert value only,
instead of what I was originally doing, which was escaping the complete insert 
statement after the fact.

0.20
----
Updated tbl_dump.php get_table_content(...) and get_table_csv(...) to escape newlines instead
of removing them. The data fields where no newlines should be entered have input constraints
anyway so there was no sense in removing them.  For fields such as DVD_EXTRAS where the newline
is used as a delimiter for the special features, the removal of newlines was causing problems.

Updated functions/input_type.php:- Renamed functions/input_type.php get_lookup_display_field(...)
to get_display_type_value(...) because of the generic functionality added.  New input_type
widgets added: checkbox_grid(...) and radio_grid(...).  New display_type functionality added
as well.  Now you can specify a bit more to the s_attribute_type display_type, much like the
input_type.  Widgets added: nl2br, unordered_list, ordered_list.  For more information about
the changes to input_type.php refer to the database.info.txt for more information.  The 
functions/input_type.php script would also be a good place to look.  Specifically the 
get_input_field(...) and get_display_type_value(...) functions.  As a result of some of these
changes the sql/opendb.sql has also been updated.

Updated freedb.org site-plugin.  Now the plugin displays the found titles as an ordered list
with numbers.  Duplicate titles (non-case sensitive) are removed before display.  A new
site/freedb/config.php variable $max_titles_list was added to configure how many titles should
be returned for a query.

0.19p7
------
A major update to the backup.php and tbl_dump.php scripts.  backup.php has been brought in
line with all other forms using the class=top and class=top2 for formatting.  I removed
the option to backup the structure of tables, as this is already provided by the installation
scripts.  I also made the sql option automatically do full inserts, as the other format of
not specifying the the insert columns was confusing, and in some cases caused duplicate
column constraint errors.  I also provided the option to backup multiple tables in the
one go when using SQL Inserts option.  The CSV Data option still just supports the single
table.  I also made several small updates to fix bugs reported in search.php and login.php.

0.19p6
------
Changed search.php again.  Initially the first s_item_type encountered was being selected
as the default type.  This was becoming annoying as in many cases a search accross all types
is preferable.  Now the default s_item_type is the ALL option.  The Category lov is empty,
but the Attribute lov contains a unique list of attributes accross all item types.

0.19p5
------
Changes to borrow.php.  Email notifications were specifying the user_id's for borrower and owner.  
Changed to specify fullname.  The SQL that actually gets the fullname from the user table already
defaults to user_id if fullname not specified.  Also modified format of messages to be a little 
nicer.

0.19p4
------
Added language icons for AUDIO_LANG and SUBTITLES.  Thanks to Marc Powell for these, they look cool.
Also added option to force an empty %img%, instead of the default of using %value%.  Now you can
specify an s_attribute_type_lookup %img% of "none" (without quotes) so that the %img% is replaced
with an empty string, instead of the <img ...> tag or %value%.

==> 0.19p3
Small update to the search.php page.  If all item types option is selected.  The category LOV is
still empty, but the attributes LOV now has a unique list of attributes accross all item types.
I also updated listings.php to rawurlencode around $title and $attribute_val, so that any wildcards
would get past through.  The functions/item.php was updated to remove the LIKE support from the
where_clause function for s_item_type, category, owner_id, attribute_type.

0.19p2
------
A small problem with the search page was fixed.  The attribute search was not working, due to me
stupidly :-) setting the type of the form input field to "attribute_val"!!!!

0.19p1
------
A few very minor cosmetic changes.  Committed as a patch more to make sure they do not get lost
than anything else.  Please check 0.19 change log for details of updates since 0.18...

0.19
----
Modified item_display.php to allow multiple site plugin links to be displayed.  This relies
on more than one site specific attribute existing for the item.  Currently this is not supported
by the IMDB or FREEDB.ORG plugins.  But it does allow the future possibility of super plugins
which chain plugins together.

Also I have rewritten the search page to be much more powerful.  It now provides dynamic update
of select objects (Category and Attribute type) depending on site type.

After some wrangling it supports Netscape 4.7x, Opera 5.1, Mozilla 0.9.4 and Konquerer on linux.
I have yet to test this functionality with other browsers.

0.18p1
------
Cleanup of user_admin.php.  I wanted to enforce correct entry of such values as email addresses.
Earlier releases contained validation when a user was being entered initially, but this validation
was not performed for updates.  I have enabled this now, and also provided rudimentary email format
validation.

Cleanup up of email.php.  Created a generic email function in functions/function.php.  Added email
notication to the borrow.php script.  For Reserve, Cancel Reserve, Check Out and Check in the owner
or the borrower (it depends) will be emailed via the php mail function.  No notification will be
sent if $use_php_mail==FALSE.  This is an initial release, and I am not sure that email works in
all cases, it may need revising.

0.17p6
------
Rewrite of the item attribute type select statements to do outer joins to the item_attribute table
for the attribute_val.  This avoids a separate get_attribute_val and is_attribute_set calls.  Also
removed order_by clause when generating list of attributes to update/insert.

A few more small fixes to widgets, including remove of lower(input_type) from all select statments,
so that case specific formatting can be added to display fields if required.  The widget type part
of the input_type field is now set to lower in the prc_input_type function instead.

If an attribute is set to empty in an update field, it is now deleted, instead of being set to
empty.  The item_display page now only displays attributes actually set, which makes for a nicer
form, except when no attributes are set :-)

Extra checking in function scripts user.php, item_attribute.php and item.php for the update functions.
Will only return false if mysql_affected_rows() === -1. Will only write update log if mysql_affected_rows()>0.
mysql_affected_rows()==0 is ignored, but treated as success nonetheless.  This was not done for insert
or delete where a mysql_affected_rows()==0 is a failure.

A fix for horizontal_check_boxes and horizontal_radio_group widgets.  The default selected item as
configured in the lookup table was not being CHECKED.  This has been fixed.