Changeset 9168

Timestamp:

10/09/2019 07:37:45 AM (5 years ago)

Author:

dd32

Message:

Login: Purge records from the 'pending registrations' table after 14 days.

By this time, either the account has been created, or the user_login/user_email is now available for registation again.

See #4739.

File:

• sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-login/functions.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-login/functions.php

@@ -349 +349 @@
     return $cache[ $cache_key ];
 }
+
+/**
+ * Schedule a cron-task to clear pending registrations regularly.
+ */
+function wporg_login_cron_tasks() {
+    if ( ! wp_next_scheduled( 'login_purge_pending_registrations' ) ) {
+        wp_schedule_event( time(), 'daily', 'login_purge_pending_registrations' );
+    }
+}
+add_action( 'admin_init', 'wporg_login_cron_tasks' );
+
+/**
+ * Clears the Pending Registrations table reguarly.
+ */
+function wporg_login_purge_pending_registrations() {
+    global $wpdb;
+    $two_weeks_ago = gmdate( 'Y-m-d H:i:s', time() - 14 * DAY_IN_SECONDS );
+
+    $wpdb->query( $wpdb->prepare(
+        "DELETE FROM `{$wpdb->base_prefix}user_pending_registrations`  WHERE `user_registered` <= %s",
+        $two_weeks_ago
+    ) );
+}
+add_action( 'login_purge_pending_registrations', 'wporg_login_purge_pending_registrations' );