Just A Blog

在我的博客里一直都是使用WP-Postviews插件来统计文章点击数，以及用来显示热门文章。WP-Postviews显示热门文章的函数是get_most_viewed，也可以通过调用get_least_viewed函数来显示最新被浏览的文章。

get_most_viewed显示所有点击最高的文章，并无时间上的限制，而get_least_viewed虽然可以显示近期的点击文章，但不可以设置相应的统计时间，只能是按照插件的默认时间算法来显示，所以如果要显示近一年或半年内的热门文章这两个函数是无法满足的。从WP-Postviews 1.30版本后就取消了一个补充函数get_timespan_most_viewed，这个函数可以显示特定时间内的热门文章，刚好是我想要的。只要把这个函数重新拷贝到WP-Postviews插件的wp-postviews.php文件内就可以使用了。

### Function: Get TimeSpan Most Viewed - Added by Paolo Tagliaferri (http://www.vortexmind.net - webmaster@vortexmind.net)
function get_timespan_most_viewed($mode = '', $limit = 10, $days = 7, $display = true) {
global $wpdb, $post;
$limit_date = current_time('timestamp') - ($days*86400);
$limit_date = date("Y-m-d H:i:s",$limit_date);
$where = '';
$temp = '';
if(!empty($mode) && $mode != 'both') {
$where = "post_type = '$mode'";
} else {
$where = '1=1';
}
$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.*, (meta_value+0) AS views FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date < '".current_time('mysql')."' AND post_date > '".$limit_date."' AND $where AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER  BY views DESC LIMIT $limit");
if($most_viewed) {
foreach ($most_viewed as $post) {
$post_title = get_the_title();
$post_views = intval($post->views);
$post_views = number_format($post_views);
$temp .= "<li><a href=\"".get_permalink()."\">$post_title</a> - $post_views ".__('views', 'wp-postviews')."</li>";
}
} else {
$temp = '<li>'.__('N/A', 'wp-postviews').'</li>'."\n";
}
if($display) {
echo $temp;
} else {
return $temp;
}
}

$days这个参数是多长时间内发表的文章，我在Single页面设置为180天，就是半年内的热门文章，而在首页则输出全部时间的热门文章。如果想在博客后台看到文章的点击数可以把以下代码（via 水煮鱼）放到WP-Postviews插件目录的wp-postviews.php文件或者你主题的function.php文件中。

add_filter('manage_posts_columns', 'postviews_admin_add_column');
function postviews_admin_add_column($columns){
 $columns['views'] = __('Views');
 return $columns;
}
add_action('manage_posts_custom_column','postviews_admin_show',10,2);
function postviews_admin_show($column_name,$id){
 if ($column_name != 'views')
 return;
 $post_views = get_post_meta($id, "views",true);
 echo $post_views;
}