Major Additions - Product Review Forums ? Research, Review & Compare Items

Version 1.4.0 has been released to remove the giftery / list it integration of the addon now that service has been discontinued. No upgrade is needed though there have been a few other bug changes since 1.3.5.

Finding Feedback Can be Like a Needle in a Haystack

The more your forum grows, the more of a challenge it becomes to sort through the history and get the full story.

Product Review Forums Brings Structure to the Chaos

As a full-featured product management addon, PRF sits on top of your forum allowing you to create defined products which, unlike individual posts, stay relevant over time. Each comment, review and even product updates filter back into this one spot allowing for a quick and comprehensive overview while the individual discussions rage on as always.

Here's just a few of the many features you'll find in PRF:

• Bring structure to products with established pages & reviews
• Reduce the number of repetitive posts from members looking up the same info
• Increase your traffic with content-rich, seo friendly, product listings
• Drive revenue by adding your own affiliate links to product listings
• Increase the activity stream's value with review integration
  
• Engage visitors with integrated wishlists from Giftery.me

===========================

Installation is not upload & go... individualized settings are required. Read the install file.

===========================
QUICK TIPS:
===========================

Enabling Product Forums: To show product details and ratings, each product-forum must be enabled in the forum manager.

Adding Products: You may upload products one at a time through the admin [includes an image uploader using GD] or you can bulk import through XML. You can also enable users to add moderated products through a global and usergroup option.

Product Review Index: To access your forum's product overview go to www.yoursite.com/productforums.php - You may want to add a link to this to your navbar or as a tab.

Customization: This addon is made to be customized. To change the color schema see clientscript/vbulletin_css or dive right on in to the templates and phrases.

Powered by Giftery.me: This mod is maintained includes two integrations you should know about. Both can be controlled through the mod options.

[ProFifaLeagues]

Just an update and thanks,Ted we have been using the last couple of versions you have released and the members we have love it and feel its something we have missed for a while,Top Work and many thanks Sir

[Ramsesx]

If moving over the thread title in forumdisplay view it shows "This is an empty post".
Wouldn't it be an advantage to have the Full Description field added in the post field instead assign a new db field like pf_product?
Because if you have a lot of products and disable/uninstall the plugin you will lose all product descriptions.

[Ted S]

Originally Posted by Ramsesx

If moving over the thread title in forumdisplay view it shows "This is an empty post".
Wouldn't it be an advantage to have the Full Description field added in the post field instead assign a new db field like pf_product?
Because if you have a lot of products and disable/uninstall the plugin you will lose all product descriptions.

I'll have to find away around that tip...

The issue with making posts rather than using a table is that you lose the structure. Rather than having a price field you can edit, you have a price line in a string. Parsing all this apart is not ideal and updating it [either for new reviews or changes to products] becomes a poor experience.

[CharlieDelta]

I think this may be of great use for my forums but was wondering if there is a demo that I could look at.

[Ted S]

Originally Posted by CharlieDelta

I think this may be of great use for my forums but was wondering if there is a demo that I could look at.

Just the screenshots.

For obvious reasons few forums want people to demo on their active sites as it disrupts "real" data.

[CharlieDelta]

Originally Posted by Ted S

Just the screenshots.

For obvious reasons few forums want people to demo on their active sites as it disrupts "real" data.

Understood. Thanks Ted.

[jshallo]

Hi Ted, Any time line on a new release?

[Ted S]

Originally Posted by jshallo

Hi Ted, Any time line on a new release?

Looks like the next feature release will be early October.

[Ted S]

PRF users -

I'm pulling together the requirements for the next major update of the mod and while there's already a lot, I want to be sure I've captured what's most important.

Please review the list at https://vborg.vbsupport.ru/showpost....38&postcount=4 and chime in with any other comments you may have

[Da-Vinci]

Hi Ted, I didn't have the product enabled in the forums, guess I missed that, DOH!!!

But when I try to enable it I get this Database error.

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE forum SET
	title_clean = 'General',
	title = 'General',
	description_clean = '',
	description = '',
	link = '',
	displayorder = 1,
	parentid = 29,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options, options + 8192),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
		options = IF(options & 131072, options - 131072, options),
	styleid = 0,
	imageprefix = '',
	password = '',
	forumiconimg = 'cartman.png',
	forumiconimg_forum_height = '50',
	forumiconimg_forum_width = '50',
	default_tags = '',
	productforumsbits = '1',
	default_tags_ids = ''
WHERE forumid = 34;

MySQL Error   : Unknown column 'productforumsbits' in 'field list'
Error Number  : 1054
Request Date  : Saturday, September 24th 2011 @ 12:49:55 AM
Error Date    : Saturday, September 24th 2011 @ 12:49:56 AM
Script        : http://www.cameraguru.co.uk/admincp/forum.php?do=update
Referrer      : http://www.cameraguru.co.uk/admincp/forum.php?do=edit&f=34
IP Address    : 78.144.36.145
Username      : Pablo
Classname     : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11

If I try to select Manage Products & Reviews I get this Database error.

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT COUNT(productid) AS count FROM pf_product;

MySQL Error   : Table 'cameraguru.pf_product' doesn't exist
Error Number  : 1146
Request Date  : Saturday, September 24th 2011 @ 12:57:07 AM
Error Date    : Saturday, September 24th 2011 @ 12:57:07 AM
Script        : http://www.cameraguru.co.uk/admincp/productforums.php?do=productforums
Referrer      : http://www.cameraguru.co.uk/admincp/index.php?do=nav
IP Address    : 78.144.36.145
Username      : Pablo
Classname     : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11

And if I try to uninstall the product I get this.

Database error in vBulletin 4.1.5:

Invalid SQL:
DROP TABLE `pf_product`;

MySQL Error   : Unknown table 'pf_product'
Error Number  : 1051
Request Date  : Saturday, September 24th 2011 @ 12:58:57 AM
Error Date    : Saturday, September 24th 2011 @ 12:58:58 AM
Script        : http://www.cameraguru.co.uk/admincp/plugin.php?do=productkill
Referrer      : http://www.cameraguru.co.uk/admincp/plugin.php?do=productdelete&productid=product_forums&s=
IP Address    : 78.144.36.145
Username      : Pablo
Classname     : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.11

Obviously I'm missing the table pf_product but how do I add that table to my database?

I've tried overwriting the product but it hasn't helped.