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]

Hi there again Ted,

is there a way for me to add the reviewers name and profile link in the reviews?

I've been trying to figure it out myself but, well, let's just say I am no coder.

[Ted S]

Originally Posted by Kirk Fitzgerald

Hi there again Ted,

is there a way for me to add the reviewers name and profile link in the reviews?

I've been trying to figure it out myself but, well, let's just say I am no coder.

I'm not sure what you mean? Reviews are created under as a post / thread that's from the user posting them. Why would you need to add a review as an admin?

[Kirk Fitzgerald]

Originally Posted by Ted S

I'm not sure what you mean? Reviews are created under as a post / thread that's from the user posting them. Why would you need to add a review as an admin?

Sorry, my fault, I didn't explain myself clearly.

If you look here you will see a review on my site:
http://www.pipesmokerscubby.com/show...arson-Pleasure

That is a review made by a member, I would like the members name in the main review entry like this:
Attachment 139579

It's just a personal touch I should like, it's no big thing if it is awkward, I can live without it of course, sorry to be such a drag.

[Ted S]

Originally Posted by Kirk Fitzgerald

Sorry, my fault, I didn't explain myself clearly.

If you look here you will see a review on my site:
http://www.pipesmokerscubby.com/show...arson-Pleasure

That is a review made by a member, I would like the members name in the main review entry like this:
Attachment 139579

It's just a personal touch I should like, it's no big thing if it is awkward, I can live without it of course, sorry to be such a drag.

Your screenshot isn't of a review, it's of a product which can be reviewed. The concept is to have a parent product and multiple reviews for it so it's easy to understand items overall...

That said, the user who creates the product is stored in the db so you can quickly hack the template to add this in.

[Kirk Fitzgerald]

Again, sorry, my fault for not being clear, had a very long day and was very tired, sorry about that.

So editing the template is a work around, that is great news and sounds very promising, but like I mentioned, I am no coder and can't figure out how to get the data.

I have created a language phrase so have the text "Listing Created By: " showing but I can't figure out what to use to pull in the users name.

I am using this:

					<div id="pf_createdby">
						{vb:phrase prodforums_creator,{vb:raw product.createdby}}
					</div><br />

I looked in the database and figured the field I need to call is createdby, either that is wrong or I have missed something, would you be so kind as to help me out here please, can you tell me what I need to use, it would be wonderfully helpful, if you don't mind too much.

Thanks, Kirk.

[Ted S]

Originally Posted by Kirk Fitzgerald

Again, sorry, my fault for not being clear, had a very long day and was very tired, sorry about that.

So editing the template is a work around, that is great news and sounds very promising, but like I mentioned, I am no coder and can't figure out how to get the data.

I have created a language phrase so have the text "Listing Created By: " showing but I can't figure out what to use to pull in the users name.

I am using this:

                    <div id="pf_createdby">
                        {vb:phrase prodforums_creator,{vb:raw product.createdby}}
                    </div><br />

I looked in the database and figured the field I need to call is createdby, either that is wrong or I have missed something, would you be so kind as to help me out here please, can you tell me what I need to use, it would be wonderfully helpful, if you don't mind too much.

Thanks, Kirk.

Your code isn't all that bad -- you'd need to be sure you have {1} for the variable but it's the variable where your issue is...

createdby a user id and to make a name show up you'll have to find the query that pulls in the product info and join the user table, add user.username and then change the variable to {vb:raw product.username}. If that sounds crazy, sorry.

[Kirk Fitzgerald]

Wow, that has totally gone straight over my head.

How do I find out about the query, how do I join user tables?

Sorry for being so dimwitted with all this.

[MySaltyreef]

i like it but i need something where my members can create their own product review in a given forum instead of me having to add it via the admin cp, are you working on something like this ?

[MySaltyreef]

Originally Posted by Kirk Fitzgerald

Wow, that has totally gone straight over my head.

How do I find out about the query, how do I join user tables?

Sorry for being so dimwitted with all this.

dude use google these guys don't have the time to sit and "teach" all information that you need has been explained already on one of the vb forums, otherwise try going to www.vbulletin.com for support

i'm in the same boat as you, info is hard to come by sand i don't know this stuff either i'm just a hobbyist with a forum so its harder for okes likes us

[Kirk Fitzgerald]

Originally Posted by MySaltyreef

i like it but i need something where my members can create their own product review in a given forum instead of me having to add it via the admin cp, are you working on something like this ?

There's a link in the review section to add a review that your members can use to submit listings.

I have already tried to do it myself by searching the net for info chap and have failed, which is why I am asking the one guy who will know how to do it properly. I have absolutely no idea what most sites are going on about when they talk about mysql queries, let alone translating it to search for something in my own database.