Forum » » Questions » » Les dix derniers posts affichés en accueil.
Posté : 25 oct. 2012 à 17:40
function MM_dernierCommentaires($nbCommentaire = 10, $maLimite = 80) {
global $NPDS_Prefix;
$nbCommentaire = arg_filter($nbCommentaire);
$maLimite = arg_filter($maLimite);
$sqlSelect = 'SELECT '.$NPDS_Prefix.'posts.topic_id, '.$NPDS_Prefix.'posts.poster_id, '.$NPDS_Prefix.'posts.post_text, '.$NPDS_Prefix.'users.name, '.$NPDS_Prefix.'stories.title
FROM '.$NPDS_Prefix.'posts
INNER JOIN '.$NPDS_Prefix.'users ON '.$NPDS_Prefix.'posts.poster_id = '.$NPDS_Prefix.'users.uid
INNER JOIN '.$NPDS_Prefix.'stories ON '.$NPDS_Prefix.'posts.topic_id = '.$NPDS_Prefix.'stories.sid
WHERE forum_id = -1
ORDER BY post_id DESC
LIMIT '.$nbCommentaire;
$execSqlSelect = sql_query($sqlSelect);
$content .= '<ul id="dernierCommentaire">';
while($dernierCommentaires = sql_fetch_row($execSqlSelect)) {
$dernierComment = strip_tags($dernierCommentaires[2]);
if(strlen($dernierComment) >= $maLimite) {
while($dernierComment[$maLimite - 1] != " ") {
$maLimite++;
}
$dernierComment = substr($dernierComment, 0, $maLimite);
$dernierComment .= ' ...';
}
$remplaceNPDS = str_replace('NPDS', 'npds', $dernierCommentaires[4]);
$content .= $dernierCommentaires[1] == 1 ? '<li>Anonyme : <a title="'.stripslashes($remplaceNPDS).'" href="article.php?sid='.$dernierCommentaires[0].'">'.stripslashes($dernierComment).'</a></li>' : '<li><a href="user.php?op=userinfo&uname='.$dernierCommentaires[3].'">'.stripslashes($dernierCommentaires[3]).'</a> : <a title="'.stripslashes($remplaceNPDS).'" href="article.php?sid='.$dernierCommentaires[0].'">'.stripslashes($dernierComment).'</a></li>';
}
$content .= '</ul>';
return($content);
}
Cet article provient de NPDS
https://www.npds.org/viewtopic.php?topic=21018&forum=9