Changeset 3718572

Timestamp:

09/29/2026 08:48:37 AM (3 weeks ago)

Author:

prondzyn

Message:

1.1: configurable days, SQLite fix, tested up to 7.1

Location:

automatic-spam-eraser

Files:

• tags/1.1 (copied) (copied from automatic-spam-eraser/trunk )
• tags/1.1/automatic-spam-eraser.php (modified) (2 diffs)
• tags/1.1/readme.txt (modified) (3 diffs)
• trunk/automatic-spam-eraser.php (modified) (2 diffs)
• trunk/readme.txt (modified) (3 diffs)

automatic-spam-eraser/tags/1.1/automatic-spam-eraser.php

@@ -3 +3 @@
    * Plugin Name: Automatic SPAM Eraser
    * Plugin URI: http://wordpress.org/plugins/automatic-spam-eraser/
-   * Description: The plugin is adding a new WP-Cron event which automatically removes all <a href="edit-comments.php?comment_status=spam">spam</a> comments older than 7 days.
-   * Version: 1.0
+   * Description: The plugin is adding a new WP-Cron event which automatically removes all <a href="edit-comments.php?comment_status=spam">spam</a> comments older than 7 days (configurable in <a href="options-discussion.php#automatic_spam_eraser_days">Settings &rarr; Discussion</a>).
+   * Version: 1.1
    * Author: Piotr Prądzyński
    * Author URI: http://prondzyn.com
    * License: GPL2
+   * Text Domain: automatic-spam-eraser
    */
+
+  define( 'AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS', 7 );
 
   register_activation_hook(__FILE__, 'on_activation');
@@ -15 +18 @@
     wp_schedule_event( time(), 'daily', 'automatic_spam_eraser_event' );
   }
-  
+
   add_action( 'automatic_spam_eraser_event',  'delete_spam_from_db' );
-  
+
+  function automatic_spam_eraser_get_days() {
+    return automatic_spam_eraser_sanitize_days( get_option( 'automatic_spam_eraser_days', AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS ) );
+  }
+
+  function automatic_spam_eraser_sanitize_days( $days ) {
+    $days = intval( $days );
+    return $days >= 1 ? $days : AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS;
+  }
+
   function delete_spam_from_db() {
     global $wpdb;
-    $wpdb->query( 
+    // spam from N or more calendar days ago, i.e. before midnight N-1 days ago;
+    // computed in PHP instead of DATEDIFF() to work on non-MySQL databases (e.g. SQLite)
+    $cutoff = gmdate( 'Y-m-d', strtotime( '-' . ( automatic_spam_eraser_get_days() - 1 ) . ' days' ) );
+    $wpdb->query(
       $wpdb->prepare(
-        "DELETE FROM $wpdb->comments WHERE comment_approved = %s AND DATEDIFF(DATE(%s), comment_date) >= %d", 
+        "DELETE FROM $wpdb->comments WHERE comment_approved = %s AND comment_date < %s",
         'spam',
-        date('Y-m-d'), 7
+        $cutoff
       )
     );
   }
 
+  add_action( 'admin_init', 'automatic_spam_eraser_register_settings' );
+
+  function automatic_spam_eraser_register_settings() {
+    register_setting( 'discussion', 'automatic_spam_eraser_days', 'automatic_spam_eraser_sanitize_days' );
+    add_settings_field(
+      'automatic_spam_eraser_days',
+      __( 'Automatic SPAM Eraser', 'automatic-spam-eraser' ),
+      'automatic_spam_eraser_render_days_field',
+      'discussion'
+    );
+  }
+
+  function automatic_spam_eraser_render_days_field() {
+    printf(
+      '<label for="automatic_spam_eraser_days">%s</label>',
+      sprintf(
+        /* translators: %s: number input */
+        __( 'Delete spam comments older than %s days', 'automatic-spam-eraser' ),
+        sprintf(
+          '<input name="automatic_spam_eraser_days" type="number" step="1" min="1" id="automatic_spam_eraser_days" value="%d" class="small-text" />',
+          automatic_spam_eraser_get_days()
+        )
+      )
+    );
+  }
+
+  add_filter( 'plugin_action_links_' . plugin_basename( __FILE__ ), 'automatic_spam_eraser_action_links' );
+
+  function automatic_spam_eraser_action_links( $links ) {
+    array_unshift( $links, sprintf(
+      '<a href="%s">%s</a>',
+      esc_url( admin_url( 'options-discussion.php#automatic_spam_eraser_days' ) ),
+      __( 'Settings', 'automatic-spam-eraser' )
+    ) );
+    return $links;
+  }
+
   register_deactivation_hook(__FILE__, 'on_deactivation');
-  
+
   function on_deactivation() {
     wp_clear_scheduled_hook( 'automatic_spam_eraser_event' );
   }
+
+  register_uninstall_hook( __FILE__, 'automatic_spam_eraser_uninstall' );
+
+  function automatic_spam_eraser_uninstall() {
+    delete_option( 'automatic_spam_eraser_days' );
+  }
 ?>

automatic-spam-eraser/tags/1.1/readme.txt

@@ -3 +3 @@
 Tags: comments, spam, eraser, cleaner, cron
 Requires at least: 3.0.1
-Tested up to: 6.5.2
-Stable tag: 1.0
+Tested up to: 7.1
+Stable tag: 1.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -14 +14 @@
 The plugin is adding a new WP-Cron event which automatically removes all spam comments older than 7 days.
 
+The number of days can be changed in Settings > Discussion (default: 7).
+
 **For the proper functioning requires a properly working WP-Cron. If the plugin does not work please check you have WP-Cron correctly working.**
 
@@ -20 +22 @@
 1. Upload `automatic-spam-eraser.php` to the `/wp-content/plugins/` directory
 2. Activate the plugin through the 'Plugins' menu in WordPress
+
+== Changelog ==
+
+= 1.1 =
+* Added: the number of days is now configurable in Settings > Discussion (default: 7).
+* Fixed: on SQLite databases all spam comments were removed regardless of their age.
+* Tested up to WordPress 7.1.
+
+= 1.0 =
+* Initial release.

automatic-spam-eraser/trunk/automatic-spam-eraser.php

@@ -3 +3 @@
    * Plugin Name: Automatic SPAM Eraser
    * Plugin URI: http://wordpress.org/plugins/automatic-spam-eraser/
-   * Description: The plugin is adding a new WP-Cron event which automatically removes all <a href="edit-comments.php?comment_status=spam">spam</a> comments older than 7 days.
-   * Version: 1.0
+   * Description: The plugin is adding a new WP-Cron event which automatically removes all <a href="edit-comments.php?comment_status=spam">spam</a> comments older than 7 days (configurable in <a href="options-discussion.php#automatic_spam_eraser_days">Settings &rarr; Discussion</a>).
+   * Version: 1.1
    * Author: Piotr Prądzyński
    * Author URI: http://prondzyn.com
    * License: GPL2
+   * Text Domain: automatic-spam-eraser
    */
+
+  define( 'AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS', 7 );
 
   register_activation_hook(__FILE__, 'on_activation');
@@ -15 +18 @@
     wp_schedule_event( time(), 'daily', 'automatic_spam_eraser_event' );
   }
-  
+
   add_action( 'automatic_spam_eraser_event',  'delete_spam_from_db' );
-  
+
+  function automatic_spam_eraser_get_days() {
+    return automatic_spam_eraser_sanitize_days( get_option( 'automatic_spam_eraser_days', AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS ) );
+  }
+
+  function automatic_spam_eraser_sanitize_days( $days ) {
+    $days = intval( $days );
+    return $days >= 1 ? $days : AUTOMATIC_SPAM_ERASER_DEFAULT_DAYS;
+  }
+
   function delete_spam_from_db() {
     global $wpdb;
-    $wpdb->query( 
+    // spam from N or more calendar days ago, i.e. before midnight N-1 days ago;
+    // computed in PHP instead of DATEDIFF() to work on non-MySQL databases (e.g. SQLite)
+    $cutoff = gmdate( 'Y-m-d', strtotime( '-' . ( automatic_spam_eraser_get_days() - 1 ) . ' days' ) );
+    $wpdb->query(
       $wpdb->prepare(
-        "DELETE FROM $wpdb->comments WHERE comment_approved = %s AND DATEDIFF(DATE(%s), comment_date) >= %d", 
+        "DELETE FROM $wpdb->comments WHERE comment_approved = %s AND comment_date < %s",
         'spam',
-        date('Y-m-d'), 7
+        $cutoff
       )
     );
   }
 
+  add_action( 'admin_init', 'automatic_spam_eraser_register_settings' );
+
+  function automatic_spam_eraser_register_settings() {
+    register_setting( 'discussion', 'automatic_spam_eraser_days', 'automatic_spam_eraser_sanitize_days' );
+    add_settings_field(
+      'automatic_spam_eraser_days',
+      __( 'Automatic SPAM Eraser', 'automatic-spam-eraser' ),
+      'automatic_spam_eraser_render_days_field',
+      'discussion'
+    );
+  }
+
+  function automatic_spam_eraser_render_days_field() {
+    printf(
+      '<label for="automatic_spam_eraser_days">%s</label>',
+      sprintf(
+        /* translators: %s: number input */
+        __( 'Delete spam comments older than %s days', 'automatic-spam-eraser' ),
+        sprintf(
+          '<input name="automatic_spam_eraser_days" type="number" step="1" min="1" id="automatic_spam_eraser_days" value="%d" class="small-text" />',
+          automatic_spam_eraser_get_days()
+        )
+      )
+    );
+  }
+
+  add_filter( 'plugin_action_links_' . plugin_basename( __FILE__ ), 'automatic_spam_eraser_action_links' );
+
+  function automatic_spam_eraser_action_links( $links ) {
+    array_unshift( $links, sprintf(
+      '<a href="%s">%s</a>',
+      esc_url( admin_url( 'options-discussion.php#automatic_spam_eraser_days' ) ),
+      __( 'Settings', 'automatic-spam-eraser' )
+    ) );
+    return $links;
+  }
+
   register_deactivation_hook(__FILE__, 'on_deactivation');
-  
+
   function on_deactivation() {
     wp_clear_scheduled_hook( 'automatic_spam_eraser_event' );
   }
+
+  register_uninstall_hook( __FILE__, 'automatic_spam_eraser_uninstall' );
+
+  function automatic_spam_eraser_uninstall() {
+    delete_option( 'automatic_spam_eraser_days' );
+  }
 ?>

automatic-spam-eraser/trunk/readme.txt

@@ -3 +3 @@
 Tags: comments, spam, eraser, cleaner, cron
 Requires at least: 3.0.1
-Tested up to: 6.5.2
-Stable tag: 1.0
+Tested up to: 7.1
+Stable tag: 1.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -14 +14 @@
 The plugin is adding a new WP-Cron event which automatically removes all spam comments older than 7 days.
 
+The number of days can be changed in Settings > Discussion (default: 7).
+
 **For the proper functioning requires a properly working WP-Cron. If the plugin does not work please check you have WP-Cron correctly working.**
 
@@ -20 +22 @@
 1. Upload `automatic-spam-eraser.php` to the `/wp-content/plugins/` directory
 2. Activate the plugin through the 'Plugins' menu in WordPress
+
+== Changelog ==
+
+= 1.1 =
+* Added: the number of days is now configurable in Settings > Discussion (default: 7).
+* Fixed: on SQLite databases all spam comments were removed regardless of their age.
+* Tested up to WordPress 7.1.
+
+= 1.0 =
+* Initial release.