如何讓wordpress所有留言都出現在一頁上，且有分頁功能：利用comment status外掛

$tablecomments 與 $tableposts 已經在 WP 3 去掉了
請將程式碼中的 global $wpdb,$tablecomments,$tableposts; 改成 global $wpdb;
並將其餘程式中全部的

$tablecomments 改成 $wpdb->comments
$tableposts 改成 $wpdb->posts

< ?php /* Plugin Name: Comments Status for WP3 Plugin URI: http://www.chweng.idv.tw/blog/wordpress/comments-status/ Description: Counts the total number of comments and layout a comments list in a clean form. Version: 0.2 Author: C.H.Weng Author URI: http://www.chweng.idv.tw/ */ $numsperpage = 40; //設定每頁顯示的數量 if (isset($_GET['page'])) { $curpage=$_GET['page']; } else { $curpage=1; } function comments_count() { global $wpdb; $comnum=$wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->posts,$wpdb->comments WHERE $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status IN ('publish','static') AND $wpdb->comments.comment_approved='1' AND $wpdb->comments.comment_type=''");
return $comnum;
}

function trackbacks_count() {
global $wpdb;
$comnum=$wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->posts,$wpdb->comments WHERE $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status IN ('publish','static') AND $wpdb->comments.comment_approved='1' AND $wpdb->comments.comment_type IN ('trackback','pingback')");
return $comnum;
}

function comments_archives($type = 'comment') {
global $wpdb,$comment;
global $numsperpage,$curpage;
if ($type=='trackback') {
$comnum=trackbacks_count();
} else {
$comnum=comments_count();
}
if (($comnum/$numsperpage)>intval($comnum/$numsperpage)) {
$maxpage=intval($comnum/$numsperpage)+1;
} else {
$maxpage=intval($comnum/$numsperpage);
}
if ($curpage<1 || $curpage!=intval($curpage) || $maxpage< $curpage) { header('Location: '.$_SERVER['PHP_SELF']); } $offset=($curpage-1)*$numsperpage; $query="SELECT ID,comment_ID,comment_author,comment_author_url,comment_date,comment_content,post_title FROM $wpdb->posts,$wpdb->comments WHERE $wpdb->posts.ID=$wpdb->comments.comment_post_ID AND post_status IN ('publish','static') AND $wpdb->comments.comment_approved='1'";
if ($type=='trackback') {
$query.=" AND $wpdb->comments.comment_type IN ('trackback','pingback')";
} else {
$query.=" AND $wpdb->comments.comment_type=''";
}
$query.=" ORDER BY comment_ID DESC LIMIT $offset,$numsperpage";
$comments=$wpdb->get_results($query);
echo '

';
if ($maxpage>1) {
if ($curpage>6) {
echo '[第一頁 First page] …';
}
for ($i=($curpage-5); $i< =($curpage+5); $i++) { if ($i>=1 && $i< =$maxpage) { echo ' '; if ($i==$curpage) { echo $i; } else { echo '[$i]"; } echo ' '; } } if ($maxpage>($curpage+5)) {
echo '… [最末頁 Last page] ";
}
}
echo "
共有 $comnum 筆留言；目前顯示第 $curpage 頁的留言；共 $maxpage 頁。

\r\n";
echo "
You have $comnum comments；Now you are in page $curpage of $maxpage
\r\n";
foreach ($comments as $comment) {
$post_title=htmlspecialchars(stripslashes($comment->post_title));
if($post_title!=$cache_post_title) {
echo '
$post_title

\r\n";
}
echo '
'.get_comment_author_link().' at '.get_comment_date().' '.get_comment_time().'
'.apply_filters('comment_text',apply_filters('get_comment_text',$comment->comment_content)).'

';
$cache_post_title=$post_title;
}
echo '

';
echo "
共有 $comnum 筆留言；目前顯示第 $curpage 頁的留言；共 $maxpage 頁。
\r\n";
echo "
You have $comnum comments；Now you are in page $curpage of $maxpage
\r\n";
if ($maxpage>1) {
if ($curpage>6) {
echo '

[第一頁First page] …';
}
for ($i=($curpage-5); $i< =($curpage+5); $i++) { if ($i>=1 && $i< =$maxpage) { echo ' '; if ($i==$curpage) { echo $i; } else { echo '[$i]"; } echo ' '; } } if ($maxpage>($curpage+5)) {
echo '… [最末頁Last page]

";
}
}
}
?>

< ?php /*Template Name: comment page*/ get_header(); >

<script type="text/javascript">// < ![CDATA[
// < ![CDATA[ var URL = "http:/你的網址/blog/myRcomments.php" var speed = 500 function reload() { location = URL } setTimeout("reload()", speed); // ]]></script>

&lt; ?php require(dirname(__FILE__).'/wp-blog-header.php'); ?&gt;
&lt; ?php get_header(); ?&gt;
本站所有留言All comments
&lt; ?php comments_archives('comment'); ?&gt;
&lt; ?php get_sidebar(); ?&gt;
&lt; ?php get_footer(); ?&gt;