Delete Free Members (S2Member Level0)

Hi guys,

Could any of you help me out with this please? I run a WordPress/BuddyPress community with S2member at the heart of things handling membership upgrades/downgrades etc. Members subscribe at Level1 where I give them a free 14 day trial of our site. They can upgrade at anytime during the 14 days to Level2 and beyond (Premium Membership). I’m using S2Member PayPal Pro Forms, and all of this works really well.

The issue I have is that roughly half of my Subscribers never actually upgrade to a Premium Membership, and so after their 14 day trial is over, they never return. This leaves a lot of Subscribers clogging up my site at Level0 (Free Members).

So my question therefore is, is there a hack or a SQL command that I can use to automatically delete Free members – S2Member Level0 who haven’t logged in or been active for a given period of time, say 6 months or so?

Would appreciate any help here…

Thanks
Rob.

Thanks for your inquiry. ~ We appreciate your patience :-)

This would require custom code if you don’t want to do it from the Dashboard.
I’ll try to point you in the right direction.

Please create this directory and file:
/wp-content/mu-plugins/s2-hacks.php
(NOTE: these are MUST USE plugins, see: http://codex.wordpress.org/Must_Use_Plugins)
(See also: http://www.s2member.com/kb/hacking-s2member/)

<?php
add_action('init', 's2_delete_old_subscribers');
function s2_delete_old_subscribers()
	{
		if(empty($_GET&#91;__FUNCTION__&#93;)) return;
		
		foreach(get_users('role=subscriber') as $user)
			if(strtotime($user->user_registered) < strtotime('-6 months'))
				wp_delete_user($user->ID);
		
		exit('Old Free Subscribers deleted.');
	}

Now open this URL in your browser.

http://www.example.com/?s2_delete_old_subscribers=yes

BACKUP YOUR DATABASE BEFORE RUNNING THIS CODE.

Hi Jason, Many thanks for taking the time to code this. It’s appreciated.

Two questions. I’m using Buddypress, so will –

wp_delete_user($user->ID);

be sufficient to delete users cleanly on BuddyPress to?

Secondly, does the code take into account when the user last logged into the site? Ideally, I only want to delete members who are on level0 and haven’t logged in for 6 months or more. I do not want to delete everyone who has been at Level0 for longer than 6 months. Only those who have been inactive, if that makes sense?

We have free members at level0 still using non premium features of our site and I obviously don’t want to delete them :)

Is this possible?

Thanks again
Rob.

Two questions. I’m using Buddypress, so will –

wp_delete_user($user->ID);
be sufficient to delete users cleanly on BuddyPress to?

I’m not aware of any problems with this function when running BuddyPress. However, this is a question that I would ask in the BuddyPress forums for some confirmation.

Secondly, does the code take into account when the user last logged into the site?

s2Member® does not keep track of this information yet; and neither does WordPress® to my knowledge. So it’s going to be very difficult to implement this. s2Member® keeps track of the number of times that a User/Member has logged in, but not the times at which this occurred. I’ll accept this as a feature request though.

Hi Jason,

Yes, please if you could add it as a feature in an upcoming release that would be awesome…

Thanks
Rob.