Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features)

Note: While this modification is updated for compatibility, I am only developing features for the 4.x version. I understand many sites continue to use 3.8 for a variety of reasons but dual developing takes time away from adding anything new. I encourage you to develop out your own change and share them back as no modification is ideal for every forum out of the box.

Every day your users contribute hundreds if not thousands of posts making it hard for new members and guests to separate out the best answers from those that are less helpful. The Helpful Answers System offers your members a quick way (AJAX) to rate individual posts as either helpful or not allowing future visitors to understand the benefits of each post.

Designed for maximum flexibility:


This addon is built to be flexible and offers several customization options including:

• The ability to show a user's vote stats in posts
• The ability to use image or text ratings.
• The ability to offer yes/no or scaled 1-10 point ranking.
• The ability to turn off negative ratings for a positive only system.
• The ability to decide which forums are open for helpful answer ratings.
• The ability to audit the system and identify top users and potential abusers.
• The ability to ban specific members from using the system.
• The ability to customize the AJAX message shown after a post is rated.
• The ability to edit all text and messages through phrases.
• The ability to show a page with the top helpful posts.
• The ability to show rating stats on a user's profile.
• Integration with the reputation system for ratings.
• Template driven display that can easily be customized to your forum.

For advanced users template conditionals and variables let you further extend the functionality to color highlight good or bad posts, include ratings in user?s profiles and much more.

Load & Scale:
This addon is designed to work with small to large sites and is currently being used by sites with more than 2 million posts. If you have questions about integrating with your big board please contact me.

Modification Installation:
This addon requires uploading multiple files, installing a vBulletin product and enabling the feature in any forums you wish. No template modifications are required. Please see the included install file for detailed instructions.

If you are not seeing the rating bar double check that you have enabled the feature in the forum you are in and insure the Manual Template override option is not enabled.

Rating Review & Deletion:
To identify and remove abuse a reporting system is included with this addon and can be found in your vBulletin ACP under the Helpful Answers tab. Through this panel you will be able to view a user's overall rating history and individual ratings and can remove either if necessary. Users can also be explicitly banned from the system.

Reputation System Integration:
Helpful Answers can be extended to directly tie into your reputation system giving users positive or negative points based on the ratings of their posts. There are numerous options on how to handle ratings that can be found in a separate Helpful Answers Reputation part of your vBulletin Settings page.

External Integration:
vB Plaza Modification - http://www.vbplaza.com/forum/showthread.php?p=6359
vB Experience - https://vborg.vbsupport.ru/showthread.php?t=199556

Anonymous Stats Tracking (optional):
vBulletin forums reach millions of consumers around the world yet little is known about their habits and opinions. This addon was released to the public out of requests but also to further the research of forum user's behaviors and actions through collecting the most basic data on thousands of sites.

By default this addon will pass basic rating data (positive or negative) to a 3rd party site for statistical purposes. Only the most basic data is captured (the vote and your site name) and no user information or specific forum details are logged, not even an IP address.

While you may disable this feature through the administrative options I ask that you consider leaving it in place to help this research effort and insure the continued support of the addon.

The tracking feature uses the php library cURL on a 5 second timeout. If cURL is not installed this option is automatically disabled.

Updates:
- 5/13/2011 - Release of 2.0.6 minor bug fix
- 08/31/2009 - Release of 2.0.0
- 08/07/2009 - Release of 1.9.5 stable

Other Versions:
This addon will work with 3.7 but to avoid issues with different code versions please see the 3.7 version thread here.

Before you download this modification please remember this is a free tool provided as a courtesy to you and support responses are subject to the availability of the author and other members. If you are looking for a professionally supported system this is not the solution for you.

[tpearl5]

Originally Posted by Quantnet.org

Interestingly enough, the Answer Forum mod is released today
https://vborg.vbsupport.ru/showthread.php?t=218653

This has been released for a while, the developer just made a 3.8 thread for it. Also, this style looks a lot more like how community server handles best answers but without the per thread "is this a question" option.

[tpearl5]

Originally Posted by Ted S

Shouldn't be a problem.

Ok with entering a username and date range and getting a result?

If it was the same as the existing posts rated report, that would probably be more useful - that way you can see in a list who is on top for a given period of time. Could you make it so you can also see the post that is rated? (like in the other report)

[Ted S]

Let me look at the data structure a bit and see what I can do.

[Ted S]

Originally Posted by cooltechie

Can I leave the mod running along with "thanks" mod and then run the import at a later time or does the import need to run immediately after the install? Hope to see a working import soon so I can get it combined. Thanks for creating this mod and for your support.

Yes you can. You could run them both forever... there's no damage.

[Ted S]

After more testing and some changes I have updated 1.9. This file remains in beta until additional sites start using it but at this time it is working in live environments without problem.

Overview of changes:
- Rating a post now adds a notification to the user whose post it is
- The top rated post can be automatically linked to after the first post
- Specific threads can be excluded or included via the admin

Installing will take a few minutes as all voting records are updated in the database.

[NLP-er]

Originally Posted by Ted S

The feature list is a few page back... somewhere.

We're not a whole lot closer as no one has picked up the beta and commented on it which makes it difficult for me to release as a stable. I will be doing more of my own tests to try and move things along.

Just release it as not beta and you will have plenty of installs
Microsoft never cares LOL

[Noctavia]

Originally Posted by Ted S

Looks like I gave you bad guidance... You need to leave 2="$post[totalrank]"

Cool, thanks, got it working now. :up:

Another question. When I try to find all ratings given to a single thread, I get the following error:

Database error in vBulletin 3.8.2:

Invalid SQL:

		SELECT COUNT(helpfulanswerid) AS count
		FROM helpfulanswer AS helpfulanswer
		INNER JOIN user AS user ON(helpfulanswer.userid = user.userid)
		WHERE helpfulanswer.helpfulanswerid <> 0
			 AND helpfulanswer.postid =  
			 AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 1247725500
		GROUP BY helpfulanswer.userid;

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 'AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 124772550' at line 6
Error Number  : 1064
Request Date  : Thursday, July 16th 2009 @ 02:26:25 AM
Error Date    : Thursday, July 16th 2009 @ 02:26:25 AM
Script        : http://xxxxxx/forums/admincp/helpfulanswers.php?do=show_helpfulanswers
Referrer      : http://xxxxxxx/forums/admincp/helpfulanswers.php
IP Address    : xxxxxxxxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.81-community

Any idea on how to fix that? I can use all the other reporting features fine. This only happens when I use the Post ID section.

[Saviour]

Ted S...

I really don't have a test forum, otherwise I'd volunteer to test the beta version. Sorry...

Until then, I'll just have to wait to update the mod until your latest release does become stable.

All my best...

[Ted S]

Originally Posted by NLP-er

Just release it as not beta and you will have plenty of installs
Microsoft never cares LOL

After another week of my sites using it I probably will. While MS does release betas as finals it's not worth the support headache for me to do so.

[Ted S]

Originally Posted by Noctavia

Cool, thanks, got it working now. :up:

Another question. When I try to find all ratings given to a single thread, I get the following error:

Database error in vBulletin 3.8.2:
 
Invalid SQL:
 
        SELECT COUNT(helpfulanswerid) AS count
        FROM helpfulanswer AS helpfulanswer
        INNER JOIN user AS user ON(helpfulanswer.userid = user.userid)
        WHERE helpfulanswer.helpfulanswerid <> 0
             AND helpfulanswer.postid =  
             AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 1247725500
        GROUP BY helpfulanswer.userid;
 
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 'AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 124772550' at line 6
Error Number  : 1064
Request Date  : Thursday, July 16th 2009 @ 02:26:25 AM
Error Date    : Thursday, July 16th 2009 @ 02:26:25 AM
Script        : http://xxxxxx/forums/admincp/helpfulanswers.php?do=show_helpfulanswers
Referrer      : http://xxxxxxx/forums/admincp/helpfulanswers.php
IP Address    : xxxxxxxxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.81-community

Any idea on how to fix that? I can use all the other reporting features fine. This only happens when I use the Post ID section.

Looks like a little bug. I will get a release out tonight with a fix.