Open Media Collectors Database

File Release Notes and Changelog

Release Name: 0.81p20

Notes:
This release is a new features upgrade for 0.80, with some additional bugfixes, etc.

The most important enhancements are:
   * Integrated Thumbnail support for images
   * Site Plugins architecture redesigned and implemented. IMDB, FREEDB, AMAZON, MICHAELD plugins all included as part of core.

The other plugins will be converted over soon.

Minor enhancements include:
    * Change user support - allows admins to temporarily login as another non-admin user to check in items, etc.

    * Last Items List on login page.

Cheers
Jason

Changes:
0.81p20
-------
* functions/thumbnails.php
	Fix minor issue with saving of thumbnails, cannot identify if a render to filename 
	issue has occurred, it looks like a thumbnail has been successfully saved when thats 
	not necessarily the case.

* various site plugin fixes

* some changes to item borrow to allow configuration of specific title masks.



0.81p19
-------
* functions/thumbnails.php
	Fix minor issue with saving of thumbnails, cannot identify if a render to filename 
	issue has occurred, it looks like a thumbnail has been successfully saved when thats 
	not necessarily the case.

* functions/http.php
	Fixed an issue with quick checkout in php 5, where array_merge
	is being used with null first parameter.
	
* site/amazon.class.php
	Minor parsing issues with images and reviews resolved
	
* item_add.php, include/tabs.js, functions/widgets.php
	Migrated div layout to use opendb 1.0 layout, which should be
	compatible with IE 7.

* item_input.php
	Major fix to item input for new item addition, where a
	validation error not handled by javascript (such as genre)
	causes the form to be returned with no fields populated.
	
* external.php, widgets.php, listutils.php
	Fixes to allow streaming of imdb images even if in item add / edit
	mode, also added some code to auto resize the popup to the image
	dimensions.
	
* functions/OpenDbSnoopy.class.inc
	Updated user agent and disabled cookies in attempt to make
	amazon plugins behave better.

0.81p18
-------
* site/amazon.class.php, site/dvdempire.class.php
	Restore correct version of dvdempire plugin, and updates to
	book support for amazon.
	
* site/amazonde.class.php, site/amazonfr.class.php
	Fix so that works with php 4.x again.  Mistakenly included a
	php 5 only function call.

0.81p17
-------
* functions/database.php
	An issue accidentally introduced during 0.81p16 has been fixed. 

0.81p18
-------
* site/amazon.class.php, site/dvdempire.class.php
	Restore correct version of dvdempire plugin, and updates to
	book support for amazon.
	
* site/amazonde.class.php, site/amazonfr.class.php
	Fix so that works with php 4.x again.  Mistakenly included a
	php 5 only function call.

0.81p16
-------
* functions/database.php
	Fix for database prefixing issue in listings page

0.81p15
-------
Migrated site plugins into the core release, includes many updates
to all previously external plugins:
	amazonde, amazonfr, amazonuk, dvdempire, dvdfr, hminfo, iblist,
	mobygames

0.81p14
-------
* item_add.php, include/config.php
	new layered div interface for item addition

* site/amazon.class.php
	fixes for some issues with amazon title / coverimage / year / 
	imdb id parsing.

* site/amazon.class.php
	fixes for amazon.com plugin

* functions/theme.php
	minor update to force no cache for dynamic pages

* email.php, user_listing.php, functions/HTML_Listing.class.inc, 
  functions/Listing.class.inc, functions/user.php, include/config.php
	some fixes for email and user listings with deactivated users.

* functions/address_type.php
	minor fix to address type to include support for '*' in minimum user 
	type condition

* functions/site_plugin.php
	minor fix for include statement in site plugin class to fix possible
	issue on some servers with matching relative paths.

* site/michaeld.class.php
	update to michaeld site plugin for unverified cover art

* site/imdb.class.php
	fix for imdb image issue

* external.php
	misc changes

* functions/item.php
	fix for MySQL 5.0.12+ issue with LEFT JOIN syntax change.

0.81p13
-------
* functions/OpenDbSnoopy.php & external.php
	Minor update to disable HTTP debugging when streaming images
	
* functions/Listing.class.inc & functions/HTML_Listing.class.inc
	Minor fix to properly cache item type images to reduce round trips to
	database.  Also implemented minor fix to actually enforce width
	configuration for header columns.
	
* site/imdb.class.php
	Refactored code to fix issues with change in IMDB site format, resulting
	in no results being returned.
	
* item_add.php, functions/status_type.php
	Fix for Add New Item functionality where only one status type
	exists in the database.

* functions/SitePlugin.class.inc
	Minor fix for the scan-isbn functionality to enforce correct
	ISBN, or no match in code.
	
* item_input.php
	Minor update to display error if site plugin class cannot be found.
	
* last_items_list.php, functions/last_items_list.php
	Updates to last items list MARQUEE functionality to support public access
	configuration, where login is not necessary.

* site/amazon.class.php
	Issue with inline functions fixed

* site/michaeld.class.php
	Minor issue with title / year parsing fixed
	
* admin/s_item_type/index.php, admin/s_item_type/config.php
	Minor changes to bring SQL gen routines into line with the new Item Types
	upload functionality on the website.

0.81p12
-------
* site/michaeld.class.php
	fix issue with titles that do not have a numeric year.
	
* admin/s_site_plugin/index.php, admin/s_site_plugin/select.js
    Minor fix for issue with prefixing and HMINFO installation process.
	Minor fix to the Edit Item types functionality.
	Minor fix when attempting to insert input field records.

* functions/SitePlugin.class.inc, admin/s_site_plugin/index.php,
  admin/s_site_plugin/functions.php
	Updated to supported cuecat and non-cuecat scanners for ISBN and UPC
	codes.
	
* item_add.php
	Fix for admin item add functionality.
	
* site/freedb.class.php
	Fix for AC/DC artist / title issue as reported in bug #1226823

* site/imdb.class.php
	Reference to deprecated getLocation() method from SitePlugin class
	has been change to getFetchedURILocation()


0.81p11
-------
* item_borrow.php
	Fix for quick checkout issue with existing reservation, and also
	enhancement to be able to use existing reservation record instead
	of creating new one.

* item_input.php
	Minor fix to ensure Compulsory footer note is correctly displayed.

* import/DVD_Profiler.php
	update DVD Profiler import plugin to support some changes to the 
	DVD Profiler 2.3.X export XML format.
	
* item_add.php
	Fix for single status type issue with adding an item.
	
* admin/s_status_type/index.php, admin/s_status_type/functions.php
	updated to fix issue where if a status type allows change owner it would 
	not allow borrowing or new inserts.  This was short sighted, and the 
	example status type (For Sale) did not even conform to these restrictions 
	anyway.

0.81p10
-------
* admin/s_address_type/index.php, admin/s_attribute_type/index.php, 
  admin/s_item_type/index.php, admin/s_site_plugin/index.php, 
  admin/s_status_type/index.php
  	Added compulsory help text entry to each of these tools where
	required.
  
* admin/s_site_plugin/index.php
	Modified generate_site_plugin_sql(...) to remove s_attribute_type
	inserts cleanup.  Modified Site Plugin edit/new form, to fix ugly
	issue, where if no s_site_plugin image selected, a broken image 
	would appear, now changed to set to a 1x1 pixel spacer image,
	where no image defined.

* functions/widgets.php
	Added new format_input_field(...) and modified get_input_field(...)
	to use this instead of format_field(...).  The new function has included
	functionality for visually indicating a field is compulsory.
	
	Minor update to _format_help_list(...) to not append <br> if list is
	being closed.
	
* user_admin.php, item_input.php, item_review.php, email.php
	Added 'Compulsory' footer help text where compulsory fields are used.

* functions/import.php
	Minor change to listing_item_import_result_row(...) to remove class="..."
	from embedded table in attributes.  A timing issue, sometimes causes the
	wrong class to be used.

* backup.php, functions/widgets.php
	Moved setCheckboxes(...) JS function into widgets and modified backup.php
	to call get_setcheckboxes_javascript(...)

* export.php
	Added Checkall / Uncheck all buttons.

0.81p9
------
* external.php
	If session expires as the external.php script is initiated, an error
	is displayed, but no option to login is provided, this has been
	fixed.
	
* admin/s_item_type/index.php & admin/s_site_plugin/index.php
	Updated logic so even if patch/s_item_type/*.sql or patch/site/*.sql
	definitions are already in the database, the interface to the patch
	system would still be made available to 'Reinstall', for such things
	as patches, etc.  

* patch.php	
	The Item Type and Site Plugins sections have been removed from the
	patch facility, as all operations can be performed from the System
	Admin tools.

0.81p8
------
* item_input.php
	Added support for overriding $CONFIG_VARS['item_input.title_articles']
	at the site plugin level with s_site_plugin_conf records.
	
* item_add.php
	Minor reformat of the layout to make it a bit tidier.
	
* site/amazon.class.php
	Minor fix to correctly parse year in amazon page.  Removed hard coded ratio's to
	match any specified, as long as they conform to standard format.
	
* functions/site_plugin.php
	Updated get_expanded_site_plugin_item_variables_r function to
	not include duplicate mapped lookup values.  Also enhanced
	get_site_plugin_links_table to only display links for plugins
	which actually exist - using the is_exists_site_plugin
	function call.

0.81p7
------
* site/amazon.class.php
	Minor fix to return 'No Records Found' message if ASIN or ISBN
	entered as search term, and do not return anything.
	
* site/images/manual.gif
	Copy of images/icon.gif, but created because site plugins currently
	are not themeable, and wanted to remain consistent.
	
* item_add.php
	Added additional check to not display site plugin block, if the
	site plugin class is not in the site/ directory.  Also a minor
	formatting change for image and description. Also reference
	new site/images/manual.gif instead of icon.gif.

0.81p6
------
* include/menu.php
	Minor fix to support including Last Item List when guest user.
	
* item_add.php
	Minor fix where no site plugins are installed.
	
* functions/language.php
	Minor fix where using local.english.inc.php (or local conf for other languages),
	before 0.81p6, the local.english would be a language option in Edit My Info,
	and considered a legal language option.

0.81p5
------
* item_add.php
	Refresh functionality was broken by changes in 0.81p4, fixed now.
	
* functions/Install_Table.php & admin/s_site_plugin/index.php
	Improvements to the support provided for importing files into 
	database tables.  HMINFO plugin currently is only plugin that
	requires this functionality.
	
* functions/phpthumb/phpthumb.class.php
	Fixes to support fix problems where GD is not available, and item_input.php
	script no longer works.  This is because the phpthumb class actually does 
	an 'exit;' call and dumps out an image if GD is not available.
	
	Modified class functions:
		function SourceImageToGD()
		function ImageCreateFromStringReplacement(&$RawImageData, $DieOnErrors=false)

0.81p4
------
* patch/prefix/index.php
	Added support for prefixes on the new tables introduced in 0.81.

* backup.php
	Minor fix to prefix the table names being exported, if prefixing is
	enabled.
	
* functions/parseutils.php::get_rebuilt_function($function_name, $arguments_r)
	A bugfix to reescape double quotes included in argument text, that are not
	used to enclose arguments with commas.
	
* admin.php
	Minor fix

* site/imdb.class.php
	Minor fix to support matching against more than just USA age ratings, this is
	a restoration of existing functionality prior to 0.81.
	
* site/amazon.class.php
	Minor fix
	
* item_input.php
	Minor enhancement to avoid issues with site plugins that do not explicitly
	return TRUE from queryListing(...) function.
	
* admin/s_plugin_type/index.php, functions/Install_Table.class.php, functions/import.php
	Added support for hminfo site plugin specific functionality, to load data from CSV
	file into a database table.  The functionality was kept generic in case it could be
	used in other instances.
	
* item_add.php
	Enhanced to display two site plugin blocks per row in a table layout, so
	that that page is less busy and easier to use.  No support for the old
	layout.

0.81p3
------
* functions/listutils.php
	Fix to get_cover_image_r(...) function to prefix '@' to getimagesize(...)
	in case image is inaccessible for some reason, so as to avoid showing
	errors to the UI, where they will cause confusion.
	
* functions/fileutils.php
	Modified save_upload_file(...) to not use move_uploaded_file(...)
	
* login.php
	Fix for whatsnew bug
	
* item_input.php, functions/item_input.php
	Fix for a couple of refresh issues, including a nasty one, where
	if you chose the 'old' title option in a refresh, the title would
	actually get set to 'old'
	
* last_items_list.php
	Updated to support marquee functionality without logging in.

0.81p2
------
* functions/item.php::fetch_item_listing_rs(...)
	Removed cast(...) function to force numeric orderby, because this
	was actually broken, instead just added '+0) to end of column,
	which actually forces MySQL to treat it as a number.
	
* admin/s_attribute_type/index.php
	Minor fix to Site Type field where no site plugins are installed.
	
* external.php, functions/Snoopy.class.php
	Minor update to hide errors if fsockopen fails.

* admin/s_item_type/index.php
	Added functionality to list SQL item_type patch definitions, that
	have yet to be applied, similiar to functionality in site plugins
	admin tool.
	
* include/menu.php & last_items_list.php
	New last items list functionality available from the menu.
	
* login.php
	Modified code a little to include a header for logged in welcome,
	so its not blank.
	
* functions/item.php, functions/last_items_list.php, item_display.php,
  login.php
	Fix to resolve issues with configuration of last_items_list
	functionality in login page.
	
	Moved (from functions/item.php) get_last_num_items_rs(...) to 
	functions/last_items_list.php

* functions/widgets.php
	Fix for issues with language packs and javascript prompts, to
	upload(...) and saveurl(...) functions.  Added an addslashes(...)
	call around $LANG_VARS in javascript code.
	
* site/michaeld.class.php & site/amazon.class.php
	Minor fixes

* functions/item_input.php
	Fix to allow saving of title, status type and borrow duration in edit 
	mode.

0.81p1
------
* site/imdb.class.php
	Updated to fix issue with listings.
	
* login.php
	Modified so last item list heading will not be displayed by itself,
	where a new opendb database.
	
* backup.php, admin/s_item_type/index.php, admin/s_site_plugin/index.php
	Changed the mime type for export of SQL, from text/plain to 
	application/octet-stream.
	
* admin/s_item_type/index.php
	Minor change to 'Back to Types' link, to bring it into line with the
	Site Plugins tool.
	
* backup.php, lang/english.inc.php
	Added 'Check All', 'Uncheck All' and 'Reset' buttons to backup screen,
	to facilitate easier backing up of all tables, or only one table.  Also
	checked 'Send as File' by default.
	
* admin/s_site_plugin/index.php, admin/s_site_plugin/functions.php, admin/s_site_plugin/select.js, 
  admin/s_item_type/functions.php
  	Added a new Item Types tool to control what item types a site plugin is applicable
	for.  This is easier to use than the Item Type's tool.

0.81
----
* listings.php, item_display.php, functions/item_type.php
	Removed is_item_site_type(...) in favour of is_item_legal_site_type(...)
	function which actually checks for the existence of a matching 
	site plugin class.
	
* functions/item.php
	Added new function get_last_num_items_rs(...) to items.php for use
	in displaying last number of items added functionality in login.php
	
* functions/http.php, backup.php, admin/s_item_type/index.php
	Introduced some new functions to work out what operating system the
	user browser is running on, so any SQL scripts generated can have the
	correct CRLF value appended to each line.  The functions added were:
		get_user_browser_crlf()
		get_user_browser_os()
	This functionality was borrowed from phpMyAdmin source code.
	
* admin/s_item_type/index.php
	Modified so that the SQL option, sends the output as a text file directly.
	
* functions/item_type.php, patch/install/opendb.sql, patch/item_types/mp3.sql,
  patch/item_types/game.sql, patch/item_types/divx.sql, patch/item_types/book.sql
	Remved default_site_type column from s_item_type table, as its 
	superfluous and inelegant at best.
	
	Removed functions/item_type.php function:
		fetch_item_type_sitetype(...)
		
	Modified functions/item_type.php functions:
		fetch_item_type_r($s_item_type)
	
* admin/s_item_type/config.php
	Added IMDBRATING as core s_attribute_type, removed site plugin attributes
	from core list, but modified internal functionality of the s_item_type
	SQL generation process to exclude site attributes from the generation
	process in addition to core attributes.
	
* include/search.js
	Added support for not including empty option to populateList function,
	by passing null emptyOptionValue.
	
* functions/patchutils.php::is_opendb_upto_date()
	Modified to include checks for site plugin tables, but also modified
	to check a new flag in the $_OPENDB_CORE_TABLE_LIST table.
	
* item_display.php
	Minor update to change table width from 90% to 100%, this makes it
	much nicer layout for both normal and printable views.
	
* functions/fileutils.php, admin/thumbnails/*, functions/item_input.php,
  functions/thumbnails.php, item_display.php, functions/listutils.php,
  functions/HTML_Listing.class.inc, functions/Listing.class.inc
	Introduced support for generating and displaying thumbnails of
	image attributes.
	
* functions/site_plugin.php, functions/SitePlugin.class.inc, backup.php,
  functions/patchutils.php, functions/theme.php
  	Site plugins architecture rewritten.

* include/theme.php, item_borrow.php, include/menu.php, docs/scripts/reminders.sh
	Updated code to use generic $HTTP_VARS['mode'] = 'job' for functionality
	that will be called from a script, and thus should be plain text.

* admin/s_item_type_group/*
	New admin tool added.
	
* admin/s_item_type/index.php
	Updated to check for referenced s_item_type_group records, and
	delete them if found (after prompting user to continue of course!)
	
* functions/admin.php
	Minor fix to get_admin_tools_r() to exclude directories where
	no index.php is found.
	
* functions/listutils.php
	Updated function get_item_type_config_key(...) to reference
	s_item_type_group table.
	
* functions/review.php
	Changed logic to reference s_item_type_group table, by removing
	call to get_item_type_group_for_item_type(...) and replacing with
	call to fetch_item_type_groups_for_item_type_r($s_item_type).
	
* functions/item.php
	Removed function get_item_type_group_for_item_type(...) as no longer
	required.  Updated from_and_where_clause(...) to reference the
	s_item_type_group table.

* include/config.php
	Removed $CONFIG_VARS['listings.s_item_type_groups'] as being replaced
	by s_item_type_group table.
	
	Removed $CONFIG_VARS['item_add.site_plugin_order'] as replaced by
	s_site_plugin table.  No support to order the 'manual' type, it
	will always be last.
	
	Removed $CONFIG_VARS['site_plugins.translate_plots_with_google'] as
	no longer supported generically.  Individual site plugins could make
	use of this functionality if required, but this is not currently
	supported.
		
* functions/ItemImportHandler.class.inc
	Minor fix to the ItemImportHandler class to change the name of the
	$errors variable to $_errors, which is what is referenced throughout
	the class.  Not sure why this was never seen as a problem before.
	
* functions/item_attribute.php
	New function is_exists_site_item_attribute(...)
	
* item_display.php
	Changed call of function from get_site_links_table(...) to 
	get_site_plugin_links_table(...).
	
* admin/s_attribute_type/index.php, admin/s_item_type/index.php
	Changed reference from get_site_type_r() to get_site_plugin_list_r()
	
* functions/item_type.php::is_item_legal_site_type(...)
	Changed reference to is_legal_site(...), to is_site_plugin(...)
	
* functions/user.php, include/menu.php, lang/english.inc.php, login.php, 
  logout.php
	Add support to allow administrators to change to another user, so that
	they can perform operations in that persons name.  Logging of the fact
	the admin user has changed will be made, from that point forward all 
	operations will be undertaken as the new user - there is currently
	no record of the fact, that its actually the admin user doing this.
	
* admin/s_attribute_type/functions.php & functions/item_attribute.php
	Moved is_exists_attribute_type(...) function to functions/item_attribute.php
	so it can be used in other areas of the system.
	
* functions/parseutils.php, item_review.php, item_input.php, item_display.php,
  item_borrow.php, item_add.php, export.php, borrow.php, functions/Listing.class.inc,
	Modified arguments for function calls:
		expand_item_title_mask
		expand_type_title_mask

* functions/parseutils.php, functions/widgets.php
	Updated expand_field_mask param order to bring in line
	with other changes made to parseutils.php

* item_display.php
	Modified item_display to support displaying a printable version of item_display,
	using a Printable version link added to item_display.