Home ›
Delete all nodes of a given content type with code ('cause, say, you're using Drupal 4.7)Delete all nodes of a given content type with code ('cause, say, you're using Drupal 4.7)
Submitted by Benjamin Melançon on September 22, 2008 - 10:31pm
Adapted from Kathleen Murtaugh's How to make mass changes to nodes in Drupal, just replacing most of the interesting parts with simply node_delete.
Code for Amazing Things online fundraising auction, the Drupal 4.7 corpse i reanimate year after year.
<?php
$sql = "SELECT n.nid
FROM {node} n
WHERE n.type = 'my_content_type'
ORDER BY n.nid DESC";
$result = db_query($sql);
$processed_nodes = 0;
while(
$anode = db_fetch_object($result)) {
node_delete($anode->nid);
$processed_nodes++;
}
if(
$processed_nodes){
$message = $processed_nodes.' nodes were deleted.';
} else {
$message = 'No nodes were deleted.';
}
drupal_set_message($message);
?>
Comments
Post new comment