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.

[Ted S]

Originally Posted by deverill2010

Because I want them to show for the products just not the normal threads, within the forum.

Or have I completely missed something?

Thanks I'll try that other file tomorrow as on iPad now.

Any idea regarding the product titles in the activity stream?

Gotcha. Well, that's going to mean continuing to tweak the template but if you compare the default threadbit and the PRF version you can find the change easily.

We'll take a look at titles...

[ashimashi]

Is it possible so that other people could approve products as well? For example I would like my moderators to have access in approving products.

[Ted S]

Originally Posted by ashimashi

Is it possible so that other people could approve products as well? For example I would like my moderators to have access in approving products.

Not possible at this time...

[1320Nation]

Originally Posted by Ted S

Try this version.

I added the file to the forum root and the results are below. However, I reinstalled the other file back in the forum root and it still shows the same error below.

Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
pfp.productid,pfp.title,pfp.rating,pfp.reviews,pfp .price,pfp.threadid,pfp.short_desc,pfp.mainphoto_t humb,DATE_FORMAT(pfp.createddate,'%a %b %D, %Y') as posteddate,
pfc.categoryid,pfc.title as category

FROM vb_pf_product as pfp
LEFT JOIN vb_pf_category as pfc ON pfp.categoryid = pfc.categoryid
WHERE pfp.active = 1


ORDER BY pfp.title desc
LIMIT 0, 25;

MySQL Error : Unknown column 'pfp.mainphoto_thumb' in 'field list'

[Ted S]

Originally Posted by 1320Nation

I added the file to the forum root and the results are below. However, I reinstalled the other file back in the forum root and it still shows the same error below.

Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
pfp.productid,pfp.title,pfp.rating,pfp.reviews,pfp .price,pfp.threadid,pfp.short_desc,pfp.mainphoto_t humb,DATE_FORMAT(pfp.createddate,'%a %b %D, %Y') as posteddate,
pfc.categoryid,pfc.title as category

FROM vb_pf_product as pfp
LEFT JOIN vb_pf_category as pfc ON pfp.categoryid = pfc.categoryid
WHERE pfp.active = 1


ORDER BY pfp.title desc
LIMIT 0, 25;

MySQL Error : Unknown column 'pfp.mainphoto_thumb' in 'field list'

Looks like the upgrade script wasn't able to run.

You'll need to manually perform a few queries:

CREATE TABLE IF NOT EXISTS pf_options (
                        optionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                        title VARCHAR (75) NOT NULL DEFAULT '',
                        fieldtype TINYINT NOT NULL DEFAULT '1',
                        defaultval TINYINT NULL,
                        active TINYINT NOT NULL DEFAULT '1',
                        PRIMARY KEY (optionid),
                        KEY title (title)
                    )

CREATE TABLE IF NOT EXISTS pf_roptions (
                        addedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                        reviewid INT NOT NULL, 
                        optionid INT NOT NULL,
                        resposnse VARCHAR (75) NOT NULL DEFAULT '',
                        PRIMARY KEY (addedid),
                        KEY optionid (optionid),
                        KEY reviewid (reviewid)
                    )

INSERT INTO activitystreamtype SET packageid = 1, section = 'product', type = 'review', enabled = 1

ALTER TABLE `pf_product` ADD mainphoto_thumb VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD mainphoto_small VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD uploadimg TINYINT NOT NULL DEFAULT '0'

Be sure to add your table prefixes as needed.

[Andrei29]

Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/fishbook/public_html/productforums.php on line 588

I got this error when I click on "be the first to review"

Any idea?

[Andrei29]

its really a buggy mod zzz

[Ted S]

Originally Posted by Andrei29

Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/fishbook/public_html/productforums.php on line 588

I got this error when I click on "be the first to review"

Any idea?

Do you have the activity system installed on your forum?

[Ted S]

Originally Posted by Andrei29

its really a buggy mod zzz

I could argue that at length, show you a few of the hundreds of forums using it, and explain that the more complex a mod is, the more it has to be adapted to work with the nearly endless combination of forum settings out there but at the end of the day you should only use what you feel is right for your site.

If this isn't right for you, well, thanks for giving it a try. :up:

[GCC LLC]

Originally Posted by Andrei29

its really a buggy mod zzz

For the number of and complexity of the features it provides, I thought it was relatively low in terms of the number of bugs. Pair that on top of the fact that the author is very active in this form to help, and I think it ranks up there as one of the best I've seen here on vb.org.