Context Navigation

← Previous Revision
Latest Revision
Next Revision →
Normal
Revision Log

admin_forums.php @ 10

Last change on this file since 10 was 4, checked in by dj3c1t, 13 years ago
passage en v5.1.1
File size: 21.1 KB

Rev	Line
[1]	1	<?php
	2
[3]	3	/**
	4	* Copyright (C) 2008-2011 FluxBB
	5	* based on code by Rickard Andersson copyright (C) 2002-2008 PunBB
	6	* License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher
	7	*/
[1]	8
	9	// Tell header.php to use the admin template
	10	define('PUN_ADMIN_CONSOLE', 1);
	11
[3]	12	define('PUN_ROOT', dirname(__FILE__).'/');
[1]	13	require PUN_ROOT.'include/common.php';
	14	require PUN_ROOT.'include/common_admin.php';
	15
	16
[3]	17	if ($pun_user['g_id'] != PUN_ADMIN)
[1]	18	message($lang_common['No permission']);
	19
[3]	20	// Load the admin_forums.php language file
	21	require PUN_ROOT.'lang/'.$admin_language.'/admin_forums.php';
[1]	22
	23	// Add a "default" forum
	24	if (isset($_POST['add_forum']))
	25	{
	26	confirm_referrer('admin_forums.php');
	27
	28	$add_to_cat = intval($_POST['add_to_cat']);
	29	if ($add_to_cat < 1)
	30	message($lang_common['Bad request']);
	31
[3]	32	$db->query('INSERT INTO '.$db->prefix.'forums (forum_name, cat_id) VALUES(\''.$db->escape($lang_admin_forums['New forum']).'\', '.$add_to_cat.')') or error('Unable to create forum', __FILE__, __LINE__, $db->error());
[1]	33
[3]	34	// Regenerate the quick jump cache
	35	if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
	36	require PUN_ROOT.'include/cache.php';
	37
[1]	38	generate_quickjump_cache();
	39
[3]	40	redirect('admin_forums.php', $lang_admin_forums['Forum added redirect']);
[1]	41	}
	42
	43	// Delete a forum
	44	else if (isset($_GET['del_forum']))
	45	{
	46	confirm_referrer('admin_forums.php');
	47
	48	$forum_id = intval($_GET['del_forum']);
	49	if ($forum_id < 1)
	50	message($lang_common['Bad request']);
	51
[3]	52	if (isset($_POST['del_forum_comply'])) // Delete a forum with all posts
[1]	53	{
	54	@set_time_limit(0);
	55
	56	// Prune all posts and topics
	57	prune($forum_id, 1, -1);
	58
	59	// Locate any "orphaned redirect topics" and delete them
[3]	60	$result = $db->query('SELECT t1.id FROM '.$db->prefix.'topics AS t1 LEFT JOIN '.$db->prefix.'topics AS t2 ON t1.moved_to=t2.id WHERE t2.id IS NULL AND t1.moved_to IS NOT NULL') or error('Unable to fetch redirect topics', __FILE__, __LINE__, $db->error());
[1]	61	$num_orphans = $db->num_rows($result);
	62
	63	if ($num_orphans)
	64	{
	65	for ($i = 0; $i < $num_orphans; ++$i)
	66	$orphans[] = $db->result($result, $i);
	67
[3]	68	$db->query('DELETE FROM '.$db->prefix.'topics WHERE id IN('.implode(',', $orphans).')') or error('Unable to delete redirect topics', __FILE__, __LINE__, $db->error());
[1]	69	}
	70
	71	// Delete the forum and any forum specific group permissions
[3]	72	$db->query('DELETE FROM '.$db->prefix.'forums WHERE id='.$forum_id) or error('Unable to delete forum', __FILE__, __LINE__, $db->error());
	73	$db->query('DELETE FROM '.$db->prefix.'forum_perms WHERE forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $db->error());
[1]	74
[3]	75	// Delete any subscriptions for this forum
	76	$db->query('DELETE FROM '.$db->prefix.'forum_subscriptions WHERE forum_id='.$forum_id) or error('Unable to delete subscriptions', __FILE__, __LINE__, $db->error());
	77
	78	// Regenerate the quick jump cache
	79	if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
	80	require PUN_ROOT.'include/cache.php';
	81
[1]	82	generate_quickjump_cache();
	83
[3]	84	redirect('admin_forums.php', $lang_admin_forums['Forum deleted redirect']);
[1]	85	}
[3]	86	else // If the user hasn't confirmed the delete
[1]	87	{
[3]	88	$result = $db->query('SELECT forum_name FROM '.$db->prefix.'forums WHERE id='.$forum_id) or error('Unable to fetch forum info', __FILE__, __LINE__, $db->error());
[1]	89	$forum_name = pun_htmlspecialchars($db->result($result));
	90
[3]	91	$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Forums']);
	92	define('PUN_ACTIVE_PAGE', 'admin');
[1]	93	require PUN_ROOT.'header.php';
	94
	95	generate_admin_menu('forums');
	96
	97	?>
	98	<div class="blockform">
[3]	99	<h2><span><?php echo $lang_admin_forums['Confirm delete head'] ?></span></h2>
[1]	100	<div class="box">
	101	<form method="post" action="admin_forums.php?del_forum=<?php echo $forum_id ?>">
	102	<div class="inform">
	103	<fieldset>
[3]	104	<legend><?php echo $lang_admin_forums['Confirm delete subhead'] ?></legend>
[1]	105	<div class="infldset">
[3]	106	<p><?php printf($lang_admin_forums['Confirm delete info'], $forum_name) ?></p>
	107	<p class="warntext"><?php echo $lang_admin_forums['Confirm delete warn'] ?></p>
[1]	108	</div>
	109	</fieldset>
	110	</div>
[3]	111	<p class="buttons"><input type="submit" name="del_forum_comply" value="<?php echo $lang_admin_common['Delete'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_admin_common['Go back'] ?></a></p>
[1]	112	</form>
	113	</div>
	114	</div>
	115	<div class="clearer"></div>
	116	</div>
	117	<?php
	118
	119	require PUN_ROOT.'footer.php';
	120	}
	121	}
	122
	123	// Update forum positions
	124	else if (isset($_POST['update_positions']))
	125	{
	126	confirm_referrer('admin_forums.php');
	127
[3]	128	foreach ($_POST['position'] as $forum_id => $disp_position)
[1]	129	{
[3]	130	$disp_position = trim($disp_position);
	131	if ($disp_position == '' \|\| preg_match('%[^0-9]%', $disp_position))
	132	message($lang_admin_forums['Must be integer message']);
[1]	133
[3]	134	$db->query('UPDATE '.$db->prefix.'forums SET disp_position='.$disp_position.' WHERE id='.intval($forum_id)) or error('Unable to update forum', __FILE__, __LINE__, $db->error());
[1]	135	}
	136
[3]	137	// Regenerate the quick jump cache
	138	if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
	139	require PUN_ROOT.'include/cache.php';
	140
[1]	141	generate_quickjump_cache();
	142
[3]	143	redirect('admin_forums.php', $lang_admin_forums['Forums updated redirect']);
[1]	144	}
	145
	146	else if (isset($_GET['edit_forum']))
	147	{
	148	$forum_id = intval($_GET['edit_forum']);
	149	if ($forum_id < 1)
	150	message($lang_common['Bad request']);
	151
	152	// Update group permissions for $forum_id
	153	if (isset($_POST['save']))
	154	{
	155	confirm_referrer('admin_forums.php');
	156
	157	// Start with the forum details
[3]	158	$forum_name = pun_trim($_POST['forum_name']);
	159	$forum_desc = pun_linebreaks(pun_trim($_POST['forum_desc']));
[1]	160	$cat_id = intval($_POST['cat_id']);
	161	$sort_by = intval($_POST['sort_by']);
	162	$redirect_url = isset($_POST['redirect_url']) ? trim($_POST['redirect_url']) : null;
	163
	164	if ($forum_name == '')
[3]	165	message($lang_admin_forums['Must enter name message']);
[1]	166
	167	if ($cat_id < 1)
	168	message($lang_common['Bad request']);
	169
	170	$forum_desc = ($forum_desc != '') ? '\''.$db->escape($forum_desc).'\'' : 'NULL';
	171	$redirect_url = ($redirect_url != '') ? '\''.$db->escape($redirect_url).'\'' : 'NULL';
	172
[3]	173	$db->query('UPDATE '.$db->prefix.'forums SET forum_name=\''.$db->escape($forum_name).'\', forum_desc='.$forum_desc.', redirect_url='.$redirect_url.', sort_by='.$sort_by.', cat_id='.$cat_id.' WHERE id='.$forum_id) or error('Unable to update forum', __FILE__, __LINE__, $db->error());
[1]	174
	175	// Now let's deal with the permissions
	176	if (isset($_POST['read_forum_old']))
	177	{
[3]	178	$result = $db->query('SELECT g_id, g_read_board, g_post_replies, g_post_topics FROM '.$db->prefix.'groups WHERE g_id!='.PUN_ADMIN) or error('Unable to fetch user group list', __FILE__, __LINE__, $db->error());
[1]	179	while ($cur_group = $db->fetch_assoc($result))
	180	{
[3]	181	$read_forum_new = ($cur_group['g_read_board'] == '1') ? isset($_POST['read_forum_new'][$cur_group['g_id']]) ? '1' : '0' : intval($_POST['read_forum_old'][$cur_group['g_id']]);
	182	$post_replies_new = isset($_POST['post_replies_new'][$cur_group['g_id']]) ? '1' : '0';
	183	$post_topics_new = isset($_POST['post_topics_new'][$cur_group['g_id']]) ? '1' : '0';
[1]	184
	185	// Check if the new settings differ from the old
	186	if ($read_forum_new != $_POST['read_forum_old'][$cur_group['g_id']] \|\| $post_replies_new != $_POST['post_replies_old'][$cur_group['g_id']] \|\| $post_topics_new != $_POST['post_topics_old'][$cur_group['g_id']])
	187	{
	188	// If the new settings are identical to the default settings for this group, delete it's row in forum_perms
	189	if ($read_forum_new == '1' && $post_replies_new == $cur_group['g_post_replies'] && $post_topics_new == $cur_group['g_post_topics'])
[3]	190	$db->query('DELETE FROM '.$db->prefix.'forum_perms WHERE group_id='.$cur_group['g_id'].' AND forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $db->error());
[1]	191	else
	192	{
	193	// Run an UPDATE and see if it affected a row, if not, INSERT
[3]	194	$db->query('UPDATE '.$db->prefix.'forum_perms SET read_forum='.$read_forum_new.', post_replies='.$post_replies_new.', post_topics='.$post_topics_new.' WHERE group_id='.$cur_group['g_id'].' AND forum_id='.$forum_id) or error('Unable to insert group forum permissions', __FILE__, __LINE__, $db->error());
[1]	195	if (!$db->affected_rows())
[3]	196	$db->query('INSERT INTO '.$db->prefix.'forum_perms (group_id, forum_id, read_forum, post_replies, post_topics) VALUES('.$cur_group['g_id'].', '.$forum_id.', '.$read_forum_new.', '.$post_replies_new.', '.$post_topics_new.')') or error('Unable to insert group forum permissions', __FILE__, __LINE__, $db->error());
[1]	197	}
	198	}
	199	}
	200	}
	201
[3]	202	// Regenerate the quick jump cache
	203	if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
	204	require PUN_ROOT.'include/cache.php';
	205
[1]	206	generate_quickjump_cache();
	207
[3]	208	redirect('admin_forums.php', $lang_admin_forums['Forum updated redirect']);
[1]	209	}
	210	else if (isset($_POST['revert_perms']))
	211	{
	212	confirm_referrer('admin_forums.php');
	213
[3]	214	$db->query('DELETE FROM '.$db->prefix.'forum_perms WHERE forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $db->error());
[1]	215
[3]	216	// Regenerate the quick jump cache
	217	if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
	218	require PUN_ROOT.'include/cache.php';
	219
[1]	220	generate_quickjump_cache();
	221
[3]	222	redirect('admin_forums.php?edit_forum='.$forum_id, $lang_admin_forums['Perms reverted redirect']);
[1]	223	}
	224
	225	// Fetch forum info
[3]	226	$result = $db->query('SELECT id, forum_name, forum_desc, redirect_url, num_topics, sort_by, cat_id FROM '.$db->prefix.'forums WHERE id='.$forum_id) or error('Unable to fetch forum info', __FILE__, __LINE__, $db->error());
[1]	227	if (!$db->num_rows($result))
	228	message($lang_common['Bad request']);
	229
	230	$cur_forum = $db->fetch_assoc($result);
	231
[3]	232	$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Forums']);
	233	define('PUN_ACTIVE_PAGE', 'admin');
[1]	234	require PUN_ROOT.'header.php';
	235
	236	generate_admin_menu('forums');
	237
	238	?>
	239	<div class="blockform">
[3]	240	<h2><span><?php echo $lang_admin_forums['Edit forum head'] ?></span></h2>
[1]	241	<div class="box">
	242	<form id="edit_forum" method="post" action="admin_forums.php?edit_forum=<?php echo $forum_id ?>">
[3]	243	<p class="submittop"><input type="submit" name="save" value="<?php echo $lang_admin_common['Save changes'] ?>" tabindex="6" /></p>
[1]	244	<div class="inform">
	245	<fieldset>
[3]	246	<legend><?php echo $lang_admin_forums['Edit details subhead'] ?></legend>
[1]	247	<div class="infldset">
	248	<table class="aligntop" cellspacing="0">
	249	<tr>
[3]	250	<th scope="row"><?php echo $lang_admin_forums['Forum name label'] ?></th>
[1]	251	<td><input type="text" name="forum_name" size="35" maxlength="80" value="<?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?>" tabindex="1" /></td>
	252	</tr>
	253	<tr>
[3]	254	<th scope="row"><?php echo $lang_admin_forums['Forum description label'] ?></th>
[1]	255	<td><textarea name="forum_desc" rows="3" cols="50" tabindex="2"><?php echo pun_htmlspecialchars($cur_forum['forum_desc']) ?></textarea></td>
	256	</tr>
	257	<tr>
[3]	258	<th scope="row"><?php echo $lang_admin_forums['Category label'] ?></th>
[1]	259	<td>
	260	<select name="cat_id" tabindex="3">
	261	<?php
	262
[3]	263	$result = $db->query('SELECT id, cat_name FROM '.$db->prefix.'categories ORDER BY disp_position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
[1]	264	while ($cur_cat = $db->fetch_assoc($result))
	265	{
	266	$selected = ($cur_cat['id'] == $cur_forum['cat_id']) ? ' selected="selected"' : '';
	267	echo "\t\t\t\t\t\t\t\t\t\t\t".'<option value="'.$cur_cat['id'].'"'.$selected.'>'.pun_htmlspecialchars($cur_cat['cat_name']).'</option>'."\n";
	268	}
	269
	270	?>
	271	</select>
	272	</td>
	273	</tr>
	274	<tr>
[3]	275	<th scope="row"><?php echo $lang_admin_forums['Sort by label'] ?></th>
[1]	276	<td>
	277	<select name="sort_by" tabindex="4">
[3]	278	<option value="0"<?php if ($cur_forum['sort_by'] == '0') echo ' selected="selected"' ?>><?php echo $lang_admin_forums['Last post'] ?></option>
	279	<option value="1"<?php if ($cur_forum['sort_by'] == '1') echo ' selected="selected"' ?>><?php echo $lang_admin_forums['Topic start'] ?></option>
	280	<option value="2"<?php if ($cur_forum['sort_by'] == '2') echo ' selected="selected"' ?>><?php echo $lang_admin_forums['Subject'] ?></option>
[1]	281	</select>
	282	</td>
	283	</tr>
	284	<tr>
[3]	285	<th scope="row"><?php echo $lang_admin_forums['Redirect label'] ?></th>
	286	<td><?php echo ($cur_forum['num_topics']) ? $lang_admin_forums['Redirect help'] : '<input type="text" name="redirect_url" size="45" maxlength="100" value="'.pun_htmlspecialchars($cur_forum['redirect_url']).'" tabindex="5" />'; ?></td>
[1]	287	</tr>
	288	</table>
	289	</div>
	290	</fieldset>
	291	</div>
	292	<div class="inform">
	293	<fieldset>
[3]	294	<legend><?php echo $lang_admin_forums['Group permissions subhead'] ?></legend>
[1]	295	<div class="infldset">
[3]	296	<p><?php printf($lang_admin_forums['Group permissions info'], '<a href="admin_groups.php">'.$lang_admin_common['User groups'].'</a>') ?></p>
[1]	297	<table id="forumperms" cellspacing="0">
	298	<thead>
	299	<tr>
	300	<th class="atcl"> </th>
[3]	301	<th><?php echo $lang_admin_forums['Read forum label'] ?></th>
	302	<th><?php echo $lang_admin_forums['Post replies label'] ?></th>
	303	<th><?php echo $lang_admin_forums['Post topics label'] ?></th>
[1]	304	</tr>
	305	</thead>
	306	<tbody>
	307	<?php
	308
[3]	309	$result = $db->query('SELECT g.g_id, g.g_title, g.g_read_board, g.g_post_replies, g.g_post_topics, fp.read_forum, fp.post_replies, fp.post_topics FROM '.$db->prefix.'groups AS g LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (g.g_id=fp.group_id AND fp.forum_id='.$forum_id.') WHERE g.g_id!='.PUN_ADMIN.' ORDER BY g.g_id') or error('Unable to fetch group forum permission list', __FILE__, __LINE__, $db->error());
[1]	310
[3]	311	$cur_index = 7;
	312
[1]	313	while ($cur_perm = $db->fetch_assoc($result))
	314	{
	315	$read_forum = ($cur_perm['read_forum'] != '0') ? true : false;
	316	$post_replies = (($cur_perm['g_post_replies'] == '0' && $cur_perm['post_replies'] == '1') \|\| ($cur_perm['g_post_replies'] == '1' && $cur_perm['post_replies'] != '0')) ? true : false;
	317	$post_topics = (($cur_perm['g_post_topics'] == '0' && $cur_perm['post_topics'] == '1') \|\| ($cur_perm['g_post_topics'] == '1' && $cur_perm['post_topics'] != '0')) ? true : false;
	318
[3]	319	// Determine if the current settings differ from the default or not
[1]	320	$read_forum_def = ($cur_perm['read_forum'] == '0') ? false : true;
	321	$post_replies_def = (($post_replies && $cur_perm['g_post_replies'] == '0') \|\| (!$post_replies && ($cur_perm['g_post_replies'] == '' \|\| $cur_perm['g_post_replies'] == '1'))) ? false : true;
	322	$post_topics_def = (($post_topics && $cur_perm['g_post_topics'] == '0') \|\| (!$post_topics && ($cur_perm['g_post_topics'] == '' \|\| $cur_perm['g_post_topics'] == '1'))) ? false : true;
	323
	324	?>
	325	<tr>
	326	<th class="atcl"><?php echo pun_htmlspecialchars($cur_perm['g_title']) ?></th>
	327	<td<?php if (!$read_forum_def) echo ' class="nodefault"'; ?>>
	328	<input type="hidden" name="read_forum_old[<?php echo $cur_perm['g_id'] ?>]" value="<?php echo ($read_forum) ? '1' : '0'; ?>" />
[3]	329	<input type="checkbox" name="read_forum_new[<?php echo $cur_perm['g_id'] ?>]" value="1"<?php echo ($read_forum) ? ' checked="checked"' : ''; ?><?php echo ($cur_perm['g_read_board'] == '0') ? ' disabled="disabled"' : ''; ?> tabindex="<?php echo $cur_index++ ?>" />
[1]	330	</td>
	331	<td<?php if (!$post_replies_def && $cur_forum['redirect_url'] == '') echo ' class="nodefault"'; ?>>
	332	<input type="hidden" name="post_replies_old[<?php echo $cur_perm['g_id'] ?>]" value="<?php echo ($post_replies) ? '1' : '0'; ?>" />
[3]	333	<input type="checkbox" name="post_replies_new[<?php echo $cur_perm['g_id'] ?>]" value="1"<?php echo ($post_replies) ? ' checked="checked"' : ''; ?><?php echo ($cur_forum['redirect_url'] != '') ? ' disabled="disabled"' : ''; ?> tabindex="<?php echo $cur_index++ ?>" />
[1]	334	</td>
	335	<td<?php if (!$post_topics_def && $cur_forum['redirect_url'] == '') echo ' class="nodefault"'; ?>>
	336	<input type="hidden" name="post_topics_old[<?php echo $cur_perm['g_id'] ?>]" value="<?php echo ($post_topics) ? '1' : '0'; ?>" />
[3]	337	<input type="checkbox" name="post_topics_new[<?php echo $cur_perm['g_id'] ?>]" value="1"<?php echo ($post_topics) ? ' checked="checked"' : ''; ?><?php echo ($cur_forum['redirect_url'] != '') ? ' disabled="disabled"' : ''; ?> tabindex="<?php echo $cur_index++ ?>" />
[1]	338	</td>
	339	</tr>
	340	<?php
	341
	342	}
	343
	344	?>
	345	</tbody>
	346	</table>
[3]	347	<div class="fsetsubmit"><input type="submit" name="revert_perms" value="<?php echo $lang_admin_forums['Revert to default'] ?>" tabindex="<?php echo $cur_index++ ?>" /></div>
[1]	348	</div>
	349	</fieldset>
	350	</div>
[3]	351	<p class="submitend"><input type="submit" name="save" value="<?php echo $lang_admin_common['Save changes'] ?>" tabindex="<?php echo $cur_index++ ?>" /></p>
[1]	352	</form>
	353	</div>
	354	</div>
	355	<div class="clearer"></div>
	356	</div>
	357
	358	<?php
	359
	360	require PUN_ROOT.'footer.php';
	361	}
	362
[3]	363	$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Forums']);
	364	define('PUN_ACTIVE_PAGE', 'admin');
[1]	365	require PUN_ROOT.'header.php';
	366
	367	generate_admin_menu('forums');
	368
	369	?>
	370	<div class="blockform">
[3]	371	<h2><span><?php echo $lang_admin_forums['Add forum head'] ?></span></h2>
[1]	372	<div class="box">
	373	<form method="post" action="admin_forums.php?action=adddel">
	374	<div class="inform">
	375	<fieldset>
[3]	376	<legend><?php echo $lang_admin_forums['Create new subhead'] ?></legend>
[1]	377	<div class="infldset">
	378	<table class="aligntop" cellspacing="0">
	379	<tr>
[3]	380	<th scope="row"><?php echo $lang_admin_forums['Add forum label'] ?><div><input type="submit" name="add_forum" value="<?php echo $lang_admin_forums['Add forum'] ?>" tabindex="2" /></div></th>
[1]	381	<td>
	382	<select name="add_to_cat" tabindex="1">
	383	<?php
	384
[3]	385	$result = $db->query('SELECT id, cat_name FROM '.$db->prefix.'categories ORDER BY disp_position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
	386	if ($db->num_rows($result) > 0)
	387	{
	388	while ($cur_cat = $db->fetch_assoc($result))
	389	echo "\t\t\t\t\t\t\t\t\t\t\t".'<option value="'.$cur_cat['id'].'">'.pun_htmlspecialchars($cur_cat['cat_name']).'</option>'."\n";
	390	}
	391	else
	392	echo "\t\t\t\t\t\t\t\t\t\t\t".'<option value="0" disabled="disabled">'.$lang_admin_forums['No categories exist'].'</option>'."\n";
[1]	393
	394	?>
	395	</select>
[3]	396	<span><?php echo $lang_admin_forums['Add forum help'] ?></span>
[1]	397	</td>
	398	</tr>
	399	</table>
	400	</div>
	401	</fieldset>
	402	</div>
	403	</form>
	404	</div>
[3]	405	<?php
[1]	406
[3]	407	// Display all the categories and forums
	408	$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.disp_position FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id ORDER BY c.disp_position, c.id, f.disp_position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());
	409
	410	if ($db->num_rows($result) > 0)
	411	{
	412
	413	?>
	414	<h2 class="block2"><span><?php echo $lang_admin_forums['Edit forums head'] ?></span></h2>
[1]	415	<div class="box">
	416	<form id="edforum" method="post" action="admin_forums.php?action=edit">
[3]	417	<p class="submittop"><input type="submit" name="update_positions" value="<?php echo $lang_admin_forums['Update positions'] ?>" tabindex="3" /></p>
[1]	418	<?php
	419
[3]	420	$cur_index = 4;
[1]	421
	422	$cur_category = 0;
	423	while ($cur_forum = $db->fetch_assoc($result))
	424	{
[3]	425	if ($cur_forum['cid'] != $cur_category) // A new category since last iteration?
[1]	426	{
	427	if ($cur_category != 0)
[3]	428	echo "\t\t\t\t\t\t\t".'</tbody>'."\n\t\t\t\t\t\t\t".'</table>'."\n\t\t\t\t\t\t".'</div>'."\n\t\t\t\t\t".'</fieldset>'."\n\t\t\t\t".'</div>'."\n";
[1]	429
	430	?>
	431	<div class="inform">
	432	<fieldset>
[3]	433	<legend><?php echo $lang_admin_forums['Category subhead'] ?> <?php echo pun_htmlspecialchars($cur_forum['cat_name']) ?></legend>
[1]	434	<div class="infldset">
	435	<table cellspacing="0">
[3]	436	<thead>
	437	<tr>
	438	<th class="tcl"><?php echo $lang_admin_common['Action'] ?></th>
	439	<th class="tc2"><?php echo $lang_admin_forums['Position label'] ?></th>
	440	<th class="tcr"><?php echo $lang_admin_forums['Forum label'] ?></th>
	441	</tr>
	442	</thead>
	443	<tbody>
[1]	444	<?php
	445
	446	$cur_category = $cur_forum['cid'];
	447	}
	448
	449	?>
	450	<tr>
[3]	451	<td class="tcl"><a href="admin_forums.php?edit_forum=<?php echo $cur_forum['fid'] ?>" tabindex="<?php echo $cur_index++ ?>"><?php echo $lang_admin_forums['Edit link'] ?></a> \| <a href="admin_forums.php?del_forum=<?php echo $cur_forum['fid'] ?>" tabindex="<?php echo $cur_index++ ?>"><?php echo $lang_admin_forums['Delete link'] ?></a></td>
	452	<td class="tc2"><input type="text" name="position[<?php echo $cur_forum['fid'] ?>]" size="3" maxlength="3" value="<?php echo $cur_forum['disp_position'] ?>" tabindex="<?php echo $cur_index++ ?>" /></td>
	453	<td class="tcr"><strong><?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></strong></td>
[1]	454	</tr>
	455	<?php
	456
	457	}
	458
	459	?>
[3]	460	</tbody>
[1]	461	</table>
	462	</div>
	463	</fieldset>
	464	</div>
[3]	465	<p class="submitend"><input type="submit" name="update_positions" value="<?php echo $lang_admin_forums['Update positions'] ?>" tabindex="<?php echo $cur_index++ ?>" /></p>
[1]	466	</form>
	467	</div>
[3]	468	<?php
	469
	470	}
	471
	472	?>
[1]	473	</div>
	474	<div class="clearer"></div>
	475	</div>
	476	<?php
	477
	478	require PUN_ROOT.'footer.php';

Note: See TracBrowser for help on using the repository browser.

rsr - v.5

Context Navigation

source: branches/rsr.v5.1.1/web/punbb/admin_forums.php @ 10

Download in other formats: