Go Back   vb.org Archive > vBulletin Modifications > vBulletin 4.x Modifications > vBulletin 4.x Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Featured Threads Details »»
Featured Threads
Version: 1.9.7, by MarkFL MarkFL is offline
Developer Last Online: Jun 2020 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 4.x.x Rating:
Released: 09-30-2015 Last Update: 11-12-2015 Installs: 43
DB Changes Uses Plugins Auto-Templates
Additional Files Translations  
No support by the author.

Overview

This product is designed to allow for the creation, display and management of a list of threads that you wish to feature on your site. It gives you a convenient means of showcasing especially good thread content on your forum and give it the increased visibility to registered users and visitors alike that you likely already feel it so richly deserves. You will find that when the featured threads list is displayed on its static page, then the block element is not collapsible since it does not share space with any other content, otherwise it is collapsible so that users will not have to scroll past this list to get to other parts of the page it they wish not to. This is consistent with the behavior of other vBulletin elements.

You may choose to manage this list yourself, or allow others on your staff to share in or even take over the management duties. Some or all of your members may even be allowed and encouraged to be a part of the process by their nominations of threads for the list. You can choose to allow nominations via this product, or use vBulletin's intrinsic thread rating system, or use a combination of both systems. You may also choose to display the most replied threads as well. In this way you could elect to implement a threads of the week or month etc. by popular vote. This product makes all of this possible and easy to accomplish.

You will find that you have a great deal of flexibility in where and how the list is displayed. Those you designate as managers of the list can add, remove, and set the display order of the threads in the list. Also, you may choose to allow your managers to auto-create voting polls to narrow down the selection of nominated threads to be added as featured threads, which is posted to a forum of your choosing. This forum may be private so that only staff is involved in the final voting, or a public forum may be selected so that everyone may vote. All actions performed by users and managers are confirmed with a standard vBulletin redirect message.

Upon installation, two tables are added to your database, one to store the list of featured threads, and one to store the nominations data. Queries are joined so that the latest data for all threads is displayed in the lists and to minimize the redundancy of stored data. If the product is uninstalled, then naturally the two added tables are removed.

The product settings are conveniently sub-divided into the following six categories:

Location Of "Featured Threads" List



You may choose to have the featured threads list displayed on every page, either below the navbar or above the footer. You are given the option to exclude any scripts that you choose. For example you may not want the featured threads list to display on pages whose associated script names are inlinemod, member or online.

In addition to displaying the list on all pages, you may choose one or more of the following options:
  • Display the list on your forum home page, either above or below the forums.
  • Display the list on your forum display pages, either above or below the threads.
  • Display the list on your show thread pages, either above or below the posts.
Note, the above 3 options will be effectively disabled if you have chosen to display on all pages to prevent duplication of content, unless you have set them as excluded scripts for displaying on all pages. This gives you increased control over these 3 pages. For example, you may wish for the featured threads list to display at the top of the page everywhere except on your home page, and so you could have it displayed below the forums there instead.

In addition to, or instead of these options, you may choose to display the list on its own static page. If you have chosen to display on all pages, that will naturally be disabled on the static page to prevent duplication of content. You then have the option to either create your own link to the page using the "Navigation Manager" or you may opt to have a link to the page auto-added as either a navtab:



A navlink on the navbar:



Or as a link in either the "Community" or "Quick Links" drop-down menus on the navbar:





Appearance Of "Featured Threads" List



You may choose to give the "Featured Threads" list element a custom title. This title will be used in the header of the list element, as the link text to the static page on the nav bar, and as the page title for the static page.

You may set a maximum height for the list that applies when it shares space with other content, that is, when it is not on the static page. A vertical scroll-bar is introduced when the list is taller than the maximum height you set. This height does not inlude the header element, just the table of data.

You may set the left/right margins of the list element as a percentage of the parent element. For example, if you wish for the list element to be 75% as wide as the parent element, and centered, then you would enter 12.5 for both the left and right margins. If you want the element to still be 75% as wide as the parent, but all the way on the right, then you would enter 25 for the left margin and 0 for the right margin.

You may set the background color for the "Featured Threads" element, using an HTML color picker.

You may define the CSS for the borders of the list element. This includes both the outer border and the inner borders of the table containing the data. The table cells are only given borders on the right.

You are given an HTML color picker for the color of the Forum/Thread links in the list, as well as the option to give any additional CSS for these links. You may also set the alignment for the thread links (left/center/right).

You may choose how the featured threads are sorted (by Thread Id/Thread Title/Date/Time Added To List/Thread Author User Id) and whether to sort in ascending or descending order. Note that when one of your managers imposes an order for the threads, then that ordering will take precedence.

You may chose to include optional thread information to be displayed, including Replies, Views, Last Poster, Forum, and Prefixes. Thread authors and titles are always displayed. The thread author has a tooltip showing when they created the thread. The replies has a tooltip giving a breakdown of everyone who posted in the thread, sorted in descending order by the number of posts, and then by user id in the case of ties in the number of posts. The last poster has a tooltip that shows when they posted that last post. All usernames in both lists (featured threads and nominated threads) are shown using their current HTML markup. And finally the thread has a tooltip showing a preview of the content of the first post. The number of characters is that which you have set in the AdminCP's general settings.

You can set the maximum number of characters of each thread's forum name to be displayed since these can be long and take up a lot of space. To display the complete forum names, set this maximum to zero. All forum titles that are truncated will have a tooltip that shows the complete forum name on mouse hover.

You are given the option to have an alternating row background color be given to the rows (in all thread tables) to make reading each row easier. You may choose either not to have the alternating backgrounds at all, to have them only for your managers who will benefit more from them because of thread selections while managing the list, and for everyone to see them. An HTML color piker allows you to choose this alternate background color.



"Featured Threads" Icon



You may choose to display an image icon for the featured threads in several places. You are given a choice of 5 included icons, or you may upload your own and give its filename in the settings. You must upload your custom icon to the "markfl_featuredthreads/icons" folder. The icons are appropriately sized depending on the location they are displayed.

If you choose to use an icon, then they are displayed in the thread listing when viewing forums, to the immediate right of the thread titles for those threads in the featured threads list.



Support for this product can be found here:

(continued in post #2)

Download Now

File Type: zip MarkFL - Featured Threads v1.9.7.zip (1.17 MB, 236 views)

Screenshots

File Type: jpg markfl_ft_navbartab.jpg (15.7 KB, 0 views)
File Type: jpg markfl_ft_navbarlink.jpg (15.3 KB, 0 views)
File Type: png markfl_ft_navbarcommunity.png (16.5 KB, 0 views)
File Type: png markfl_ft_navbarquicklinks.png (23.4 KB, 0 views)
File Type: jpg markfl_ft_listuser.jpg (54.4 KB, 0 views)
File Type: jpg markfl_ft_forumdisplay.jpg (79.2 KB, 0 views)
File Type: jpg markfl_ft_acp_section1.jpg (133.8 KB, 0 views)
File Type: jpg markfl_ft_acp_section2.jpg (107.7 KB, 0 views)
File Type: png markfl_ft_acp_section3.png (75.7 KB, 0 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
6 благодарности(ей) от:
bosanci28, ikopylov, RichieBoy67, smirkley, TheLastSuperman, vze2yqtm

Comments
  #122  
Old 04-18-2016, 12:47 PM
ProfC's Avatar
ProfC ProfC is offline
 
Join Date: Jun 2011
Location: Coventry, UK
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This mod has quickly become a staple of my board, thank you ^^

However, when trying to reorder the threads, I get a database error which suggests that the table "thread" doesn't exist.

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

                SELECT thread.*, featuredthreads.id
                FROM estate_thread
                INNER JOIN estate_featuredthreads
                ON thread.threadid = featuredthreads.threadid
                    ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;

MySQL Error   : Unknown table 'thread'
Error Number  : 1051
Reply With Quote
  #123  
Old 04-18-2016, 01:41 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you provide the information about the steps you are taking to reorder the list and the exact error you get?
Reply With Quote
  #124  
Old 04-18-2016, 02:58 PM
ProfC's Avatar
ProfC ProfC is offline
 
Join Date: Jun 2011
Location: Coventry, UK
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarkFL View Post
Can you provide the information about the steps you are taking to reorder the list and the exact error you get?
Thank you, and from the main page (forumhome) which is where I display the Featured Threads box, I either select all or select the Featured Threads I want to reorder and then alter the value in the display order box to be what I want it to (while editing the display order of any other threads which had that original value to the value of the threads being moved up or down). I then click re-order.

My exact error is this on the standard vBulletin Database Error page:

Page URL: https://www.alexandria-ns.com/featur...p?action=array

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

                SELECT thread.*, featuredthreads.id
                FROM estate_thread
                INNER JOIN estate_featuredthreads
                ON thread.threadid = featuredthreads.threadid
                    ORDER BY featuredthreads.thread_order ASC, featuredthreads.id ASC;

MySQL Error   : Unknown table 'thread'
Error Number  : 1051
Request Date  : Monday, April 18th 2016 @ 02:43:08 PM
Error Date    : Monday, April 18th 2016 @ 02:43:08 PM
Script        : http://www.alexandria-ns.com/featuredthread.php?action=array
Referrer      : https://www.alexandria-ns.com/forum.php
IP Address    : xx.xx.xx.xx
Username      : Joshua Ravenclaw
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.47-0ubuntu0.14.04.1
Reply With Quote
  #125  
Old 04-18-2016, 03:27 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay, try replacing the file "featuredthread.php" (in your forum's root folder) with the attached file...let me know if that works.
Attached Files
File Type: php featuredthread.php (21.2 KB, 7 views)
Reply With Quote
  #126  
Old 04-18-2016, 04:39 PM
ProfC's Avatar
ProfC ProfC is offline
 
Join Date: Jun 2011
Location: Coventry, UK
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarkFL View Post
Okay, try replacing the file "featuredthread.php" (in your forum's root folder) with the attached file...let me know if that works.
It now works perfectly, thank you so much!
Reply With Quote
Благодарность от:
MarkFL
  #127  
Old 04-18-2016, 04:47 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ProfC View Post
It now works perfectly, thank you so much!
Thanks for calling this to my attention and for now letting me know it works. I neglected to give some tables an alias in a few of the queries which resulted in an error for sites with a table prefix.

I am planning an upgrade for this product soon to fix a lot of minor details, as I have learned a great deal since I wrote the code for this product.
Reply With Quote
  #128  
Old 04-26-2016, 07:02 PM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd like to give this a try..

Any idea when upgrade will be forthcoming so I can test the most current version?

Thanks for your efforts ...

Regards,
Doug
Reply With Quote
  #129  
Old 04-27-2016, 11:24 AM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BadgerDog View Post
I'd like to give this a try..

Any idea when upgrade will be forthcoming so I can test the most current version?

Thanks for your efforts ...

Regards,
Doug
Sorry, I can't be more specific than "soon." The main changes I have in mind are to use phrases and to revise the thread links.
Reply With Quote
  #130  
Old 04-27-2016, 11:26 AM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarkFL View Post
Sorry, I can't be more specific than "soon." The main changes I have in mind are to use phrases and to revise the thread links.
Thanks Mark ..

I'll keep checking back... :up:

Regards,
Doug
Reply With Quote
  #131  
Old 02-06-2017, 11:22 PM
Snowhog's Avatar
Snowhog Snowhog is offline
 
Join Date: Oct 2011
Location: Andover, MN
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarkFL View Post
Thanks for calling this to my attention and for now letting me know it works. I neglected to give some tables an alias in a few of the queries which resulted in an error for sites with a table prefix.

I am planning an upgrade for this product soon to fix a lot of minor details, as I have learned a great deal since I wrote the code for this product.
Have you gotten around to this yet? I don't see a post from you saying you have.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:36 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11323 seconds
  • Memory Usage 2,392KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (7)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete