HTTPS SSH
What's new in 4.0.3 Alpha
-----------------
*New. Supports Joomla 3.1 (3.0 is not supported).
*Fix. Default content missing function errors (#10).
*Fix. Joomla 3.0 DS constant removed (#11).
*Fix. Joomla 3.0 authorise vs authorize (#12).
*Fix. User review error Interface 'IConfigurable' not found (#14).
*Fix. Frontend Language not getting loaded (#18).
*Change. Updated to jQuery 1.9.1 and jQuery UI to 1.10.2.

What's new in 4.0.2 Alpha
-----------------
*New. Review field placeholders now support raw rendering by using an underscore suffix e.g. {Review:Field:1_}.
*Fix. Call to undefined method TemplateCategoryFrontBase (#1).
*Fix. Option being set incorrectly (#2).
*Fix. Review Title Helper using incorrect path to interfaces (#3).
*Fix. Community Builder not being detected (#4).
*Fix. List title placeholder not working (#6).
*Fix. Not able to change the review's author in Joomla 2.5 (#7).
*Fix. Cannot assign ACL (#9).

What's new in 4.0.1 Alpha
-----------------
*New. Dropped support for PHP 4.
*New. CSS classes and IDs are now prefixed with "sr-" (work in progress).
*New. Support for Joomla ini language files (work in progress).
*Removed. Top review widget on the categories' review listing page. This should now be done via the Joomla Top/Latest reviews module.

What's new in 3.0.13
-----------------
*New. Support for Joomla 2.5.
*Fix. Turning star rating off in comments.
*Fix. JavaScript error if comment rating is turned off.

What's new in 3.0.12
-----------------
*New. Comments no longer require a body (configurable).
*New. Comments no longer require a rating (configurable).
*New. More debug information if a category could not be found.

What's new in 3.0.11
-----------------
*New. Reviews no longer require a rating.
*New. Updated jQuery Validation Plugin to 1.8.1.
*Fix. Placeholders. Issues with the following tags have been fixed: {Category:Alias}, {Category:ID}, {Category:Name}, {Review:ID}

What's new in 3.0.10
-----------------
*New. Support for Joomla 1.7.
*New. Support for page breaks in reviews. Uses the standard Joomla page break button. Your templates review.css may require a new class to force the pager on a new line: .pagination{clear: both;}
*New. Basic Joomla 1.6 ACL support.
*New. Added support for getting comment avatars from phpBB via p8pbb.
*New. Added a setting for the date format in comments.
*Fix. Real name display not working in comments.
*Fix. Export comments. Not working in PHP4. Not working if using non-default database name. Export getting cached.
*Fix. Category page, Undefined variable: link.
*Fix. If you have switched Avatar Providers, try using the previous avatar if the Avatar Provider can't find one for the user.

What's new in 3.0.9
-----------------
*New. Added support for getting comment avatars from phpBB via JFusion.
*New. Comments can now contain new lines.
*New. Can export existing Simple Review comments to Disqus.
*Fix. Issue with allowing multiple comments for a user per review and the star rating.
*Fix. If review listing paging is turned off (Category config 'Number of displayed Reviews' > 0) don't show 'Display #'.
*Change. Made the frontend review filters linkable. This also fixed some issues with the pager.

What's new in 3.0.8
-----------------
*New. When writing a review the 'select category' step is removed if there is only one category.
*New. Added star rating ability to forms.
*New. Option to show/hide the review alias on the user review form (defaults to hidden).
*New. Google image search for selecting user review images.
*New. Review and category aliases are now optional. If not entered it will be generated from the name.
*Fix. Issues with including jQuery and jQueryUI.
*Fix. Frontend user review listing not allowing editing.
*Change. Updated to jQuery 1.6.1.
*Change. Tidied up user reviews form (more to come).
*Change. User review alias is always filtered (based on tag configuration alias replacement setting).

What's new in 3.0.7
-----------------
*New. Support for comments using Disqus.
*New. Support for reCAPTCHA.
*Fix. Category and Review image selector Joomla 1.6.
*Fix. Backend review filter and pager issue.
*Fix. Content plugins Joomla 1.6.
*Change. The default comment template has been simplified and the orange has been removed.
*Change. The default review listing template (category.css) has been changed and the alternating background colour has been replaced by a top and bottom border. This is due to not currently having nice transparent star icons.
*Change. Categories and Reviews default to being published.

What's new in 3.0.6
-----------------
*New. Can now delete custom fields.
*New. Can sort reviews in the backend.
*Fix. Deprecated errors in PHP 5.3.
*Fix. Comment display template undeclared PHP error.
*Fix. In the backend item listing the unpublished icon was displaying as published.
*Fix. Error if editing a review which has a long category field.

What's new in 3.0.5
-----------------
*New. Support for JomSocial.
*Fix. A problem with the pager in Joomla 1.6.
*Fix. Added pager css classes to category review listing (Joomla 1.6).

What's new in 3.0.4
-----------------
*New. Joomla 1.6 support (beta).
*Fix. When editing a review on a site with a lot of users then author combobox causes issues.
*Fix. Editing a banned IP may result in an undefined method PHP error.
*Fix. Top Rated Review widget layout on some Joomla templates. 
*Fix. Cancel button not working on configuration page.

Known Issues
*User review listing does not work.
*Comment IP not showing in admin.
*Select category/tag menu does not select the current value in the select list.

What's new in 3.0.3
-----------------
*Fix. If a field is missing then getting the review URL may cause an error.
*Fix. Cannot edit comments.
*Fix. Tags not working if Joomla SEO is on.

What's new in 3.0.2
-----------------
*New. Added basic avatar support in comments for Community Builder and Kunena. Comment display template changed.
*New. Tag configuration: can specify the default template for tags.
*New. Tag configuration: can specify the replacement character for non-Latin characters in tag aliases.
*New. Placeholders can now be used in the tag review listing template. See this guide to upgrade your template (if applicable):
http://simple-review.com/389-upgrading-template-3-0-0-to-3-0-1.html , be sure to use the tag template instead of category.
*New. Cleaned up main administration page.
*Fix. Error when editing a review with no titles.
*Fix. Quotes in meta information not being escaped.

What's new in 3.0.1
-----------------
*New. Placeholders can now be used in the category review listing template. See this guide to upgrade your template (if applicable):
http://simple-review.com/389-upgrading-template-3-0-0-to-3-0-1.html 
*Fix. Frontend tag filter not working.
*Fix. Widget configuration not saved on some PHP setups.
*Fix. A new user review could not be given the max rating.
*Fix. Joomla plugin warning in newer PHP versions (tested on 5.3.1) "Parameter 1 to plgXYZ() expected to be a reference, value given in...".
*Fix. Tags could not be deleted from the tag administration page.
*Fix. The last tag could not be removed from a review on the review administration page.

What's new in 3.0.0
-----------------
*New. Review templates support the hReview microformat (http://microformats.org/wiki/hreview). You can test what your review will look like in Google search here: http://www.google.com/webmasters/tools/richsnippets
*New. Can sort reviews.
*New. Can now select a specific category when creating a menu item.
*New. Reviews can now be tagged.
*New. Reviews now have meta keywords and descriptions.
*Change. The review template file has been renamed from template.html to template.html.php.
*Change. Place holder {Review:AwardImageUrl} has been renamed to {Review:Award}.
*Change. Place holder {Review:ModifiedDate} has been renamed to {Review:DateModified}. 
*Fix. Place holder {Review:Date} now works.
*Fix. User reviews are now working and have a redesigned template.
*Fix. Pager and filter.

SQL Updates:
ALTER TABLE `jos_simplereview_tag` 
ADD `name` VARCHAR( 255 ) NOT NULL, 
ADD `description` TEXT NULL ,
ADD `imageURL` VARCHAR( 255 ) NULL,
ADD `templateName` VARCHAR( 255 ) NOT NULL DEFAULT 'default';

ALTER TABLE `jos_simplereview_review` 
ADD `metakey` TEXT NOT NULL DEFAULT '',
ADD `metadesc` TEXT NOT NULL DEFAULT '',
ADD `metadata` TEXT NOT NULL DEFAULT '';

What's new in 3.0.0 Beta 1
-----------------
*New. Option to require comments to be approved before being published.
*Change. Template system has changed. Old templates are no longer compatible.
*Change. Simple Tags have been renamed to Place Holders. The place holders have a new easier to remember format and provide additional features - the old format is still supported. They are no longer case sensitive.
*Change. Editing content is now more consistent with Joomla. The layout is now simpler and provides things such as an image selector.
*Change. Category & review titles are now called fields. Fields are now optional.
*Change. Include jQuery locally by default and upgraded to 1.4.3.
*Fix. Bug where the user's real name was always displayed instead of the user name.

SQL Updates:
UPDATE `jos_simplereview_comments` SET `published` =1;

What's new in 2.2.4
-----------------
*Fixed the category order being ignored.
*Fixed new lines not being preserved in user reviews.

What's new in 2.2.3
-----------------
*Some minor tweaks to the user review submission form.

What's new in 2.2.2
-----------------
*Category - added average user rating to the default template and it now correctly displays as a star rating (if enabled)
*Category - breadcrumnbs fixed
*Category - incorrect review count fixed
*jQuery inclusion fixes.
*Review - administration paging 'all' option fixed
*Review - average user rating when a user submits more than one comment
*Review - content plugin parameter reference warning fixed
*Review - link title now correctly displays as a link
*Review - rating title now correctly displays as a star rating (if enabled)
*Review - title expand image not showing
*User Reviews - beta

Changed files:
frontend/views/userReview/index.html
frontend/views/userReview/metadata.xml
frontend/views/userReview/tmpl/base.php
frontend/views/userReview/tmpl/base.xml
frontend/views/userReview/tmpl/home.php
frontend/views/userReview/tmpl/home.xml
frontend/views/userReview/tmpl/index.html
frontend/views/userReview/tmpl/myreviews.php
frontend/views/userReview/tmpl/myreviews.xml
frontend/views/userReview/tmpl/write.php
frontend/views/userReview/tmpl/write.xml

frontend/views/commentdisplay/tmpl/default.php

frontend/views/category/tmpl/default.php

admin/classes/SRBridgeJoomla15.php
admin/classes/SRBridgeCMS.php
admin/config/modules/UserReview_Module.php
admin/globals.php
admin/simple_review.xml

admin/addons/modules/base.php

admin/addons/modules/Category_Module/Category_Module.php
admin/addons/modules/Category_Module/db.php
admin/addons/modules/Category_Module/templates/Admin/CategoryForm.php

admin/addons/modules/Locale_Module/languages/en-GB/UserReview_Module.php
admin/addons/modules/Locale_Module/languages/de-DE/UserReview_Module.php

admin/addons/modules/UserReview_Module/UserReview_Module_Admin.php
admin/addons/modules/UserReview_Module/index.html
admin/addons/modules/UserReview_Module/UserReview_Module.php

admin/addons/modules/Review_Module/Review_Module_Admin.php
admin/addons/modules/Review_Module/titles/Link.php
admin/addons/modules/Review_Module/titles/Rating.php
admin/addons/modules/Review_Module/titles/Text.php
admin/addons/modules/Review_Module/Review_Module.Admin.js
admin/addons/modules/Review_Module/db.php
admin/addons/modules/Review_Module/Review_Module.php

What's new in 2.2.1
-----------------
*Review tag table now dropped when uninstalling.
*Fixed default template drop downs.
*Fixed some unclosed html tags.
*Joomla content plugins (e.g. {mosmap} and {gallery}) now work.


Update SQL UTF8:
ALTER TABLE `jos_simplereview_category` 
CHANGE `categoryTemplateName`  `categoryTemplateName`  VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default',
CHANGE `reviewTemplateName` `reviewTemplateName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default'

ALTER TABLE `jos_simplereview_review` CHANGE `templateName` `templateName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default'

----

Update SQL Default collation:
ALTER TABLE `jos_simplereview_category` 
CHANGE `categoryTemplateName`  `categoryTemplateName`  VARCHAR( 255 ) NOT NULL DEFAULT 'default',
CHANGE `reviewTemplateName` `reviewTemplateName` VARCHAR( 255 ) NOT NULL DEFAULT 'default';

ALTER TABLE `jos_simplereview_review` CHANGE `templateName` `templateName` VARCHAR( 255 ) NOT NULL DEFAULT 'default';

What's new in 2.2.0
-----------------
*All backend users can view the backend page.
*Configuration is easier to backup (www/administrator/components/com_simple_review/config) now more robust after upgrading.
*Templates are now stored here: www/components/com_simple_review/views/.
*Templates can no longer be created online - they are now purely file based.
*New reviews can now have default content - this works similar to the old online template creation.
*Fixed Captcha now works with Security Images 5.1.2 http://extensions.joomla.org/extensions/access-a-security/captcha/1211
*Fixed CSS causing star rating to not display in the review.
*Fixed Review administration php pass by reference warning.

Update SQL UTF8:
ALTER TABLE `jos_simplereview_review` ADD `templateName` VARCHAR( 255 ) NOT NULL DEFAULT 'Default' AFTER `awardID`;
ALTER TABLE `jos_simplereview_review` ADD FULLTEXT `idx_srr_name` (`name`);
UPDATE `jos_simplereview_review` SET `templateName` = 'Blank';
ALTER TABLE `jos_simplereview_review` ADD `status` ENUM( 'pending', 'approved', 'rejected' ) NOT NULL DEFAULT 'pending',
ADD `statusReason` TEXT NULL;

RENAME TABLE `jos_simplereview_template`  TO `jos_simplereview_default_content` ;

ALTER TABLE `jos_simplereview_default_content` CHANGE `templateID` `defaultContentID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE `template` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `jos_simplereview_category` CHANGE `templateID` `defaultContentID` INT( 11 ) NOT NULL DEFAULT '-1';
ALTER TABLE `jos_simplereview_category` ADD `reviewTemplateName` VARCHAR( 255 ) NOT NULL DEFAULT 'Default' AFTER `categoryTemplateName`;

DELETE FROM `jos_components` WHERE `name` = 'Template Management' AND `option` = 'com_simple_review' LIMIT 1;
UPDATE `jos_components` SET `admin_menu_link` = 'option=com_simple_review&task=edit&module=Configuration_Module'  WHERE `name` = 'Configuration' AND `option` = 'com_simple_review' LIMIT 1;

CREATE TABLE IF NOT EXISTS jos_simplereview_review_tag(
reviewID INT UNSIGNED NOT NULL ,
tagID INT UNSIGNED NOT NULL ,
UNIQUE (
reviewID,
tagID
)
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

----

Update SQL Default collation:
ALTER TABLE `jos_simplereview_review` ADD `templateName` VARCHAR( 255 ) NOT NULL DEFAULT 'Default' AFTER `awardID`;
ALTER TABLE `jos_simplereview_review` ADD FULLTEXT `idx_srr_name` (`name`);
UPDATE `jos_simplereview_review` SET `templateName` = 'Blank';
ALTER TABLE `jos_simplereview_review` ADD `status` ENUM( 'pending', 'approved', 'rejected' ) NOT NULL DEFAULT 'pending',
ADD `statusReason` TEXT NULL;

RENAME TABLE `jos_simplereview_template`  TO `jos_simplereview_default_content` ;

ALTER TABLE `jos_simplereview_default_content` CHANGE `templateID` `defaultContentID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE `template` `content` TEXT NOT NULL;

ALTER TABLE `jos_simplereview_category` CHANGE `templateID` `defaultContentID` INT( 11 ) NOT NULL DEFAULT '-1';
ALTER TABLE `jos_simplereview_category` ADD `reviewTemplateName` VARCHAR( 255 ) NOT NULL DEFAULT 'Default' AFTER `categoryTemplateName`; 

DELETE FROM `jos_components` WHERE `name` = 'Template Management' AND `option` = 'com_simple_review' LIMIT 1;
UPDATE `jos_components` SET `admin_menu_link` = 'option=com_simple_review&task=edit&module=Configuration_Module'  WHERE `name` = 'Configuration' AND `option` = 'com_simple_review' LIMIT 1;

CREATE TABLE IF NOT EXISTS jos_simplereview_review_tag(
reviewID INT UNSIGNED NOT NULL ,
tagID INT UNSIGNED NOT NULL ,
UNIQUE (
reviewID,
tagID
)
) ENGINE = MYISAM;
What's new in 2.1.2
-----------------
*Added a new tag {sr_name} to display the name of the review.

*Added pathway/breadcrumbs.

*Added new language strings:

Category_Module.php:
--FormTemplateCategory
--FormTemplateCategoryTip
--Error404Title
--Error404Description

Review_Module.php:
--Error404Title
--Error404Description

Language_Module.php:
--ConfigPluginFooter
--ConfigPluginFooterTip
--ConfigPluginHeader
--ConfigPluginHeaderTip

Tag_Module.php
--TagReviewName

*Added frontend 404 error pages to be displayed if a review or category is not found or not published.

*Added a template for categories. This will be used when the user visits a category i.e. clicks your reviews menu item and sees the list of categories and their reviews.
The templates are found in:
www\administrator\components\com_simple_review\addons\modules\Category_Module\templates\Front\
To modify the template copy the 'Default' directory and give it a name e.g. 'MyTemplate1'.
Edit the HTML in MyTemplate1\Template.php (editing area is marked with START EDITING).
Edit the CSS in MyTemplate1\Template.css
Go to the Category administration page and change the 'Category Template' to your new template 'MyTemplate1'.

*Changed the HTML and CSS for the rating boxes - they will now be displayable horizontally (and inside P tags) rather than the forced vertically.
To revert to vertical change the css in:
www\administrator\com_simple_review\admin\addons\modules\Review_Module\templates\Front\Default\Template.css

to (from display:inline-block;):
.scoreBox, .userScoreBox
{
	display:block;
	text-align:center;
}

The new HTML looks like - note that the class names have changed and the divs have been replaced with spans.
<span class="scoreBox">
      <span class="ratingHeadingContainer"><span class="ratingHeading">Rating</span></span><br/>
      <span class="ratingContainer"><span class="rating">0.0</span></span><br/>
      <span class="ratingTextContainer"><span class="ratingText">out of 5</span></span><br/>
      <span class="ratingFooterContainer"/>  
</span>

*Changed Administration Review listing to now use the review name instead of title 1, 2 and 3.

*Changed and improved the plugin selection configuration.

*Fixed a bug where if Joomla 'Search Engine Friendly URLs' was turned off a user will be redirected to the main page rather than the review after adding a comment.

*Fixed a bug where you could not view a review if 'ONLY_FULL_GROUP_BY' was turned on in MySQL.

*Fixed star rating not being shown on category listing.

*Fixed configuration options:
Category:
--Sort options. Added "Review Name" as the default sort field.
--Limit Top N to Current Category
--Removed option 'Show Review Count' (edit via category template see http://simple-review.com/forum/index.php?topic=467.0)
--Removed option 'Show Reviewer' (edit via category template see http://simple-review.com/forum/index.php?topic=467.0)
--Removed option 'Title 2 is Review Link' (edit via category template see http://simple-review.com/forum/index.php?topic=467.0)
--Removed option 'Title 3 is Review Link' (edit via category template see http://simple-review.com/forum/index.php?topic=467.0)

*Moved:
www\administrator\components\com_simple_review\addons\modules\Review_Module\Review_Module.css
to:
www\administrator\com_simple_review\admin\addons\modules\Review_Module\templates\Front\Default\Template.css

*Moved:
www\components\com_simple_review\images\
emptystar.png
emptystar-alt.png
fullstar.png
fullstar-alt.png
halfstar.png
halfstar-alt.png
to:
www\administrator\com_simple_review\admin\addons\modules\Review_Module\templates\Front\Default\
www\administrator\com_simple_review\admin\addons\modules\Category_Module\templates\Front\Default\

The reason for moving into both Review and Category folders
is incase you want smaller or different coloured star icons in the review listing (category page) or review page.

*Removed file Category_Module.css and merged it into the Default template.
If you have made changes to this file copy them into the template.

*Removed directory:
www\administrator\components\com_simple_review\addons\modules\Review_Module\images
and merged the contents in:
www\administrator\com_simple_review\admin\addons\modules\Review_Module\templates\Front\Default

*Removed directory:
www\components\com_simple_review\frontend\css. 
File Simple_Review.css has been merged into the Default Review and Category template CSS files.


Full Listing of File Changes:
modified   admin/addons/Addon_Base.php
modified   admin/addons/Addon_Base_Admin.php
modified   admin/addons/Addon_Base_Frontend.php
deleted    admin/addons/modules/Category_Module/Category_Module.css
modified   admin/addons/modules/Category_Module/Category_Module.php
modified   admin/addons/modules/Category_Module/Category_Module_Admin.php
modified   admin/addons/modules/Category_Module/config.php
modified   admin/addons/modules/Category_Module/db.php
modified   admin/addons/modules/Category_Module/templates/Admin/CategoryForm.php
deleted    admin/addons/modules/Category_Module/templates/Front/Default/Default.css
deleted    admin/addons/modules/Category_Module/templates/Front/Default/Default.php
added      admin/addons/modules/Category_Module/templates/Front/Default/emptystar-alt.png
added      admin/addons/modules/Category_Module/templates/Front/Default/emptystar.png
added      admin/addons/modules/Category_Module/templates/Front/Default/fullstar-alt.png
added      admin/addons/modules/Category_Module/templates/Front/Default/fullstar.png
added      admin/addons/modules/Category_Module/templates/Front/Default/halfstar-alt.png
added      admin/addons/modules/Category_Module/templates/Front/Default/halfstar.png
added      admin/addons/modules/Category_Module/templates/Front/Default/Template.css
added      admin/addons/modules/Category_Module/templates/Front/Default/Template.php
modified   admin/addons/modules/Category_Module/vm.php
modified   admin/addons/modules/Comment_Module/Comment_Module.php
modified   admin/addons/modules/Comment_Module/Comment_Module_Admin.php
modified   admin/addons/modules/Language_Module/languages/de-DE/Category_Module.php
modified   admin/addons/modules/Language_Module/languages/de-DE/Language_Module.php
modified   admin/addons/modules/Language_Module/languages/de-DE/Review_Module.php
modified   admin/addons/modules/Language_Module/languages/de-DE/Tag_Module.php
modified   admin/addons/modules/Language_Module/languages/en-GB/Category_Module.php
modified   admin/addons/modules/Language_Module/languages/en-GB/Language_Module.php
modified   admin/addons/modules/Language_Module/languages/en-GB/Review_Module.php
modified   admin/addons/modules/Language_Module/languages/en-GB/Tag_Module.php
modified   admin/addons/modules/Review_Module/db.php
modified   admin/addons/modules/Review_Module/Review_Module.css
modified   admin/addons/modules/Review_Module/Review_Module.php
modified   admin/addons/modules/Review_Module/Review_Module_Admin.php
modified   admin/addons/modules/Review_Module/templates/Admin/ReviewForm.php
modified   admin/addons/modules/Review_Module/templates/Front/Default/Template.css
added      admin/addons/modules/Review_Module/templates/Front/Default/Template.php
modified   admin/addons/modules/Tag_Module/Tag_Module.php
modified   admin/addons/plugins/Comment_Display/base.php
modified   admin/addons/plugins/Comment_Display/Bubble_Comment.php
modified   admin/addons/plugins/Comment_Display/Bubble_Comment/Bubble_Comment.html.php
modified   admin/addons/plugins/Comment_Display/Standard_Comment.php
modified   admin/addons/plugins/Comment_Form/Standard_Comment_Form.php
modified   admin/addons/plugins/TopN_Display/base.php
modified   admin/addons/plugins/TopN_Display/Horizontal_TopN.php
modified   admin/addons/plugins/TopN_Display/Standard_TopN.php
modified   admin/admin.simple_review.css
modified   admin/admin.simple_review.html.php
modified   admin/admin.simple_review.php
modified   admin/classes/SRBridgeCMS.php
modified   admin/classes/SRBridgeJoomla15.php
modified   admin/classes/SRConfiguration.php
modified   admin/config.simple_review.php
modified   admin/globals.php
deleted    frontend/css
modified   frontend/simple_review.php
modified   readme.txt
modified   simple_review.xml

What's new in 2.1.1
-----------------
*Added 'Name' to review which will be used in the page's title and in the modules.
*Added string to languages files Review_Module.php (FormName, FormNameTip).
*Added new CSS classes to the review rating boxes.
*Added a default timestamp to the review dates as in somecases without it 'on update CURRENT_TIMESTAMP' was being applied.
*Changed category name and description to be a database text field rather than varchar(255).
*Changed review image URLs to be a database text field rather than varchar(255).
*Fixed the comment email link.
*Fixed issues with PHP 4.
*Fixed superfluous spaces in review character filter.
*Fixed Tag table not deleted.
*Fixed Admin Pagination.
*Fixed Comment form float clearing.
*Fixed review form text inputs being too small.
*Fixed review title quote escaping while editing .
*Removed Category configuaration options (now done via templates in 'www\administrator\components\com_simple_review\admin\addons\modules\Category_Module\templates\Front\'):
-Show Title 1
-Show Title 2
-Show Title 3
-Show Rating
-Show Reviewer
-Show Date
-Title 2 is External Url
-Title 3 is External Url
-Title 2 is Review Link
-Title 3 is Review Link

Update SQL:

UTF8:

ALTER TABLE  `jos_simplereview_review` CHANGE  `createdDate`  `createdDate` TIMESTAMP NOT NULL DEFAULT  '0000-00-00 00:00:00',
CHANGE  `lastModifiedDate`  `lastModifiedDate` TIMESTAMP NOT NULL DEFAULT  '0000-00-00 00:00:00';

ALTER TABLE  `jos_simplereview_review` ADD  `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER  `score`;

UPDATE `jos_simplereview_review` SET pageName = '' WHERE pageName IS NULL;
UPDATE `jos_simplereview_category` SET pageName = name WHERE pageName IS NULL;
UPDATE `jos_simplereview_review` SET name = pageName;

ALTER TABLE  `jos_simplereview_review` CHANGE  `name`  `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
CHANGE `pageName` `pageName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 
CHANGE `imageURL` `imageURL` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci default NULL,
CHANGE `thumbnailURL` `thumbnailURL` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci default NULL;

ALTER TABLE  `jos_simplereview_category` CHANGE  `pageName` `pageName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 
CHANGE `name` `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 
CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
ADD  `categoryTemplateName` VARCHAR( 255 ) CHARACTER SET ASCII COLLATE ascii_general_ci NOT NULL DEFAULT  'Default' AFTER  `templateID`;


Default collation:

ALTER TABLE  `jos_simplereview_review` CHANGE  `createdDate`  `createdDate` TIMESTAMP NOT NULL DEFAULT  '0000-00-00 00:00:00',
CHANGE  `lastModifiedDate`  `lastModifiedDate` TIMESTAMP NOT NULL DEFAULT  '0000-00-00 00:00:00';


ALTER TABLE  `jos_simplereview_review` ADD  `name` TEXT NULL DEFAULT '' AFTER  `score`;

UPDATE `jos_simplereview_review` SET pageName = '' WHERE pageName IS NULL;
UPDATE `jos_simplereview_category` SET pageName = name WHERE pageName IS NULL;
UPDATE `jos_simplereview_review` SET name = pageName;

ALTER TABLE  `jos_simplereview_review` CHANGE  `name`  `name` TEXT NOT NULL , 
CHANGE `pageName` `pageName` TEXT NOT NULL, 
CHANGE `imageURL` `imageURL` TEXT default NULL,
CHANGE `thumbnailURL` `thumbnailURL` TEXT default NULL;

ALTER TABLE  `jos_simplereview_category` CHANGE  `pageName` `pageName` TEXT NOT NULL, 
CHANGE `name` `name` TEXT NOT NULL, 
CHANGE `description` `description` TEXT NOT NULL default '',
ADD  `categoryTemplateName` VARCHAR( 255 ) NOT NULL DEFAULT  'Default' AFTER  `templateID`;


What's new in 2.1.0 RC1
-----------------
*Fixed: Closed an open DIV in category layout.
*Fixed: Removed nested forms in category layout.
*Fixed: Bug when posting a comment while logged in.
*Fixed: Deleting and editing comments.
*Added: Can now change the reviews author.

Update SQL:
CREATE TABLE  jos_simplereview_tag (
`tagID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`tag` VARCHAR( 255 ) NOT NULL ,
UNIQUE (`tag`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;

What's new in 2.1.0 Beta 2
-----------------
*Fixed configuration layout in Internet Explorer
*Fixed error after saving configuration
*If a review has a type or Link or Rating it will be rendered as a link or star rating (if star ratings are on) when using {sr_title1},..,{sr_titleN}

Known Issues:
*The review titles are not rendered on the category page.
*When Single Category Bypass is on 'Top N' do not get displayed. 

Update SQL:
ALTER TABLE  `jos_simplereview_review_title` 
ADD  `titleSetup` TEXT NULL DEFAULT NULL;

What's new in 2.1.0 Beta 1
-----------------
*Review blurb can be greater than 400 characters.
*Can no longer submit a review with the rating greater than the max allowed rating.
*Pass by reference PHP error in Addon_Base.php.
*Can no longer add a category with the parent category set to itself.
*Titles now have a types Link, Rating and Text.
*Titles can now be marked as mandatory
*jQuery is now a requirement (currently included via google)
*Categories have a new field 'Page Name' which can be used in the Url, it can contain non-ascii characters but this is not recommend as they will be Url encoded.
*Fixed bug where you could not create categories if legacy mode was enabled.
*Joomla 1.0.X is no longer supported.
*Internet Explorer 6 is no longer supported.

Known Issues:
*The configuration page layout is 'messed' up in Internet Explorer, please use Firefox or Chrome if it bothers you.
*When Single Category Bypass is on 'Top N' do not get displayed. 

Update SQL:
ALTER TABLE  `jos_simplereview_category` ADD  `pageName` TEXT NULL DEFAULT NULL AFTER  `catOrder`;
ALTER TABLE  `jos_simplereview_review` ADD  `pageName` TEXT NULL DEFAULT NULL AFTER  `score`;

ALTER TABLE  `jos_simplereview_category_title` 
ADD  `titleType` ENUM( 'Text', 'Link', 'Rating', 'List', 'Option', 'Selection' ) NULL DEFAULT  'Text',
ADD  `titleSetup` TEXT NULL DEFAULT NULL,
ADD  `mandatory` TINYINT( 1 ) NOT NULL;

What's new in 2.1.0 Alpha 2
-----------------
*Languages have been cleaned up and moved into:
www\administrator\components\com_simple_review\addons\modules\Language_Module\languages\
Note that at the moment the language cannot be changed from en-GB, you are free to modify en-GB to test.

*The category layout has been moved into a separate file:
www\administrator\components\com_simple_review\addons\modules\Category_Module\templates\Default
Note that at the moment the template cannot be changed from Default, you are free to modify Default to test.

*Works on PHP 4
*Created By and Last Modified By are now being saved (broken in Alpha 1)
*{sr_categoryID} tag now works
*Can now submit a comment with rating 0
*Non-ASCII titles in URLs are now handled correctly i.e. non-ASCII character removed, temporary solution a new field will be added for the Url.
*Extra dashes in URLs have been removed
*The administration review listing now has a category filter.
*Provide alternating star image in review listing.


What's new in 2.1.0 Alpha 1
-----------------
Native Joomla 1.5


What's new in 2.0:
-----------------

Almost a complete re-write.
Much more structured and most things are now a module or plugin.
More and easily customizable.

Uses Joomla pathway

**Fix bug where non published user reviews are in cat count


What's new in 1.3:
-----------------

*Links are now more search engine friendly eg:
http://sardless.com/component/option,com_simple_review/review,7-Kool-Keith-TOMC3-Project-Polaroid/Itemid,26/

you old links will still work

*You can now limit users to comment per review.

*If multiple comments are allowed then they can only add a rating to their first comment.

*Can ban ips for comments

*Comments avatars have been fixed

*You can now have an email sent when a comment is added

*User reviews can now be limited. 
In limited/Force User Review Template you can specify what html is allowed.
Simple tags cannot be used.
The review will be forced to match your template.

*You can now set permission levels to be able to add a review.

*You can now set permission levels to have a user review automatically published

*The config screen has been re-worked

*Categories can now have a description

*Categories now have a sort order

*Listing of categories can optionally show a count of reviews - does not include sub categories

*In the review listing the sorting has been replaced with a javascript sort instead of a page refresh

*Reviews now have an apply button.
So you can now save a review without leaving the edit page.

*Reviews dynamic fields addition has been much improved.

*When adding a review it now shows the categories names for the titles instead of just showing title1, title2 and title3

*various minor bug fixes


Know issues:
security images doesn't work in mambo 4.5.3, earlier versions work fine and so does joomla


What's new in 1.2:
-----------------

If you don't add a rating to a user comment then you get a javascript alert instead of a SQL error.

When entering a new review the template is now loaded without having to change categories.

Top N review layout is now easily customised in the admin backend.

User comments have a new look (old style still available, just turn it on in the config page)

Mouseovers can now be turned off.

Use Dummy URLs e.g the review titles will go in the URL for the review, this can help with SEO as well as making the links easier to understand.

The review details go in the browsers title

If there is only 1 top level category then it just list its reviews and sub categories

Each category can have its own image

user reivews can only be submitted to categories with user reviews enabled

The majority of the application is now internationalized.

Can now decide if you want to display usernames or full names for submitted items.

Dynamic fields have now been added seperate the using ||.

It now passes the ItemID in all links so modules will display correctly.

New Tags:
*{sr_reviewURL} - for the URL of the review

*{sr_userReview} - Force user reviews to stick to template 

*{sr_dynamic_title_1} ... {sr_dynamic_title_9} - Titles (category section) for dynamic fields

*{sr_dynamic_1} ... {sr_dynamic_9} - Dynamic fields for reviews