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)
-   -   Miscellaneous Hacks - Featured Threads (https://vborg.vbsupport.ru/showthread.php?t=320387)

MarkFL 02-07-2017 12:06 AM

Quote:

Originally Posted by Snowhog (Post 2581977)
Have you gotten around to this yet? I don't see a post from you saying you have.

As far as I know, this was done. :)

Morrus 05-08-2017 03:25 PM

Quick question re the functionality of this. I think I know the answer, but wanted to check first --

Can I use this mod to set up a separate page which lists all the most replied to threads which were started in the last week?

Thanks!

MarkFL 05-08-2017 03:50 PM

Quote:

Originally Posted by Morrus (Post 2586311)
Quick question re the functionality of this. I think I know the answer, but wanted to check first --

Can I use this mod to set up a separate page which lists all the most replied to threads which were started in the last week?

Thanks!

You can see a list of the most replied to threads, from which you can add to the featured list, but it won't auto-add only from the last week.

Morrus 05-08-2017 04:35 PM

Quote:

Originally Posted by MarkFL (Post 2586312)
You can see a list of the most replied to threads, from which you can add to the featured list, but it won't auto-add only from the last week.

Darnit. Thanks for the reply!

chloe101 05-19-2017 04:26 PM

Quote:

Originally Posted by MarkFL (Post 2569216)
Okay, try replacing the file "featuredthread.php" (in your forum's root folder) with the attached file...let me know if that works. :)

Hi Mark, I am having a similar, though not the exact same, problem and wonder if I should replace this file too? Or if you have another suggestion.

This happens when I try to reorder the threads. Here is my error message:
HTML Code:

PHP Warning: mysqli_query(): (42S02/1051): Unknown table 'thread' in ..../includes/class_core.php on line 1394

Database error in vBulletin 4.2.4:

Invalid SQL:

                                SELECT thread.*, featuredthreads.id
                                FROM (redacted)thread
                                INNER JOIN (redacted)featuredthreads
                                ON thread.threadid = featuredthreads.threadid
                                        ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;

MySQL Error  : Unknown table 'thread'
Error Number  : 1051

Thanks again for this awesome mod!

MarkFL 05-19-2017 04:33 PM

Quote:

Originally Posted by chloe101 (Post 2586689)
Hi Mark, I am having a similar, though not the exact same, problem and wonder if I should replace this file too? Or if you have another suggestion.

This happens when I try to reorder the threads. Here is my error message:
HTML Code:

PHP Warning: mysqli_query(): (42S02/1051): Unknown table 'thread' in ..../includes/class_core.php on line 1394

Database error in vBulletin 4.2.4:

Invalid SQL:

                                SELECT thread.*, featuredthreads.id
                                FROM (redacted)thread
                                INNER JOIN (redacted)featuredthreads
                                ON thread.threadid = featuredthreads.threadid
                                        ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;

MySQL Error  : Unknown table 'thread'
Error Number  : 1051

Thanks again for this awesome mod!

Yes, try doing the replacement, and let me know if that works or not. If not, we can go from there. :)

chloe101 05-19-2017 04:53 PM

Thank you! That seems to have worked beautifully. I can now reorder the threads without the SQL error.

Additional question if you don't mind... Is it possible to see how many nominations each thread received? It's entirely possible I'm missing something obvious.

Also, I am not sure what the "Rating Threshold" in the Nominations setting means and how it correlates to the "Votes Threshold".

I have the settings on Auto-Add Featured threads but that's adding an awful lot of threads at the top of my forum. Is it possible to limit the number of threads to 5 or 6 if I use Auto-Add?

MarkFL 05-19-2017 05:06 PM

Quote:

Originally Posted by chloe101 (Post 2586691)
Thank you! That seems to have worked beautifully. I can now reorder the threads without the SQL error.

Great...glad to hear it. :)

Quote:

Originally Posted by chloe101 (Post 2586691)
Additional question if you don't mind... Is it possible to see how many nominations each thread received? It's entirely possible I'm missing something obvious.

You should see how many nomination each thread has received when you open up the list of nominated threads. Only those who have been designated as managers can do this...but since you are reordering threads, you are a manager already.

Also, if you hover your mouse over the number of nominations, a tooltip will show you a list of users who have nominated the threads.

Quote:

Originally Posted by chloe101 (Post 2586691)
Also, I am not sure what the "Rating Threshold" in the Nominations setting means and how it correlates to the "Votes Threshold".

The "Rating Threshold" is the minimum rating average a thread must have before being including in the "User-Rated Threads" list. The "Votes Threshold" is the minimum number of votes a threads must have before being included.

For example, you might wish to only have 5 star threads in the list, but you want a thread to have at least 5 votes as well, this way you don't see those that have only gotten a small number of votes.

Quote:

Originally Posted by chloe101 (Post 2586691)
I have the settings on Auto-Add Featured threads but that's adding an awful lot of threads at the top of my forum. Is it possible to limit the number of threads to 5 or 6 if I use Auto-Add?

The only way to limit the number is to use the option "Yes, And Penultimate Thread Is Removed"...this way when the newest thread is added, the previous auto-added thread is removed.

I don't have a way to limit this by number.

I use this feature at MHB for our "Problem Of The Week" forums...when a new problem is posted in one of our problem categories (High School/University/Post-Grad), last week's problem is auto-removed, and the new problem is auto-added. :)

chloe101 05-19-2017 05:46 PM

Quote:

Originally Posted by MarkFL (Post 2586692)
You should see how many nomination each thread has received when you open up the list of nominated threads.

Also, if you hover your mouse over the number of nominations, a tooltip will show you a list of users who have nominated the threads.

The User Nominated & Featured tables are different on my forum. I am trying to find a way to sort the threads by number of nominated votes (or at least know how many votes they got) so that when I manually add new ones, I have a little more visibility into which ones to eliminate.

First I couldn't get people to use it on our new forum and suddenly they're using it everywhere so your add-on is a major success!

Quote:

The "Rating Threshold" is the minimum rating average a thread must have before being including in the "User-Rated Threads" list. The "Votes Threshold" is the minimum number of votes a threads must have before being included.

For example, you might wish to only have 5 star threads in the list, but you want a thread to have at least 5 votes as well, this way you don't see those that have only gotten a small number of votes.
Thank you.

Quote:

The only way to limit the number is to use the option "Yes, And Penultimate Thread Is Removed"...this way when the newest thread is added, the previous auto-added thread is removed.

I don't have a way to limit this by number.
This will make things difficult when our forum gets busy. Would you be available to tailor this for our needs when donations start rolling in? We'd compensate you of course. One feature I'd love is the ability to put these in a couple of widgets on the CMS. I hope I didn't break any VB rules by asking that!

(on edit, I found the admin setting for "Yes, And Penultimate Thread Is Removed" but I'd still like it tailored ;) )

MarkFL 05-19-2017 09:16 PM

Quote:

Originally Posted by chloe101 (Post 2586698)
The User Nominated & Featured tables are different on my forum. I am trying to find a way to sort the threads by number of nominated votes (or at least know how many votes they got) so that when I manually add new ones, I have a little more visibility into which ones to eliminate.

First I couldn't get people to use it on our new forum and suddenly they're using it everywhere so your add-on is a major success!

You should see the number of nominations in the leftmost column in that table when you click the button to view it. There is no option to turn that column off.

The threads in that table are automatically sorted in descending order by the number of nominations they receive, and in the event of a tie, the threads are sorted within the members of the tie by threadid, so that the older threads are displayed first.


All times are GMT. The time now is 11:59 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.01271 seconds
  • Memory Usage 1,766KB
  • 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
  • (2)bbcode_html_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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