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

trunk/wp-comments-post.php

@@ -33 +33 @@
 $user_ip = $_SERVER['REMOTE_ADDR'];
 
-if ( 'closed' ==  $wpdb->get_var("SELECT comment_status FROM $tableposts WHERE ID = '$comment_post_ID'") )
+if ( 'closed' ==  $wpdb->get_var("SELECT comment_status FROM $wpdb->posts WHERE ID = '$comment_post_ID'") )
     die( __('Sorry, comments are closed for this item.') );
 
@@ -52 +52 @@
 
 // Simple flood-protection
-$lasttime = $wpdb->get_var("SELECT comment_date FROM $tablecomments WHERE comment_author_IP = '$user_ip' ORDER BY comment_date DESC LIMIT 1");
+$lasttime = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_author_IP = '$user_ip' ORDER BY comment_date DESC LIMIT 1");
 if (!empty($lasttime)) {
     $time_lastcomment= mysql2date('U', $lasttime);
@@ -69 +69 @@
 }
 
-$wpdb->query("INSERT INTO $tablecomments 
+$wpdb->query("INSERT INTO $wpdb->comments 
 (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_approved) 
 VALUES