Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
[AJAX] Helpful Answers - Allow users to rate individual posts Details »»
[AJAX] Helpful Answers - Allow users to rate individual posts
Mod Version: 2.0.0, by Ted S (Coder) Ted S is offline
Developer Last Online: Nov 2014 I like it Show Printable Version Email this Page

vB Version: 3.7.x Rating: (7 votes - 5.00 average) Installs: 47
Released: 04 Feb 2009 Last Update: 01 Sep 2009 Downloads: 375
Not Supported DB Changes Uses Plugins Auto-Template Additional Files  

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 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.

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.

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.

History of this addon:

This addon was originally developed for private use in 2006 for a site of mine but after getting several past clients requested requests and messages I decided to package it up for public release.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	admin-stats1.gif
Views:	568
Size:	15.5 KB
ID:	94046Click image for larger version

Name:	admin-stats2.gif
Views:	475
Size:	11.3 KB
ID:	94047Click image for larger version

Name:	admin-stats3.gif
Views:	394
Size:	6.1 KB
ID:	94048Click image for larger version

Name:	rating-methods.gif
Views:	591
Size:	48.8 KB
ID:	95494Click image for larger version

Name:	settings.jpg
Views:	320
Size:	102.6 KB
ID:	95495

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
[AJAX] Helpful Answers - Post Rating System (plus many sub-features) Ted S vBulletin 3.8 Add-ons 1800 18 Nov 2013 18:56

Comments
  #2  
Old 04 Feb 2009, 01:37
Ted S Ted S is offline
 
Join Date: Dec 2003
Tips & Tricks Using Template Variables:

While the Helpful Answers section may appear to only add to a small part of your post it can be used much more extensively to change the color of an entire post, to add a special icon or just about anything else you like. Here are list of the variables available for your templates and a few sample conditions you can use with them:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Future Updates:

I'm pleased with this addon so far but plan to extend it as feedback comes in so please share your comments and suggestions as they will be read and responded too.

Coming soon... A page showcasing your top 10 (or 20 or 30 or 100) posts.
__________________
New features released for Product Review Forums 1.3 (4.0)
Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
Reply With Quote
  #3  
Old 04 Feb 2009, 02:52
Ted S Ted S is offline
 
Join Date: Dec 2003
Thanks for the private feedback; I've added a simple page showing the Most Helpful Answers. This can be disabled through the options and the number of results to show can also be configured.
__________________
New features released for Product Review Forums 1.3 (4.0)
Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
Reply With Quote
  #4  
Old 04 Feb 2009, 03:18
Spank Spank is offline
 
Join Date: Jan 2007
Real name: Mark
Brill, will download and install later. Thanks
Reply With Quote
  #5  
Old 04 Feb 2009, 03:45
Rickeo's Avatar
Rickeo Rickeo is offline
 
Join Date: Jan 2007
Real name: Richard
Any chance of getting this to work on 3.8x?
__________________
SpiritualBB.com
The Online Multi Faith, Unexplained & Paranormal Bulletin Board
Reply With Quote
  #6  
Old 04 Feb 2009, 03:58
Ted S Ted S is offline
 
Join Date: Dec 2003
Originally Posted by Rickeo View Post
Any chance of getting this to work on 3.8x?
http://www.vbulletin.org/forum/showthread.php?t=204117
__________________
New features released for Product Review Forums 1.3 (4.0)
Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
Reply With Quote
  #7  
Old 04 Feb 2009, 08:31
GigaSb GigaSb is offline
 
Join Date: Aug 2006
help here please, got errors:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,post.goodrank,post.totalrank,helpfulanswer.helpfulanswerid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 4 AND postparsed.languageid = 3)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 4 AND sigparsed.languageid = 3)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN helpfulanswer AS helpfulanswer ON(helpfulanswer.postid = post.postid and helpfulanswer.userid = 1)
WHERE post.postid IN (0,210,231)
ORDER BY post.dateline;

MySQL Error : Table 'mysite_fph.helpfulanswer' doesn't exist
Error Number : 1146
Request Date : Wednesday, February 4th 2009 @ 11:26:54 AM
Error Date : Wednesday, February 4th 2009 @ 11:26:54 AM
Script : http://www.mysite.co.il/showthread.php?t=188
Referrer : http://www.mysite.co.il/forumdisplay.php?f=3
IP Address : XX.XXX.XX.XXX
Username : PCTech
Classname : vB_Database
MySQL Version : 5.0.37-standard
__________________
Best Regards, Thanks for the helpers.
Reply With Quote
  #8  
Old 04 Feb 2009, 13:32
6piston's Avatar
6piston 6piston is offline
 
Join Date: Apr 2005
Originally Posted by GigaSb View Post
help here please, got errors:

Database error in vBulletin 3.7.0:
try this:
http://www.vbulletin.org/forum/showp...91&postcount=8
Reply With Quote
  #9  
Old 04 Feb 2009, 13:40
6piston's Avatar
6piston 6piston is offline
 
Join Date: Apr 2005
hi Ted

i've created the sql table manually using the link i posted above. but now, i get other sql errors. this time:

when i click Yes / No the AJAX effect doesn't work, instead, a window pops up and says:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Zerotohundred.com Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.zerotohundred.com/newforums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The Zerotohundred.com database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.zerotohundred.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.zerotohundred.com forum technical staff have been notified of the error, though you may <a href="mailto:">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.2:

Invalid SQL:



SELECT post.goodrank,post.totalrank

FROM vb3post

WHERE postid = 2661498;

MySQL Error : Unknown column 'post.goodrank' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 4th 2009 @ 09:37:03 PM
Error Date : Wednesday, February 4th 2009 @ 09:37:04 PM
Script : http://www.zerotohundred.com/newforu...fulanswers.php
Referrer : http://www.zerotohundred.com/newforu...-sohc-bot.html
IP Address : 124.82.95.141
Username : Tom
Classname : vB_Database
MySQL Version : 5.0.51a-community-log</textarea></form>

</body>
</html>
so it's this:
MySQL Error : Unknown column 'post.goodrank' in 'field list'

please advise ted
Reply With Quote
  #10  
Old 04 Feb 2009, 14:10
GigaSb GigaSb is offline
 
Join Date: Aug 2006
i added the query that u advised me..
thank u very much!
__________________
Best Regards, Thanks for the helpers.
Reply With Quote
  #11  
Old 04 Feb 2009, 14:13
apiasto's Avatar
apiasto apiasto is offline
 
Join Date: Oct 2006
i am getting the same error.i will wait for stable hack
Reply With Quote
  #12  
Old 04 Feb 2009, 14:13
6piston's Avatar
6piston 6piston is offline
 
Join Date: Apr 2005
cool!. now you may face the next same prob as i am
Reply With Quote
  #13  
Old 04 Feb 2009, 17:07
tpearl5's Avatar
tpearl5 tpearl5 is offline
 
Join Date: Nov 2001
Real name: John
hrm - I like this idea, although I've already modified the wording of the reputation system to resemble something similar.
Reply With Quote
  #14  
Old 04 Feb 2009, 21:07
Ted S Ted S is offline
 
Join Date: Dec 2003
My appologies to those who have experienced bugs with the system. 3 issues were identified (2 with queries like the errors above show) and 1 in the creation of the table. An updated version has been released which solves all known issues.
__________________
New features released for Product Review Forums 1.3 (4.0)
Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
Reply With Quote
  #15  
Old 04 Feb 2009, 21:08
Ted S Ted S is offline
 
Join Date: Dec 2003
Note: Version 1.3.3 has been released which fixes several small issues related to creating the mySQL table for this addon and with two queries. With this update the current mysql query errors will go away and the table will be properly created.

All users are advised to upgrade while those who have experienced database errors should uninstall and then upgrade.

To upgrade simply upload the new version of helpfulanswer.php and install the new plugin file.
__________________
New features released for Product Review Forums 1.3 (4.0)
Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 00:02.

Layout Options | Width: Wide Color: