Añadir ultimos post a una barra lateralTema Solucionado

[Turbooo]

Me gustaria saber que codigo tendria que poner en la barra lateral que le he puesto a mi foro para poder ver los ultimos post creados en el foro.

Tambien me gustaria poner en la barra lateral el mini menu del usuario en el q aparece su avartar, justamente como el q teneis en este foro

gracias de antemano

[angelismo]

Tendrias que instalar el silverbar mod ,con la barra de mitch no se puede ,aunque se podria intentar programar esos bloques.

[Turbooo]

Tendrias que instalar el silverbar mod ,con la barra de mitch no se puede ,aunque se podria intentar programar esos bloques.

el caso es q yo he estado probando de programar como tu dices y lo unico q he conseguido es poner el buscador, anuncios y los minibanners

cuando ponia reloj, calendario, ultimos egistrados , ecttt no funcionaban

llebo detras de esa barra silvebar mucho tiempo , lo q pasa q no esta en este foro, pone modificando....

a ver si alguien q la tenga me la pasa

saludos

[ThE KuKa]

Y así es, la barra mostrada aquí usa "parte" de dicho MOD, pero esta bastante "retocada" por mi. Recordar lo que hice en su día es complicado, se que el MOD carga la barra en el overall_header.html cosa que yo NO quería, ya que lo que quería era mostrar según que cosas en según que páginas.

Este sitio usa tres, cuatro o cinco barras distintas, una para el indice de foros, otra para faq.php, otra para search.php, otra en la página de noticias, otra en la página de quien esta conectado, etc.

Por ejemplo para incrustar la barra en faq.php en realidad lo que hago es un include en faq_body.html de este modo:

Código: Seleccionar todo

<!-- INCLUDE overall_header.html -->
<!-- INCLUDE sidebar_body_faq.html -->

Osea al principio del archivo .HTML la primera linea que encontramos es el include del encabezado del foro <!-- INCLUDE overall_header.html --> lo que hago es añadir mi barra debajo de esa linea

¿Que código hay en sidebar_body_faq.html? mostrare la "base" ya que todo no lo pongo, no por nada, si no por diferentes includes que no vienen a cuento...

Spoiler

Código: Seleccionar todo

<!-- IF PAGE_TITLE eq L_LOGIN or PAGE_TITLE eq L_INFORMATION or PAGE_TITLE eq "Forum Chat" or PAGE_TITLE eq L_CONFIRM or S_IN_MCP or S_IN_UCP -->
<!-- ELSE -->
<!-- IF not S_IS_BOT -->
<table cellspacing="0" cellpadding="3" border="0" width="100%" style="padding-right: 10px;">
    <tr>
    <td width="200" valign=top style="margin-left: 10px;">
<div class="panel bg2">
<span class="corners-top"><span></span></span>
<div style="text-align: center; font-weight: bold;">Titulo de un bloque</div><hr />
<div align="left">
&bull; <a href="descargas.php" title="Descargas en phpBB-Es">Descargas en phpBB-Es</a><br />
&bull; <a href="http://code.google.com/p/phpbb-es/" target="_blank" title="Descargas en Google Code de phpBB-Es">Google Code de phpBB-Es</a><br />
&bull; <a href="https://sourceforge.net/projects/phpbb-es/" target="_blank" title="Descargas en SourceForge de phpBB-Es">SourceForge de phpBB-Es</a><br />
&bull; <a href="https://www.ohloh.net/p/phpbb-es" target="_blank" title="Descargas en Ohloh de phpBB-Es">Ohloh de phpBB-Es</a>
</div>
<span class="corners-bottom"><span></span></span></div>
<br />
<div class="panel bg2">
<span class="corners-top"><span></span></span>
<div style="text-align: center; font-weight: bold;">Aquí bloque de enlaces</div><hr />
<!-- INCLUDE sidebar_board_links.html -->
<span class="corners-bottom"><span></span></span></div>
<br />
<!-- INCLUDE sidebar_recent_topics.html -->
<br />
<div class="panel bg2">
<span class="corners-top"><span></span></span>
<div style="text-align: center; font-weight: bold;">Mapa de Visitas que ves en la web</div><hr />
<div style="text-align: center">
<a href="http://www4.clustrmaps.com/counter/maps.php?url=http://www.phpbb-es.com" id="clustrMapsLink" target="_blank"><img src="http://www4.clustrmaps.com/counter/index2.php?url=http://www.phpbb-es.com" style="border:0px;" alt="Desde donde visitan esta p&aacute;gina" title="Desde donde visitan esta p&aacute;gina" id="clustrMapsImg" onerror="this.onerror=null; this.src='http://www2.clustrmaps.com/images/clustrmaps-back-soon.jpg'; document.getElementById('clustrMapsLink').href='http://www2.clustrmaps.com';" />
</a>
</div>
<span class="corners-bottom"><span></span></span></div>
<br />
<div class="panel bg2"><span class="corners-top"><span></span></span>
<div style="text-align: center; font-weight: bold;">Publicidad</div><hr />
<div style="text-align: center">
AQUÍ TU CÓDIGO DE PUBLICIDAD DE 120X600 POR EJEMPLO
</div>
<span class="corners-bottom"><span></span></span></div>
    </td>
    <td width="10" valign=top>
    </td>
    <td valign=top>
<!-- ELSE -->
{L_SIDEBAR_BOT_INFO}
<!-- ENDIF -->
<!-- ENDIF -->

Basándonos en este código se podría usar como "plantilla" para cada barra, solo seria cuestión de cambiar el nombre de la barra, y del include en cuestión

Lo de los últimos mensajes es instalar el MOD "a trozos" solo lo que interesa por ejemplo si vamos a usar la barra de MODs con mensajes por aprobar o no, etc.

Supongamos que SOLO quieres lo de los últimos mensajes en el foro.

Crea un archivo llamado functions_barra.php con este código y copialo en la carpeta /includes/ de tu foro.

Spoiler

Código: Seleccionar todo

<?php
/**
*
*===================================================================
*
*  BEGIN Silverbar MOD Functions File
*-------------------------------------------------------------------
*	Script info:
* Version:		 ( 0.6.0 - Beta										)
* Last release:	 ( 6/12/2008  |||  5:46 PM [ GMT - 5 ] 						)
* Copyright: 	 ( (c) 2008 - sTraTo 									)
* License: 		 ( http://opensource.org/licenses/gpl-license.php  |||  GNU Public License 	)
* Package:		 ( phpBB3											)
*
*===================================================================
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/****\
	*
	* @function		grab_recent_topics
	* @description		Grabs the most recent topics and prepares to display them.
	* @globals			$db for queries, $user for permissions checking, $config if needed, $auth for permissions check, __
	* 					$phpbb_root_path for filepath, $phpEx for PHP extension, $template for template file prep
	*
	* @param integer		$limit_amt	(Number of topics to grab)
	*
	* @usage-example	grab_recent_topics(10);
	* @usage-example	grab_recent_topics();
	*
	* @copyright 		(c) nickvergessen ( http://mods.flying-bits.org/ )
	*					( Code reused from the NV Recent Topics MOD, legal under the GNU GPL v2 )
	* @function-license 	http://opensource.org/licenses/gpl-license.php ( GNU Public License )
	*
	*
\****/
	
	function grab_recent_topics($limit_amt = 5)
	{
		global $db, $auth, $user, $template;
		global $phpbb_root_path, $phpEx, $config;
		
		$user_id = $user->data['user_id'];
		$limit = 1;
		if ($limit_amt >= $limit)
		{
			$limit = $limit_amt;
		}
		
		if ($limit_amt >= 10)
		{
			$limit = 10;
		}
		
		$template->assign_vars(array(
			'RT_DISPLAY'				=> true,
			'NEWEST_POST_IMG'			=> $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
		));

		$rt_anti_topics = '0';
		$onlyforum = 0;
		$onlyforum = request_var('f', 0);
		$sql = 'SELECT * FROM ' . FORUMS_TABLE . "
					ORDER BY left_id";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
		{
			if (strstr($onlyforum, $row['parent_id']))
			{
				$onlyforum .= ', ' . $row['forum_id'];
			}
		}
		$db->sql_freeresult($result);
		$forum_ary = array();
		$forum_read_ary = $auth->acl_getf('f_read');
		foreach ($forum_read_ary as $forum_id => $allowed)
		{
			if ($allowed['f_read'])
			{
				$forum_ary[] = (int) $forum_id;
			}
		}
		$forum_ary = array_unique($forum_ary);
		$forum_sql = (sizeof($forum_ary)) ? $db->sql_in_set('t.forum_id', $forum_ary, false) : $db->sql_in_set('t.forum_id', '0', false);

		$keeponrunning = $topic_id = 0;

		$sql = 'SELECT t.*, i.icons_url, i.icons_width, i.icons_height, tp.topic_posted, f.forum_name, f.forum_type, f.forum_flags
			FROM ' . TOPICS_TABLE . ' t
			LEFT JOIN ' . TOPICS_POSTED_TABLE . ' tp
				ON (t.topic_id = tp.topic_id
					AND tp.user_id = ' . $user_id . ')
			LEFT JOIN ' . FORUMS_TABLE . ' f
				ON f.forum_id = t.forum_id
			LEFT JOIN ' . ICONS_TABLE . ' i
				ON t.icon_id = i.icons_id
			WHERE
				(
					' . $forum_sql . '
					' . (($onlyforum) ? ' AND f.forum_id IN (' . $onlyforum . ')': '') . "
					" . (($rt_anti_topics) ? ' AND t.topic_id not IN (' . $rt_anti_topics . ')': '') . "
				)
				OR t.topic_type IN (" . POST_GLOBAL . ")
			GROUP BY t.topic_last_post_id
			ORDER BY t.topic_last_post_time DESC
			LIMIT $limit";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
		{
			$topic_id = $row['topic_id'];
			$forum_id = $row['forum_id'];
			$s_type_switch_test = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
			$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];
			$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id, $global_announce_list = false);
			$unread_topic = (isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
			$folder_img = $folder_alt = $topic_type = $folder = $folder_new = '';
			switch ($row['topic_type'])
			{
				case POST_GLOBAL:
					$topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];
					$folder = 'global_read';
					$folder_new = 'global_unread';
					$forum_id = request_var('sf', 2);
				break;
				case POST_ANNOUNCE:
					$topic_type = $user->lang['VIEW_TOPIC_ANNOUNCEMENT'];
					$folder = 'announce_read';
					$folder_new = 'announce_unread';
				break;
				case POST_STICKY:
					$topic_type = $user->lang['VIEW_TOPIC_STICKY'];
					$folder = 'sticky_read';
					$folder_new = 'sticky_unread';
				break;
				default:
					$topic_type = '';
					$folder = 'topic_read';
					$folder_new = 'topic_unread';
					if ($config['hot_threshold'] && $replies >= $config['hot_threshold'] && $row['topic_status'] != ITEM_LOCKED)
					{
						$folder .= '_hot';
						$folder_new .= '_hot';
					}
				break;
			}
			if ($row['topic_status'] == ITEM_LOCKED)
			{
				$topic_type = $user->lang['VIEW_TOPIC_LOCKED'];
				$folder .= '_locked';
				$folder_new .= '_locked';
			}
			if ($row['topic_posted'])
			{
				$folder .= '_mine';
				$folder_new .= '_mine';
			}
			if ($row['topic_type'] == POST_GLOBAL)
			{
				$global_announce_list[$row['topic_id']] = true;
			}
			$folder_img = ($unread_topic) ? $folder_new : $folder;
			$folder_alt = ($unread_topic) ? 'NEW_POSTS' : (($row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_NEW_POSTS');
			if ($row['poll_start'] && $row['topic_status'] != ITEM_MOVED)
			{
				$topic_type = $user->lang['VIEW_TOPIC_POLL'];
			}
			$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . '&t=' . $topic_id);
			$view_forum_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
			$topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
			$posts_unapproved = ($row['topic_approved'] && $row['topic_replies'] < $row['topic_replies_real'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
			$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&t=$topic_id", true, $user->session_id) : '';
			$s_type_switch = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
			$template->assign_block_vars('recenttopicrow', array(
				'FORUM_ID'					=> $forum_id,
				'TOPIC_ID'					=> $topic_id,
				'TOPIC_AUTHOR_FULL'			=> get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
				'FIRST_POST_TIME'			=> $user->format_date($row['topic_time']),
				'LAST_POST_SUBJECT'			=> censor_text($row['topic_last_post_subject']),
				'LAST_POST_TIME'			=> $user->format_date($row['topic_last_post_time']),
				'LAST_VIEW_TIME'			=> $user->format_date($row['topic_last_view_time']),
				'LAST_POST_AUTHOR'			=> get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
				'LAST_POST_AUTHOR_COLOUR'	=> get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
				'LAST_POST_AUTHOR_FULL'		=> get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
				//'PAGINATION'				=> topic_generate_pagination($replies, $view_topic_url),
				'REPLIES'					=> $replies,
				'VIEWS'						=> $row['topic_views'],
				'TOPIC_TITLE'				=> censor_text($row['topic_title']),
				'FORUM_NAME'				=> $row['forum_name'],
				'TOPIC_TYPE'				=> $topic_type,
				'TOPIC_FOLDER_IMG'			=> $user->img($folder_img, $folder_alt),
				'TOPIC_FOLDER_IMG_SRC'		=> $user->img($folder_img, $folder_alt, false, '', 'src'),
				'TOPIC_FOLDER_IMG_ALT'		=> $user->lang[$folder_alt],
				'NEWEST_POST_IMG'			=> $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
				'TOPIC_ICON_IMG'			=> (!empty($row['icons_url'])) ? $row['icons_url'] : '',
				'TOPIC_ICON_IMG_WIDTH'		=> (!empty($row['icons_url'])) ? $row['icons_width'] : '',
				'TOPIC_ICON_IMG_HEIGHT'		=> (!empty($row['icons_url'])) ? $row['icons_height'] : '',
				'ATTACH_ICON_IMG'			=> ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',
				'UNAPPROVED_IMG'			=> ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',
				'S_TOPIC_TYPE'				=> $row['topic_type'],
				'S_USER_POSTED'				=> (isset($row['topic_posted']) && $row['topic_posted']) ? true : false,
				'S_UNREAD_TOPIC'			=> $unread_topic,
				'S_TOPIC_REPORTED'			=> (!empty($row['topic_reported']) && $auth->acl_get('m_report', $forum_id)) ? true : false,
				'S_TOPIC_UNAPPROVED'		=> $topic_unapproved,
				'S_POSTS_UNAPPROVED'		=> $posts_unapproved,
				'S_HAS_POLL'				=> ($row['poll_start']) ? true : false,
				'S_POST_ANNOUNCE'			=> ($row['topic_type'] == POST_ANNOUNCE) ? true : false,
				'S_POST_GLOBAL'				=> ($row['topic_type'] == POST_GLOBAL) ? true : false,
				'S_POST_STICKY'				=> ($row['topic_type'] == POST_STICKY) ? true : false,
				'S_TOPIC_LOCKED'			=> ($row['topic_status'] == ITEM_LOCKED) ? true : false,
				'S_TOPIC_MOVED'				=> ($row['topic_status'] == ITEM_MOVED) ? true : false,
				'U_NEWEST_POST'				=> $view_topic_url . '&view=unread#unread',
				'U_LAST_POST'				=> $view_topic_url . '&p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],
				'U_LAST_POST_AUTHOR'		=> get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
				'U_TOPIC_AUTHOR'			=> get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
				'U_VIEW_TOPIC'				=> $view_topic_url,
				'U_VIEW_FORUM'				=> $view_forum_url,
				'U_MCP_REPORT'				=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=reports&f=' . $forum_id . '&t=' . $topic_id, true, $user->session_id),
				'U_MCP_QUEUE'				=> $u_mcp_queue,
				'S_TOPIC_TYPE_SWITCH'		=> ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test,
			));
			$template->assign_vars(array('S_RECENT_POSTS'	=> true));
		}
		$db->sql_freeresult($result);
	}  //end recent topics

?>

Ahora se trata de abrir el /includes/functions.php

BUSCAR:

Código: Seleccionar todo

// The following assigns all _common_ variables that may be used at any point in a template.

ANTES AÑADIR:

Código: Seleccionar todo

    //-- Barra ultimos mensajes --------------------------------------------------
	//-- add
	include_once($phpbb_root_path . 'includes/functions_barra.' . $phpEx);
	
	//Mensajes a mostrar
	//Si quieres mostrar mas de 5, cambialo por 10 o los que quieras
	grab_recent_topics(5);
	
	//-- Barra ultimos mensajes --------------------------------------------------

Y por último, subir el archivo /styles/prosilver/template/sidebar_recent_topics.html que es este de aquí abajo

Código: Seleccionar todo

<!-- $Id: recent_topics_body.html 68 2008-01-06 01:03:56Z nickvergessen $ -->
<div class="panel bg2">
	<div class="inner"><span class="corners-top"><span></span></span>
<!-- BEGIN recenttopicrow -->

<!-- IF recenttopicrow.S_FIRST_ROW or not recenttopicrow.S_TOPIC_TYPE_SWITCH -->
		<div style="text-align: center; padding-top: 6px; margin: 0 auto; font-weight: bold;"><a href="{U_SEARCH_NEW}">Temas recientes</a></div>
		<hr /><br />
<marquee behavior="scroll" direction="up" height="90" scrolldelay="150" scrollamount="5" loop="true" onmouseover="this.stop()" onmouseout="this.start()">
	<!-- ENDIF -->
	<div style="width: 90%;"><!-- IF recenttopicrow.S_UNREAD_TOPIC --><a href="{recenttopicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --> <a href="{recenttopicrow.U_VIEW_TOPIC}" class="topictitle">{recenttopicrow.TOPIC_TITLE}</a><br />{L_POST_BY_AUTHOR} {recenttopicrow.LAST_POST_AUTHOR_FULL}</div>

    <!-- IF recenttopicrow.S_LAST_ROW -->

	<!-- ENDIF -->
<!-- END recenttopicrow -->
  </marquee>
	<br />
	<span class="corners-bottom"><span></span></span></div>
</div>
<br />

y a ver si funciona...

Intentare hacer una guía mas exhaustiva sobre este tema en cuanto pueda.

[Turbooo]

Bueno antes de empezar te doy las gracias enormente por el tiempo que pierdes conmigo.

Y antes de nada preguntarte si tendria que tener instalado el mod silverbar para hacer eso q me dices, o vale con la barra que tengo de Morph

[angelismo]

Te vale con la barra de moprh ,no tienes que instalar el silverbarmod ,de hecho yo lo he hecho con la barra de mitch.

[ThE KuKa]

No, no hace falta, eso es HTML "puro y duro" con algún include HTML y/o PHP poco más...

Eso que he puesto no lo he comprobado, mañana a ver si hago algunas pruebas (no lo prometo por falta de tiempo) pero si tengo un hueco, pruebo, y así voy paso a paso, pero en principio, debería funcionar sin problemas.

[Ronald_doom]

ps yo tengo un bloque de "ultimos mensaje" solo que modifique el mod "recent topics" y lo adapte a mi barra, si te interesa, solo tienes que borrar los datos que no te pueden servir

[Turbooo]

A ver no se si estoy confundido, he hecho solo esto

Supongamos que SOLO quieres lo de los últimos mensajes en el foro.

Crea un archivo llamado functions_barra.php con este código y copialo en la carpeta /includes/ de tu foro.

Spoiler: Mostrar
Código: Seleccionar todo
<?php
/**
*
*===================================================================
*
* BEGIN Silverbar MOD Functions File
*-------------------------------------------------------------------
* Script info:
* Version: ( 0.6.0 - Beta )
* Last release: ( 6/12/2008 ||| 5:46 PM [ GMT - 5 ] )
* Copyright: ( (c) 2008 - sTraTo )
* License: ( http://opensource.org/licenses/gpl-license.php" onclick="window.open(this.href);return false; ||| GNU Public License )
* Package: ( phpBB3 )
*
*===================================================================
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}

/****\
*
* @function grab_recent_topics
* @description Grabs the most recent topics and prepares to display them.
* @globals $db for queries, $user for permissions checking, $config if needed, $auth for permissions check, __
* $phpbb_root_path for filepath, $phpEx for PHP extension, $template for template file prep
*
* @param integer $limit_amt (Number of topics to grab)
*
* @usage-example grab_recent_topics(10);
* @usage-example grab_recent_topics();
*
* @copyright (c) nickvergessen ( http://mods.flying-bits.org/" onclick="window.open(this.href);return false; )
* ( Code reused from the NV Recent Topics MOD, legal under the GNU GPL v2 )
* @function-license http://opensource.org/licenses/gpl-license.php" onclick="window.open(this.href);return false; ( GNU Public License )
*
*
\****/

function grab_recent_topics($limit_amt = 5)
{
global $db, $auth, $user, $template;
global $phpbb_root_path, $phpEx, $config;

$user_id = $user->data['user_id'];
$limit = 1;
if ($limit_amt >= $limit)
{
$limit = $limit_amt;
}

if ($limit_amt >= 10)
{
$limit = 10;
}

$template->assign_vars(array(
'RT_DISPLAY' => true,
'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
));

$rt_anti_topics = '0';
$onlyforum = 0;
$onlyforum = request_var('f', 0);
$sql = 'SELECT * FROM ' . FORUMS_TABLE . "
ORDER BY left_id";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
if (strstr($onlyforum, $row['parent_id']))
{
$onlyforum .= ', ' . $row['forum_id'];
}
}
$db->sql_freeresult($result);
$forum_ary = array();
$forum_read_ary = $auth->acl_getf('f_read');
foreach ($forum_read_ary as $forum_id => $allowed)
{
if ($allowed['f_read'])
{
$forum_ary[] = (int) $forum_id;
}
}
$forum_ary = array_unique($forum_ary);
$forum_sql = (sizeof($forum_ary)) ? $db->sql_in_set('t.forum_id', $forum_ary, false) : $db->sql_in_set('t.forum_id', '0', false);

$keeponrunning = $topic_id = 0;

$sql = 'SELECT t.*, i.icons_url, i.icons_width, i.icons_height, tp.topic_posted, f.forum_name, f.forum_type, f.forum_flags
FROM ' . TOPICS_TABLE . ' t
LEFT JOIN ' . TOPICS_POSTED_TABLE . ' tp
ON (t.topic_id = tp.topic_id
AND tp.user_id = ' . $user_id . ')
LEFT JOIN ' . FORUMS_TABLE . ' f
ON f.forum_id = t.forum_id
LEFT JOIN ' . ICONS_TABLE . ' i
ON t.icon_id = i.icons_id
WHERE
(
' . $forum_sql . '
' . (($onlyforum) ? ' AND f.forum_id IN (' . $onlyforum . ')': '') . "
" . (($rt_anti_topics) ? ' AND t.topic_id not IN (' . $rt_anti_topics . ')': '') . "
)
OR t.topic_type IN (" . POST_GLOBAL . ")
GROUP BY t.topic_last_post_id
ORDER BY t.topic_last_post_time DESC
LIMIT $limit";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$topic_id = $row['topic_id'];
$forum_id = $row['forum_id'];
$s_type_switch_test = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];
$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id, $global_announce_list = false);
$unread_topic = (isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
$folder_img = $folder_alt = $topic_type = $folder = $folder_new = '';
switch ($row['topic_type'])
{
case POST_GLOBAL:
$topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];
$folder = 'global_read';
$folder_new = 'global_unread';
$forum_id = request_var('sf', 2);
break;
case POST_ANNOUNCE:
$topic_type = $user->lang['VIEW_TOPIC_ANNOUNCEMENT'];
$folder = 'announce_read';
$folder_new = 'announce_unread';
break;
case POST_STICKY:
$topic_type = $user->lang['VIEW_TOPIC_STICKY'];
$folder = 'sticky_read';
$folder_new = 'sticky_unread';
break;
default:
$topic_type = '';
$folder = 'topic_read';
$folder_new = 'topic_unread';
if ($config['hot_threshold'] && $replies >= $config['hot_threshold'] && $row['topic_status'] != ITEM_LOCKED)
{
$folder .= '_hot';
$folder_new .= '_hot';
}
break;
}
if ($row['topic_status'] == ITEM_LOCKED)
{
$topic_type = $user->lang['VIEW_TOPIC_LOCKED'];
$folder .= '_locked';
$folder_new .= '_locked';
}
if ($row['topic_posted'])
{
$folder .= '_mine';
$folder_new .= '_mine';
}
if ($row['topic_type'] == POST_GLOBAL)
{
$global_announce_list[$row['topic_id']] = true;
}
$folder_img = ($unread_topic) ? $folder_new : $folder;
$folder_alt = ($unread_topic) ? 'NEW_POSTS' : (($row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_NEW_POSTS');
if ($row['poll_start'] && $row['topic_status'] != ITEM_MOVED)
{
$topic_type = $user->lang['VIEW_TOPIC_POLL'];
}
$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . '&t=' . $topic_id);
$view_forum_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
$topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
$posts_unapproved = ($row['topic_approved'] && $row['topic_replies'] < $row['topic_replies_real'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&t=$topic_id", true, $user->session_id) : '';
$s_type_switch = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;
$template->assign_block_vars('recenttopicrow', array(
'FORUM_ID' => $forum_id,
'TOPIC_ID' => $topic_id,
'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
'FIRST_POST_TIME' => $user->format_date($row['topic_time']),
'LAST_POST_SUBJECT' => censor_text($row['topic_last_post_subject']),
'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),
'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),
'LAST_POST_AUTHOR' => get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
'LAST_POST_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
//'PAGINATION' => topic_generate_pagination($replies, $view_topic_url),
'REPLIES' => $replies,
'VIEWS' => $row['topic_views'],
'TOPIC_TITLE' => censor_text($row['topic_title']),
'FORUM_NAME' => $row['forum_name'],
'TOPIC_TYPE' => $topic_type,
'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt),
'TOPIC_FOLDER_IMG_SRC' => $user->img($folder_img, $folder_alt, false, '', 'src'),
'TOPIC_FOLDER_IMG_ALT' => $user->lang[$folder_alt],
'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
'TOPIC_ICON_IMG' => (!empty($row['icons_url'])) ? $row['icons_url'] : '',
'TOPIC_ICON_IMG_WIDTH' => (!empty($row['icons_url'])) ? $row['icons_width'] : '',
'TOPIC_ICON_IMG_HEIGHT' => (!empty($row['icons_url'])) ? $row['icons_height'] : '',
'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',
'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',
'S_TOPIC_TYPE' => $row['topic_type'],
'S_USER_POSTED' => (isset($row['topic_posted']) && $row['topic_posted']) ? true : false,
'S_UNREAD_TOPIC' => $unread_topic,
'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && $auth->acl_get('m_report', $forum_id)) ? true : false,
'S_TOPIC_UNAPPROVED' => $topic_unapproved,
'S_POSTS_UNAPPROVED' => $posts_unapproved,
'S_HAS_POLL' => ($row['poll_start']) ? true : false,
'S_POST_ANNOUNCE' => ($row['topic_type'] == POST_ANNOUNCE) ? true : false,
'S_POST_GLOBAL' => ($row['topic_type'] == POST_GLOBAL) ? true : false,
'S_POST_STICKY' => ($row['topic_type'] == POST_STICKY) ? true : false,
'S_TOPIC_LOCKED' => ($row['topic_status'] == ITEM_LOCKED) ? true : false,
'S_TOPIC_MOVED' => ($row['topic_status'] == ITEM_MOVED) ? true : false,
'U_NEWEST_POST' => $view_topic_url . '&view=unread#unread',
'U_LAST_POST' => $view_topic_url . '&p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],
'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
'U_TOPIC_AUTHOR' => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
'U_VIEW_TOPIC' => $view_topic_url,
'U_VIEW_FORUM' => $view_forum_url,
'U_MCP_REPORT' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=reports&f=' . $forum_id . '&t=' . $topic_id, true, $user->session_id),
'U_MCP_QUEUE' => $u_mcp_queue,
'S_TOPIC_TYPE_SWITCH' => ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test,
));
$template->assign_vars(array('S_RECENT_POSTS' => true));
}
$db->sql_freeresult($result);
} //end recent topics

?>

Ahora se trata de abrir el /includes/functions.php

BUSCAR:

Código: Seleccionar todo
// The following assigns all _common_ variables that may be used at any point in a template.

ANTES AÑADIR:

Código: Seleccionar todo
//-- Barra ultimos mensajes --------------------------------------------------
//-- add
include_once($phpbb_root_path . 'includes/functions_barra.' . $phpEx);

//Mensajes a mostrar
//Si quieres mostrar mas de 5, cambialo por 10 o los que quieras
grab_recent_topics(5);

//-- Barra ultimos mensajes --------------------------------------------------


Y por último, subir el archivo /styles/prosilver/template/sidebar_recent_topics.html que es este de aquí abajo

Código: Seleccionar todo
<!-- $Id: recent_topics_body.html 68 2008-01-06 01:03:56Z nickvergessen $ -->
<div class="panel bg2">
<div class="inner"><span class="corners-top"><span></span></span>
<!-- BEGIN recenttopicrow -->

<!-- IF recenttopicrow.S_FIRST_ROW or not recenttopicrow.S_TOPIC_TYPE_SWITCH -->
<div style="text-align: center; padding-top: 6px; margin: 0 auto; font-weight: bold;"><a href="{U_SEARCH_NEW}">Temas recientes</a></div>
<hr /><br />
<marquee behavior="scroll" direction="up" height="90" scrolldelay="150" scrollamount="5" loop="true" onmouseover="this.stop()" onmouseout="this.start()">
<!-- ENDIF -->
<div style="width: 90%;"><!-- IF recenttopicrow.S_UNREAD_TOPIC --><a href="{recenttopicrow.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF --> <a href="{recenttopicrow.U_VIEW_TOPIC}" class="topictitle">{recenttopicrow.TOPIC_TITLE}</a><br />{L_POST_BY_AUTHOR} {recenttopicrow.LAST_POST_AUTHOR_FULL}</div>

<!-- IF recenttopicrow.S_LAST_ROW -->

<!-- ENDIF -->
<!-- END recenttopicrow -->
</marquee>
<br />
<span class="corners-bottom"><span></span></span></div>
</div>
<br />

y a ver si funciona...

y a mi no me sale nada

mi pregunta es si tengo q hacer tambien lo q explica antes the Kuka

[angelismo]

Incluye el codigo del sidebar_recent_topics.html el overall_header.html al final del codigo de la barra de morph.

[Turbooo]

perfecto!!! ahora si, gracias a los dos The Kuka y angelisimo

por cierto como dice de Kuka hay q hacer un manual de esto, vendra muy bien

saludos

[angelismo]

De nada.
Yo voy a hacer una guia de como integrar este bloque en la barra de mitch.

[YOLANDA]

HolaURL: http://www.rebeccaloos.es" onclick="window.open(this.href);return false;
Versión phpBB: phpBB2 (2.0.22)
MODs Instalados: (1, 'EasyMOD', 'easymod/easymod_install.php',
(2, 'Multiple BBCode MOD',
(3, 'YouTube Video BBCode',
(4, 'ACP Site Announcement Centre',
(5, 'Birthday',
(6, 'Tags in Forum phpBB', 'tags_foro_phpbb011/install.txt', '0.1.1', 'ThE KuKa', 'thekukaATphpbb-esDOTcom', 'Raul', 'http://www.phpbb-es.com', 'Add some Tags in your View Topic.', 1215368721, '2.0.22', 'subSilver; becca', 'spanish; english', 2, 0, 0, 0),
(7, 'Digg, Del.icio.us & Slashdot Mod',
(8, 'Security Question Mod',
(9, 'User Last Active',

Plantilla(s) usada(s): subsilver
Servidor: de pago
Actualización desde otra versión: No
Conversión desde otro sistema de foros: No



Hola,

solo quiero mostrar los últimos cinco post en la barra lateral de mi foro. Me estoy volviendo loca.
He tomado el código que señaláis:
functions_barra.php (he copiado todo el código que pones)
functions.php (he añadido las lineas que indicas)
overal_header.tpl (en mi caso, que es donde quiero que me aparezcan los últimos post)

Me sale este error:
"Fatal error: Call to a member function assign_vars() on a non-object in /home/fruit/public_html/phpBB2/includes/functions_barra.php on line 64"

Me podrías dar alguna indicación? habláis de estos mods o no se lo que son (silverbar mod, barra de mitch) que yo no tengo, imagino que tendrá que ver eso con el hecho de que no me funcione?
Y si es debido a eso, me lo podéis indicar donde conseguirlo? he buscado pero no doy con ello. La verdad que ni se realmente si me es necesario

Gracias de antemano.
Saludos.

[YOLANDA]

me he equivocado, he escrito el post en la zona de PHPBB 3 y yo lo quiero para el PHPBB 2..

sorry

[CRACK_2]

La verdad es que jugando con los codigos hice algo que la verdad hizo que, para mi , quede mejor.