<?php
       $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);
      }
       mysql_set_charset("utf8");

      $q=mysql_query("SELECT latitude,longitude,depth,magnitude,pop25,pop100,pop200,cdi AS intensity,place,tsunami,url,provider,TIMESTAMPDIFF(MINUTE,data,NOW()) AS difference FROM (select * from automatic_emsc union select * from automatic_usgs union select * from automatic_ingv union select * from automatic_ign) as a WHERE a.data > date_sub(NOW(), interval '".$_REQUEST['timeframe']."' minute) AND a.magnitude>='".$_REQUEST['magnitude']."' ORDER BY a.data DESC");

      while($e=mysql_fetch_assoc($q))

              $output[]=$e;

      print(json_encode($output));

     
      mysql_close();
?>