调整WordPress的留言/评论的显示顺序

November 16th, 2007

故障现象: Wordpress的最新评论永远在最最下面一行
期望目标: 将最新评论置于第一行, 最旧的评论置于最后一行

我的环境是wordpress2.3.1, 但其它版本应该也有此类问题. 每次找最新评论都得翻到页面的最下方.

所以将wordpress 的留言排序改成第1条是最最新留言应该是比较好的方法吧!

修改方法并不复杂, 修改../wp-includes/comment-template.php文件, 将其中的

// TODO: Use API instead of SELECTs.
if ( $user_ID) {
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND (comment_approved = ‘1′ OR ( user_id = ‘$user_ID’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date”);
} else if ( empty($comment_author) ) {
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND comment_approved = ‘1′ ORDER BY comment_date”);
} else {
  $author_db = $wpdb->escape($comment_author);
  $email_db = $wpdb->escape($comment_author_email);
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND ( comment_approved = ‘1′ OR ( comment_author = ‘$author_db’ AND comment_author_email = ‘$email_db’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date”);
}

改为

// TODO: Use API instead of SELECTs.
if ( $user_ID) {
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND (comment_approved = ‘1′ OR ( user_id = ‘$user_ID’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date DESC”);
} else if ( empty($comment_author) ) {
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND comment_approved = ‘1′ ORDER BY comment_date DESC”);
} else {
  $author_db = $wpdb->escape($comment_author);
  $email_db = $wpdb->escape($comment_author_email);
  $comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND ( comment_approved = ‘1′ OR ( comment_author = ‘$author_db’ AND comment_author_email = ‘$email_db’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date DESC”);

最后再打开试试,成功了,呵呵!

Last modified at: Friday, November 16th, 2007 04:01:13 pm
Trackback URL: http://blog.zhangjianfeng.com/article/686/trackback

给本文打分: 1 Star