<?

//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);
//error_reporting(E_ALL);

include_once('lib/tbs_class.php');
include_once('lib/plugins/tbs_plugin_html.php');
include_once('lib/plugins/tbs_plugin_bypage.php'); // Plug-in By-Page
include_once('lib/plugins/tbs_plugin_navbar.php'); // Plug-in Navigation Bar
include_once('lib/plugins/tbs_plugin_cache.php'); 

$webname="訂房優惠報報";
$titleadd="";
$updatetime=date("Y-m-d");

include "myfunc.php";
//include_once "pageview.php";

if ( isset($_GET['pid']) ) {
	$pid=$_GET['pid'];
}

$cache_file="entry-" . $pid;

$TBS = new clsTinyButStrong ;
$TBS->PlugIn(TBS_INSTALL, TBS_CACHE, './tbscache', 'cache_*.html'); // Install the plug-in

if ($TBS->PlugIn(TBS_CACHE,$cache_file,604800)) {
	if ( filesize($cache_file) == '0' ) {
		header('Location: /');	
	}
	die();
}

include "cg.php";

$blog_sql="SELECT *,P2.id as pid FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN `parser_keyword_nature` P2 ON P.keyword_id = P2.keyword_id WHERE P2.id != \"$pid\" AND img != '' GROUP BY url";
$list_sql="SELECT *,P2.id as pid FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN `parser_keyword_nature` P2 ON P.keyword_id = P2.keyword_id WHERE P2.img = '' AND P2.type = 'a'";
$yt_sql="SELECT *,P2.id as pid FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN `parser_keyword_nature` P2 ON P.keyword_id = P2.keyword_id WHERE P2.type= 'y' AND P2.domain_name = 'https://www.youtube.com'";

$relate_ky_sql="SELECT * FROM ( SELECT map_keyword_id FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN keyword_relate R ON P.keyword_id = R.keyword_id ) A JOIN keyword K2 ON A.map_keyword_id = K2.id WHERE K2.is_parser_content = '2' AND K2.status != '8' ORDER BY RAND() limit 0,7";
$map_ky_sql="SELECT * FROM ( SELECT R.keyword_id FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN keyword_relate R ON P.keyword_id = R.map_keyword_id ) A JOIN keyword K2 ON A.keyword_id = K2.id WHERE level != '0' AND K2.is_parser_content = '2' AND K2.status != '8' ORDER BY RAND() limit 0,8";
$all_ky_sql="SELECT * FROM ( SELECT R.keyword_id FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN keyword_relate R ON P.keyword_id = R.map_keyword_id ) A JOIN keyword K2 ON A.keyword_id = K2.id WHERE level != '0' AND K2.is_parser_content = '2' AND K2.status != '8'";

$pid_sql="SELECT * FROM `parser_keyword_nature` WHERE id = \"$pid\"";
$pid_rst=mysqli_query($conn,$pid_sql)or die($dbquery_error);
if ( $pr=mysqli_fetch_array($pid_rst) ) {
	$pid_status=$pr['status'];
	if ( $pid_status == '9' ) {
		$ad_yesno="1";
	} else {
		$ad_yesno="0";
	}
} else {
	$ad_yesno="1";
	$none_to="https://" . $_SERVER['SERVER_NAME'];
	http_response_code(404);
	header($none_to);
	$TBS->LoadTemplate('template/none_to.html') ;
	$TBS->Show() ;
	die();
}


//$hotel_sql="SELECT * FROM ( SELECT SUBSTRING_INDEX(`kytype`, '_', -1) as hotel_id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN rowdata R ON K.hotel_id = R.hotel_id";
$ky_hotel_sql="SELECT GROUP_CONCAT(hotel_id) as hotel_ids FROM ( SELECT SUBSTRING_INDEX(`kytype`, '_', -1) as hotel_id FROM ( SELECT keyword_id FROM ( SELECT K1.id as id FROM `keyword` K1 JOIN ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P ON K1.id = P.keyword_id  ) K JOIN keyword_relate R ON ( K.id = R.map_keyword_id OR K.id = R.keyword_id ) ) A JOIN keyword K2 ON A.keyword_id = K2.id WHERE K2.is_parser_content = '2' AND K2.status != '8' GROUP BY kytype ) A";
$ky_hotel_rst=mysqli_query($conn,$ky_hotel_sql)or die($dbquery_error);
if ( $khr=mysqli_fetch_array($ky_hotel_rst) ) {
	$hotel_ids=$khr['hotel_ids'];
	
	if ( $hotel_ids == '' ) {
		$ky_hotelid_sql="SELECT SUBSTRING_INDEX(`kytype`, '_', -1) as hotel_id FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN keyword K ON P.keyword_id = K.id";
		$ky_hotelid_rst=mysqli_query($conn,$ky_hotelid_sql)or die($dbquery_error);
		if ( $khr2=mysqli_fetch_array($ky_hotelid_rst) ) {
			$hotel_ids=$khr2['hotel_id'];
		}
	}
	$hotel_sql="SELECT * FROM ( SELECT * FROM `rowdata` WHERE hotel_id in ($hotel_ids) limit 0,30 ) A ORDER BY ( rating_average * number_of_reviews ) desc limit 0,9";
	$hotel_rst=mysqli_query($conn,$hotel_sql)or die($dbquery_error);
	
	if ( $hr=mysqli_fetch_array($hotel_rst) ) {
		$zipcode=$hr['zipcode'];
		$city_id=$hr['city_id'];
		$city_name=$hr['city'];
		$photo1=$hr['photo1'];
		$photo2=$hr['photo2'];
	} else {
		$zipcode="";
		$city_id="4951";
		$city_name="";
		$photo1="https://i.imgur.com/H8YKUrg.jpg";
		$photo2="https://i.imgur.com/oEOjBKY.jpg";
	}
	$city_hotel_sql="SELECT * FROM ( SELECT * FROM `rowdata` WHERE hotel_id not in ($hotel_ids) AND `city_id` = \"$city_id\" ORDER BY ( rating_average * number_of_reviews ) desc limit 0,100 ) A ORDER BY RAND() limit 0,10";
} else {
	header('Location: https://twagoda.com/');
}

$keyword_plus_sql="SELECT * FROM `keyword_plus` WHERE type = 'e' AND tid = \"$pid\"";
$keyword_plus_rst=mysqli_query($conn,$keyword_plus_sql)or die($dbquery_error);
if ( $kpr=mysqli_fetch_array($keyword_plus_rst) ) {
	$title=$kpr['title'];
	$description=content_cut_php($kpr['content']);
	$content=$kpr['content'];
	$img=firstimg_php($kpr['content']);
	$geturl="";
	$url="https://igotojapan.com/entry/" . $pid;
	$keyword_plus="0";
	
} else {
	$entry_sql="SELECT *,UNCOMPRESS(content_bin) as content FROM `parser_keyword_nature` WHERE id = \"$pid\"";
	$entry_rst=mysqli_query($conn,$entry_sql)or die($dbquery_error);
	if ( $er=mysqli_fetch_array($entry_rst) ) {
		if ( $er['content'] == '' ) {
			$geturl=<<<EOF
<script type="text/javascript">
			$(document).ready(function() {
				$("#more").load("/readability.php?id=$pid #content");
			});
			</script>
EOF;
			$description=$er['description'];
			$content=$er['description'];
			$img=photo2bigphp($photo1);
			$title=$er['title'];
			$url=$er['url'];
		} else {
			$geturl="";
			$description=$er['description'];
			$content=$er['content'];
			$title=$er['title'];
			$img=$er['img'];
			if ( $img == '' ) {
				$img=photo2bigphp($photo1);
			}
			$url=$er['url'];
		}
	}
	$keyword_plus="1";
}


$levelupky_sql="SELECT K.name FROM ( SELECT keyword_id FROM `parser_keyword_nature` WHERE id = \"$pid\" ) P JOIN keyword K ON P.keyword_id = K.id WHERE K.is_parser_content = '2' AND K.status != '8'";
$levelupky_rst=mysqli_query($conn,$levelupky_sql)or die($dbquery_error);
if ( $lr=mysqli_fetch_array($levelupky_rst) ) {
	$levelupky=$lr['name'];
	$name=$lr['name'];
} else {
	$name="";
}

$newky_sql="SELECT * FROM `keyword_new` WHERE type = 'k' ORDER BY RAND() limit 0,10";

if ( check_mobile() ) {
	$adsize="width:336px;height:280px;";
} else {
	$adsize="width:800px;height:250px;";
}

require_once 'kyhigh.php';
$random_ky=array_rand($ky,12);
$kyhigh01=$ky[$random_ky[0]];
$kyhigh02=$ky[$random_ky[1]];
$kyhigh03=$ky[$random_ky[2]];
$kyhigh04=$ky[$random_ky[3]];
$kyhigh05=$ky[$random_ky[4]];
$kyhigh06=$ky[$random_ky[5]];
$kyhigh07=$ky[$random_ky[6]];
$kyhigh08=$ky[$random_ky[7]];
$kyhigh09=$ky[$random_ky[8]];
$kyhigh10=$ky[$random_ky[9]];
$kyhigh11=$ky[$random_ky[10]];
$kyhigh12=$ky[$random_ky[11]];
//$city_all_sql="SELECT * FROM `city` ORDER BY `city`.`count` DESC";
// <option value="[var.http]://[var.site]/city/[city_all_sql.city_id]">[city_all_sql.city_name;block=option] ([city_all_sql.count])</option>

//$TBS = new clsTinyButStrong ;

if ( strpos($title,'繪圖板') !== false )  {
	$graphicstablet="<p><a href=\"https://www.aery.pro/pages/%E7%B9%AA%E5%9C%96%E6%9D%BF%E6%8E%A8%E8%96%A6%E5%83%B9%E6%A0%BC%E6%96%87\" title=\"三分鐘了解》2021繪圖板推薦及價格介紹－新手必看！\">三分鐘了解》2021繪圖板推薦及價格介紹－新手必看！</a></p>";
} else {
	$graphicstablet="";
}

if ( $keyword_plus == "0") {
	$TBS->LoadTemplate('template/entry_plus.html') ;
} else {
	if ( $ad_yesno == "0" ) {
		$TBS->LoadTemplate('template/entry.html') ;
	} else {
		$TBS->LoadTemplate('template/entry_noad.html') ;
	}
}


$TBS->MergeBlock('hotel_sql',$conn,$hotel_sql);
$TBS->MergeBlock('city_hotel_sql',$conn,$city_hotel_sql);
$TBS->MergeBlock('blog_sql',$conn,$blog_sql);
$TBS->MergeBlock('list_sql',$conn,$list_sql);
$TBS->MergeBlock('yt_sql',$conn,$yt_sql);
$TBS->MergeBlock('relate_ky_sql',$conn,$relate_ky_sql);
$TBS->MergeBlock('map_ky_sql',$conn,$map_ky_sql);
$TBS->MergeBlock('newky_sql',$conn,$newky_sql);

$TBS->Show() ;


?>