最近突然发现首页显示的好像全是我的评论,有点那个啥!所以就想修改一下,首页不显示管理员评论,也就是我的那些评论了.正常流程百度and Google之,经过实验发现在方法可用,在这发上来供大家参考!

image

老大网络原来的侧边栏调用最新评论的代码是这样的:

<?php
        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,
        SUBSTRING(comment_content,1,35) AS com_excerpt
        FROM $wpdb->comments
        LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =
        $wpdb->posts.ID)
       WHERE comment_approved = ‘1’ AND comment_type = ” AND
        post_password = ”  ORDER BY comment_date_gmt DESC  LIMIT 10";
        $comments = $wpdb->get_results($sql);
        $output = $pre_HTML;
        $output .= "\n<ul>";
        foreach ($comments as $comment) {
        $output .= "\n<li>".strip_tags($comment->comment_author)
        .":" . "<a href=\"" . get_permalink($comment->ID) .
        "#comment-" . $comment->comment_ID . "\" title=\"on " .
        $comment->post_title . "\">" . strip_tags($comment->com_excerpt)
        ."</a></li>";
        }
        $output .= "\n</ul>";
        $output .= $post_HTML;
        echo $output;?>   

现在我加了一句代码[AND  comment_author <>’max’],将其修改为:

<?php
        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,
        SUBSTRING(comment_content,1,35) AS com_excerpt
        FROM $wpdb->comments
        LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =
        $wpdb->posts.ID)
        WHERE comment_approved = ‘1’ AND comment_type = ” AND
        post_password = ”AND  comment_author <>’admin’
        ORDER BY comment_date_gmt DESC
        LIMIT 10
";
        $comments = $wpdb->get_results($sql);
        $output = $pre_HTML;
        $output .= "\n<ul>";
        foreach ($comments as $comment) {
        $output .= "\n<li>".strip_tags($comment->comment_author)
        .":" . "<a href=\"" . get_permalink($comment->ID) .
        "#comment-" . $comment->comment_ID . "\" title=\"on " .
        $comment->post_title . "\">" . strip_tags($comment->com_excerpt)
        ."</a></li>";
        }
        $output .= "\n</ul>";
        $output .= $post_HTML;
        echo $output;?>   

好了,不多做解释,我都懂,我相信你肯定也懂吧!