Changeset 10009

Timestamp:

07/03/2020 06:51:15 AM (6 years ago)

Author:

dd32

Message:

Login: Don't delete pending accounts whose initial registration were over 14 days but the activation key has been resent since then.

See #5278.

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

@@ -350 +350 @@
 function wporg_login_purge_pending_registrations() {
         global $wpdb;
-        $two_weeks_ago = gmdate( 'Y-m-d H:i:s', time() - 14 * DAY_IN_SECONDS );
+        $two_weeks_ago_s = time() - 14 * DAY_IN_SECONDS;
+        $two_weeks_ago   = gmdate( 'Y-m-d H:i:s', $two_weeks_ago_s );
 
         $wpdb->query( $wpdb->prepare(
-                "DELETE FROM `{$wpdb->base_prefix}user_pending_registrations`  WHERE `user_registered` <= %s",
-                $two_weeks_ago
+                "DELETE FROM `{$wpdb->base_prefix}user_pending_registrations`
+                WHERE `user_registered` <= %s AND LEFT( `user_activation_key`, 10 ) <= %d",
+                $two_weeks_ago,
+                $two_weeks_ago_s
         ) );
 }