Changeset 546 for trunk/b2commentspopup.php

Timestamp:

11/12/2003 03:22:47 PM (22 years ago)

Author:

emc3

Message:

otaku42's comment moderation patches

File:

• trunk/b2commentspopup.php (modified) (1 diff)

trunk/b2commentspopup.php

@@ -31 +31 @@
 <?php
 // this line is WordPress' motor, do not delete it.
-$comments = $wpdb->get_results("SELECT * FROM $tablecomments WHERE comment_post_ID = $id ORDER BY comment_date");
+$comments = $wpdb->get_results("SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1' ORDER BY comment_date");
 $commentstatus = $wpdb->get_row("SELECT comment_status, post_password FROM $tableposts WHERE ID = $id");
 if (!empty($commentstatus->post_password) && $HTTP_COOKIE_VARS['wp-postpass_'.$cookiehash] != $commentstatus->post_password) {  // and it doesn't match the cookie