| 1 | <?php
 | 
  
    | 2 | 
 | 
  
    | 3 | // $Id: delete.php 310 2006-02-19 05:31:10Z ryan $
 | 
  
    | 4 | 
 | 
  
    | 5 | /*
 | 
  
    | 6 | 
 | 
  
    | 7 |  Website Baker Project <http://www.websitebaker.org/>
 | 
  
    | 8 |  Copyright (C) 2004-2006, 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 | // Get page id
 | 
  
    | 27 | if(!isset($_GET['page_id']) OR !is_numeric($_GET['page_id'])) {
 | 
  
    | 28 | 	header("Location: index.php");
 | 
  
    | 29 | 	exit(0);
 | 
  
    | 30 | } else {
 | 
  
    | 31 | 	$page_id = $_GET['page_id'];
 | 
  
    | 32 | }
 | 
  
    | 33 | 
 | 
  
    | 34 | // Create new admin object and print admin header
 | 
  
    | 35 | require('../../config.php');
 | 
  
    | 36 | require_once(WB_PATH.'/framework/class.admin.php');
 | 
  
    | 37 | $admin = new admin('Pages', 'pages_delete');
 | 
  
    | 38 | 
 | 
  
    | 39 | // Include the WB functions file
 | 
  
    | 40 | require_once(WB_PATH.'/framework/functions.php');
 | 
  
    | 41 | 
 | 
  
    | 42 | // Get perms
 | 
  
    | 43 | $results = $database->query("SELECT admin_groups,admin_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
 | 
  
    | 44 | $results_array = $results->fetchRow();
 | 
  
    | 45 | 
 | 
  
    | 46 | // Find out more about the page
 | 
  
    | 47 | $query = "SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'";
 | 
  
    | 48 | $results = $database->query($query);
 | 
  
    | 49 | if($database->is_error()) {
 | 
  
    | 50 | 	$admin->print_error($database->get_error());
 | 
  
    | 51 | }
 | 
  
    | 52 | if($results->numRows() == 0) {
 | 
  
    | 53 | 	$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
 | 
  
    | 54 | }
 | 
  
    | 55 | $results_array = $results->fetchRow();
 | 
  
    | 56 | $old_admin_groups = explode(',', str_replace('_', '', $results_array['admin_groups']));
 | 
  
    | 57 | $old_admin_users = explode(',', str_replace('_', '', $results_array['admin_users']));
 | 
  
    | 58 | if(!is_numeric(array_search($admin->get_group_id(), $old_admin_groups)) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users))) {
 | 
  
    | 59 | 	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
 | 
  
    | 60 | }
 | 
  
    | 61 | 
 | 
  
    | 62 | $visibility = $results_array['visibility'];
 | 
  
    | 63 | 
 | 
  
    | 64 | // Check if we should delete it or just set the visibility to 'deleted'
 | 
  
    | 65 | if(PAGE_TRASH != 'disabled' AND $visibility != 'deleted') {
 | 
  
    | 66 | 	// Page trash is enabled and page has not yet been deleted
 | 
  
    | 67 | 	// Function to change all child pages visibility to deleted
 | 
  
    | 68 | 	function trash_subs($parent = 0) {
 | 
  
    | 69 | 		global $database;
 | 
  
    | 70 | 		// Query pages
 | 
  
    | 71 | 		$query_menu = $database->query("SELECT page_id FROM ".TABLE_PREFIX."pages WHERE parent = '$parent' ORDER BY position ASC");
 | 
  
    | 72 | 		// Check if there are any pages to show
 | 
  
    | 73 | 		if($query_menu->numRows() > 0) {
 | 
  
    | 74 | 			// Loop through pages
 | 
  
    | 75 | 			while($page = $query_menu->fetchRow()) {
 | 
  
    | 76 | 				// Update the page visibility to 'deleted'
 | 
  
    | 77 | 				$database->query("UPDATE ".TABLE_PREFIX."pages SET visibility = 'deleted' WHERE page_id = '".$page['page_id']."' LIMIT 1");
 | 
  
    | 78 | 				// Run this function again for all sub-pages
 | 
  
    | 79 | 				trash_subs($page['page_id']);
 | 
  
    | 80 | 			}
 | 
  
    | 81 | 		}
 | 
  
    | 82 | 	}
 | 
  
    | 83 | 	
 | 
  
    | 84 | 	// Update the page visibility to 'deleted'
 | 
  
    | 85 | 	$database->query("UPDATE ".TABLE_PREFIX."pages SET visibility = 'deleted' WHERE page_id = '$page_id.' LIMIT 1");
 | 
  
    | 86 | 	
 | 
  
    | 87 | 	// Run trash subs for this page
 | 
  
    | 88 | 	trash_subs($page_id);
 | 
  
    | 89 | } else {
 | 
  
    | 90 | 	// Really dump the page
 | 
  
    | 91 | 	// Delete page subs
 | 
  
    | 92 | 	$sub_pages = get_subs($page_id, array());
 | 
  
    | 93 | 	foreach($sub_pages AS $sub_page_id) {
 | 
  
    | 94 | 		delete_page($sub_page_id);
 | 
  
    | 95 | 	}
 | 
  
    | 96 | 	// Delete page
 | 
  
    | 97 | 	delete_page($page_id);
 | 
  
    | 98 | }	
 | 
  
    | 99 | 
 | 
  
    | 100 | // Check if there is a db error, otherwise say successful
 | 
  
    | 101 | if($database->is_error()) {
 | 
  
    | 102 | 	$admin->print_error($database->get_error());
 | 
  
    | 103 | } else {
 | 
  
    | 104 | 	$admin->print_success($MESSAGE['PAGES']['DELETED']);
 | 
  
    | 105 | }
 | 
  
    | 106 | 
 | 
  
    | 107 | // Print admin footer
 | 
  
    | 108 | $admin->print_footer();
 | 
  
    | 109 | 
 | 
  
    | 110 | ?>
 |