PunBB Forums — Active Topics

Re: Active Topics

null@example.com (raptrex) — Tue, 25 Mar 2008 00:41:06 +0000

anyone wanna update this to work with 1.3?

Re: Active Topics

null@example.com (staffanl) — Fri, 16 Nov 2007 08:40:34 +0000

AND f.id != 1

And if I want 1,2 and 3?

AND f.id != 1
AND f.id != 2
AND f.id != 3

Or is there and other better way?

Re: Active Topics

null@example.com (pogenwurst) — Thu, 15 Nov 2007 20:31:57 +0000

You'd probably just change

$result = $db->query('
    SELECT t.* 
    FROM '.$db->prefix.'topics AS t 
    INNER JOIN '.$db->prefix.'forums AS f 
    ON f.id=t.forum_id 
    LEFT JOIN '.$db->prefix.'forum_perms AS fp 
    ON (
        fp.forum_id=f.id 
        AND fp.group_id='.$pun_user['g_id'].'
    ) 
    WHERE (
        fp.read_forum IS NULL 
        OR fp.read_forum=1
    ) 
    ORDER BY t.last_post DESC
    LIMIT '.$ak_limit
) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

$result = $db->query('
    SELECT t.* 
    FROM '.$db->prefix.'topics AS t 
    INNER JOIN '.$db->prefix.'forums AS f 
    ON f.id=t.forum_id 
    LEFT JOIN '.$db->prefix.'forum_perms AS fp 
    ON (
        fp.forum_id=f.id 
        AND fp.group_id='.$pun_user['g_id'].'
    ) 
    WHERE (
        fp.read_forum IS NULL 
        OR fp.read_forum=1
    ) AND f.id != 1
    ORDER BY t.last_post DESC
    LIMIT '.$ak_limit
) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

Re: Active Topics

null@example.com (staffanl) — Thu, 15 Nov 2007 13:36:08 +0000

Is it possible to remove some forums in mod_active_topics_1.2? I dont want forum id=1 to be displayed for example.

query('
    SELECT t.* 
    FROM '.$db->prefix.'topics AS t 
    INNER JOIN '.$db->prefix.'forums AS f 
    ON f.id=t.forum_id 
    LEFT JOIN '.$db->prefix.'forum_perms AS fp 
    ON (
        fp.forum_id=f.id 
        AND fp.group_id='.$pun_user['g_id'].'
    ) 
    WHERE (
        fp.read_forum IS NULL 
        OR fp.read_forum=1
    ) 
    ORDER BY t.last_post DESC
    LIMIT '.$ak_limit
) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

require PUN_ROOT.'lang/'.$pun_user['language'].'/forum.php';

?>

    Active Topics
    
        
            num_rows($result))
{
    while ($cur_topic = $db->fetch_assoc($result))
    {
        $icon_text = $lang_common['Normal icon'];
        $item_status = '';
        $icon_type = 'icon';

        if ($cur_topic['moved_to'] == null)
            $last_post = ''.format_time($cur_topic['last_post']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['last_poster']).'';
        else
            $last_post = ' ';

        if ($pun_config['o_censoring'] == '1')
            $cur_topic['subject'] = censor_words($cur_topic['subject']);

        if ($cur_topic['moved_to'] != 0)
            $subject = $lang_forum['Moved'].': '.pun_htmlspecialchars($cur_topic['subject']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'';
        else if ($cur_topic['closed'] == '0')
            $subject = ''.pun_htmlspecialchars($cur_topic['subject']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'';
        else
        {
            $subject = ''.pun_htmlspecialchars($cur_topic['subject']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'';
            $icon_text = $lang_common['Closed icon'];
            $item_status = 'iclosed';
        }

        if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'] && $cur_topic['moved_to'] == null)
        {
            $icon_text .= ' '.$lang_common['New icon'];
            $item_status .= ' inew';
            $icon_type = 'icon inew';
            $subject = ''.$subject.'';
            $subject_new_posts = '[ '.$lang_common['New posts'].' ]';
        }
        else
            $subject_new_posts = null;

        // Should we display the dot or not? :)
        if (1 == 0 && !$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1')
        {
            if ($cur_topic['has_posted'] == $pun_user['id'])
                $subject = '· '.$subject;
            else
                $subject = '  '.$subject;
        }

        if ($cur_topic['sticky'] == '1')
        {
            $subject = ''.$lang_forum['Sticky'].': '.$subject;
            $item_status .= ' isticky';
            $icon_text .= ' '.$lang_forum['Sticky'];
        }

        $num_pages_topic = ceil(($cur_topic['num_replies'] + 1) / $pun_user['disp_posts']);

        if ($num_pages_topic > 1)
            $subject_multipage = '[ '.paginate($num_pages_topic, -1, 'viewtopic.php?id='.$cur_topic['id']).' ]';
        else
            $subject_multipage = null;

        // Should we show the "New posts" and/or the multipage links?
        if (!empty($subject_new_posts) || !empty($subject_multipage))
        {
            $subject .= '  '.(!empty($subject_new_posts) ? $subject_new_posts : '');
            $subject .= !empty($subject_multipage) ? ' '.$subject_multipage : '';
        }

?>
                >

Re: Active Topics

null@example.com (thesaint) — Sat, 14 Jul 2007 07:17:42 +0000

hmm i want this in a portal block style...

Re: Active Topics

null@example.com (reviewum.com) — Sat, 14 Jul 2007 02:57:19 +0000

Sorry to dig up an old thread, but I'm a huge fan of the "Active Topics" mod (used it on my very first install of punBB years ago). I just installed "Mark as read" and I too can't get the Active Topics to be marked as read. Any suggestions?

Thanks!

Re: Active Topics

null@example.com (dss) — Wed, 19 Apr 2006 09:34:12 +0000

I'd like to integrate the 'Mark topic as read' Mod into the Active Topics 1.2

My question is how to translate this:

if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'] && $cur_topic['moved_to'] == null)
        {
            $icon_text .= ' '.$lang_common['New icon'];
            $item_status .= ' inew';
            $icon_type = 'icon inew';
            $subject = ''.$subject.'';
            $subject_new_posts = '[ '.$lang_common['New posts'].' ]';
        }
        else
            $subject_new_posts = null;

To relate to this modification from the viewtopic.php changes in the Mark topic as read mod

#
#---------[ 43. OPEN ]--------------------------------------------------------
#

viewtopic.php


#
#---------[ 44. FIND (line: 71) ]---------------------------------------------
#

    $result = $db->query('SELECT MIN(id) FROM '.$db->prefix.'posts WHERE topic_id='.$id.' AND posted>'.$pun_user['last_visit']) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());


#
#---------[ 45. REPLACE WITH ]------------------------------------------------
#

    // MOD: MARK TOPICS AS READ - 5 LINES NEW CODE FOLLOW
    if(!empty($pun_user['read_topic']['t'][$id])) {
        $last_read = $pun_user['read_topic']['t'][$id];
    } else { // if the user hasn't read the topic
        $last_read = $pun_user['last_visit'];
    }
    // MOD: MARK TOPICS AS READ - 1 LINE MODIFIED CODE FOLLOWS
    $result = $db->query('SELECT MIN(id) FROM '.$db->prefix.'posts WHERE topic_id='.$id.' AND posted>'.$last_read) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());


#
#---------[ 46. FIND (line: 105) ]--------------------------------------------
#

    $result = $db->query('SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id='.$id.' AND t.moved_to IS NULL') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());


#
#---------[ 47. REPLACE WITH ]------------------------------------------------
#

    // MOD: MARK TOPICS AS READ - 1 LINE MODIFIED CODE FOLLOWS
    $result = $db->query('SELECT t.subject, t.closed, t.num_replies, t.sticky, t.last_post, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id='.$id.' AND t.moved_to IS NULL') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error());


#
#---------[ 48. FIND (line: 115) ]--------------------------------------------
#

// Sort out who the moderators are and if we are currently a moderator (or an admin)


#
#---------[ 49. BEFORE, ADD ]-------------------------------------------------
#

// MOD: MARK TOPICS AS READ - 1 LINE NEW CODE FOLLOWS
if (!$pun_user['is_guest']) mark_topic_read($id, $cur_topic['forum_id'], $cur_topic['last_post']);


#
#---------[ 50. SAVE/UPLOAD ]-------------------------------------------------
#

Seems like it's possible, but the language is so different I've only been able to destroy it, not actually get it to work.

Re: Active Topics

null@example.com (Jasoco) — Sat, 21 Jan 2006 23:46:26 +0000

Awesome! I spent hours last night trying to make a Mod to my forum like this and failed spectacularly.

http://www.jasoco.net/geekpub/

Re: Active Topics

null@example.com (Zevs) — Thu, 08 Dec 2005 16:26:24 +0000

Very nice version this mod !

Re: Active Topics

null@example.com (Replika) — Wed, 07 Dec 2005 11:41:10 +0000

like vbulletin:
My forum

query('SELECT c.id AS cid...' or anywhere you want)
*/

$active_topic_limit = 7; // change this to the number of active topics you want to display.
$result = $db->query('SELECT t.* FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY t.last_post DESC    LIMIT '.$active_topic_limit) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

require PUN_ROOT.'lang/'.$pun_user['language'].'/forum.php';

?>

    Active Topics
    
        
            num_rows($result))
{
    echo '';
}
else
{
?>
                
            
';
    while ($cur_topic = $db->fetch_assoc($result))
    {
        $item_status = '';

        if ($pun_config['o_censoring'] == '1')
            $cur_topic['subject'] = censor_words($cur_topic['subject']);

        $last_post = ''.pun_htmlspecialchars($cur_topic['subject']).'';

        if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'])
        {
            $item_status .= ' inew';
            $last_post = ''.$last_post.'';
        }

        if ($cur_topic['sticky'] == '1')
        {
            $last_post = ''.$lang_forum['Sticky'].': '.$last_post;
            $item_status .= ' isticky';
        }
?>
            >
                    
                            
                                › '.$last_post.' » '.pun_htmlspecialchars($cur_topic['last_poster']).' » '.$lang_common['Replies'].': '.$cur_topic['num_replies'].' » '.$lang_forum['Views'].': '.$cur_topic['num_views'].' » '.format_time($cur_topic['last_post']).'';
                                ?>

Re: Active Topics

null@example.com (lebel) — Sat, 03 Dec 2005 16:28:22 +0000

Works perfect with 1.2.10
a great mods !

Re: Active Topics

null@example.com (alexkingorg) — Mon, 07 Mar 2005 19:06:15 +0000

Works fine.

Re: Active Topics

null@example.com (Ataxy) — Mon, 07 Mar 2005 19:05:49 +0000

as anybody tried it on 1.2.2

Re: Active Topics

null@example.com (reviewum.com) — Sun, 06 Mar 2005 19:46:08 +0000

Dang... I wish I was a programmer! Looking more closely there are aspects of both I like. For example the "new post" is really nice on the old version, but the layout and the number of views on the new one is great too. Decisions... decisions....

Thanks again for this ever important mod!

Re: Active Topics

null@example.com (reviewum.com) — Sun, 06 Mar 2005 17:42:11 +0000

Not to look a gift horse in the mouth (thanks alexkingorg for the update) but is there anybody with skillz that can make this included file / mod show like the old mod? I don't want to confuse my users and really like the old layout.

See the old version running here:
http://www.nifty-stuff.com/img/getimg/active_mod.gif

Thanks in advance!

'; while ($cur_topic = $db->fetch_assoc($result)) { $item_status = ''; if ($pun_config['o_censoring'] == '1') $cur_topic['subject'] = censor_words($cur_topic['subject']); $last_post = ''.pun_htmlspecialchars($cur_topic['subject']).''; if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit']) { $item_status .= ' inew'; $last_post = ''.$last_post.''; } if ($cur_topic['sticky'] == '1') { $last_post = ''.$lang_forum['Sticky'].': '.$last_post; $item_status .= ' isticky'; } ?> > › '.$last_post.' » '.pun_htmlspecialchars($cur_topic['last_poster']).' » '.$lang_common['Replies'].': '.$cur_topic['num_replies'].' » '.$lang_forum['Views'].': '.$cur_topic['num_views'].' » '.format_time($cur_topic['last_post']).''; ?>