之前寫過(guò)《替換HotNews Pro主題熱門文章調(diào)用函數(shù)》配合wp-postviews插件，通過(guò)添加：
- ###Get TimeSpan Most Viewed
- 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 $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_viewedas$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>".__('', 'wp-postviews')."</li>";
- }
- } else {
- $temp = '<li>'.__('N/A', 'wp-postviews').'</li>'."\n";
- }
- if($display) {
- echo$temp;
- } else {
- return$temp;
- }
- }
調(diào)用顯示某時(shí)間段內(nèi)瀏覽最多日志的功能。
近日，有童鞋問這些瀏覽最多的文章可不可以加上縮略圖，簡(jiǎn)單修改了一下上述代碼：
- //按時(shí)間獲得最受歡迎文章（帶縮略圖）
- 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 $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_viewedas$post) {
- $post_title = get_the_title();
- $post_views = intval($post->views);
- $post_views = number_format($post_views);
- $thumb = "<img src=\"".get_post_meta(get_the_id(), 'thumbnail', true)."\">";
- $temp .= "<li><a href=\"".get_permalink()."\">$post_title,$thumb</a>".__('', 'wp-postviews')."</li>";
- }
- } else {
- $temp = '<li>'.__('N/A', 'wp-postviews').'</li>'."\n";
- }
- if($display) {
- echo$temp;
- } else {
- return$temp;
- }
- }
其中：
- get_post_meta(get_the_id(), 'thumbnail', true)
顯示添加自定義欄目：thumbnail 文章的縮略圖，也可以修改為調(diào)用特色圖像：
- the_post_thumbnail('post_thumbnail');
調(diào)用方法，在主題模板適當(dāng)位置添加：
- <ul>
- <?php if (function_exists('get_most_viewed')): ?>
- <?php get_timespan_most_viewed('post',8,60, true, true); ?>
- <?php endif; ?>
- </ul>
以上方法僅供參考。
評(píng)論