Samuele E. Locatelli
63 lines
1.9 KiB
PHP
63 lines
1.9 KiB
PHP
<?php
|
|
$ini = parse_ini_file("conf.ini", true);
|
|
|
|
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);
|
|
}
|
|
|
|
$idmin=$_REQUEST['idmin'];
|
|
$postfix=$_REQUEST['postfix'];
|
|
$table="chat".$postfix;
|
|
|
|
$full=0;
|
|
|
|
if ($full==1){
|
|
mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
|
|
mysql_select_db($ini['db']['db']);
|
|
|
|
$sql=mysql_query('SET CHARACTER SET utf8');
|
|
$sql=mysql_query("SELECT * FROM (SELECT ID,user_code as user_id,nick,message,moderator,weather,day,TIMESTAMPDIFF(MINUTE,date, NOW()) AS difference FROM $table where ID>$idmin order by ID desc limit 200) AS dummy ORDER BY ID");
|
|
|
|
if (mysql_num_rows($sql))
|
|
{
|
|
while($e=mysql_fetch_assoc($sql))
|
|
$output[]=$e;
|
|
print(json_encode($output));
|
|
}
|
|
else{
|
|
print("no_new");
|
|
}
|
|
mysql_close();
|
|
}
|
|
else{
|
|
$filename="chat_table".$postfix.".txt";
|
|
if (file_exists($filename)){
|
|
$delta_time=time()-filemtime($filename);
|
|
}
|
|
else{
|
|
$delta_time=1000;
|
|
}
|
|
if ($delta_time>5)
|
|
{
|
|
mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
|
|
mysql_select_db($ini['db']['db']);
|
|
|
|
$sql=mysql_query('SET CHARACTER SET utf8');
|
|
$sql=mysql_query("SELECT * FROM (SELECT ID,user_code as user_id,nick,message,moderator,weather,day,TIMESTAMPDIFF(MINUTE,date, NOW()) AS difference FROM $table order by ID desc limit 200) AS dummy ORDER BY ID");
|
|
if (mysql_num_rows($sql)){
|
|
while($e=mysql_fetch_assoc($sql))
|
|
$output_file[]=$e;
|
|
$json_file = json_encode($output_file);
|
|
file_put_contents($filename,$json_file);
|
|
}
|
|
mysql_close();
|
|
}
|
|
$data = file_get_contents($filename);
|
|
print($data);
|
|
}
|
|
?>
|