phpBB España Oficial

Código: Seleccionar todo

    <?php

    define('IN_PHPBB', true);
    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './foro/';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup('viewforum');

    function last_topics_on_portal($limit = 3) {

        global $db, $template, $user, $auth;
        global $phpbb_root_path, $phpEx;
        global $phpbb_seo;

        $topics_ary = array(
            'SELECT' => 'f.*, t.*, u.username, u.user_colour',
            'FROM' => array(
                TOPICS_TABLE => 't',
            ),
            'LEFT_JOIN' => array(
                array(
                    'FROM' => array(USERS_TABLE => 'u'),
                    'ON' => 'u.user_id = t.topic_poster'
                ),
                array(
                    'FROM' => array(FORUMS_TABLE => 'f'),
                    'ON' => 't.forum_id = f.forum_id'
                ),
            ),
            'WHERE' => $db->sql_in_set('t.forum_id', array_keys($auth->acl_getf('f_read', true))) . '
            AND t.topic_status <> ' . ITEM_MOVED . '
            AND t.topic_approved = 1
            OR t.forum_id = 0', //OR t.forum_id = 0, esta linea es para que muestre tambien los globales ya que el id del foro de estos es 0
            'ORDER_BY' => 't.topic_id DESC',
        );

        $topics = $db->sql_build_query('SELECT', $topics_ary);

        $topics_result = $db->sql_query_limit($topics, $limit);
        echo "<ul>";
        while ($topics_row = $db->sql_fetchrow($topics_result)) {
            $forum_id = $topics_row['forum_id'];
            $topic_title = $topics_row['topic_title'];
            $topic_title = censor_text($topic_title);
            if (strlen($topic_title) > 50) {
                $topic_title = substr($topic_title, 0, 49) . "...";
            }
            $topic_author = get_username_string('full', $topics_row['topic_last_poster_id'], $topics_row['topic_first_poster_name'], $topics_row['topic_first_poster_colour']);
            $topic_link = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topics_row['forum_id'] . '&t=' . $topics_row['topic_id']);
            $forum_name = $topics_row['forum_name'];


            echo "<li style='margin-left:3px; line-height:1.0em'>";
            echo "<a href='$topic_link'>" . censor_text($topic_title) . "</a> por $topic_author<br />";
            echo "en <i><b>$forum_name</i></b>";
            echo "</li><hr />";
        }

        echo "</ul>";
    }

    last_topics_on_portal(3); // donde 3 es el numero de temas a mostrar.
    ?>