phpBB España Oficial

Código: Seleccionar todo

   <!-- // inicio ultimos mensajes by Alorse -->
    <!-- IF not S_IS_BOT -->
    <div class="panel bg3">
        <div class="inner">
            <span class="corners-top"><span></span></span>
            <div class="content">
                <p>
                    <!-- BEGIN last_topics -->
                    <strong>{L_POST_SUBJECT}:</strong> <a href="{last_topics.TOPIC_LINK}">{last_topics.TOPIC_TITLE}</a> {last_topics.TOPIC_REPLIES} - Autor: {last_topics.TOPIC_AUTHOR}<br />
                    <br />
                    <!-- END last_post -->
                </p>
            </div>
           </div>
        </div>
    </div>
    <!-- ENDIF -->
    <!-- // fin ultimos mensajes by Alorse -->

Código: Seleccionar todo

// Output page
page_header($user->lang['INDEX']);


function last_topics_on_index($limit = 30) {

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

	$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);

	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);
		// add-on - number of replies on topic title
		$topic_replies = $topics_row['topic_replies'];
		$topic_replies = $topic_replies == 1 ? "(".$topics_row['topic_replies']." respuesta)" : "(".$topics_row['topic_replies']." respuestas)";
		$topic_replies = $topic_replies == '(0 respuestas)' ? '' : $topic_replies;
		$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_date = $user->format_date($topics_row['topic_time']);
		$topic_link = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topics_row['forum_id'] . '&t=' . $topics_row['topic_id']);

		$template->assign_block_vars('last_topics', array(
			'TOPIC_TITLE' => censor_text($topic_title),
			'TOPIC_AUTHOR' => $topic_author,
			'TOPIC_DATE' => $topic_date,
			'TOPIC_LINK' => $topic_link,
			'TOPIC_REPLIES' => $topic_replies,
		));
	}
}

last_topics_on_index(10);// donde 10 es el número de mensajes a mostrar

$template->set_filenames(array(
	'body' => 'index_body.html')
);

page_footer();





?>