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.

[Kirk Fitzgerald]

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

[Ted S]

Originally Posted by Kirk Fitzgerald

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

[Kirk Fitzgerald]

Originally Posted by Ted S

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT threadid FROM thread WHERE title = 'Dr Plumb 9mm Absorbent Carbon smoking Pipe Filters 10's';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 1
Error Number : 1064
Request Date : Sunday, July 22nd 2012 @ 01:35:11 AM
Error Date : Sunday, July 22nd 2012 @ 01:35:12 AM
Script : http://www.pipesmokerscubby.com/admi....php?do=do_xml
Referrer : http://www.pipesmokerscubby.com/admi...ums.php?do=xml
IP Address : 86.130.60.119
Username : Kirk Fitzgerald
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Any ideas on this Ted?

[Ted S]

Originally Posted by Kirk Fitzgerald

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:


Any ideas on this Ted?

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

[Kirk Fitzgerald]

Originally Posted by Ted S

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

Perfect, thanks Ted

[Kirk Fitzgerald]

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

[Ted S]

Originally Posted by Kirk Fitzgerald

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

[Kirk Fitzgerald]

Originally Posted by Ted S

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

Okay, had to revert some templates, huge changes in some templates then, the files don't even compare in winmerge, they are too different now, will have to figure out my changes again, no biggie I guess, just annoying.

Thanks for your help Ted, much appreciated. ):

[Kirk Fitzgerald]

Little addition for anyone wanting it in the forumdisplay for your products, to add the +add new product button to be at the top of the thread listing as well as the bottom, do the following:

Open FORUMDISPLAY

FIND:

<div id="above_threadlist" class="above_threadlist">

BELOW ADD:

<vb:if condition="$show['newproduct']">
	<a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>
</vb:if>

Perhaps something you could add in future release Ted, not essential as easy enough to hack.

[Ted S]

Originally Posted by Kirk Fitzgerald

Little addition for anyone wanting it in the forumdisplay for your products, to add the +add new product button to be at the top of the thread listing as well as the bottom, do the following:

Open FORUMDISPLAY

FIND:

<div id="above_threadlist" class="above_threadlist">

BELOW ADD:

<vb:if condition="$show['newproduct']">
    <a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>
</vb:if>

Perhaps something you could add in future release Ted, not essential as easy enough to hack.

There's no hook to add it there or we would have