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

[Ted S]

In my case 1 and also 2 hides all posts, even first post. posts which are even non negative rated. I think its a bug and only negative posts should not be visible..? :eek:.

Typo on my part.

-2

Logic used:

($post['goodrank'] - $post['totalrank']) < $this->registry->options['helpans_hidelownum']

[dougdirac]

any screenshots of what a hidden post looks like? Do you click to view?

[Ted S]

any screenshots of what a hidden post looks like? Do you click to view?

Right, the entire post contents are replaced with a very short block of text that has a link to expand back the post (we use a hidden div to make it happen).

The default phrase is "The post by {1} is hidden due to low votes. Click expand to view it" but of you can of course change that, add details, images, whatever you like.

[postcd]

When i add -1 it dont hide 1 negative votes posts. why?

[Ted S]

When i add -1 it dont hide 1 negative votes posts. why?

It's a greater then statement so > -1 is -2, -3, etc... So you enter whatever the minimum value of posts you want to have show.

Clearly not how the option describes it but we'll probably change the phrase rather than the logic to avoid any adverse impact to forums that already have a value in.

[tpearl5]

Any thoughts on importing vbseo likes into helpful answers?

The likes system and vbseo in general has going to the toilet.

[Ted S]

Any thoughts on importing vbseo likes into helpful answers?

The likes system and vbseo in general has going to the toilet.

There's no import feature at this point... not sure how they work exactly if you can explain?

[TheLastSuperman]

There's no import feature at this point... not sure how they work exactly if you can explain?

vBSEO Likes is similar to Paul's mod here on vbulletin.org where you click the heart to "like" a post but instead it was a link bottom right of postbit text in each post. Also it's very similar to DB Tech's thanks/likes system they are all very similar in concept.

[Ted S]

vBSEO Likes is similar to Paul's mod here on vbulletin.org where you click the heart to "like" a post but instead it was a link bottom right of postbit text in each post. Also it's very similar to DB Tech's thanks/likes system they are all very similar in concept.

Thanks!

Obviously if it's just a straight like, importing the data would be rather simple (loop the votes, add a record for each, resync the totals on the post).

The question is of course: why do it and does it match the user's expectation? I like a lot of things but are they helpful? Not sure it's the same...

[Loget]

Dear Ted S,

I would like to install your modification however was wondering if there was a port available from https://vborg.vbsupport.ru/showthread.php?t=231666?

Thanks.

[Ted S]

Dear Ted S,

I would like to install your modification however was wondering if there was a port available from https://vborg.vbsupport.ru/showthread.php?t=231666?

Thanks.

Nope.

[webmastersitesi]

reported answers page url not opening... any idea?
showpost.php?p=123 no opening... profile.php?do=helpfulans this is the page...

[Ted S]

reported answers page url not opening... any idea?
showpost.php?p=123 no opening... profile.php?do=helpfulans this is the page...

showpost.php is part of your core forum, if that's not working, you should check your vBulletin installation (or clarify your message to indicate what this addon is doing that does not work with it).

[Wajow-community]

doesnt work with 4.2.1?..

[Ted S]

doesnt work with 4.2.1?..

Sure it does.

Did you read the install guide and/ or first thread of this post?

[emath]

Hey Ted, did you consider to make the most helpful answer as the second post?
This could be a very great feature..

[Ted S]

Hey Ted, did you consider to make the most helpful answer as the second post?
This could be a very great feature..

You can re-order posts by votes with a little hacking or show a message to jump down to the most helpful post. Moving one specific post, not really requested.

[Wajow-community]

doesnt work good with vbulletin 4.2.1

[Prince]

this hack stinks.

[ozzy47]

Well that's constructive feedback.

[Prince]

I just don't want anyone else to waste their time installing it. :)

[ozzy47]

Hmmm, 555+ installs, I would say you are a bit late.

[TheLastSuperman]

this hack stinks.

I just don't want anyone else to waste their time installing it. :)

Matter of opinion I suppose, most would argue though :p.

[Ted S]

doesnt work good with vbulletin 4.2.1

This system works fine with many 4.x sites as noted by other members over past posts. If you provided actual details, I'm sure we could figure out what's not happening for your specific forum but it's pretty hard to do much with "doesn't work good."

[Ted S]

this hack stinks.

I'm not understanding if you don't like the concept or the execution. If the former, by all means, don't use what isn't right for you. If the later, perhaps you'll grace us with some details to help insure it gets improved?

[Ted S]

Hmmm, 555+ installs, I would say you are a bit late.

And the 4,000,000+ votes that have taken place through those installs (anonymous reporting is an admin option). Suppose that means a few people must like it... maybe, sorta?

[Edit: Make that 6.4 million. Guess they didn't get the memo that it stinks yet :D]

[asabet]

I own several photography forums, and I'm looking for a solution that would let members nominate posts for consideration to be featured on the front page/CMS. This looks like it will work really well for that - I would check the stats daily and see which posts receive multiple nominations - but it has a lot more options/features than I need. Does it affect performance much on a big board?

[Ted S]

I own several photography forums, and I'm looking for a solution that would let members nominate posts for consideration to be featured on the front page/CMS. This looks like it will work really well for that - I would check the stats daily and see which posts receive multiple nominations - but it has a lot more options/features than I need. Does it affect performance much on a big board?

Everything dynamic impacts performance but this mod is pretty low on the threshold as it's primarily just extending existing queries to call in votes and, on occasion, append them in. It's by no means without it's hit but it was designed thinking about how to avoid new calls (and mark options which require them clearly).

The biggest boards using the mod pull in six figures worth of votes themselves, so you can infer from that what their size is.

[tpearl5]

There's no import feature at this point... not sure how they work exactly if you can explain?

One like = one helpful answer vote. There are no down votes. There was an importer for this mod for the likes. This was the query:


"select p.postid,p.userid,ha.dateline as date,ha.userid as whoadded,hp.threadid,u.username,l.l_contentid ".
"from ".vbseo_tbl_prefix('helpfulanswer')." ha inner join ".vbseo_tbl_prefix('post')." p on (ha.postid = p.postid) ".
"inner join ".vbseo_tbl_prefix('helpfulpost')." hp on (ha.postid = hp.postid) ".
"inner join ".vbseo_tbl_prefix('user')." u on (ha.userid = u.userid) ".
"left join ".vbseo_tbl_prefix('vbseo_likes')." l on l_ctype=1 and l_contentid=p.postid and l_from_userid=ha.userid ".
"where ha.yesno = 1";

[Ted S]

One like = one helpful answer vote. There are no down votes. There was an importer for this mod for the likes. This was the query:


"select p.postid,p.userid,ha.dateline as date,ha.userid as whoadded,hp.threadid,u.username,l.l_contentid ".
"from ".vbseo_tbl_prefix('helpfulanswer')." ha inner join ".vbseo_tbl_prefix('post')." p on (ha.postid = p.postid) ".
"inner join ".vbseo_tbl_prefix('helpfulpost')." hp on (ha.postid = hp.postid) ".
"inner join ".vbseo_tbl_prefix('user')." u on (ha.userid = u.userid) ".
"left join ".vbseo_tbl_prefix('vbseo_likes')." l on l_ctype=1 and l_contentid=p.postid and l_from_userid=ha.userid ".
"where ha.yesno = 1";


Very Cool.

Just remember, there's 3 bits of logging involved in votes:

helpfulpost - which stores the post level totals (so we don't have calculate every load)
helpfulanswer - which records the votes (so we know every detail to report / manage)

and then a record on the user level (for profile views)

[juzz86]

All good found it under postbit_legacy. Using the {vb:raw post.goodrank} variable works well. Thanks again

found it, I used {vb:raw post.hagoodrank}
sorry for all the posts :)

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

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

Ted, hi from Australia.

Mate I have been using your plugin for a while now, with great results. I scoured the thread time and time again going over the posts of those who've tried to do this before me, as I'm having the same trouble.

I am attempting to add a 'good' tally to the postbit. Getting it into place and stuff is fine, but I cannot for the life of me seem to find the correct variable to put here.

Here's the postbit:

https://vborg.vbsupport.ru/external/2014/02/6.png

And here's the template source (I have this stacked under the 'thanks' hack postbit template):

<vb:if condition="$post['userid']">
<vb:if condition="$post['post_thanks_thanked_times'] == 1">
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_time_post}</dd>
<vb:elseif condition="$post['post_thanks_thanked_posts'] == 1" />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_post, {vb:raw post.post_thanks_thanked_times_formatted}}</dd>
<vb:else />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_posts, {vb:raw post.post_thanks_thanked_times_formatted}}</dd><br>
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">Helped {vb:raw post.hagoodrank} Times</dd>
</vb:if>
</vb:if>

Doesn't seem to matter which variable I use, 'hagoodrank', 'hatotalrank', 'totalrank', 'goodrank', you name it - I just can't seem to find the user's global tally of 'good' votes.

I didn't really want to trouble you with it, especially as it's technically an unsupported mod, but mate I am just about out of options. I quoted the bloke above who got it working with post.hagoodrank - that isn't working for me.

Any help greatly appreciated!

Justin

[Ted S]

Mate I have been using your plugin for a while now, with great results. I scoured the thread time and time again going over the posts of those who've tried to do this before me, as I'm having the same trouble.

I am attempting to add a 'good' tally to the postbit. Getting it into place and stuff is fine, but I cannot for the life of me seem to find the correct variable to put here.


You just had to go there and open Pandora's box... :D

So it looks like the variables were setup right (post.hagoodrank & post.hatotalrank), but the routine for updating votes was completed bugged up... results were always 0 because results were never properly saved.

I've fixed that, updating upload/helpfulanswers.php

Also found another bug in switching back & forth in voting types and templates, fixed that in the xml file.

And finally added a resync routine to get all the old votes from members updated, so you don't have zeros on people with vote history, also the xml file.

Note: This is a lightly tried update from my working-version code with whatever else I've done since 2.4.2 so please proceed with caution.

[juzz86]

You just had to go there and open Pandora's box... :D

So it looks like the variables were setup right (post.hagoodrank & post.hatotalrank), but the routine for updating votes was completed bugged up... results were always 0 because results were never properly saved.

I've fixed that, updating upload/helpfulanswers.php

Also found another bug in switching back & forth in voting types and templates, fixed that in the xml file.

And finally added a resync routine to get all the old votes from members updated, so you don't have zeros on people with vote history, also the xml file.

Note: This is a lightly tried update from my working-version code with whatever else I've done since 2.4.2 so please proceed with caution.

You Sir, are a champion. If you could see the parallels with 'opening Pandora's box' and my life yesterday, you would be laughing about as much as I am now :up:

Truly appreciative of your efforts and quick fix mate - thankyou. I will have a go at this tonight after work and report back my findings. Many thanks again for all your efforts :) If you ever find yourself in my neck of the woods, your first beers are on me :up:

[Ted S]

Now that's a damn good offer. Should I ever make it to yourside of the world, expect a PM...

Let me know how the update goes.

[juzz86]

Now that's a damn good offer. Should I ever make it to yourside of the world, expect a PM...

Let me know how the update goes.

You're on!

Just reporting back mate, 2.5.0 takes care of that and sorts it beautifully. Tally now reflects the helpfulanswers.php page, and is updating on refresh.

Thanks again mate.

[Ted S]

You're on!

Just reporting back mate, 2.5.0 takes care of that and sorts it beautifully. Tally now reflects the helpfulanswers.php page, and is updating on refresh.

Thanks again mate.

Fantastic!

[yukirina]

This mod is absolutely fantastic, but is there still no way to undo a vote that you've done on a post?

[Ted S]

This mod is absolutely fantastic, but is there still no way to undo a vote that you've done on a post?

Nope.

[m7sen]

hello
any upgrade ?

we are in 2014 !

[Randhal007]

hello
any upgrade ?

we are in 2014 !

i will wait for that too :)

[Ted S]

i will wait for that too :)

Why?

[Ted S]

hello
any upgrade ?

we are in 2014 !

Upgrade to change / do / add what?

[yukirina]

I'm pretty sure it's not much help posting this, but I'm going to try it anyway by the smallest chance that it's possible.

There's a mod called vBActivity by DragonByte that our forum uses. This module increases activity points of the user rep'ing a post. I tried rep'ing someone's post without a mod and the points increased as expected. But when I used your mod to rep someone's post (helpful answer upvote/downvote), nothing happened. Do you possibly know any solution to this?

[Ted S]

There's no connection between the two mods from this end so voting up a post here won't impact the reputation system there. The solution would be to extend your reputation system to add points by votes which can be done with the included hooks.

[yukirina]

There's no connection between the two mods from this end so voting up a post here won't impact the reputation system there. The solution would be to extend your reputation system to add points by votes which can be done with the included hooks.

But using a reputation system by vBulletin does affect it, that's why I think there's something that can be tweaked to make it work.

[Ted S]

But using a reputation system by vBulletin does affect it, that's why I think there's something that can be tweaked to make it work.

Right, like I said, it can almost certainly be done if you so chose to do it.

[Conehead555]

When I use this option:

Enable User Points
If enabled, users will have votes on their posts counted to display in the postbit template, their profile, etc.

What is the variable for using this in the postbit, etc.?

[Ted S]

When I use this option:

Enable User Points
If enabled, users will have votes on their posts counted to display in the postbit template, their profile, etc.

What is the variable for using this in the postbit, etc.?

Yikes, that's really not well labeled, my bad :D

Here's the variables generated, play around to see which paint the right picture you want.

{vb:raw post.totalrank} - The total number of ratings
{vb:raw post.goodrank} - The number of good ratings
{vb:raw post.badrank} - The number of bad ratings
{vb:raw post.helpfulgood} - True if the post is positive overall (more good than bad ratings)
{vb:raw post.rate_helpfulanswer} - True if the user can rate the post (false if they are banned or have rated it).
{vb:raw post.helpfulanswerid} - True if the user has already rated the post.

[GCC LLC]

Skimmed through but couldn't fine it.

Is there a variable that you can put in postbit that lists the number of votes received by others?

Looking to create a nice list of "most useful members"

[QFIT]

I came to post pretty much the same as the last poster. How do I get a list of the most helpful posters? I think this is more useful than the posters that used the function the most.

[Ted S]

I came to post pretty much the same as the last poster. How do I get a list of the most helpful posters? I think this is more useful than the posters that used the function the most.

This is not something included but the data is all there (in the user table) waiting for you to build whatever display you want.

[QFIT]

Can you give me the SQL query?

[Ted S]

Can you give me the SQL query?

There's two columns in the usertable to use:

hagoodrank - which is the number of good rankings
hatotalrank - which is the total votes on threads

You can use either / both to sort as you see fit.

[Meestor_X]

Sorry if this question has already been answered... (TL;DR and I did do a search on this thread and didn't get any relevant hits)

Can a thread be sorted by # of upvotes? That is to say, can the posts with the highest "good" rating be shown first? Are there other sort options too?

[Ted S]

Sorry if this question has already been answered... (TL;DR and I did do a search on this thread and didn't get any relevant hits)

Can a thread be sorted by # of upvotes? That is to say, can the posts with the highest "good" rating be shown first? Are there other sort options too?

Not as a default option.

Thread sorting is assumed to be by date and us hardcoded into the system so while it's very much possible, it requires some manual hacking to accomplish.

Look at line 881 / 919 / 1002 of showthread.php

[Meestor_X]

Thank you for your quick reply!
Alternately, a link to the highest rated answer shown in the first post would be good.
I'm looking to see if there's a substitute for Stack Exchange-type question/answer threads that can be done within VB, and it seems like your Mod might be a workable solution.

[Ted S]

Thank you for your quick reply!
Alternately, a link to the highest rated answer shown in the first post would be good.
I'm looking to see if there's a substitute for Stack Exchange-type question/answer threads that can be done within VB, and it seems like your Mod might be a workable solution.

There is a feature to enable a link to the top post though if you want a true q/a system I'd suggest the hack which will require a couple joins and a few conditionals. Shouldn't be crazy.

[Meestor_X]

There is a feature to enable a link to the top post though if you want a true q/a system I'd suggest the hack which will require a couple joins and a few conditionals. Shouldn't be crazy.Very cool! Would you be able to point me to information on that hack?

[Ted S]

Very cool! Would you be able to point me to information on that hack?

Sorry, "it" being a concept. Don't know that it's been actually done.

[Cyclist]

Everything works fine. Thanks!

Is is possible to translate the phrases that appear on the users and the posts? How would that be possible?

[ozzy47]

If the mod is coded to use phrases, you can do it in the Phrase Manager. :)

[Ted S]

If the mod is coded to use phrases, you can do it in the Phrase Manager. :)

And everything in the mod should be set to phrases :D

[Shill360]

Hey Ted,

I've just started using the vBulletin Default Mobile Style on my Forums. Is there an easy way to integrate the helpful_answers into the postbit and postbit_legacy? I just placed {vb:raw helpful_answers} in there, but it doesn't seem to work.

It works perfectly for the desktop theme: http://www.onlinearsenal.com

[PJRC]

Is there any way to use the helpful answers ratings to sort/rank forum search results (search.php)?

[ninthbit]

This mod is absolutely fantastic, but is there still no way to undo a vote that you've done on a post?Nope.
Can that feature be added? With smartphones its real easy to click the wrong vote.

[SilverBoy]

Hi

I want to use this great add-on to maintain this objective.

I have one forum for my correspondents to give me the last news from their places, I want to be able as administrator or any specific group to give point (1 to 10) for every thread one of them makes in that forum.

The point that I don't recognize how to do it until now (I don't make deep research in this big thread), I want the average of points every correspondent get from our votes on his thread depending on the stories that he wrote and if it was fake, rumor or real, then I can filter my huge correspondents team and give real job to those which make good job.

Any Ideas?

[sixpackspeak]

Hey Ted,

I've just started using the vBulletin Default Mobile Style on my Forums. Is there an easy way to integrate the helpful_answers into the postbit and postbit_legacy? I just placed {vb:raw helpful_answers} in there, but it doesn't seem to work.

It works perfectly for the desktop theme: http://www.onlinearsenal.comI would love this as well.

[Ted S]

I would love this as well.

Do you see the same "helpfulanswers_" templates appearing in your mobile style as the desktop themes?

If so, open up the template for your rating style (topten, etc) and add some characters to the very top, refresh and see if they appear (to see if the template is getting called up at all).

[sixpackspeak]

It is not in the mobile templates. Thanks for replying. I appreciate it.

[Ted S]

It is not in the mobile templates. Thanks for replying. I appreciate it.

Try copying those templates over to the mobile style. Odds are the script is running fine, it just doesn't have the templates to pull up

[sixpackspeak]

Thanks Ted. That did it.

[mtlurb]

Hello everyone,

I have this weird bug where a specific forum shows the same thread over and over.

I disabled the plugins one by one and its this plugin that is causing this issue.

Its very weird as everything was working before.

Anyone got the same issue?

Please help as I like this plugin very much!

Thanks,

[Palidino76]

Hello everyone,

I have this weird bug where a specific forum shows the same thread over and over.

I disabled the plugins one by one and its this plugin that is causing this issue.

Its very weird as everything was working before.

Anyone got the same issue?

Please help as I like this plugin very much!


Thanks,

Experiencing the same issue as you. Disabling this mod fixed the section using this mod. With it enabled, the same thread is listed multiple times in a section and threads aren't properly ordered in the display by post date either.

[caciquegm]

Hi guys, i need to implement one button for "accepted solutions", the users ask, the other users responds, and the user mark the answer to "accepted solutions", and mark with a green checker mark. In the last option, the user have a possibility to delete the accepted solutions.

I thinks this plugin/mod help me with this.

Please help me if it correct and if you have more details.

https://comunidad.movistar.com.ar/attachment.php?attachmentid=5375&d=1419673471

https://comunidad.movistar.com.ar/attachment.php?attachmentid=5376&d=1419673528

https://comunidad.movistar.com.ar/attachment.php?attachmentid=5377&d=1419673613

[Ted S]

Hi guys, i need to implement one button for "accepted solutions", the users ask, the other users responds, and the user mark the answer to "accepted solutions", and mark with a green checker mark. In the last option, the user have a possibility to delete the accepted solutions.

I thinks this plugin/mod help me with this.

Please help me if it correct and if you have more details.


This addon does not provide the functionality you described. You could certainly use it as a base to modify into something that accomplishes your goals but it's going to take some development effort, especially the delete part.

[caciquegm]

OK man!!! really thanks for the answer!

This addon does not provide the functionality you described. You could certainly use it as a base to modify into something that accomplishes your goals but it's going to take some development effort, especially the delete part.