vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features) (https://vborg.vbsupport.ru/showthread.php?t=204117)

Ted S 12-08-2009 04:54 PM

Quote:

Originally Posted by haothiencz (Post 1927220)
Is there any way to make it intergate with vbcredits?

User can get more credit when receives good rate and losse credit with bad vote?

Thank you in advanced.

There is no integration mod with vB Credits that I have seen to this point.

Spinball 12-11-2009 05:01 PM

Some questions/suggestions.
1) I think it would be useful to allow people to switch the 'helpful answer' functionality on for a particular thread when they create a it. I think this is preferable to allowing people to vote into threads which are not appropriate for voting. E.g. 'You'll never guess who I bumped into on holiday'. It would be a tickbox in the new thread page. Is this doable?

2) Would it be possible to allow people to vote for one post in a thread only? I.e. if they vote for a new post, their previous vote for a different post is removed? That way, if a better answer is posted and people vote for it, the older, less useful post will lose votes and hopefully fall more rapidly below the new post in popularity.

3) Displaying the most helpful answer. How difficult would it be to, if there is a helpful answer voted, display a line under the first post (a bit like the 'Thank you' line in the Post Thank You mod) which shows there is a 'most helpful answer'. The line has the usual category open/collapse button. The button is collapsed by default. When someone clicks the open button, the post is displayed like when you expand/contract a category. So you show the thread like we're used to seeing threads, but if people want to see the most helpful answer, they just click the open button in the line under the first post.

Any of these ideas sound any good?

Ted S 12-12-2009 05:45 AM

Quote:

Originally Posted by Spinball (Post 1928931)
Some questions/suggestions.
1) I think it would be useful to allow people to switch the 'helpful answer' functionality on for a particular thread when they create a it. I think this is preferable to allowing people to vote into threads which are not appropriate for voting. E.g. 'You'll never guess who I bumped into on holiday'. It would be a tickbox in the new thread page. Is this doable?

Possible, sure. It's just not designed to to that.

Quote:

2) Would it be possible to allow people to vote for one post in a thread only? I.e. if they vote for a new post, their previous vote for a different post is removed? That way, if a better answer is posted and people vote for it, the older, less useful post will lose votes and hopefully fall more rapidly below the new post in popularity.
Yes it would be. This requires one additional SQL check on voting.

Quote:

3) Displaying the most helpful answer. How difficult would it be to, if there is a helpful answer voted, display a line under the first post (a bit like the 'Thank you' line in the Post Thank You mod) which shows there is a 'most helpful answer'. The line has the usual category open/collapse button. The button is collapsed by default. When someone clicks the open button, the post is displayed like when you expand/contract a category. So you show the thread like we're used to seeing threads, but if people want to see the most helpful answer, they just click the open button in the line under the first post.
The first part is simple enough and already offered. Getting the post to show up directly is tricky since you have to query and build it which seems redundant. Why not just link to it directly and avoid the server load?

Interesting stuff that I'll definitely consider after building the 4.0 version.

Spinball 12-12-2009 08:50 AM

Quote:

Originally Posted by Ted S (Post 1929193)
The first part is simple enough and already offered. Getting the post to show up directly is tricky since you have to query and build it which seems redundant. Why not just link to it directly and avoid the server load?

Server load will be something to consider. If the answer is on the same page, will the user just be scrolled down to it using a # link? That would be the most efficient.
Otherwise, providing a link to the best answer means people will click the link to open a new page. And that had got to use more server resources than the additional query to present the answer under the first post?
Quote:

Originally Posted by Ted S (Post 1929193)
Interesting stuff that I'll definitely consider after building the 4.0 version.

:up:
I'll not be upgrading to 4, by the way. I need my forums to work!

Ted S 12-12-2009 08:29 PM

Quote:

Originally Posted by Spinball (Post 1929232)
Server load will be something to consider. If the answer is on the same page, will the user just be scrolled down to it using a # link? That would be the most efficient.
Otherwise, providing a link to the best answer means people will click the link to open a new page. And that had got to use more server resources than the additional query to present the answer under the first post?

Yes and no. The load for the user who clicks it wil be higher but the overall load will be lower as the script doesn't have to query to get the post for every thread view, just when someone wants to see that answer.

Quote:

Originally Posted by Spinball (Post 1929232)
I'll not be upgrading to 4, by the way. I need my forums to work!

Well that makes two of us but unfortunately many people will so that's my first goal...

Spinball 12-12-2009 09:00 PM

Quote:

Originally Posted by Ted S (Post 1929534)
Well that makes two of us but unfortunately many people will so that's my first goal...

LOL I think that when they realise that 4 is so bug-riddled and server hungry, they'll be so desperate to roll back to their previously installed version that installing plugins will be the least of their worries :) But fair enough.

christicehurst 12-13-2009 06:56 AM

I'm looking through the list of helpful posters list but it shows up the person who gives it away or not the person who made the helpful post.

Ted S 12-13-2009 07:25 AM

Quote:

Originally Posted by christicehurst (Post 1929762)
I'm looking through the list of helpful posters list but it shows up the person who gives it away or not the person who made the helpful post.

I'm not following what you mean by the person who gives it away?

christicehurst 12-13-2009 08:03 AM

The person who gives it the thumbs up. There's no list of people who receive the thumps up or down. Only a list of the people who voted.

jGas 12-13-2009 09:48 AM

hi, thanks for this great mod!

i'm using it and it works, but i have a problem when i try to open helpfulanswers.php and "Enable Most Helpful Answers" is on.

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

                SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalrank,helpfulpost.lastvote,
                        thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,goodrank as avgrank
                       
                FROM vb_helpfulpost as helpfulpost
                INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
                INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
                INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
                WHERE goodrank > 0
                       
                       
                ORDER BY avgrank desc
                LIMIT 0, 25;

MySQL Error  : Column 'goodrank' in field list is ambiguous
Error Number  : 1052
Request Date  : Sunday, December 13th 2009 @ 05:44:40 AM
Error Date    : Sunday, December 13th 2009 @ 05:44:40 AM
Script        : http://www.musicadigitale.net/forum/helpfulanswers.php?do=topanswers
Referrer      :
IP Address    : 151.68.52.235
Username      : Mr Gas
Classname    : vB_Database_MySQLi
MySQL Version : 5.0.87-community

what should i do to fix it?

thanks =)


All times are GMT. The time now is 05:11 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02917 seconds
  • Memory Usage 1,759KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete