Project

General

Profile

1 1224 Luisehahne
<?php
2
/**
3
 *
4 1269 Luisehahne
 * @category        backend
5
 * @package         modules
6
 * @author          WebsiteBaker Project
7
 * @copyright       2004-2009, Ryan Djurovich
8 1349 Luisehahne
 * @copyright       2009-2011, Website Baker Org. e.V.
9 1269 Luisehahne
 * @link			http://www.websitebaker2.org/
10
 * @license         http://www.gnu.org/licenses/gpl.html
11
 * @platform        WebsiteBaker 2.8.x
12 1349 Luisehahne
 * @requirements    PHP 5.2.2 and higher
13 1269 Luisehahne
 * @version         $Id$
14 1270 Luisehahne
 * @filesource		$HeadURL$
15
 * @lastmodified    $Date$
16 1224 Luisehahne
 *
17 1334 Luisehahne
 */
18 1224 Luisehahne
19
// Stop this file being access directly
20
if(!defined('WB_URL')) {
21
	header('Location: ../index.php');
22
	exit(0);
23
}
24
25
// Get page id
26 1334 Luisehahne
if(isset($_GET['page_id']) && is_numeric($_GET['page_id']))
27
{
28 1224 Luisehahne
	$page_id = $_GET['page_id'];
29 1334 Luisehahne
} elseif(isset($_POST['page_id']) && is_numeric($_POST['page_id']))
30
{
31 1224 Luisehahne
	$page_id = $_POST['page_id'];
32
} else {
33
	header("Location: index.php");
34
	exit(0);
35
}
36
37
// Get section id if there is one
38 1334 Luisehahne
if(isset($_GET['section_id']) && is_numeric($_GET['section_id']))
39
{
40 1224 Luisehahne
	$section_id = $_GET['section_id'];
41 1334 Luisehahne
} elseif(isset($_POST['section_id']) && is_numeric($_POST['section_id']))
42
{
43 1224 Luisehahne
	$section_id = $_POST['section_id'];
44
} else {
45
	// Check if we should redirect the user if there is no section id
46 1353 FrankH
	if (isset($no_section_required))
47 1334 Luisehahne
	{
48 1224 Luisehahne
		$section_id = 0;
49
	} else {
50
		header("Location: $section_required");
51
		exit(0);
52
	}
53
}
54
55
// Create js back link
56
$js_back = 'javascript: history.go(-1);';
57
58
// Create new admin object
59 1334 Luisehahne
include(WB_PATH.'/framework/class.admin.php');
60
// header will be set here, see database->is_error
61 1224 Luisehahne
$admin = new admin('Pages', 'pages_modify');
62
63
// Get perms
64 1334 Luisehahne
// $database = new database();
65
$sql  = 'SELECT `admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` ';
66
$sql .= 'WHERE `page_id` = '.intval($page_id);
67 1224 Luisehahne
68 1334 Luisehahne
$res_pages = $database->query($sql);
69
$rec_pages = $res_pages->fetchRow();
70
71
$old_admin_groups = explode(',', str_replace('_', '', $rec_pages['admin_groups']));
72
$old_admin_users  = explode(',', str_replace('_', '', $rec_pages['admin_users']));
73
74 1224 Luisehahne
$in_group = FALSE;
75 1334 Luisehahne
foreach($admin->get_groups_id() as $cur_gid)
76
{
77
    if (in_array($cur_gid, $old_admin_groups))
78
	{
79 1224 Luisehahne
        $in_group = TRUE;
80
    }
81
}
82 1334 Luisehahne
if((!$in_group) && !is_numeric(array_search($admin->get_user_id(), $old_admin_users)))
83
{
84 1224 Luisehahne
	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
85
}
86
87 1353 FrankH
// Check whether the section_id belongs to the page_id at all
88
if ($section_id != 0) {
89
	$sql  = "SELECT `position` FROM `".TABLE_PREFIX."sections` WHERE `page_id` = '$page_id' AND `section_id` = '$section_id'";
90
	$res_sec = $database->query($sql);
91
	if ($database->is_error())
92
	{
93
		$admin->print_error($database->get_error());
94
	}
95
	if ($res_sec->numRows() == 0)
96
	{
97
		$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
98
	}
99
}
100
101 1224 Luisehahne
// Workout if the developer wants to show the info banner
102 1334 Luisehahne
if(isset($print_info_banner) && $print_info_banner == true)
103
{
104
	// Get page details
105
	// $database = new database(); not needed
106
	$sql  = 'SELECT `page_id`,`page_title`,`modified_by`,`modified_when` FROM `'.TABLE_PREFIX.'pages` ';
107
	$sql .= 'WHERE `page_id` = '.intval($page_id);
108
	$res_pages = $database->query($sql);
109
	if($database->is_error())
110
	{
111
		// $admin->print_header();  don't know why
112
		$admin->print_error($database->get_error());
113
	}
114 1335 Luisehahne
	if($res_pages->numRows() == 0)
115 1334 Luisehahne
	{
116
		// $admin->print_header();   don't know why
117
		$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
118
	} else {
119 1335 Luisehahne
		$rec_pages = $res_pages->fetchRow();
120 1334 Luisehahne
	}
121 1224 Luisehahne
122 1334 Luisehahne
	// Get display name of person who last modified the page
123 1335 Luisehahne
	$user = $admin->get_user_details($rec_pages['modified_by']);
124 1224 Luisehahne
125 1334 Luisehahne
	// Convert the unix ts for modified_when to human a readable form
126 1335 Luisehahne
	if($rec_pages['modified_when'] != 0)
127 1334 Luisehahne
	{
128 1335 Luisehahne
		$modified_ts = gmdate(TIME_FORMAT.', '.DATE_FORMAT, $rec_pages['modified_when']+TIMEZONE);
129 1334 Luisehahne
	} else {
130
		$modified_ts = 'Unknown';
131
	}
132 1224 Luisehahne
133 1334 Luisehahne
	// Include page info script
134
	$template = new Template(THEME_PATH.'/templates');
135
	$template->set_file('page', 'pages_modify.htt');
136
	$template->set_block('page', 'main_block', 'main');
137
	$template->set_var(array(
138 1335 Luisehahne
				'PAGE_ID' => $rec_pages['page_id'],
139
				'PAGE_TITLE' => ($rec_pages['page_title']),
140 1334 Luisehahne
				'MODIFIED_BY' => $user['display_name'],
141
				'MODIFIED_BY_USERNAME' => $user['username'],
142
				'MODIFIED_WHEN' => $modified_ts,
143
				'ADMIN_URL' => ADMIN_URL
144
				));
145 1224 Luisehahne
146 1335 Luisehahne
	$template->set_block('main_block', 'show_modify_block', 'show_modify');
147 1334 Luisehahne
	if($modified_ts == 'Unknown')
148
	{
149 1335 Luisehahne
    	$template->set_block('show_modify', '');
150 1334 Luisehahne
		$template->set_var('CLASS_DISPLAY_MODIFIED', 'hide');
151
	} else {
152
		$template->set_var('CLASS_DISPLAY_MODIFIED', '');
153 1335 Luisehahne
    	$template->parse('show_modify', 'show_modify_block', true);
154 1334 Luisehahne
	}
155 1224 Luisehahne
156 1335 Luisehahne
	$template->set_block('main_block', 'show_section_block', 'show_section');
157 1334 Luisehahne
	// Work-out if we should show the "manage sections" link
158
    $sql  = 'SELECT `section_id` FROM `'.TABLE_PREFIX.'sections` ';
159
	$sql .= 'WHERE `page_id` = '.intval($page_id).' AND `module` = "menu_link"';
160
	if( ( $res_sections = $database->query($sql) ) && ($database->is_error() == false ) )
161
	{
162
		if($res_sections->numRows() > 0)
163
		{
164 1335 Luisehahne
			$template->set_block('show_section', '');
165 1334 Luisehahne
			$template->set_var('DISPLAY_MANAGE_SECTIONS', 'none');
166
		}elseif(MANAGE_SECTIONS == 'enabled')
167
		{
168
			$template->set_var('TEXT_MANAGE_SECTIONS', $HEADING['MANAGE_SECTIONS']);
169 1335 Luisehahne
    		$template->parse('show_section', 'show_section_block', true);
170 1334 Luisehahne
		}else {
171 1335 Luisehahne
			$template->set_block('show_section', '');
172 1334 Luisehahne
			$template->set_var('DISPLAY_MANAGE_SECTIONS', 'none');
173
		}
174
	} else {
175
		$admin->print_error($database->get_error());
176
	}
177 1224 Luisehahne
178 1334 Luisehahne
	// Insert language TEXT
179
	$template->set_var(array(
180
				'TEXT_CURRENT_PAGE' => $TEXT['CURRENT_PAGE'],
181
				'TEXT_CHANGE' => $TEXT['CHANGE'],
182
				'LAST_MODIFIED' => $MESSAGE['PAGES']['LAST_MODIFIED'],
183
				'TEXT_CHANGE_SETTINGS' => $TEXT['CHANGE_SETTINGS'],
184
				'HEADING_MODIFY_PAGE' => $HEADING['MODIFY_PAGE']
185
				));
186 1224 Luisehahne
187 1334 Luisehahne
	// Parse and print header template
188
	$template->parse('main', 'main_block', false);
189
	$template->pparse('output', 'page');
190 1224 Luisehahne
}
191
192
// Work-out if the developer wants us to update the timestamp for when the page was last modified
193 1334 Luisehahne
if(isset($update_when_modified) && $update_when_modified == true)
194
{
195
	$sql  = 'UPDATE `'.TABLE_PREFIX.'pages` ';
196
	$sql .= 'SET `modified_when` = '.time().', ';
197
	$sql .=     '`modified_by`   = '.intval($admin->get_user_id()).' ';
198
	$sql .=     'WHERE page_id   = '.intval($page_id);
199
	$database->query($sql);
200 1224 Luisehahne
}
201
202 4 ryan
?>