Code:
<div class="block">
<h2><span><font color="#CCCC99"><b>Topics</b></font></span></h2>
<?
$result = $db->query('SELECT p.poster, p.id, p.topic_id, t.subject FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON p.topic_id = t.id INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id = f.id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (f.id = fp.forum_id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum = 1) AND p.posted > t.posted ORDER BY t.last_post DESC LIMIT 100') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
while($cur_topic = $db->fetch_assoc($result))
{
?>
<div class="box">
<div id="recenttopics" class="inbox">
<?php echo $cur_topic['posted']; ?> <a href="viewtopic.php?pid=<?php echo $cur_topic['id']; ?>#p<?php echo $cur_topic['id']; ?>" target=_blank><?php echo substr($cur_topic['subject'], 0, 50); ?></a> <i><font color="#CCCC99"><?php echo $cur_topic['poster']; ?></font></i><br>
</div>
</div>
<?