The Arcive of Official vBulletin Modifications Site.

Featured Threads · **Released**: 09-30-2015

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)

MarkFL · #**102** 01-23-2016, 06:42 AM

Quote:

Originally Posted by hazem_aliraqi

thank you mark i have made the COUNT from sql using php file

how can i find the Featured Threads for each user ?

i don't want a major upgrade its hard to translate for arabic language

I need more information regarding the SQL error you get when you try to display the icon next to the names of "Featured Threads" authors in postbits/profiles. You posted that you are getting an error, but not why.

MarkFL · #**103** 01-23-2016, 06:46 AM

Quote:

Originally Posted by hazem_aliraqi

this

PHP Code:


			
MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140

This is the query:

PHP Code:


			
    $myfeatured = $vbulletin->db->query_first("
        SELECT COUNT(*) AS thread_count, thread.postuserid
        FROM " . TABLE_PREFIX . "thread AS thread
        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads
        ON thread.threadid = featuredthreads.threadid
        WHERE thread.postuserid = " . $post['userid']
    );

I use "COUNT" all the time without a "GROUP BY" clause. What MySQL version are you using?

hazem_aliraqi · #**104** 01-23-2016, 06:57 AM

Quote:

Originally Posted by MarkFL

This is the query:

PHP Code:


			
    $myfeatured = $vbulletin->db->query_first("

        SELECT COUNT(*) AS thread_count, thread.postuserid

        FROM " . TABLE_PREFIX . "thread AS thread

        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads

        ON thread.threadid = featuredthreads.threadid

        WHERE thread.postuserid = " . $post['userid']

    );

I use "COUNT" all the time without a "GROUP BY" clause. What MySQL version are you using?

version 5.0.51

MarkFL · #**105** 01-23-2016, 07:16 AM

Quote:

Originally Posted by hazem_aliraqi

version 5.0.51

Try changing the query to:

PHP Code:


			
    $myfeatured = $vbulletin->db->query_first("

        SELECT COUNT(*) AS thread_count, thread.postuserid

        FROM " . TABLE_PREFIX . "thread AS thread

        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads

        ON thread.threadid = featuredthreads.threadid

        WHERE thread.postuserid = " . $post['userid'] . "

        GROUP BY thread.postuserid

    ");

In the plugins titled:

Show Featured Authors (Postbit)
Show Featured Authors (Postbit - Quick Reply)
Show Featured Authors (Profile)

If that works, then we will proceed from there.

hazem_aliraqi · #**106** 01-23-2016, 07:27 AM

Quote:

Originally Posted by MarkFL

Try changing the query to:

PHP Code:


			
    $myfeatured = $vbulletin->db->query_first("

        SELECT COUNT(*) AS thread_count, thread.postuserid

        FROM " . TABLE_PREFIX . "thread AS thread

        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads

        ON thread.threadid = featuredthreads.threadid

        WHERE thread.postuserid = " . $post['userid'] . "

        GROUP BY thread.postuserid

    ");

In the plugins titled:

Show Featured Authors (Postbit)
Show Featured Authors (Postbit - Quick Reply)
Show Featured Authors (Profile)

If that works, then we will proceed from there.

awesome
works successfully

thank you

MarkFL · #**107** 01-23-2016, 07:34 AM

Quote:

Originally Posted by hazem_aliraqi

awesome
works successfully

thank you

Okay, now if you wish for this data to show up in the postbit userinfo area (if you are also showing the icon next to the username), try adding this code:

PHP Code:


			
        $t = 'Thread';
        if ($myfeatured['thread_count'] > 1)
        {
            $t .= 's';
        }
        $template_hook['postbit_userinfo_right_after_posts'] .= '<dt title="Featured Thread Author">FT Author</dt> <dd>' . $myfeatured['thread_count'] . ' ' . $t . '</dd>';

within the if statement (at the end within it) in the plugins titled:

Show Featured Authors (Postbit)
Show Featured Authors (Postbit - Quick Reply)

hazem_aliraqi · #**108** 01-23-2016, 07:58 AM

Quote:

Originally Posted by MarkFL

Okay, now if you wish for this data to show up in the postbit userinfo area (if you are also showing the icon next to the username), try adding this code:

PHP Code:


			
        $t = 'Thread';
        if ($myfeatured['thread_count'] > 1)
        {
            $t .= 's';
        }
        $template_hook['postbit_userinfo_right_after_posts'] .= '<dt title="Featured Thread Author">FT Author</dt> <dd>' . $myfeatured['thread_count'] . ' ' . $t . '</dd>';

within the if statement (at the end within it) in the plugins titled:

Show Featured Authors (Postbit)
Show Featured Authors (Postbit - Quick Reply)

thank you mark

i use this php file with field42

PHP Code:


			
SELECT COUNT(*) AS thread_count
FROM thread AS thread
INNER JOIN featuredthreads AS featuredthreads
ON thread.threadid = featuredthreads.threadid
WHERE thread.postuserid = userfield.userid

is that right ?

MarkFL · #**109** 01-23-2016, 08:03 AM

You should be able to do this without having to use a profile field...you wouldn't want to have to run an additional query for each postbit, redundantly updating a profile field each time.

hazem_aliraqi · #**110** 01-23-2016, 08:09 AM

Quote:

Originally Posted by MarkFL

You should be able to do this without having to use a profile field...you wouldn't want to have to run an additional query for each postbit, redundantly updating a profile field each time.

i used Scheduled Tasks for updating user field in every 24 hour

MarkFL · #**111** 01-23-2016, 08:12 AM

Quote:

Originally Posted by hazem_aliraqi

i used Scheduled Tasks for updating user field in every 24 hour

I would simply use the query that is already being run to display the information in the postbit, as I suggested above. If you wish to do it differently, then that's fine.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10871 seconds Memory Usage 2,413KB 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 (8)bbcode_php (9)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 (11)post_thanks_box (6)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (10)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
Messages:

6 благодарности(ей) от:
bosanci28, ikopylov, RichieBoy67, smirkley, TheLastSuperman, vze2yqtm

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!