Files
EQN/appServer/distquake_download_delay6.php
2017-09-22 15:16:26 +02:00

79 lines
2.1 KiB
PHP

<?php
// Parse with sections
$ini = parse_ini_file("conf.ini", true);
mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
mysql_select_db($ini['db']['db']);
if ($ini['db']['log']=="1"){
$arrival_time=microtime(true);
$filename=basename(__FILE__);
$filename="log_".$filename.".txt";
$chunck=strval($arrival_time)." ".$_SERVER['REQUEST_URI']."\r\n";
file_put_contents($filename,$chunck,FILE_APPEND);
}
$sql=mysql_query("select avg(delay) as csi from delay_csi");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as csn from delay_guc");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as emsc from delay_emsc");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as funvisis from delay_funvisis");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as geonet from delay_geonet");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as igepn from delay_igepn");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as ign from delay_ign");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as ineter from delay_ineter");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as ingv from delay_ingv");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as inpres from delay_inpres");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as jma from delay_jma");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as rsn from delay_rsn");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as sgc from delay_sgc");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as ssn from delay_ssn");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
$sql=mysql_query("select avg(delay) as usgs from delay_usgs");
$e=mysql_fetch_assoc($sql);
$output[]=$e;
print(json_encode($output));
mysql_close();
?>