Skip to content

Instantly share code, notes, and snippets.

@strangerstudios

strangerstudios/lockdown_menus_and_recipes.sql

Created August 25, 2015 16:18
Show Gist options
  • Save strangerstudios/6c0a4e44ccf9543a41b3 to your computer and use it in GitHub Desktop.
Save strangerstudios/6c0a4e44ccf9543a41b3 to your computer and use it in GitHub Desktop.
Download ZIP
require level 2 on all posts of type recipe or menu
Raw
lockdown_menus_and_recipes.sql
#require level 2 on all posts of type recipe or menu
INSERT INTO wp_pmpro_memberships_pages (membership_id, page_id)
SELECT 2, page_id FROM wp_posts WHERE post_type IN('menus', 'recipes') AND post_status = 'publish'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment