巧克力工厂

20 Comment(s)

1. fvcity
   July 2nd, 2007 at 3:15 pm

   谢谢Michael,真的是太谢谢了,嘻嘻

2. fvcity
   July 2nd, 2007 at 3:58 pm

   我在最新的2.3测试版本使用出现这样的提示:
   WordPress database error: [Table 'dao.wp_post2cat' doesn't exist]
   SELECT ID, post_title, post_date, post_content, post_id, category_id FROM wp_posts, wp_post2cat WHERE wp_posts.post_status = ‘publish’ AND wp_posts.post_type=’post’ AND wp_post2cat.category_id = 1 AND wp_posts.ID = wp_post2cat.post_id AND post_password =” ORDER BY post_date DESC LIMIT 0, 5

3. Michael  (Blog Owner)
   July 2nd, 2007 at 4:11 pm

   我没有 2.3 不好说，不过看起来 2.3 在数据库结构上又作了调整。

4. Michael  (Blog Owner)
   July 2nd, 2007 at 4:27 pm

   @fvcity: 我在 2.3 上测试了一下，没有发现你说的问题。我觉得你可以

   1. 登入到后台，wordpress 会自动帮你转换数据库。
   2. 如果不行，升级到最新的 version 再试试。

5. fvcity
   July 2nd, 2007 at 4:37 pm

   我是全新安装的,因为数据结构变化了
   我加你QQ好不好?

6. fvcity
   July 2nd, 2007 at 4:37 pm

   我的QQ是79894390,谢谢我很急,急用,谢谢

7. fvcity
   July 3rd, 2007 at 2:19 am

   Michael,麻烦人再改我一下,可能是表改变了的原因!

8. fvcity
   July 3rd, 2007 at 8:18 am

   改成了这样还是不行

   function get_recent_catposts($no_posts = 5, $catid = 1, $before = ”, $after = ”, $show_pass_post = false, $skip_posts = 0) {
   global $wpdb;
   $request = “SELECT ID, post_title, post_date, post_content, $wpdb->terms.term_id FROM $wpdb->term_taxonomy, $wpdb->posts, $wpdb->terms WHERE $wpdb->posts.post_status = ‘publish’ AND $wpdb->posts.post_type=’post’ AND $wpdb->terms.term_id = $catid AND $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id “;
   if(!$show_pass_post) { $request .= “AND post_password =” “; }
   $request .= “ORDER BY post_date DESC LIMIT $skip_posts, $no_posts”;
   $posts = $wpdb->get_results($request);
   $output = ”;
   foreach ($posts as $post) {
   $post_title = stripslashes($post->post_title);
   // $post_date = mysql2date(’j.m.Y’, $post->post_date);
   $permalink = get_permalink($post->ID);
   $output .= $before . ‘‘ . $post_title . ‘‘. $after;
   }
   echo $output;
   }

9. Michael  (Blog Owner)
   July 3rd, 2007 at 9:51 am

   先别做小白鼠了，等 2.3 beta 出来再看看吧。

10. 偶爱偶妻
    July 4th, 2007 at 4:32 am

    谢谢，等2.3.呵呵！不麻烦您了！

11. ryana
    September 16th, 2007 at 4:14 pm

    完全不显示。。我放到sidebar以后，不知道为什么，我的是wp2.2.2，另外，$no_posts = 5, ＄catid = 1这段话的后面的$用成了全角。。

12. Michael  (Blog Owner)
    September 17th, 2007 at 12:18 am

    @ryana, 全角半角的问题要注意一下，例子里的单引号也是全角的。

13. 酷辣客
    October 11th, 2007 at 2:42 am

    如果博主把这个函数和前面那个修改的最新留言函数一起集成到中文工具箱就好了，呵呵，我是个代码盲。

14. Michael  (Blog Owner)
    October 11th, 2007 at 11:02 am

    @酷辣客，这个版本已经集成了所有的修改，下载完就可以直接用了。

15. 酷辣客
    October 11th, 2007 at 11:44 am

    谢谢，得确很好用，我的另一个站用他。

16. mo
    October 21st, 2007 at 12:34 pm

    这个功能可以用在2.3里面吗?

17. Michael  (Blog Owner)
    October 21st, 2007 at 12:37 pm

    @mo, 可以。

18. Ryana
    October 24th, 2007 at 11:15 am

    这个我已经用上了，很棒~
    不知道里面有没有什么调用函数，可以取出post的time,author,catogory的信息呢?
    http://www.psytopic.com/mag/中间的列表后面跟随了时间，不是全部link的大list，感觉好很多~

    先说声谢谢~

19. DamionKutaeff
    March 23rd, 2008 at 4:42 pm

    Hello everybody, my name is Damion, and I’m glad to join your conmunity,
    and wish to assit as far as possible.

20. Tiferneenanda
    April 14th, 2008 at 5:17 pm

    I’d prefer reading in my native language, because my knowledge of your languange is no so well. But it was interesting! Look for some my links: