| 1 | <?php
 | 
  
    | 2 | 
 | 
  
    | 3 | // $Id: delete.php 563 2008-01-18 23:13:42Z Ruebenwurzel $
 | 
  
    | 4 | 
 | 
  
    | 5 | /*
 | 
  
    | 6 | 
 | 
  
    | 7 |  Website Baker Project <http://www.websitebaker.org/>
 | 
  
    | 8 |  Copyright (C) 2004-2008, Ryan Djurovich
 | 
  
    | 9 | 
 | 
  
    | 10 |  Website Baker is free software; you can redistribute it and/or modify
 | 
  
    | 11 |  it under the terms of the GNU General Public License as published by
 | 
  
    | 12 |  the Free Software Foundation; either version 2 of the License, or
 | 
  
    | 13 |  (at your option) any later version.
 | 
  
    | 14 | 
 | 
  
    | 15 |  Website Baker is distributed in the hope that it will be useful,
 | 
  
    | 16 |  but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
  
    | 17 |  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
  
    | 18 |  GNU General Public License for more details.
 | 
  
    | 19 | 
 | 
  
    | 20 |  You should have received a copy of the GNU General Public License
 | 
  
    | 21 |  along with Website Baker; if not, write to the Free Software
 | 
  
    | 22 |  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 | 
  
    | 23 | 
 | 
  
    | 24 | */
 | 
  
    | 25 | 
 | 
  
    | 26 | // Must include code to stop this file being access directly
 | 
  
    | 27 | if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); }
 | 
  
    | 28 | 
 | 
  
    | 29 | //get and remove all php files created for the news section
 | 
  
    | 30 | $query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'");
 | 
  
    | 31 | if($query_details->numRows() > 0) {
 | 
  
    | 32 | 	while($link = $query_details->fetchRow()) {
 | 
  
    | 33 | 		if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) {
 | 
  
    | 34 | 		unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION);
 | 
  
    | 35 | 		}
 | 
  
    | 36 | 	}
 | 
  
    | 37 | }
 | 
  
    | 38 | //check to see if any other sections are part of the news page, if only 1 news is there delete it
 | 
  
    | 39 | $query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id'");
 | 
  
    | 40 | if($query_details->numRows() == 1) {
 | 
  
    | 41 | 	$query_details2 = $database->query("SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
 | 
  
    | 42 | 	$link = $query_details2->fetchRow();
 | 
  
    | 43 | 	if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) {
 | 
  
    | 44 | 		unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION);
 | 
  
    | 45 | 	}
 | 
  
    | 46 | }
 | 
  
    | 47 | 
 | 
  
    | 48 | $database->query("DELETE FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'");
 | 
  
    | 49 | $database->query("DELETE FROM ".TABLE_PREFIX."mod_news_groups WHERE section_id = '$section_id'");
 | 
  
    | 50 | $database->query("DELETE FROM ".TABLE_PREFIX."mod_news_comments WHERE section_id = '$section_id'");
 | 
  
    | 51 | $database->query("DELETE FROM ".TABLE_PREFIX."mod_news_settings WHERE section_id = '$section_id'");
 | 
  
    | 52 | 
 | 
  
    | 53 | ?>
 |