Forum Home Enhancements - Latest X Threads on Forum Home

Latest X Threads on Forum Index
by: whitemike
Demo: Here

What this does?

This will add the latest x posts onto your forum index

Features?

1. Enable/Disable - Master Switch to Turn Latest Posts on or off
2. Title - Change the title of the Site News
3. Posts to Show - Number of Last Posts to show
4. Cutoff Length - How many characters to show before the ... at the end
5. Exclude Forums - Choose what forums you do not want to be listed
6. Thread Title Width - Width of Title Table
7. User Title Width - Width of User Table
8. Forum Title Width - Width of Forum Table
9. Auto Location - Enable/Disable auto location
10. Location - Gives Options for Under navbar, above forum, or below forum
11. Date & Time - Enable/Disable the time and date from being shown

Added?

1. 2 Template
2. 3 Plugins
3. 11 Settings
4. 29 Phrases

Installation?

1. Import Product

Thats It!

Releases

1.1 - Fixed Moderated thread bug
1.0 - Initial release

Please Click Install if you use

For Latest X Posts on Forum Home CLICK HERE

[eviltechie]

Nice mod! Thx.

I made a couple modifications for my use, and figured I'd share in case anyone else wants to do similar. I wanted to display the latest threads based on the last post instead of the first. So, whenever a new post is made in a thread it jumps to the top of the list...and also displays the author as the most recent poster.

Here's my edited code, it replaces the Main Code plugin which runs on forumhome_start.

PHP Code:

// enable to run this script
if ($vbulletin->options['latest_thread_enabled'])
{
    $db->hide_errors();
    global $vbulletin;

    // forum permissions
    $forumpermissions = array();
    foreach($vbulletin->forumcache AS $forum)
    {
        $forumpermissions[$forum["forumid"]] = fetch_permissions($forum['forumid']);
        if ((!($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview'])) OR (!($forum['options'] & $vbulletin->bf_misc_forumoptions['active']) AND !$vbulletin->options['showprivateforums'] AND !in_array($vbulletin->userinfo['usergroupid'], array(5,6,7))))
        {
            $forumids .= ','.$forum['forumid'];
        }
    }
    if ($vbulletin->options['latest_thread_exclude']!='')
    {
        $forumids .= ','.$vbulletin->options['latest_thread_exclude'];
    }
    $forumids = substr($forumids, 1);
    if ($forumids!='')
    {
        $latest_and = "thread.forumid NOT IN($forumids)";
        $latest_and_1 = "forum.forumid NOT IN($forumids)";
    }
    
    // converts options to nice variables
    $limit = $vbulletin->options['latest_thread_number'];
    
    // query to get the last posts
    $query = $vbulletin->db->query_read("
        SELECT
            thread.forumid as forumid, thread.visible, thread.title as thread_title, thread.threadid as threadid, post.username as username, post.userid as userid, thread.dateline as date,
            forum.title as forum_title,
            post.postid, post.pagetext as pagetext
        FROM " . TABLE_PREFIX . "thread as thread
        LEFT JOIN " . TABLE_PREFIX . "post as post on (thread.lastpostid = post.postid)
        LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
        WHERE thread.visible = 1 AND $latest_and AND $latest_and_1
        ORDER BY postid DESC
        LIMIT $limit"
    );

    // reset variables
    $counter = 0;
    $latest_post_bits = '';
    
    while ($row = $vbulletin->db->fetch_array($query))
    {
        // allow to use alternate color in rows
        require_once(DIR . '/includes/functions.php');
        exec_switch_bg();
        
        // strips the bbcode out of the post
        $row['pagetext'] = strip_bbcode($row['pagetext'], $stripquotes = true, $fast_and_dirty = false, $showlinks = true);
        
        // adds the cutoff ... with substr
        $row['pagetext'] = substr($row['pagetext'], 0, $vbulletin->options['latest_thread_cut']) . '...';

        // convert pagetext to nice looking variable
        $pagetext = $row['pagetext'];
        $username = $row['username'];
        $userid = $row['userid'];
        $forumid = $row['forumid'];
        $threadid = $row['threadid'];
        $postid = $row['postid'];
        $forumtitle = $row['forum_title'];
        $threadtitle = $row['thread_title'];
        $date = vbdate($vbulletin->options['dateformat'], $row['date'], true);
        $time = vbdate($vbulletin->options['timeformat'], $row['date']);
        
        // increments the counter +1
        $show['latest_break'] = $counter++;
        
        eval('$latest_post_bits .= "' . fetch_template('forumhome_latest_thread_bit') . '";');
    }
    
    // free the query
    $vbulletin->db->free_result($query);
    
    eval('$latest = "' . fetch_template('forumhome_latest_thread') . '";');
    
    switch ($vbulletin->options['latest_thread_location'])
        {
            case 0: $latest_location = '$navbar'; break;
            case 1: $latest_location = '<!-- main -->'; break;
            case 2:    $latest_location = '<!-- what\'s going on box -->'; break;
        }
    
    if ($vbulletin->options['latest_thread_auto'])
    {
        // adds location to forumhome template
        $vbulletin->templatecache['FORUMHOME'] = str_replace(
            $latest_location,
            $latest_location.'$latest',
            $vbulletin->templatecache['FORUMHOME']
        );
    }
} 


I also modified the template code for forumhome_latest_thread_bit to the following to make the link jump to the latest post when clicked:

PHP Code:

<tr>
    <td class="$bgclass">
        <a href="$vboptions[bburl]/showthread.php?$session[sessionurl]t=$threadid&p=$postid" class="smallfont">$threadtitle</a>
        <if condition="$vboptions['latest_thread_time']"><span class="smallfont">$date $time</span></if>
        <if condition="$vboptions['latest_thread_cut'] != '0'"><div class="smallfont">$pagetext</div></if>
    </td>
    <td class="$bgclass">
        <a href="$vboptions[bburl]/forumdisplay.php?$session[sessionurl]f=$forumid" class="smallfont">$forumtitle</a>
    </td>
    <td class="$bgclass">
        <a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$userid" class="smallfont">$username</a>
    </td>
</tr> 


Seems to be working great thus far! Thanks again.

[m4gnus]

Hi I´m running Latest X Threads on my forum. The forum is in swedish so I Want to translate the column header "Latest 10 Threads" to swedish. I´m a newbe so I dont dare to change anything without asking here first.

My new forum:

[Michael Biddle]

It is a phrase, you can edit it from your admincp

[dmknights]

*Installed*
This works on my board & i have 3.8.1

[Michael Biddle]

Glad everything is working great!

[ctfortner]

I have been using this for a while, works great. One question, how could I set this for members only, not visible to guests? I tried editing the main code plugin with a

<if condition="!$show['guest']">

, but that didnt work. Not a programmer

[Michael Biddle]

To gain support please click install first

[ctfortner]

my bad, installed. Any thoughts?

[Michael Biddle]

You could add that if at the beginning of the forumhome_latest_threads template

[ctfortner]

Hi, thanks for the response. What I did is added <if condition="!$show['guest']"> to the very to of the forumhome_latest_threads template and then added </if> to the very bottom. Is that correct? It did not change anything, still showed for guests.

I also tried putting it all together like this at the very top with no luck

<if condition="!$show['guest']">
</if>

thanks