0 AND n.nid=nc.nid INNER JOIN (SELECT max(c.cid) as cid ,c.nid,count(c.cid) as cnt FROM {comments} c GROUP by c.nid ) cm ON cm.nid=n.nid INNER JOIN {comments} cc ON cc.cid=cm.cid INNER JOIN {users} u ON u.uid=cc.uid ORDER BY nc.last_comment_timestamp DESC"),0,$number); $items=array(); while($comment=db_fetch_object($result)){ $tte=''; if(strlen(strip_tags($comment->comment))>$commentlenght) { $tte=$endcomment; }; $items[] = ''. l($comment->title, 'node/'. $comment->nid, array('fragment' => 'comment-'. $comment->cid)).' ('.$comment->cnt.')' .'
'.strip_tags(drupal_substr($comment->comment, 0, $commentlenght)).$tte.'
'.format_date($comment->timestamp, 'small').'
от: '.theme('username',user_load($comment->uid)). ''; } if(count($items)){ print theme('item_list',$items); } ?>