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