<?php
	ini_set("display_errors", 1);
	error_reporting(E_ALL);
	$id = file_get_contents("./next_id.txt", FILE_IGNORE_NEW_LINES);//開始位置
	$con = @mysql_connect("localhost","event","L523GpA");
	if(!$con){
		unset($con);
		die();
	}
	$db_select = @mysql_select_db("eventdb");
	mysql_query("set names utf8");
	$sql = "select max(kanko_id) as max_id  from display_master where kanko_id!=999";
	$res = @mysql_query($sql);
	$row = mysql_fetch_array($res);
	$insert_id=($row['max_id']+1);
	mysql_free_result($res);
	$close = @mysql_close($con);
	if(!$close){
		unset($con,$sql,$res,$max,$db_select);
		die();
	}
	unset($con,$sql,$res,$db_select,$row);

	$con = @mysql_connect("localhost","crawler","crawler2016");
	if(!$con){
		unset($con);
		die();
	}
	$db_select = @mysql_select_db("crawlerdb");
	mysql_query("set names latin1");
	$sql2 = "select id,name,description,event_at,img_url,address,location from takaoka_soc_events where id > ".$id." order by id asc";
	$res2 = @mysql_query($sql2);
	for($i=0;$row2 = mysql_fetch_array($res2);$i++){
		$location=explode(",", $row2['location']);
		$lat[$i]=$location[0];
		$lng[$i]=$location[1];
		if($row2['img_url']!=null){
			$img_url[$i]=$row2['img_url'];
		}else{
			$img_url[$i]=null;
		}
		$name[$i]=$row2['name'];
		$description[$i]=$row2['description'];
		$event_at[$i]=$row2['event_at'];
		$address[$i]=$row2['address'];
		$id=$row2['id'];
	}
	$loop_cnt=$i;
	mysql_free_result($res2);
	$close = @mysql_close($con);
	if(!$close){
		unset($con,$sql,$res2,$row2,$db_select);
		die();
	}
	$con = @mysql_connect("localhost","event","L523GpA");
	if(!$con){
		unset($con);
		die();
	}
	$db_select = @mysql_select_db("eventdb");
	mysql_query("set names utf8");
	for($i=0;$i<$loop_cnt;$i++){
		if($lat[$i]!=null){
			if($img_url[$i]!=null){
				mysql_query("insert into display_master (kanko_id,kanko_name,kanko_ido,kanko_keido,janru_id,gazoufile,regist_date,update_date) values(".$insert_id.",'".$name[$i]."','".$lat[$i]."','".$lng[$i]."',3,'".$img_url[$i]."',now(),now())");
			}else{
				mysql_query("insert into display_master (kanko_id,kanko_name,kanko_ido,kanko_keido,janru_id,gazoufile,regist_date,update_date) values(".$insert_id.",'".$name[$i]."','".$lat[$i]."','".$lng[$i]."',3,'toshinaga.jpg',now(),now())");
			}
		}
		mysql_query("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",0, '".$description[$i]."')");
		mysql_query("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",1, ' ')");
		mysql_query("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",2, '開催場所等".$event_at[$i]."')");
		mysql_query("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",3, '".$address[$i]."')");
		for($cnt=4;$cnt<8;$cnt++){
			mysql_query("insert into  display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",".$cnt.", ' ')");
		}
		$insert_id++;
	}
	//次回の読み込み開始場所の記録
	$next_id=fopen("./next_id.txt", "a");
	if(flock($next_id,LOCK_EX)){
		ftruncate($next_id,0);
		fwrite($next_id,$id);
	}
	fclose($next_id);
	mysql_free_result($res2);
	$close = @mysql_close($con);
	if(!$close){
		unset($con,$sql,$res,$db_select,$kanko_id,$row,$res2,$next_id,$id,$cnt,$insert_id,$address,$description,$event_at,$name,$lat,$lng,$img_url,$loop_cnt);
		die();
	}
	unset($con,$sql,$res,$db_select,$kanko_id,$row,$res2,$next_id,$id,$cnt,$insert_id,$address,$description,$event_at,$name,$lat,$lng,$img_url,$loop_cnt);
?>