What are the table prefix for the protected content plugin?

We have been experimenting with the new protected content plugin and can't find the tables to delete to remove our testing.

  • Michelle Shull

    Hi there, Brian!

    Thanks to your question, I just learned something valuable about Protected Content. We don't use unique tables to store the data, we store it in other tables.

    We can still get this cleaned up for you, by borrowing from the private function we use to clean up options:

    private static function cleanup() {
    
    		global $wpdb;
    		$sql = array();
    
    		$sql[] = "DELETE FROM $wpdb->options WHERE option_name LIKE 'ms_%';";
    		$sql[] = "DELETE FROM $wpdb->posts WHERE post_type LIKE 'ms_%';";
    		$sql[] = "DELETE FROM $wpdb->postmeta  WHERE NOT EXISTS (SELECT 1 FROM wp_posts tmp WHERE tmp.ID = post_id);";
    		$sql[] = "DELETE FROM $wpdb->options WHERE option_name LIKE '_transient_%';";
    
    		foreach( $sql as $s ) {
    			$wpdb->query( $s );
    		}
    	}

    This is obviously PHP, but if we strip away the PHP code, we're left with some handy queries you can run on your MySQL to clean up the bits and pieces of Protected Content data throughout your database.

    Hope this helps, and glad you're having fun playing with Protected Content. We were so excited to share it with you. : )

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.