Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL Query to copy page restrictions to a page's children for Paid Memberships Pro
# Copy page restrictions from parent page to child pages.
# NOTE that this doesn't delete any existing restrictions for the child pages.
INSERT IGNORE INTO wp_pmpro_memberships_pages (membership_id, page_id)
SELECT mp.membership_id, p.ID
FROM wp_posts p
LEFT JOIN wp_pmpro_memberships_pages mp ON p.post_parent = mp.page_id
WHERE mp.membership_id IS NOT NULL
AND p.ID = 123; -- Change the p.ID here to match your post's ID.
@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