Changeset 1355 for trunk/wp-admin/moderation.php

Timestamp:

05/24/2004 08:22:18 AM (21 years ago)

Author:

saxmatt

Message:

Giant commit, sorry mailing list people. Move all table names to new $wpdb versions. Works but the whole app needs thorough testing now.

File:

• trunk/wp-admin/moderation.php (modified) (2 diffs)

trunk/wp-admin/moderation.php

@@ -135 +135 @@
 <div class="wrap">
 <?php
-$comments = $wpdb->get_results("SELECT * FROM $tablecomments WHERE comment_approved = '0'");
+$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0'");
 
 if ($comments) {
@@ -148 +148 @@
     foreach($comments as $comment) {
     $comment_date = mysql2date(get_settings("date_format") . " @ " . get_settings("time_format"), $comment->comment_date);
-    $post_title = $wpdb->get_var("SELECT post_title FROM $tableposts WHERE ID='$comment->comment_post_ID'");
+    $post_title = $wpdb->get_var("SELECT post_title FROM $wpdb->posts WHERE ID='$comment->comment_post_ID'");
     
     echo "\n\t<li id='comment-$comment->comment_ID'>";