$start_mi = empty($temp) ? 0 : $temp; $temp = trim($frm_miles_onsc); // 12/9/10 $onsc_mi = empty($temp) ? 0 : $temp; $temp = trim($frm_miles_end); $end_mi = empty($temp) ? 0 : $temp; // 12/9/10 $query = sprintf("INSERT INTO `{$GLOBALS['mysql_prefix']}assigns` (`as_of`, `dispatched`, `ticket_id`, `responder_id`, `comments`, `start_miles`, `on_scene_miles`, `end_miles`, `user_id`)\n\t\t\t\t\t\t\t\tVALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)", quote_smart($now), quote_smart($now), quote_smart($frm_ticket_id), quote_smart($unit_ids[$i]), quote_smart($frm_comments), quote_smart($start_mi), quote_smart($onsc_mi), quote_smart($end_mi), quote_smart($frm_by_id)); $result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__); // apply status update to unit status do_log($GLOBALS['LOG_CALL_DISP'], $frm_ticket_id, $unit_ids[$i], 0); // 3/18/10 } // end for ($i=0; $i< count($unit_ids)-1; $i++) $to_str = $_POST['frm_contact_str']; handle_mail($to_str, $frm_ticket_id); // snap(basename(__FILE__), __LINE__); $query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00'"; // 2/12/09 $result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__); $lines = mysql_affected_rows(); unset($result); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE>Add Complete</TITLE> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
$query = "UPDATE `{$GLOBALS['mysql_prefix']}responder` SET\n\t\t\t\t\t`user_id`= " . quote_smart(trim($_SESSION['user_id'])) . ",\n\t\t\t\t\t`_by`= " . quote_smart(trim($_SESSION['user_id'])) . ",\n\t\t\t\t\t`_from`= " . quote_smart(trim($_SERVER['REMOTE_ADDR'])) . ",\n\t\t\t\t\t`_on`= " . quote_smart(trim($now)) . "\n\t\t\t\t\tWHERE `id` = " . quote_smart($frm_unit_id) . " LIMIT 1"; // 11/8/08 $result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__); do_log($GLOBALS['LOG_UNIT_STATUS'], $frm_ticket_id, $frm_unit_id, $frm_status_id); do_log($GLOBALS['LOG_CALL_DISP'], $frm_ticket_id, $frm_unit_id, $frm_status_id); // 3/18/10 } // end if (mysql_affected_rows()==0) $query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE `id` = " . quote_smart($frm_unit_id) . " LIMIT 1"; // 1/29/09 $result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__); $row = stripslashes_deep(mysql_fetch_array($result)); // snap(basename(__FILE__), __LINE__); $to_str = $row['contact_via']; // if (is_email($to_str)) { // 3/9/09 handle_mail($to_str, $frm_unit_id, $row['name'], $frm_ticket_id); // } // $host = $_SERVER['HTTP_HOST']; // 6/26/09 // $uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\'); // $extra = basename(__FILE__); // header("Location: http://$host$uri/$extra"); // finished - reload // exit; // ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE>Add Complete</TITLE> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT="">