Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Example SQL to duplicate restrictions for level ID 1 to also restrict for level ID 2
#Example SQL to duplicate restrictions for level ID 1 to also restrict for level ID 2
INSERT IGNORE INTO wp_pmpro_memberships_pages (membership_id, page_id)
SELECT '2', page_id FROM wp_pmpro_memberships_pages WHERE membership_id = 1;
@laurenhagan0306
Copy link

laurenhagan0306 commented Mar 29, 2021

This recipe is included in the blog post on "Bulk methods to restrict access to posts, pages, and CPTs for a specific membership level ID via MySQL" at Paid Memberships Pro here: https://www.paidmembershipspro.com/bulk-methods-to-restrict-access-to-posts-pages-and-cpts-for-a-specific-membership-level-id-via-mysql/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment