|
|

楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑 4 W# y6 n- l8 V3 V; v# Q
7 M Y0 S* t1 @5 q1 Y
WordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05
4 [' W1 N* {; ? r0 T
7 `' {7 Z9 T2 ?# h* G; C0 A首先打开function.php,添加一段代码:
, M: B1 S" Z& p! L W" I$ G% K function simple_get_most_viewed($posts_num=10, $days=300){9 u& |, Z$ q& y* c( @
global $wpdb;1 t: j3 D, c4 _2 Z7 L5 p& B% J
$sql = “SELECT ID , post_title , comment_count/ x$ R8 A S% q0 u$ h4 V0 r) F/ [ L
FROM $wpdb->posts& f; E$ s. G, ?/ z4 T1 a
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days$ \" T; V$ }6 `7 A. O
AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)" o$ L9 `# W( g$ ^; ]
ORDER BY comment_count DESC LIMIT 0 , $posts_num “;: W1 ~$ |3 ]/ N
$posts = $wpdb->get_results($sql);
" Q; q9 U9 a& ]: G# D $output = “”;) v0 _5 j% G J
foreach ($posts as $post){
* O; }2 e$ P2 F4 X9 g' j0 f $output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;5 a6 m6 c$ t8 [ I
}# x* J' Q% T; M0 b/ D1 T& L
echo $output;$ Q3 q# z/ t d
}
& W' c# s% B5 ^& i其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。9 E4 w7 }/ [/ a( P7 D
( h& I, e3 ?: P6 d3 B# p+ z然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 2 ^& O% e/ u5 r8 s- }0 ^0 C; h
|
|