phpBB España Oficial

Código: Seleccionar todo

function last_topics_on_index($limit = 10) {

	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

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>
                <h3>&Uacute;ltimos mensajes</h3>
                <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}<br />
                        <strong>{L_AUTHOR}:</strong> {last_topics.TOPIC_AUTHOR}<br />
                        <strong>{L_FILEDATE}:</strong> {last_topics.TOPIC_DATE}<br /><br />
                        <!-- END last_post -->
                    </p>
                </div>
                <span class="corners-bottom"><span></span></span>
            </div>
        </div>
        <!-- ENDIF -->
        <!-- // fin ultimos mensajes by Alorse -->

Código: Seleccionar todo

luego solo debes ir al archivo newspage.php y al principio del archivo conde están los include has uno nuevo al archivo donde tienes mi código.

Código: Seleccionar todo

include($phpbb_root_path . 'alorsebarra.' . $phpEx);

Código: Seleccionar todo

General Error
SQL ERROR [ mysqli ]

[0]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.