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);
?>More like this
- Fix RSS output for CCK node types so that information from all important fields are included
- Drupal 6 wigs out if you delete or move (as in rename to settings.php) its default.settings.php
- Switch a node's content type... with no niceties or safety net
- Custom nodes module AND CCK: Bdragon serves you cake and lets you have it, too
- Does FeedAPI re-import a feed item if its node has been deleted?
Comments
Post new comment