I may begin tackling adding on a way to calculate and display the top ranked products, unless you already have something like that in the works? I'm not 100% sure how to rank them yet, but I think it will need to be weighted against the total number of reviews and the score rather than just the score (ie. a product reviewed 10 times with a 4.9 rating would rank better than a product reviewed 1 time with a 5.0 rating) and also should take into consideration how recent the reviews are. I guess this would be sort of a "best of the most popular products" hack so to speak.

PRF users, there's a release level update out today marked as 1.3.5 [skipping .3 and .4 as those were posted as patches].

This is a bug fix designed to address issues with moderated posts, blank reviews [too short & duplicate content] review links and a few other details that impacted a few, but not all sites. If you do not have any of these issues you do not need to upgrade.

To update install the new plugin file and upload/productforums.php into your forum folder. There no other changed files.

Thanks to GCC LLC for tracking down the moderation issue too.

Also if anyone's interested, I added BMP support in the image resync functions. Some of the images at the remote URL from my XML feed were BMP and the image processing script at
includes/prodforums_uploader.php wouldn't process them. Here's the changes I made:

In the load() function, added:
elseif( $this->image_type == IMAGETYPE_BMP ) {

$this->image = imagecreatefromwbmp($filename);
return '.bmp';
}

In the save() function, added:
elseif( $image_type == IMAGETYPE_BMP ) {
$white = 0x00FFFFFF;
imagewbmp($this->image,$filename,$white);
}

(Note: I defined the color for white for processing bitmaps because in the imagewbmp() function, it defaults everything to a black alpha channel (background) - so you may want to adjust this to your own preferences)

In the output() function, added:
elseif( $image_type == IMAGETYPE_BMP ) {

imagewbmp($this->image);
}

Are you thinking of this in place of the current productforums.php index or as a standalone feature [say a widget for the widebar]?

mySQL isn't great for formulas on the fly as they add load time but if it's just rating sum & count it's pretty simple.... I'll play around with some queries when I return after next week.

Hate bmps and really should expand on this to convert them as well but this is very helpful. Thanks for the contribution, it will be rolled into 1.3.6

In our case we use the forum display and don't really send anyone directly to productforums.php, so I'd need to think outside the box a little on how/where to display it. More of an idea at the moment rather than anything.

Makes two of us, that's the reason I added that. Our XML feed was full of 300kb+ .BMP files that were being loaded on every page view. Hosting them locally, the JPGs are down to 12-15kb and page times are much faster for the end user.

Would a sidebar widget work? If not maybe a forum block above the threads with product photos [remember the old photopost integration?]

installing and testing latest and greatest!
thnx agian Ted S!