Active Topics (Page 2 of 3)

    ORDER BY t.last_post DESC

<?php
/*
PunBB Active Topics Lite by aFeLiOn
Based on "Mod Active Topics" of Alex King, http://www.alexking.org/
This is a mod for PunBB, http://punbb.org/
PunBB is Copyright (C) 2005  Rickard Andersson (rickard@punbb.org)
-------------------------------
To install, include this file below the forums list in your index.php file:
  include('mod_active_topics.php');
  (Before line: '$result = $db->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';

?>
<div id="vf" class="blocktable">
    <h2><span>Active Topics</span></h2>
    <div class="box">
        <div class="inbox">
            <table cellspacing="0">
            <tbody>
<?php
// If there are topics in this forum.
if ($db->num_rows($result))
{
    echo '<tr><td class="tcl">';
    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 = '<a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a>';

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

        if ($cur_topic['sticky'] == '1')
        {
            $last_post = '<span class="stickytext">'.$lang_forum['Sticky'].': </span>'.$last_post;
            $item_status .= ' isticky';
        }
?>
            <div<?php if ($item_status != '') echo ' class="'.trim($item_status).'"'; ?>>
                    <div class="intd">
                            <div class="tclcon">
                                <?php
                                 echo '<font color="#FF9900"><strong>›</strong></font> '.$last_post.' <span class="byuser">» '.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']).'</span>';
                                ?>
                            </div>
                        </div>
                    </div>
<?php
    }
    echo '</td></tr>';
}
else
{
?>
                <tr>
                    <td class="tcl" colspan="4"><?php echo '*EMPTY*' ?></td>
                </tr>
<?php

}
?>
            </tbody>
            </table>
        </div>
    </div>
</div>