Esta es la consulta a la BD:
Código PHP:
//Consulta Posts Recientes
if (($data=$cache->get('posts_recent',6)) === FALSE || !empty($id))
{
//Consulta de posts normales
$request=db_query("
SELECT m.ID_MEMBER, m.ID_TOPIC, m.body, m.imgport, c.ID_CAT, subject, c.name, t.ID_BOARD, posterName, puntos, m.hiddenOption, posterTime, denuncias
FROM {$db_prefix}messages as m, {$db_prefix}boards as c, {$db_prefix}topics as t
WHERE c.ID_BOARD=m.ID_BOARD AND t.ID_TOPIC=m.ID_TOPIC AND t.isSticky = 0 {$cat_condition}
AND c.ID_CAT != 12 " . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND c.ID_BOARD != $modSettings[recycle_board]" : '') . "
ORDER BY m.ID_TOPIC DESC
LIMIT $limit_posts", __FILE__, __LINE__);
while($posts = mysql_fetch_array($request))
{
$context['normal_posts'][] = array(
'ID_MEMBER' => $posts['ID_MEMBER'],
'id' => $posts['ID_TOPIC'],
'body' => $posts['body'],
'imgport' => $posts['imgport'],
'title' => $posts['subject'],
'category' => $posts['name'],
'id_category' => $posts['ID_BOARD'],
'user' => $posts['posterName'],
'date' => $posts['posterTime'],
'puntos' => $posts['puntos'],
'denuncias' => $posts['denuncias'],
);
}
mysql_free_result($request);
if (empty($id))
$cache->set('posts_recent', $context['normal_posts']);
}else{
$context['normal_posts'] = $data;
}
y con un foreach obtengo el listado de los post
Código PHP:
foreach ($context['normal_posts'] as $np)
{
$hcode = array(' ',',');
$bcode = array('-','-');
$titleurl = str_replace($hcode, $bcode, $np['title']);
if($i==0){
//primer post
echo'<div id="content-r2">';
} else if($i == $len - 1){
//último post
echo'<div id="content-re">';
} else{
//Cualquier otro post
echo'<div id="content-re'; if($cont <= 3) { echo $cont; ++$cont; } echo'">';
}
echo '<div class="title-r"><a href="/posts/', $np['id'],'/'; echo $titleurl; echo'.html" title="',$np['title'],'">'; echo $np['title']; echo'</a></div>
<div class="img-recent">
<a href="/posts/', $np['id'],'/'; echo $titleurl; echo'.html"><img class="img-r" src="',$np['imgport'],'" title="',$np['title'],'" /></a>
</div>';
echo'<div class="content-recent">';
echo
substr($np['body'], 0, 200); //Recorto titulo a 30 caracteres
echo'... <span class="s-leye"><a href="/posts/', $np['id'],'/'; echo $titleurl; echo'.html">Seguir leyendo</a></span></div>
</div>';
//Incrementar contador:
$i++;
}
Muchas Gracias!