phpBB España Oficial, Soporte Internacional Oficial del sistema de foros phpBB en Español, extensiones, estilos, traducciones, guías, tutoriales, videos, redes sociales, webmaster.
https://www.phpbb-es.com/foro/
Si men si, en los comentarios, estoy buscando una solución. Si quieres pide soporte y te paso el code con el que obtengo los comentarios.Damage, INc escribió:Gracias de nuevo.
Donde se siguen incluyendo los nuevos temas? en los comentarios?
Código: Seleccionar todo
//Start Last Posts by Rainwod
$sql = 'SELECT p.post_id, p.forum_id, p.post_time, p.post_subject, u.username, u.user_id, u.user_colour
FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
WHERE u.user_id = p.poster_id
AND p.post_reported = 0
AND p.post_approved = 1' ."
ORDER BY p.post_time DESC";
$result = $db->sql_query_limit($sql, 10);
while( ($row = $db->sql_fetchrow($result)) && ($row['post_subject']) )
{
$is_guest = $row['user_id'] != ANONYMOUS ? false : true;
$template->assign_block_vars('posts', array(
'TITLE' => censor_text($row['post_subject']),
'AUTHOR' => $is_guest ? $user->lang['BY'] . ' ' . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']) : $user->lang['BY'] . ' ' . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] .'&p=' . $row['post_id'].'#p'.$row['post_id']),
'ICON' => $user->img('icon_post_target', $user->lang['VIEW_TOPIC']),
));
}
$db->sql_freeresult($result);
//END Last Posts by RainwodCódigo: Seleccionar todo
'TOPIC_TITLE' => $user->lang['IN'] . ' ' . $topic_title));
}
$db->sql_freeresult($result);Código: Seleccionar todo
<div class="forabg">
<div class="inner"><span class="corners-top"><span></span></span>
<table class="table1" cellspacing="1" id="top_five">
<thead>
<tr>
<th style="width: 50%;">{L_NEWEST_TOPICS}</th>
<th style="width: 20%;">{L_TOP_FIVE_ACTIVE}</th>
<th style="width: 30%;">{L_TOP_FIVE_NEWEST}</th>
</tr>
</thead>
<tbody>
<tr class="bg2">
<td valign="top"><!-- BEGIN top_five_topic --><!-- IF top_five_topic.NO_TOPIC_TITLE-->{top_five_topic.NO_TOPIC_TITLE}<!-- ELSE --><a href="{top_five_topic.U_TOPIC}">{top_five_topic.TOPIC_TITLE}</a><br /> {top_five_topic.USERNAME_FULL} {top_five_topic.LAST_TOPIC_TIME}<br /><!-- ENDIF --><!-- END top_five_topic --></td>
<td valign="top"><!-- BEGIN posts -->{posts.ICON} <a href="{posts.U_VIEW_TOPIC}">{posts.TITLE}</a><br /> {posts.AUTHOR}<br /><!-- END posts --></td>
<td valign="top"><!-- BEGIN top_five_newest -->{top_five_newest.USERNAME_FULL}<br /> {L_JOINED}: {top_five_newest.REG_DATE}<br /><!-- END top_five_newest --></td>
</tr>
</tbody>
</table>
<span class="corners-bottom"><span></span></span></div>
</div>
Código: Seleccionar todo
<th style="width: 50%;">{L_NEWEST_TOPICS}</th>
<th style="width: 20%;">{L_TOP_FIVE_ACTIVE}</th>
<th style="width: 30%;">{L_TOP_FIVE_NEWEST}</th>Código: Seleccionar todo
<th style="width: 40%;">{L_NEWEST_TOPICS}</th>
<th style="width: 10%;">{L_TOP_FIVE_ACTIVE}</th>
<th style="width: 25%;">{L_TOP_FIVE_NEWEST}</th>
<th style="width: 25%;">{L_POINTS_MOST_RICH_CASH_USERS}</th>Código: Seleccionar todo
<td valign="top"><!-- BEGIN top_five_newest -->{top_five_newest.USERNAME_FULL}<br /> {L_JOINED}: {top_five_newest.REG_DATE}<br /><!-- END top_five_newest --></td>Código: Seleccionar todo
<td valign="top"><p><!-- BEGIN rich_user --><!-- IF not rich_user.S_FIRST_ROW --> • <!-- ENDIF -->{rich_user.USERNAME} ({rich_user.SUM_POINTS} {rich_user.SUM_POINTS_NAME})<!-- END rich_user --></td>