Project

General

Profile

1 238 stefan
<?php
2
3
// $Id$
4
5
/*
6
7
 Website Baker Project <http://www.websitebaker.org/>
8 519 Ruebenwurz
 Copyright (C) 2004-2008, Ryan Djurovich
9 238 stefan
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 4 ryan
// Include config file
27 238 stefan
require('../../config.php');
28
29 4 ryan
// Make sure people are allowed to access this page
30 238 stefan
if(MANAGE_SECTIONS != 'enabled') {
31
	header('Location: '.ADMIN_URL.'/pages/index.php');
32 286 stefan
	exit(0);
33 238 stefan
}
34
35 4 ryan
// Get page id
36 238 stefan
if(!isset($_GET['page_id']) OR !is_numeric($_GET['page_id'])) {
37
	header("Location: index.php");
38 286 stefan
	exit(0);
39 238 stefan
} else {
40
	$page_id = $_GET['page_id'];
41
}
42
43 4 ryan
// Create new admin object
44 238 stefan
require_once(WB_PATH.'/framework/class.admin.php');
45
$admin = new admin('Pages', 'pages_modify');
46
47 4 ryan
// Get perms
48 238 stefan
$database = new database();
49
$results = $database->query("SELECT admin_groups,admin_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
50
$results_array = $results->fetchRow();
51
$old_admin_groups = explode(',', $results_array['admin_groups']);
52
$old_admin_users = explode(',', $results_array['admin_users']);
53 546 doc
$in_old_group = FALSE;
54
foreach($admin->get_groups_id() as $cur_gid){
55
    if (in_array($cur_gid, $old_admin_groups)) {
56
        $in_old_group = TRUE;
57
    }
58
}
59
if((!$in_old_group) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users))) {
60 238 stefan
	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
61
}
62
63 4 ryan
// Get page details
64 238 stefan
$database = new database();
65
$query = "SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'";
66
$results = $database->query($query);
67
if($database->is_error()) {
68
	$admin->print_header();
69
	$admin->print_error($database->get_error());
70
}
71
if($results->numRows() == 0) {
72
	$admin->print_header();
73
	$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
74
}
75
$results_array = $results->fetchRow();
76
77 4 ryan
// Set module permissions
78 238 stefan
$module_permissions = $_SESSION['MODULE_PERMISSIONS'];
79
80 4 ryan
// Loop through sections
81 238 stefan
$query_sections = $database->query("SELECT section_id,module,position FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' ORDER BY position ASC");
82
if($query_sections->numRows() > 0) {
83
	$num_sections = $query_sections->numRows();
84
	while($section = $query_sections->fetchRow()) {
85 347 stefan
		if(!is_numeric(array_search($section['module'], $module_permissions))) {
86
			// Update the section record with properties
87
			$section_id = $section['section_id'];
88 552 thorn
			$sql = ''; $publ_start = 0; $publ_end = 0;
89
			$dst = date("I")?" DST":""; // daylight saving time?
90 347 stefan
			if(isset($_POST['block'.$section_id]) AND $_POST['block'.$section_id] != '') {
91
				$sql = "block = '".$admin->add_slashes($_POST['block'.$section_id])."'";
92 552 thorn
			}
93
			// update publ_start and publ_end, trying to make use of the strtotime()-features like "next week", "+1 month", ...
94
			if(isset($_POST['start_date'.$section_id]) AND isset($_POST['end_date'.$section_id])) {
95
				if(trim($_POST['start_date'.$section_id]) == '0' OR trim($_POST['start_date'.$section_id]) == '') {
96
					$publ_start = 0;
97
				} else {
98
					$publ_start = strtotime($_POST['start_date'.$section_id]);
99 238 stefan
				}
100 552 thorn
				if(trim($_POST['end_date'.$section_id]) == '0' OR trim($_POST['end_date'.$section_id]) == '') {
101
					$publ_end = 0;
102
				} else {
103
					$publ_end = strtotime($_POST['end_date'.$section_id], $publ_start);
104
				}
105
				if($sql != '')
106
					$sql .= ",";
107
				$sql .= " publ_start = '".$publ_start."'";
108
				$sql .= ", publ_end = '".$publ_end."'";
109 238 stefan
			}
110 552 thorn
			$query = "UPDATE ".TABLE_PREFIX."sections SET $sql WHERE section_id = '$section_id' LIMIT 1";
111
			if($sql != '') {
112
				$database->query($query);
113
			}
114 238 stefan
		}
115
	}
116
}
117
// Check for error or print success message
118 4 ryan
if($database->is_error()) {
119
	$admin->print_error($database->get_error(), ADMIN_URL.'/pages/sections.php?page_id='.$page_id);
120
} else {
121
	$admin->print_success($MESSAGE['PAGES']['SECTIONS_PROPERTIES_SAVED'], ADMIN_URL.'/pages/sections.php?page_id='.$page_id);
122
}
123 238 stefan
124 4 ryan
// Print admin footer
125 238 stefan
$admin->print_footer();
126
127 552 thorn
?>