Add-On Releases - [AJAX] Helpful Answers - Allow users to rate individual posts

Helpful Answers has been used to record over 6 MILLION times on more than 2,000 forums. If you're not using HA your users are looking for it!

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 to rate individual posts as either helpful or not allowing future visitors to understand the value of each post.

Designed to be flexible, HA has over 30 configurable settings:

• Use image or text ratings AJAX or traditional links.
• Offer yes/no or scaled 1-10 point ranking.
• Turn off negative ratings for a positive only system.
• Decide which forums are open for helpful answer ratings.
• Audit the system and identify top users and potential abusers.
• Ban specific members from using the system.
• Customize the message shown after a post is rated.
• Show a page with the top helpful posts.
• Show rating stats on a user's profile.
• Hide posts that rate "too low"
• Template driven so you can customize it all for 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 [Must Read]:

Step 1: Upload the addon files found in the upload/ folder to your forum directory
Step 2: Install the plugin through your vB Administration area
Step 3: Configure settings & enable the mod in individual forums

You must configure settings & enable forums before voting will show up.
Anonymous Stats Tracking (optional):

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. You can disable this through the admin.

Mod Philosophy -- Drive Your Own Success:

All of my mods are inspired by my work in digital marketing and are designed to drive registrations, interaction or other engagement activities the core platform does not address.

Each is designed to fit a general need by providing a starting point but it's on you to decide how to make things work to their best possible outcome. Feel free to suggest what you'd like to see next but don't wait to have what everyone else has; figure out what your forum needs and customize away.

[bfdzio]

Originally Posted by Ted S

You can simply copy that routine and add one addition WHERE statement to the mySQL query along the lines of

createddate >= DATE_SUB(NOW(),INTERVAL 1 day)

Tried several different things and can't get it to work...where excactly? Also it can't find any 'createddate' but at least got rid of the error when I changed it to post dateline..but nothing shows.

$helpfulanswers = $db->query_read_slave("
SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalran k,helpfulpost.lastvote,
thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle $helpful_selectby
$hook_query_fields
FROM " . TABLE_PREFIX . "helpfulpost as helpfulpost
INNER JOIN " . TABLE_PREFIX . "post AS post ON(helpfulpost.postid = post.postid)
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON(post.threadid = thread.threadid)
INNER JOIN " . TABLE_PREFIX . "forum AS forum ON(thread.forumid = forum.forumid)
WHERE helpfulpost.goodrank > 0
$conditions
$hook_query_joins
ORDER BY $sqlsort $sortorder
LIMIT " . ($limitlower - 1) . ", $perpage
");

[Ted S]

Shoot... createddate is the attribute I usually use in mods but in this one it would be

helpfulanswer.lastvote

However I've over simplified as this is a UNIXTIMESTAMP made by vBulletin rather than a datestamp. That means you have to get more complex in the query...

helpfulanswer.lastvote >= UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 1 day))

Or something like that

[Shill360]

Bit of a strange one this.

I am entering {vb:raw post.totalrank} in my postbit_legacy template.

And it is showing the number of thanks under the user avatar. But only on that particular post. Is there anyway to show the total number of thanks on all posts for a user. The old variable on the 3.x version was $post[hatotalrank] which showed the total number of thanks on multiple posts for users.

Am I doing something wrong ?

[Ted S]

Originally Posted by Shill360

Bit of a strange one this.

I am entering {vb:raw post.totalrank} in my postbit_legacy template.

And it is showing the number of thanks under the user avatar. But only on that particular post. Is there anyway to show the total number of thanks on all posts for a user. The old variable on the 3.x version was $post[hatotalrank] which showed the total number of thanks on multiple posts for users.

Am I doing something wrong ?

post.totalrank is a post variable so it's not strange that it only shows what that post got

If you scroll back to the first page of the mod there's a list of accessible variables with brief descriptions. I don't recall them all off hand but if I had any common sense when making this version it would have been post.hatotalrank

[bfdzio]

Originally Posted by Ted S

Shoot... createddate is the attribute I usually use in mods but in this one it would be

helpfulanswer.lastvote

However I've over simplified as this is a UNIXTIMESTAMP made by vBulletin rather than a datestamp. That means you have to get more complex in the query...

helpfulanswer.lastvote >= UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 1 day))

Or something like that

Got it working, now I just need to make it show a preview of the post (or the whole post).

Probably more work involved in that though.

[Trevor Matthews]

Hi
I have this installed and all is fine, except that I have just installed Pird of Preys Simple Postbit modification and this mod no longer works in the sections where I have activated Simple Postbits.
Simple Postbits has a box that says Use Postbit Control Hooks, the description is below;

"Choose whether you want to enable the postbit controls template hook. If yes mods that use this hook will be able to place their code in the simple postbit. Enable this if you want a "Like" button or other 3rd party buttons to show."

Does anyone know how I can get Helpful Answers to work again in those sections?
Thanks for any suggestions.

[Ted S]

Originally Posted by Trevor Matthews

Hi
I have this installed and all is fine, except that I have just installed Pird of Preys Simple Postbit modification and this mod no longer works in the sections where I have activated Simple Postbits.
Simple Postbits has a box that says Use Postbit Control Hooks, the description is below;

"Choose whether you want to enable the postbit controls template hook. If yes mods that use this hook will be able to place their code in the simple postbit. Enable this if you want a "Like" button or other 3rd party buttons to show."

Does anyone know how I can get Helpful Answers to work again in those sections?
Thanks for any suggestions.

I can't debug specific cross-mod issues as there's simply too many combinations but I'd suggest trying the manual placement option and adding the template hook yourself. This takes a couple lines of editing but may solve your issue.

[Trevor Matthews]

Ok, thanks, Pird of Prey is having a look at it for me.
I will report back if I can solve the problem.

[Ted S]

Originally Posted by Trevor Matthews

Ok, thanks, Pird of Prey is having a look at it for me.
I will report back if I can solve the problem.

If they find a conflict please let me know. It's _generally_ not hard to fix those, it's finding them that's a pain.

[Trevor Matthews]

It has been sorted, I had to modify the template.
Details are Here, should be sorted in later releases.