Membership Plugin

WordPress Membership Plugin

How select posts not protected

Simple Membership Plugin › Forums › Simple Membership Plugin › How select posts not protected

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • November 4, 2015 at 2:37 pm #3827
    Anonymous
    Inactive

    Hi,

    is there a way to list posts not protected (if necessary using PhpMyAdmin)?

    Now I have a lot of posts and some of these could not protected, I need to find them, so I can edit and update.
    Thank you.

    November 5, 2015 at 1:00 am #3833
    nur
    Participant

    Hi,
    protected posts are stored as serialized object in wp_swpm_membership_tbl.

    you can retrieve them using:

    
SELECT post_list FROM  <code>wp_swpm_membership_tbl</code> WHERE id =1

    once you deserialize the object, you can build query in phpmyadmin to retrieve posts not protected.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.