Bulk Protection flag change

[adelamora]

Is there a way to do a bulk change on the status of a page from

“No, do not protect this content”

to

“Yes, Protect this content”

and all content for “Subscribed” level.

I was looking for the flag on the database, but I’m unable to identify it. Any suggestions?

Regards

Arturo

[mbrsolution]

Hi, are you referring to changing the content protect level for all pages or a number of pages at the same time? Is that what you mean by bulk? If you are, then unfortunately at present that is not possible with the plugin.

Kind regards

[adelamora]

If you can tell me on which table of the database is the flag, I can run a MySQL query, I need to convert around 12000 pages…

Thank you!

[mbrsolution]

Hi, the plugin developers will investigate further your question.

Thank you

[admin]

The following table contains the data for the protection settings:

swpm_membership_tbl

Some data is stored there in a serialized form. You will need to do some reverse engineering there by doing the following maybe:

1) Protect a post then observe the data for that entry.
2) Then un-protect that same post and see data for that entry again.

The change in data should help you understand what value needs to change.

We are working on adding an interface to bulk update content protection of posts/pages. We should have something for the next release (or the one after that).

[adelamora]

Thank you I find the field page_list and got the logics behind the flag. Now I’m working on my Query. Thank you!

SOLVED

[estudie]

Hi adelamora,
I have a simalare problem and wonder how you solved it. Can you share this critical information?

[Author]

Posts