1 area51 Dec 31, 2006 09:12
3 area51 Dec 31, 2006 17:15
Good idea. Is there any way I can batch change all current posts from public to members only?
4 yabba Dec 31, 2006 18:17
You could use pma to change the status. If this was just for one blog then you'd need to narrow it down by 'where post_main_cat_ID = ##' (for each cat in the blog)
update evo_posts set post_status = 'protected'
Change evo_ to match your installs table prefix
Don't forget to take a backup first, I'm blonde and we don't always get it right first time ;)
¥
5 area51 Dec 31, 2006 18:24
Where do I go to make this change?
6 topanga Dec 31, 2006 18:32
In your phpmyadmin
and you find that in your cpanel
7 yabba Dec 31, 2006 18:33
You'd need to run that in PhpMyAdmin, which should be available through your control panel
¥
*edit*
lol, Damn Belgians beat us to the post again :p
Here's how I would do it :
1/ In the blog make all posts "protected" ( can only be seen by members )
2/ Create an "awaiting approval group" with no membership to the blog and no admin access etc
3/ Make the default group for new registrations the "awaiting approval" group
4/ After approving a member I'd change their group to one that does have membership to the blog.
¥