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

27 lines
1.3 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("delete from chat_eng_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_ita_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_es_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_zh_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_jp_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_pt_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from chat_tag_gen where date < date_sub(now(), interval 2 day)");
$sql=mysql_query("delete from weather_recent where earthquake_date < date_sub(now(), interval 2 day)");
$sql=mysql_query("update earthquakes set donotshow=1 where date < date_sub(now(), interval 24 hour)");
mysql_close();
?>