Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
[AJAX] Helpful Answers - Post Rating System (plus many sub-features) Details »»
[AJAX] Helpful Answers - Post Rating System (plus many sub-features)
Version: 2.0.6, by Ted S Ted S is offline
Developer Last Online: Nov 2020 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.8.1 Rating:
Released: 02-02-2009 Last Update: 05-12-2011 Installs: 460
DB Changes Uses Plugins Auto-Templates
Additional Files  
No support by the author.

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.

Download Now

File Type: zip Helpful Answers 1.9.5.zip (36.5 KB, 398 views)
File Type: zip Helpful Answers 2.0.6.zip (39.4 KB, 617 views)

Screenshots

File Type: gif admin-stats1.gif (15.5 KB, 0 views)
File Type: gif admin-stats2.gif (11.3 KB, 0 views)
File Type: gif admin-stats3.gif (6.1 KB, 0 views)
File Type: gif topanswers.gif (19.6 KB, 0 views)
File Type: jpg settings.jpg (102.6 KB, 0 views)
File Type: gif rating-methods.gif (48.8 KB, 0 views)

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
5 благодарности(ей) от:
BGObsession, hsoen, JohorBahru, Simon Lloyd

Comments
  #912  
Old 07-22-2009, 11:03 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by The Smoking Gun View Post
Yes I understand that where my next forum is concerned but my currently running forum of over two years, will also be getting this mod, and thank you hack has been installed, although the import lost those from the other BB software I got so frustrated with and ended up upgrading to this, so there are not a whole lot of thanks to consider but there may be by the time you release the new stable version since you do not wish for me to be a tester of it, which is probably better for my limited php skill level!

Thanks none the less though, we all appreciate all your hard work, as is true for all the other developers who post the many versatile hacks here for no additional cost, and as soon as any one of my sites goes from red to green, some will be shared with those whose mods contributed to that!

TSG!
Makes perfect sense.

I'm hoping the import script will be done soon so people like you can rock and roll with it.

As for modifications, frankly my biggest interest is in seeing forums evolve, thrive and become marketing forces which is why all of my mods are designed to drive traffic and activity. Some of what I've built for my own sites ends up here... it's a win-win for me and those who use them (most of the time).
Reply With Quote
  #913  
Old 07-22-2009, 11:06 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cooltechie View Post
If you feel you have a near finished version of import you would like to test, I'm willing to give it a try. I could do without it, but then again, the members have invested some time to thank others, so it's probably better to get them counted.
Attached is the updated version of the script. To be candid I plan to test this more myself over the weekend but if you are inclined you are more than welcome to give it a shot. Just prepare to remove the addon should you encounter a bug.
Attached Files
File Type: php ha_import.php (3.8 KB, 8 views)
Reply With Quote
  #914  
Old 07-23-2009, 01:58 AM
cooltechie cooltechie is offline
 
Join Date: Apr 2004
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm surprised no one reported issue when using the latest version (1.9.1 beta v6).

Code:
Database error in vBulletin 3.8.3:

Invalid SQL:

				SELECT helpfulpost.postid as postid,post.threadid as threadid
				FROM helpfulpost as helpfulpost
				INNER JOIN post AS post ON(helpfulpost.postid = post.postid);

MySQL Error   : Table 'example_vb.helpfulpost' doesn't exist
Error Number  : 1146
Request Date  : Thursday, July 23rd 2009 @ 02:55:42 AM
Error Date    : Thursday, July 23rd 2009 @ 02:55:44 AM
Script        : http://www.example.com/community/admincp/plugin.php?do=productimport
Referrer      : http://www.example.com/community/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Classname     : vB_Database
MySQL Version : 5.0.81-community
Reply With Quote
  #915  
Old 07-23-2009, 02:20 AM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is this a fresh install or an upgrade?
Reply With Quote
  #916  
Old 07-23-2009, 02:34 AM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Answered my own question... Beta 1.9.1 version8 is posted which fixes a bug with new installs.
Reply With Quote
  #917  
Old 07-23-2009, 03:20 AM
Daky Daky is offline
 
Join Date: Aug 2006
Posts: 247
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ted S View Post
Absolutely. Just delete all the data from the tables helpfulpost and helpfulanswer and it will all go away. Alternatively you can use the field userid to limit who has their data removed.
- thank you for answer, but, no thank you, i am going to leave it as it is.

I can't play with my database - not an expert, afraid i am gonna f* it up.

Anyway, thank you very much for detailed answer as always, great support and best script.

D
Reply With Quote
  #918  
Old 07-23-2009, 12:16 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not much risk in the delete process... I assure you (especially if you don't mind doing a complete reset).

Here's a few queries you could run:

To remove all votes:
Quote:
DELETE FROM helpfulpost;
DELETE FROM helpfulanswer;
To remove votes from one user:
Quote:
DELETE FROM helpfulpost WHERE userid = XYZ;
DELETE FROM helpfulanswer WHERE userid = XYZ;
Pretty simple.
Reply With Quote
  #919  
Old 07-23-2009, 01:16 PM
cooltechie cooltechie is offline
 
Join Date: Apr 2004
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ted S View Post
Answered my own question... Beta 1.9.1 version8 is posted which fixes a bug with new installs.
I think you forgot to attach it so we can help you test.
Reply With Quote
  #920  
Old 07-23-2009, 04:33 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Details, details.
Reply With Quote
  #921  
Old 07-23-2009, 05:42 PM
cooltechie cooltechie is offline
 
Join Date: Apr 2004
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ted S View Post
Details, details.
Ok, now I see it in the download area.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:02 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06766 seconds
  • Memory Usage 2,364KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (7)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (4)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (9)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete