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.

[Ted S]

Originally Posted by bfdzio

Ted S...do you have any idea on how I might do this (the second quote)? I got it working thanks to your help but just saw this post was bumped and recalled I never did figure out how to make it preview the posts.

I can probably handle the design part of it but is that a specific code I am looking for or anything?

You'll need to alter the script's query to join the post table, get the body message, potentially parse it through the editor if you allow styling and that's about it.

SELECT <existing stuff>,post.message

JOIN post ON helpfulpost.postid = post.postID

[socialteenz]

Originally Posted by Ted S

And your settings for the mod....?

I am using the default settings. Everything is fine, if the mod is disabled.

[Ted S]

Originally Posted by socialteenz

I am using the default settings. Everything is fine, if the mod is disabled.

Modify the plugin hook forumdisplay_query_threadid to

if($foruminfo['helpfulanswerbits'] AND $foruminfo['helpfulanswerorderbits']){
                    $hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "helpfulpost AS helpfulpost ON(thread.threadid = helpfulpost.threadid)";
                }

And let me know if that fixes it

[socialteenz]

Originally Posted by Ted S

Modify the plugin hook forumdisplay_query_threadid to

if($foruminfo['helpfulanswerbits'] AND $foruminfo['helpfulanswerorderbits']){
                    $hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "helpfulpost AS helpfulpost ON(thread.threadid = helpfulpost.threadid)";
                }

And let me know if that fixes it

Still no luck Ted!

[socialteenz]

Update: I modified forumdisplay_query hook with your code.

That seems to fix my problem.

[Ted S]

Originally Posted by socialteenz

Update: I modified forumdisplay_query hook with your code.

That seems to fix my problem.

Great. We'll roll that into the next official release.

[Eole]

Originally Posted by Ted S

That's certainly not something that should be happening... It sounds like something is going wrong with your mySQL records...

Take a look at the table helpfulpost and a post that shows up multiple times. There should be just one entry per postid.

I.E. SELECT COUNT(*) FROM helpfulpost WHERE postid = '12345';

Hello TedS,

in the helpfulpost table, every postid has a single line, no duplicate in database. But there are always here in the forum pages. the threadid has 5 line in helpfulpost table (5 distinct postid) that seems correct, but I have exactly 5 duplicate threads on the thread page of the forum.

Regards.

[Ted S]

Originally Posted by Eole

Hello TedS,

in the helpfulpost table, every postid has a single line, no duplicate in database. But there are always here in the forum pages. the threadid has 5 line in helpfulpost table (5 distinct postid) that seems correct, but I have exactly 5 duplicate threads on the thread page of the forum.

Regards.

And when you disable just this mod that goes away, correct?

[penmai.com]

please help me, how to make only certain usergroup can vote it, for example only moderator and supermod can vote it.

[Ted S]

Originally Posted by penmai.com

please help me, how to make only certain usergroup can vote it, for example only moderator and supermod can vote it.

That's not something built in but you can hack the mod to do it through both the XML and php file.