Project

General

Profile

1 238 stefan
<?php
2
3 399 Ruebenwurz
// $Id$
4
5 238 stefan
/*
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
// 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 286 stefan
	exit(0);
33 238 stefan
}
34
35
// Get page id
36
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
// Create new admin object
44
require_once(WB_PATH.'/framework/class.admin.php');
45
$admin = new admin('Pages', 'pages_modify');
46
47
// Check if we are supposed to add or delete a section
48
if(isset($_GET['section_id']) AND is_numeric($_GET['section_id'])) {
49
	// Get more information about this section
50
	$section_id = $_GET['section_id'];
51
	$query_section = $database->query("SELECT module FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id'");
52
	if($query_section->numRows() == 0) {
53
		$admin->print_error('Section not found');
54
	}
55
	$section = $query_section->fetchRow();
56
	// Include the modules delete file if it exists
57
	if(file_exists(WB_PATH.'/modules/'.$section['module'].'/delete.php')) {
58
		require(WB_PATH.'/modules/'.$section['module'].'/delete.php');
59
	}
60
	$database->query("DELETE FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id' LIMIT 1");
61
	if($database->is_error()) {
62
		$admin->print_error($database->get_error());
63
	} else {
64
		require(WB_PATH.'/framework/class.order.php');
65
		$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
66
		$order->clean($page_id);
67
		$admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/sections.php?page_id='.$page_id);
68
		$admin->print_footer();
69
		exit();
70
	}
71
} elseif(isset($_POST['module']) AND $_POST['module'] != '') {
72
	// Get section info
73
	$module = $_POST['module'];
74
	// Include the ordering class
75
	require(WB_PATH.'/framework/class.order.php');
76
	// Get new order
77
	$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
78
	$position = $order->get_new($page_id);
79
	// Insert module into DB
80
	$database->query("INSERT INTO ".TABLE_PREFIX."sections (page_id,module,position,block) VALUES ('$page_id','$module','$position','1')");
81
	// Get the section id
82
	$section_id = $database->get_one("SELECT LAST_INSERT_ID()");
83
	// Include the selected modules add file if it exists
84
	if(file_exists(WB_PATH.'/modules/'.$module.'/add.php')) {
85
		require(WB_PATH.'/modules/'.$module.'/add.php');
86
	}
87
}
88
89
// Get perms
90
$database = new database();
91
$results = $database->query("SELECT admin_groups,admin_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'");
92
$results_array = $results->fetchRow();
93
$old_admin_groups = explode(',', $results_array['admin_groups']);
94
$old_admin_users = explode(',', $results_array['admin_users']);
95 546 doc
$in_old_group = FALSE;
96
foreach($admin->get_groups_id() as $cur_gid){
97
    if (in_array($cur_gid, $old_admin_groups)) {
98
	$in_old_group = TRUE;
99
    }
100
}
101
if((!$in_old_group) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users))) {
102 238 stefan
	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
103
}
104
105
// Get page details
106
$database = new database();
107
$query = "SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'";
108
$results = $database->query($query);
109
if($database->is_error()) {
110
	$admin->print_header();
111
	$admin->print_error($database->get_error());
112
}
113
if($results->numRows() == 0) {
114
	$admin->print_header();
115
	$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
116
}
117
$results_array = $results->fetchRow();
118
119
// Set module permissions
120
$module_permissions = $_SESSION['MODULE_PERMISSIONS'];
121
122
// Unset block var
123
unset($block);
124
// Include template info file (if it exists)
125
if($results_array['template'] != '') {
126
	$template_location = WB_PATH.'/templates/'.$results_array['template'].'/info.php';
127
} else {
128
	$template_location = WB_PATH.'/templates/'.DEFAULT_TEMPLATE.'/info.php';
129
}
130
if(file_exists($template_location)) {
131
	require($template_location);
132
}
133
// Check if $menu is set
134
if(!isset($block[1]) OR $block[1] == '') {
135
	// Make our own menu list
136
	$block[1] = $TEXT['MAIN'];
137
}
138 552 thorn
?>
139 238 stefan
140 552 thorn
<?php // include jscalendar-setup
141 574 thorn
	$jscal_use_time = true; // whether to use a clock, too
142 552 thorn
	require_once(WB_PATH."/include/jscalendar/wb-setup.php");
143 574 thorn
	// override some vars: (normally, there is no need to change this)
144 552 thorn
	//$jscal_lang = "en"; //- calendar-language (default: wb-backend-language)
145 574 thorn
	//$jscal_today = ""; // - date the calendar offers if the text-field is empty (default: today)
146 552 thorn
	//$jscal_firstday = "0"; // - first-day-of-week (0-sunday, 1-monday, ...) (default: 0(EN) or 1(everything else))
147 574 thorn
	//$jscal_format = "Y-m-d"; // - initial-format used for the text-field (default: from wb-backend-date-format)
148
	//$jscal_ifformat = "%Y-%m-%d"; // - format for jscalendar (default: from wb-backend-date-format)
149 238 stefan
?>
150
<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%" height="50" style="margin-bottom: 10px;">
151
<tr style="background-color: #F0F0F0;">
152
	<td valign="middle" align="left">
153
		<h2><?php echo $HEADING['MANAGE_SECTIONS']; ?></h2>
154
	</td>
155
	<td align="right">
156
		<?php echo $TEXT['CURRENT_PAGE']; ?>:
157 442 Ruebenwurz
		<b><?php echo ($results_array['page_title']); ?></b>
158 238 stefan
		-
159
		<a href="<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>"><?php echo $HEADING['MODIFY_PAGE']; ?></a>
160
		-
161
		<a href="<?php echo ADMIN_URL; ?>/pages/settings.php?page_id=<?php echo $page_id; ?>"><?php echo $TEXT['CHANGE_SETTINGS']; ?></a>
162
	</td>
163
</tr>
164
</table>
165
166
<?php
167 552 thorn
$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");
168 238 stefan
if($query_sections->numRows() > 0) {
169
?>
170
<form name="section_properties" action="<?php echo ADMIN_URL; ?>/pages/sections_save.php?page_id=<?php echo $page_id; ?>" method="post">
171
172
<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%">
173
<tr>
174
	<td><?php echo $TEXT['TYPE']; ?>:</td>
175
	<?php if(SECTION_BLOCKS) { ?>
176
	<td style="display: {DISPLAY_BLOCK}"><?php echo $TEXT['BLOCK']; ?>:</td>
177
	<?php } ?>
178 552 thorn
	<td><?php echo $TEXT['PUBL_START_DATE']; ?>:</td>
179
	<td><?php echo $TEXT['PUBL_END_DATE']; ?>:</td>
180 238 stefan
	<td colspan="3" width="60"><?php echo $TEXT['ACTIONS']; ?>:</td>
181
</tr>
182
<?php
183
	$num_sections = $query_sections->numRows();
184
	while($section = $query_sections->fetchRow()) {
185
		// Get the modules real name
186 346 stefan
		$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
187
		if(!is_numeric(array_search($section['module'], $module_permissions))) {
188 238 stefan
			?>
189
			<tr>
190 552 thorn
				<td style="width: <?php if(SECTION_BLOCKS) print "120"; else print "200"; ?>px;"><a href="<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>#<?php echo $section['section_id']; ?>"><?php echo $module_name; ?></a></td>
191 238 stefan
				<?php if(SECTION_BLOCKS) { ?>
192
				<td>
193
					<select name="block<?php echo $section['section_id']; ?>" style="width: 150px;">
194
						<?php
195
						foreach($block AS $number => $name) {
196
							?>
197
							<option value="<?php echo $number; ?>"<?php if($number == $section['block']) { echo ' selected'; } ?>><?php echo $name; ?></option>
198
							<?php
199
						}
200
						?>
201
					</select>
202
				</td>
203 552 thorn
				<?php } // jscalendar-stuff following ?>
204
				<td><input type="text" id="start_date<?php echo $section['section_id']; ?>" name="start_date<?php echo $section['section_id']; ?>" value="<?php if($section['publ_start']==0) print ""; else print date($jscal_format, $section['publ_start'])?>" style="width: 120px;" />
205 585 thorn
					<img src="<?php echo ADMIN_URL ?>/images/clock_16.png" id="trigger_start<?php echo $section['section_id']; ?>" style="cursor: pointer;" title="Calendar" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" />
206
					<img src="<?php echo ADMIN_URL ?>/images/clock_del_16.png" style="cursor: pointer;" title="delete date" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" onclick="document.section_properties.start_date<?php echo $section['section_id']; ?>.value=''" />
207
				</td>
208 552 thorn
				<td><input type="text" id="end_date<?php echo $section['section_id']; ?>" name="end_date<?php echo $section['section_id']; ?>" value="<?php if($section['publ_end']==0) print ""; else print date($jscal_format, $section['publ_end'])?>" style="width: 120px;" />
209 585 thorn
					<img src="<?php echo ADMIN_URL ?>/images/clock_16.png" id="trigger_stop<?php echo $section['section_id']; ?>" style="cursor: pointer;" title="Calendar" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" />
210
					<img src="<?php echo ADMIN_URL ?>/images/clock_del_16.png" style="cursor: pointer;" title="delete date" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" onclick="document.section_properties.end_date<?php echo $section['section_id']; ?>.value=''"/>
211
				</td>
212 238 stefan
				<td width="20">
213
					<?php if($section['position'] != 1) { ?>
214
					<a href="<?php echo ADMIN_URL; ?>/pages/move_up.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section['section_id']; ?>">
215
						<img src="<?php echo ADMIN_URL; ?>/images/up_16.png" alt="^" border="0" />
216
					</a>
217
					<?php } ?>
218
				</td>
219
				<td width="20">
220
					<?php if($section['position'] != $num_sections) { ?>
221
					<a href="<?php echo ADMIN_URL; ?>/pages/move_down.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section['section_id']; ?>">
222
						<img src="<?php echo ADMIN_URL; ?>/images/down_16.png" alt="v" border="0" />
223
					</a>
224
					<?php } ?>
225
				</td>
226
				<td width="20">
227
					<a href="javascript: confirm_link('<?php echo $TEXT['ARE_YOU_SURE']; ?>', '<?php echo ADMIN_URL; ?>/pages/sections.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section['section_id']; ?>');">
228
						<img src="<?php echo ADMIN_URL; ?>/images/delete_16.png" alt="Del" border="0" />
229
					</a>
230
				</td>
231
			</tr>
232
			<?php
233
			}
234
	}
235
	?>
236
	<tr>
237 552 thorn
		<td align="center" colspan="<?php if(SECTION_BLOCKS) print "7"; else print "6"; ?>"><input type="submit" name="save" value="<?php echo $TEXT['SAVE']; ?>" style="width: 150px;" /></td>
238 238 stefan
	</tr>
239
	</table>
240
241
</form>
242
<?php
243 552 thorn
	// now add the calendars -- remember to to set the range to [1970, 2037] if the date is used as timestamp!
244
	// the loop is simply a copy from above.
245
	$query_sections = $database->query("SELECT section_id,module FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' ORDER BY position ASC");
246
	if($query_sections->numRows() > 0) {
247
		$num_sections = $query_sections->numRows();
248
		while($section = $query_sections->fetchRow()) {
249
			// Get the modules real name
250
			$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
251
			if(!is_numeric(array_search($section['module'], $module_permissions))) {
252
	?>
253
				<script type="text/javascript">
254
					Calendar.setup(
255
						{
256
							inputField  : "start_date<?php echo $section['section_id']; ?>",
257
							ifFormat    : "<?php echo $jscal_ifformat ?>",
258
							button      : "trigger_start<?php echo $section['section_id']; ?>",
259
							firstDay    : <?php echo $jscal_firstday ?>,
260 574 thorn
							<?php if(isset($jscal_use_time) && $jscal_use_time==TRUE) { ?>
261
								showsTime   : "true",
262
								timeFormat  : "24",
263
							<?php } ?>
264 552 thorn
							date        : "<?php echo $jscal_today ?>",
265
							range       : [1970, 2037],
266
							step        : 1
267
						}
268
					);
269
				</script>
270
				<script type="text/javascript">
271
					Calendar.setup(
272
						{
273
							inputField  : "end_date<?php echo $section['section_id']; ?>",
274
							ifFormat    : "<?php echo $jscal_ifformat ?>",
275
							button      : "trigger_stop<?php echo $section['section_id']; ?>",
276
							firstDay    : <?php echo $jscal_firstday ?>,
277 574 thorn
							<?php if(isset($jscal_use_time) && $jscal_use_time==TRUE) { ?>
278
								showsTime   : "true",
279
								timeFormat  : "24",
280
							<?php } ?>
281 552 thorn
							date        : "<?php echo $jscal_today ?>",
282
							range       : [1970, 2037],
283
							step        : 1
284
						}
285
					);
286
				</script>
287
<?php
288
			}
289
		}
290
	}
291
?>
292
<?php
293 238 stefan
}
294
295
// Work-out if we should show the "Add Section" form
296
$query_sections = $database->query("SELECT section_id FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' AND module = 'menu_link'");
297
if($query_sections->numRows() == 0) {
298
	?>
299
	<h2><?php echo $TEXT['ADD_SECTION']; ?></h2>
300
301
	<form name="add" action="<?php echo ADMIN_URL; ?>/pages/sections.php?page_id=<?php echo $page_id; ?>" method="post">
302
303
	<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%">
304
	<tr>
305
		<td>
306
			<select name="module" style="width: 100%;">
307
			<?php
308
			// Insert module list
309 384 Ruebenwurz
			$result = $database->query("SELECT * FROM ".TABLE_PREFIX."addons WHERE type = 'module' AND function = 'page' AND directory != 'menu_link' order by name");
310 238 stefan
			if($result->numRows() > 0) {
311
				while($module = $result->fetchRow()) {
312
					// Check if user is allowed to use this module
313
					if(!is_numeric(array_search($module['directory'], $module_permissions))) {
314
						?>
315
						<option value="<?php echo $module['directory']; ?>"<?php if($module['directory'] == 'wysiwyg') { echo 'selected'; } ?>><?php echo $module['name']; ?></option>
316
						<?php
317
					}
318
				}
319
			}
320
			?>
321
			</select>
322
		</td>
323
		<td width="100">
324
			<input type="submit" name="submit" value="<?php echo $TEXT['ADD']; ?>" style="width: 100px" />
325
		</td>
326
	</tr>
327
	</table>
328
329
	</form>
330
	<?php
331
}
332
333
// Print admin footer
334
$admin->print_footer();
335
336 552 thorn
?>