vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Add-On Releases - [AJAX] Helpful Answers - Allow users to rate individual posts (https://vborg.vbsupport.ru/showthread.php?t=233296)

Ted S 10-28-2014 03:58 AM

Quote:

Originally Posted by QFIT (Post 2520255)
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 11-03-2014 01:32 PM

Can you give me the SQL query?

Ted S 11-03-2014 06:01 PM

Quote:

Originally Posted by QFIT (Post 2521106)
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 11-03-2014 06:12 PM

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 11-03-2014 07:00 PM

Quote:

Originally Posted by Meestor_X (Post 2521145)
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 11-03-2014 07:27 PM

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 11-03-2014 07:49 PM

Quote:

Originally Posted by Meestor_X (Post 2521150)
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 11-03-2014 09:04 PM

Quote:

Originally Posted by Ted S (Post 2521152)
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 11-04-2014 12:27 AM

Quote:

Originally Posted by Meestor_X (Post 2521164)
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 11-27-2014 08:47 PM

Everything works fine. Thanks!

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


All times are GMT. The time now is 03:58 AM.

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.02293 seconds
  • Memory Usage 1,739KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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