<?php
		$nodata = $_GET['rono'];
		$mood = $_GET['mord'];
		$lino = $_GET['lino'];
		$pointNo = $_GET['pono'];
		
		//DB接続
		$con = @mysql_connect("localhost","event","L523GpA");
		if(!$con){
			unset($con);
			die("1");
		}
		$db_select = @mysql_select_db("eventdb");
		if(!$db_select){
			unset($con,$db_select);
			die("2");
		}
		mysql_query("set names utf8");

		//バス停データ取得
		$res = @mysql_query("SELECT lat,lon,point_id FROM community_route WHERE line_num = ".$lino." and route_id = ".$nodata." order by point_id desc");
		if(!$res){
			unset($con,$db_select,$res);
			die("3");
		}
		for($i = 0;$row = mysql_fetch_array($res);$i++){
			$point[$i] = $row['point_id'];
			$ido[$i] = $row['lat'];
			$kid[$i] = $row['lon'];
		}
		$max = $i;
		//バックアップデータ取得
		$res2 = @mysql_query("SELECT lat,lon,point_id FROM community_route WHERE line_num = ".$lino." and route_id = 99 order by point_id asc");
		if(!$res2){
			unset($con,$db_select,$res,$res2);
			die("4");
		}
		for($i = 0;$row = mysql_fetch_array($res2);$i++){
			$point2[$i] = $row['point_id'];
			$ido2[$i] = $row['lat'];
			$kid2[$i] = $row['lon'];
		}
		mysql_free_result($res);
		mysql_free_result($res2);
		$close = @mysql_close($con);
		if(!$close){
			unset($con,$db_select,$res,$res2,$row,$ido,$kid,$point,$ido2,$kid2,$point2);
		}

		//DB接続
		$con = @mysql_connect("localhost","event","L523GpA");
		if(!$con){
			unset($con);
			die("5");
		}
		$db_select = @mysql_select_db("eventdb");
		if(!$db_select){
			unset($con,$db_select);
			die("6");
		}
		mysql_query("set names utf8");
		//追加時の戻る
		if($mood == 1){
			@mysql_query("DELETE FROM community_route WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$point2[0]);
		//削除時の戻る
		}else if($mood==2){
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);
			if($pointNo<=$max){
				$data3 = @mysql_query("UPDATE community_route SET lat= '".$ido2[0]."',lon = '".$kid2[0]."' WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$pointNo);
				for($i=$pointNo;$i<$max;$i++){
					$cnt=$i+1;
					$data1 = @mysql_query("UPDATE community_route SET lat= '".$ido[$i]."',lon = '".$kid[$i]."' WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$cnt);
				}
				$cnt3=$max+1;
				$data2 = mysql_query("insert into community_route (route_id,line_num,point_id,lat,lon) values(".$nodata.",".$lino.",'".$cnt3."','".$ido[0]."','".$kid[0]."')");
			}else{
				$cnt3=$max+1;
				$data2 = mysql_query("insert into community_route (route_id,line_num,point_id,lat,lon) values(".$nodata.",".$lino.",'".$cnt3."','".$ido2[0]."','".$kid2[0]."')");
			}
			if($data1 === true && $data2 === true && $data3 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}

			unset($max,$i,$data1,$data2,$data3);

		//書き換え時の戻る
		}else if($mood==3){
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);

			$data2 = mysql_query("UPDATE community_route SET lat = '".$ido2[0]."' WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$pointNo);
			$data3 = mysql_query("UPDATE community_route SET lon = '".$kid2[0]."' WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$pointNo);

			if($data2 === true && $data3 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}

			unset($data2,$data3);
		//挿入時の戻る
		}else if($mood==4){
			
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);

			if($pointNo<=$max){
				$data1 = @mysql_query("DELETE FROM community_route WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$pointNo);
				for($i=$max;$i>$pointNo+1;$i--){
					$cnt2=$i-1;
					$data2 = @mysql_query("UPDATE community_route SET lat= '".$ido[$max-$i]."',lon = '".$kid[$max-$i]."' WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$point[$max-$cnt2]);
				}
				$data3 = mysql_query("insert into community_route (route_id,line_num,point_id,lat,lon) values(".$nodata.",".$lino.",'".$pointNo."','".$ido[$max-$pointNo-1]."','".$kid[$max-$pointNo-1]."')");
				$data4 = @mysql_query("DELETE FROM community_route WHERE route_id = ".$nodata." and line_num = ".$lino." and point_id = ".$max);
			}
			
			if($data1 === true && $data2 === true && $data3 === true && $data4 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}
			unset($max,$cnt3,$i,$data1,$data2,$data3,$data4);
		}
		//mysql_query("DELETE FROM community_route WHERE route_id = 99");
		$close = @mysql_close($con);
		if(!$close){
			unset($con,$db_select,$ido,$kid,$point,$ido2,$kid2,$point2);
			die("7");
		}
		unset($con,$db_select,$ido,$kid,$point,$bus2,$ido2,$kid2,$point2);
		die("正常終了");
?>