<?php
		$nodata = $_GET['r_id'];
		$mood = $_GET['mord'];

		//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 bus_name,busstop_id,stop_lat,stop_lng FROM nbus_master WHERE r_id = ".$nodata." order by busstop_id asc");
		if(!$res){
			unset($con,$db_select,$res);
			die("3");
		}
		for($i = 0;$row = mysql_fetch_array($res);$i++){
			$bus[$i] = $row['bus_name'];
			$ido[$i] = $row['stop_lat'];
			$kid[$i] = $row['stop_lng'];
			$no[$i] = $row['busstop_id'];
		}
		$max = $i;

		//バックアップデータ取得
		$res2 = @mysql_query("SELECT bus_name,busstop_id,stop_lat,stop_lng FROM nbus_master WHERE r_id = 99 order by busstop_id asc");
		if(!$res2){
			unset($con,$db_select,$res,$res2);
			die("4");
		}
		for($i = 0;$row = mysql_fetch_array($res2);$i++){
			$bus2[$i] = $row['bus_name'];
			$ido2[$i] = $row['stop_lat'];
			$kid2[$i] = $row['stop_lng'];
			$no2[$i] = $row['busstop_id'];
		}
		mysql_free_result($res);
		mysql_free_result($res2);
		$close = @mysql_close($con);
		if(!$close){
			unset($con,$db_select,$res,$res2,$row,$bus,$ido,$kid,$no,$bus2,$ido2,$kid2,$no2);
		}
		$flag = $i;
		//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 nbus_master WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);
		//削除時の戻る
		}else if($mood==2){
			/**/
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);

			if($max >= $no2[0]){
				$data1 = mysql_query("UPDATE nbus_master SET bus_name = '".$bus2[0]."',stop_lat= '".$ido2[0]."',stop_lng = '".$kid2[0]."' WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);
				$data2 = true;
				for($i = $no2[0] + 1;$i <= $max;$i++){
					$cnt3 = $i - 2;
					$data3 = mysql_query("UPDATE nbus_master SET bus_name = '".$bus[$cnt3]."',stop_lat= '".$ido[$cnt3]."',stop_lng = '".$kid[$cnt3]."' WHERE r_id = ".$nodata." and busstop_id = ".$i);
					if($data3 === false)
						$data2 = false;
				}
				$cnt4 = $max - 1;
				$i = $max+1;
				$data3 = mysql_query("insert into nbus_master (r_id,busstop_id,bus_name,stop_lat,stop_lng) values(".$nodata.",".$i.",'".$bus[$cnt4]."','".$ido[$cnt4]."','".$kid[$cnt4]."')");
			}else{
				mysql_query("insert into nbus_master (r_id,busstop_id,bus_name,stop_lat,stop_lng) values(".$nodata.",".$no2[0].",'".$bus2[0]."','".$ido2[0]."','".$kid2[0]."')");
			}

			/**/
			if($data1 === true && $data2 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}

			unset($max,$cnt4,$i,$data1,$data2,$data3);
		//書き換え時の戻る
		}else if($mood==3){
			/**/
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);

			$data1 = mysql_query("UPDATE nbus_master SET bus_name = '".$bus2[0]."' WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);
			$data2 = mysql_query("UPDATE nbus_master SET stop_lat= '".$ido2[0]."' WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);
			$data3 = mysql_query("UPDATE nbus_master SET stop_lng = '".$kid2[0]."' WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);

			/**/
			if($result === true && $data1 === true && $data2 === true && $data3 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}

			unset($data1,$data2,$data3);
		//挿入時の戻る
		}else if($mood==4){
			/**/
			//トランザクションをはじめる準備
			$Query = "set autocommit = 0";
			mysql_query($Query);

			//トランザクション開始
			$Query = "begin";
			mysql_query($Query);

			$data1 = mysql_query("DELETE FROM nbus_master WHERE r_id = ".$nodata." and busstop_id = ".$no2[0]);
			$data2 = true;
			if($max >= $no2[0]){
				for($i = $no2[0] + 1;$max >= $i;$i++){
					$cnt2 = $i - 1;
					$data3 = mysql_query("UPDATE nbus_master SET busstop_id = '".$cnt2."' WHERE r_id = ".$nodata." and busstop_id = ".$i);
					if($data3 === false)
						$data2 = false;
				}

			}

			/**/
			if($data1 === true && $data2 === true){
			//コミット
				$Query = "commit";
				mysql_query($Query);
			}else{
			//ロールバック
				$Query = "rollback";
				mysql_query($Query);
			}
			unset($max,$cnt3,$i,$data1,$data2,$data3);
		}
		mysql_query("DELETE FROM nbus_master WHERE r_id = 99");
		$close = @mysql_close($con);
		if(!$close){
			unset($con,$db_select,$bus,$ido,$kid,$no,$bus2,$ido2,$kid2,$no2);
			die("7");
		}
		unset($con,$db_select,$bus,$ido,$kid,$no,$bus2,$ido2,$kid2,$no2);
		die("正常終了");
?>