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 The Rocketeer

For some reason the top ten was turned on. So after disabling it and trying to run these queries

we are getting this error

An error occurred while attempting to execute your query. The following information was returned.

error number: 1064
error desc: 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 'DELETE FROM helpfulanswer' at line 2

Try running the delete query separately?

[The Rocketeer]

Originally Posted by Ted S

Try running the delete query separately?

that didnt work either ted i tried them both separately

what should i do now?

[The Rocketeer]

Okay on my 3rd try I was able to get this query to run

DELETE FROM helpfulanswer;

But I still couldn't get this to run

UPDATE post SET goodrank = '', totalrank = '';

I keep getting this error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'goodrank' in 'field list'

And if the Helpful answers are enabled then after clicking thumbs up, I get this error

Parse error: syntax error, unexpected '<' in /home/myaccount/public_html/helpfulanswers.php on line 522

[Ted S]

Originally Posted by The Rocketeer

Okay on my 3rd try I was able to get this query to run

DELETE FROM helpfulanswer;

But I still couldn't get this to run

UPDATE post SET goodrank = '', totalrank = '';

I keep getting this error


And if the Helpful answers are enabled then after clicking thumbs up, I get this error

Parse error: syntax error, unexpected '<' in /home/myaccount/public_html/helpfulanswers.php on line 522

The first error is because that query is really really old.

Should be: UPDATE helpfulpost SET goodrank = '', totalrank = ''

The second error is something in your script. Reupload.

[The Rocketeer]

thanks Ted, I was using the old query found inside the read me, your updated query fixed it

UPDATE helpfulpost SET goodrank = '', totalrank = ''

Great mod, nominated, we will use it in all our forums

[Ted S]

Thanks for the heads up. I'll have to fix that!

[Successfulsteps]

Very nice! Installed and working marvelously! :up:

[The Rocketeer]

Update

Ted, I found a very annoying error with this mod that would cause double posts / duplicate posts of the first topic on a thread. Meaning the topic creators first post will be shown at the bottom of his post as the second post.

I will be sending you the details of this 'Error" in a PM.

[Ted S]

Originally Posted by The Rocketeer

Update

Ted, I found a very annoying error with this mod that would cause double posts / duplicate posts of the first topic on a thread. Meaning the topic creators first post will be shown at the bottom of his post as the second post.

I will be sending you the details of this 'Error" in a PM.

Is this happening on EVERY post? Or just a few posts?

If it's across the board it's something in your particular install [otherwise this would obviously not be used by anyone] and more tricky to trace down. How much activity do you have in the system? Have you made any changes to the template or code beyond resetting the query?

P.S. I handle all support via the public posts so other users can chime in and benefit from answers.

[The Rocketeer]

No Ted, its not happening across the board, otherwise you would see it on other posts, only happens in a couple posts that probably got affected when I had accedentally turned on and off the top ten thing and then went on and clicked "thumbs up" on a few posts which gave me the error ("Parse error: syntax error, unexpected '<' in /home/myaccount/public_html/helpfulanswers.php on line 522"). So only those few posts are affected. Have I had the updated query then this probably wouldnt have happened. So I think it might be some kind of a query, table or something small gone bad(cache or database related?) that could be easily fixed, since the problem goes away if the mod is disabled. BTW. Did you login with the details and had a good look around yet?

P.S. Thats perfectly fine since others might be able to chime in, so we'll discuss it here. I just PMed you since I didn't want to share my boards URL or anything publicly.