Any way to automatically delete accounts that have status “activation needed”?

[saschapi]

I would like to automatically remove accounts (inlcuding the WP user) of people that did not click their actication link after 24 hours. Is there any way to do that by wordpress cron or a hook? Doing the bulk delete all the time is pretty annoying.

Thank you for your input

[The Assurer]

There is an “Advanced Setting” called Auto Delete Pending Account.

[saschapi]

As others mentioned before, this setting will not delete accounts that did not manually validated their email. In case that others are looking for a way to auto delete accounts that registered and did not manually validated their email after a certain period of time, this function added to the functions.php or a custom plugin might help:

// Delete not activated members after three days
add_action('swpm_delete_pending_account_event', 'delete_not_activated_accounts');

function delete_not_activated_accounts() {

			global $wpdb;
			$query = $wpdb->prepare("SELECT member_id,user_name FROM {$wpdb->prefix}swpm_members_tbl WHERE account_state='activation_required' AND subscription_starts < DATE_SUB(NOW(), INTERVAL 3 DAY) LIMIT %d, 100",  $counter);
            $results = $wpdb->get_results($query);

	            if (empty($results)) {
                //No more records to process. Break out of the loop.
                return false;
            }
            $to_delete = array();
            foreach ($results as $result) {
                //Delete SM member
				$query = "DELETE FROM {$wpdb->prefix}swpm_members_tbl
                          WHERE member_id ='".$result->member_id."'";
                $wpdb->query($query);
				
				//Delete WP user
				$queryWP = "DELETE FROM {$wpdb->prefix}users
                          WHERE user_login = '".$result->user_name."'";
                $wpdb->query($queryWP);
				
            }

}

It uses the same hook as the pending account deletion. In this case it deletes those users after 3 days if they did not click the link in their email and activated their account. It is necessary to ALSO delete the WP account which this function does for you.

Hope this helps others. Sascha

[admin]

Thank you. Just adding more info to this. We have the following feature for manually bulk deleting accounts by ‘account status’ which might be helpful.

Go to the Members → Bulk Operation menu, then scroll down to the section titled Bulk Delete Member Accounts By Status. From there, select Activation Required as the account status and click the Delete button. This will remove all accounts currently marked with the “Activation Required” status.

[LaFamilleClub]

So, I’m not a PHP programmer, and this isn’t clear: LIMIT %d, 100

Does this limit it to 100 rows? 100 days? Do I want to limit it?

[The Assurer]

100 rows. But you should try the suggestion by @admin first, if you are not a PHP programmer.

[Author]

Posts