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

I'm curious, in the 3rd pic on the OP. The list of products?

How easy would it be to modify this.

I'd like to see
my books image
the name
the rating
the price,
and a link to the description page
but in 3 or 4 columns across

I think it would take up less space and make room for more products on a page.

It's all displayed via a template so, assuming you don't want to add any fields, editing is as quick as you can change the html and corresponding css.

[tomshawk]

Thank you but as a novice changing html and CSS is not my fortay

Could you assist with this?

Also,

I have a few more questions as well if you do not mind

What if I want to add fields for the reviews in pic 1 and 2, for example, a field in my books for reading level, or amount of pages in a book.

Also, is there a way to add more images to the product profile like you see on ebay for example?

Thank you in advance for the outstanding addon BTW

[tomshawk]

Originally Posted by Ted S

Are you comfortable editing php? If so, try removing the ,1 from line 416 of the script.

If not, tell me about your server... is it using Apache? Shared or dedicated host? Does the review still post?

I installed this onto a friends site and I get this same error.
I removed the ,1 and the error remains.
The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it in the admincp I get this error

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

This is a vbulletin 4.2.2 PL4 fresh install

Any help would be great, thank you

[tomshawk]

Anybody have an idea?

This mod works perfectly on vb 4.0.0 but gives the error above in 4.2.2 PL4

Sorry if I seem impatient but I told my friend about how good it is and well.

Thanks in advance

[Ted S]

Originally Posted by tomshawk

Thank you but as a novice changing html and CSS is not my fortay

There's a forum here for coding support discussions that may be a good place to try.

What if I want to add fields for the reviews in pic 1 and 2, for example, a field in my books for reading level, or amount of pages in a book.

The addon supports custom fields but it's pretty basic. You can't change them by category for example but they will allow this sort if info. They're in the admin settings.

Also, is there a way to add more images to the product profile like you see on ebay for example?

You can use bbcode or basic html to embed them if they're already posted somewhere (which works depends on your forum settings).

[Ted S]

Originally Posted by tomshawk

I installed this onto a friends site and I get this same error.
I removed the ,1 and the error remains.
The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it in the admincp I get this error

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

This is a vbulletin 4.2.2 PL4 fresh install

Any help would be great, thank you

The problem is that the value being posted is negative. Sounds like the counter didn't go up properly and needs to be reset to 1 if the content is still there to delete or 0 if it's been cleared.

You'll have to excuse me but I don't recall the exact details anymore and didn't see what you quoted from in the last few pages of the thread?

[tomshawk]

Thank you Ted, I was able to figure out the custom fields option while playing on my site. I have not customized my friends yet but I know where to start.

I will ask about the HTML changes on the other forum.

The error I am reffereing to is

Writing a review causes
Warning: Only variables should be assigned by reference in ..../productforums.php (line 416)

You suggested this

Are you comfortable editing php? If so, try removing the ,1 from line 416 of the script.

The server is running apache

The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it I get this error

Removing the ,1 from that line did not fix the problem.

I am also getting this

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

when trying to delete the review.

This is vbulletin 4.2.2 PL4 where mine is 4.0.0thank you again for your support on this awesome addon, it is greatly appreciated

[tomshawk]

OK, this problem seems to be related to the socialpages problem with vbulletin 4.2.2
I found it as I noticed I got another error when just trying to use advanced search function in VB on this new site, as soon as I patched that error, this one went away.

So, now the only problem I have now is the truncating of the review into a long wall of text instead of paragraphs and lines as it should be.

Not to drive you up the wall but, as part of my customization, I want to remove the start rating system

I have removed it for all the pages via templates except the review creation screen.
If I remove it from there, I cant not create a review as I did not add a rating.

How do I remove it as a requirement?

Thank you

[Ted S]

Originally Posted by tomshawk

So, now the only problem I have now is the truncating of the review into a long wall of text instead of paragraphs and lines as it should be.

Do you allow HTML or BBCode on the forum reviews post to? Can you try toggling both on / off to see if it helps?

How do I remove it as a requirement?

Remove it from the template and add a hidden form field with a value of 1 in its place. This way it gets past along for the script to check and the database to insert though you won't show it back anywhere.

[tomshawk]

Originally Posted by Ted S

Do you allow HTML or BBCode on the forum reviews post to? Can you try toggling both on / off to see if it helps?

Remove it from the template and add a hidden form field with a value of 1 in its place. This way it gets past along for the script to check and the database to insert though you won't show it back anywhere.

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)