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

22 lines
800 B
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 notifications_copy");
$sql=mysql_query("INSERT INTO notifications_copy (ID,event,user_id,latitude,longitude,accuracy,delta_notification,data,calibrated,Charge,screenOn) SELECT ID,event,user_id,latitude,longitude,accuracy,delta_notification,data,calibrated,Charge,screenOn FROM notifications");
mysql_close();
?>