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') . "] [" . lang::p('delete') . "]"); } $db->free_result($resolutiones); $admin->row_span('', 'tfoot', 'center', 3); $admin->table_end(); $admin->form_end(); $admin->page_end(); } /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>