trash/delete_rss.php

   1 #!/usr/bin/php
   2 <?php
   3 require('../config/config.inc');
   4 //connecting to database and creating universal $db object
   5 require(INCLUDE_DIR.'/log.inc');
   6 require(INCLUDE_DIR.'/database.inc');
   7 require(INCLUDE_DIR.'/nodes.inc');
   8 $db=new CLASS_DATABASE();
   9
  10 $set=$db->query("select node_id from nodes where node_type='13'");
  11
  12 while ($set->next()) {
  13         $id=$set->getString('node_id');
  14         if (is_numeric($id)) {
  15                 $q="delete from node_content where node_id='$id'";
  16                 $db->query($q);
  17                 $q="delete from nodes where node_id='$id'";
  18                 $db->query($q);
  19         }
  20 }
  21
  22 ?>