| 1 | 
        
            4
         | 
        
            ryan
         | 
        <?php
  | 
      
      
        | 2 | 
        
         | 
        
         | 
        
  | 
      
      
        | 3 | 
        
            40
         | 
        
            stefan
         | 
        // $Id$
  | 
      
      
        | 4 | 
        
            4
         | 
        
            ryan
         | 
        
  | 
      
      
        | 5 | 
        
         | 
        
         | 
        /*
  | 
      
      
        | 6 | 
        
         | 
        
         | 
        
  | 
      
      
        | 7 | 
        
         | 
        
         | 
         Website Baker Project <http://www.websitebaker.org/>
  | 
      
      
        | 8 | 
        
            915
         | 
        
            Ruebenwurz
         | 
         Copyright (C) 2004-2009, Ryan Djurovich
  | 
      
      
        | 9 | 
        
            4
         | 
        
            ryan
         | 
        
  | 
      
      
        | 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($_POST['page_id']) OR !is_numeric($_POST['page_id'])) {
 | 
      
      
        | 28 | 
        
         | 
        
         | 
        	header("Location: index.php");
 | 
      
      
        | 29 | 
        
            286
         | 
        
            stefan
         | 
        	exit(0);
  | 
      
      
        | 30 | 
        
            4
         | 
        
            ryan
         | 
        } else {
 | 
      
      
        | 31 | 
        
         | 
        
         | 
        	$page_id = $_POST['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_settings');
 | 
      
      
        | 38 | 
        
         | 
        
         | 
        
  | 
      
      
        | 39 | 
        
         | 
        
         | 
        // Include the WB functions file
  | 
      
      
        | 40 | 
        
         | 
        
         | 
        require_once(WB_PATH.'/framework/functions.php');
  | 
      
      
        | 41 | 
        
         | 
        
         | 
        
  | 
      
      
        | 42 | 
        
         | 
        
         | 
        // Get values
  | 
      
      
        | 43 | 
        
            488
         | 
        
            Ruebenwurz
         | 
        $page_title = $admin->get_post_escaped('page_title');
 | 
      
      
        | 44 | 
        
            656
         | 
        
            thorn
         | 
        $page_title = htmlspecialchars($page_title);
  | 
      
      
        | 45 | 
        
            488
         | 
        
            Ruebenwurz
         | 
        $menu_title = $admin->get_post_escaped('menu_title');
 | 
      
      
        | 46 | 
        
            656
         | 
        
            thorn
         | 
        $menu_title = htmlspecialchars($menu_title);
  | 
      
      
        | 47 | 
        
         | 
        
         | 
        $description = htmlspecialchars($admin->add_slashes($admin->get_post('description')));
 | 
      
      
        | 48 | 
        
         | 
        
         | 
        $keywords = htmlspecialchars($admin->add_slashes($admin->get_post('keywords')));
 | 
      
      
        | 49 | 
        
         | 
        
         | 
        $parent = $admin->get_post_escaped('parent');
 | 
      
      
        | 50 | 
        
         | 
        
         | 
        $visibility = $admin->get_post_escaped('visibility');
 | 
      
      
        | 51 | 
        
         | 
        
         | 
        $template = $admin->get_post_escaped('template');
 | 
      
      
        | 52 | 
        
         | 
        
         | 
        $target = $admin->get_post_escaped('target');
 | 
      
      
        | 53 | 
        
         | 
        
         | 
        $admin_groups = $admin->get_post_escaped('admin_groups');
 | 
      
      
        | 54 | 
        
         | 
        
         | 
        $viewing_groups = $admin->get_post_escaped('viewing_groups');
 | 
      
      
        | 55 | 
        
         | 
        
         | 
        $searching = $admin->get_post_escaped('searching');
 | 
      
      
        | 56 | 
        
         | 
        
         | 
        $language = $admin->get_post_escaped('language');
 | 
      
      
        | 57 | 
        
         | 
        
         | 
        $menu = $admin->get_post_escaped('menu');
 | 
      
      
        | 58 | 
        
            4
         | 
        
            ryan
         | 
        
  | 
      
      
        | 59 | 
        
         | 
        
         | 
        // Validate data
  | 
      
      
        | 60 | 
        
            430
         | 
        
            Ruebenwurz
         | 
        if($page_title == '' || substr($page_title,0,1)=='.') {
 | 
      
      
        | 61 | 
        
            4
         | 
        
            ryan
         | 
        	$admin->print_error($MESSAGE['PAGES']['BLANK_PAGE_TITLE']);
  | 
      
      
        | 62 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 63 | 
        
            428
         | 
        
            Ruebenwurz
         | 
        if($menu_title == '' || substr($menu_title,0,1)=='.') {
 | 
      
      
        | 64 | 
        
            4
         | 
        
            ryan
         | 
        	$admin->print_error($MESSAGE['PAGES']['BLANK_MENU_TITLE']);
  | 
      
      
        | 65 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 66 | 
        
         | 
        
         | 
        
  | 
      
      
        | 67 | 
        
         | 
        
         | 
        // Get existing perms
  | 
      
      
        | 68 | 
        
         | 
        
         | 
        $database = new database();
  | 
      
      
        | 69 | 
        
         | 
        
         | 
        $results = $database->query("SELECT parent,link,position,admin_groups,admin_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
 | 
      
      
        | 70 | 
        
         | 
        
         | 
        $results_array = $results->fetchRow();
  | 
      
      
        | 71 | 
        
         | 
        
         | 
        $old_parent = $results_array['parent'];
  | 
      
      
        | 72 | 
        
         | 
        
         | 
        $old_link = $results_array['link'];
  | 
      
      
        | 73 | 
        
         | 
        
         | 
        $old_position = $results_array['position'];
  | 
      
      
        | 74 | 
        
         | 
        
         | 
        $old_admin_groups = explode(',', str_replace('_', '', $results_array['admin_groups']));
 | 
      
      
        | 75 | 
        
         | 
        
         | 
        $old_admin_users = explode(',', str_replace('_', '', $results_array['admin_users']));
 | 
      
      
        | 76 | 
        
            546
         | 
        
            doc
         | 
        
  | 
      
      
        | 77 | 
        
         | 
        
         | 
        $in_old_group = FALSE;
  | 
      
      
        | 78 | 
        
         | 
        
         | 
        foreach($admin->get_groups_id() as $cur_gid){
 | 
      
      
        | 79 | 
        
         | 
        
         | 
            if (in_array($cur_gid, $old_admin_groups)) {
 | 
      
      
        | 80 | 
        
         | 
        
         | 
        	$in_old_group = TRUE;
  | 
      
      
        | 81 | 
        
         | 
        
         | 
            }
  | 
      
      
        | 82 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 83 | 
        
         | 
        
         | 
        if((!$in_old_group) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users))) {
 | 
      
      
        | 84 | 
        
            4
         | 
        
            ryan
         | 
        	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
  | 
      
      
        | 85 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 86 | 
        
         | 
        
         | 
        
  | 
      
      
        | 87 | 
        
         | 
        
         | 
        // Setup admin groups
  | 
      
      
        | 88 | 
        
         | 
        
         | 
        $admin_groups[] = 1;
  | 
      
      
        | 89 | 
        
            733
         | 
        
            thorn
         | 
        //if(!in_array(1, $admin->get_groups_id())) {
 | 
      
      
        | 90 | 
        
         | 
        
         | 
        //	$admin_groups[] = implode(",",$admin->get_groups_id());
 | 
      
      
        | 91 | 
        
         | 
        
         | 
        //}
  | 
      
      
        | 92 | 
        
            4
         | 
        
            ryan
         | 
        $admin_groups = implode(',', $admin_groups);
 | 
      
      
        | 93 | 
        
         | 
        
         | 
        // Setup viewing groups
  | 
      
      
        | 94 | 
        
         | 
        
         | 
        $viewing_groups[] = 1;
  | 
      
      
        | 95 | 
        
            733
         | 
        
            thorn
         | 
        //if(!in_array(1, $admin->get_groups_id())) {
 | 
      
      
        | 96 | 
        
         | 
        
         | 
        //	$viewing_groups[] = implode(",",$admin->get_groups_id());
 | 
      
      
        | 97 | 
        
         | 
        
         | 
        //}
  | 
      
      
        | 98 | 
        
            4
         | 
        
            ryan
         | 
        $viewing_groups = implode(',', $viewing_groups);
 | 
      
      
        | 99 | 
        
         | 
        
         | 
        
  | 
      
      
        | 100 | 
        
         | 
        
         | 
        // If needed, get new order
  | 
      
      
        | 101 | 
        
         | 
        
         | 
        if($parent != $old_parent) {
 | 
      
      
        | 102 | 
        
         | 
        
         | 
        	// Include ordering class
  | 
      
      
        | 103 | 
        
         | 
        
         | 
        	require(WB_PATH.'/framework/class.order.php');
  | 
      
      
        | 104 | 
        
         | 
        
         | 
        	$order = new order(TABLE_PREFIX.'pages', 'position', 'page_id', 'parent');
  | 
      
      
        | 105 | 
        
         | 
        
         | 
        	// Get new order
  | 
      
      
        | 106 | 
        
         | 
        
         | 
        	$position = $order->get_new($parent);
  | 
      
      
        | 107 | 
        
         | 
        
         | 
        	// Clean new order
  | 
      
      
        | 108 | 
        
         | 
        
         | 
        	$order->clean($parent);
  | 
      
      
        | 109 | 
        
         | 
        
         | 
        } else {
 | 
      
      
        | 110 | 
        
         | 
        
         | 
        	$position = $old_position;
  | 
      
      
        | 111 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 112 | 
        
         | 
        
         | 
        
  | 
      
      
        | 113 | 
        
         | 
        
         | 
        // Work out level and root parent
  | 
      
      
        | 114 | 
        
         | 
        
         | 
        if ($parent!='0') {
 | 
      
      
        | 115 | 
        
         | 
        
         | 
        	$level = level_count($parent)+1;
  | 
      
      
        | 116 | 
        
         | 
        
         | 
        	$root_parent = root_parent($parent);
  | 
      
      
        | 117 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 118 | 
        
         | 
        
         | 
        else {
 | 
      
      
        | 119 | 
        
         | 
        
         | 
        	$level = '0';
  | 
      
      
        | 120 | 
        
         | 
        
         | 
        	$root_parent = '0';
  | 
      
      
        | 121 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 122 | 
        
         | 
        
         | 
        
  | 
      
      
        | 123 | 
        
         | 
        
         | 
        // Work-out what the link should be
  | 
      
      
        | 124 | 
        
         | 
        
         | 
        if($parent == '0') {
 | 
      
      
        | 125 | 
        
            830
         | 
        
            thorn
         | 
        	$link = '/'.page_filename($menu_title);
  | 
      
      
        | 126 | 
        
            831
         | 
        
            doc
         | 
        	// rename menu titles: index && intro to prevent clashes with intro page feature and WB core file /pages/index.php
  | 
      
      
        | 127 | 
        
         | 
        
         | 
        	if($link == '/index' || $link == '/intro') {
 | 
      
      
        | 128 | 
        
         | 
        
         | 
        		$link .= '_' .$page_id;
  | 
      
      
        | 129 | 
        
         | 
        
         | 
        		$filename = WB_PATH.PAGES_DIRECTORY.'/'.page_filename($menu_title).'_'.$page_id .PAGE_EXTENSION;
  | 
      
      
        | 130 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 131 | 
        
         | 
        
         | 
        		$filename = WB_PATH.PAGES_DIRECTORY.'/'.page_filename($menu_title).PAGE_EXTENSION;
  | 
      
      
        | 132 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 133 | 
        
            4
         | 
        
            ryan
         | 
        } else {
 | 
      
      
        | 134 | 
        
         | 
        
         | 
        	$parent_section = '';
  | 
      
      
        | 135 | 
        
         | 
        
         | 
        	$parent_titles = array_reverse(get_parent_titles($parent));
  | 
      
      
        | 136 | 
        
         | 
        
         | 
        	foreach($parent_titles AS $parent_title) {
 | 
      
      
        | 137 | 
        
         | 
        
         | 
        		$parent_section .= page_filename($parent_title).'/';
  | 
      
      
        | 138 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 139 | 
        
         | 
        
         | 
        	if($parent_section == '/') { $parent_section = ''; }
 | 
      
      
        | 140 | 
        
            830
         | 
        
            thorn
         | 
        	$link = '/'.$parent_section.page_filename($menu_title);
  | 
      
      
        | 141 | 
        
         | 
        
         | 
        	$filename = WB_PATH.PAGES_DIRECTORY.'/'.$parent_section.page_filename($menu_title).PAGE_EXTENSION;
  | 
      
      
        | 142 | 
        
            4
         | 
        
            ryan
         | 
        }
  | 
      
      
        | 143 | 
        
         | 
        
         | 
        
  | 
      
      
        | 144 | 
        
         | 
        
         | 
        // Check if a page with same page filename exists
  | 
      
      
        | 145 | 
        
         | 
        
         | 
        $database = new database();
  | 
      
      
        | 146 | 
        
         | 
        
         | 
        $get_same_page = $database->query("SELECT page_id,page_title FROM ".TABLE_PREFIX."pages WHERE link = '$link' and page_id != '$page_id'");
 | 
      
      
        | 147 | 
        
         | 
        
         | 
        if($get_same_page->numRows() > 0) {
 | 
      
      
        | 148 | 
        
         | 
        
         | 
        	$admin->print_error($MESSAGE['PAGES']['PAGE_EXISTS']);
  | 
      
      
        | 149 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 150 | 
        
         | 
        
         | 
        
  | 
      
      
        | 151 | 
        
         | 
        
         | 
        // Update page with new order
  | 
      
      
        | 152 | 
        
         | 
        
         | 
        $query = "UPDATE ".TABLE_PREFIX."pages SET parent = '$parent', position = '$position' WHERE page_id = '$page_id'";
  | 
      
      
        | 153 | 
        
         | 
        
         | 
        $database = new database();
  | 
      
      
        | 154 | 
        
         | 
        
         | 
        $database->query($query);
  | 
      
      
        | 155 | 
        
         | 
        
         | 
        
  | 
      
      
        | 156 | 
        
         | 
        
         | 
        // Get page trail
  | 
      
      
        | 157 | 
        
         | 
        
         | 
        $page_trail = get_page_trail($page_id);
  | 
      
      
        | 158 | 
        
         | 
        
         | 
        
  | 
      
      
        | 159 | 
        
         | 
        
         | 
        // Update page settings in the pages table
  | 
      
      
        | 160 | 
        
         | 
        
         | 
        $query = "UPDATE ".TABLE_PREFIX."pages SET parent = '$parent', page_title = '$page_title', menu_title = '$menu_title', menu = '$menu', level = '$level', page_trail = '$page_trail', root_parent = '$root_parent', link = '$link', template = '$template', target = '$target', description = '$description', keywords = '$keywords', position = '$position', visibility = '$visibility', searching = '$searching', language = '$language', admin_groups = '$admin_groups', viewing_groups = '$viewing_groups' WHERE page_id = '$page_id'";
  | 
      
      
        | 161 | 
        
         | 
        
         | 
        $database->query($query);
  | 
      
      
        | 162 | 
        
         | 
        
         | 
        
  | 
      
      
        | 163 | 
        
         | 
        
         | 
        // Clean old order if needed
  | 
      
      
        | 164 | 
        
         | 
        
         | 
        if($parent != $old_parent) {
 | 
      
      
        | 165 | 
        
         | 
        
         | 
        	$order->clean($old_parent);
  | 
      
      
        | 166 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 167 | 
        
         | 
        
         | 
        
  | 
      
      
        | 168 | 
        
         | 
        
         | 
        /* BEGIN page "access file" code */
  | 
      
      
        | 169 | 
        
         | 
        
         | 
        
  | 
      
      
        | 170 | 
        
         | 
        
         | 
        // Create a new file in the /pages dir if title changed
  | 
      
      
        | 171 | 
        
         | 
        
         | 
        if(!is_writable(WB_PATH.PAGES_DIRECTORY.'/')) {
 | 
      
      
        | 172 | 
        
         | 
        
         | 
        	$admin->print_error($MESSAGE['PAGES']['CANNOT_CREATE_ACCESS_FILE']);
  | 
      
      
        | 173 | 
        
         | 
        
         | 
        } else {
 | 
      
      
        | 174 | 
        
         | 
        
         | 
        	// First check if we need to create a new file
  | 
      
      
        | 175 | 
        
         | 
        
         | 
        	if($old_link != $link) {
 | 
      
      
        | 176 | 
        
         | 
        
         | 
        		// Delete old file
  | 
      
      
        | 177 | 
        
            555
         | 
        
            Ruebenwurz
         | 
        		$old_filename = WB_PATH.PAGES_DIRECTORY.$old_link.PAGE_EXTENSION;
  | 
      
      
        | 178 | 
        
            497
         | 
        
            ryan
         | 
        		if(file_exists($old_filename)) {
 | 
      
      
        | 179 | 
        
         | 
        
         | 
        			unlink($old_filename);
  | 
      
      
        | 180 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 181 | 
        
            4
         | 
        
            ryan
         | 
        		// Create access file
  | 
      
      
        | 182 | 
        
         | 
        
         | 
        		create_access_file($filename,$page_id,$level);
  | 
      
      
        | 183 | 
        
         | 
        
         | 
        		// Move a directory for this page
  | 
      
      
        | 184 | 
        
         | 
        
         | 
        		if(file_exists(WB_PATH.PAGES_DIRECTORY.$old_link.'/') AND is_dir(WB_PATH.PAGES_DIRECTORY.$old_link.'/')) {
 | 
      
      
        | 185 | 
        
         | 
        
         | 
        			rename(WB_PATH.PAGES_DIRECTORY.$old_link.'/', WB_PATH.PAGES_DIRECTORY.$link.'/');
  | 
      
      
        | 186 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 187 | 
        
         | 
        
         | 
        		// Update any pages that had the old link with the new one
  | 
      
      
        | 188 | 
        
         | 
        
         | 
        		$old_link_len = strlen($old_link);
  | 
      
      
        | 189 | 
        
            54
         | 
        
            stefan
         | 
        		$query_subs = $database->query("SELECT page_id,link,level FROM ".TABLE_PREFIX."pages WHERE link LIKE '%$old_link/%' ORDER BY LEVEL ASC");
 | 
      
      
        | 190 | 
        
            4
         | 
        
            ryan
         | 
        		if($query_subs->numRows() > 0) {
 | 
      
      
        | 191 | 
        
         | 
        
         | 
        			while($sub = $query_subs->fetchRow()) {
 | 
      
      
        | 192 | 
        
         | 
        
         | 
        				// Double-check to see if it contains old link
  | 
      
      
        | 193 | 
        
         | 
        
         | 
        				if(substr($sub['link'], 0, $old_link_len) == $old_link) {
 | 
      
      
        | 194 | 
        
         | 
        
         | 
        					// Get new link
  | 
      
      
        | 195 | 
        
         | 
        
         | 
        					$replace_this = $old_link;
  | 
      
      
        | 196 | 
        
            54
         | 
        
            stefan
         | 
        					$old_sub_link_len =strlen($sub['link']);
  | 
      
      
        | 197 | 
        
         | 
        
         | 
        					$new_sub_link = $link.'/'.substr($sub['link'],$old_link_len+1,$old_sub_link_len);
  | 
      
      
        | 198 | 
        
            4
         | 
        
            ryan
         | 
        					// Work out level
  | 
      
      
        | 199 | 
        
         | 
        
         | 
        					$new_sub_level = level_count($sub['page_id']);
  | 
      
      
        | 200 | 
        
            54
         | 
        
            stefan
         | 
        					// Update level and link
  | 
      
      
        | 201 | 
        
         | 
        
         | 
        					$database->query("UPDATE ".TABLE_PREFIX."pages SET link = '$new_sub_link', level = '$new_sub_level' WHERE page_id = '".$sub['page_id']."' LIMIT 1");
 | 
      
      
        | 202 | 
        
            4
         | 
        
            ryan
         | 
        					// Re-write the access file for this page
  | 
      
      
        | 203 | 
        
            555
         | 
        
            Ruebenwurz
         | 
        					$old_subpage_file = WB_PATH.PAGES_DIRECTORY.$new_sub_link.PAGE_EXTENSION;
  | 
      
      
        | 204 | 
        
            4
         | 
        
            ryan
         | 
        					if(file_exists($old_subpage_file)) {
 | 
      
      
        | 205 | 
        
         | 
        
         | 
        						unlink($old_subpage_file);
  | 
      
      
        | 206 | 
        
         | 
        
         | 
        					}
  | 
      
      
        | 207 | 
        
            555
         | 
        
            Ruebenwurz
         | 
        					create_access_file(WB_PATH.PAGES_DIRECTORY.$new_sub_link.PAGE_EXTENSION, $sub['page_id'], $new_sub_level);
  | 
      
      
        | 208 | 
        
            4
         | 
        
            ryan
         | 
        				}
  | 
      
      
        | 209 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 210 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 211 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 212 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 213 | 
        
         | 
        
         | 
        
  | 
      
      
        | 214 | 
        
         | 
        
         | 
        // Function to fix page trail of subs
  | 
      
      
        | 215 | 
        
            447
         | 
        
            Ruebenwurz
         | 
        function fix_page_trail($parent,$root_parent) {
 | 
      
      
        | 216 | 
        
            4
         | 
        
            ryan
         | 
        	// Get objects and vars from outside this function
  | 
      
      
        | 217 | 
        
         | 
        
         | 
        	global $admin, $template, $database, $TEXT, $MESSAGE;
  | 
      
      
        | 218 | 
        
         | 
        
         | 
        	// Get page list from database
  | 
      
      
        | 219 | 
        
         | 
        
         | 
        	$database = new database();
  | 
      
      
        | 220 | 
        
         | 
        
         | 
        	$query = "SELECT page_id FROM ".TABLE_PREFIX."pages WHERE parent = '$parent'";
  | 
      
      
        | 221 | 
        
         | 
        
         | 
        	$get_pages = $database->query($query);
  | 
      
      
        | 222 | 
        
         | 
        
         | 
        	// Insert values into main page list
  | 
      
      
        | 223 | 
        
         | 
        
         | 
        	if($get_pages->numRows() > 0)	{
 | 
      
      
        | 224 | 
        
         | 
        
         | 
        		while($page = $get_pages->fetchRow()) {
 | 
      
      
        | 225 | 
        
         | 
        
         | 
        			// Fix page trail
  | 
      
      
        | 226 | 
        
            447
         | 
        
            Ruebenwurz
         | 
        			$database->query("UPDATE ".TABLE_PREFIX."pages SET ".($root_parent != 0 ?"root_parent = '$root_parent', ":"")." page_trail = '".get_page_trail($page['page_id'])."' WHERE page_id = '".$page['page_id']."'");
 | 
      
      
        | 227 | 
        
            4
         | 
        
            ryan
         | 
        			// Run this query on subs
  | 
      
      
        | 228 | 
        
            447
         | 
        
            Ruebenwurz
         | 
        			fix_page_trail($page['page_id'],$root_parent);
  | 
      
      
        | 229 | 
        
            4
         | 
        
            ryan
         | 
        		}
  | 
      
      
        | 230 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 231 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 232 | 
        
         | 
        
         | 
        // Fix sub-pages page trail
  | 
      
      
        | 233 | 
        
            447
         | 
        
            Ruebenwurz
         | 
        fix_page_trail($page_id,$root_parent);
  | 
      
      
        | 234 | 
        
            4
         | 
        
            ryan
         | 
        
  | 
      
      
        | 235 | 
        
         | 
        
         | 
        /* END page "access file" code */
  | 
      
      
        | 236 | 
        
         | 
        
         | 
        
  | 
      
      
        | 237 | 
        
         | 
        
         | 
        // Check if there is a db error, otherwise say successful
  | 
      
      
        | 238 | 
        
         | 
        
         | 
        if($database->is_error()) {
 | 
      
      
        | 239 | 
        
         | 
        
         | 
        	$admin->print_error($database->get_error(), ADMIN_URL.'/pages/settings.php?page_id='.$page_id);
  | 
      
      
        | 240 | 
        
         | 
        
         | 
        } else {
 | 
      
      
        | 241 | 
        
         | 
        
         | 
        	$admin->print_success($MESSAGE['PAGES']['SAVED_SETTINGS'], ADMIN_URL.'/pages/index.php');
  | 
      
      
        | 242 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 243 | 
        
         | 
        
         | 
        
  | 
      
      
        | 244 | 
        
         | 
        
         | 
        // Print admin footer
  | 
      
      
        | 245 | 
        
         | 
        
         | 
        $admin->print_footer();
  | 
      
      
        | 246 | 
        
         | 
        
         | 
        
  | 
      
      
        | 247 | 
        
            543
         | 
        
            thorn
         | 
        ?>
  |