monitor-frontend/functions.inc.php

<?php
/*
 *      PHP Frontend for pocsag monitor
 *
 *      Copyright (C) 2004-2005
 *          Manuel Weiser (manuelw@fire-devils.org)
 *
 *      This program is free software; you can redistribute it and/or modify
 *      it under the terms of the GNU General Public License as published by
 *      the Free Software Foundation; either version 2 of the License, or
 *      (at your option) any later version.
 *
 *      This program is distributed in the hope that it will be useful,
 *      but WITHOUT ANY WARRANTY; without even the implied warranty of
 *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *      GNU General Public License for more details.
 *
 *      You should have received a copy of the GNU General Public License
 *      along with this program; if not, write to the Free Software
 *      Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
 */

// Status pr<70>fen, berichtigen, ersetzen
function repair_status($kennung, $zeit_neu, $status_alt, $zeit_alt) {
	global $korr_status_zeit, $status_kfz;

	$spanne = mktime(substr($zeit_neu,8,2), substr($zeit_neu,10,2), substr($zeit_neu,12,2), substr($zeit_neu,4,2), substr($zeit_neu,6,2), substr($zeit_neu,0,4)) - mktime(substr($zeit_alt,8,2), substr($zeit_alt,10,2), 0, substr($zeit_alt,4,2), substr($zeit_alt,6,2), substr($zeit_alt,0,4));
	$spanne = (int)($spanne / 60);
	
    if( $spanne > $korr_status_zeit )
    {
		// Wenn FW
		if( substr($kennung,0,1) == '6' )
		{
			if( $status_alt == '1' ) $neu["status"] = '2';
			if( $status_alt == '2' ) $neu["status"] = '3';
			if( $status_alt == '3' ) $neu["status"] = '4';
			if( $status_alt == '9' ) $neu["status"] = '4';
			if( $status_alt == '4' ) $neu["status"] = '1';
			if( $status_alt == '6' ) $neu["status"] = '2';
		}
		// Wenn RD
		else
		{
			if( $status_alt == '1' ) $neu["status"] = '2';
		    if( $status_alt == '2' ) $neu["status"] = '3';
			if( $status_alt == '3' ) $neu["status"] = '4';
			if( $status_alt == '9' ) $neu["status"] = '4';
			if( $status_alt == '4' ) $neu["status"] = '7';
			if( $status_alt == '6' ) $neu["status"] = '2';
			if( $status_alt == '7' ) $neu["status"] = '8';
			if( $status_alt == '8' ) $neu["status"] = '1';
		}

		$neu["text"]    = $status_kfz[$neu["status"]].' (R)';
		$neu["db"] = 1;
		
    }
    else
    {
        $neu["status"] = '15';
		$neu["text"] = 'LST: automatische Quittung (R)';
        $neu["db"] = 0;
        //$show_stats = 0;
    }
    
    return $neu;
}

function check_stiwo($stiwo, $text) {
	
	$stiwo = explode(",", $stiwo);

	if( is_array($stiwo) )
	{
		foreach( $stiwo AS $v )
		{
			if( eregi($v, $text) )
			{
				$do = "hit";
			}
		}
	}
	
	return $do;
}

// Datum auslesen
function get_date($time) {
	$jahr	= substr($time,0,4);
	$monat	= substr($time,4,2);
	$tag	= substr($time,6,2);

	$time	= strftime("%d.%m.%Y", mktime(0,0,0, $monat,$tag,$jahr));

	return $time;
}

// Datum lang auslesen
function get_date_long($time) {
	$jahr	= substr($time,0,4);
	$monat	= substr($time,4,2);
	$tag	= substr($time,6,2);
	
	$time	= strftime("%A, %d.%m.%Y", mktime(0,0,0, $monat,$tag,$jahr));
	
	return $time;
}

// Stunde:Minute:Sekunde aus Timestamp lesen
function get_time($time) {
	$h	= substr($time,-6,2);
	$m	= substr($time,-4,2);
	$s	= substr($time,12,2);
		
	$time 	= $h.':'.$m.':'.$s;
	return $time;
}

function get_timestamp($time) {
	$jahr	= substr($time,0,4);
	$monat	= substr($time,4,2);
	$tag	= substr($time,6,2);
	$h	= substr($time,-6,2);
	$m	= substr($time,-4,2);
	$s	= substr($time,12,2);
	
	$time = mktime($h, $m, $s, $monat, $tag, $jahr);
	
	return $time;
}

// Tag auslesen
function get_day($time) {
	$day	= substr($time,6,2);
	
	return $day;
}

// Filter Zeit errechnen
function filter_zeit($filter) {
	$filter = date("YmdHis", mktime(date("G")-$filter,date("i"),date("s"), date("m"),date("d"),date("Y")));
    //$filter = date("Y-m-d H:i:s", mktime(date("G")-$filter,date("i"),date("s"), date("m"),date("d"),date("Y")));
	return $filter;
}

function get_org($kennung) {
	global $bos_org, $bos_ort;

	$org	= substr($kennung,0,1);
	$ort	= substr($kennung,1,3);
	
	$bos    = $bos_org[$org].' '.$bos_ort[$ort]; //.' <font color="black"> | </font>';
	
	return $bos;

	//return $bos_org[$org].' '.$bos_ort[$ort].' <font color="black"> | </font>';
}

function search_time_small($time) {
	list($stunde, $minute) = explode(":", $time);
	$time = $stunde.$minute;
	
		return $time;
}

function get_hour($time) {
	list($stunde, $minute, $sekunde) = explode(":", $time);
	
	return $stunde;
}

function ip2str($ip) {
    //$ip = preg_replace("/(\d{1,3})\.?/e", 'sprintf("%03d", \1)', $ip);
    $ip = preg_replace_callback(
        "/(\d{1,3})\.?/",
        function($matches){
            foreach($matches as $match){
                return sprintf("%03d", $match);
            }
        },
        $ip
    );

    return (string)$ip;
}

####################################################
#function get_day($feld) {
#	if ($feld == 1) return 'Montag';
#	if ($feld == 2) return 'Dienstag';
#	if ($feld == 3) return 'Mittwoch';
#	if ($feld == 4) return 'Donnerstag';
#	if ($feld == 5) return 'Freitag';
#	if ($feld == 6) return 'Samstag';
#	if ($feld == 7) return 'Sonntag';
#}

function check_url ($url) {
	if (!$url)
	{
		$url = 'http://';
	}
	else 
	{
		list($http, $www) = explode(":", $url);
			if ($http != 'http') $url = 'http://'.$url;
	}
	
	return $url;
}

function span2min($from,$to) {
	list($f_stunde, $f_minute, $f_sek) = explode(":", $from);
	list($t_stunde, $t_minute, $t_sek) = explode(":", $to);
	
		$stunden = ($t_stunde - $f_stunde) * 60;
		$minuten = ($f_minute - $t_minute);
		$span	 = ($stunden - $minuten);
		
		return $span;
}

function span2hour($from,$to) {
	list($f_stunde, $f_minute, $f_sek) = explode(":", $from);
	list($t_stunde, $t_minute, $t_sek) = explode(":", $to);
	
		//if ($t_stunde == '00') $t_stunde = '24';
		if ($t_stunde < $f_stunde) $t_stunde = (24 + $t_stunde);
	
		if ($t_minute >= $f_minute)
		{
			$stunden = ($t_stunde - $f_stunde);
			$minuten = ($t_minute - $f_minute);
		}
		else
		{
			$stunden = ($t_stunde - $f_stunde) -1;
			$minuten = 60 - ($f_minute - $t_minute);
		}
		
			if ($stunden != 1) { $h_text = ' Stunden '; } else { $h_text = ' Stunde '; }
			if ($minuten != 1) { $m_text = ' Minuten '; } else { $m_text = ' Minute '; }
			
		return ('<b>'.$stunden.'</b>'.$h_text.'<b>'.$minuten.'</b>'.$m_text);
}

function span2hour_short($from,$to) {
	list($f_stunde, $f_minute, $f_sek) = explode(":", $from);
	list($t_stunde, $t_minute, $t_sek) = explode(":", $to);
	
		//if ($t_stunde == '00') $t_stunde = '24';
		if ($t_stunde < $f_stunde) $t_stunde = (24 + $t_stunde);
	
		if ($t_minute >= $f_minute)
		{
			$stunden = ($t_stunde - $f_stunde);
			$minuten = ($t_minute - $f_minute);
		}
		else
		{
			$stunden = ($t_stunde - $f_stunde) -1;
			$minuten = 60 - ($f_minute - $t_minute);
		}
		
			if ($stunden != 1) { $h_text = ' Stunden '; } else { $h_text = ' Stunde '; }
			if ($minuten != 1) { $m_text = ' Minuten '; } else { $m_text = ' Minute '; }
			
		return ($stunden.':'.$minuten);
}

function add_span2db ($span,$dbspan) {
	list($new_stunden, $new_minuten) = explode(":", $span);
	list($old_stunden, $old_minuten) = explode(":", $dbspan);
	
		$stunden = ($new_stunden + $old_stunden);
		$minuten = ($new_minuten + $old_minuten);
		
		if ($minuten > 60)
		{
			$minuten = $minuten - 60;
			$stunden = $stunden + 1;
		}
		
		return (doublenum($stunden).':'.doublenum($minuten));
}

function del_span2db ($span,$dbspan) {
	list($del_stunden, $del_minuten) = explode(":", $span);
	list($old_stunden, $old_minuten) = explode(":", $dbspan);
	
		$stunden = ($old_stunden - $del_stunden);
		$minuten = ($old_minuten - $del_minuten);
		
		if ($minuten < 0)
		{
			$minuten = 60 + $minuten;
			$stunden = $stunden - 1;
		}
		
		return (doublenum($stunden).':'.doublenum($minuten));
}

function split_time($split) {
	list($stunde, $minute) = explode(":", $split);

			if ($stunde != 1) { $h_text = ' Stunden '; } else { $h_text = ' Stunde '; }
			if ($minute != 1) { $m_text = ' Minuten '; } else { $m_text = ' Minute '; }
	
		return ('<b>'.$stunde.'</b>'.$h_text.'<b>'.$minute.'</b>'.$m_text);
}

function split_year($split) {
	list($jahr, $monat, $tag) = explode("-", $split);
	
	return $jahr;
}

function split_month($split) {
	list($jahr, $monat, $tag) = explode("-", $split);
	
	return $monat;
}

function split_day($split) {
	list($jahr, $monat, $tag) = explode("-", $split);
	
	return $tag;
}

function split_kfz($kfz) {
	$kfz = explode(",", $kfz);

	return $kfz;
}

function count_total($tocount) {
	$result = mysqli_query($dbconn, "SELECT Count(*) as $tocount FROM $tocount");
	$result = mysqli_fetch_array($result);
	return $result[$tocount];
}

function minimize($num) {
	$wert = 40 * $num / 100;
	$wert = $num - $wert;
	return $wert;
}

function doublenum($num) {
	if($num < 10) $num = '0'.$num;
	return $num;	
}

function gettemplate($template,$endung="html") {
	return str_replace("\"","\\\"",implode("",file($template.".".$endung)));
}

function dooutput($template) {
	echo $template;
}

function banner_typ($typ) {
  list($bild, $typ) = explode(".", $typ);
  return $typ;
}

function date_format_fw($setdate) {
  list($jahr, $monat, $tag) = explode("-", $setdate);
  return sprintf("%02d.%02d.%04d", $tag, $monat, $jahr);
}

function date_long_format($setdate) {
  list($jahr, $monat, $tag) = explode("-", $setdate);
  //return sprintf("%02d.%02d.%04d", $tag, $monat, $jahr);
  return strftime("%A, %d. %B %Y", mktime(0,0,0, date($monat),date($tag),date($jahr)));
}


function date_dbformat($setdate) {
  list($tag, $monat, $jahr) = explode(".", $setdate);
  return sprintf("%04d-%02d-%02d", $jahr, $monat, $tag);
}

function time_format($settime) {
  list($stunde, $minute, $sek) = explode(":", $settime);
  return sprintf("%02d:%02d", $stunde, $minute);
}

    function compile_db_string($data) {
    
    	$field_names  = "";
		$field_values = "";
		
		foreach ($data as $k => $v) {
			$v = preg_replace( "/'/", "\\'", $v );
			$field_names  .= "$k,";
			$field_values .= "'$v',";
		}
		
		$field_names  = preg_replace( "/,$/" , "" , $field_names  );
		$field_values = preg_replace( "/,$/" , "" , $field_values );
		
		return array( 'FIELD_NAMES'  => $field_names,
			      'FIELD_VALUES' => $field_values,
			    );
	}
	
	function pass_erstellen ($wert) {
		if (!isset($pass)) $pass="";
        $i = 0;
		 while($i < $wert) {
		  mt_srand((double)microtime()*1000000);
		  $zahl = mt_rand(1,20);
		  if ($zahl == 4) {
		   $zahl = mt_rand(0,9);
		   $pass = $pass.$zahl;
		  } else {
		   $zahl = mt_rand(97,122);
		   $zufall = mt_rand(1,2);
		   if ($zufall == 2) {
		    $pass = $pass.strtoupper(chr($zahl));   
		   } else {
		    $pass = $pass.chr($zahl);
		   }
		  }
		  $i++; 
		 }
		 return $pass;
	}

function no_access($text) {
	return '<br>
        <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
          <tr background="images/box_back.gif">
	        <td colspan="2" background="images/box_back.gif">
			  	<font color="#FF0000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>&nbsp;No Access</strong></font>
			</td>
          </tr>
          <tr bgcolor="#FFFFFF">
            <td class="text_normal">
				<br><div align="center">'.$text.'</div><br>
			</td>
          </tr>
          <tr>
            <td height="30" bgcolor="#FFFFFF">
				<div align="center"><a href="javascript:history.back()">zurck</a></div>
			</td>
          </tr>
        </table>';
}

function gohome($goto) {
  $refresh = '<meta http-equiv="refresh" content="1;URL='.$goto.'">';
  return $refresh;
}

function clean_htmlCode($text) {
	$text = stripslashes($text);
	$text = strip_tags($text, '<br>');
	return $text;
}

function htmlCode_message($post) {
	$post = str_replace("ä","&auml;",$post);
	$post = str_replace("ö","&ouml;",$post);
	$post = str_replace("ü","&uuml;",$post);
	$post = str_replace("ß","&szlig;",$post);
	$post = str_replace("Ö","&Ouml;",$post);
	$post = str_replace("Ä","&Auml;",$post);
	$post = str_replace("Ü","&Uuml;",$post);
	
	$post = str_replace("</div>","",$post);
		
	$post= stripslashes($post);
	return $post;
}

function mail_message_header($post) {
	$post = str_replace(utf8_decode("ä"),"ae",$post);
	$post = str_replace(utf8_decode("Ä"),"AE",$post);
	$post = str_replace(utf8_decode("ö"),"oe",$post);
	$post = str_replace(utf8_decode("Ö"),"OE",$post);
	$post = str_replace(utf8_decode("ü"),"ue",$post);
	$post = str_replace(utf8_decode("Ü"),"UE",$post);
	$post = str_replace(utf8_decode("ß"),"sz",$post);
		
	$post= stripslashes($post);
	return $post;
}

function mail_message_body($post) {
	$post = str_replace(utf8_decode("ä"),"ae",$post);
	$post = str_replace(utf8_decode("Ä"),"Ae",$post);
	$post = str_replace(utf8_decode("ö"),"oe",$post);
	$post = str_replace(utf8_decode("Ö"),"Oe",$post);
	$post = str_replace(utf8_decode("ü"),"ue",$post);
	$post = str_replace(utf8_decode("Ü"),"Ue",$post);
	$post = str_replace(utf8_decode("ß"),"sz",$post);
		
	$post= stripslashes($post);
	return $post;
}

function mail_pass($email,$pass) {
  global $monitordomain, $monitoremail;
			
			$body = ("--------------------------------------------------------\n"
				."Login zur Pocsag Seite\n"
				."--------------------------------------------------------\n\n"
				."Über folgenden Link kannst du die Pocsag Seite besuchen: \n"
                ."$monitordomain?login=$pass \n\n"
                ."ACHTUNG: Der Link ist nur einmal gültig! \n\n"
				."--------------------------------------------------------\n"
				."Dies ist eine automatische EMail auf eine Loginanfrage. \n"
				."--------------------------------------------------------");
			$xtra    = "From: $monitoremail (Monitor)\n";
			$xtra   .= "Content-Type: text/plain; charset=UTF-8\n";
			$xtra   .= "MIME-Version: 1.0\n";
			$xtra   .= "Content-Transfer-Encoding: 8bit\n";
			$xtra   .= "X-Mailer: PHP ". phpversion();
			mail("$email", "Monitor Loginanfrage", $body, $xtra);
}

function mail_alarm($datum,$zeit,$email,$org,$org_name,$bezeichnung,$text) {
	global $monitoremail;
	
			$body = ("--------------------------------------------------------\n"
				."Alarmauslösung für $org $org_name \n"
				."--------------------------------------------------------\n\n"
				."Datum: $datum, $zeit \n"
				."Bezeichnung: $bezeichnung \n\n"
   				."Info: $text \n\n"
				."--------------------------------------------------------\n"
				."Dies ist eine automatische Info-EMail. \n"
				."--------------------------------------------------------");
			$xtra    = "From: $monitoremail (Monitor)\n";
			$xtra   .= "Content-Type: text/plain; charset=UTF-8\n";
			$xtra   .= "MIME-Version: 1.0\n";
			$xtra   .= "Content-Transfer-Encoding: 8bit\n";
			$xtra   .= "X-Mailer: PHP ". phpversion();
			mail("$email", "Monitor Alarm: $org ".mail_message_header($org_name), $body, $xtra);
}

function mail_alarm_sms($datum,$zeit,$email,$org,$org_name,$text) {
	global $monitoremail;
	
			$body 	= ("$datum, $zeit");
			$xtra    = "From: $monitoremail (Monitor)\n";
			$xtra   .= "Content-Type: text/plain; charset=UTF-8\n";
			$xtra   .= "MIME-Version: 1.0\n";
			$xtra   .= "Content-Transfer-Encoding: 8bit\n";
			$xtra   .= "X-Mailer: PHP ". phpversion();
			mail("$email", "$org ".mail_message_header($org_name).": ".mail_message_body($text), $body, $xtra);
}

$timestampnow				= date("YmdHis");
$timestamp_date_now			= date("Ymd");
$datnow 					= date("Y-m-d", mktime(0,0,0, date("m"),date("d"),date("Y")));
$dat2month 					= date("Y-m-d", mktime(0,0,0, date("m")-2,date("d"),date("Y")));
$dat3month 					= date("Y-m-d", mktime(0,0,0, date("m")-3,date("d"),date("Y")));
$datshownow					= date_format_fw(date("Y-m-d", mktime(0,0,0, date("m"),date("d"),date("Y"))));
$datlargenow 				= strftime("%A, %d.%m.%Y", mktime(0,0,0, date("m"),date("d"),date("Y")));
$yearnow 					= date("Y", mktime(0,0,0, date("m"),date("d"),date("Y")));
$monthnow					= date("m", mktime(0,0,0, date("m"),date("d"),date("Y")));
$timenow 					= date("G:i");
$timenowlong				= date("G:i:s");
$useronlinetime				= date("Y-m-d H:i:s", mktime(date("H"),date("i")-5,date("s"), date("m"),date("d"),date("Y")));

function remove_idea_codes($input) {
    $toRemove = array(
    	"<DC1>",
        "<DC2>",
        "<DC3>",
        "<ENQ>",
        "<ETX>",
        "<BS>",
        "<ESC>",
        "<ETB>",
        "<RS>",
        "<ACK>",
        "<CAN>",
        "<GS>",
        "<HT>",
        "<LF>",
        "<US>",
        "<DEL>",
        "<SUB>",
        "<DLE>"
	);

    return str_replace($toRemove, " ", $input);
	//return $input;
}