Developer Documentation

How can I do a bulk edit of the Status field for all the posts in my database?

Use the following SQL commands to change the post_status for every post in your wp_posts database table. This command will do the bulk change and exclude Pages from being changed–remember to replace STATUS with draft, private, or publish.

UPDATE wp_posts  SET post_status = 'STATUS' WHERE post_status != 'static';

If you have multiple authors and only want to do a bulk edit of just one author’s post, you can use the following command, but remember to replace NUMBER with the correct ID number of the post_author.

 UPDATE wp_posts SET post_status='STATUS' WHERE post_author='NUMBER';

How do I get .phps files to show up in colored text on my server?

If you want to have your server display .phps files in color like this updatelinkroll.phps at, add the following line to your .htaccess file in the server root directory. This assumes your server is Apache and that you have the ability to add types in .htaccess

AddType application/x-httpd-php-source .phps