Samuele E. Locatelli
52 lines
1.2 KiB
PHP
52 lines
1.2 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);
|
|
}
|
|
|
|
mysql_set_charset("utf8");
|
|
|
|
$user_id=$_REQUEST['user_id'];
|
|
$latitude=$_REQUEST['latitude'];
|
|
$longitude=$_REQUEST['longitude'];
|
|
$picture=$_REQUEST['picture'];
|
|
|
|
$sql=mysql_query("select * from banned where user_id=$user_id");
|
|
if (mysql_num_rows($sql))
|
|
{
|
|
$match=1;
|
|
}
|
|
else
|
|
{
|
|
$match=0;
|
|
}
|
|
|
|
if ($match==0)
|
|
{
|
|
$sql=mysql_query("select ID from manual_picture where user_id=$user_id and date>date_sub(NOW(), interval 1440 minute)");
|
|
if (mysql_num_rows($sql))
|
|
{
|
|
$ID=mysql_result($sql,0,"ID");
|
|
$sql=mysql_query("update manual_picture set picture='$picture' where ID=$ID");
|
|
}
|
|
else{
|
|
$sql=mysql_query("insert into manual_picture (user_id,latitude,longitude,picture) values ($user_id,$latitude,$longitude,'$picture')");
|
|
}
|
|
print('ok');
|
|
}
|
|
else
|
|
{
|
|
print('ko');
|
|
}
|
|
|
|
mysql_close();
|
|
?>
|