271 lines
9.9 KiB
PHP
271 lines
9.9 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Copyright (C) 2008-2012 FluxBB
|
|
* based on code by Rickard Andersson copyright (C) 2002-2008 PunBB
|
|
* License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher
|
|
*/
|
|
|
|
// Tell header.php to use the admin template
|
|
define('PUN_ADMIN_CONSOLE', 1);
|
|
|
|
define('PUN_ROOT', dirname(__FILE__).'/');
|
|
require PUN_ROOT.'include/common.php';
|
|
require PUN_ROOT.'include/common_admin.php';
|
|
|
|
|
|
if ($pun_user['g_id'] != PUN_ADMIN)
|
|
message($lang_common['No permission'], false, '403 Forbidden');
|
|
|
|
// Load the admin_categories.php language file
|
|
require PUN_ROOT.'lang/'.$admin_language.'/admin_categories.php';
|
|
|
|
// Add a new category
|
|
if (isset($_POST['add_cat']))
|
|
{
|
|
confirm_referrer('admin_categories.php');
|
|
|
|
$new_cat_name = pun_trim($_POST['new_cat_name'] ?? '');
|
|
if ($new_cat_name == '')
|
|
message($lang_admin_categories['Must enter name message']);
|
|
|
|
$db->query('INSERT INTO '.$db->prefix.'categories (cat_name) VALUES (\''.$db->escape($new_cat_name).'\')') or error('Unable to create category', __FILE__, __LINE__, $db->error());
|
|
|
|
redirect('admin_categories.php', $lang_admin_categories['Category added redirect']);
|
|
}
|
|
|
|
// Delete a category
|
|
else if (isset($_POST['del_cat']) || isset($_POST['del_cat_comply']))
|
|
{
|
|
confirm_referrer('admin_categories.php');
|
|
|
|
$cat_to_delete = intval($_POST['cat_to_delete'] ?? 0);
|
|
if ($cat_to_delete < 1)
|
|
message($lang_common['Bad request'], false, '404 Not Found');
|
|
|
|
if (isset($_POST['del_cat_comply'])) // Delete a category with all forums and posts
|
|
{
|
|
@set_time_limit(0);
|
|
|
|
$result = $db->query('SELECT id FROM '.$db->prefix.'forums WHERE cat_id='.$cat_to_delete) or error('Unable to fetch forum list', __FILE__, __LINE__, $db->error());
|
|
|
|
while ($cur_forum = $db->fetch_row($result))
|
|
{
|
|
// Prune all posts and topics
|
|
prune($cur_forum[0], 1, -1);
|
|
|
|
// Delete the forum
|
|
$db->query('DELETE FROM '.$db->prefix.'forums WHERE id='.$cur_forum[0]) or error('Unable to delete forum', __FILE__, __LINE__, $db->error());
|
|
|
|
}
|
|
|
|
// Locate any "orphaned redirect topics" and delete them
|
|
$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());
|
|
$orphans = [];
|
|
|
|
while ($row = $db->fetch_row($result))
|
|
$orphans[] = $row[0];
|
|
|
|
if (!empty($orphans))
|
|
$db->query('DELETE FROM '.$db->prefix.'topics WHERE id IN ('.implode(',', $orphans).')') or error('Unable to delete redirect topics', __FILE__, __LINE__, $db->error());
|
|
|
|
// Delete the category
|
|
$db->query('DELETE FROM '.$db->prefix.'categories WHERE id='.$cat_to_delete) or error('Unable to delete category', __FILE__, __LINE__, $db->error());
|
|
|
|
// Regenerate the quick jump cache
|
|
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
|
require PUN_ROOT.'include/cache.php';
|
|
|
|
generate_subforums_cache(); // MOD subforums - Visman
|
|
generate_quickjump_cache();
|
|
|
|
redirect('admin_categories.php', $lang_admin_categories['Category deleted redirect']);
|
|
}
|
|
else // If the user hasn't confirmed the delete
|
|
{
|
|
$result = $db->query('SELECT cat_name FROM '.$db->prefix.'categories WHERE id='.$cat_to_delete) or error('Unable to fetch category info', __FILE__, __LINE__, $db->error());
|
|
$cat_name = $db->result($result);
|
|
|
|
$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Categories']);
|
|
define('PUN_ACTIVE_PAGE', 'admin');
|
|
require PUN_ROOT.'header.php';
|
|
|
|
generate_admin_menu('categories');
|
|
|
|
?>
|
|
<div class="blockform">
|
|
<h2><span><?php echo $lang_admin_categories['Delete category head'] ?></span></h2>
|
|
<div class="box">
|
|
<form method="post" action="admin_categories.php">
|
|
<div class="inform">
|
|
<input type="hidden" name="cat_to_delete" value="<?php echo $cat_to_delete ?>" />
|
|
<input type="hidden" name="csrf_hash" value="<?php echo csrf_hash() ?>" />
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_categories['Confirm delete subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<p><?php printf($lang_admin_categories['Confirm delete info'], pun_htmlspecialchars($cat_name)) ?></p>
|
|
<p class="warntext"><?php echo $lang_admin_categories['Delete category warn'] ?></p>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
<p class="buttons"><input type="submit" name="del_cat_comply" value="<?php echo $lang_admin_common['Delete'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_admin_common['Go back'] ?></a></p>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
<div class="clearer"></div>
|
|
</div>
|
|
<?php
|
|
|
|
require PUN_ROOT.'footer.php';
|
|
}
|
|
}
|
|
|
|
else if (isset($_POST['update'])) // Change position and name of the categories
|
|
{
|
|
confirm_referrer('admin_categories.php');
|
|
|
|
$categories = $_POST['cat'] ?? null;
|
|
if (! is_array($categories) || empty($categories))
|
|
message($lang_common['Bad request'], false, '404 Not Found');
|
|
|
|
foreach ($categories as $cat_id => $cur_cat)
|
|
{
|
|
$cur_cat['name'] = pun_trim($cur_cat['name'] ?? '');
|
|
$cur_cat['order'] = pun_trim($cur_cat['order'] ?? '');
|
|
|
|
if ($cur_cat['name'] == '')
|
|
message($lang_admin_categories['Must enter name message']);
|
|
|
|
if ($cur_cat['order'] == '' || preg_match('%[^0-9]%', $cur_cat['order']))
|
|
message($lang_admin_categories['Must enter integer message']);
|
|
|
|
$db->query('UPDATE '.$db->prefix.'categories SET cat_name=\''.$db->escape($cur_cat['name']).'\', disp_position='.intval($cur_cat['order']).' WHERE id='.intval($cat_id)) or error('Unable to update category', __FILE__, __LINE__, $db->error());
|
|
}
|
|
|
|
// Regenerate the quick jump cache
|
|
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
|
require PUN_ROOT.'include/cache.php';
|
|
|
|
generate_subforums_cache(); // MOD subforums - Visman
|
|
generate_quickjump_cache();
|
|
|
|
redirect('admin_categories.php', $lang_admin_categories['Categories updated redirect']);
|
|
}
|
|
|
|
// Generate an array with all categories
|
|
$result = $db->query('SELECT id, cat_name, disp_position FROM '.$db->prefix.'categories ORDER BY disp_position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
|
|
$cat_list = [];
|
|
|
|
while ($row = $db->fetch_assoc($result))
|
|
{
|
|
$cat_list[] = $row;
|
|
}
|
|
|
|
$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Categories']);
|
|
define('PUN_ACTIVE_PAGE', 'admin');
|
|
require PUN_ROOT.'header.php';
|
|
|
|
generate_admin_menu('categories');
|
|
|
|
?>
|
|
<div class="blockform">
|
|
<h2><span><?php echo $lang_admin_categories['Add categories head'] ?></span></h2>
|
|
<div class="box">
|
|
<form method="post" action="admin_categories.php">
|
|
<div class="inform">
|
|
<input type="hidden" name="csrf_hash" value="<?php echo csrf_hash() ?>" />
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_categories['Add categories subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<table class="aligntop">
|
|
<tr>
|
|
<th scope="row"><?php echo $lang_admin_categories['Add category label'] ?><div><input type="submit" name="add_cat" value="<?php echo $lang_admin_categories['Add new submit'] ?>" tabindex="2" /></div></th>
|
|
<td>
|
|
<input type="text" name="new_cat_name" size="35" maxlength="80" tabindex="1" />
|
|
<span><?php printf($lang_admin_categories['Add category help'], '<a href="admin_forums.php">'.$lang_admin_common['Forums'].'</a>') ?></span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
|
|
<?php if (!empty($cat_list)): ?> <h2 class="block2"><span><?php echo $lang_admin_categories['Delete categories head'] ?></span></h2>
|
|
<div class="box">
|
|
<form method="post" action="admin_categories.php">
|
|
<div class="inform">
|
|
<input type="hidden" name="csrf_hash" value="<?php echo csrf_hash() ?>" />
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_categories['Delete categories subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<table class="aligntop">
|
|
<tr>
|
|
<th scope="row"><?php echo $lang_admin_categories['Delete category label'] ?><div><input type="submit" name="del_cat" value="<?php echo $lang_admin_common['Delete'] ?>" tabindex="4" /></div></th>
|
|
<td>
|
|
<select name="cat_to_delete" tabindex="3">
|
|
<?php
|
|
|
|
foreach ($cat_list as $cur_cat)
|
|
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";
|
|
|
|
?>
|
|
</select>
|
|
<span><?php echo $lang_admin_categories['Delete category help'] ?></span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<?php endif; ?>
|
|
|
|
<?php if (!empty($cat_list)): ?> <h2 class="block2"><span><?php echo $lang_admin_categories['Edit categories head'] ?></span></h2>
|
|
<div class="box">
|
|
<form method="post" action="admin_categories.php">
|
|
<div class="inform">
|
|
<input type="hidden" name="csrf_hash" value="<?php echo csrf_hash() ?>" />
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_categories['Edit categories subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<table id="categoryedit">
|
|
<thead>
|
|
<tr>
|
|
<th class="tcl" scope="col"><?php echo $lang_admin_categories['Category name label'] ?></th>
|
|
<th scope="col"><?php echo $lang_admin_categories['Category position label'] ?></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
|
|
foreach ($cat_list as $cur_cat)
|
|
{
|
|
|
|
?>
|
|
<tr>
|
|
<td class="tcl"><input type="text" name="cat[<?php echo $cur_cat['id'] ?>][name]" value="<?php echo pun_htmlspecialchars($cur_cat['cat_name']) ?>" size="35" maxlength="80" /></td>
|
|
<td><input type="text" name="cat[<?php echo $cur_cat['id'] ?>][order]" value="<?php echo $cur_cat['disp_position'] ?>" size="3" maxlength="3" /></td>
|
|
</tr>
|
|
<?php
|
|
|
|
}
|
|
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
<div class="fsetsubmit"><input type="submit" name="update" value="<?php echo $lang_admin_common['Update'] ?>" /></div>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<?php endif; ?> </div>
|
|
<div class="clearer"></div>
|
|
</div>
|
|
<?php
|
|
|
|
require PUN_ROOT.'footer.php';
|