Changeset 2561

Timestamp:

04/20/2005 09:56:28 PM (19 years ago)

Author:

matt

Message:

Dupe comment check - ​http://mosquito.wordpress.org/view.php?id=1265

File:

• trunk/wp-includes/functions-post.php (modified) (1 diff)

trunk/wp-includes/functions-post.php

@@ -486 +486 @@
     }
 
+    // Simple duplicate check
+    $dupe = "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = '$comment_post_ID' AND ( comment_author = '$author' ";
+    if ( $email ) $dupe .= "OR comment_author_email = '$email' ";
+    $dupe .= ") AND comment_content = '$comment' LIMIT 1";
+    if ( $wpdb->get_var($dupe) )
+        die( __('Duplicate comment detected; it looks as though you\'ve already said that!') );
+
     // Simple flood-protection
     if ( $lasttime = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_author_IP = '$user_ip' OR comment_author_email = '$email' ORDER BY comment_date DESC LIMIT 1") ) {