Aqui la funcion para obtener los ultimos comentarios
Código PHP:
function getComentarios($newsId = '', $template = 'comentarios') {
$sql = "SELECT
commentId,
gamecms_comment.userId,
comment,
gamecms_comment.timestamp,
username,
user_rank,
user_posts,
user_avatar,
gamecms_nowPlaying.gameId,
systemAbbrev
FROM
gamecms_comment
LEFT JOIN
phpbb_users
ON
gamecms_comment.userId = phpbb_users.user_id
LEFT JOIN
gamecms_nowPlaying
ON
gamecms_comment.userId = gamecms_nowPlaying.userId
LEFT JOIN
gamecms_game
ON
gamecms_nowPlaying.gameId = gamecms_game.gameId
LEFT JOIN
gamecms_system
ON
gamecms_game.systemId = gamecms_system.systemId
WHERE
gamecms_comment.newsId= '$newsId'
AND
gamecms_comment.seccion='news'
AND
gamecms_comment.auth='1'
AND
gamecms_comment.deleted='0'
ORDER BY
gamecms_comment.timestamp";
$this->db->query($sql);
while($this->db->next_record()) {
$id = $this->db->f("userId");
$comentario = $this->db->f("comment");
$timestamp = $this->db->f("timestamp");
$usuario = $this->db->f("username");
$avatar = $this->db->f("user_avatar");
$rank = $this->db->f("user_rank");
$posts = $this->db->f("user_posts");
$gameId = $this->db->f("gameId");
$consola = $this->db->f("systemAbbrev");
include "./templates/".$template.".tpl.php";
}
}
Código PHP:
<tr bgcolor="#CCCCCC">
<td width="103px"><div align="center"><strong><a href="http://foros.gamerzone.com.mx/memberlist.php?mode=viewprofile&u=<?php echo $id ?>"><?php echo $usuario ?></a></strong><br />
<img src="http://foros.gamerzone.com.mx/download/file.php?avatar=<?php echo $avatar ?>" /><br />
<?php if ($rank ==0) {
$sql = mysql_query("SELECT rank_image FROM phpbb_ranks WHERE rank_min > '$posts' AND rank_special = '0'") or die (mysql_error());
while ($row = mysql_fetch_array($sql)) {
$imagen = "$row[rank_image]";
echo"<img src='http://foros.gamerzone.com.mx/images/ranks/$imagen' alt='Rango'>";
} }
else {
$sql = mysql_query("SELECT rank_image FROM phpbb_ranks WHERE rank_id ='$rank'") or die (mysql_error());
while ($row = mysql_fetch_array($sql)) {
$imagen = "$row[rank_image]";
echo"<img src='http://foros.gamerzone.com.mx/images/ranks/$imagen' alt='Rango'>";
} }
?>
</div></td>
<td><?php echo $comentario ?>
<?php if($gameId > 0) { ?>
<div align="right"><b>Ahora Juego</b>
<?php global $media;
$media->getBoxArt($gameId, $consola."_BoxArt", 'boxart'); ?>
<?php } else { }?></div></td>
</tr> 
