Skip to content

Instantly share code, notes, and snippets.

@ideadude

ideadude/pmpro_copy_single_parent_restrictions_to_children.sql

Created May 1, 2019 13:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ideadude/fd725ccdf747ad76c56acb506fbe43b6 to your computer and use it in GitHub Desktop.
Save ideadude/fd725ccdf747ad76c56acb506fbe43b6 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Query to copy page restrictions to a page's children for Paid Memberships Pro
Raw
pmpro_copy_single_parent_restrictions_to_children.sql
# 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

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