Samuele E. Locatelli
81 lines
2.1 KiB
PHP
81 lines
2.1 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);
|
|
}
|
|
|
|
$user_id=$_REQUEST['u_id'];
|
|
$reg_id=$_REQUEST['r_id'];
|
|
|
|
if (!empty($_REQUEST['u_id_old'])){
|
|
$user_id_old=$_REQUEST['u_id_old'];
|
|
}
|
|
else{
|
|
$user_id_old=0;
|
|
}
|
|
if (!empty($_REQUEST['lat'])){
|
|
$user_latitude=$_REQUEST['lat'];
|
|
}
|
|
else{
|
|
$user_latitude=0;
|
|
}
|
|
if (!empty($_REQUEST['lon'])){
|
|
$user_longitude=$_REQUEST['lon'];
|
|
}
|
|
else{
|
|
$user_longitude=0;
|
|
}
|
|
|
|
$migrated=0;
|
|
if ($user_id_old<>0&&$user_id<>0){
|
|
$sql=mysql_query("select user_id from gcm where user_id=$user_id_old limit 1");
|
|
if (mysql_num_rows($sql))
|
|
{
|
|
//gcm
|
|
$sql=mysql_query("update gcm set user_id=$user_id,user_id_old=$user_id_old,migrated=1,date=now(),reg_id='$reg_id' where user_id=$user_id_old");
|
|
if ($sql){
|
|
print("migrated");
|
|
$migrated=1;
|
|
}
|
|
|
|
//contest_nick
|
|
$sql=mysql_query("update contest_nick set last_known_user_id=$user_id where last_known_user_id=$user_id_old");
|
|
|
|
//banned
|
|
$sql=mysql_query("update banned set user_id=$user_id where user_id=$user_id_old");
|
|
|
|
//personal_ban
|
|
$sql=mysql_query("update personal_ban set user_id_from=$user_id where user_id_from=$user_id_old");
|
|
$sql=mysql_query("update personal_ban set user_id_to=$user_id where user_id_to=$user_id_old");
|
|
|
|
//subscriptions
|
|
$sql=mysql_query("update subscriptions set user_id=$user_id where user_id=$user_id_old");
|
|
}
|
|
}
|
|
|
|
if ($migrated==0){
|
|
if ($user_latitude<>0 and $user_longitude<>0){
|
|
$sql = mysql_query("replace into gcm (user_id,reg_id,last_latitude,last_longitude,date) values ($user_id,'$reg_id',$user_latitude,$user_longitude,now())");
|
|
}
|
|
else{
|
|
$sql = mysql_query("replace into gcm (user_id,reg_id,date) values ($user_id,'$reg_id',now())");
|
|
}
|
|
if ($sql){
|
|
print("ok");
|
|
}
|
|
else{
|
|
print("nok");
|
|
}
|
|
}
|
|
|
|
mysql_close();
|
|
?>
|