15/07/2011, 18:33:48
J'ai trouvé, il fallait en plus supprimer la ligne du dessous et forcer le classement DESC.
Remplacer :
par :
Remplacer :
Code :
$query="SELECT DISTINCT entry.* FROM ".cms_db_prefix()."module_blogs_entries AS entry LEFT JOIN ".cms_db_prefix()."module_blogs_comments AS comment ON entry.id=comment.entry WHERE entry.category=? $active ORDER BY comment.createtime";
if ($oldestfirst) $query.=" DESC"; else $query.=" ASC";
par :
Code :
$query="SELECT DISTINCT entry.* FROM ".cms_db_prefix()."module_blogs_entries AS entry LEFT JOIN ".cms_db_prefix()."module_blogs_comments AS comment ON entry.id=comment.entry WHERE entry.category=? $active ORDER BY entry.createtime DESC";
CMSMS 1.6
90plan OVH