Latest Posts on site home page

Looking for a MOD? Have a MOD request? Post here for help. (Note: This forum is community supported; phpBB does not have official MOD authors)
Ideas Centre
Locked
Embraer195
Registered User
Posts: 4
Joined: Thu Jan 03, 2008 7:06 pm

Latest Posts on site home page

Post by Embraer195 » Thu Mar 20, 2008 11:12 pm

Is there a code for V3 that I can add to have the latest forum postings shown on the site home page? I've seen it on another website and I'm intrigued to have it on mine. If anyone can help me?

I tried 'fetch all' but I'm having difficulties!

Many thanks.

J.

xDazedx
Registered User
Posts: 362
Joined: Sat Aug 21, 2004 11:42 pm
Contact:

Re: Latest Posts on site home page

Post by xDazedx » Fri Mar 21, 2008 2:10 am

I am looking for this as well. I had it on phpbb2 but not on v3.

zippolah
Registered User
Posts: 1
Joined: Fri Mar 21, 2008 9:50 am

Re: Latest Posts on site home page

Post by zippolah » Fri Mar 21, 2008 9:52 am

im also looking for this same mod. any help or link to mods would be great thnx

demo2008
Registered User
Posts: 9
Joined: Thu Mar 20, 2008 6:01 am

Re: Latest Posts on site home page

Post by demo2008 » Fri Mar 21, 2008 10:09 am

search for NV recent topics

Embraer195
Registered User
Posts: 4
Joined: Thu Jan 03, 2008 7:06 pm

Re: Latest Posts on site home page

Post by Embraer195 » Fri Mar 21, 2008 9:45 pm

'NV Recent Topic' is for the actual forum though isn't it? I wanted the code to add to a non-forum webpage so it would draw more visitors to the forum direct from the front page.

xDazedx
Registered User
Posts: 362
Joined: Sat Aug 21, 2004 11:42 pm
Contact:

Re: Latest Posts on site home page

Post by xDazedx » Sat Mar 22, 2008 1:31 am

Embraer195 you and I are on the same page.

I think that mod just lists recent topics on the forum page. I would like to put a small block on a side panel of my main site for recent posts in the forum. I had this before as a scrolling marquee. Helped bring people to the forum.

Gnagy08
Registered User
Posts: 19
Joined: Thu Mar 20, 2008 3:33 am

Re: Latest Posts on site home page

Post by Gnagy08 » Sat Mar 22, 2008 2:48 am

It would be nice to have a it for HTML since my main page is HTML format.

Vinyard_X43q
Registered User
Posts: 19
Joined: Wed Jun 06, 2007 8:14 am

Re: Latest Posts on site home page

Post by Vinyard_X43q » Sat Mar 22, 2008 8:14 am

Here is a cleaned up version of what I use on my website.

This must be placed at the top of your page.

Code: Select all

<?php
    define('IN_PHPBB', true);
    $phpbb_root_path = './forum/'; // Path to phpbb folder
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);

    // Grab user preferences
    $user->setup();
?>
Place this where you want the topic links to appear.

Code: Select all

<?php
    /*** phpBB3 - Last Active Topics System ***/
    //Show last x topics
    define('TOPICS_LIMIT',10);

    // Create arrays
    $topics = array();
    
    // Get forums that current user has read rights to.
    $forums = array_unique(array_keys($auth->acl_getf('f_read', true)));
    
    // Get active topics.
    $sql="SELECT *
    FROM " . TOPICS_TABLE . "
    WHERE topic_approved = '1' AND " . $db->sql_in_set('forum_id', $forums) . "
    ORDER BY topic_last_post_time DESC";
    $result = $db->sql_query_limit($sql,TOPICS_LIMIT);
    while ($r = $db->sql_fetchrow($result))
    {
        $topics[] = $r;
    }
   $db->sql_freeresult($result);
?>
<div>
<?php
        
    foreach($topics as $t)
    {
        // Get folder img, topic status/type related information
        $topic_tracking_info = get_complete_topic_tracking($t['forum_id'], $t['topic_id']);
        $unread_topic = (isset($topic_tracking_info[$t['topic_id']]) && $t['topic_last_post_time'] > $topic_tracking_info[$t['topic_id']]) ? true : false;
        $folder_img = $folder_alt = $topic_type = '';
        topic_status($t, $t['topic_replies'], $unread_topic, $folder_img, $folder_alt, $topic_type);
        
        // output the link
        ?>
            <img style="vertical-align: text-bottom" src="<?php echo $user->img($folder_img, $folder_alt, false, '', 'src');?>" title="<?php echo $user->lang[$folder_alt];?>" alt="<?php echo $user->lang[$folder_alt];?>" />
            <a href="<?php echo $phpbb_root_path . 'viewtopic.php?f=' . $t['forum_id'] . '&t=' . $t['topic_id'] . '&p=' . $t['topic_last_post_id'] . '#p' . $t['topic_last_post_id'];?>"><?php echo html_entity_decode($t['topic_title']);?></a><br />
    <?
    }
    ?>
</div>
Here is a demo: https://www.vnetgaming.net/activetopics_clean.php
Hope it's what you guys are looking for. :)
Last edited by Vinyard_X43q on Fri Feb 14, 2014 9:33 pm, edited 7 times in total.

Embraer195
Registered User
Posts: 4
Joined: Thu Jan 03, 2008 7:06 pm

Re: Latest Posts on site home page

Post by Embraer195 » Sat Mar 22, 2008 7:37 pm

Works like a charm, Vinyard!

Many thanks for your efforts I really appreciate it! :D

Vinyard_X43q
Registered User
Posts: 19
Joined: Wed Jun 06, 2007 8:14 am

Re: Latest Posts on site home page

Post by Vinyard_X43q » Sun Mar 23, 2008 2:54 am

Glad to hear its working great for you. :)

saultw
Registered User
Posts: 1
Joined: Sun Mar 23, 2008 10:45 am

Re: Latest Posts on site home page

Post by saultw » Sun Mar 23, 2008 10:59 am

I would like to ask how to change the hot TOPICS

Vinyard_X43q
Registered User
Posts: 19
Joined: Wed Jun 06, 2007 8:14 am

Re: Latest Posts on site home page

Post by Vinyard_X43q » Mon Mar 24, 2008 2:35 am

What exactly do you mean by "hot topics"?

pbcd2000
Registered User
Posts: 7
Joined: Mon Mar 24, 2008 8:33 pm

Re: Latest Posts on site home page

Post by pbcd2000 » Mon Mar 24, 2008 8:39 pm

This works fine for me but I would like to be able to show all the latest posts to unregistered users as well, not just related to a persons logged in permissions. When an unregistered user clicks on such a post phpBB asks them to register anyway so that would be good for my purposes. A sort of 'see what your missing' type of system.

How would I change the above code to ignore a users permissions and show all posts?

pbcd2000
Registered User
Posts: 7
Joined: Mon Mar 24, 2008 8:33 pm

Re: Latest Posts on site home page

Post by pbcd2000 » Mon Mar 24, 2008 11:19 pm

Cancel my last, i changed the code from

Code: Select all

$sql = 'SELECT p.post_id, p.topic_id, p.forum_id, p.post_subject, p.post_time, u.username
                    FROM ' . POSTS_TABLE . ' p , ' . USERS_TABLE . ' u
                    WHERE post_approved = 1
                        AND ' . $db->sql_in_set('forum_id', $forums) . '
                        AND u.user_id = p.poster_id
                    ORDER BY post_time DESC
                    LIMIT 0,' . $topic_limit;
    $result = $db->sql_query($sql);
to

Code: Select all

$sql = 'SELECT p.post_id, p.topic_id, p.forum_id, p.post_subject, p.post_time, u.username
                    FROM ' . POSTS_TABLE . ' p , ' . USERS_TABLE . ' u
                    WHERE post_approved = 1
                        AND u.user_id = p.poster_id
                    ORDER BY post_time DESC
                    LIMIT 0,' . $topic_limit;
    $result = $db->sql_query($sql);
That seems to do the trick not full understanding what I have done but I think I have ignored any reference to an array that contains a list of permitted forums for the current user.

Vinyard_X43q
Registered User
Posts: 19
Joined: Wed Jun 06, 2007 8:14 am

Re: Latest Posts on site home page

Post by Vinyard_X43q » Tue Mar 25, 2008 12:44 am

The code you removed was an array of forums the current user has read right to. In order for any topics to appear guest users must have read rights to some forums or else nothing will appear.

Locked

Return to “[3.0.x] MOD Requests”

Who is online

Users browsing this forum: No registered users and 12 guests

cron