Changeset 1355 for trunk/wp-commentsrss2.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-commentsrss2.php (modified) (2 diffs)

trunk/wp-commentsrss2.php

@@ -29 +29 @@
             $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, 
             comment_author_url, comment_date, comment_content, comment_post_ID, 
-            $tableposts.ID, $tableposts.post_password FROM $tablecomments 
-            LEFT JOIN $tableposts ON comment_post_id = id WHERE comment_post_ID = '$id' 
-            AND $tablecomments.comment_approved = '1' AND $tableposts.post_status = 'publish' 
+            $wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments 
+            LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE comment_post_ID = '$id' 
+            AND $wpdb->comments.comment_approved = '1' AND $wpdb->posts.post_status = 'publish' 
             AND post_date < '".date("Y-m-d H:i:59")."' 
             ORDER BY comment_date LIMIT " . get_settings('posts_per_rss') );
@@ -37 +37 @@
             $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, 
             comment_author_url, comment_date, comment_content, comment_post_ID, 
-            $tableposts.ID, $tableposts.post_password FROM $tablecomments 
-            LEFT JOIN $tableposts ON comment_post_id = id WHERE $tableposts.post_status = 'publish' 
-            AND $tablecomments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."'  
+            $wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments 
+            LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE $wpdb->posts.post_status = 'publish' 
+            AND $wpdb->comments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."'  
             ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') );
         }