wordpress添加阅读和评论排行榜功能

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

< ?php
//文章排行
function most_viewed($time,$limit) {
global $wpdb, $post;
$output = "<ul class=\"hot_views\">";
$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.*, (meta_value+0) AS post_views_count FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish' AND meta_key = 'post_views_count' AND post_password = '' ORDER BY post_views_count DESC LIMIT $limit");
if($most_viewed) {
$num=1;
foreach ($most_viewed as $post) {
$output .= "\n<li><a href= \"".get_permalink($post->ID)."\" rel=\"bookmark\" title=\"".$post->post_title." (".$post->post_views_count."+)\" >$num. ". $post->post_title." (".$post->post_views_count."+)</a></li>";
$num++;
}
$output .= "<br />";
echo $output;
}
}
//评论排行
function most_commmented($time,$limit) {
global $wpdb, $post;
$output = "<ul class=\"hot_views\">";
$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.* FROM $wpdb->posts  WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish'  AND post_password = '' ORDER BY comment_count DESC LIMIT $limit");
if($most_viewed) {
$num=1;
foreach ($most_viewed as $post) {
$output .= "\n<li><a href= \"".get_permalink($post->ID)."\" rel=\"bookmark\" title=\"".$post->post_title." (".$post->comment_count."+)\" >$num. ". $post->post_title." (".$post->comment_count."+)</a></li>";
$num++;
}
$output .= "</ul><br />";
echo $output;
}
}
?>

< ?php //文章排行 function most_viewed($time,$limit) { global $wpdb, $post; $output = "<ul class=\"hot_views\">"; $most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.*, (meta_value+0) AS post_views_count FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish' AND meta_key = 'post_views_count' AND post_password = '' ORDER BY post_views_count DESC LIMIT $limit"); if($most_viewed) { $num=1; foreach ($most_viewed as $post) { $output .= "\n<li><a href= \"".get_permalink($post->ID)."\" rel=\"bookmark\" title=\"".$post->post_title." (".$post->post_views_count."+)\" >$num. ". $post->post_title." (".$post->post_views_count."+)</a></li>"; $num++; } $output .= "<br />"; echo $output; } } //评论排行 function most_commmented($time,$limit) { global $wpdb, $post; $output = "<ul class=\"hot_views\">"; $most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.* FROM $wpdb->posts WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish' AND post_password = '' ORDER BY comment_count DESC LIMIT $limit"); if($most_viewed) { $num=1; foreach ($most_viewed as $post) { $output .= "\n<li><a href= \"".get_permalink($post->ID)."\" rel=\"bookmark\" title=\"".$post->post_title." (".$post->comment_count."+)\" >$num. ". $post->post_title." (".$post->comment_count."+)</a></li>"; $num++; } $output .= "</ul><br />"; echo $output; } } ?>

1
2
3
4
5
6
7
8

<h2>本月浏览量排行</h2>
< ?php most_viewed(30,10); ?>
<h2>本月评论量排行</h2>
< ?php most_commmented(30,10); ?>
<h2>年度浏览量排行</h2>
< ?php most_viewed(365,10); ?>
<h2>年度评论量排行</h2>
< ?php most_commmented(365,10); ?>

<h2>本月浏览量排行</h2> < ?php most_viewed(30,10); ?> <h2>本月评论量排行</h2> < ?php most_commmented(30,10); ?> <h2>年度浏览量排行</h2> < ?php most_viewed(365,10); ?> <h2>年度评论量排行</h2> < ?php most_commmented(365,10); ?>

1
2
3

.hot_views li{
border-bottom: 1px dashed #DDD;
}

.hot_views li{ border-bottom: 1px dashed #DDD; }