Skip to content

Instantly share code, notes, and snippets.

@amityweb

amityweb/update_pmpro_members_expiry_dates

Created December 22, 2017 16:07
Show Gist options
  • Save amityweb/b181e6bb7c19636664cfc6583387c29e to your computer and use it in GitHub Desktop.
Save amityweb/b181e6bb7c19636664cfc6583387c29e to your computer and use it in GitHub Desktop.
Download ZIP
Paid Memberships Pro SQL to Update Expiry Dates for Member Groups
Raw
update_pmpro_members_expiry_dates
UPDATE wp_pmpro_memberships_users
SET enddate = '2018-01-30 23:59:59'
WHERE (membership_id = 10 OR membership_id = 11)
AND enddate = '0000-00-00 00:00:00'
AND status = 'active';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment