在当前主题function.php中添加
function getHotComments($limit = 10){
$db = Typecho_Db::get();
$result = $db->fetchAll($db->select()->from(‘table.contents’)
->where(‘status = ?’,‘publish’)
->where(‘type = ?’, ‘post’)
->where(‘created limit($limit)
->order(‘commentsNum’, Typecho_Db::SORT_DESC)
);
if($result){
foreach($result as $val){
$val = Typecho_Widget::widget(‘Widget_Abstract_Contents’)->push($val);
$post_title = htmlspecialchars($val[‘title’]);
$permalink = $val[‘permalink’];
echo ‘'.$post_title.'’;
}
}
}
前台调用
“