[AJAX] Helpful Answers - Post Rating System (plus many sub-features)

[Ted S]

You can edit the text through the phrase manager.

[compuminus]

In a future version it would also be helpful to have an option to also enable thread level thumbs up/down ratings, in addition to having them available for posts. This information could then be factored in when prioritizing threads in the sitemap, or for adding to an archive/library section on the forum.

[tpearl5]

I could look at making something to work with the notifications box I suppose.

Yeh, that would be even better than the PM's!

[Ted S]

In a future version it would also be helpful to have an option to also enable thread level thumbs up/down ratings, in addition to having them available for posts. This information could then be factored in when prioritizing threads in the sitemap, or for adding to an archive/library section on the forum.

Not a bad idea but as it would require different tables I may make this as a second addon.

[cheesegrits]

Re 'helpful threads' ...

Not a bad idea but as it would require different tables I may make this as a second addon.

For the moment, rather than a separate addon, could you look at adding an option to 'Display Threads On Top Answers Page?' and just derive the helpfulness of threads from the number/score of the rated posts?

Personally I'm not interested in adding a 'was this thread helpful?' button. Some folk may feel differently, but I think marking helpful posts is already doing that job. Seems like having both is somewhat redundant, and potentially confusing.

But ... I am very interested in being able to show both Post and Thread helpfulness on the Top Answers page.

As a slightly related request ... how about some hooks in 'topanswers'? Before I saw the post I'm responding to, I had just started looking in to adding Top Threads myself, and for this (and other) issues it'd be nice to have a few hooks - the usual vB stuff, with start/prequery/postquery/end.

BTW, great mod.

-- hugh

[Ted S]

Re 'helpful threads' ...
For the moment, rather than a separate addon, could you look at adding an option to 'Display Threads On Top Answers Page?' and just derive the helpfulness of threads from the number/score of the rated posts?


I don't think that would accomplish the goal. You're not interested in the helpful thread button but some people are. Hence a different mod... similar code but different.


But ... I am very interested in being able to show both Post and Thread helpfulness on the Top Answers page.


I could do another chart of top threads I suppose.


As a slightly related request ... how about some hooks in 'topanswers'? Before I saw the post I'm responding to, I had just started looking in to adding Top Threads myself, and for this (and other) issues it'd be nice to have a few hooks - the usual vB stuff, with start/prequery/postquery/end.


Sure. I can get that in the next release

[dancue]

Does anyone have any icons that look better with darker skins?

[Theater]

Does anyone have any icons that look better with darker skins?

See if these work for ya...

[dancue]

Any plans to integrate with vbcredits?

[Ted S]

Any plans to integrate with vbcredits?

No....

What did you have in mind?

[compuminus]

One other bit of feedback on an already excellent mod:

Within the "helpful answers system" menu in the admin control panel, it would be very helpful to be able to search/list the ratings based not only on who was rated and what they've rated, but also by who *has been rated* and what posts they've received ratings on. I'd think this would be straightforward to enable...

[cheesegrits]

I don't think that would accomplish the goal. You're not interested in the helpful thread button but some people are. Hence a different mod... similar code but different.


The reasons I'd like to see a Helpful Thread system based purely on the ratings of the posts are:

1) We already have Forum Ratings. It's a well known, well understood interface / concept. Replacing this with a Helpful Threads which is separate from Helpful Posts would seem to be reinventing the wheel.

2) It'd one less widget / knob / dial for the user to worry about. If they poke the helpful post button, they would automatically be giving the thread a rating bump. And as a user, this would seem totally natural ... if I found the post useful, then pretty much by definition I'm finding the thread useful (or not, as the case may be). I wouldn't really understand why I would have to go and manually give the thread a rating bump as a separate action.

3) Replacing the existing (and somewhat arbitrary 1 to 5 star) Thread Rating with a numeric Helpful Threads rating derived purely from the combined ratings of the posts in the thread would provide a true measure of how helpful any given thread is.

Perhaps there's a need for a Helpful Threads mod as a separate beastie instead of Helpful Posts ... but if I'm running Helpful Posts, I'd really like that option to replace the existing Thread Rating stuff with a derived value from the sum of the helpful posts. So instead of the rating stars on forumdisplay, I'd see a (sortable) numeric rating column.

-- hugh

[Milez]

Just a quick suggestion...

in the helpfulanswers.php page I removed 'Post 228819 in thread:' from the helpful_answers_top_bit template. My suggestion would be to grab the username to replace that text with. Something like:

Username in ThreadTitle

Users might enjoy seeing who is the most valuable poster.

The other suggestion I have is to enforce the Reputation rules. Right now a user may rate a post with the helpful anwers system and can also rate the same post with the standard Reputation controls in the postbit.

[Razasharp]

The other suggestion I have is to enforce the Reputation rules. Right now a user may rate a post with the helpful anwers system and can also rate the same post with the standard Reputation controls in the postbit.

That's working as intended - because the rep system can have a different value ;)

[Ted S]

Just a quick suggestion...

in the helpfulanswers.php page I removed 'Post 228819 in thread:' from the helpful_answers_top_bit template. My suggestion would be to grab the username to replace that text with. Something like:

Username in ThreadTitle


You can customize the template to look like any of thoes combinations.

[dancue]

No....

What did you have in mind?

A helpful rating earns x credits set by user.

[dancue]

See if these work for ya...

Thanks, but I was kind of hoping for the red and green colored ones.

[Ted S]

Thanks, but I was kind of hoping for the red and green colored ones.

I'd suggest working with a designer if you want custom icons. You can use any images you want with the system...

[dutchbb]

Great mod, should be introduced in vb4. Question: how can we have it like youtube?

See screenshot:

[Ted S]

Great mod, should be introduced in vb4. Question: how can we have it like youtube?

See screenshot:

Thanks.

Very easy to change that you can do by editing the templates and adding an inactive (greyed out) icon.

[Quantnet]

Ted,
I would be interested in that modification as well (the question by dutchbb)
Can you make it so when you hover over the thumb up/thumb down, it changes color from grey out to red or green.
When you click on it, it will show how the votes with numbers.
i can't even get the icons off youtube site ;(

[Ted S]

The YouTube icons are copyrighted... I can't use them. To do this someone would need to provide a grey icon set and color set.

[Quantnet]

I modified my template to look a bit like the youtube one.
It would be cool if we can implement the hover part.

[Quantnet]

question for Ted
How would i display the difference of $post[goodrank] - $post[badrank].

[Ted S]

However is simple... it's just a little javascript but doing it will require the grey icons which I can't make right now. If you can get those I can show you how to it all (going to post it up for everyone).

As far as the variables you'd need to grab it in the php code and change the output to activate it.

[Eagle Eyes]

How can i get those buttons that you have in the image demo?

Post, edit buttons.

Thank you so much.

[nelson.cabral]

Hi!

Is it possible to have multiple rating categories, so that users can rate posts on several criteria?
Is it possible to have the last post rating on thread view and on forum view?

[nelson.cabral]

Hi again, another question here : is it possible to change the cumulated rating calculation?

[Quantnet]

Here are the icons i used on my site

[Ted S]

How can i get those buttons that you have in the image demo?

Post, edit buttons.

Thank you so much.

Look in the admin options area and you'll find the setting to change this.

[Ted S]

Here are the icons i used on my site

These look to be the images from YouTube.com. If this is the case I can't reuse them in the addon. Sorry.

[Ted S]

Hi again, another question here : is it possible to change the cumulated rating calculation?

Please explain...

[Ted S]

Hi!
Is it possible to have multiple rating categories, so that users can rate posts on several criteria?


This addon is a Yes/No or 1-10 scale only. It doesn't evaulate criteria like a user review would.

Is it possible to have the last post rating on thread view and on forum view?

Not with the current functionality.

[Eagle Eyes]

No, i am talking about these buttons that you have in the image. Do you have the set to share? https://vborg.vbsupport.ru/external/2009/04/15.gifhttps://vborg.vbsupport.ru/external/2009/04/16.gif

[Ted S]

As in the icon set used my my example site? Those are not part of this addon.

[Eagle Eyes]

As in the icon set used my my example site? Those are not part of this addon.

I know. But if you want to share that would be great.

Otherwise its ok. My site: www.defence.pk

[Ted S]

I know. But if you want to share that would be great.

Otherwise its ok. My site: www.defence.pk

I can't post copyrighted elements when i dont have a licensr (nor should you be using them without consent). If you have another icon set that is free for public use I can package up the rollovers for you.

[Bigj85]

great mod,I have a question how would I go about showing this in only a certain thread.
I have $helpful_answers located where I want it in my postbit but is there some kind of way like <if condition=code for the thread id so it will only show in that threadID
I know very little about this stuff but it seems like it shouldn't be to hard.
I have a rate this song/video thread which is all I want it to show in.
thanks

sorry if this has been answered but there are so many pages of posts I couldnt go through them all

[Ted S]

You could use the condition <if condition="$threadinfo[threadid] == X">...</if>

[Bigj85]

thanks for the answer but I can't get it to work
after trying that it wont show at all,not even in the thread specified
I tried this in the postbit template

<if condition="$threadinfo[threadid] == 72"><div align="right">$helpful_answers</div></if>


is that how its supposed to look?it wont show in showthread.php?t=72

[Quantnet]

I think I found a bug (is it the same bug people reported earlier?)
When I click a few times on the thumb up button, there is a delay and when it comes back, it has 3 + and the post is duplicated 3 times.
It is weird since you can't remove any of them, remove one will remove all 3.

Update: I have to go to the Rating History backend to remove the ratings. It will also remove the posts automatically.
Anyone else has this problem?

[tpearl5]

Ted - any ideas on using $post[helpfulgood] in forumdisplay and $helpfulposts[totalranks] in postbit?

Also - I'm using vbplaza for my points system. Normally when reputation is given the user receives vbplaza points. Now that I'm using the reputation given strictly by your mod - they are not getting vbplaza points when receiving a good (or negative for bad) ratings for posts. Any ideas?

[Ted S]

I dont have the code in front me... try $thread[threadid] instead.

[tpearl5]

I dont have the code in front me... try $thread[threadid] instead.
try it where?

[Ted S]

try it where?
Sorry, that wasn't for your post.

[Ted S]

I think I found a bug (is it the same bug people reported earlier?)
When I click a few times on the thumb up button, there is a delay and when it comes back, it has 3 + and the post is duplicated 3 times.
It is weird since you can't remove any of them, remove one will remove all 3.

Update: I have to go to the Rating History backend to remove the ratings. It will also remove the posts automatically.
Anyone else has this problem?

The script checks to be sure you haven't voted before updating. Are you saying you're not seeing this validation take place?

[Ted S]

Ted - any ideas on using $post[helpfulgood] in forumdisplay and $helpfulposts[totalranks] in postbit?

Also - I'm using vbplaza for my points system. Normally when reputation is given the user receives vbplaza points. Now that I'm using the reputation given strictly by your mod - they are not getting vbplaza points when receiving a good (or negative for bad) ratings for posts. Any ideas?

There's no integration with vbplaza in this mod thus it wouldn't assign points. To make this work you would need to identify the code to add to vbplaza and bring that into the appropriate part of the mod.

[Bigj85]

I dont have the code in front me... try $thread[threadid] instead.

awesome,works great thanks Ted S :D

[tpearl5]

There's no integration with vbplaza in this mod thus it wouldn't assign points. To make this work you would need to identify the code to add to vbplaza and bring that into the appropriate part of the mod.
Right, but there's something missing between helpful answers giving reputation and giving regular reputation.

[Ted S]

Right, but there's something missing between helpful answers giving reputation and giving regular reputation.

Nope. There's nothing missing... There's simply different code used. The reputation page pulls in other elements this script doesn't need to pull in and this script pulls in elements it doesn't to insure everything is working properly.

What you would need to do is identify the plugin area vBplaza is calling and add it to the script as is necessary.

[furst]

Having someone rep someone for a post should also increase the post's helpful answer rating. This would be an improvement to the integration of the rep system.

[Milez]

Ted you mentioned earlier that in helpfulanswers.php we could print the username to the screen (which would be incredibly nice) but I don't think you are grabbing that from a quick look at the query. You're grabbing the userid though so maybe you could alter the query to reference the userlist table and get the username. Would really tie that page together and make it useful to see at a glance who uses the system.

SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalran k,helpfulpost.lastvote,thread.threadid,thread.titl e as title,forum.title as ftitle $helpful_selectby
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 goodrank > 0

Also is there anyway you could post the javascript to enhance our thumbs up/down with the greyed out image (I have these)? I would love to test this on my board.

[Ted S]

I assume the username you want to grab is for the person who posted. This I can definitely add in the next update.

As for the javascript I will be doing this once someone comes with a set of permissible use icons in grey and color format.

[TAIFUN_T]

Thx ..
But,

setting_helpans_stats_votes_title - Enable Profile Voting Stats - I
&
setting_helpans_stats_ranks_desc
If I On this functions ..adds a 20 query to the profile page

Enable Profile Voting Stats - I & Enable Profile Voting Stats - II

[Ted S]

What's a 20 query?

[TAIFUN_T]

queries to the database

[Milez]

I assume the username you want to grab is for the person who posted. This I can definitely add in the next update.

Hey thanks, that's exactly what I want! Added your thumbs images for you, they are transparent. See attached. Edit: Made them lighter.

Really looking forward to this update Ted :)

[Holf- Andrew]

I was wondering how i can uninstall this - I've uninstalled it through the Plugins & Products section in the Admin CP - but i am still getting it in the left hand side menu.

It is a great plugin - but i'm just finding it isn't needed for my forum.

[akonze]

BE AWARE! THIS THING CAN NOT BE UNINSTALLED!

I installed it and tried it out for my forum. Personally I did not find the design well and therefore I decided to stay with normal thread voting and the Thank Post addon. I then uninstalled this addon. It was removed from the addon list, but the section in the admin menu was not deleted. Now I have useless menu entries in the admin menu, which I can not get rid of. :-(

[Bigj85]

BE AWARE! THIS THING CAN NOT BE UNINSTALLED!

I installed it and tried it out for my forum. Personally I did not find the design well and therefore I decided to stay with normal thread voting and the Thank Post addon. I then uninstalled this addon. It was removed from the addon list, but the section in the admin menu was not deleted. Now I have useless menu entries in the admin menu, which I can not get rid of. :-(

BEWARE THIS POST CONTAINS COMMON SENSE
why dont you guys delete the files you uploaded for this mod,one of them is "cpnav_helpfulanswers.xml"
which is probably the file that makes the acp entry

[Simon Lloyd]

BEWARE THIS POST CONTAINS COMMON SENSE
why dont you guys delete the files you uploaded for this mod,one of them is "cpnav_helpfulanswers.xml"
which is probably the file that makes the acp entry
well said!, ;)

[peyman.nt]

How can I sort the posts by they rank?
while I using 10 points rank...
Like sorting by date,
Is it possible?

[Ted S]

BE AWARE! THIS THING CAN NOT BE UNINSTALLED!

I installed it and tried it out for my forum. Personally I did not find the design well and therefore I decided to stay with normal thread voting and the Thank Post addon. I then uninstalled this addon. It was removed from the addon list, but the section in the admin menu was not deleted. Now I have useless menu entries in the admin menu, which I can not get rid of. :-(

Please don't make assertions without at least asking for support first. This plugin can certainly be uninstalled. Have you removed the XML file or did you just disable the plugin?

[Ted S]

How can I sort the posts by they rank?
while I using 10 points rank...
Like sorting by date,
Is it possible?

Unfortunately there is no hook to alter how posts are sorted. You would have to hack your showthread page to manually make the edit.

[Ted S]

I was wondering how i can uninstall this - I've uninstalled it through the Plugins & Products section in the Admin CP - but i am still getting it in the left hand side menu.

It is a great plugin - but i'm just finding it isn't needed for my forum.

No problem. Not every addon is for everyone.

Be sure to remove all the upload files including the one in includes/xml to fully remove the addon.

[Ted S]

Hey thanks, that's exactly what I want! Added your thumbs images for you, they are transparent. See attached. Edit: Made them lighter.

Really looking forward to this update Ted :)

Awesome. I'll get the code out shortly.

[Milez]

Bigj85 that was hilarious :)

[Bigj85]

A few things I noticed about the extra variables you provided in your second post

This one used for highlighting the background
<if condition="$thread[toppost] == $post[postid]">background-color:#CCCCCC;</if>
also changes my private messages,I changed the messagearea with a blue background and it does the same thing to my pm message areas

Example (http://img242.imageshack.us/img242/9659/examplepm.jpg)

I fixed it for my board because I only use it for one thread by doing this
<if condition="$thread[toppost] == $post[postid] AND $thread[threadid] == 453">background-color:#375368;</if>
But you might wanna fix it for people who use it for more than I do

also the code to identify top rated post says
<if condition="$threadinfo[toppost] == $post[postid]">This is the top rated post!</code>

Shouldn't it say
<if condition="$thread[toppost] == $post[postid]">This is the top rated post!</if>
That's what worked for me but again it has to be changed or it shows in my private messages

[Ted S]

Thanks. I've been aware of these issues but lagged on updating the info post which has now been done.

[tpearl5]

Nope. There's nothing missing... There's simply different code used. The reputation page pulls in other elements this script doesn't need to pull in and this script pulls in elements it doesn't to insure everything is working properly.

What you would need to do is identify the plugin area vBplaza is calling and add it to the script as is necessary.

I see - unfortunately it's hard to see how vbplaza hooks into things since everything is encoded.

[Ted S]

question for Ted
How would i display the difference of $post[goodrank] - $post[badrank].

$post[overallrank]

[Ted S]

I've released 1.8.0 of this addon which is a small feature release.

The main purpose of this update is to introduce rollover rankings similar to what YouTube uses.

Rollover rankings can be enabled using the ratings dropdown option.

If you enable this option the template helpful_answers_roll will be used in place of helpful_answers. Please re-apply any customizations you may have made.

I have also updated the Top Helpful Answers page to include a new variable postusername as well as some hooks for other modifications.

1.9.0 will be coming next month and will include showing notifications when a post has been rated.

[DobieGillis?]

Noice Ted!

[tpearl5]

Ted - any ideas on using $post[helpfulgood] in forumdisplay and $helpfulposts[totalranks] in postbit?


Ted - did ya see that part?

Thanks again for this great hack.

[DobieGillis?]

hmmm.... downloaded the new version but there is a sub folder listed as Helpful Answers 1.7. Is this correct?

[Ted S]

hmmm.... downloaded the new version but there is a sub folder listed as Helpful Answers 1.7. Is this correct?

Didn't change the zip properly. I'll repost it later but you're using the right copy.

[Ted S]

Ted - did ya see that part?

Thanks again for this great hack.

Missed it.

What is your end goal with these variables in postbit?

[DobieGillis?]

Didn't change the zip properly. I'll repost it later but you're using the right copy.

gotcha, thanks!

[tpearl5]

Missed it.

What is your end goal with these variables in postbit?

To display the number of helpful posts a member has below their username.

[Ted S]

Each post is saved as a distinct record so displaying this would require a query for every post (figure 10-50 queries per page which is a bad, bad thing).

The alternative option would be to extend the addon to update a user's profile every time their post is rated to store this.

[tpearl5]

Yeh, my next question was going to be if that would add a lot of queries. If you could do it without adding a lot of overhead that would be awesome.

[Ted S]

It's not planned in the addon now but you certainly could extend things to update as I mentioned above.

[cellarius]

Hi Ted,

thanks for your work.

There might be a bug in the product file, tho: I tried to install, but the script threw a mysql error at me, saying there was no field "helpfulanswerid" in the fieldset of table "helpfulpost".
I checked and found that there had been no tables installed into my database and thought: Well, of course, there's no field if the tables did not get installed. So I looked at your product file and took out the mysql-CREATEs and created the tables in phpmyadmin.
I tried to install again, and yet again the script threw the same error at me, tho I was pretty sure the tables were created as they were supposed to be. Indeed, there was no such field in helpfulpost. After a closer look at your script, I was pretty sure that the line
SELECT COUNT(helpfulanswerid) as count FROM " . TABLE_PREFIX . "helpfulpostwas supposed to read
SELECT COUNT(helpfulanswerid) as count FROM " . TABLE_PREFIX . "helpfulansweri.e., the query was going to the wrong table. After changing this, I had no further problems installing, and the mod works just fine (at least, I did not find any errors up to now).

Another question concerning phrase helpfulanswer_postshavebeen. It reads "{1}'s Posts have been rated good {2} out of {3} times</span>". Is that </span>-Tag really supposed to be there?

Then I did a little modification to the helpful_answers_roll-Template. I was somewhat disappointed that there was no way to have icons when I want to allow only positive ratings (or did I miss something?). So I set the options to "Images - Thumbs with rollover" anyway and changed the template code as follows:

Find:

<if condition="$show['rate_helpfulanswer']">
<strong>$vbphrase[helpfulanswer_didyoufind] <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1">$vbphrase[helpfulanswer_yesidid]</a></strong>
</if>
Replace with:

<if condition="$show['rate_helpfulanswer']">
$vbphrase[helpfulanswer_didyoufind] <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 1);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup.gif';" onmouseout="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup_gray.gif';"><img name="post_$post[postid]_up" src="images/buttons/ha_thumbsup_gray.gif" width="11" height="20" border="0" alt="$vbphrase[helpfulanswer_yes]" align="absmiddle" /></a>

<if condition="$show['guest'] AND $vboptions['helpans_guestshow']">
$vbphrase[helpfulanswer_didyoufind]
<a href="./helpfulanswers.php?do=guestrate" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 1);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_up.src='images/buttons/ha_plus.png';" onmouseout="document.post_$post[postid]_up.src='images/buttons/ha_plus_gray.png';"><img name="post_$post[postid]_up" src="images/buttons/ha_plus_gray.png" width="20" height="20" border="0" alt="$vbphrase[helpfulanswer_yes]" align="absmiddle" /></a>
</if>
It will also show the green thumbsup for posts the user has already rated.

[Ted S]

Thanks for your two comments. I'm posting an updated verison to fix the install bug.

I'll look at the span tag later this evening.

[cellarius]

Hope you won't stone me, but in the template I edited, it seems to me that several <strong>-Tags are opened but never closed. Same in other templates. Not sure if I'm overlooking something.

Lines 131, 203, 222, 256, 262 in the .xml-file.

[Ted S]

Hope you won't stone me, but in the template I edited, it seems to me that several <strong>-Tags are opened but never closed. Same in other templates. Not sure if I'm overlooking something.

Lines 131, 203, 222, 256, 262 in the .xml-file.

Too many edits without doing a rebuild. These will be fixed in 1.8.1

[Ted S]

Hi Ted,

I was somewhat disappointed that there was no way to have icons when I want to allow only positive ratings (or did I miss something?). So I set the options to "Images - Thumbs with rollover" anyway and changed the template code as follows:


As you discovered there isn't an option to do thumbs up only by removing the thumbs down icon will get you pretty close.

To date no one else has requested this.

[Ted S]

I have posted version 1.8.1 which is a small update release fixing a bug in the installer and a few erroneous HTML tags. Updating is optional.

To upgrade replace the xml file only. No changes were made to any upload files.

[BehG]

Hi Ted,

We installed this hack and it wasn't what we were looking for, so we removed it. However, since then (actually even after we disabled the product and before we removed it), all our regular Vbulletin polls are getting redirected to other threads (either upong voting or through the edit poll function by MODS).

I'm just wondering if there's any part of this hack which would have modified the poll.php file or any of its functions to cause this problem . We did not have this issue before. Your help would be greatly appreciated as we're getting a lot of grif from our members now. :(

[landrewolsen72]

I installed version 1.7.0 on a system running vbulletin 3.8.2 and ran into a a small problem where the admin section could not find the postid.

I am new enough to vbulletin that this error could have been pilot error on my part, but I am posting the patch here in case it is useful to anyone else.

Thanks
-Andy

[Sworm]

Hi, great Hack!

There's some knowed issue if used with Post Thank You Hack?

[Ted S]

Hi Ted,

We installed this hack and it wasn't what we were looking for, so we removed it. However, since then (actually even after we disabled the product and before we removed it), all our regular Vbulletin polls are getting redirected to other threads (either upong voting or through the edit poll function by MODS).

I'm just wondering if there's any part of this hack which would have modified the poll.php file or any of its functions to cause this problem . We did not have this issue before. Your help would be greatly appreciated as we're getting a lot of grif from our members now. :(

Sorry to hear the addon wasn't right for you however there is nothing that should impact polls with this addon. Due to the method used for plugins once you removed the addon all code related to other files was removed from plugin locations.

I would suggest uploading the poll.php file again and testing a new poll to see what is incorrectly linking. If you want to PM me I may be able to try and help you run down the issue.

[Ted S]

Hi, great Hack!

There's some knowed issue if used with Post Thank You Hack?

There are no known conflicts that prevent either addon from working however because both addons use the same template hook there have been style complaints. If you dislike the style appearance you can get around this by enabling the manual template placement option with this addon and placing a variable in your postbit template where you want the ratings to show.

[Simon Lloyd]

I use the post thank you hack too and have no issues whatsoever, im using 3.8.2

[HighRollerX]

Where can I get that button set? I like them...lol.

[Ted S]

Where can I get that button set? I like them...lol.

The icons (thumbs) come included in the zip archive.

[Strike3ForumsMH]

Hi Ted,

Sorry if this has been covered before but I ran into this error:

Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO helpfulanswer
SET postid = 449290, userid = 4, yesno = '1', dateline = 1241158596, userid = 36;

MySQL Error : Column 'userid' specified twice
Error Number : 1110
Request Date : Friday, May 1st 2009 @ 02:16:36 AM
Error Date : Friday, May 1st 2009 @ 02:16:36 AM
Script : xxxxx/helpfulanswers.php
Referrer : xxxxx
IP Address : xxxxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community

Did I miss something or is it due to being on 3.8x? Sorry again if this has been covered.

Thanks.

- Reid

[Ted S]

Yikes. Looks like a bug in the code... I'm away from my main computer for a few days but will try to post a fix asap.

[Ted S]

1.8.2 has been released to fix a small bug in 1.8.1. Users with 1.8.1 should upgrade by uploading the file helpfulanswers.php. Users on earlier versions do not need to upgrade.

[Sworm]

Hi Ted, good work.

Last question before install....
I don't have seen the layout of the 10 point rank system....
This mode, is like the hack used in the vbseo.com forum , under the staff posts? "Have i helped you? Please rate my support"

In that forum, if anybody go to click on the link "Please Rate my support" , is showed a loading image that open a new part with the default vbulletin stars rating for the votes.....
98619

98620

Can i know if is the same hack or if there's some differences?

Thanks

[Ted S]

This is a different (or possibly custom) addon.

[Sworm]

Pls i'm not expert, can you cunstomize for do anything of similar?
If not possible, no there's a problem, i 'll use this great hack :)

Thanks for your work

[Ted S]

This addon does not accomplish that functionality and would have to be modified to do so. If you are not a coder or do not have a coder I suggest you look at the suggest a hack forum.

[Quantnet]

Just installed 1.8.2 and here are my comments
1) After voting, the ajax does not seem to reload the result automatically. it will show 2 gray thumbs. If i reload the page, the correct result will display.
2) I disable guest voting so under every post, there is some small spacing where the "did you find helpful" located.
I thought we took care of that issue a few versions back.

Nice job as always.

[Ted S]

1 - Have you reverted your templates to be sure no custom changes are having impact?

2 - I'll take a look next week.

[Simon Lloyd]

Ted, do we only need to upload the latest xml to upgrade or everything?

[Ted S]

That depends on what version you have. The last few updates have been XML changes but I'd suggest uploading the file upload/helpfulanswers.php as well

[Simon Lloyd]

That depends on what version you have. The last few updates have been XML changes but I'd suggest uploading the file upload/helpfulanswers.php as well
i have 1.8.1, 'm just a little wary of uploading all the files as i don't want to lose the data (dated helpful answers) that i have now.

[Milez]

Ted,

Finally got around to testing 1.8.2 and had 1 issues:

- I think you forgot to add the code to helpfulanswers.php to show the username of the user who received the rep. If you could also grab the user who gave rep that might be pretty cool too. For now I would take either!

[Ted S]

i have 1.8.1, 'm just a little wary of uploading all the files as i don't want to lose the data (dated helpful answers) that i have now.

Uploading php files won't change your data.

[Ted S]

Ted,

Finally got around to testing 1.8.2 and had 1 issues:

- I think you forgot to add the code to helpfulanswers.php to show the username of the user who received the rep. If you could also grab the user who gave rep that might be pretty cool too. For now I would take either!

The code is there. Using the variable is up to you.

[vbuser99]

Ted, could you add a feature/option to highlight the highest rated post? That would be great!

[Ted S]

Ted, could you add a feature/option to highlight the highest rated post? That would be great!

This already exists. See the first post.

[Wizardjv]

I get page not found when clicking the buttons, but when you copy the location of the link and paste it in the browser it works. Any idea why it would be doing that?

[vbuser99]

This already exists. See the first post.

Thanks Ted, got it.

May be I missed in between hundreds of messages, is there an option to exclude users being rated. To give an example we have a bot that does auto message posting we do not want it to be rated at all.

Great add-on again! Thanks.

[Ted S]

Thanks Ted, got it.

May be I missed in between hundreds of messages, is there an option to exclude users being rated. To give an example we have a bot that does auto message posting we do not want it to be rated at all.

Great add-on again! Thanks.

There is not. However you could use a simple conditional to do this manually.

[Ted S]

I get page not found when clicking the buttons, but when you copy the location of the link and paste it in the browser it works. Any idea why it would be doing that?

Are you using an SEO solution of any sort? Are your forums in a sub folder or the main folder?

[edenx]

Coool Mod!

1. How can I highlight all posts with Helpful > Number ?

2. Will you support this for VB 4.0 ?

[Ted S]

1. How can I highlight all posts with Helpful > Number ?

You can use the variables show in the first post to do this with template conditionals.

2. Will you support this for VB 4.0 ?

Vbulletin 4.0 does not exist to the public yet. I plan to upgrade this addon for it but can't speak to something I have no access to in any detail.

[Strike3ForumsMH]

Ted, your fix (the latest version) fixed my problem 100%, so thank you.

I did have a few suggestions, notably on the helpfulanswers.php page:
1. For the layout, remove the "Post xxxxxin thread *threadtitle* and change it to "*threadtitle by *username*" linking to the post of course. I know this is possible with a few edits, but I think it gives a more friendly look to the page for users that you might want to consider.
2. Add a filter to the helpfulanswers.php page to allow users to either see the most helpfulanswers by either a time measure (last 24 hours, week, etc) or by a threshold of votes (only answers with 5 +'s or whatever.)
3. Right now the helpfulanswers.php page does not consider usergroup permissions. And while if someone clicks on a thread they can't access and that won't change, they do see the thread title, obviously if there is a private forum with sensitive info, this could be a problem. And I do realize that you can enable/disable on a per forum basis, but I really would like this enabled through out my forum.

Anywho, this is a great modification and I just wanted to share this with you as food for thought. I am actually using this in replacement of the traditional reputation system. Thanks for such a great mod Ted.

[vbuser99]

There is not. However you could use a simple conditional to do this manually.

Yep, you are right. it is working great.

[Strike3ForumsMH]

Ted, this is probably a conflict on my forum but I was wondering if you could help. I can give positive reputation fine but negative reputation results in a db error:

Database error in vBulletin 3.8.2:

Invalid SQL:



INSERT IGNORE INTO reputation (postid, reputation, userid, whoadded, reason, dateline)

VALUES (159963, -111, 307, 4, 'They totally didn't like this.' ,'1242494793');

MySQL Error : 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 't like this.' ,'1242494793')' at line 2
Error Number : 1064
Request Date : Saturday, May 16th 2009 @ 01:26:33 PM
Error Date : Saturday, May 16th 2009 @ 01:26:33 PM
Script : /forums/helpfulanswers.php

Any ideas?

Also, another suggestion: allow users to change their vote on the postbit, in case they clicked the wrong button or misunderstood the post.

[Strike3ForumsMH]

Ok, I played around to the point that I don't know what solved it. BUT, I installed the new version of Display Unread Posts and Reputation Comments by Paul M and the error did go away. However, for me anyway, negative reputation given by myself is not showing up under that mod but positive reputation is. Obviously not a big deal and you can't ensure compatibility with all mods, but in case there is anything to that (that it isn't just a problem for me), I wanted to let you know Ted.

[Raptor]

I made some nicer thumbs (you will need to change the helpful_answers_roll template to:



<if condition="$show['helpfulanswer']">
<div id="helpfulanswers_box_$post[postid]">
<br /><hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<if condition="$vboptions[helpans_neg]">

<if condition="$post['totalrank']">
<phrase 1="$post[goodrank]" 2="$post[totalrank]">$vbphrase[helpfulanswer_x_out_of_y]</phrase>
</if>

<if condition="$show['rate_helpfulanswer']">

<strong>$vbphrase[helpfulanswer_didyoufind]</strong>
<a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 1);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup.gif';" onmouseout="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup_gray.gif';"><img name="post_$post[postid]_up" src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" /></a> |
<a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=0" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 0);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn.gif';" onmouseout="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn_gray.gif';"><img name="post_$post[postid]_dn" src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" /></a>

<else />
<if condition="$post[helpfulanswerid] AND !$show[guest]">

<if condition="$post[yesno]">
<img src="images/buttons/ha_thumbsup.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
<img src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
<else />
<img src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
<img src="images/buttons/ha_thumbsdn.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
</if>

</if>
</if>

<if condition="$show['guest'] AND $vboptions['helpans_guestshow']">
<strong>$vbphrase[helpfulanswer_didyoufind]</strong>
<a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_yes</a> |
<a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_no</a>
</if>

<else />

<if condition="$post['totalrank']">
<phrase 1="$post[goodrank]">$vbphrase[helpfulanswer_x_found]</phrase>
</if>

<if condition="$show['rate_helpfulanswer']">
<strong>$vbphrase[helpfulanswer_didyoufind] <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1">$vbphrase[helpfulanswer_yesidid]</a></strong>
</if>

</if>

</div>
</if>

[Raptor]

I need the option to vote to only show on the first post - how do I do that ?

[Ted S]

I need the option to vote to only show on the first post - how do I do that ?

Use a template conditional for firstpostid and the current postid.

[Ted S]

Ted, this is probably a conflict on my forum but I was wondering if you could help. I can give positive reputation fine but negative reputation results in a db error:

You modified the phrase to include a single quote (don't). Try adding a \ before the '.


Also, another suggestion: allow users to change their vote on the postbit, in case they clicked the wrong button or misunderstood the post.

Thanks for the idea.

[Ted S]

I made some nicer thumbs (you will need to change the helpful_answers_roll template to:


Thanks for providing these. As an alternative to template changes they can simply be renamed to match the existing thumb icons.

[Ted S]

Ok, I played around to the point that I don't know what solved it. BUT, I installed the new version of Display Unread Posts and Reputation Comments by Paul M and the error did go away. However, for me anyway, negative reputation given by myself is not showing up under that mod but positive reputation is. Obviously not a big deal and you can't ensure compatibility with all mods, but in case there is anything to that (that it isn't just a problem for me), I wanted to let you know Ted.

Thanks. I don't have experience with those addons but will take a look.

[Raptor]

Use a template conditional for firstpostid and the current postid.

could you please let me know what that conditional code is exactley? thanks

[Raptor]

Thanks for providing these. As an alternative to template changes they can simply be renamed to match the existing thumb icons.

no - it was the sizes that were changed as the image sizes were specified in the template.

[Ted S]

Actually there's a better way to reduce server load with this...

Open up the XML file and find:


if($this->registry->options['helpans_hidefirst'] AND $this->post['postid'] == $this->thread['firstpostid']){
$show['helpfulanswer'] = false;
$show['rate_helpfulanswer'] = false;
}


Change that to:


if($this->post['postid'] != $this->thread['firstpostid']){
$show['helpfulanswer'] = false;
$show['rate_helpfulanswer'] = false;
}


Now only the first post will show ratings.

[Ted S]

no - it was the sizes that were changed as the image sizes were specified in the template.

My mistake! I'll have to make those variable defined if people continue adding images.

[Milez]

I love this mod but I would just like to echo these 3 suggestions as they are my only real problems:

1. For the layout, remove the "Post xxxxxin thread *threadtitle* and change it to "*threadtitle by *username*" linking to the post of course. I know this is possible with a few edits, but I think it gives a more friendly look to the page for users that you might want to consider.

2. Add a filter to the helpfulanswers.php page to allow users to either see the most helpfulanswers by either a time measure (last 24 hours, week, etc) or by a threshold of votes (only answers with 5 +'s or whatever.)

3. Right now the helpfulanswers.php page does not consider usergroup permissions. And while if someone clicks on a thread they can't access and that won't change, they do see the thread title, obviously if there is a private forum with sensitive info, this could be a problem. And I do realize that you can enable/disable on a per forum basis, but I really would like this enabled through out my forum.

[Ted S]

1. For the layout, remove the "Post xxxxxin thread *threadtitle* and change it to "*threadtitle by *username*" linking to the post of course. I know this is possible with a few edits, but I think it gives a more friendly look to the page for users that you might want to consider.


Suggestion noted. Thanks (seriously)


2. Add a filter to the helpfulanswers.php page to allow users to either see the most helpfulanswers by either a time measure (last 24 hours, week, etc) or by a threshold of votes (only answers with 5 +'s or whatever.)


Good ideas as well. I will have to look at the impact on load of each. I did play with the time limit before and stopped. Something to revist.


3. Right now the helpfulanswers.php page does not consider usergroup permissions. And while if someone clicks on a thread they can't access and that won't change, they do see the thread title, obviously if there is a private forum with sensitive info, this could be a problem. And I do realize that you can enable/disable on a per forum basis, but I really would like this enabled through out my forum.

Absolutely. Never thought of this issue but it's very important. I'll see if I can get permissions built in smoothly.

[tpearl5]

FYI, anyone wanting this to work with vbplaza: http://www.vbplaza.com/forum/showthread.php?p=6359

:)

[kawe]

how to make thumbs appear like this https://vborg.vbsupport.ru/attachment.php?attachmentid=95493&d=1235590687

[Ted S]

how to make thumbs appear like this https://vborg.vbsupport.ru/attachment.php?attachmentid=95493&d=1235590687

Use the option you want from the vbulletin options page.

[Ted S]

FYI, anyone wanting this to work with vbplaza: http://www.vbplaza.com/forum/showthread.php?p=6359

:)

Awesome. I'll see if I can get this integrated without breaking things for users without vbPlaza

[kawe]

Use the option you want from the vbulletin options page.

not work sir :(

[Ted S]

How does it not work?

[Theater]

I made some nicer thumbs (you will need to change the helpful_answers_roll template to:



<if condition="$show['helpfulanswer']">
<div id="helpfulanswers_box_$post[postid]">
<br /><hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<if condition="$vboptions[helpans_neg]">

<if condition="$post['totalrank']">
<phrase 1="$post[goodrank]" 2="$post[totalrank]">$vbphrase[helpfulanswer_x_out_of_y]</phrase>
</if>

<if condition="$show['rate_helpfulanswer']">

<strong>$vbphrase[helpfulanswer_didyoufind]</strong>
<a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 1);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup.gif';" onmouseout="document.post_$post[postid]_up.src='images/buttons/ha_thumbsup_gray.gif';"><img name="post_$post[postid]_up" src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" /></a> |
<a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=0" <if condition="$vboptions[disable_ajax] != 2"> onclick="return helpfulanswers_rate($post[postid], 0);" </if> rel="nofollow" onmouseover="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn.gif';" onmouseout="document.post_$post[postid]_dn.src='images/buttons/ha_thumbsdn_gray.gif';"><img name="post_$post[postid]_dn" src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" /></a>

<else />
<if condition="$post[helpfulanswerid] AND !$show[guest]">

<if condition="$post[yesno]">
<img src="images/buttons/ha_thumbsup.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
<img src="images/buttons/ha_thumbsdn_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
<else />
<img src="images/buttons/ha_thumbsup_gray.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_yes]" />
<img src="images/buttons/ha_thumbsdn.gif" width="16" height="18" border="0" alt="$vbphrase[helpfulanswer_no]" />
</if>

</if>
</if>

<if condition="$show['guest'] AND $vboptions['helpans_guestshow']">
<strong>$vbphrase[helpfulanswer_didyoufind]</strong>
<a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_yes</a> |
<a href="./helpfulanswers.php?do=guestrate" rel="nofollow">$helpfulanswer_no</a>
</if>

<else />

<if condition="$post['totalrank']">
<phrase 1="$post[goodrank]">$vbphrase[helpfulanswer_x_found]</phrase>
</if>

<if condition="$show['rate_helpfulanswer']">
<strong>$vbphrase[helpfulanswer_didyoufind] <a href="./helpfulanswers.php?do=rate&postid=$post[postid]&rank=1">$vbphrase[helpfulanswer_yesidid]</a></strong>
</if>

</if>

</div>
</if>




Thank you! These look great on my forum. :cool:

[Quantnet]

When I enable display rating for guests, it shows the Rating Display: Text Yes/No while I chose the rating display Thumb with rollover.
How do I make display for guests same as the setting I chose over all (thumb with rollover)

[Trana]

I finally got this to work properly.

Is there a way to display which threads have the highest total votes in all their posts?

Has anyone created a CMPS module for showing the results?

[Ted S]

When I enable display rating for guests, it shows the Rating Display: Text Yes/No while I chose the rating display Thumb with rollover.
How do I make display for guests same as the setting I chose over all (thumb with rollover)

Try using an image option besides rollovers.

[Ted S]

Is there a way to display which threads have the highest total votes in all their posts?

The mod does not do this at this time.

[Trana]

How about the ability to rate just the threads themselves?

[Ted S]

This system is for post rating. vBulletin includes a thread rating system.

[Veer]

Is there any option available to enable this mod on selective forum IDs? because I don't like to have this mod enabled on all forums.

thanks.

[Ted S]

Is there any option available to enable this mod on selective forum IDs? because I don't like to have this mod enabled on all forums.


Yes.

[EagleNick]

It doesn't seem to be awarding reputation points for marking a post as "helpful". I have ensured my settings are set correctly.
Is there a way to check and see if is indeed working properly?

Related but different: Does rebuilding reputation via the Maintenance manager also factor in 'helpful' posts? Also, with the Post Thanks mod, I can see in the Reputation Comments manager when a post has been thanked, and users can see it in their UserCP as well in the reputation section; does this mod include similar functionality?

[Ted S]

It doesn't seem to be awarding reputation points for marking a post as "helpful". I have ensured my settings are set correctly.
Is there a way to check and see if is indeed working properly?


Are you using any rep related mods?


Related but different: Does rebuilding reputation via the Maintenance manager also factor in 'helpful' posts?

No. Reputation does not seed back into helpful answer ratings.


Also, with the Post Thanks mod, I can see in the Reputation Comments manager when a post has been thanked, and users can see it in their UserCP as well in the reputation section; does this mod include similar functionality?

There is an admin log for all helpful answer ratings. There is not a user log to see who has rated their post.

[EagleNick]

Are you using any rep related mods?
Nope.

No. Reputation does not seed back into helpful answer ratings.

So if I were to rebuild reputation, all of the points accrued by posts marked as helpful would be essentially lost - permanently?

There is an admin log for all helpful answer ratings. There is not a user log to see who has rated their post.

Can this be turned into a feature suggestion, to work just like the Post Thanks hack? ;)


And thank you for the prompt response; it's something that not too many coders offer anymore.

[Ted S]

So if I were to rebuild reputation, all of the points accrued by posts marked as helpful would be essentially lost - permanently?

Not sure why you would think that would happen. The two systems do not overlap so rebuilding one will not reset the other.

Can this be turned into a feature suggestion, to work just like the Post Thanks hack?

Please send me a link or image of what you're thinking of so I can see how this mod would produce something similar.


And thank you for the prompt response; it's something that not too many coders offer anymore.

I do my best as do many coders but you have to forgive us, there's a lot of demand and the pay stinks. :D

[Ted S]

And for the rep system, I'll post an updated script that lets you debug.

[EagleNick]

Ted, to follow up, this definitely isn't working properly.

- I checked my profile and have had my posts marked as helpful 14 times: Nick's Posts have been rated good 14 out of 14 times.- I checked my UserCP and have 46 reputation points.

- I checked the Reputation Comments log in the AdminCP for all reputation given to me. On three occasions, I have been reputed earning me 2, 15, and 19 points. Adding in the fact that all users start out with 10 points, this equates to 46. Therefore, I am not earning any reputation points by having my posts marked as helpful.

- So maybe my settings aren't configured properly. You tell me:
1- http://i475.photobucket.com/albums/rr112/NickR25/screen1-1.png
2- http://i475.photobucket.com/albums/rr112/NickR25/screen2-1.png

I am baffled as to why this isn't working properly.

Another issue we're having is that post authors cannot see the rating on their posts. I have self-rating disabled, but shouldn't I be able to see, "2 of 2 users found this post helpful" on my own posts? Or is that not a feature?

[Ted S]

EagleNick,

I'm not sure what's going wrong so let's try debugging.

Please install the attached version and try repping a post. You should see some new text with debug messages.

Copy this and revert to your current version of the addon.

We can go from there.

[EagleNick]

This is the only text that came up (in addition to the "thank you for rating" etc.): no reuptation...

[Ted S]

Ok. That means the code was not activated. I'm on the road but will provide next steps asap

[EagleNick]

Ok. That means the code was not activated. I'm on the road but will provide next steps asap
Great, Ted - I really appreciate your assistance. ;)

[Ted S]

There's 3 things that would cause the code not to activate:

1 - Reputation is not enabled in your admin.

2 - Reputation in the mod is is not enabled.

3 - You're rating your own posts.

This version will tell us what's up.

[EagleNick]

There's 3 things that would cause the code not to activate:

1 - Reputation is not enabled in your admin.

2 - Reputation in the mod is is not enabled.

3 - You're rating your own posts.

This version will tell us what's up.
Thanks, Ted. Here's the text: no reuptation:-1-1-40!

[Ted S]

Are you tryin to rate your own post?

[EagleNick]

Are you tryin to rate your own post?
No. That's not even possible, as the buttons don't appear on my own posts.

Would you like admin access? Would it help figure this out quicker?

[dieKetzer]

very nice. much less passive-aggressive potential than the other options.

[Ted S]

No. That's not even possible, as the buttons don't appear on my own posts.

Would you like admin access? Would it help figure this out quicker?

Some people enable it so it is possible... But got it.

I'll review the code again and get back to you in a few. My appologies for this taking so much time.

[EagleNick]

Some people enable it so it is possible... But got it.

I'll review the code again and get back to you in a few. My appologies for this taking so much time.
I know it's an option but I meant that in my specific case, it isn't possible since I don't have it enabled.

No worries. This is baffling to us both. I just hope we can get it resolved no matter how much time it takes. :)
I appreciate you working with me on this. ;)

[cheesegrits]

Tiny gripe ...

If negative ratings are not enabled, icons aren't used for the "Yes I did" button (i.e. it ignores the Rating Display setting in ACP).

Of course we can tweak that ourselves (near the bottom of the helpful_answers template) ... just seems like it shouldn't matter if negative ratings are enabled or not ... If I select 'icons' for the Rating Display, I still want a Green Thumb.

-- hugh

[Ted S]

Thanks for the suggestion. I agree and will see that the next release reflects that.

[cheesegrits]

Thanks!

BTW, am I imagining it, or is the hooks XML missing from the ZIP?

I just went to add a helpfulanswers_top_query plugin so I can add forumid to the field list ... but the hooks ain't there in vB ... just the fectch_hook() calls in the code.

-- hugh

[Ted S]

Maybe I'm missing something..... I see the hook locations in the zip file. Is there something else needed to trigger them that you're not seeing?

[Ted S]

I know it's an option but I meant that in my specific case, it isn't possible since I don't have it enabled.

No worries. This is baffling to us both. I just hope we can get it resolved no matter how much time it takes. :)
I appreciate you working with me on this. ;)

Please try this version.

[EagleNick]

Please try this version.
Now it says: reuptation...2...

[Ted S]

Is it updating scores properly? Or at all?

[EagleNick]

Is it updating scores properly? Or at all?
Yep, it works now! It even shows up in the "View Reputation Comments" section of the Reputation manager in the AdminCP. :cool:

Is there a way to make it go back and add the reputation points for all "marked as helpful" posts, because only posts marked as helpful after I installed the updated/debugging version give points. If not, then no biggie. At least it's working now.

So now we just need a version that doesn't show the code when rating a post. :)

[Ted S]

It would be possible to update posts retroactively but I haven't tested a script to do this and wouldn't want to do so "live". I'd suggest rolling from now forward.

Look for the official update in a few minutes (without the debug lines).

[Ted S]

1.8.3 Has been released.

This is a small bug fix which addresses two issues:
- Fixes problems with the reputation module not working
- Fixes problems with disabling negative voting and using different rating styles

To update just upload the xml file to your Admin CP. No changes have been made to script files.

[EagleNick]

You're the best, Ted. Thanks!

[digicom]

Apprciated for update Ted :up:

[Dreykan]

I cannot get this mod to work. When a user hits the Yes button all he gets is a popup window.

Is there any way I can unistall this?

Thanks

[Ted S]

Yes, use the uninstall feature and delete the files.

[cooltechie]

Does this mod work with vbexperience's CDP?

[Ted S]

Does this mod work with vbexperience's CDP?

I have not used that mod so you would to test it yourself.

[bjkinzluvr]

I'm sorry if this had been asked and answered, but I couldn't find it. If I enable the most helpful answers to "Displays a page of the top answers (posts) based on overall votes." where does this page display? Where may I find it? Thanks.

[Ted S]

<a href="http://www.yoursite.com/helpfulanswers.php" target="_blank">www.yoursite.com/helpfulanswers.php</a>

[wastemytime]

Hello,

i get this error (a big Pop-Up Window), if i want to rate somebody:

Invalid SQL:


INSERT INTO vb_helpfulanswer
SET postid = 204968, userid = 1, yesno = '1', dateline = 1244503437, userid = 1197;

MySQL-Fehler : Column 'userid' specified twice

[bjkinzluvr]

www.yoursite.com/helpfulanswers.php (http://www.yoursite.com/helpfulanswers.php)

I don't understand this answer. It is just an advertising page for web hosting . . . ???

1. I need to know where the list of helpful answers displays when enabled. Thank you.

2. Also, I am getting a pop up error when trying to give a thumbs-up:
(I downloaded and installed your latest version today and I run vbulletin 3.8.2)

http://kinzcommunity.com/images/Mine/HelpfulError.jpg

[Ted S]

I don't understand this answer. It is just an advertising page for web hosting . . . ???

Ads? This modification has nothing to do with ads so those would be something on your side.


1. I need to know where the list of helpful answers displays when enabled. Thank you.


The file is helpfulanswers.php and exists whereever you uploaded it.


2. Also, I am getting a pop up error when trying to give a thumbs-up:
(I downloaded and installed your latest version today and I run vbulletin 3.8.2)


Your popup shows that there was an error but not what it was. You will need to tell me the database error for me to be of help.

[Ted S]

Hello,

i get this error (a big Pop-Up Window), if i want to rate somebody:

Invalid SQL:


INSERT INTO vb_helpfulanswer
SET postid = 204968, userid = 1, yesno = '1', dateline = 1244503437, userid = 1197;

MySQL-Fehler : Column 'userid' specified twice


Yikes. This was fixed a while back but it looks like I broke it again. Please upload helpfulanswers.php from the 1.8.4 zip file now posted.

[Ted S]

Version 1.8.4 has been released which fixes an SQL bug. This bug was introduced in 1.8.3 when I used an old version of a query. Users who did not upload helpfulanswers.php will not be impacted.

To upgrade upload helpfulanswers.php. You can update the plugin file as well to change the version number although this is not required.

[bjkinzluvr]

Your popup shows that there was an error but not what it was. You will need to tell me the database error for me to be of help.

The image I gave you is all I had, but I looked after you posted this and found emails that were sent automatically from my database. Here is the error information. I got this over and over:
Database error in vBulletin 3.8.2:

Invalid SQL:

INSERT INTO helpfulanswer
SET postid = 45648, userid = 444, yesno = '1', dateline = 1244505618, userid = 421;

MySQL Error : Column 'userid' specified twice
Error Number : 1110
Request Date : Monday, June 8th 2009 @ 08:00:18 PM
Error Date : Monday, June 8th 2009 @ 08:00:18 PM
Script : http://kinzcommunity.com/helpfulanswers.php
Referrer : http://kinzcommunity.com/showthread.php?t=3824
IP Address :
Username :
Classname : vb_database


I would appreciate any help you can give. Thanks.

[Ted S]

Perfect. This was fixed in the update release today. Apply it and you should be all set.

[sockwater]

I'm sorry if this had been asked and answered, but I couldn't find it. If I enable the most helpful answers to "Displays a page of the top answers (posts) based on overall votes." where does this page display? Where may I find it? Thanks.

www.yoursite.com/helpfulanswers.php (http://www.yoursite.com/helpfulanswers.php)

I don't understand this answer. It is just an advertising page for web hosting . . . ???

1. I need to know where the list of helpful answers displays when enabled. Thank you.


Ads? This modification has nothing to do with ads so those would be something on your side.

The file is helpfulanswers.php and exists whereever you uploaded it.


bjkinzluvr, don't go to www.yoursite.com/helpfulanswers.php (http://www.yoursite.com/helpfulanswers.php), go to WHATEVER-YOUR-SITE-IS/helpfulanswers.php

[Simon Lloyd]

Perfect. This was fixed in the update release today. Apply it and you should be all set.
Ted is it just the xml or are there some php script changes?

[Ted S]

Ted is it just the xml or are there some php script changes?

It's the main php script (helpfulanswers.php) as well.

[Quantnet]

What are the updates in 1.8.3?

[Ted S]

What are the updates in 1.8.3?

1.8.3 and 1.8.4 both contain bug fixes.

[mariocaz]

Hi Ted

To update only I have to upload and reoverwrite the product in my ACP ?

Thank you!

Mario

[Ted S]

Wh version are you updating from?

[mariocaz]

1.8.1

[Ted S]

You'll need to update both the XML file and the upload/helpfulanswers.php file,

[ctrlbrk]

Hi,

I am brand new to vbulletin so I apologize. I read through many posts but could not find this. I am sure it is here, but maybe someone would be so kind to repeat.

What code can I place in postbit so that under the "Posts: xx" display it will show "Thanked: xx times"? I want it so if it is 0 (zero) nothing is shown, otherwise it would say "Thanked: 3 times" etc. This is the total number of times the user has been thanked across ALL posts.

Thank you.
Mike

[Ted S]

Mike there is not support for that level of reporting in this addon

[ctrlbrk]

Mike there is not support for that level of reporting in this addon

Thank you Ted. You have an excellent product here. Do you think this may be added in a future version or perhaps I am missing some other add-on?

Have a good one,
Mike

[Ted S]

It's in the roadmap but not something you will likely see in the next few weeks

[NLP-er]

Hi, what I need to do to have some link in nav bar to most rated posts?

[Saviour]

Nice...me likey...marks Installed.

Have a question about the Most Helpful Answers page, though. I notice that in the Posts column...it will list the title of the thread.

Anyway to limit the amount of characters for the thread title in this column?

Also...it would seem the Forum title and Average Rating column content is not centered in the column. Can ya fix this?

I also have one last question. I'd like to include a "top of page image" within the table that calls the info for user votes on a thread/post. What do I edit to include this?

Thanks, bunches, for this mod. Replaces the post thank you/groan for my Articles forum...

[Ted S]

Hi, what I need to do to have some link in nav bar to most rated posts?

edit the navbar template and add the link

[Ted S]

Have a question about the Most Helpful Answers page, though. I notice that in the Posts column...it will list the title of the thread.

Anyway to limit the amount of characters for the thread title in this column?


In helpfulanswers.php find:


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

and change it to:


SELECT post.postid,LEFT(post.title,35) 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

Where 35 is the number of characters to grab.


Also...it would seem the Forum title and Average Rating column content is not centered in the column. Can ya fix this?


Odd. The cables cells are set to center. Is this the data results or the header?


I also have one last question. I'd like to include a "top of page image" within the table that calls the info for user votes on a thread/post. What do I edit to include this?


I'm not sure what you mean. Can you elaborate?

[Saviour]

Did a search for the text you said look for...it's not found in the helpfulanswers.php file.

Found this, though:

SELECT post.postid,post.goodrank,post.totalrank
FROM post as post
WHERE totalrank > 0
");

Also...I'm referring to centering the data results for those two columns...they don't look like they are centered.

[Saviour]

post.title

...is not located in the file you're referring to.

[cheesegrits]

Maybe I'm missing something..... I see the hook locations in the zip file. Is there something else needed to trigger them that you're not seeing?

There's no ./includes/xml/hooks_helpfulanswers.xml, so your hooks don't show up in the available hooks list when creating a plugin.

Like this:

<?xml version="1.0" encoding="ISO-8859-1"?>
<hooks>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_start</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_query</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_loop</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_done</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_prerate</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_dorate</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_show_ajax</hook>
</hooktype>
</hooks>

-- hugh

[Saviour]

post.title

...is not located in the file you're referring to.


My bad...was looking at the wrong file...found it. Made the change...and that's okay. Problem is the data in the two columns I referred to are still not centered. The table headers are...but the data in the column is not.

[Ted S]

You can edit the templates controlling the layout to align it as you see fit.

[Ted S]

There's no ./includes/xml/hooks_helpfulanswers.xml, so your hooks don't show up in the available hooks list when creating a plugin.

Like this:

<?xml version="1.0" encoding="ISO-8859-1"?>
<hooks>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_start</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_query</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_loop</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_top_done</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_prerate</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_dorate</hook>
</hooktype>
<hooktype type="helpfulanswers">
<hook>helpfulanswers_show_ajax</hook>
</hooktype>
</hooks>

-- hugh

Ooooh.... Great pointer. I'll see that this gets updated this week.

[Simon Lloyd]

Hi, what I need to do to have some link in nav bar to most rated posts?
in your navbar template you can use the following:
find<if condition="$show['member']">
<td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>
</if> and underneath add<if condition="$show['member']">
<td class="vbmenu_control"><a href="http://www.yoursite.com/forum/helpfulanswers.php">Helpful Answers</a></td>
</if> Hope that helps!

[NLP-er]

edit the navbar template and add the link

To what address?...

[Simon Lloyd]

NLP-er i have guven you what you need!, just replace yoursite.com with your actual site and if you do not have a forum folder or the helpful answers software is not in a forum folder then omit the forum/

[cheesegrits]

Ooooh.... Great pointer. I'll see that this gets updated this week.

Thanks.

FYI, I just wrote a "Helpful Answers for vbCredits" mod, first cut of it is here:

http://www.vbcredits.com/forum/showthread.php?p=17117#post17117

It's something I needed for myself, but I saw somebody else had requested it, so I posted it. I'm not that wild about supporting it in the long run, though. Once it is debugged and any additional features added, would you be interested in taking it over?

-- hugh

[Ted S]

To what address?...

helpfulanswers.php

[Ted S]

Thanks.

FYI, I just wrote a "Helpful Answers for vbCredits" mod, first cut of it is here:

http://www.vbcredits.com/forum/showthread.php?p=17117#post17117

It's something I needed for myself, but I saw somebody else had requested it, so I posted it. I'm not that wild about supporting it in the long run, though. Once it is debugged and any additional features added, would you be interested in taking it over?

-- hugh

Hugh,

Thanks for releasing this! I don't work with vBcredits so while I'd love to help out I'm probably not the best person to lend any support on this versus someone who knows that tool.

[NLP-er]

NLP-er i have guven you what you need!, just replace yoursite.com with your actual site and if you do not have a forum folder or the helpful answers software is not in a forum folder then omit the forum/

Sorry I miss your post ;) Great thanks!

[Kintaro81]

Just hide the lowest post or maybe more control...

- hide posts that are negative
- set a min votes before hiding
- let a user unhide

is it possibile with the current version of Helpful Answers?

[Ted S]

is it possibile with the current version of Helpful Answers?

Possible with some work on your end, not out of the box.

[cheesegrits]

Ted,

Just noticed your uninstall code is missing the closing ` on table names in the DROP statements.

-- hugh

[cheesegrits]

Hugh,

Thanks for releasing this! I don't work with vBcredits so while I'd love to help out I'm probably not the best person to lend any support on this versus someone who knows that tool.

There's really nothing to it. Basically just a simple product XML, with a single plugin on one of your hooks that looks at your $helpful setting, and either adds or deducts X amount of credits for the poster, and adds Y amount to the logged on user (i.e. incentive for using Helpful Answers). Plus the usergroup settings for the X and Y values.

Ah well, it was a long shot anyway. I'm just being lazy. :)

-- hugh

[Ted S]

I've got no problem watching that if it's posted here. Don't make it to other sites much though...

[scabbed]

hello, thanks for this great hack

i have a little question, i would like to know if its possible to show the usefull post under the first post of the thread, so people will have the best answer fast and they don't have to read the all thread to see all members ideas

here is a little screen of what i was thinking about, sry for my english, it's not my native language.

http://img526.imageshack.us/img526/5343/sanstitre3j.jpg

thanks in advance

[ragarcia87]

I love this addon :D I have it installed but I was wondering if I could have it enabled for only a certain thread? I dont need it to be enabled on a whole forum. Thank you.

[Ted S]

hello, thanks for this great hack

i have a little question, i would like to know if its possible to show the usefull post under the first post of the thread, so people will have the best answer fast and they don't have to read the all thread to see all members ideas

here is a little screen of what i was thinking about, sry for my english, it's not my native language.

http://img526.imageshack.us/img526/5343/sanstitre3j.jpg

thanks in advance

You could do this with some template hacks. The variables to show this information are all in the first post.

I will probably add something like this to version 1.9

[Ted S]

I love this addon :D I have it installed but I was wondering if I could have it enabled for only a certain thread? I dont need it to be enabled on a whole forum. Thank you.

You can use template conditionals to limit the display to just one thread.

[scabbed]

You could do this with some template hacks. The variables to show this information are all in the first post.

I will probably add something like this to version 1.9

hello, thanks for the answer

i think i must add this code somewhere in the postbit ??

<if condition="$thread[toppost] == $post[postid] AND THIS_SCRIPT == 'showthread'">This is the top rated post!</code></if>

but i don't know where i must add it so it will be shown under the first post

maybe you can help me ? or i will wait for the 1.9 version ;)

[ragarcia87]

You can use template conditionals to limit the display to just one thread.

Thank you for your speedy response. Im not much of a coder but I will google what you mean and try to do this.


The code I am inserting into my postbit is
<if condition="$thread['forumid'] == 703">
<div class="smallfont">
$helpfulanswers
</div>
</if>


703 is the id of the thread but it wont show in the thread. Am I doing this right?

//EDIT//
I figured out I had to use this code to target the specific threadid
<if condition="$thread['forumid'] == '38' && $thread['threadid'] == '703'">
<div class="smallfont">
This is a test...
</div>
</if>

That works but when I add the variable $helpfulanswers it doesn't show. I need help on actually getting the variable to show up. The test message appeared only in that thread.

[Ted S]

hello, thanks for the answer

i think i must add this code somewhere in the postbit ??

<if condition="$thread[toppost] == $post[postid] AND THIS_SCRIPT == 'showthread'">This is the top rated post!</code></if>

but i don't know where i must add it so it will be shown under the first post

maybe you can help me ? or i will wait for the 1.9 version ;)

Give me the weekend to see if I can't get 1.9 going...

[Ted S]

<if condition="$thread[threadid] == XX">
$helpful_answers
</if>


Something along the lines of that where XX is the thread id.

[scabbed]

Give me the weekend to see if I can't get 1.9 going...

whoo :D that would be very very nice ::p

:up::up:

[ragarcia87]

<if condition="$thread[threadid] == XX">
$helpful_answers
</if>


Something along the lines of that where XX is the thread id.


Ive got it showing test text but not the $helpful_answers variable. I dont know what I am doing wrong. I have it set to manual in the settings.

[Ted S]

Ive got it showing test text but not the $helpful_answers variable. I dont know what I am doing wrong. I have it set to manual in the settings.

So you're seeing other text but not the rating code?

[ragarcia87]

So you're seeing other text but not the rating code?

Correct. I can enter any text and it shows up so I know i have the coding right but the $helpful_answers variable doesnt work.

[Ted S]

And if you remove the template conditional stuff does it work?

[Ted S]

Give me the weekend to see if I can't get 1.9 going...

The attached version 1.9.0 beta adds an option to display a message under the first post about which post is the top post and links to it.

You can set a minimum number of votes before the message shows up (so it isn't there for 1 vote posts).

This option will add a query.

To upgrade upload the new plugin file and upload/helpfulanswers.php

Note: Upgrading will take a few minutes as each post with voting history has to be modified to add the threadid it is associated with.

[Ted S]

Attention Helpful Answers users,

I have begun adding some new functionality for version 1.9 starting with a message that will show under the first post linking visitors to the most helpful post.

1.9 also includes a number of small bug fixes and cleans up some of the code.

This is a work in progress and labeled beta as it will be evolving. To upgrade upload the attached php files and install the product file. Updating will take a few minutes as changes are made to every rated post in the system. For larger sites with more than 25,000 votes I suggest running this during non-peak hours.

[ragarcia87]

And if you remove the template conditional stuff does it work?

It still doesn't work after the template conditionals are removed.

[Ted S]

Wellthen your settings aren't right. Have you enabled it for the forum your thread is in?

[ragarcia87]

Wellthen your settings aren't right. Have you enabled it for the forum your thread is in?

Yes I have.

[Ted S]

Yes I have.

Strange.

Try disabling the auto placement and confirm that the rating box shows up. Let me know what the results are.

[digicom]

Thanks for the update Ted :up:

[Ted S]

Thanks for the update Ted :up:

No problem.

I have a few other features on the to do list... but am open to last minute suggestions too.

[scabbed]

yeah, wonderfull Ted, you are the best :)

thanks for the update

edit :

- the link to the usefull post should be clickable ? i can't click on it (there's no link anywhere)
- where can i custom the box where the link is displayed ?

thanks for all

[Ted S]

yeah, wonderfull Ted, you are the best :)

thanks for the update

edit :

- the link to the usefull post should be clickable ? i can't click on it (there's no link anywhere)
- where can i custom the box where the link is displayed ?

thanks for all

Link, who wants a link? :D

1. Change the phrase helpfulanswer_mosthelp_post to


Members of {1} have rated post {2} as the most helpful. <a href="./showpost.php?p={2}">Skip right to it!</a>


2. The box is controlled by template helpful_answers_mosthelp_post