
Forum » » Questions » » Les dix derniers posts affichés en accueil.
Posté : 25-10-2012 17:40 
function MM_dernierCommentaires($nbCommentaire = 10, $maL imite = 80) {
global $NPDS_Prefix;
$nbCommentaire = arg_filter($nbCommentaire) ;
$maLimite = arg_filter($maLimite);
$sqlSelect = 'SELECT '.$NPDS_Prefix.'p osts.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 J OIN '.$NPDS_Prefix.'users ON '.$NPDS_Prefix.'posts.poster_id&nbs p;= '.$NPDS_Prefix.'users.uid
  ; INNER J OIN '.$NPDS_Prefix.'stories ON '.$NPDS_Prefix.'posts.topic_id&nb sp;= '.$NPDS_Prefix.'stories.sid
  ; WHERE f orum_id = -1
  ; ORDER BY post_id DESC
  ; LIMIT '.$nbCommentaire;
$execSqlSelect = sql_query($sqlSelect);
$content .= '<ul id="dernierComment aire">';
while($dernierCommentaires = sql_fetch_row( $execSqlSelect)) {
$dernierComment = s trip_tags($dernierCommentaires[2]);
if(strlen($dernierComment)&nb sp;>= $maLimite) {
while ($dernierComment[$maLimite - 1] != " ") {
  ; $maLimite++;
}
$dern ierComment = substr($dernierComment, 0, $maLimite);
$dern ierComment .= ' ...';
}
$remplaceNPDS = str _replace('NPDS', 'npds', $dernierCommentaires[4]);
$content .= $dernie rCommentaires[1] == 1 ? '<li>Anonyme : < a title="'.stripslashes($remplaceNPDS).'" href="article.php?sid='.$de rnierCommentaires[0].'">'.stripslashes($dernierComment).'</a></li&g t;' : '<li><a href="user.php?op=userinfo&uname='.$d ernierCommentaires[3].'">'.stripslashes($dernierCommentaires[3]).'</a> : <a title="'.stripslashes($remplaceNPDS).'" href="arti cle.php?sid='.$dernierCommentaires[0].'">'.stripslashes($dernierComment).'&l t;/a></li>';
}
$content .= '</ul>';
return($content);
}
Cet article provient de NPDS REvolution 16
https://lab.grottes-et-karsts-de-chine.org/viewtopic.php?topic=21018&forum=9