<?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();
?>