query("DELETE FROM " . TABLE_PREFIX . "status WHERE statusid = " . intval($bugsys->in['statusid']));
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'delete')
{
$admin->page_confirm(lang::p('confirm_delete_status'), 'status.php?do=kill&statusid=' . intval($bugsys->in['statusid']));
}
// ###################################################################
if ($_POST['do'] == 'insert')
{
$db->query("INSERT INTO " . TABLE_PREFIX . "status (status, displayorder, color) VALUES ('" . $bugsys->in['status'] . "', " . intval($bugsys->in['displayorder']) . ", '" . $bugsys->in['color'] . "')");
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'add')
{
$admin->page_start(lang::p('add_new_status'));
$admin->form_start('status.php', 'insert');
$admin->table_start();
$admin->table_head(lang::p('new_status'));
$admin->row_input(lang::p('status_title'), 'status');
$admin->row_input(lang::p('status_display_order'), 'displayorder');
$admin->row_input(phraes('status_color'), 'color');
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_POST['do'] == 'update')
{
$db->query("UPDATE " . TABLE_PREFIX . "status SET status = '" . $bugsys->in['status'] . "', displayorder = " . intval($bugsys->in['displayorder']) . ", color = '" . $bugsys->in['color'] . "' WHERE statusid = " . intval($bugsys->in['statusid']));
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'edit')
{
$status = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "status WHERE statusid = " . intval($bugsys->in['statusid']));
if (!is_array($status))
{
$admin->error(lang::p('error_invalid_id'));
}
$admin->page_start(lang::p('edit_status'));
$admin->form_start('status.php', 'update');
$admin->form_hidden_field('statusid', $status['statusid']);
$admin->table_start();
$admin->table_head(lang::p('edit_status_title', $status['status'], $status['statusid']));
$admin->row_input(lang::p('status_title'), 'status', $status['status']);
$admin->row_input(lang::p('status_display_order'), 'displayorder', $status['displayorder']);
$admin->row_input(lang::p('status_color'), 'color', $status['color']);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_REQUEST['do'] == 'modify')
{
$admin->page_start('Status Manager');
$statuses = $db->query("SELECT * FROM " . TABLE_PREFIX . "status");
$admin->form_start('status.php', 'null');
$admin->table_start();
$admin->table_head('Status Manager');
while ($status = $db->fetch_array($statuses))
{
$colourblock = '';
$admin->row_text("$colourblock$status[displayorder]: $status[status]", "(statusid: $status[statusid]) " . lang::p('edit_wraplink') . " " . lang::p('delete_wraplink') . "");
}
$db->free_result($statuses);
$admin->row_span('', 'tfoot', 'center', 3);
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>