#2 Feb 24, 2007 22:51
The ease of doing this depends on how many categories you have in the blog you want to make private. Even though we think of posts as being in a blog with a category, the database stores them as attached to a category which happens to be assigned to a blog. So you're going to need a list of all the category numbers for the blog in question. Then via phpmyadmin something like this should get it done for you:
NNN is each main category ID for the posts you want to hide. So like a post in 5 cats will be hidden by doing the query to the main cat for that post.
Backup your database first! To test if it's working you'll have to either log out of your blog or visit your site in a different browser and see if posts are "going away" after each time you do the query. BTW since you didn't pick a version I figured it must be 192 and came up with a query that'll work for that release. Or at least I think it'll work!