<h1>&raquo; Noticias</h1>

<div align="justify">
<?php
//
// Configuration
//
$forum_id = 1;        //Forum ID to pull posts from
$num_posts = 7;        //Number of posts to display

//
// Auth
//
$can_read_forum = $auth->acl_getf('f_read');    //Get the forums the user can read from
$forum_id_ary = array_keys($can_read_forum);    //Rework the array some
unset($can_read_forum);

//
// Recent posts
//
if(array_key_exists($forum_id, $forum_id_ary))    //See if the user is authed to read from that forum
{
    $sql = 'SELECT p.post_id, t.topic_id, t.topic_replies, t.topic_views, p.post_subject, p.post_text, p.post_time, p.bbcode_bitfield, p.bbcode_uid, u.username
            FROM ' . TOPICS_TABLE . ' t 
                INNER JOIN ' . POSTS_TABLE . ' p ON (t.topic_id = p.topic_id)
                    INNER JOIN ' . USERS_TABLE . ' u ON (p.poster_id = u.user_id)
                        WHERE t.topic_approved = 1
                            AND p.post_approved = 1
                            AND p.forum_id = ' . $forum_id . ' 
                            AND p.post_id = t.topic_first_post_id
                        ORDER BY p.post_time DESC';

    $result = $db->sql_query_limit($sql, $num_postsn);
    $row = $db->sql_fetchrowset($result);

    for($i = 0; $i < $num_posts; $i++)
    {
        $post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $forum_id . '&amp;t=' . $row[$i]['topic_id'] . '&amp;p=' . $row[$i]['post_id'] . 'p' . $row[$i]['post_id']);

//-----------------+
      $views = $row[$i]['topic_views'];
      $reply = $row[$i]['topic_replies'];
//-----------------+
        $uid = $bitfield = $options = '';
        $allow_bbcode = $allow_smilies = $allow_urls = true;
        $flags = (($allow_bbcode) ? OPTION_FLAG_BBCODE : 0) + (($allow_smilies) ? OPTION_FLAG_SMILIES : 0) + (($allow_urls) ? OPTION_FLAG_LINKS : 0);


        $message = generate_text_for_display($row[$i]['post_text'], $row[$i]['bbcode_uid'], $row[$i]['bbcode_bitfield'], $flags);
//        $reply = generate_text_for_display( $row[$i]['topic_replies'], $flags);

        echo '<div width="90%"><span class="titulo">&nbsp;&nbsp;' . censor_text($row[$i]['post_subject']) . '</span>
              <br><span class="subtitulo">&nbsp;&nbsp;Escrito por <b><u><span title="' . $row[$i]['username'] . '">' . $row[$i]['username'] . '</span></u></b> el ' . date('d/m/Y [G:i]', $row[$i]['post_time']) . '</span><br>
              <div class="contenido">' . $message . '</div><br>&nbsp;&nbsp;<a href="' . $post_url . '"  target=\"_blank\">Leer todo</a> | ' . $reply .' Comentarios | '. $views .' Visitas<br>
<hr size=1>
                </div>';
    }

    $db->sql_freeresult($result); 
}
?>
<p align="center"><a href="foros/viewforum.php?f=1" target="_blank">Ver Todas Las Noticias</a></p>      
</div>

[url=http://www.paginaweb.com]Mi website[/url]

[url=http://www.pagina.com]pagina[/url] - [url]http://www.pagina.com[/url]