Project

General

Profile

1 1009 Ruebenwurz
<?php
2
3
// $Id$
4
5
/*
6
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2009, 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
// Include config file
27
require('../../config.php');
28
29
// Make sure people are allowed to access this page
30
if(MANAGE_SECTIONS != 'enabled') {
31
	header('Location: '.ADMIN_URL.'/pages/index.php');
32
	exit(0);
33
}
34
35
// Get page id
36
if(!isset($_GET['page_id']) OR !is_numeric($_GET['page_id'])) {
37
	header("Location: index.php");
38
	exit(0);
39
} else {
40
	$page_id = $_GET['page_id'];
41
}
42
43
$debug = false; // to show position and section_id
44
45
// Create new admin object
46
require_once(WB_PATH.'/framework/class.admin.php');
47
$admin = new admin('Pages', 'pages_modify');
48
49
// Check if we are supposed to add or delete a section
50
if(isset($_GET['section_id']) AND is_numeric($_GET['section_id'])) {
51
	// Get more information about this section
52
	$section_id = $_GET['section_id'];
53
	$query_section = $database->query("SELECT module FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id'");
54
	if($query_section->numRows() == 0) {
55
		$admin->print_error('Section not found');
56
	}
57
	$section = $query_section->fetchRow();
58
	// Include the modules delete file if it exists
59
	if(file_exists(WB_PATH.'/modules/'.$section['module'].'/delete.php')) {
60
		require(WB_PATH.'/modules/'.$section['module'].'/delete.php');
61
	}
62
	$database->query("DELETE FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id' LIMIT 1");
63
	if($database->is_error()) {
64
		$admin->print_error($database->get_error());
65
	} else {
66
		require(WB_PATH.'/framework/class.order.php');
67
		$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
68
		$order->clean($page_id);
69
		$admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/sections.php?page_id='.$page_id);
70
		$admin->print_footer();
71
		exit();
72
	}
73
} elseif(isset($_POST['module']) AND $_POST['module'] != '') {
74
	// Get section info
75
	$module = $admin->add_slashes($_POST['module']);
76
	// Include the ordering class
77
	require(WB_PATH.'/framework/class.order.php');
78
	// Get new order
79
	$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
80
	$position = $order->get_new($page_id);
81
	// Insert module into DB
82
	$database->query("INSERT INTO ".TABLE_PREFIX."sections (page_id,module,position,block) VALUES ('$page_id','$module','$position','1')");
83
	// Get the section id
84
	$section_id = $database->get_one("SELECT LAST_INSERT_ID()");
85
	// Include the selected modules add file if it exists
86
	if(file_exists(WB_PATH.'/modules/'.$module.'/add.php')) {
87
		require(WB_PATH.'/modules/'.$module.'/add.php');
88 1092 Ruebenwurz
	}
89 1009 Ruebenwurz
}
90
91
// Get perms
92
$database = new database();
93
$results = $database->query("SELECT admin_groups,admin_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
94
$results_array = $results->fetchRow();
95
$old_admin_groups = explode(',', $results_array['admin_groups']);
96
$old_admin_users = explode(',', $results_array['admin_users']);
97
$in_old_group = FALSE;
98
foreach($admin->get_groups_id() as $cur_gid){
99
	if (in_array($cur_gid, $old_admin_groups)) {
100
		$in_old_group = TRUE;
101
	}
102
}
103
if((!$in_old_group) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users))) {
104
	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
105
}
106
107
// Get page details
108
$database = new database();
109
$query = "SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'";
110
$results = $database->query($query);
111
if($database->is_error()) {
112
	$admin->print_header();
113
	$admin->print_error($database->get_error());
114
}
115
if($results->numRows() == 0) {
116
	$admin->print_header();
117
	$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
118
}
119
$results_array = $results->fetchRow();
120
121
// Set module permissions
122
$module_permissions = $_SESSION['MODULE_PERMISSIONS'];
123
124
// Unset block var
125
unset($block);
126
// Include template info file (if it exists)
127
if($results_array['template'] != '') {
128
	$template_location = WB_PATH.'/templates/'.$results_array['template'].'/info.php';
129
} else {
130
	$template_location = WB_PATH.'/templates/'.DEFAULT_TEMPLATE.'/info.php';
131
}
132
if(file_exists($template_location)) {
133
	require($template_location);
134
}
135
// Check if $menu is set
136
if(!isset($block[1]) OR $block[1] == '') {
137
	// Make our own menu list
138
	$block[1] = $TEXT['MAIN'];
139
}
140
141
/*-- load css files with jquery --*/
142
// include jscalendar-setup
143
$jscal_use_time = true; // whether to use a clock, too
144
require_once(WB_PATH."/include/jscalendar/wb-setup.php");
145
146
// Setup template object
147
$template = new Template(THEME_PATH.'/templates');
148
$template->set_file('page', 'pages_sections.htt');
149
$template->set_block('page', 'main_block', 'main');
150
$template->set_block('main_block', 'module_block', 'module_list');
151
$template->set_block('main_block', 'section_block', 'section_list');
152 1095 Ruebenwurz
$template->set_block('section_block', 'block_block', 'block_list');
153 1009 Ruebenwurz
$template->set_block('main_block', 'calendar_block', 'calendar_list');
154
155
// set first defaults and messages
156
$template->set_var(array(
157
				'PAGE_ID' => $results_array['page_id'],
158
				'PAGE_TITLE' => ($results_array['page_title']),
159
				'MENU_TITLE' => ($results_array['menu_title']),
160
				'TEXT_CURRENT_PAGE' => $TEXT['CURRENT_PAGE'],
161
				'HEADING_MANAGE_SECTIONS' => $HEADING['MANAGE_SECTIONS'],
162
				'HEADING_MODIFY_PAGE' => $HEADING['MODIFY_PAGE'],
163
				'TEXT_CHANGE_SETTINGS' => $TEXT['CHANGE_SETTINGS'],
164
				'TEXT_ADD_SECTION' => $TEXT['ADD_SECTION'],
165
				'TEXT_ID' => 'ID',
166
				'TEXT_TYPE' => $TEXT['TYPE'],
167
				'TEXT_BLOCK' => $TEXT['BLOCK'],
168
				'TEXT_PUBL_START_DATE' => $TEXT{'PUBL_START_DATE'},
169
				'TEXT_PUBL_END_DATE' => $TEXT['PUBL_END_DATE'],
170
				'TEXT_ACTIONS' => $TEXT['ACTIONS'],
171
				'ADMIN_URL' => ADMIN_URL,
172
				'WB_URL' => WB_URL,
173
				'WB_PATH' => WB_PATH,
174 1112 Ruebenwurz
				'THEME_URL' => THEME_URL
175
				)
176
		);
177 1009 Ruebenwurz
178
// Insert variables
179
$template->set_var(array(
180
				'VAR_PAGE_ID' => $results_array['page_id'],
181
				'VAR_PAGE_TITLE' => $results_array['page_title'],
182
				'SETTINGS_LINK' => ADMIN_URL.'/pages/settings.php?page_id='.$results_array['page_id'],
183
				'MODIFY_LINK' => ADMIN_URL.'/pages/modify.php?page_id='.$results_array['page_id'],
184
			) );
185
186
$query_sections = $database->query("SELECT section_id,module,position,block,publ_start,publ_end FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' ORDER BY position ASC");
187
if($query_sections->numRows() > 0) {
188
	$num_sections = $query_sections->numRows();
189
	while($section = $query_sections->fetchRow()) {
190
		if(!is_numeric(array_search($section['module'], $module_permissions))) {
191
			// Get the modules real name
192
			$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
193
			$template->set_var(array(
194
			) );
195
			if(SECTION_BLOCKS) {
196
				$edit_page ='<a name="'.$section['section_id'].'" href="'.ADMIN_URL.'/pages/modify.php?page_id='.$page_id.'#'.$section['section_id'].'">'.$module_name.'</a>';
197
				$input_attribute = 'input_normal';
198
				$template->set_var(array(
199 1103 Ruebenwurz
						'STYLE_DISPLAY_SECTION_BLOCK' => ' style="visibility:visible;"',
200 1009 Ruebenwurz
						'NAME_SIZE' => 180,
201
						'INPUT_ATTRIBUTE' => $input_attribute,
202
						'VAR_SECTION_ID' => $section['section_id'],
203
						'VAR_POSITION' => $section['position'],
204
						'LINK_MODIFY_URL_VAR_MODUL_NAME' => $edit_page,
205 1050 Ruebenwurz
						'SELECT' => '',
206
						'SET_NONE_DISPLAY_OPTION' => '',
207 1009 Ruebenwurz
				) );
208
				// Add block options to the section_list
209
				$template->clear_var('block_list');
210
				foreach($block AS $number => $name) {
211
					$template->set_var('NAME', htmlentities(strip_tags($name)));
212
					$template->set_var('VALUE', $number);
213
					$template->set_var('SIZE', 1);
214
					if($section['block'] == $number) {
215
						$template->set_var('SELECTED', ' selected="selected"');
216
					} else {
217
						$template->set_var('SELECTED', '');
218
					}
219
					$template->parse('block_list', 'block_block', true);
220
				}
221
			} else {
222 1065 Ruebenwurz
				$edit_page ='<a name="'.$section['section_id'].'" href="'.ADMIN_URL.'/pages/modify.php?page_id='.$page_id.'#'.$section['section_id'].'">'.$module_name.'</a>';
223 1009 Ruebenwurz
				$input_attribute = 'input_small';
224
				$template->set_var(array(
225 1103 Ruebenwurz
						'STYLE_DISPLAY_SECTION_BLOCK' => ' style="display:none;"',
226 1009 Ruebenwurz
						'NAME_SIZE' => 270,
227
						'INPUT_ATTRIBUTE' => $input_attribute,
228
						'VAR_SECTION_ID' => $section['section_id'],
229
						'VAR_POSITION' => $section['position'],
230
						'LINK_MODIFY_URL_VAR_MODUL_NAME' => $edit_page,
231 1092 Ruebenwurz
						'NAME' => htmlentities(strip_tags($block[1])),
232
						'VALUE' => 1,
233
						'SET_NONE_DISPLAY_OPTION' => '',
234 1009 Ruebenwurz
					) );
235
			}
236
			// Insert icon and images
237
			$template->set_var(array(
238
						'CLOCK_16_PNG' => 'clock_16.png',
239
						'CLOCK_DEL_16_PNG' => 'clock_del_16.png',
240
						'DELETE_16_PNG' => 'delete_16.png',
241
					) );
242
			// set calendar start values
243
			if($section['publ_start']==0) {
244
				$template->set_var('VALUE_PUBL_START', '');
245
			} else {
246
				$template->set_var('VALUE_PUBL_START', date($jscal_format, $section['publ_start']));
247
			}
248
			// set calendar start values
249
			if($section['publ_end']==0) {
250
				$template->set_var('VALUE_PUBL_END', '');
251
			} else {
252
				$template->set_var('VALUE_PUBL_END', date($jscal_format, $section['publ_end']));
253
			}
254
			// Insert icons up and down
255
			if($section['position'] != 1 ) {
256
				$template->set_var(
257
							'VAR_MOVE_UP_URL',
258
							'<a href="'.ADMIN_URL.'/pages/move_up.php?page_id='.$page_id.'&amp;section_id='.$section['section_id'].'">
259 1078 Ruebenwurz
							<img src="'.THEME_URL.'/images/up_16.png" alt="{TEXT_MOVE_UP}" />
260 1009 Ruebenwurz
							</a>' );
261
			} else {
262
				$template->set_var(array(
263
							'VAR_MOVE_UP_URL' => '',
264
						) );
265
			}
266
			if($section['position'] != $num_sections ) {
267
				$template->set_var(
268
							'VAR_MOVE_DOWN_URL',
269
							'<a href="'.ADMIN_URL.'/pages/move_down.php?page_id='.$page_id.'&amp;section_id='.$section['section_id'].'">
270 1078 Ruebenwurz
							<img src="'.THEME_URL.'/images/down_16.png" alt="{TEXT_MOVE_DOWN}" />
271 1009 Ruebenwurz
							</a>' );
272
			} else {
273
				$template->set_var(array(
274
							'VAR_MOVE_DOWN_URL' => '',
275
						) );
276
			}
277
		}
278 1048 Ruebenwurz
			$template->set_var(array(
279
							'DISPLAY_DEBUG' => ' style="visibility="visible;"',
280
							'TEXT_SID' => 'SID',
281
							'DEBUG_COLSPAN_SIZE' => 9,
282
						) );
283 1009 Ruebenwurz
		if($debug) {
284
			$template->set_var(array(
285
							'DISPLAY_DEBUG' => ' style="visibility="visible;"',
286
							'TEXT_PID' => 'PID',
287
							'TEXT_SID' => 'SID',
288
							'POSITION' => $section['position'],
289
						) );
290
		} else {
291
			$template->set_var(array(
292 1050 Ruebenwurz
							'DISPLAY_DEBUG' => ' style="display:none;"',
293 1009 Ruebenwurz
							'TEXT_PID' => '',
294
							'POSITION' => '',
295
						) );
296
		}
297
		$template->parse('section_list', 'section_block', true);
298
	}
299
}
300
301
// now add the calendars -- remember to to set the range to [1970, 2037] if the date is used as timestamp!
302
// the loop is simply a copy from above.
303
$query_sections = $database->query("SELECT section_id,module FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' ORDER BY position ASC");
304
if($query_sections->numRows() > 0) {
305
	$num_sections = $query_sections->numRows();
306
	while($section = $query_sections->fetchRow()) {
307
		// Get the modules real name
308
		$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
309
		if(!is_numeric(array_search($section['module'], $module_permissions))) {
310
			$template->set_var(array(
311
						'jscal_ifformat' => $jscal_ifformat,
312
						'jscal_firstday' => $jscal_firstday,
313
						'jscal_today' => $jscal_today,
314
						'start_date' => 'start_date'.$section['section_id'],
315
						'end_date' => 'end_date'.$section['section_id'],
316
						'trigger_start' => 'trigger_start'.$section['section_id'],
317
						'trigger_end' => 'trigger_stop'.$section['section_id'],
318
					) );
319
			if(isset($jscal_use_time) && $jscal_use_time==TRUE) {
320
				$template->set_var(array(
321
						'showsTime' => "true",
322
						'timeFormat' => "24",
323
					) );
324
			}  else {
325
				$template->set_var(array(
326
						'showsTime' => "false",
327
						'timeFormat' => "24",
328
					) );
329
			}
330
		}
331
		$template->parse('calendar_list', 'calendar_block', true);
332
	}
333
}
334
335
// Work-out if we should show the "Add Section" form
336
$query_sections = $database->query("SELECT section_id FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' AND module = 'menu_link'");
337
if($query_sections->numRows() == 0) {
338
	// Modules list
339
	$result = $database->query("SELECT * FROM ".TABLE_PREFIX."addons WHERE type = 'module' AND function = 'page' AND directory != 'menu_link' order by name");
340
	if($result->numRows() > 0) {
341
		while ($module = $result->fetchRow()) {
342
			// Check if user is allowed to use this module   echo  $module['directory'],'<br />';
343
			if(!is_numeric(array_search($module['directory'], $module_permissions))) {
344
				$template->set_var('VALUE', $module['directory']);
345
				$template->set_var('NAME', $module['name']);
346
				if($module['directory'] == 'wysiwyg') {
347
					$template->set_var('SELECTED', ' selected="selected"');
348
				} else {
349
					$template->set_var('SELECTED', '');
350
				}
351
				$template->parse('module_list', 'module_block', true);
352
			}
353
		}
354
	}
355
}
356
// Insert language text and messages
357
$template->set_var(array(
358
					'TEXT_MANAGE_SECTIONS' => $HEADING['MANAGE_SECTIONS'],
359
					'TEXT_ARE_YOU_SURE' => $TEXT['ARE_YOU_SURE'],
360
					'TEXT_TYPE' => $TEXT['TYPE'],
361
					'TEXT_ADD' => $TEXT['ADD'],
362
					'TEXT_SAVE' =>  $TEXT['SAVE'],
363
					'TEXTLINK_MODIFY_PAGE' => $HEADING['MODIFY_PAGE'],
364
					'TEXT_CALENDAR' => $TEXT['CALENDAR'],
365
					'TEXT_DELETE_DATE' => $TEXT['DELETE_DATE'],
366
					'TEXT_ADD_SECTION' => $TEXT['ADD_SECTION'],
367 1078 Ruebenwurz
					'TEXT_MOVE_UP' => $TEXT['MOVE_UP'],
368
					'TEXT_MOVE_DOWN' => $TEXT['MOVE_DOWN']
369 1009 Ruebenwurz
				) );
370
$template->parse('main', 'main_block', false);
371
$template->pparse('output', 'page');
372
373
// Print admin footer
374
$admin->print_footer();
375
376
?>