Project

General

Profile

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