Changeset 36 for trunk/blocks

Timestamp:

Dec 21, 2008, 3:01:51 AM (16 years ago)

Author:

toemon

Message:

ブロックのXMLキャッシュ化　#43

File:

• trunk/blocks/xpress_block_recent_comments.php (modified) (5 diffs)

trunk/blocks/xpress_block_recent_comments.php

@@ -66 +66 @@
                 $mydirpath = XOOPS_ROOT_PATH . '/modules/' . $mydirname;
                 
-
                 $myts =& MyTextSanitizer::getInstance();
 
@@ -96 +95 @@
                 
                 global $wpdb;
-                $block = array( 
-                'mydirname' => $mydirname ,
-                'mod_url' => XOOPS_URL.'/modules/'.$mydirname ,
-                ) ;
                         
                 if (!is_null($wpdb)){
+                        $comment_sql  = "SELECT comment_ID,comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_content, comment_type,UNIX_TIMESTAMP(comment_date) as comment_unix_time ";
+                        $comment_sql .= "FROM $wpdb->comments LEFT JOIN $wpdb->posts ON  $wpdb->posts.ID = $wpdb->comments.comment_post_ID ";
+                        $comment_sql .= "WHERE comment_approved = '1' AND post_type = 'post'  AND post_status = 'publish' $type_select ";
+                        $comment_sql .= "ORDER BY comment_date_gmt DESC LIMIT $disp_count";
 
-                        $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments LEFT JOIN $wpdb->posts ON  $wpdb->posts.ID = $wpdb->comments.comment_post_ID WHERE comment_approved = '1' AND post_type = 'post'  AND post_status = 'publish' $type_select ORDER BY comment_date_gmt DESC LIMIT $disp_count");
+                        $comments = $wpdb->get_results($comment_sql);
                         $format = get_settings('date_format') . ' ' . get_settings('time_format');                              
 
                         if ( $comments ) {
                                 $output .= '<ul>';
+                                $item_no = 0;
                                 foreach ($comments as $comment){
                                         $comment_content = $comment->comment_content;
@@ -114 +114 @@
                                         $comment_link = get_permalink($comment->comment_post_ID) . '#comment-' . $comment->comment_ID ;
                                         $comment_title = $comment_excerpt;
-                                        $comment_title_link = "<a href='$comment_link' rel='external nofollow' class='url'>$comment_tytle</a>";
+                                        $comment_title_link = "<a href='$comment_link' rel='external nofollow' class='url'>$comment_title</a>";
 
                                         $post_link = get_comment_link($comment->comment_ID);
@@ -130 +130 @@
                                                 'comment_ID'            => $comment->comment_ID ,
                                                 'comment_post_ID'       => $comment->comment_post_ID ,
-                                                'comment_date'          => $comment->comment_date ,
+                                                'comment_date'          => date(get_settings('date_format'),$comment->comment_unix_time) ,
+                                                'comment_date_time' => date(get_settings('date_format') . ' ' . get_settings('time_format'),$comment->comment_unix_time) ,
                                                 'comment_content'       => $comment_content ,
                                                 'comment_excerpt'       => $comment_excerpt ,   
                                                 'comment_link'          => $comment_link,
-                                                'comment_title'         => $ccomment_title ,
+                                                'comment_title'         => $comment_title ,
                                                 'comment_title_link' => $comment_title_link ,
                                                 'post_link'             => $post_link,
@@ -146 +147 @@
                                         );
                                         
-                                        $block['contents'][] = $row_data;
+                                        $block['contents']['item'.$item_no] = $row_data;
+                                        $item_no++;
                                 }
                         }
+                        require_once dirname(dirname( __FILE__ )).'/include/xoops_block_cache.php';
+                        xpress_block_cache_write($mydirname,'recent_comment_block',$block);
                 } else {
-//                      $block['contents'] = "out of  module";
+                        require_once dirname(dirname( __FILE__ )).'/include/xoops_block_cache.php';
+                        $block = xpress_block_cache_read($mydirname,'recent_comment_block');
                 }
-                        return $block ;
-
+                return $block ;
         }
 }