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 *,P.id as pid FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN parser_keyword_nature P ON K.id = P.keyword_id WHERE img != '' GROUP BY url";
$list_sql="SELECT *,P.id as pid FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN parser_keyword_nature P ON K.id = P.keyword_id WHERE img = '' AND type = 'a'";
$yt_sql="SELECT *,P.id as pid FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN parser_keyword_nature P ON K.id = P.keyword_id WHERE P.type= 'y' AND domain_name = 'https://www.youtube.com'";
$relate_ky_sql="SELECT * FROM ( SELECT map_keyword_id FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN keyword_relate R ON K.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 keyword_id FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN keyword_relate R ON K.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 keyword_id FROM ( SELECT id FROM `keyword` WHERE `name` = \"$name\" ) K JOIN keyword_relate R ON K.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' ";
//$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,kstatus FROM ( SELECT SUBSTRING_INDEX(`kytype`, '_', -1) as hotel_id,kstatus FROM ( SELECT keyword_id,kstatus FROM ( SELECT id,status as kstatus FROM `keyword` WHERE `name` = \"$name\" ) 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 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'];
$hotel_all_sql="SELECT * FROM `rowdata` WHERE hotel_id in ($hotel_ids) ";
$hotel_all_rst=mysqli_query($conn,$hotel_all_sql)or die($dbquery_error);
$kstatus=$khr['kstatus'];
$cnt=mysqli_num_rows($hotel_all_rst);
$pages=ceil($cnt/$PageSize);
$RecCnt=$cnt;
$pages_start=($PageNum-1)*$PageSize;
if ( $PageNum < $pages ) {
$next_PageNum=$PageNum+1;
$next_page="" . $name . "，大家都在找解答？第" . $next_PageNum . "頁";
} else {
$next_page="";
}
$hotel_sql="SELECT * FROM `rowdata` WHERE hotel_id in ($hotel_ids) ORDER BY ( rating_average * number_of_reviews ) desc limit $pages_start,$PageSize";
$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";
}
$keyword_plus_sql="SELECT * FROM ( SELECT * FROM keyword WHERE name = \"$name\" ) K JOIN `keyword_plus` P ON K.id = P.tid WHERE P.type = 'k'";
$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=$kpr['content'];
$keyword_plus="0";
} else {
$desc_pages_start=$pages_start%3;
$desc_sql="SELECT GROUP_CONCAT(`description`) as description FROM ( SELECT `description` as description FROM ( SELECT * FROM `keyword` WHERE `name` = \"$name\" ) K JOIN parser_keyword_nature P ON K.id = P.keyword_id WHERE P.type ='a' limit $desc_pages_start,2 ) A";
$desc_rst=mysqli_query($conn,$desc_sql)or die($dbquery_error);
if ( $dr=mysqli_fetch_array($desc_rst) ) {
$description=$dr['description'];
}
$keyword_plus="1";
}
$levelupky_sql="SELECT K2.name FROM ( SELECT * FROM `keyword` WHERE `name` = \"$name\" ) K JOIN keyword K2 ON K.parent_id = K2.id WHERE K2.is_parser_content = '2' AND K2.status != '8'";
$levelupky_rst=mysqli_query($conn,$levelupky_sql)or die($dbquery_error);
if ( $lr=mysqli_fetch_array($levelupky_rst) ) {
$levelupky=$lr['name'];
} else {
$levelupky=$name;
}
$option_city_id="";
//$city_all_sql="SELECT * FROM `city` ORDER BY `city`.`count` DESC";
//
$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]];
if ( strpos($name,'繪圖板') !== false ) {
$graphicstablet="