default: //no error $output .= ' <h1>' . lang("ticket", "browse_tickets") . '</h1>'; } unset($err); $output .= ' </div>'; $action = isset($_GET["action"]) ? $_GET["action"] : NULL; switch ($action) { case "browse_tickets": browse_tickets(); break; case "delete_tickets": delete_tickets(); break; case "edit_ticket": edit_ticket(); break; case "do_edit_ticket": do_edit_ticket(); break; case "do_mark_ticket": do_mark_ticket(); break; default: browse_tickets(); } unset($action); unset($action_permission); require_once "footer.php";
if (array_key_exists('id', $_GET)) { // 5/4/11 $_SESSION['active_ticket'] = $_GET['id']; $id = $_GET['id']; } elseif (array_key_exists('id', $_SESSION)) { $id = $_SESSION['active_ticket']; } else { echo "error at " . __LINE__; } // end if/else if (isset($_GET['action']) && $_GET['action'] == 'update') { /* update ticket */ if ($id == '' or $id <= 0 or !check_for_rows("SELECT * FROM {$GLOBALS['mysql_prefix']}ticket WHERE id='{$id}' LIMIT 1")) { print "<FONT CLASS=\"warn\">Invalid Ticket ID: '{$id}'</FONT>"; } else { edit_ticket($id); // post updated data } } else { if (isset($_GET['delete'])) { //delete ticket if ($_POST['frm_confirm']) { /* remove ticket and ticket actions */ $result = mysql_query("DELETE FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE ID='{$id}'") or do_error('edit.php::remove_ticket(ticket)', 'mysql_query() failed', mysql_error(), __FILE__, __LINE__); $result = mysql_query("DELETE FROM `{$GLOBALS['mysql_prefix']}action` WHERE ticket_id='{$id}'") or do_error('edit.php::remove_ticket(action)', 'mysql_query() failed', mysql_error(), __FILE__, __LINE__); print "<FONT CLASS=\"header\">Ticket '{$id}' has been removed.</FONT><BR /><BR />"; list_tickets(); } else { //confirm deletion print "<FONT CLASS='header'>Confirm ticket deletion</FONT><BR /><BR /><FORM METHOD='post' NAME = 'del_form' ACTION='" . basename(__FILE__) . "?id={$id}&delete=1&go=1'><INPUT TYPE='checkbox' NAME='frm_confirm' VALUE='1'>Delete ticket #{$id} <INPUT TYPE='Submit' VALUE='Confirm'></FORM>"; }