A Bit? No!!!

我感觉自己似乎一直在浪费时间，一直都是在给别人做WP主题，当然也是为了赚点钱。每次一开电脑就要打开Netbeans，还有一个为了测试主题而安装的Windows虚拟机。。。

自己想学的都还没有学到，很多的事情都荒废了。不过也学到了点东西，至少更会做网页了，还会了点PHP，算是意外的收获。为了更好的写代码，还学习了一下使用Mercurial，之前我是从来没用过版本控制软件的，因为之前就没写过太多代码。

没有什么说的了，贴一点做主题时用到的简单的代码，说不定哪天有哪位与ABitNo一样菜的朋友会用到。不过想想也不知道哪些代码比较有用，就把我在sidebar里用的几个方法帖一下。

获取WordPress中评论最多的文章

function wp_get_most_commented_posts($limitclause="") {
    global $wpdb;
    $q = "SELECT ID, post_title, post_date,
COUNT($wpdb->comments.comment_post_ID) AS 'comment_count'
FROM $wpdb->posts, $wpdb->comments
WHERE comment_approved = '1' AND post_status = 'publish'
      AND $wpdb->posts.ID=$wpdb->comments.comment_post_ID 
GROUP BY $wpdb->comments.comment_post_ID
ORDER BY comment_count DESC $limitclause";
    return $wpdb->get_results($q);
}

获取并输出WordPress的相关文章列表，如果没有相关文章就显示评论最多的文章，这个用到了上面获取评论最多文章的方法

function wp_get_related_posts() {
    global $wpdb, $post,$table_prefix;

    $now = current_time('mysql', 1);
    $tags = wp_get_post_tags($post->ID);

    $taglist = "'" . $tags[0]->term_id. "'";

    $tagcount = count($tags);
    if ($tagcount > 1) {
        for ($i = 1; $i <= $tagcount; $i++) {
            $taglist = $taglist . ", '" . $tags[$i]->term_id . "'";
        }
    }

    $q = "SELECT p.ID, p.post_title, p.post_date, p.comment_count,
count(t_r.object_id) as cnt
FROM $wpdb->term_taxonomy t_t,
        $wpdb->term_relationships t_r,
        $wpdb->posts p
WHERE t_t.taxonomy ='post_tag'
AND t_t.term_taxonomy_id = t_r.term_taxonomy_id
AND t_r.object_id  = p.ID
AND (t_t.term_id IN ($taglist))
AND p.ID != $post->ID
AND p.post_status = 'publish'
AND p.post_date_gmt < '$now'
GROUP BY t_r.object_id
ORDER BY cnt DESC, p.post_date_gmt DESC $limitclause;";

    $related_posts = $wpdb->get_results($q);
    $output = "";

    if (!$related_posts) {
        $related_posts = wp_get_most_commented_posts("LIMIT 10");

        foreach ($related_posts as $related_post ) {
            $output .= '<li>';

            $output .=  '<a href="'.
                get_permalink($related_post->ID).
                '" title="'.wptexturize($related_post->post_title).
                '">'.wptexturize($related_post->post_title).'';

            $output .=  '</a></li>';
        }
        $output = '<ul class="related_post">' . $output . '</ul>';
        $output =
            "<div class='most-comment'><h2>Most Commented</h2></div>".
            $output;
        return $output;
    }

    foreach ($related_posts as $related_post ) {
        $output .= '<li>';

        $output .=  '<a href="'.get_permalink($related_post->ID).
            '" title="'.wptexturize($related_post->post_title).'">'.
            wptexturize($related_post->post_title).'';

        $output .=  '</a></li>';
    }
    $output = '<ul class="related_post">' . $output . '</ul>';
    $output =  "<div class='related'><h2>Related Posts</h2></div>".
        $output;
    return $output;
}

function wp_related_posts() {
    $output = wp_get_related_posts() ;
    echo $output;
}

<获取并输出WordPress中的最新留言列表，并且不包含ABitNo自己写的评论，每条留言最多只显示30个字，后面加个省略号。其中的一个方法utf8Substr是用来截取utf字符串的。

function wp_list_newest_comments($limitclause="LIMIT 10") {
    global $wpdb;

    $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID,
comment_post_ID, comment_author, comment_date_gmt, comment_approved,
comment_type,comment_author_url,
comment_content
FROM $wpdb->comments
LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =
        $wpdb->posts.ID)
WHERE comment_author!='ABitNo' AND comment_approved = '1'
AND comment_type = '' AND post_password = ''
ORDER BY comment_date_gmt DESC $limitclause";

    $comments = $wpdb->get_results($sql);

    $output = "";

    foreach ($comments as $comment) {
        $comment_cont=utf8Substr(strip_tags($comment->comment_content),
            0, 30)."...";
        $output .= "<li><span>".strip_tags($comment->comment_author)
            ."</span>:  <a href=\"" . get_permalink($comment->ID) .
            "#comment-" . $comment->comment_ID . "\" title=\"on " .
            $comment->post_title . "\">" .$comment_cont
            ."</a></li>";
    }

    echo $output;
}

function utf8Substr($str, $from, $len) {
    return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.
        $from.
        '}'.'((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.
        $len.
        '}).*#s',
    '$1',$str);
}

把这些代码放到WordPress主题的functions.php文件中就可以直接调用了。上面前两段代码改自WP的一个插件WordPress 2.3 Related Posts Plugin，获取最新留言的代码也取自google并做了些修改，已经不知道最早的作者是谁了。