function error_out($err_arg)
{
// 2/10/12
do_log($GLOBALS['LOG_ERROR'], 0, 0, $err_arg);
// logs supplied error message
echo "";
// ajax return data
exit;
// finished - die
}
/**
* In case of any error, redirect to a dummy page with error details
*/
function error_handler($errno, $errstr, $errfile, $errline)
{
global $cfg, $url;
do_log("Error at line {$errline} - {$errstr}. URL: {$url}");
if (!empty($cfg['config']['test_mode'])) {
// return error msg to client
echo '301:http://error-at-line-' . (int) $errline . '/' . urlencode($errstr) . "\n";
} else {
echo $url . "\n";
// fail silently
}
die;
}
function do_login($requested_page, $outinfo = FALSE, $hh = FALSE)
{
// do login/ses sion code - returns array - 2/12/09, 3/8/09
global $hide_dispatched, $hide_status_groups;
@session_start();
global $expiry, $istest;
$now = mysql_format_date(time() - intval(get_variable('delta_mins')) * 60);
$the_sid = isset($_SESSION['id']) ? $_SESSION['id'] : null;
// 7/3/11
$warn = array_key_exists('expires', $_SESSION) && $now > $_SESSION['expires'] ? "Log-in has expired due to inactivity. Please log in again." : "";
$internet = get_variable("internet");
// 8/22/10
$temp = implode(";", $_SESSION);
if (array_key_exists('user_id', $_SESSION) && is_expired($_SESSION['user_id'])) {
$the_date = mysql_format_date($expiry);
$sess_key = session_id();
// not expired
$query = "UPDATE `{$GLOBALS['mysql_prefix']}user` SET `expires`= '{$the_date}' WHERE `sid` = '{$sess_key}' LIMIT 1";
$result = mysql_query($query) or do_error("", 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$_SESSION['expires'] = $expiry;
$warn = "";
if ($internet == 3) {
set_filenames($internet);
}
// possible change to filenames based on connect status - 8/31/10
} else {
// not logged in; now either get form data or db check form entries
if (array_key_exists('frm_passwd', $_POST)) {
// first, db check
// 6/25/10
$categories = array();
// 3/15/11
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `clear` <> 'NULL'";
// 3/15/11
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_disp = mysql_num_rows($result);
//
if ($num_disp > 0 && $hide_dispatched == 1) {
$category_butts[0] = "Deployed";
$i = 1;
} else {
$i = 0;
}
if ($hide_status_groups == 1) {
// 3/15/11
$query = "SELECT DISTINCT `group` FROM `{$GLOBALS['mysql_prefix']}un_status` ORDER BY `group` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$categories[$i] = $row['group'];
$i++;
}
unset($result);
} else {
$categories[$i] = "Available";
$i++;
$categories[$i] = "Not Available";
}
$fac_categories = array();
$i = 0;
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}fac_types` ORDER BY `name` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$fac_categories[$i] = $row['name'];
$i++;
}
unset($result);
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}user` \n\t\t\t\tWHERE `user`=" . quote_smart($_POST['frm_user']) . " \t \n\t\t\t\tAND (`passwd`=PASSWORD(" . quote_smart($_POST['frm_passwd']) . ") \n\t\t\t\tOR `passwd`=MD5(" . quote_smart(strtolower($_POST['frm_passwd'])) . " )) \n\t\t\t\tLIMIT 1";
$result = mysql_query($query) or do_error("", 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
$row = stripslashes_deep(mysql_fetch_assoc($result));
if ($row['sortorder'] == NULL) {
$row['sortorder'] = "date";
}
$dir = $row['sort_desc'] ? " DESC " : "";
$sid = session_id();
// 1/8/10
$browser = checkBrowser(FALSE);
$the_date = mysql_format_date($expiry);
$query = "UPDATE `{$GLOBALS['mysql_prefix']}user` SET \n\t\t\t\t\t`sid` = '{$sid}', \n\t\t\t\t\t`expires`= '{$the_date}', \n\t\t\t\t\t`login` = '{$now}', \n\t\t\t\t\t`_from`= '{$_SERVER['REMOTE_ADDR']}', \n\t\t\t\t\t`browser` = '{$browser}' \n\t\t\t\t\tWHERE `id` = {$row['id']} LIMIT 1";
$result = mysql_query($query) or do_error("", 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$_SESSION['id'] = $sid;
$_SESSION['expires'] = time();
$_SESSION['user_id'] = $row['id'];
$_SESSION['user'] = $row['user'];
$_SESSION['level'] = $row['level'];
$_SESSION['login_at'] = $now;
$_SESSION['scr_height'] = $_POST['scr_height'];
$_SESSION['scr_width'] = $_POST['scr_width'];
// monitor dimensions this user
$_SESSION['allow_dirs'] = TRUE;
// allow directions
$_SESSION['show_closed'] = TRUE;
// show closed dispatched
$_SESSION['sortorder'] = $row['sortorder'] == NULL ? "date" : $row['sortorder'];
$_SESSION['sort_desc'] = $row['sort_desc'] == NULL ? " DESC " : $row['sort_desc'];
$_SESSION['ticket_per_page'] = 0;
$_SESSION['show_hide_unit'] = "s";
// show/hide units
$_SESSION['show_hide_unav'] = "s";
// show/hide unavailable units - 4/27/10
$_SESSION['show_hide_fac'] = "h";
// show/hide facilities - 3/8/10
$_SESSION['unit_flag_1'] = "";
// unit id where status or position change
$_SESSION['unit_flag_2'] = "";
// usage tbd 4/7/10
$_SESSION['tick_flag_1'] = "";
// usage tbd 4/7/10
$_SESSION['tick_flag_2'] = "";
// usage tbd 4/7/10
$_SESSION['fac_flag_2'] = 2;
// 2/16/11
$_SESSION['list_type'] = 0;
// 12/2/10
$_SESSION['show_hide_Deployed'] = "s";
// Show all deployed tickets 3/15/11
$_SESSION['day_night'] = $_POST['frm_daynight'];
// 01/20/11 Set Day or Night Colors
$_SESSION['hide_controls'] = "s";
// 3/15/11
$_SESSION['incs_list'] = "s";
// 3/15/11
$_SESSION['resp_list'] = "s";
// 3/15/11
$_SESSION['facs_list'] = "s";
// 3/15/11
$_SESSION['regions_boxes'] = "s";
// 6/10/11
$_SESSION['user_unit_id'] = $row['responder_id'];
//3/19/11
$_SESSION['show_hide_upper'] = "Show Menu";
//6/10/11
foreach ($categories as $key => $value) {
// 3/15/11
$sess_flag = "show_hide_" . $value;
$_SESSION[$sess_flag] = "s";
}
foreach ($fac_categories as $key => $value) {
// 3/15/11
$fac_sess_flag = "show_hide_fac_" . $value;
$_SESSION[$fac_sess_flag] = "h";
}
$temp = implode(";", $_SESSION);
set_filenames($internet);
// 8/31/10
do_log($GLOBALS['LOG_SIGN_IN'], 0, 0, $row['id']);
// log it
// 7/21/10
$query = "DELETE FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE `status` = {$GLOBALS['STATUS_RESERVED']} AND `_by` = {$_SESSION['user_id']};";
$result = mysql_query($query);
$to = "";
$subject = "Tickets Login";
$message = "From: " . gethostbyaddr($_SERVER['REMOTE_ADDR']) . "\nBrowser:" . $_SERVER['HTTP_USER_AGENT'];
$message .= "\nBy: " . $_POST['frm_user'];
$message .= "\nScreen: " . $_POST['scr_width'] . " x " . $_POST['scr_height'];
$message .= "\nReferrer: " . $_POST['frm_referer'];
// @mail ($to, $subject, $message); // 1/11/09
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');
$host = $_SERVER['HTTP_HOST'];
$uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$unit_id = get_unit();
// 3/19/11
$level = $row['level'];
if ($level == $GLOBALS['LEVEL_UNIT']) {
// 3/1/12
$extra = 'mobile.php';
} else {
if ($level == $GLOBALS['LEVEL_STATS']) {
$extra = 'stats_scr.php?stats=stats';
} else {
$extra = 'main.php?log_in=1';
}
}
// $extra = (($row['level']== $GLOBALS['LEVEL_UNIT']) ||($unit_id))? 'mobile.php' : 'main.php?log_in=1'; // 8/29/10
header("Location: http://{$host}{$uri}/{$extra}");
// to top of calling script
exit;
}
// end if (mysql_affected_rows()==1)
}
// end if((!empty($_POST))&&(check_for_rows(...)
// if no form data or values fail
@session_destroy();
// 4/29/10
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD><TITLE>Tickets - free open source computer-aided dispatch software (CAD)</TITLE>
<META HTTP-EQUIV=="Description" CONTENT="free, open source, CAD, dispatch, emergency response, ARES Teams, RACES Teams, amateur radio " />
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<META HTTP-EQUIV="Expires" CONTENT="0">
<META HTTP-EQUIV="Cache-Control" CONTENT="NO-CACHE">
<META HTTP-EQUIV="Pragma" CONTENT="NO-CACHE">
<META HTTP-EQUIV="Content-Script-Type" CONTENT="text/javascript">
<META HTTP-EQUIV="Script-date" CONTENT="1/23/10">
<LINK REL=StyleSheet HREF="stylesheet.php?version=<?php
print time();
?>
" TYPE="text/css"> <!-- 3/15/11 -->
<STYLE type="text/css">
input {background-color:transparent;} /* Benefit IE radio buttons */
</STYLE>
<SCRIPT defer="defer"> <!-- 11/18/10 -->
String.prototype.trim = function () {
return this.replace(/^\s*(\S*(\s+\S+)*)\s*$/, "$1");
};
function getBrowserWidth(){
var val="";
if (window.innerWidth){
var val= window.innerWidth;}
else if (document.documentElement && document.documentElement.clientWidth != 0){
var val= document.documentElement.clientWidth; }
else if (window.screen.width && window.screen.width != 0){
var val= window.screen.width; }
else if (document.body){var val= document.body.clientWidth;}
return(isNaN(val))? 1024: val;
}
function getBrowserHeight(){
var val="";
if (window.innerHeight){
var val= window.innerHeight;}
else if (document.documentElement && document.documentElement.clientHeight != 0){
var val= document.documentElement.clientHeight; }
else if (window.screen.height && window.screen.height != 0){
var val= window.screen.height; }
else if (document.body){var val= document.body.clientHeight;}
return(isNaN(val))? 740: val;
}
function Set_Cookie( name, value, expires, path, domain, secure ) {
var today = new Date(); // set time in milliseconds
today.setTime( today.getTime() );
if ( expires ) {
expires = expires * 1000 * 60 ;
}
var expires_date = new Date( today.getTime() + (expires) );
document.cookie = name + "=" +escape( value ) +
( ( expires ) ? ";expires=" + expires_date.toGMTString() : "" ) + //expires.toGMTString()
( ( path ) ? ";path=" + path : "" ) +
( ( domain ) ? ";domain=" + domain : "" ) +
( ( secure ) ? ";secure" : "" );
}
// if the expires variable is set, make the correct expires time, the
// current script below will set it for x number of days, to make it
// for hours, delete * 24, for minutes, delete * 60 * 24
// alert('expires ' + expires_date.toGMTString());// this is for testing purposes only
// alert( 'today ' + today.toGMTString() );// this is for testing purpose only
function Get_Cookie( check_name ) {
var a_all_cookies = document.cookie.split( ';' ); // first we'll split this cookie up into name/value pairs
var a_temp_cookie = ''; // note: document.cookie only returns name=value, not the other components
var cookie_name = '';
var cookie_value = '';
var b_cookie_found = false; // set boolean t/f default f
var i = '';
for ( i = 0; i < a_all_cookies.length; i++ ) {
a_temp_cookie = a_all_cookies[i].split( '=' ); // plit each name=value pair
cookie_name = a_temp_cookie[0].replace(/^\s+|\s+$/g, ''); // and trim left/right whitespace
if ( cookie_name == check_name ){ // if the extracted name matches passed check_name
b_cookie_found = true;
if ( a_temp_cookie.length > 1 ){ // we need to handle case where cookie has no value but exists (no = sign, that is):
cookie_value = unescape( a_temp_cookie[1].replace(/^\s+|\s+$/g, '') );
}
return cookie_value;// note that in cases where cookie is initialized but no value, null is returned
break;
}
a_temp_cookie = null;
cookie_name = '';
}
if ( !b_cookie_found ) {
return null;
}
} // end function Get_Cookie(
function do_hh_onload () { // 2/24/09
document.login_form.scr_width.value=getBrowserWidth();
document.login_form.scr_height.value=getBrowserHeight();
document.login_form.frm_user.focus();
} // end function
function do_onload () {
if (this.window.name!="main") {self.close();} // in a popup
if(self.location.href==parent.location.href) { // prevent frame jump
self.location.href = 'index.php';
};
try { // should always be true
parent.frames["upper"].document.getElementById("whom").innerHTML = "<?php
echo NOT_STR;
?>
" ;
parent.frames["upper"].document.getElementById("level").innerHTML = "<?php
echo NA_STR;
?>
" ;
parent.frames["upper"].document.getElementById("script").innerHTML = "login";
}
catch(e) {
}
document.login_form.scr_width.value=screen.width; // 1/23/10
document.login_form.scr_height.value=screen.height;
// document.login_form.frm_user.focus();
// parent.upper.hide_butts(); // 1/21/09
} // end function do onload ()
<?php
if (get_variable('call_board') == 2) {
// 7/7/09
?>
try { // 8/10/10
parent.calls.location.href = 'board.php';
}
catch (e) {
}
<?php
// print "\tparent.calls.location.href = 'board.php';\n"; // reload to show 'waiting' message 6/19/09
}
print "\tparent.upper.location.href = 'top.php';\n";
// reload and initialize top frame 6/19/09
?>
window.setTimeout("document.forms[0].frm_user.focus()", 1000);
</SCRIPT>
</HEAD>
<?php
print $hh ? "\n\t<BODY onLoad = 'do_hh_onload()'>\n" : "\n\t<BODY onLoad = 'do_onload()'>\n";
// 2/24/09
?>
<!-- <BODY onLoad = "do_onload()"> 11/6/10 -->
<CENTER><BR />
<?php
if (get_variable('_version') != '') {
print "<SPAN style='FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #000000;'>" . get_variable('login_banner') . "</SPAN><BR /><BR />";
}
?>
</FONT>
<FORM METHOD="post" ACTION="<?php
print $requested_page;
?>
" NAME="login_form" onSubmit="return true;">
<TABLE BORDER=0>
<?php
if (array_key_exists('frm_passwd', $_POST)) {
$warn = "Login failed. Pls enter correct values and try again.";
}
if (!empty($warn)) {
print "<TR CLASS='odd'><TH COLSPAN='99'><FONT CLASS='warn'>\n\t\t\t{$warn}\n\t\t\t</FONT><BR /><BR /></TH></TR>";
}
$temp = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : "";
$my_click = $_SERVER["HTTP_HOST"] == "127.0.0.1" ? " onClick = \"document.login_form.frm_user.value='admin';document.login_form.frm_passwd.value='admin';\"" : "";
// print (array_key_exists ('frm_user', $_POST))? $_POST['frm_user'] . "/" : "";
// print (array_key_exists ('frm_passwd', $_POST))? $_POST['frm_passwd']: "";
?>
<TR CLASS='even'><TD ROWSPAN=6 VALIGN='middle' ALIGN='left' bgcolor=#EFEFEF><BR /><BR /> <IMG BORDER=0 SRC='open_source_button.png' <?php
print $my_click;
?>
><BR /><BR />
<img src="php.png" /> </TD><TD CLASS="td_label"><?php
print get_text("User");
?>
:</TD>
<TD><INPUT TYPE="text" NAME="frm_user" MAXLENGTH="255" SIZE="30" onChange = "document.login_form.frm_user.value = document.login_form.frm_user.value.trim();" VALUE=""></TD></TR>
<TR CLASS='odd'><TD CLASS="td_label"><?php
print get_text("Password");
?>
: </TD>
<TD><INPUT TYPE="password" NAME="frm_passwd" MAXLENGTH="255" SIZE="30" onChange = "document.login_form.frm_passwd.value = document.login_form.frm_passwd.value.trim();" VALUE=""></TD></TR>
<TR CLASS="even"><TD COLSPAN=2> </TD></TR>
<TR CLASS='odd'><TD CLASS="td_label">Colors: </TD>
<TD><INPUT TYPE="radio" NAME="frm_daynight" VALUE="Day" checked>Day <INPUT TYPE="radio" NAME="frm_daynight" value="Night">Night</TD></TR>
<TR CLASS="even"><TD COLSPAN=2> </TD></TR>
<TR CLASS='even'><TD></TD><TD><INPUT TYPE="submit" VALUE="<?php
print get_text("Log In");
?>
"></TD></TR>
<TR CLASS='even'><TD COLSPAN=3 ALIGN='center'><BR /> Visitors may login as <B>guest</B> with password <B>guest</B>. </TD></TR>
<TR CLASS='even'><TD COLSPAN=3> </TD></TR>
<TR CLASS='even'><TD COLSPAN=3> </TD></TR>
</TABLE>
<INPUT TYPE='hidden' NAME = 'scr_width' VALUE=''>
<INPUT TYPE='hidden' NAME = 'scr_height' VALUE=''>
<INPUT TYPE='hidden' NAME = 'frm_referer' VALUE="<?php
print $temp;
?>
">
</FORM><BR /><BR />
<a href="http://www.ticketscad.org/"><SPAN CLASS='text_small'>Tickets CAD Project home</SPAN></a>
</CENTER></HTML>
<?php
exit;
// no return value
}
}
$frm_lng = empty($_POST['frm_lng']) ? 'NULL' : quote_smart(trim($_POST['frm_lng']));
// 7/15/10
$now = mysql_format_date(time() - get_variable('delta_mins') * 60);
$query = "INSERT INTO `{$GLOBALS['mysql_prefix']}facilities` (\n\t\t\t`name`, `street`, `city`, `state`, `handle`, `icon_str`, `boundary`, `description`, `capab`, `status_id`, `contact_name`, `contact_email`, `contact_phone`, `security_contact`, `security_email`, `security_phone`, `opening_hours`, `access_rules`, `security_reqs`, `pager_p`, `pager_s`, `lat`, `lng`, `type`, `user_id`, `updated` )\n\t\t\tVALUES (" . quote_smart(trim($_POST['frm_name'])) . "," . quote_smart(trim($_POST['frm_street'])) . "," . quote_smart(trim($_POST['frm_city'])) . "," . quote_smart(trim($_POST['frm_state'])) . "," . quote_smart(trim($_POST['frm_handle'])) . "," . quote_smart(trim($_POST['frm_icon_str'])) . "," . quote_smart(trim($_POST['frm_boundary'])) . "," . quote_smart(trim($_POST['frm_descr'])) . "," . quote_smart(trim($_POST['frm_capab'])) . "," . quote_smart(trim($_POST['frm_status_id'])) . "," . quote_smart(trim($_POST['frm_contact_name'])) . "," . quote_smart(trim($_POST['frm_contact_email'])) . "," . quote_smart(trim($_POST['frm_contact_phone'])) . "," . quote_smart(trim($_POST['frm_security_contact'])) . "," . quote_smart(trim($_POST['frm_security_email'])) . "," . quote_smart(trim($_POST['frm_security_phone'])) . "," . quote_smart(trim($_POST['frm_opening_hours'])) . "," . quote_smart(trim($_POST['frm_access_rules'])) . "," . quote_smart(trim($_POST['frm_security_reqs'])) . "," . quote_smart(trim($_POST['frm_pager_p'])) . "," . quote_smart(trim($_POST['frm_pager_s'])) . "," . $frm_lat . "," . $frm_lng . "," . quote_smart(trim($_POST['frm_type'])) . "," . quote_smart(trim($_SESSION['user_id'])) . "," . quote_smart(trim($now)) . ");";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
$new_id = mysql_insert_id();
$status_id = $_POST['frm_status_id'];
//4/14/11
foreach ($_POST['frm_group'] as $grp_val) {
// 6/10/11
if (test_allocates($new_id, $grp_val, 3)) {
$query_a = "INSERT INTO `{$GLOBALS['mysql_prefix']}allocates` (`group` , `type`, `al_as_of` , `al_status` , `resource_id` , `sys_comments` , `user_id`) VALUES \n\t\t\t\t\t({$grp_val}, 3, '{$now}', {$status_id}, {$new_id}, 'Allocated to Group' , {$by})";
$result_a = mysql_query($query_a) or do_error($query_a, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
}
do_log($GLOBALS['LOG_FACILITY_ADD'], 0, mysql_insert_id(), $_POST['frm_status_id']);
// 2/17/11
$caption = "<B>Facility <i>" . stripslashes_deep($_POST['frm_name']) . "</i> data has been updated.</B><BR /><BR />";
finished($caption);
// wrap it up
}
// end if ($_getgoadd == 'true')
// add ===========================================================================================================================
// add ===========================================================================================================================
// add ===========================================================================================================================
if ($_getadd == 'true') {
print do_calls();
// call signs to JS array for validation
?>
</HEAD>
<BODY onLoad = "ck_frames();" onUnload="GUnload()">
function do_notify() {
return;
} // end function do notify()
</SCRIPT>
<?php
}
print "</HTML>";
// 10/19/08
}
// end else ...
// ________________________________________________________
exit;
} else {
if ($get_action == 'delete') {
if (array_key_exists('confirm', $_GET)) {
do_log($GLOBALS['LOG_PATIENT_DELETE'], $_GET['ticket_id'], 0, $_GET['id']);
// 3/18/10
// ($code, $ticket_id=0, $responder_id=0, $info="", $facility_id=0, $rec_facility_id=0, $mileage=0) { // generic log table writer - 5/31/08, 10/6/09
$query = "DELETE FROM `{$GLOBALS['mysql_prefix']}patient` WHERE `id`='{$_GET['id']}' LIMIT 1";
$result = mysql_query($query) or do_error('', $query, mysql_error(), basename(__FILE__), __LINE__);
?>
<script>
setTimeout("document.next_Form.submit()",1500);
</script>
<?php
print "<FONT CLASS='header'>{$patient} record deleted</FONT><BR /><BR />";
} else {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}patient` WHERE `id`='{$_GET['id']}' LIMIT 1";
$result = mysql_query($query) or do_error($query, $query, mysql_error(), basename(__FILE__), __LINE__);
$row = stripslashes_deep(mysql_fetch_assoc($result));
print "<FONT CLASS='header'>Really delete {$patient} record ' " . shorten($row['description'], 24) . "' ?</FONT><BR /><BR />";
function do_notify() {
return;
} // end function do notify()
</SCRIPT>
<?php
}
print "</HTML>";
// 10/19/08
}
// end else ...
// ____________________________________________________
exit;
} else {
if ($get_action == 'delete') {
if (array_key_exists('confirm', $_GET)) {
do_log($GLOBALS['LOG_ACTION_DELETE'], $_GET['ticket_id'], 0, $_GET['id']);
// 8/7/08
// ($code, $ticket_id=0, $responder_id=0, $info="", $facility_id=0, $rec_facility_id=0, $mileage=0) { // generic log table writer - 5/31/08, 10/6/09
$result = mysql_query("DELETE FROM `{$GLOBALS['mysql_prefix']}action` WHERE `id`='{$_GET['id']}' LIMIT 1") or do_error('', 'mysql_query', mysql_error(), basename(__FILE__), __LINE__);
print '<FONT CLASS="header">Action deleted</FONT><BR /><BR />';
add_header($_GET['ticket_id']);
show_ticket($_GET['ticket_id']);
} else {
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}action` WHERE `id`='{$_GET['id']}' LIMIT 1";
$result = mysql_query($query) or do_error($query, $query, mysql_error(), basename(__FILE__), __LINE__);
$row = stripslashes_deep(mysql_fetch_assoc($result));
print "<FONT CLASS='header'>Really delete action record '" . shorten($row['description'], 24) . "' ? </FONT><BR /><BR />";
print "<FORM NAME='delfrm' METHOD='post' ACTION='action_w.php?action=delete&id={$_GET['id']}&ticket_id=" . $_GET['ticket_id'] . "&confirm=1'>";
print "<INPUT TYPE='Submit' VALUE='Yes'> ";
print "<INPUT TYPE='Button' VALUE='Cancel' onClick='history.back();'></FORM>";
}
function get_cast_mdata_pull($ctx_age, $cast_mdata_ctx)
{
$cast_name = $cast_mdata_ctx['name'];
// sanity check - $cast_mdata_ctx['type'] MUST be "pull"
assert($cast_mdata_ctx['type'] == "pull");
do_log("slota");
do_log("ctx_age=" . $ctx_age);
do_log("cast_mdata_ctx=" . print_r($cast_mdata_ctx, true));
// get the casti_srv_uri directly from $cast_mdata_ctx['arg'];
$casti_srv_uri = $cast_mdata_ctx['arg'];
// forward the xmlrpc to casti_srv_uri
$client = new IXR_Client($casti_srv_uri);
// $client->debug = true;
if (!$client->query('get_cast_mdata', $cast_name)) {
// delete the context file if it is now unreachable
// unlink(cast_name_to_filepath($cast_name));
// forward the error to the caller
return new IXR_Error($client->getErrorCode(), "slotaIXR" . $client->getErrorMessage());
}
// get the cast_mdata
$cast_mdata = $client->getResponse();
// return the $cast_mdata
return $cast_mdata;
}
function log_info($syslog_message)
{
do_log($syslog_message, LOG_INFO);
}
function check_couchdb($testhost)
{
$host = false;
$pingt = exec("fping -t 30 " . $testhost);
if ($pingt == $testhost . ' is alive') {
$ret = json_decode(check_http('http://' . $testhost . ':5984', 2), TRUE);
do_log("Check couchdb:" . $testhost . ":5984/", 'd', __FILE__, __FUNCTION__, __LINE__);
if ($ret['couchdb'] == 'Welcome' && $ret['version'] == '1.1.1') {
return $testhost;
} else {
do_log("FAILED couchdb:" . $testhost, '', __FILE__, __FUNCTION__, __LINE__);
}
} else {
do_log("FAILED fping:" . $pingt . " -t 50 ip=" . $testhost, '', __FILE__, __FUNCTION__, __LINE__);
}
return false;
}
$ogts = empty($_POST['frm_ogts']) ? 0 : quote_smart(trim($_POST['frm_ogts']));
$now = mysql_format_date(time() - get_variable('delta_mins') * 60);
// 1/27/09
$query = "INSERT INTO `{$GLOBALS['mysql_prefix']}responder` (\n\t\t\t`name`, `street`, `city`, `state`, `phone`, `handle`, `icon_str`, `description`, `capab`, `un_status_id`, `callsign`, `mobile`, `multi`, `aprs`, `instam`, `locatea`, `gtrack`, `glat`, `t_tracker`, `ogts`, `ring_fence`, `excl_zone`, `direcs`, `contact_name`, `contact_via`, `lat`, `lng`, `type`, `user_id`, `updated` )\n\t\t\tVALUES (" . quote_smart(trim($_POST['frm_name'])) . "," . quote_smart(trim($_POST['frm_street'])) . "," . quote_smart(trim($_POST['frm_city'])) . "," . quote_smart(trim($_POST['frm_state'])) . "," . quote_smart(trim($_POST['frm_phone'])) . "," . quote_smart(trim($_POST['frm_handle'])) . "," . quote_smart(trim($_POST['frm_icon_str'])) . "," . quote_smart(trim($_POST['frm_descr'])) . "," . quote_smart(trim($_POST['frm_capab'])) . "," . quote_smart(trim($_POST['frm_un_status_id'])) . "," . quote_smart(trim($_POST['frm_callsign'])) . "," . quote_smart(trim($_POST['frm_mobile'])) . "," . quote_smart(trim($_POST['frm_multi'])) . "," . quote_smart(trim($_POST['frm_aprs'])) . "," . quote_smart(trim($_POST['frm_instam'])) . "," . quote_smart(trim($_POST['frm_locatea'])) . "," . quote_smart(trim($_POST['frm_gtrack'])) . "," . quote_smart(trim($_POST['frm_glat'])) . "," . quote_smart(trim($_POST['frm_t_tracker'])) . "," . quote_smart(trim($_POST['frm_ogts'])) . "," . quote_smart(trim($_POST['frm_ringfence'])) . "," . quote_smart(trim($_POST['frm_excl_zone'])) . "," . quote_smart(trim($_POST['frm_direcs'])) . "," . quote_smart(trim($_POST['frm_contact_name'])) . "," . quote_smart(trim($_POST['frm_contact_via'])) . "," . $frm_lat . "," . $frm_lng . "," . quote_smart(trim($_POST['frm_type'])) . "," . quote_smart(trim($_SESSION['user_id'])) . "," . quote_smart(trim($now)) . ");";
// 8/23/08, 5/11/11
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
$new_id = mysql_insert_id();
$status_id = $_POST['frm_un_status_id'];
foreach ($_POST['frm_group'] as $grp_val) {
// 6/10/11
if (test_allocates($new_id, $grp_val, 2)) {
$query_a = "INSERT INTO `{$GLOBALS['mysql_prefix']}allocates` (`group` , `type`, `al_as_of` , `al_status` , `resource_id` , `sys_comments` , `user_id`) VALUES \n\t\t\t\t\t\t({$grp_val}, 2, '{$now}', {$status_id}, {$new_id}, 'Allocated to Group' , {$by})";
$result_a = mysql_query($query_a) or do_error($query_a, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
}
do_log($GLOBALS['LOG_UNIT_STATUS'], 0, mysql_insert_id(), $_POST['frm_un_status_id']);
// 6/2/08
$caption = "<B>Unit <i>" . stripslashes_deep($_POST['frm_name']) . "</i> data has been applied </B><BR /><BR />";
}
// end if ($_getgoadd == 'true')
// add ===========================================================================================================================
// add ===========================================================================================================================
// add ===========================================================================================================================
if ($_getadd == 'true') {
print do_calls();
// call signs to JS array for validation
?>
</HEAD>
<BODY onLoad = "ck_frames();" onUnload="GUnload()"> <!-- <?php
print __LINE__;
?>
<?php
/*
3/15/11 Created from as_up_un_status.php to allow change of facility status through situation screen
*/
error_reporting(E_ALL);
// file as_up_fac_status.php
@session_start();
require_once $_SESSION['fip'];
//snap(basename(__FILE__), __LINE__);
extract($_GET);
$now = time() - get_variable('delta_mins') * 60;
@session_start();
$query = "UPDATE `{$GLOBALS['mysql_prefix']}facilities` SET `status_id`= ";
$query .= quote_smart($frm_status_id);
$query .= ", `updated` = " . quote_smart(mysql_format_date($now));
$query .= ", `user_id` = " . $_SESSION['user_id'];
$query .= " WHERE `id` = ";
$query .= quote_smart($frm_responder_id);
$query .= " LIMIT 1";
$result = mysql_query($query) or do_error($query, "", mysql_error(), basename(__FILE__), __LINE__);
// dump ($query);
do_log($GLOBALS['LOG_FACILITY_STATUS'], $frm_ticket_id, $frm_responder_id, $frm_status_id);
set_sess_exp();
// update session time
print date("H:i", $now);
//date("H:i", $row['as_of'])
public function saveConfig()
{
do_log("hola mundo \n");
$data = array();
// notice that "ip_address" inputbox and "save" "restore" config buttons
// are also received from console. just ignore it
// search valid keys from http received parameters
foreach (Config::$config_options as $key => $info) {
if ($info[1] == true) {
continue;
}
// ignoramos configuracion de sistema
$type = $info[0];
if ($info[0] == "c") {
$type = "s";
}
if ($info[0] == "b") {
$type = "i";
}
if (isset($_REQUEST[$key])) {
$data[$key] = http_request($key, $type, $info[2]);
}
}
// finally write file:
$res = array_merge($this->config, $data);
$result = $this->write_ini_file($res, AC_CONFIG_FILE);
if ($result === FALSE) {
return "Error al generar el fichero de configuracion";
}
return "";
}
function do_send($to_str, $subject_str, $text_str)
{
// 7/7/09
global $istest;
require_once 'smtp.inc.php';
// defer load until required - 8/2/10
$sleep = 4;
// seconds delay between text messages
$my_smtp_ary = explode("/", trim(get_variable('smtp_acct')));
if (count($my_smtp_ary) > 1 && count($my_smtp_ary) != 6) {
do_log($GLOBALS['LOG_ERROR'], 0, 0, "Invalid smtp account information: " . trim(get_variable('smtp_acct')));
return;
}
if (count($my_smtp_ary) == 6 && !is_email(trim($my_smtp_ary[5]))) {
// email format test
do_log($GLOBALS['LOG_ERROR'], 0, 0, "Invalid smtp account address: " . trim($my_smtp_ary[5]));
return;
}
if (!is_email(trim(get_variable('email_reply_to')))) {
// email format test
do_log($GLOBALS['LOG_ERROR'], 0, 0, "Invalid email reply-to: " . trim(get_variable('email_reply_to')));
return;
}
function stripLabels($sText)
{
$labels = array("Incident:", "Priority:", "Nature:", "Addr:", "Descr:", "Reported by:", "Phone:", "Written:", "Updated:", "Status:", "Disp:", "Run Start:", "Map:", "Patient:", "Actions:", "Tickets host:");
// 5/9/10
for ($x = 0; $x < count($labels); $x++) {
$sText = str_replace($labels[$x], '', $sText);
}
return $sText;
}
$to_array = array_values(array_unique(explode("|", $to_str)));
// input is pipe-delimited string - 10/17/08
require_once "cell_addrs.inc.php";
// 10/22/08
$ary_cell_addrs = $ary_ll_addrs = array();
for ($i = 0; $i < count($to_array); $i++) {
// walk down the input address string/array
$temp = explode("@", $to_array[$i]);
// if (in_array(trim(strtolower($temp[1])), $cell_addrs)) { // cell addr?
if (!in_array(trim(strtolower($temp[1])), $cell_addrs)) {
// cell addr?
array_push($ary_cell_addrs, $to_array[$i]);
// yes
} else {
// no, land line addr
array_push($ary_ll_addrs, $to_array[$i]);
}
}
// end for ($i = ...)
$caption = "";
$my_from_ary = explode("/", trim(get_variable('email_from')));
// note /B option
$my_replyto_str = trim(get_variable('email_reply_to'));
$count_cells = $count_ll = 0;
// counters
if (count($ary_ll_addrs) > 0) {
// got landline addee's?
// ($my_smtp_ary, $my_to_ary, $my_subject_str, $my_message_str, $my_from_ary, $my_replyto_str)
if (count($my_smtp_ary) > 1) {
$count_ll = do_swift_mail($my_smtp_ary, $ary_ll_addrs, $subject_str, $text_str, $my_from_ary, $my_replyto_str);
} else {
$count_ll = do_native_mail($my_smtp_ary, $ary_ll_addrs, $subject_str, $text_str, $my_from_ary, $my_replyto_str);
}
}
if (count($ary_cell_addrs) > 0) {
// got cell addee's?
$lgth = 140;
$ix = 0;
$i = 1;
$cell_text_str = stripLabels($text_str);
// strip labels 5/10/10
while (substr($cell_text_str, $ix, $lgth)) {
// chunk to $lgth-length strings
$subject_ex = $subject_str . "/part " . $i . "/";
// 10/21/08
// ($my_smtp_ary, $my_to_ary, $my_subject_str, $my_message_str, $my_from_ary, $my_replyto_str)
if (count($my_smtp_ary) > 1) {
$count_cells = do_swift_mail($my_smtp_ary, $ary_cell_addrs, $subject_ex, substr($cell_text_str, $ix, $lgth), $my_from_ary, $my_replyto_str);
} else {
$count_cells = do_native_mail($my_smtp_ary, $ary_cell_addrs, $subject_ex, substr($cell_text_str, $ix, $lgth), $my_from_ary, $my_replyto_str);
}
if ($i > 1) {
sleep($sleep);
}
// 10/17/08
$ix += $lgth;
$i++;
}
// end while (substr($cell_text_...)
}
// end if (count($ary_cell_addrs)>0)
return (string) ($count_ll + $count_cells);
}
<?php
exit;
break;
case 'do_del':
$temp = explode(",", $_POST['idstr'], 20);
for ($i = 0; $i < count($temp); $i++) {
$query = "DELETE from `{$GLOBALS['mysql_prefix']}ticket` WHERE `id` = " . $temp[$i] . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
// 6/4/08 - corrected table names
$query = "DELETE from `{$GLOBALS['mysql_prefix']}action` WHERE `ticket_id` = " . $temp[$i];
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
$query = "DELETE from `{$GLOBALS['mysql_prefix']}patient` WHERE `ticket_id` = " . $temp[$i];
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
$query = "DELETE from `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . $temp[$i];
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), __FILE__, __LINE__);
do_log($GLOBALS['LOG_INCIDENT_DELETE'], $temp[$i]);
// added 6/4/08
// dump ($query);
}
$plu = $i > 1 ? "s" : "";
?>
<DIV STYLE = 'margin-left:100px; margin-top:60px;'>
<FORM NAME='can_Form' METHOD="post" ACTION = "<?php
print basename(__FILE__);
?>
">
<BR /><BR /><BR /><BR /><B>Ticket<?php
print $plu;
?>
and associated Assigns, Action and <?php
print $patient;
function can_bid()
{
do_log('bid');
return get_logs('bid', bid_time) < 6;
}
} else {
$the_date = "<U>{$temp[0]}</U> {$temp[1]}";
$day_part = $temp[0];
}
$print .= "<TD ALIGN='right'> " . $the_date . " </TD>" . "<TD>" . $types[$row['code']] . "</TD>" . "<TD>" . $row['thename'] . "</TD>" . "<TD>" . $row['theinfo'] . "</TD>" . "<TD> " . $row['from'] . "</TD>" . "</TR>\n";
break;
}
}
$print .= "<TR><TD COLSPAN=99 ALIGN='center'><BR /><B>End of Station Log Report</B><BR /><BR /><A HREF='#page_top'><U>to top</U></A></TD></TR>\n";
$print .= "</TABLE><BR /><BR /><CENTER></CENTER>";
return $print;
}
// end function my_show_log ()
switch ($_POST['func']) {
case "add":
do_log($GLOBALS['LOG_COMMENT'], $ticket_id = 0, $responder_id = 0, trim($_POST['frm_comment']));
break;
case "view":
print my_show_log();
print "<BR CLEAR='left'><BR>";
break;
case "del":
// 2/30/09
?>
<CENTER>
<FORM NAME="del_form" METHOD="post" ACTION = "<?php
print basename(__FILE__);
?>
">
<INPUT TYPE="hidden" NAME="func" VALUE="del_db" />
function updt_ticket($id)
{
/* 1/25/09 */
global $addrs, $NOTIFY_TICKET;
$post_frm_meridiem_problemstart = empty($_POST) || !empty($_POST) && empty($_POST['frm_meridiem_problemstart']) ? "" : $_POST['frm_meridiem_problemstart'];
$post_frm_meridiem_booked_date = empty($_POST) || !empty($_POST) && empty($_POST['frm_meridiem_booked_date']) ? "" : $_POST['frm_meridiem_booked_date'];
//10/1/09
$post_frm_affected = empty($_POST) || !empty($_POST) && empty($_POST['frm_affected']) ? "" : $_POST['frm_affected'];
$_POST['frm_description'] = strip_html($_POST['frm_description']);
//clean up HTML tags
$post_frm_affected = strip_html($post_frm_affected);
$_POST['frm_scope'] = strip_html($_POST['frm_scope']);
if (!get_variable('military_time')) {
//put together date from the dropdown box and textbox values
if ($post_frm_meridiem_problemstart == 'pm') {
$post_frm_meridiem_problemstart = ($post_frm_meridiem_problemstart + 12) % 24;
}
}
if (!get_variable('military_time')) {
//put together date from the dropdown box and textbox values
if ($post_frm_meridiem_booked_date == 'pm') {
$post_frm_meridiem_booked_date = ($post_frm_meridiem_booked_date + 12) % 24;
}
}
if (empty($post_frm_owner)) {
$post_frm_owner = 0;
}
$frm_problemstart = "{$_POST['frm_year_problemstart']}-{$_POST['frm_month_problemstart']}-{$_POST['frm_day_problemstart']} {$_POST['frm_hour_problemstart']}:{$_POST['frm_minute_problemstart']}:00{$post_frm_meridiem_problemstart}";
if (intval($_POST['frm_status']) == 3) {
// 1/21/11
$frm_booked_date = "{$_POST['frm_year_booked_date']}-{$_POST['frm_month_booked_date']}-{$_POST['frm_day_booked_date']} {$_POST['frm_hour_booked_date']}:{$_POST['frm_minute_booked_date']}:00{$post_frm_meridiem_booked_date}";
} else {
// $frm_booked_date = "NULL";
$frm_booked_date = "";
// 6/20/10
}
if (!get_variable('military_time')) {
//put together date from the dropdown box and textbox values
if ($post_frm_meridiem_problemstart == 'pm') {
$_POST['frm_hour_problemstart'] = ($_POST['frm_hour_problemstart'] + 12) % 24;
}
if (isset($_POST['frm_meridiem_problemend'])) {
if ($_POST['frm_meridiem_problemend'] == 'pm') {
$_POST['frm_hour_problemend'] = ($_POST['frm_hour_problemend'] + 12) % 24;
}
}
if (isset($_POST['frm_meridiem_booked_date'])) {
//10/1/09
if ($_POST['frm_meridiem_booked_date'] == 'pm') {
$_POST['frm_hour_booked_date'] = ($_POST['frm_hour_booked_date'] + 12) % 24;
}
}
}
$frm_problemend = isset($_POST['frm_year_problemend']) ? quote_smart("{$_POST['frm_year_problemend']}-{$_POST['frm_month_problemend']}-{$_POST['frm_day_problemend']} {$_POST['frm_hour_problemend']}:{$_POST['frm_minute_problemend']}:00") : "NULL";
$now = mysql_format_date(time() - intval(get_variable('delta_mins') * 60));
// 6/20/10
if (empty($post_frm_owner)) {
$post_frm_owner = 0;
}
// $inc_num_ary = unserialize (get_variable('_inc_num')); // 11/13/10
$temp = get_variable('_inc_num');
// 3/2/11
$inc_num_ary = strpos($temp, "{") > 0 ? unserialize($temp) : unserialize(base64_decode($temp));
$name_rev = $_POST['frm_scope'];
if ($inc_num_ary[0] == 0) {
// no auto numbering scheme
switch (get_variable('serial_no_ap')) {
// incident name revise -1/22/09
case 0:
/* no serial no. */
$name_rev = $_POST['frm_scope'];
break;
case 1:
/* prepend */
$name_rev = $id . "/" . $_POST['frm_scope'];
break;
case 2:
/* append */
$name_rev = $_POST['frm_scope'] . "/" . $id;
break;
default:
/* error???? */
$name_rev = " error error error ";
}
// end switch
// 8/23/08, 9/20/08, 8/13/09
}
// end if()
$facility_id = empty($_POST['frm_facility_id']) ? 0 : trim($_POST['frm_facility_id']);
// 9/28/09
$rec_facility_id = empty($_POST['frm_rec_facility_id']) ? 0 : trim($_POST['frm_rec_facility_id']);
// 9/28/09
$groups = "," . implode(',', $_POST['frm_group']) . ",";
// 6/10/11
if ($facility_id > 0) {
// 9/22/09
$query_g = "SELECT * FROM {$GLOBALS['mysql_prefix']}facilities WHERE `id`= {$facility_id} LIMIT 1";
$result_g = mysql_query($query_g) or do_error($query_g, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_g = stripslashes_deep(mysql_fetch_array($result_g));
$the_lat = $row_g['lat'];
// use facility location
$the_lng = $row_g['lng'];
} else {
$the_lat = quote_smart(trim($_POST['frm_lat']));
// use incident location
$the_lng = quote_smart(trim($_POST['frm_lng']));
}
if (strlen($the_lat) < 3 && strlen($the_lng) < 3) {
// 1/29/11
$the_lat = $the_lng = 0.999999;
}
// perform db update //9/22/09 added facility capability, 10/1/09 added receiving facility
@session_start();
$by = $_SESSION['user_id'];
// $booked_date = empty($frm_booked_date)? "NULL" : quote_smart(trim($frm_booked_date)) ; // 6/20/10
$booked_date = intval(trim($_POST['frm_do_scheduled']) == 1) ? quote_smart($frm_booked_date) : "NULL";
// 1/2/11, 1/19/10
// die;
// 6/26/10
$query = "UPDATE `{$GLOBALS['mysql_prefix']}ticket` SET \n\t\t\t\t`contact`= " . quote_smart(trim($_POST['frm_contact'])) . ",\n\t\t\t\t`street`= " . quote_smart(trim($_POST['frm_street'])) . ",\n\t\t\t\t`city`= " . quote_smart(trim($_POST['frm_city'])) . ",\n\t\t\t\t`state`= " . quote_smart(trim($_POST['frm_state'])) . ",\n\t\t\t\t`phone`= " . quote_smart(trim($_POST['frm_phone'])) . ",\n\t\t\t\t`facility`= " . quote_smart($facility_id) . ",\n\t\t\t\t`rec_facility`= " . quote_smart($rec_facility_id) . ",\n\t\t\t\t`lat`= " . $the_lat . ",\n\t\t\t\t`lng`= " . $the_lng . ",\n\t\t\t\t`scope`= " . quote_smart(trim($name_rev)) . ",\n\t\t\t\t`owner`= " . quote_smart(trim($post_frm_owner)) . ",\n\t\t\t\t`severity`= " . quote_smart(trim($_POST['frm_severity'])) . ",\n\t\t\t\t`in_types_id`= " . quote_smart(trim($_POST['frm_in_types_id'])) . ",\n\t\t\t\t`status`=" . quote_smart(trim($_POST['frm_status'])) . ",\n\t\t\t\t`problemstart`=" . quote_smart(trim($frm_problemstart)) . ",\n\t\t\t\t`problemend`=" . $frm_problemend . ",\n\t\t\t\t`description`= " . quote_smart(trim($_POST['frm_description'])) . ",\n\t\t\t\t`comments`= " . quote_smart(trim($_POST['frm_comments'])) . ",\n\t\t\t\t`nine_one_one`= " . quote_smart(trim($_POST['frm_nine_one_one'])) . ",\n\t\t\t\t`booked_date`= " . $booked_date . ",\n\t\t\t\t`date`='{$now}',\n\t\t\t\t`updated`='{$now}',\n\t\t\t\t`_by` = {$by}\n\t\t\t\tWHERE ID={$id}";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$tick_stat = $_POST['frm_status'];
// 6/10/11
$prob_start = quote_smart(trim($frm_problemstart));
// 6/10/11
foreach ($_POST['frm_group'] as $grp_val) {
// 6/10/11
if (test_allocates($id, $grp_val, 1)) {
$query_a = "INSERT INTO `{$GLOBALS['mysql_prefix']}allocates` (`group` , `type`, `al_as_of` , `al_status` , `resource_id` , `sys_comments` , `user_id`) VALUES \n\t\t\t\t\t\t({$grp_val}, 1, '{$now}', {$tick_stat}, {$id}, 'Allocated to Group' , {$by})";
$result_a = mysql_query($query_a) or do_error($query_a, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
}
do_log($GLOBALS['LOG_INCIDENT_OPEN'], $id);
if (intval($facility_id) > 0) {
//9/22/09, 10/1/09, 3/24/10
do_log($GLOBALS['LOG_FACILITY_INCIDENT_OPEN'], $id, '', 0, $facility_id);
// - 7/11/10
}
if (intval($rec_facility_id) > 0) {
do_log($GLOBALS['LOG_CALL_REC_FAC_SET'], $id, 0, 0, 0, $rec_facility_id);
// 6/20/10 - 7/11/10
}
$the_year = date("y");
if ((int) $inc_num_ary[0] == 3 && !($inc_num_ary[5] == $the_year)) {
// year style and change?
$inc_num_ary[3] = 1;
// roll over and start at 1
$inc_num_ary[5] = $the_year;
} else {
if ((int) $inc_num_ary[0] > 0) {
// step to next no. if scheme in use
$inc_num_ary[3]++;
// do the deed for next use
}
$out_str = base64_encode(serialize($inc_num_ary));
// 3/2/11
$query = "UPDATE`{$GLOBALS['mysql_prefix']}settings` SET `value` = '{$out_str}' WHERE `name` = '_inc_num'";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
return $name_rev;
}
function win_shut_down()
{
// for use in window vs. frame
do_log($GLOBALS['LOG_INTRUSION'], 0);
?>
<html>
<body onload="setTimeout('window.close()', 2000);" >
<BR /><BR /><CENTER><H2>Intrusion attempt prevented!</H2></CENTER>
</body>
</html>
<?php
}
{
$cur_date = "%-" . date('m-d');
# var_dump($cur_date);
$SQL_Querry = "SELECT uid,user,deposit,sms_tel,mob_tel,phone FROM " . BILL_AUTH_TABLE . " WHERE date_birth LIKE '" . $cur_date . "'";
$result = mysql_query($SQL_Querry, $LINK) or do_log_sql($stdlog, "#deposit error " . mysql_error($LINK), $LINK);
for ($i = 0; $i <= mysql_num_rows($result); $i++) {
$res = mysql_fetch_array($result);
$users_list[$i] = $res;
}
mysql_free_result($result);
return $users_list;
}
global $LINK;
$LINK = mysql_pconnect($CONF_MYSQL_HOST, $CONF_MYSQL_USERNAME, $CONF_MYSQL_PASSWORD);
if (!$LINK) {
do_log($stdlog, "Cant connect to DB " . $CONF_MYSQL_HOST);
exit;
}
mysql_select_db($CONF_MYSQL_DBNAME, $LINK) or die('Could not select database.');
$users_birth = get_users_birth($LINK, $stdlog);
$ts = time();
#var_dump($users_birth);
#die();
foreach ($users_birth as $key => $value) {
$TEXT = $TEXT_base;
$pattern = "|[^\\d\\(\\)-+]|";
$replacement = "";
$SMS_TEL = preg_replace($pattern, $replacement, $value['sms_tel']);
if (strlen($SMS_TEL) == 10) {
sms("7" . $SMS_TEL, $TEXT, $COMPANY);
}
function edit_ticket($id)
{
/* post changes */
global $addrs, $NOTIFY_TICKET;
$post_frm_meridiem_problemstart = empty($_POST) || !empty($_POST) && empty($_POST['frm_meridiem_problemstart']) ? "" : $_POST['frm_meridiem_problemstart'];
$post_frm_meridiem_booked_date = empty($_POST) || !empty($_POST) && empty($_POST['frm_meridiem_booked_date']) ? "" : $_POST['frm_meridiem_booked_date'];
//10/1/09
$post_frm_affected = empty($_POST) || !empty($_POST) && empty($_POST['frm_affected']) ? "" : $_POST['frm_affected'];
$_POST['frm_description'] = strip_html($_POST['frm_description']);
//clean up HTML tags
$post_frm_affected = strip_html($post_frm_affected);
$_POST['frm_scope'] = strip_html($_POST['frm_scope']);
/* if (get_variable('reporting')) { // if any change do automatic action reporting
// if ($_POST[frm_affected] != $_POST[frm_affected_default]) report_action($GLOBALS[ACTION_AFFECTED],$_POST[frm_affected],0,$id);
if ($_POST[frm_severity] != $_POST[frm_severity_default]) report_action($GLOBALS[ACTION_SEVERITY],get_severity($_POST[frm_severity_default]),get_severity($_POST[frm_severity]),$id);
if ($_POST[frm_scope] != $_POST[frm_scope_default]) report_action($GLOBALS[ACTION_SCOPE],$_POST[frm_scope_default],0,$id);
}
*/
if (!get_variable('military_time')) {
//put together date from the dropdown box and textbox values
if ($post_frm_meridiem_problemstart == 'pm') {
$post_frm_meridiem_problemstart = ($post_frm_meridiem_problemstart + 12) % 24;
}
if (isset($_POST['frm_meridiem_booked_date'])) {
//10/1/09
if ($_POST['frm_meridiem_booked_date'] == 'pm') {
$_POST['frm_hour_booked_date'] = ($_POST['frm_hour_booked_date'] + 12) % 24;
}
}
// if ($_POST['frm_meridiem_problemend'] == 'pm') $_POST['frm_hour_problemend'] = ($_POST['frm_hour_problemend'] + 12) % 24;
}
if (empty($post_frm_owner)) {
$post_frm_owner = 0;
}
// $frm_problemstart = $_POST['frm_year_problemstart']-$_POST['frm_month_problemstart']-$_POST['frm_day_problemstart'] $_POST['frm_hour_problemstart']:$_POST['frm_minute_problemstart']:00";
$frm_problemstart = "{$_POST['frm_year_problemstart']}-{$_POST['frm_month_problemstart']}-{$_POST['frm_day_problemstart']} {$_POST['frm_hour_problemstart']}:{$_POST['frm_minute_problemstart']}:00{$post_frm_meridiem_problemstart}";
$curr_groups = $_POST['frm_exist_groups'];
// 6/10/11
$groups = "," . implode(',', $_POST['frm_group']) . ",";
// 6/10/11
// dump($_POST); // 6/10/11
if (!get_variable('military_time')) {
//put together date from the dropdown box and textbox values
if ($post_frm_meridiem_problemstart == 'pm') {
$_POST['frm_hour_problemstart'] = ($_POST['frm_hour_problemstart'] + 12) % 24;
}
if (isset($_POST['frm_meridiem_problemend'])) {
if ($_POST['frm_meridiem_problemend'] == 'pm') {
$_POST['frm_hour_problemend'] = ($_POST['frm_hour_problemend'] + 12) % 24;
}
}
if (isset($_POST['frm_meridiem_booked_date'])) {
//10/1/09
if ($_POST['frm_meridiem_booked_date'] == 'pm') {
$_POST['frm_hour_booked_date'] = ($_POST['frm_hour_booked_date'] + 12) % 24;
}
}
}
$frm_problemend = isset($_POST['frm_year_problemend']) ? quote_smart("{$_POST['frm_year_problemend']}-{$_POST['frm_month_problemend']}-{$_POST['frm_day_problemend']} {$_POST['frm_hour_problemend']}:{$_POST['frm_minute_problemend']}:00") : "NULL";
$frm_booked_date = isset($_POST['frm_year_booked_date']) ? quote_smart("{$_POST['frm_year_booked_date']}-{$_POST['frm_month_booked_date']}-{$_POST['frm_day_booked_date']} {$_POST['frm_hour_booked_date']}:{$_POST['frm_minute_booked_date']}:00") : "NULL";
//10/1/09
if ($_POST['frm_status'] != 1) {
$frm_problemend = "NULL";
}
// perform db update
$now = mysql_format_date(time() - get_variable('delta_mins') * 60);
$by = $_SESSION['user_id'];
// 12/7/10
if (empty($post_frm_owner)) {
$post_frm_owner = 0;
}
// 8/23/08, 9/20/08, 9/22/09 (Facility), 10/1/09 (receiving facility), 6/26/10 (911), 6/10/11
$query = "UPDATE `{$GLOBALS['mysql_prefix']}ticket` SET \n\t\t\t`contact`= " . quote_smart(trim($_POST['frm_contact'])) . ",\n\t\t\t`street`= " . quote_smart(trim($_POST['frm_street'])) . ",\n\t\t\t`city`= " . quote_smart(trim($_POST['frm_city'])) . ",\n\t\t\t`state`= " . quote_smart(trim($_POST['frm_state'])) . ",\n\t\t\t`phone`= " . quote_smart(trim($_POST['frm_phone'])) . ",\n\t\t\t`facility`= " . quote_smart(trim($_POST['frm_facility_id'])) . ",\n\t\t\t`rec_facility`= " . quote_smart(trim($_POST['frm_rec_facility_id'])) . ",\n\t\t\t`lat`= " . quote_smart(trim($_POST['frm_lat'])) . ",\n\t\t\t`lng`= " . quote_smart(trim($_POST['frm_lng'])) . ",\n\t\t\t`scope`= " . quote_smart(trim($_POST['frm_scope'])) . ",\n\t\t\t`owner`= " . quote_smart(trim($post_frm_owner)) . ",\n\t\t\t`severity`= " . quote_smart(trim($_POST['frm_severity'])) . ",\n\t\t\t`in_types_id`= " . quote_smart(trim($_POST['frm_in_types_id'])) . ",\n\t\t\t`status`=" . quote_smart(trim($_POST['frm_status'])) . ",\n\t\t\t`problemstart`=" . quote_smart(trim($frm_problemstart)) . ",\n\t\t\t`problemend`=" . $frm_problemend . ",\n\t\t\t`description`= " . quote_smart(trim($_POST['frm_description'])) . ",\n\t\t\t`comments`= " . quote_smart(trim($_POST['frm_comments'])) . ",\n\t\t\t`nine_one_one`= " . quote_smart(trim($_POST['frm_nine_one_one'])) . ",\n\t\t\t`booked_date`= \t\t{$frm_booked_date},\n\t\t\t`_by` = \t\t\t{$by}, \n\t\t\t`updated`='{$now}'\n\t\t\tWHERE ID='{$id}'";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), __FILE__, __LINE__);
$list = $_POST['frm_exist_groups'];
// 6/10/11
$ex_grps = explode(',', $list);
// 6/10/11
if ($curr_groups != $groups) {
// 6/10/11
foreach ($_POST['frm_group'] as $posted_grp) {
// 6/10/11
if (!in_array($posted_grp, $ex_grps)) {
$tick_stat = $_POST['frm_status'];
$query = "INSERT INTO `{$GLOBALS['mysql_prefix']}allocates` (`group` , `type`, `al_as_of` , `al_status` , `resource_id` , `sys_comments` , `user_id`) VALUES \n\t\t\t\t\t\t\t({$posted_grp}, 1, '{$now}', {$tick_stat}, {$id}, 'Allocated to Group' , {$by})";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
}
foreach ($ex_grps as $existing_grp) {
// 6/10/11
print $existing_grp;
if (in_array($existing_grp, get_allocates(4, $id))) {
if (!in_array($existing_grp, $_POST['frm_group'])) {
$query = "DELETE FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type` = 1 AND `group` = '{$existing_grp}' AND `resource_id` = {$id}";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
}
}
}
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = '{$id}' AND (`clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00')";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_assigns = mysql_num_rows($result);
if ($num_assigns != 0) {
// 4/4/11 - added to update any existing assigns record with any ticket changes.
$query = "UPDATE `{$GLOBALS['mysql_prefix']}assigns` SET \n\t\t\t`as_of`='{$now}',\n\t\t\t`status_id`= " . quote_smart(trim($_POST['frm_status'])) . ",\n\t\t\t`user_id`= " . quote_smart(trim($post_frm_owner)) . ",\n\t\t\t`facility_id`= " . quote_smart(trim($_POST['frm_facility_id'])) . ",\n\t\t\t`rec_facility_id`= " . quote_smart(trim($_POST['frm_rec_facility_id'])) . "\n\t\t\tWHERE ticket_id='{$id}'";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
do_log($GLOBALS['LOG_INCIDENT_CHANGE'], $id, 0);
// report change - 3/25/10
if ($_POST['frm_status'] == $GLOBALS['STATUS_CLOSED']) {
// log incident complete - repeats possible
do_log($GLOBALS['LOG_INCIDENT_CLOSE'], $id, 0);
}
switch ($_POST['frm_fac_chng']) {
// log facility changes - 3/25/10
case "0":
// no change
break;
case "1":
do_log($GLOBALS['LOG_FACILITY_INCIDENT_CHANGE'], $id, 0);
//10/1/09
break;
case "2":
do_log($GLOBALS['LOG_CALL_REC_FAC_CHANGE'], $id);
//10/7/09
break;
case "3":
do_log($GLOBALS['LOG_FACILITY_INCIDENT_CHANGE'], $id, 0);
//10/1/09
do_log($GLOBALS['LOG_CALL_REC_FAC_CHANGE'], $id);
//10/7/09
break;
default:
// 8/10/09
// dump($_POST['frm_fac_chng']);
print "ERROR in " . basename(__FILE__) . " " . __LINE__ . "<BR />";
}
// end switch ()
print '<FONT CLASS="header">Ticket <I>' . $_POST['frm_scope'] . '</I> has been updated</FONT><BR /><BR />';
/* show updated ticket */
// notify_user($id, $GLOBALS['NOTIFY_TICKET']);
add_header($id);
show_ticket($id);
$addrs = notify_user($id, $GLOBALS['NOTIFY_TICKET_CHG']);
// returns array or FALSE
unset($_SESSION['active_ticket']);
// 5/4/11
}
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
// apply status update to unit status
$query = "SELECT `id`, `contact_via` FROM `{$GLOBALS['mysql_prefix']}responder` WHERE `id` = " . quote_smart($assigns[$i]) . " LIMIT 1";
// 10/7/08
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), __FILE__, __LINE__);
$row_addr = stripslashes_deep(mysql_fetch_assoc($result));
if (is_email($row_addr['contact_via'])) {
array_push($addrs, $row_addr['contact_via']);
}
// to array for emailing to unit
do_log($GLOBALS['LOG_UNIT_STATUS'], $frm_ticket_id, $assigns[$i], $frm_status_id);
if ($frm_facility_id != 0) {
do_log($GLOBALS['LOG_FACILITY_DISP'], $frm_ticket_id, $assigns[$i], $frm_status_id);
}
if ($frm_rec_facility_id != 0) {
do_log($GLOBALS['LOG_FACILITY_DISP'], $frm_ticket_id, $assigns[$i], $frm_status_id);
}
}
?>
<SCRIPT>
function sendRequest(url,callback,postData) {
var req = createXMLHTTPObject();
if (!req) return;
var method = (postData) ? "POST" : "GET";
req.open(method,url,true);
req.setRequestHeader('User-Agent','XMLHTTP/1.0');
if (postData)
req.setRequestHeader('Content-type','application/x-www-form-urlencoded');
req.onreadystatechange = function () {
if (req.readyState != 4) return;
// ==== { ================================================
// dump($_POST);
$now = mysql_format_date(time() - get_variable('delta_mins') * 60);
if (isset($frm_inc_status_id)) {
$query = "UPDATE `{$GLOBALS['mysql_prefix']}ticket` SET `status`= " . quote_smart($frm_inc_status_id) . ", `updated` = " . quote_smart($now) . " WHERE `id` = " . quote_smart($frm_ticket_id) . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
do_log($GLOBALS['LOG_INCIDENT_CHANGE'], $frm_ticket_id);
}
if (isset($frm_unit_status_id)) {
$query = "UPDATE `{$GLOBALS['mysql_prefix']}responder` SET `un_status_id`= " . quote_smart($frm_unit_status_id) . ", `updated` = " . quote_smart($now) . " WHERE `id` = " . quote_smart($frm_unit_id) . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
do_log($GLOBALS['LOG_UNIT_CHANGE'], $frm_unit_id);
}
if (!empty($frm_complete)) {
// is run completed? 6/4/08 // 6/26/08
do_log($GLOBALS['LOG_UNIT_COMPLETE'], $frm_ticket_id, $frm_unit_id);
// set clear times
$query = "UPDATE `{$GLOBALS['mysql_prefix']}assigns` SET `as_of`= " . quote_smart($now) . ", `clear`= " . quote_smart($now) . " WHERE `id` = " . $_POST['frm_id'] . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
}
$frm_dispatched = array_key_exists('frm_db', $_POST) ? quote_smart($_POST['frm_year_dispatched'] . "-" . $_POST['frm_month_dispatched'] . "-" . $_POST['frm_day_dispatched'] . " " . $_POST['frm_hour_dispatched'] . ":" . $_POST['frm_minute_dispatched'] . ":00") : "";
$frm_responding = array_key_exists('frm_rb', $_POST) ? quote_smart($_POST['frm_year_responding'] . "-" . $_POST['frm_month_responding'] . "-" . $_POST['frm_day_responding'] . " " . $_POST['frm_hour_responding'] . ":" . $_POST['frm_minute_responding'] . ":00") : "";
$frm_on_scene = array_key_exists('frm_os', $_POST) ? quote_smart($_POST['frm_year_on_scene'] . "-" . $_POST['frm_month_on_scene'] . "-" . $_POST['frm_day_on_scene'] . " " . $_POST['frm_hour_on_scene'] . ":" . $_POST['frm_minute_on_scene'] . ":00") : "";
$frm_u2fenr = array_key_exists('frm_fe', $_POST) ? quote_smart($_POST['frm_year_u2fenr'] . "-" . $_POST['frm_month_u2fenr'] . "-" . $_POST['frm_day_u2fenr'] . " " . $_POST['frm_hour_u2fenr'] . ":" . $_POST['frm_minute_u2fenr'] . ":00") : "";
//10/6/09
$frm_u2farr = array_key_exists('frm_fa', $_POST) ? quote_smart($_POST['frm_year_u2farr'] . "-" . $_POST['frm_month_u2farr'] . "-" . $_POST['frm_day_u2farr'] . " " . $_POST['frm_hour_u2farr'] . ":" . $_POST['frm_minute_u2farr'] . ":00") : "";
//10/6/09
$frm_clear = array_key_exists('frm_cb', $_POST) ? quote_smart($_POST['frm_year_clear'] . "-" . $_POST['frm_month_clear'] . "-" . $_POST['frm_day_clear'] . " " . $_POST['frm_hour_clear'] . ":" . $_POST['frm_minute_clear'] . ":00") : "";
$date_part = empty($frm_dispatched) ? "" : ", `dispatched`= " . $frm_dispatched;
$date_part .= empty($frm_responding) ? "" : ", `responding`= " . $frm_responding;
$date_part .= empty($frm_on_scene) ? "" : ", `on_scene`= " . $frm_on_scene;
*/
error_reporting(E_ALL);
@session_start();
require_once $_SESSION['fip'];
//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
*/
$GLOBALS['LOG_CALL_RESET'] = 34;
// 5/25/09
//$query = "UPDATE `$GLOBALS[mysql_prefix]assigns` SET
// `dispatched` = NULL,
// `responding` = NULL,
// `on_scene` = NULL,
// `u2fenr` = NULL,
// `u2farr` = NULL,
// `clear` = NULL,
// `as_of` = $now
// WHERE `id` = {$_POST['frm_id']} LIMIT 1;";
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `id` = {$_POST['frm_id']} LIMIT 1";
$result = mysql_query($query) or do_error($query, "", mysql_error(), basename(__FILE__), __LINE__);
$row = mysql_fetch_assoc($result);
// collect for log
do_log($GLOBALS['LOG_CALL_RESET'], $row['ticket_id'], $row['responder_id'], $row['id']);
set_u_updated($_POST['frm_id']);
// 9/1/10
$query = "DELETE FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `id` = {$_POST['frm_id']} LIMIT 1;";
$result = mysql_query($query) or do_error($query, "", mysql_error(), basename(__FILE__), __LINE__);
//snap(__LINE__, $query );
unset($result);
<?php
if (!empty($_POST)) {
extract($_POST);
$now = mysql_format_date(time() - get_variable('delta_mins') * 60);
$assigns = explode(",", $_POST['frm_id_str']);
// comma sep'd
for ($i = 0; $i < count($assigns); $i++) {
$query = sprintf("INSERT INTO `{$GLOBALS['mysql_prefix']}assigns` (`as_of`, `status_id`, `ticket_id`, `responder_id`, `comments`, `user_id`, `dispatched`)\n\t\t\t\t\t\tVALUES (%s,%s,%s,%s,%s,%s,%s)", quote_smart($now), quote_smart($frm_status_id), quote_smart($frm_ticket_id), quote_smart($assigns[$i]), quote_smart($frm_comments), quote_smart($frm_by_id), quote_smart($now));
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
// remove placeholder inserted by 'add'
$query = "DELETE FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . quote_smart($frm_ticket_id) . " AND `responder_id` = 0 LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
// apply status update to unit status
$query = "UPDATE `{$GLOBALS['mysql_prefix']}responder` SET `un_status_id`= " . quote_smart($frm_status_id) . " WHERE `id` = " . quote_smart($assigns[$i]) . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), __FILE__, __LINE__);
do_log($GLOBALS['LOG_UNIT_STATUS'], $frm_ticket_id, $assigns[$i], $frm_status_id);
}
?>
<SCRIPT>
try {
parent.frames["upper"].document.getElementById("whom").innerHTML = "<?php
print $_SESSION['user'];
?>
";
parent.frames["upper"].document.getElementById("level").innerHTML = "<?php
print get_level_text($_SESSION['level']);
?>
";
parent.frames["upper"].document.getElementById("script").innerHTML = "<?php
function log_ogts_err($message)
{
// error logger
@session_start();
if (!array_key_exists("ogts_err", $_SESSION)) {
// limit to once per session
do_log($GLOBALS['LOG_ERROR'], 0, 0, $message);
$_SESSION['ogts_err'] = TRUE;
}
}
#!/usr/bin/php
<?php
require_once 'phplib/Sag.php';
require_once 'functions.php';
require_once 'config.php';
// check while
while ($stop == false) {
while ($host == false) {
foreach (explode(" ", $hosts) as $testhost) {
$host = check_couchdb($testhost);
if ($host) {
break;
}
}
if ($host) {
continue;
}
do_log("No connect to cluster-db sleep now for next tray in (s):" . $testsleep);
sleep($testsleep);
}
$sag = new Sag($host);
$dbconfig = db_config();
print_r($dbconfig->default->fs_nodes);
sleep(5);
$host = false;
}
}
$error = my_copy($source, $dest);
if (!$error) {
sleep(5);
$error = my_copy($source, $dest);
}
if (!$error) {
sleep(5);
$error = my_copy($source, $dest);
}
if (!$error) {
do_log($error_log, $pic['src'] . "\n");
//记录没有采集成功的图片
continue;
}
do_log($success_log, $pic['filename'] . "\n");
}
}
ob_flush();
flush();
$posi = $key + 1;
echo $posi . '/' . $total . '<br />';
}
function get_file($path)
{
$return = array();
if ($handle = opendir($path)) {
while (false !== ($file = readdir($handle))) {
if ($file != '.' && $file != '..') {
$return[] = $file;
}
/**
* get a variable from _REQUEST array
* @param {string} $name variable name
* @param {string} $type default type (i,s,b)
* @param {string} $def default value. may be null
* @param {boolean} $esc true if variable should be MySQL escape'd to avoid SQL injection
* @return {object} requested value (int,string,bool) or null if invalid type
*/
function http_request($name, $type, $def, $esc = true)
{
$a = $def;
if (isset($_REQUEST[$name])) {
$a = $_REQUEST[$name];
}
if ($a === null) {
return null;
}
switch ($type) {
case "s":
if ($a === _('-- Search --')) {
$a = "";
}
if ($esc) {
return escapeString(strval($a));
}
return strval($a);
case "i":
return intval($a);
case "b":
if ($a === "") {
return $def;
}
return toBoolean($a);
case "d":
case "f":
return floatval(str_replace(",", ".", $a));
}
do_log("request() invalid type:{$type} requested");
return null;
}
$result = $inscripciones->inscritos();
break;
case "inscritosbyteam":
$result = $inscripciones->inscritosByTeam($equipo);
break;
case "inscritosbyjornada":
$result = $inscripciones->inscritosByJornada($jornada);
break;
case "reorder":
$am->access(PERMS_OPERATOR);
$result = $inscripciones->reorder();
break;
case "setdorsal":
$am->access(PERMS_OPERATOR);
$result = $inscripciones->setDorsal($perro, $olddorsal, $newdorsal);
break;
default:
throw new Exception("inscripcionFunctions:: invalid operation: {$operation} provided");
}
if ($result === null) {
throw new Exception($inscripciones->errormsg);
}
if ($result === "") {
echo json_encode(array('success' => true, 'insert_id' => $inscripciones->insertid, 'affected_rows' => 0));
} else {
echo json_encode($result);
}
} catch (Exception $e) {
do_log($e->getMessage());
echo json_encode(array('errorMsg' => $e->getMessage()));
}
if ($checkit == false) {
do_log("min check wait: {$ncheck} > " . $dbconfig['phone_numbers']->default->extern_numbermanager_min_check, 'v', 'info', __FILE__, __FUNCTION__, __LINE__);
if ($ncheck > $dbconfig['phone_numbers']->default->extern_numbermanager_min_check) {
check_gateways();
$ncheck = 0;
}
$checkit = true;
}
}
$gat = false;
$checkit = false;
$ret = false;
$res = false;
// ========== FIRST INIT ===============================================
if ($first == false) {
// first init all
$first = true;
}
// ========== END FIRST INIT ===============================================
$cmd = false;
if (!is_numeric($dbconfig['phone_numbers']->default->extern_numbermanager_min_check)) {
$dbconfig['phone_numbers']->default->extern_numbermanager_min_check = '120';
}
if (!is_numeric($dbconfig['phone_numbers']->default->extern_numbermanager_sleep_time)) {
$dbconfig['phone_numbers']->default->extern_numbermanager_sleep_time = '60';
}
do_log("Sleep now:" . $dbconfig['phone_numbers']->default->extern_numbermanager_sleep_time, 'v', __FILE__, __FUNCTION__, __LINE__);
sleep($dbconfig['phone_numbers']->default->extern_numbermanager_sleep_time);
$ncheck = $ncheck + $dbconfig['phone_numbers']->default->extern_numbermanager_sleep_time;
$host = false;
}
