Samuele E. Locatelli
102 lines
3.4 KiB
PHP
102 lines
3.4 KiB
PHP
<?php
|
|
$ini = parse_ini_file("conf.ini", true);
|
|
|
|
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);
|
|
}
|
|
|
|
$filename="count_network.txt";
|
|
if (file_exists($filename)){
|
|
$delta_time=time()-filemtime($filename);
|
|
}
|
|
else{
|
|
$delta_time=1000;
|
|
}
|
|
|
|
if ($delta_time>15)
|
|
{
|
|
mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
|
|
mysql_select_db($ini['db']['db']);
|
|
|
|
$sql1=mysql_query("select count(*) as count_earthquakes from earthquakes where donotshow=0");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as count_green from notifications where latitude<>0 AND longitude<>0 AND enabled=1");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 count_red");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as count_past_earthquakes from earthquakes where latitude<>0 AND longitude<>0 AND falsealarm=0");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 as online_users");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 435-count(*) as top_100_available from subscriptions where top_100=1 or top_100_annual=1");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 1000-count(*) as top_1000_available from subscriptions where top_1000=1 or top_1000_annual=1");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 10000-count(*) as top_10000_available from subscriptions where top_10000=1 or top_10000_annual=1");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 as count_green_ong");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 as count_red_ong");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 as count_green_sc");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select 0 as count_red_sc");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as emsc_g from automatic_emsc where magnitude<3.5 and data > date_sub(now(), interval 1440 minute)");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as emsc_y from automatic_emsc where magnitude>=3.5 and magnitude<4.5 and data > date_sub(now(), interval 1440 minute)");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as emsc_r from automatic_emsc where magnitude>=4.5 and magnitude<5.5 and data > date_sub(now(), interval 1440 minute)");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select count(*) as emsc_p from automatic_emsc where magnitude>=5.5 and data > date_sub(now(), interval 1440 minute)");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$sql1=mysql_query("select latitude as max_lat,longitude as max_lon,magnitude as max_mag,place as max_place from automatic_emsc where data > date_sub(now(), interval 1440 minute) and magnitude=(select max(magnitude) from automatic_emsc where data> date_sub(now(), interval 1440 minute)) limit 1");
|
|
$e=mysql_fetch_assoc($sql1);
|
|
$output[]=$e;
|
|
|
|
$json_file = json_encode($output);
|
|
file_put_contents($filename,$json_file);
|
|
|
|
mysql_close();
|
|
}
|
|
|
|
$data = file_get_contents($filename);
|
|
print($data);
|
|
?>
|