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 Order
The 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 Title
The title of this priority flag (eg: `Slated for Development` or `Address Now`)
', 'priority', $priority['priority']); $admin->row_input('Display Order
The 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$ || ################################################################### \*=====================================================================*/ ?>