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 tomshawk

Forgive my ignorance, again

This hidden form field

Is this done in the Custom form field?
If it is, I do not see a hidden option
and I assume the title does not matter.

What will this do to the Thread creating title.
right now, it says 5 out of 5 rating for (Product title)

I'd rather it just say Rev: (Product Title)

No, you would be adding it to the HTML code (the field name is "rating").

Remove:

<div class="blockrow">
                                <label for="rating">{vb:phrase prodforums_writeitrating} <span style="color:red;">*</span></label>
                                <select name="rating">
                                    <option value="">--- {vb:phrase prodforums_select} ---</option>
                                    <option value="1">1 {vb:phrase prodforums_star}</option>
                                    <option value="2">2 {vb:phrase prodforums_stars}</option>
                                    <option value="3">3 {vb:phrase prodforums_stars}</option>
                                    <option value="4">4 {vb:phrase prodforums_stars}</option>
                                    <option value="5">5 {vb:phrase prodforums_stars}</option>
                                </select>
                            </div>

Add

<input type="hidden" name="rating" value="1" />

http://www.w3schools.com/tags/att_input_type.asp

The thread title is set from the phrase prodforums_reviewtitle. {2} is the title, the rest can be removed.

[tomshawk]

Thank you, that hidden code eliminates the need for rating.

But, now, the product details page does not count the review, it still says would you like to be first to review.

Also, still just a huge wall of text though, with bbcode and html enabled on the forums as well as the usergroup

The title fix worked perfectly, thank you

[tomshawk]

I figured I would try something

If I copy the review before submitting, then edit the review and paste it in after I submit, it looks fine

If I re-write the review but add in the line break manually with

<br>

It posts but double-spaced lines.

Very wierd

[Ted S]

Originally Posted by tomshawk

Thank you, that hidden code eliminates the need for rating.

But, now, the product details page does not count the review, it still says would you like to be first to review.

Also, still just a huge wall of text though, with bbcode and html enabled on the forums as well as the usergroup

The title fix worked perfectly, thank you

Does this bug continue if you write a second review? Any errors with the posting process along the way?

Will dig in to the breaktags more tomorrow or monday.

[tomshawk]

Yes, subsequent reviews do the same thing.

Turns reviews into a wall of text and the review counter does not multiply

[Ted S]

Originally Posted by tomshawk

Turns reviews into a wall of text and the review counter does not multiply

Hrm, if you look in the table pf_product (via phpmyadmin, mysql or just through your vbulletin query manager), do you see any value on that thread id?

SELECT * FROM pf_product WHERE threadid = X;

(add prefixes before pf_product if used).

[Ted S]

Originally Posted by tomshawk

Yes, subsequent reviews do the same thing.

This is not going to be fun as I can't replicate so I apologize but I'm going to have to try making changes and have you try them out. Try this version of the addon to start.

REPLACE IT WITH THE CURRENT ACTIVE VERSION AFTER YOU HAVE TESTED, IT WILL SHOW DEBUG CONTENT.

[tomshawk]

Originally Posted by Ted S

Hrm, if you look in the table pf_product (via phpmyadmin, mysql or just through your vbulletin query manager), do you see any value on that thread id?

SELECT * FROM pf_product WHERE threadid = X;

(add prefixes before pf_product if used).

Strange, it is giving error 1146
Table does not exist.

That new productforums.php just gives me a blank white screen when I try to go to it.

Don't apologize, I realize this addon was made quite a while ago and for a different version of vBulletin.

I truly appreciate all the help.

[Ted S]

Originally Posted by tomshawk

Strange, it is giving error 1146
Table does not exist.

Do you use table prefixes? if so, you need to include them into the query.

[tomshawk]

I went into repair optimize tables as I did not think he used a prefix but I found

vb422pf_product

so ran the query again

SELECT * FROM vb422pf_product WHERE threadid = X
this time I get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'X' in 'where clause'

Then just for giggles I ran this thinking there needed to be a . between the prefix and the table name

SELECT * FROM vb422.pf_product WHERE threadid = X;

and got this error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1142
error desc: SELECT command denied to user 'tomwayne_vb422'@'localhost' for table 'pf_product'