query('INSERT INTO '.$db->prefix.'categories (cat_name) VALUES(\''.escape($new_cat_name).'\')') or error('Unable to create category', __FILE__, __LINE__, $db->error());
redirect('admin_categories.php', 'Category added. Redirecting ...');
}
else if (isset($_POST['del_cat']) || isset($_POST['comply']))
{
confirm_referer('admin_categories.php');
$cat_to_delete = intval($_POST['cat_to_delete']);
if (empty($cat_to_delete))
message($lang_common['Bad request']);
if (isset($_POST['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());
$num_forums = $db->num_rows($result);
for ($i = 0; $i < $num_forums; $i++)
{
$cur_forum = $db->result($result, $i);
// Prune all posts and topics (start transaction)
prune($cur_forum, 1, -1);
// Delete the forum (end transaction)
$db->query('DELETE FROM '.$db->prefix.'forums WHERE id='.$cur_forum, PUN_TRANS_END) 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 OUTER 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());
$num_orphans = $db->num_rows($result);
if ($num_orphans)
{
for ($i = 0; $i < $num_orphans; $i++)
$orphans[] = $db->result($result, $i);
$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());
redirect('admin_categories.php', 'Category deleted. Redirecting ...');
}
else // If the user hasn't comfirmed the delete
{
$page_title = htmlspecialchars($options['board_title']).' / Admin / Categories';
require 'header.php';
admin_menu('categories');
?>
query('SELECT id, position FROM '.$db->prefix.'categories ORDER BY position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
$num_cats = $db->num_rows($result);
for ($i = 0; $i < $num_cats; $i++)
{
if ($cat_name[$i] == '')
message('You must enter a category name.');
if ($cat_order[$i] == '' || preg_match('/[^0-9]/', $cat_order[$i]))
message('Position must be an integer value.');
if ($admmod_only[$i] != '1')
$admmod_only[$i] = '0';
list($cat_id, $position) = $db->fetch_row($result);
$db->query('UPDATE '.$db->prefix.'categories SET cat_name=\''.escape($cat_name[$i]).'\', admmod_only=\''.$admmod_only[$i].'\', position='.$cat_order[$i].' WHERE id='.$cat_id) or error('Unable to update category', __FILE__, __LINE__, $db->error());
}
redirect('admin_categories.php', 'Category updated. Redirecting ...');
}
// Generate an array with all categories
$result = $db->query('SELECT id, cat_name, admmod_only, position FROM '.$db->prefix.'categories ORDER BY position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
$num_cats = $db->num_rows($result);
for ($i = 0; $i < $num_cats; $i++)
$cat_list[] = $db->fetch_row($result);
$page_title = htmlspecialchars($options['board_title']).' / Admin / Categories';
require 'header.php';
admin_menu('categories');
?>