Posts

Showing posts from April, 2020

Drupal Node Revisions Cleanup

<? $nodes = db_select('node', 'n')     ->fields('n', array('nid','vid'))     ->execute(); foreach ($nodes as $node) {     $revisions = db_select('node_revision', 'n')         ->fields('n', array('vid'))         ->condition('n.nid',$node->nid)         ->condition('n.vid',$node->vid, '<')         ->execute();     $count = 0;     foreach ($revisions as $rev)     {         // Uncomment below line to actually delete         // node_revision_delete($rev->vid);           $count++;     } if ($count>0)     echo '<a target="_blank" href="/node/'.$node->nid.'">node '.$node->nid.'</a><br>count '.$count.'<br>'; } ?>

Drupal unpublish node programmatically

<? $nids = explode(',','62013,61859,61863,61865,61867,61871,61886,63158,62026,62030,186894,62065,62066,62075,62077,147834,62944,62107,62109,62110,62113,62114,62117,62593,62595,147333,62625,62725,62730,62731,62737,62738,147694,62744,62746,62747,62749,62752,62882,62931,62936,62939,63142,63329,63330,179870,147716,63537,63545,63990,63779,63778,64096,64097,64098,147160,64105,147159,138323,142181,146031,210600,235951,141272,142298,186895,146032,146997,147529,145236,145813,274097,281698,296945,299231'); foreach ($nids as $nid) { $node = node_load($nid); if (isset($node->status)) { $node->status = 0; node_save($node); } } ?>