query("DELETE FROM " . TABLE_PREFIX . "resolution WHERE resolutionid = " . intval($bugsys->in['resolutionid']));
build_resolutions();
$admin->redirect('resolution.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'delete')
{
$admin->page_confirm(lang::p('confirm_delete_resolution'), 'resolution.php?do=kill&resolutionid=' . intval($bugsys->in['resolutionid']));
}
// ###################################################################
if ($_POST['do'] == 'insert')
{
$db->query("INSERT INTO " . TABLE_PREFIX . "resolution (resolution, displayorder) VALUES ('" . $bugsys->in['resolution'] . "', " . intval($bugsys->in['displayorder']) . ")");
build_resolutions();
$admin->redirect('resolution.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'add')
{
$admin->page_start(lang::p('add_new_resolution'));
$admin->form_start('resolution.php', 'insert');
$admin->table_start();
$admin->table_head(lang::p('new_resolution'));
$admin->row_input(lang::p('resolution_title'), 'resolution');
$admin->row_input(lang::p('resolution_display_order'), 'displayorder');
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_POST['do'] == 'update')
{
$db->query("UPDATE " . TABLE_PREFIX . "resolution SET resolution = '" . $bugsys->in['resolution'] . "', displayorder = " . intval($bugsys->in['displayorder']) . " WHERE resolutionid = " . intval($bugsys->in['resolutionid']));
build_resolutions();
$admin->redirect('resolution.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'edit')
{
$resolution = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "resolution WHERE resolutionid = " . intval($bugsys->in['resolutionid']));
if (!is_array($resolution))
{
$admin->error(lang::p('error_invalid_id'));
}
$admin->page_start(lang::p('edit_resolution'));
$admin->form_start('resolution.php', 'update');
$admin->form_hidden_field('resolutionid', $resolution['resolutionid']);
$admin->table_start();
$admin->table_head(lang::p('edit_resolution_title', $resolution['resolution'], $resolution['resolutionid']));
$admin->row_input(lang::p('resolution_title'), 'resolution', $resolution['resolution']);
$admin->row_input(lang::p('resolution_display_order'), 'displayorder', $resolution['displayorder']);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_REQUEST['do'] == 'modify')
{
$admin->page_start(lang::p('resolution_manager'));
$resolutions = $db->query("SELECT * FROM " . TABLE_PREFIX . "resolution ORDER BY displayorder");
$admin->form_start('resolution.php', 'null');
$admin->table_start();
$admin->table_head(lang::p('resolution_manager'));
while ($resolution = $db->fetch_array($resolutions))
{
$admin->row_text("$resolution[displayorder]: $resolution[resolution]", "(resolutionid: $resolution[resolutionid]) " . lang::p('edit_wraplink') . " " . lang::p('delete_wraplink') . "");
}
$db->free_result($resolutiones);
$admin->row_span('', 'tfoot', 'center', 3);
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>