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

34 lines
2.0 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 online_chat_eng where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_ita where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_es where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_zh where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_jp where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_pt where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_chat_tag where date < date_sub(now(), interval 20 minute)");
$sql=mysql_query("delete from online_users where date < date_sub(now(), interval 6 minute)");
$sql=mysql_query("update online_chat_eng set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_ita set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_es set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_zh set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_jp set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_pt set status=1 where date < date_sub(now(), interval 5 minute)");
$sql=mysql_query("update online_chat_tag set status=1 where date < date_sub(now(), interval 5 minute)");
mysql_close();
?>