" :
"\t\t"; // 12/19/09, 1/1/10. 3/15/11
while ($row = stripslashes_deep($result_st->fetch_assoc())) {
if ($the_grp != $row['group']) {
$outstr .= ($i == 0)? "": "\t";
$the_grp = $row['group'];
$outstr .= "\t\t";
}
$sel = ($row['id']==$status_val_in)? " SELECTED": "";
$outstr .= "\t\t\t$row[$status_field] ";
$i++;
} // end while()
$outstr .= "\t\t \t\t ";
return $outstr;
}
function curr_regs() { // 10/18/11 Gets currently allocated or viewed regions
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 4 AND `resource_id` = ?;"; // 10/18/11
$result = db_query($query, [$_SESSION['user_id']]);
$al_groups = array();
while ($row = stripslashes_deep($result->fetch_assoc())) {
$al_groups[] = $row['group'];
}
if(array_key_exists('viewed_groups', $_SESSION)) {
$curr_viewed= explode(",",$_SESSION['viewed_groups']);
}
if(!isset($curr_viewed)) {
if(empty($al_groups)) { // catch for errors - no entries in allocates for the user. // 5/30/13
$where = "WHERE `{$GLOBALS['mysql_prefix']}allocates`.`type` = 3";
} else {
$x=0; // 6/10/11
$where = "WHERE (";
foreach($al_groups as $grp) {
$where2 = (count($al_groups) > ($x+1)) ? " OR " : ")";
$where .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where .= $where2;
$x++;
}
$where .= "AND `{$GLOBALS['mysql_prefix']}allocates`.`type` = 3"; // sets the region allocations searched for to type = 3 - Facilities.
}
} else {
if(empty($curr_viewed)) { // catch for errors - no entries in allocates for the user. // 5/30/13
$where = "WHERE `a`.`type` = 2";
} else {
$x=0; // 6/10/11
$where = "WHERE ("; // 6/10/11
foreach($curr_viewed as $grp) {
$where2 = (count($curr_viewed) > ($x+1)) ? " OR " : ")";
$where .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where .= $where2;
$x++;
}
$where .= "AND `{$GLOBALS['mysql_prefix']}allocates`.`type` = 3"; // sets the region allocations searched for to type = 3 - Facilities.
}
}
return $where;
}
function get_recfac_sel($unit_in, $tickid, $assign_id) { // 10/18/11 - Gets select menu for receiving facility control on mobile page
$where = curr_regs();
$query01 = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `{$GLOBALS['mysql_prefix']}assigns`.`id` = ? LIMIT 1";
$result01 = db_query($query01, [$assign_id]);
while ($row01 = stripslashes_deep($result01->fetch_assoc())) {
$curr_fac = $row01['rec_facility_id'];
}
$query02 = "SELECT *, `{$GLOBALS['mysql_prefix']}facilities`.`id` AS `fac_id`
FROM `{$GLOBALS['mysql_prefix']}facilities`
LEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` ON ( `{$GLOBALS['mysql_prefix']}facilities`.`id` = `{$GLOBALS['mysql_prefix']}allocates`.`resource_id` )
$where GROUP BY `{$GLOBALS['mysql_prefix']}facilities`.`id` ORDER BY `name` ASC";
$result02 = db_query($query02);
$guest = is_guest();
$dis = ($guest)? " DISABLED": "";
$i = 0;
$outstr = "\t\t";
if($curr_fac == 0) {
$outstr .= "\t\t\tNone Selected ";
} else {
$outstr .= "\t\t\tNone Selected ";
}
while ($row02 = stripslashes_deep($result02->fetch_assoc())) {
$sel = ($row02['fac_id'] == $curr_fac)? " SELECTED": "";
$outstr .= "\t\t\t" . $row02['name'] . " ";
$i++;
} // end while()
$outstr .= "\t\t ";
return $outstr;
}
function get_units_legend() { // returns string as centered span - 2/8/10
$query = "SELECT DISTINCT `type`, `icon`, `{$GLOBALS['mysql_prefix']}unit_types`.`name` AS `mytype` FROM `{$GLOBALS['mysql_prefix']}responder`
LEFT JOIN `{$GLOBALS['mysql_prefix']}unit_types` ON `{$GLOBALS['mysql_prefix']}unit_types`.`id` = `{$GLOBALS['mysql_prefix']}responder`.`type` ORDER BY `mytype`";
$result = db_query($query);
$out_str = " Units Types: ";
while ($row = stripslashes_deep($result->fetch_assoc())) {
$the_bg_color = array_key_exists($row['icon'], $GLOBALS['UNIT_TYPES_BG']) ? $GLOBALS['UNIT_TYPES_BG'][$row['icon']] : "#FFFFFF";
$the_text_color = array_key_exists($row['icon'], $GLOBALS['UNIT_TYPES_TEXT']) ? $GLOBALS['UNIT_TYPES_TEXT'][$row['icon']] : "000000";
$out_str .= " {$row['mytype']} ";
}
return $out_str .= " Warn Location Types: "; // 3/15/11
$warn_types = array();
foreach($GLOBALS['LOC_TYPES'] as $val) {
$warn_types[$val] = $GLOBALS['LOC_TYPES_NAMES'][$val];
}
foreach ($warn_types as $key => $value) {
$the_bg_color = array_key_exists($key, $GLOBALS['LOC_TYPES_BG']) ? $GLOBALS['LOC_TYPES_BG'][$key]: "#FFFFFF";
$the_text_color = array_key_exists($key, $GLOBALS['LOC_TYPES_TEXT']) ? $GLOBALS['LOC_TYPES_TEXT'][$key] : "#000000";
$theName = array_key_exists($key, $GLOBALS['LOC_TYPES_NAMES']) ? $GLOBALS['LOC_TYPES_NAMES'][$key] : "Error";
$out_str .= " {$theName} ";
}
return $out_str .= " Facilitiy types: "; // 3/15/11
while ($row = stripslashes_deep($result->fetch_array())) {
$the_bg_color = array_key_exists($row['icon'], $GLOBALS['FACY_TYPES_BG']) ? $GLOBALS['FACY_TYPES_BG'][$row['icon']] : "#FFFFFF";
$the_text_color = array_key_exists($row['icon'], $GLOBALS['FACY_TYPES_TEXT']) ? $GLOBALS['FACY_TYPES_TEXT'][$row['icon']] : "#000000";
$out_str .= " {$row['mytype']} ";
}
return $out_str .= " Status legend:
";
while ($row = stripslashes_deep($result->fetch_assoc())) {
$out_str .= "{$row['status_val']} ";
}
return $out_str .= "
{$tags_arr[4]} " . elapsed ($u2farr) . " ";}
if (is_date($u2fenr)) { return " {$tags_arr[3]} " . elapsed ($u2fenr) . " ";}
if (is_date($on_scene)) { return " {$tags_arr[2]} " . elapsed ($on_scene) . " ";}
if (is_date($responding)) { return " {$tags_arr[1]} " . elapsed ($responding) . " ";}
if (is_date($dispatched)) { return " {$tags_arr[0]} " . elapsed ($dispatched) . " ";}
}
function auto_disp_status($disp_status, $responder, $tick_id=0) { // 8/22/13
$now = mysql_format_date(time() - (intval(get_variable('delta_mins'))*60));
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}auto_disp_status` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$disp_status]);
if($result->num_rows >= 1) {
$row = stripslashes_deep($result->fetch_assoc());
$the_val = intval($row['status_val']);
$query2 = "UPDATE `{$GLOBALS['mysql_prefix']}responder` SET `un_status_id` = ?, `user_id` = '999999', `status_updated` = ?, `updated`= ? WHERE `id`= ?";
$result2 = db_query($query2, [$the_val, $now, $now, $responder]);
if($result2) {
$the_ret = $the_val;
do_log($GLOBALS['LOG_UNIT_STATUS'], $tick_id, $responder, $the_val);
} else {
$the_ret = 0;
}
} else {
$the_ret = 0;
}
return $the_ret;
}
// 5/11/2013 fix to remove '_on' change ' _by' to 'user_id' from set_u_updated () sql - 6/10/2013
function set_u_updated ($in_assign) { // given a disaptch record id, updates unit data - 9/1/10
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$in_assign]);
$row_temp = $result->fetch_assoc(); //
$now = mysql_format_date(time() - (intval(get_variable('delta_mins'))*60)); // 9/1/10
$user = trim($_SESSION['user_id']);
$result = db_query("UPDATE `{$GLOBALS['mysql_prefix']}responder` SET
`updated`= ?,
`user_id`= ?
WHERE `id`= ?",
[$now, $user, $row_temp['responder_id']]);
unset($result);
return true;
} // end function set_u_updated (
function short_ts($in_str){ // ex:10/29/10 12:22 - 10/2/10
return substr($in_str, -5);
}
function get_dist_factor() { // returns distance conversion factor - 11/24/10
$factors = array("0.6214", "0.6214", "1.0"); // factors as strings
return $factors[get_variable("locale")]; // US, UK, ROW
}
function get_speed ($instr, $inspeed) { // 11/26/10
if (!(is_int($inspeed))) {$the_class='unk';}
elseif ($inspeed >= 50) {$the_class='fast'; }
elseif ($inspeed == 0) {$the_class='stopped'; }
else {$the_class='moving'; }
return " {$instr} ";
}
function get_remote($url, $json=true) { // 11/26/10 , 4/23/11
if (function_exists("curl_init")) {
$ch = curl_init();
$timeout = 10;
curl_setopt($ch,CURLOPT_URL,$url);
$verify_ssl = get_variable('verify_ssl') !== '0'; // Default: verify SSL. Set verify_ssl=0 in settings to disable.
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, $verify_ssl);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, $verify_ssl ? 2 : 0);
curl_setopt($ch,CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
curl_setopt($ch,CURLOPT_TIMEOUT,$timeout);
$data = curl_exec($ch);
$curl_errno = curl_errno($ch);
$curl_error = curl_error($ch);
curl_close($ch);
if ($curl_errno > 0) {
print $curl_error . "
Intrusion attempt prevented! Intrusion attempt prevented! ";
$print .= "File Name Uploaded By Date ";
$filename = $row['filename'];
$origfilename = $row['orig_filename'];
$title = $row['title'];
$print .= "" . $row['title'] . " " . get_owner($row['_by']) . " ";
$print .= "" . format_date_2(strtotime($row['_on'])) . " ";
$print .= " ";
$bgcolor = ($bgcolor == "#EEEEEE") ? "#FEFEFE" : "#EEEEEE";
} // end while
$print .= "
";
} else {
$print = "";
$print .= " No Files
";
} // end else
return $print;
}
function add_sidebar($regions = true, $files = true, $messages = true, $controls = true, $more=false, $allowedit=false, $ticket_id = 0, $responder_id = 0, $facility_id = 0, $mi_id = 0) {
$theHeight = $_SESSION['scr_height'] / 2.5;
$theHeight2 = $theHeight * .8;
$theHeight3 = $theHeight * .58;
$use_twitter = (get_variable('twitter_consumerkey') != "" && get_variable('twitter_consumersecret') != "" && get_variable('twitter_accesstoken') != "" && get_variable('twitter_accesstokensecret') != "") ? true : false;
$print = "";
return $print;
}
function do_tweet($message) {
require_once '../lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
try {
$tweet = $twitter->send($message); // you can add $imagePath as second argument
return 1;
} catch (TwitterException $e) {
$log_message = "Error Sending Tweet. Error Details - " . $e->getMessage();
do_log($GLOBALS['LOG_ERROR'], 0, 0, $log_message);
}
}
function show_tweets() {
require_once './lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
$statuses = $twitter->load(Twitter::ME_AND_FRIENDS);
$print = "";
$print .= "";
return $print;
}
function show_rec_direc($count = 20) {
require_once './lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
$messages = $twitter->rec_direct($count);
$print = "";
$print .= "";
return $print;
}
function show_sent_direc($count = 20) {
require_once './lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
$messages = $twitter->sent_direct($count);
$print = "";
$print .= "";
return $print;
}
function do_tweet_direct($message, $userid = null, $screenname = null) {
require_once '../lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
if(($userid == null || $userid == "") && ($screenname == null || $screenname == "")) {
return false;
} else {
try {
$tweet = $twitter->direct($message, $userid, $screenname);
return 1;
} catch (TwitterException $e) {
$log_message = "Error Sending Tweet. Error Details - " . $e->getMessage();
do_log($GLOBALS['LOG_ERROR'], 0, 0, $log_message);
return $e->getMessage();
}
}
}
function send_tweet_direct($message, $userid = null, $screenname = null) {
require_once './lib/twitter/twitter.class.php';
$consumerKey = get_variable('twitter_consumerkey');
$consumerSecret = get_variable('twitter_consumersecret');
$accessToken = get_variable('twitter_accesstoken');
$accessTokenSecret = get_variable('twitter_accesstokensecret');
$twitter = new Twitter($consumerKey, $consumerSecret, $accessToken, $accessTokenSecret);
if(($userid == null || $userid == "") && ($screenname == null || $screenname == "")) {
return false;
} else {
try {
$tweet = $twitter->direct($message, $userid, $screenname);
return 1;
} catch (TwitterException $e) {
$log_message = "Error Sending Tweet. Error Details - " . $e->getMessage();
do_log($GLOBALS['LOG_ERROR'], 0, 0, $log_message);
return $e->getMessage();
}
}
}
function is_dir_empty($dir) {
if (!is_readable($dir)) return null;
$handle = opendir($dir);
while (false !== ($entry = readdir($handle))) {
if ($entry != "." && $entry != "..") {
return false;
}
}
return true;
}
function get_tile_bounds ($repository) {
// Try cached bounds from database first to avoid expensive filesystem scan.
// The 'bounds' setting is updated by update_localmap_boundary.php after tile
// downloads and by recalculate_tile_bounds() after tile changes. 3/14/26
$cached = get_variable('bounds');
if (!empty($cached)) {
$parts = explode(',', $cached);
if (count($parts) === 4) {
// bounds format: "bl_lat,bl_lon,tr_lat,tr_lon" → return [west, north, east, south]
return array(
floatval($parts[1]), // west (bl_lon)
floatval($parts[2]), // north (tr_lat)
floatval($parts[3]), // east (tr_lon)
floatval($parts[0]) // south (bl_lat)
);
}
}
// Fallback: scan filesystem (only reached if no cached bounds exist)
return scan_tile_bounds($repository);
} // end function
/**
* Scan the tile directory to compute geographic bounds from tile coordinates.
* This is expensive I/O on large tile sets — results should be cached via
* recalculate_tile_bounds(). All opendir() calls are guarded to prevent
* PHP warnings from flooding the error log. 3/14/26
*/
function scan_tile_bounds ($repository) {
if(!is_dir($repository) || is_dir_empty($repository)) {return false;}
if (!function_exists('tile2long')) {
function tile2long( $x, $z) {
$n = pow(2, $z);
return $x / $n * 360.0 - 180.0;
}
}
if (!function_exists('tile2lat')) {
function tile2lat( $y, $z) {
$n = pow(2, $z);
return rad2deg(atan(sinh(pi() * (1 - 2 * $y / $n))));
}
}
if (!function_exists('low_high_dir')) {
function low_high_dir ($path, $low = true) {
$dh = @opendir($path);
if ($dh === false) { return ($low) ? 99999 : 0; } // guard against missing dir
if ($low) { // find min
$return = 99999; // starter - see below
while (false !== ($filename = readdir($dh)) ) {
if ( intval($filename) > 0 && intval ($filename) < intval ($return ) ) {
$return = $filename ; // retain extension if file
}
} // end while ()
} else { //find max
$return = 0; // starter - see below
while (false !== ($filename = readdir($dh)) ) {
if ( intval($filename) > 0 && intval ($filename) > intval ($return ) ) {
$return = $filename ;
}
} // end while ()
} // end else
closedir($dh);
return $return;
} // end function
}
// 1. compute zoom
$dir = $repository;
$dh = @opendir($dir);
if ($dh === false) { return false; } // guard against missing dir
$zoom = 99; // starter - see below
while (false !== ($filename = readdir($dh)) ) {
if ( is_numeric ($filename ) && intval ($filename) < intval ($zoom ) ) { $zoom = intval ($filename) ; }
} // end while ()
closedir($dh);
if ($zoom === 99) { return false; } // no zoom directories found
// 2. compute west and east longs
$west = 99999; // set extremes
$east = 0;
$path = "{$dir}/{$zoom}";
$dh = @opendir($path);
if ($dh === false) { return false; } // guard against missing zoom dir
while (false !== ($filename = readdir($dh) ) ) { // walk down the selected zoom directory
if (is_numeric ($filename) ) {
if ( intval($filename ) < intval ($west) ) {$west = $filename;} // min
if ( intval($filename ) > intval ($east) ) {$east = $filename;} // max
} // end if (is_numeric () )
} // end while ()
closedir($dh);
// 3. compute northwest tile - OK
$path = "{$dir}/{$zoom}/{$west}";
$northwest = low_high_dir ($path, $low = true) ;
// 4. compute southeast tile
$path = "{$dir}/{$zoom}/{$east}";
$southeast = low_high_dir ($path, $low = false) ;
$west_long = round (tile2long( $west, $zoom), 6) ;
$north_lat = round (tile2lat( intval($northwest), $zoom), 6);
$east_long = round (tile2long( $east + 1, $zoom), 6); // note + 1
$south_lat = round (tile2lat( intval($southeast) + 1, $zoom), 6); // note + 1
return array($west_long, $north_lat, $east_long, $south_lat );
} // end function scan_tile_bounds
/**
* Recalculate tile bounds from the filesystem and cache the result in the
* database 'bounds' setting. Call this after tiles are added or removed. 3/14/26
*/
function recalculate_tile_bounds ($repository) {
$bounds = scan_tile_bounds($repository);
if ($bounds === false) {
// No tiles — clear the cached bounds
$query = "UPDATE `{$GLOBALS['mysql_prefix']}settings` SET `value`= '' WHERE `name` = 'bounds'";
db_query($query);
return false;
}
// Store as "south,west,north,east" (bl_lat,bl_lon,tr_lat,tr_lon)
$boundsString = $bounds[3] . "," . $bounds[0] . "," . $bounds[1] . "," . $bounds[2];
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}settings` WHERE `name`= 'bounds' LIMIT 1";
$result = db_query($query);
if ($result && $result->num_rows > 0) {
$query2 = "UPDATE `{$GLOBALS['mysql_prefix']}settings` SET `value`= ? WHERE `name` = 'bounds'";
db_query($query2, [$boundsString]);
}
return $bounds;
} // end function recalculate_tile_bounds
function checkColExists($table, $col) {
$safe_table = preg_replace('/[^a-zA-Z0-9_]/', '', $table);
$safe_col = preg_replace('/[^a-zA-Z0-9_]/', '', $col);
$query = "SHOW COLUMNS FROM `{$GLOBALS['mysql_prefix']}{$safe_table}` LIKE '{$safe_col}'";
$result = db_query($query);
if($result) {
return true;
} else {
return false;
}
}
function get_standard_messages() {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}std_msgs` ORDER BY `id` ASC";
$result = db_query($query);
while ($row = stripslashes_deep($result->fetch_assoc())) {
$ret_arr[$row['id']]['id'] = $row['id'];
$ret_arr[$row['id']]['name'] = $row['name'];
$ret_arr[$row['id']]['message'] = $row['message'];
}
return $ret_arr;
}
function get_standard_messages_sel() {
$sms_provider = get_msg_variable('smsg_provider');
$count = 0;
switch($sms_provider) {
case "0":
$chosen = "";
break;
case "1":
$chosen = "OR `smsresponder` = 1";
break;
case "2":
$chosen = "OR `txtlocal` = 1";
break;
case "3":
$chosen = "OR `mototrbo` = 1";
break;
case "4":
$chosen = "OR `smsbroadcast` = 1";
break;
default:
$chosen = "";
}
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}std_msgs` WHERE `email` = 1 {$chosen} ORDER BY `groupby`, `id` ASC";
$result = db_query($query);
$ret = "";
$the_grp = "";
while ($row = stripslashes_deep($result->fetch_array())) {
if ($the_grp != $row['groupby']) {
if($the_grp != "") {$ret .= "";}
$the_grp = $row['groupby'];
$ret .= "\n";
}
$ret .= "\t {$row['name']} \n";
} // end while()
$ret .= "\n \n";
return $ret;
}
function multi_array_key_exists($key, $array) {
if (array_key_exists($key, $array)) {
return true;
} else {
foreach ($array as $nested) {
if (is_array($nested) && multi_array_key_exists($key, $nested)) {
return true;
}
}
}
return false;
}
/* function valid_status($id) {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}un_status` WHERE `id` = " . $id;
$result = db_query($query);
if($result->num_rows > 0) {
return true;
} else {
return false;
}
}
function valid_fac_status($id) {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}fac_status` WHERE `id` = ?";
$result = db_query($query, [$id]);
if($result->num_rows > 0) {
return true;
} else {
return false;
}
} */
function get_roster($current=null) { // 9/6/13
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}personnel` ORDER BY `person_identifier`";
$result = db_query($query);
$the_ret = "";
$the_ret .= "Select a Person ";
while ($row = stripslashes_deep($result->fetch_assoc())) {
$sel = (($current) && ($current == $row['id'])) ? "SELECTED " : "";
$the_ret .= "" . $row['person_identifier'] . " ";
}
$the_ret .= " ";
return $the_ret;
}
function get_user_details($rosterID) { // 9/6/13
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}personnel` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$rosterID]);
if($result->num_rows != 0) {
$row = stripslashes_deep($result->fetch_assoc());
$the_ret = "Name: " . $row['forenames'] . " " . $row['surname'] . "";
if($id == null) {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}member`";
$result = db_query($query);
while($row = stripslashes_deep($result->fetch_assoc())) {
$theFlag = (get_member_already_assigned($row['id']) > 0) ? "background-color: red; color: white;'" : "";
$output .= "
";
return $output;
}
function get_member_contact_details($id) {
$ret_arr = array();
$query = "SELECT `field1`, `field2`, `field24`, `field25`, `field26` FROM `{$GLOBALS['mysql_prefix']}member` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$id]);
$row = stripslashes_deep($result->fetch_assoc());
foreach($row as $key => $val) {
$fieldid = substr($key, 5);
$fieldname = get_fieldlabel($fieldid);
$ret_arr[$fieldname] = $val;
}
return $ret_arr;
}
function get_member_full_details($id) {
$ret_arr = array();
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}member` WHERE `id` = ? LIMIT 1";
$result = db_query($query, [$id]);
$row = stripslashes_deep($result->fetch_assoc());
foreach($row as $key => $val) {
if($key != "_on" && $key != "_by" && $key != "_from" && $key != "id") {
$fieldid = substr($key, 5);
$fieldname = get_fieldlabel($fieldid);
if($fieldname == "Team") {
$ret_arr[$fieldname] = get_teamname($val);
} elseif($fieldname == "Member Status") {
$ret_arr[$fieldname] = get_status_name($id);
} elseif($fieldname == "Picture") {
if($val != "") {
$ret_arr[$fieldname] = "
";
}
}
}
function get_roadcondition_types() {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}conditions` ORDER BY `id`";
$result = db_query($query);
if($result && $result->num_rows > 0) {
return $result->num_rows;
} else {
return 0;
}
}
function get_tickets_status_select($selectname, $selected=null) {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}un_status`";
$result = $result = db_query($query);
if($result->num_rows > 0) {
$output = "";
$output .= "Select Unit Status ";
while ($row = $result->fetch_assoc()) {
$name = $row['status_val'];
$id = $row['id'];
$sel = ($row['id'] == $selected) ? "selected" : "";
$output .= "" . $name . " ";
}
$output .= " ";
} else {
$output = "ERROR";
}
return $output;
}
function get_mdb_status_select($selectname, $selected=null) {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}member_status`";
$result = $result = db_query($query);
if($result->num_rows > 0) {
$output = "";
$output .= "Select Member Status ";
while ($row = $result->fetch_assoc()) {
$name = $row['status_val'];
$id = $row['id'];
$sel = ($row['id'] == $selected) ? "selected" : "";
$output .= "" . $name . " ";
}
$output .= " ";
} else {
$output = "ERROR";
}
return $output;
}
if(checkColExists('std_msgs', 'name')) {$std_messages = get_standard_messages();}
?>
"; // 7/3/10
if (can_edit()){
if($show_ed_button) {
print "" . get_text("Edit") . "
";
}
if (!is_closed($ticket_id)) {
print "+ " . get_text("Action") . "
";
print "+ " . get_text("Patient") . "
";
}
print "" . get_text("Notify") . "
";
}
print "" . get_text("Print") . "
";
if (!is_guest()) { // 2/1/10
print "" . get_text("E-mail") . "
"; // 8/20/09
}
if (!is_unit()) { // 7/27/10
print "" . get_text("Dispatch") . "
"; // 3/30/10
}
}
print "