userinfo['permissions'] & CANADMINFIELDS))
{
admin_login();
}
// ###################################################################
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] = 'modify';
}
// ###################################################################
if ($_REQUEST['do'] == 'kill')
{
sanitize(array('priorityid' => INT));
$DB_sql->query("DELETE FROM " . TABLE_PREFIX . "priority WHERE priorityid = $vars[priorityid]");
build_priorities();
$admin->redirect('priority.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'delete')
{
sanitize(array('priorityid' => INT));
$admin->page_confirm('Are you sure you want to delete this priority? Doing so will revert all bugs to the default priority (which is set in the options panel)?', 'priority.php?do=kill&priorityid=' . $vars['priorityid']);
}
// ###################################################################
if ($_POST['do'] == 'insert')
{
sanitize(array('priority' => STR, 'displayorder' => INT));
$DB_sql->query("INSERT INTO " . TABLE_PREFIX . "priority (priority, displayorder) VALUES ('" . addslasheslike($vars['priority']) . "', $vars[displayorder])");
build_priorities();
$admin->redirect('priority.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'add')
{
$admin->page_start('Add New Priority');
$admin->form_start('priority.php', 'insert');
$admin->table_start();
$admin->table_head('New Priority');
$admin->row_input('Priority Title
The title of this priority flag (eg: `Slated for Development` or `Address Now`)
', 'priority');
$admin->row_input('Display OrderThe order in which the priorities are displayed. The higher the number, the lower down in the list it is.
', 'displayorder');
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_POST['do'] == 'update')
{
sanitize(array('priorityid' => INT, 'priority' => STR, 'displayorder' => INT));
$DB_sql->query("UPDATE " . TABLE_PREFIX . "priority SET priority = '" . addslasheslike($vars['priority']) . "', displayorder = $vars[displayorder] WHERE priorityid = $vars[priorityid]");
build_priorities();
$admin->redirect('priority.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'edit')
{
sanitize(array('priorityid' => INT));
$priority = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX . "priority WHERE priorityid = $vars[priorityid]");
if (!is_array($priority))
{
$admin->error('-1');
}
$admin->page_start('Edit Priority');
$admin->form_start('priority.php', 'update');
$admin->form_hidden_field('priorityid', $priority['priorityid']);
$admin->table_start();
$admin->table_head("Edit Priority - $priority[priority] (priorityid: $priority[priorityid])");
$admin->row_input('Priority TitleThe title of this priority flag (eg: `Slated for Development` or `Address Now`)
', 'priority', $priority['priority']);
$admin->row_input('Display OrderThe order in which the priorities are displayed. The higher the number, the lower down in the list it is.
', 'displayorder', $priority['displayorder']);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_REQUEST['do'] == 'modify')
{
$admin->page_start('Priority Manager');
$priorities = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "priority ORDER BY displayorder");
$admin->form_start('priority.php', 'null');
$admin->table_start();
$admin->table_head('Priority Manager');
while ($priority = $DB_sql->fetch_array($priorities))
{
$admin->row_text("$priority[displayorder]: $priority[priority]", "(priorityid: $priority[priorityid]) [Edit] [Delete]");
}
$DB_sql->free_result($priorityes);
$admin->row_span('', 'tfoot', 'center', 3);
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>