//start page comments
$slug = "message"; //页面缩略名
$limit = 10; //调用数量
$length = 30; //截取长度
$ispage = true; //true 输出slug页面评论,false输出其它所有评论
$isGuestbook = $ispage ? " = " : " <> ";
$db = $this->db;//Typecho_Db::get();
$optiOns= $this->options;//Typecho_Widget::widget('Widget_Options');
$page = $db->fetchRow($db->select()->from('table.contents')
->where('table.contents.status = ?', 'publish')
->where('table.contents.created ', $options->gmtTime)
->where('table.contents.slug = ?', $slug));
if( $page ){
$type = $page['type'];
$routeExists = (NULL != Typecho_Router::get($type));
$page['pathinfo'] = $routeExists ? Typecho_Router::url($type, $page) : '#';
$page['permalink'] = Typecho_Common::url($page['pathinfo'], $options->index);
$comments = $db->fetchAll($db->select()->from('table.comments')
->where('table.comments.status = ?', 'approved')
->where('table.comments.created ', $options->gmtTime)
->where('table.comments.type = ?', 'comment')
->where('table.comments.cid '.$isGuestbook.' ?', $page['cid'])
->order('table.comments.created', Typecho_Db::SORT_DESC)
->limit($limit) );
foreach($comments AS $comment) {
echo '
';
echo '';
echo Typecho_Common::subStr(strip_tags($comment['text']), 0, $length, '...').'';
echo '';
}
}else{
echo "
No Comments";
}
//end page comments
?>