Changeset 158 for trunk/wp-content/themes/xpress_default/blocks/popular_posts_block_theme.php

Timestamp:

Apr 6, 2009, 6:29:42 PM (16 years ago)

Author:

toemon

Message:

#91 マルチユーザモードでユーザ指定時人気記事リストブロックが表示されないバグ修正

File:

• trunk/wp-content/themes/xpress_default/blocks/popular_posts_block_theme.php (modified) (4 diffs)

trunk/wp-content/themes/xpress_default/blocks/popular_posts_block_theme.php

@@ -26 +26 @@
         $selected_author_id = xpress_selected_author_id(false); 
 
-        global $wpdb,$wp_query;
+        global $wpdb,$wp_query,$xoops_db;
         
         $db_prefix = get_wp_prefix();
@@ -43 +43 @@
         include ($mydirpath . '/wp-includes/version.php');
                 
-        $select = "SELECT $view_tb.post_views, $post_tb.ID, $post_tb.post_title, $post_tb.post_date, $user_tb.display_name";                            
-        if ($wp_db_version >= 6124){
-                $from  = " FROM ((((";
+        $select = "SELECT $view_tb.post_views, $post_tb.ID, $post_tb.post_title, $post_tb.post_date";                           
+
+                $from  = " FROM (((";
                 $from .= " $post_tb LEFT JOIN $view_tb ON $post_tb.ID = $view_tb.post_id)";
                 $from .= " INNER JOIN $term_relationships_tb ON $post_tb.ID = $term_relationships_tb.object_id)";
                 $from .= " INNER JOIN $term_taxonomy ON $term_relationships_tb.term_taxonomy_id = $term_taxonomy.term_taxonomy_id)";
-                $from .= " INNER JOIN $terms_tb ON $term_taxonomy.term_id = $terms_tb.term_id)";
-                $from .= " INNER JOIN $user_tb ON $post_tb.post_author = $user_tb.ID";
+                $from .= " INNER JOIN $terms_tb ON $term_taxonomy.term_id = $terms_tb.term_id ";
                 
-                $where = " WHERE ($post_tb.post_type = 'post') AND ($post_tb.post_status = 'publish')";
-                if (!empty($selected_author_id)){
-                        $where  .= " AND $post_tb.post_author = $selected_author_id ";
-                }
+                $where = " WHERE $post_tb.post_type = 'post' AND $post_tb.post_status = 'publish'";
+//              if (!empty($selected_author_id)){
+//                      $where  .= " AND ($post_tb.post_author = $selected_author_id) ";
+//                      $where  .= " AND ($post_tb.post_author = 2) ";
+//              }
 
                 if ($cat_select) {
@@ -67 +67 @@
                 }
                 
-        } else {
-                $from  = " FROM ((";
-                $from .= " $post_tb LEFT JOIN $view_tb ON $post_tb.ID = $view_tb.post_id)";
-                $from .= " LEFT JOIN $post2cat_tb ON $post_tb.ID = $post2cat_tb.post_id)";
-                $from .= " INNER JOIN $user_tb ON $post_tb.post_author = $user_tb.ID";
-                
-                $where = " WHERE ($post_tb.post_status = 'publish') AND  (UNIX_TIMESTAMP($post_tb.post_date) <= UNIX_TIMESTAMP())" ;
-                
-                if ($cat_select) {
-                        $where .= " AND ($post2cat_tb.category_id IN ($cat_id))";
-                }
-                if (!empty($selected_author_id)){
-                        $where  .= " AND $post_tb.post_author = $selected_author_id ";
-                }
-
-        }
+
         if ($show_month_range > 0) {
                         $where .= " AND (UNIX_TIMESTAMP($post_tb.post_date) >= UNIX_TIMESTAMP(DATE_ADD(CURRENT_DATE, INTERVAL -$show_month_range month)))";
         }
         $order_limmit = " GROUP BY $post_tb.ID ORDER BY $view_tb.post_views DESC LIMIT 0, $disp_count";
-        
-        $populars = $wpdb->get_results($select . $from . $where . $order_limmit);
+        $sql = $select . $from . $where . $order_limmit;
+
+        $populars = $wpdb->get_results($sql);
         
         foreach ($populars as $popular){
@@ -156 +142 @@
                         $post_modified_date_time = $post_modified_date . ' ' . $post_modified_time ;
                         $trackback_url = trackback_url(false);
-                        $post_viwes = xpress_post_views_count($post_id,'views: %d' ,false);
+                        $post_viwes = xpress_post_views_count($post_id,__('views: %d','xpress') ,false);
 //                      if (empty($tags)) $tags = __('Not Tag');