show recent posts auf der Startseite

            else if ($action == 'show_24h')
            {
                $result = $db->query('SELECT t.id 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.last_post>'.(time() - 86400)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

            else if ($action == 'show_24h')
            {
                $result = $db->query('SELECT t.id 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) limit 0,10') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

                $result = $db->query('SELECT t.id 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 0,10') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

<script language="php">
// If it's a search for the last x posts
            else if ($action == 'home')
            {
                $result = $db->query('SELECT t.id 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 0,10') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

                if (!$num_hits)
                    message($lang_search['No recent posts']);
            }
</script>

<script language="php">
// If it's a search for todays posts
            else if ($action == 'show_24h')
            {
                $result = $db->query('SELECT t.id 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.last_post>'.(time() - 86400)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
                $num_hits = $db->num_rows($result);

                if (!$num_hits)
                    message($lang_search['No recent posts']);
            }
</script>

<script language="php">
else
    {
        if ($action != 'show_new' && $action != 'show_24h' && $action != 'home' && $action != 'show_unanswered' && $action != 'show_subscriptions')
            message($lang_common['Bad request']);
    }
</script>

<script language="php">
}
        else if ($action == 'show_new' || $action == 'home' || $action == 'show_24h' || $action == 'show_user' || $action == 'show_subscriptions' || $action == 'show_unanswered')
        {
            // If it's a search for new posts
</script>

<div class="block">
    <h2 class="block2"><span><?php echo $lang_index['Recent Posts'] ?></span></h2>
    <div class="box">       
        <div class="inbox">
        <br/>
            <?php
            $trunc_len = 40; // Fill this in
            $result = $db->query('SELECT subject, last_post_id, id FROM '.$db_prefix.'topics ORDER BY last_post DESC LIMIT 5') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
            
            while($cur_topic = $db->fetch_assoc($result))
            {        
        ?>
            <a href="viewtopic.php?id=<?php echo $cur_topic['id']; ?>#p<?php echo $cur_topic['last_post_id']; ?>"><?php echo substr($cur_topic['subject'], 0, $trunc_len); ?>...</a>  
        <?php
            }
        ?>
        <br/><br/>
        </div>
    </div>
</div>

'Recent Posts'            =>    '5 neueste Posts',

'Recent Posts'            =>    '5 newest Posts',