<?php
	$r_id = $_GET['r_id'];
	$day = date("md");
	$r_id2="";
	if($r_id<10){
		$r_id2=0;
	}

	//各ルートの運行状態(0:運行終了,1:運行中,2:運行準備,3:点検など,4:運休)
	$status = rtrim(file_get_contents("./maintenance/data/location/status".$r_id2.$r_id.".txt", FILE_IGNORE_NEW_LINES));

	//現在の便番号
	$now_bin = rtrim(file_get_contents("./maintenance/data/location/bin".$r_id2.$r_id.".txt", FILE_IGNORE_NEW_LINES));

	$con = mysql_connect("localhost","event","L523GpA");
	if(!$con){
		unset($con);
		die("0.0,0.0");
	}
	$select_db = mysql_select_db("eventdb");
	if(!$select_db){
		unset($con,$select_db);
		die("0.0,0.0");
	}
	unset($select_db);
	mysql_query("set names utf8");
	$sql = "select log_lat,log_lng from nbus_log where log_day = '".$day."' and r_id = ".$r_id." order by log_time desc limit 1";
	$res = mysql_query($sql);
	if(!$res){
		unset($con,$select,$spl,$res,$day,$bus);
		die("0.0,0.0");
	}
	$row = mysql_fetch_array($res);
	mysql_free_result($res);
	$close = mysql_close($con);
	if(!$close){
		unset($con,$close,$day,$bus,$row,$sql,$close);
		die($row['log_lat'] . ',' . $row['log_lng']);
	}
	unset($con,$close,$day,$sql);
	if(($row['log_lat'] != null) && ($row['log_lng'] != null)){
		echo $row['log_lat'].",".$row['log_lng'].",".$status.",".$now_bin;
	}else{
		echo "0,0,0,".$now_bin;
	}
?>