assign_res.php

<?php
/*
4/26/09 initial release
5/25/09 reset defined here to avoid need for current functions.inc.php
10/6/09 Added untries for new fields in assigns table u2fenr and u2farr (unit to facility status
7/28/10 Added inclusion of startup.inc.php for checking of network status and setting of file name variables to support no-maps versions of scripts.
9/1/10 set unit 'updated' time
6/20/12 don't apply NULL to `dispatched`
*/
error_reporting(E_ALL);

@session_start();
session_write_close();
require_once(isset($_SESSION['fip']) ? $_SESSION['fip'] : './incs/functions.inc.php');        //7/28/10
$now = "'" . mysql_format_date(time() - (get_variable('delta_mins')*60)) . "'";

/*
USERS: you may replace NULL with $now (EXACTLY THAT!) in the following sql query to meet local needs
*/

// 6/20/12
$frm_id = sanitize_int($_POST['frm_id']);
$query = "UPDATE `{$GLOBALS['mysql_prefix']}assigns` SET
    `responding` = NULL,
    `on_scene` = NULL,
    `u2fenr` = NULL,
    `u2farr` = NULL,
    `clear` = NULL,
    `as_of` = $now
    WHERE `id` = ? LIMIT 1;";

$result = db_query($query, [$frm_id]);
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$frm_id]);

$row = $result ? $result->fetch_assoc() : null;

do_log($GLOBALS['LOG_CALL_RESET'], $row['ticket_id'], $row['responder_id'], $row['id']);
set_u_updated ($frm_id);                                     // 9/1/10

unset($result);
?>