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

Timestamp:

Jun 8, 2009, 5:55:59 PM (15 years ago)

Author:

toemon

Message:

#137 WordPressME2.0.11への対応(ブロックの対応）

File:

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

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

@@ -44 +44 @@
                 
         $select = "SELECT $view_tb.post_views, $post_tb.ID, $post_tb.post_title, $post_tb.post_date";                           
-
+        if ($wp_db_version >= 6124){
                 $from  = " FROM (((";
                 $from .= " $post_tb LEFT JOIN $view_tb ON $post_tb.ID = $view_tb.post_id)";
@@ -66 +66 @@
                                 $where .= " AND ($term_taxonomy.term_id IN ($tag_id_list))";
                 }
+        } 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))";
+                }
+        }
                 
 
@@ -106 +118 @@
                         ob_end_clean(); 
                         
-                        ob_start();
-                                the_tags(__('Tags:', 'kubrick') . ' ',' &bull; ','');
-                                $tags = ob_get_contents();
-                        ob_end_clean();
+                        if (function_exists('the_tags')){
+                                ob_start();
+                                        the_tags(__('Tags:', 'xpress') . ' ',' &bull; ','');
+                                        $tags = ob_get_contents();
+                                ob_end_clean(); 
+                        } else {
+                                $tags = '';
+                        }
                         
                         ob_start();
@@ -115 +131 @@
                                 $post_modified_date = ob_get_contents();
                         ob_end_clean();
-                        
+                                
                         ob_start();
                                 the_modified_date($time_format);