Unpublish drupal content

unpublish-nodes.php

<?php
 
// Select all nodes of type article created by anonymous and admin
$result = db_select('node', 'n')
  ->fields('n', array('nid'))
  ->condition('type', 'article')
  ->condition('uid', array(0,1), 'IN')
  ->execute();
 
// go through results and unpublish each article.
foreach($result as $row) {
  $node = node_load($row->nid);
  print 'Unpublishing:  ' . $node->nid . ' - ' . $node->title . "\n";
  $node->status = 0;
  node_save($node);
}
 
exit(0);