Samuele E. Locatelli
27 lines
1.9 KiB
PHP
27 lines
1.9 KiB
PHP
<?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);
|
|
}
|
|
|
|
$sql=mysql_query("TRUNCATE automatic");
|
|
$sql=mysql_query("INSERT INTO automatic (latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider) SELECT latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider FROM automatic_emsc");
|
|
print("ok1");
|
|
$sql=mysql_query("INSERT INTO automatic (latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider) SELECT latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider FROM automatic_usgs");
|
|
print("ok2");
|
|
$sql=mysql_query("INSERT INTO automatic (latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider) SELECT latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider FROM automatic_ingv");
|
|
print("ok3");
|
|
$sql=mysql_query("INSERT INTO automatic (latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider) SELECT latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider FROM automatic_ign");
|
|
print("ok4");
|
|
$sql=mysql_query("INSERT INTO automatic (latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider) SELECT latitude,longitude,depth,magnitude,felt,cdi,pop25,pop100,pop200,data,code,place,tsunami,url,provider FROM automatic_csi");
|
|
print("ok5");
|
|
mysql_close();
|
|
?>
|