Project

General

Profile

1
<?php
2

    
3
// $Id: sections.php 656 2008-02-01 22:53:02Z thorn $
4

    
5
/*
6

    
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2008, 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
// 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 = $admin->add_slashes($_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
$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
	$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
?>
139

    
140
<?php // include jscalendar-setup
141
	$jscal_use_time = true; // whether to use a clock, too
142
	require_once(WB_PATH."/include/jscalendar/wb-setup.php");
143
?>
144
<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%" height="50" style="margin-bottom: 10px;">
145
<tr style="background-color: #F0F0F0;">
146
	<td valign="middle" align="left">
147
		<h2><?php echo $HEADING['MANAGE_SECTIONS']; ?></h2>
148
	</td>
149
	<td align="right">
150
		<?php echo $TEXT['CURRENT_PAGE']; ?>: 
151
		<b><?php echo ($results_array['page_title']); ?></b>
152
		-
153
		<a href="<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>"><?php echo $HEADING['MODIFY_PAGE']; ?></a>
154
		-
155
		<a href="<?php echo ADMIN_URL; ?>/pages/settings.php?page_id=<?php echo $page_id; ?>"><?php echo $TEXT['CHANGE_SETTINGS']; ?></a>
156
	</td>
157
</tr>
158
</table>
159

    
160
<?php
161
$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");
162
if($query_sections->numRows() > 0) {
163
?>
164
<form name="section_properties" action="<?php echo ADMIN_URL; ?>/pages/sections_save.php?page_id=<?php echo $page_id; ?>" method="post">
165

    
166
<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%">
167
<tr>
168
	<td><?php echo $TEXT['TYPE']; ?>:</td>
169
	<?php if(SECTION_BLOCKS) { ?>
170
	<td style="display: {DISPLAY_BLOCK}"><?php echo $TEXT['BLOCK']; ?>:</td>
171
	<?php } ?>
172
	<td><?php echo $TEXT['PUBL_START_DATE']; ?>:</td>
173
	<td><?php echo $TEXT['PUBL_END_DATE']; ?>:</td>
174
	<td colspan="3" width="60"><?php echo $TEXT['ACTIONS']; ?>:</td>
175
</tr>
176
<?php
177
	$num_sections = $query_sections->numRows();
178
	while($section = $query_sections->fetchRow()) {
179
		// Get the modules real name
180
		$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
181
		if(!is_numeric(array_search($section['module'], $module_permissions))) {
182
			?>
183
			<tr>
184
				<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>
185
				<?php if(SECTION_BLOCKS) { ?>
186
				<td>
187
					<select name="block<?php echo $section['section_id']; ?>" style="width: 150px;">
188
						<?php
189
						foreach($block AS $number => $name) {
190
							?>
191
							<option value="<?php echo $number; ?>"<?php if($number == $section['block']) { echo ' selected'; } ?>><?php echo $name; ?></option>
192
							<?php
193
						}
194
						?>
195
					</select>
196
				</td>
197
				<?php } // jscalendar-stuff following ?>
198
				<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;" />
199
					<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=''" />
200
					<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=''" />
201
				</td>
202
				<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;" />
203
					<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=''" />
204
					<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=''"/>
205
				</td>
206
				<td width="20">
207
					<?php if($section['position'] != 1) { ?>
208
					<a href="<?php echo ADMIN_URL; ?>/pages/move_up.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section['section_id']; ?>">
209
						<img src="<?php echo ADMIN_URL; ?>/images/up_16.png" alt="^" border="0" />
210
					</a>
211
					<?php } ?>
212
				</td>
213
				<td width="20">
214
					<?php if($section['position'] != $num_sections) { ?>
215
					<a href="<?php echo ADMIN_URL; ?>/pages/move_down.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section['section_id']; ?>">
216
						<img src="<?php echo ADMIN_URL; ?>/images/down_16.png" alt="v" border="0" />
217
					</a>
218
					<?php } ?>
219
				</td>
220
				<td width="20">
221
					<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']; ?>');">
222
						<img src="<?php echo ADMIN_URL; ?>/images/delete_16.png" alt="Del" border="0" />
223
					</a>
224
				</td>
225
			</tr>
226
			<?php
227
			}
228
	}
229
	?>
230
	<tr>
231
		<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>
232
	</tr>
233
	</table>
234

    
235
</form>
236
<?php
237
	// now add the calendars -- remember to to set the range to [1970, 2037] if the date is used as timestamp!
238
	// the loop is simply a copy from above.
239
	$query_sections = $database->query("SELECT section_id,module FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' ORDER BY position ASC");
240
	if($query_sections->numRows() > 0) {
241
		$num_sections = $query_sections->numRows();
242
		while($section = $query_sections->fetchRow()) {
243
			// Get the modules real name
244
			$module_name=$database->get_one("SELECT name FROM ".TABLE_PREFIX."addons WHERE directory='".$section['module']."'");
245
			if(!is_numeric(array_search($section['module'], $module_permissions))) {
246
	?>			
247
				<script type="text/javascript">
248
					Calendar.setup(
249
						{
250
							inputField  : "start_date<?php echo $section['section_id']; ?>",
251
							ifFormat    : "<?php echo $jscal_ifformat ?>",
252
							button      : "trigger_start<?php echo $section['section_id']; ?>",
253
							firstDay    : <?php echo $jscal_firstday ?>,
254
							<?php if(isset($jscal_use_time) && $jscal_use_time==TRUE) { ?>
255
								showsTime   : "true",
256
								timeFormat  : "24",
257
							<?php } ?>
258
							date        : "<?php echo $jscal_today ?>",
259
							range       : [1970, 2037],
260
							step        : 1
261
						}
262
					);
263
				</script>
264
				<script type="text/javascript">
265
					Calendar.setup(
266
						{
267
							inputField  : "end_date<?php echo $section['section_id']; ?>",
268
							ifFormat    : "<?php echo $jscal_ifformat ?>",
269
							button      : "trigger_stop<?php echo $section['section_id']; ?>",
270
							firstDay    : <?php echo $jscal_firstday ?>,
271
							<?php if(isset($jscal_use_time) && $jscal_use_time==TRUE) { ?>
272
								showsTime   : "true",
273
								timeFormat  : "24",
274
							<?php } ?>
275
							date        : "<?php echo $jscal_today ?>",
276
							range       : [1970, 2037],
277
							step        : 1
278
						}
279
					);
280
				</script>
281
<?php
282
			}
283
		}
284
	}
285
?>
286
<?php
287
}
288

    
289
// Work-out if we should show the "Add Section" form
290
$query_sections = $database->query("SELECT section_id FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id' AND module = 'menu_link'");
291
if($query_sections->numRows() == 0) {
292
	?>
293
	<h2><?php echo $TEXT['ADD_SECTION']; ?></h2>
294
	
295
	<form name="add" action="<?php echo ADMIN_URL; ?>/pages/sections.php?page_id=<?php echo $page_id; ?>" method="post">
296
	
297
	<table cellpadding="5" cellspacing="0" border="0" align="center" width="100%">
298
	<tr>
299
		<td>
300
			<select name="module" style="width: 100%;">
301
			<?php
302
			// Insert module list
303
			$result = $database->query("SELECT * FROM ".TABLE_PREFIX."addons WHERE type = 'module' AND function = 'page' AND directory != 'menu_link' order by name");
304
			if($result->numRows() > 0) {
305
				while($module = $result->fetchRow()) {
306
					// Check if user is allowed to use this module
307
					if(!is_numeric(array_search($module['directory'], $module_permissions))) {
308
						?>
309
						<option value="<?php echo $module['directory']; ?>"<?php if($module['directory'] == 'wysiwyg') { echo 'selected'; } ?>><?php echo $module['name']; ?></option>
310
						<?php
311
					}
312
				}
313
			}
314
			?>
315
			</select>
316
		</td>
317
		<td width="100">
318
			<input type="submit" name="submit" value="<?php echo $TEXT['ADD']; ?>" style="width: 100px" />
319
		</td>
320
	</tr>
321
	</table>
322
	
323
	</form>
324
	<?php
325
}
326

    
327
// Print admin footer
328
$admin->print_footer();
329

    
330
?>
(13-13/19)