selectone(TB_offers, "OffersID,OffersTitle,OffersDetail,OffersShortDetail,OffersImagesName,OffersImagesName2,OffersDateUpdate,OffersPublish,GroupRefer,OffersViewCount,BranchID", "LangRefer='" . language . "' AND GroupRefer=$OffersID $ViewOnlineStatus $CheckDateRegister "); // // $condb->printQuery('selectone',TB_offers, "OffersID,OffersTitle,OffersDetail,OffersShortDetail,OffersImagesName,OffersDateUpdate,OffersPublish,GroupRefer,OffersViewCount,OffersTypeID", "LangRefer='" . language . "' AND GroupRefer=$OffersID $ViewOnlineStatus $CheckDateRegister "); if ($sqlOffers) { $OffersViewCount = convertToText(stripStr($sqlOffers["OffersViewCount"])); if ($OffersViewCount < 1) { $OffersViewCount = 0; } $OffersViewCountAll = $OffersViewCount + 1; $jsonData['OffersViewCount'] = $OffersViewCountAll; $sqlUpd = $condb->updatedata(TB_offers, json_encode($jsonData), "GroupRefer = $OffersID "); $totalrowsOffers = count($sqlOffers); $OffersTitle = convertToText(stripStr($sqlOffers["OffersTitle"])); $OffersShortDetail = convertToText(stripStr($sqlOffers["OffersShortDetail"])); $OffersDetail = convertToHtmlFCKImage(convertToHtmlFCK(convertToHtmlFCKYoutube(stripStr($sqlOffers["OffersDetail"])))); $OffersImagesName = convertToText(stripStr($sqlOffers["OffersImagesName"])); $OffersImagesName2 = convertToText(stripStr($sqlOffers["OffersImagesName2"])); if (strpos($_SERVER['HTTP_ACCEPT'], 'image/webp') !== false || strpos($_SERVER['HTTP_USER_AGENT'], ' Chrome/') !== false) { $OffersImagesName2Webp = strstr(substr($OffersImagesName2, -5), '.'); $OffersImagesName2WebpS = str_replace($OffersImagesName2Webp, ".webp", $OffersImagesName2); } else { $OffersImagesName2WebpS = "nosupport"; } if (is_file($OffersImagePathHome . $OffersImagesName2WebpS) && filesize($OffersImagePathHome . $OffersImagesName2WebpS) > 0) { $OffersImagesName2S = "\"""; } elseif (is_file($OffersImagePathHome . $OffersImagesName2)) { $OffersImagesName2S = "\"""; } else { $OffersImagesName2S = "";; } $GroupRefer = convertToText(stripStr($sqlOffers["GroupRefer"])); $BranchID = convertToText(stripStr($sqlOffers["BranchID"])); $OffersPublish = convertToText(stripStr($sqlOffers['OffersPublish'])); if (language == 1) { $OffersPublish = mySqlToFullDate($sqlOffers['OffersPublish']); } else { $OffersPublish = mySqlToFullDateEng($sqlOffers['OffersPublish']); } $ImagesNamefacebook = ""; $sqlOffers = $condb->selectone(TB_offers, "OffersImagesName", "LangRefer='1' AND GroupRefer=$OffersID"); if ($sqlOffers) { $OffersImagesName = convertToText(stripStr($sqlOffers["OffersImagesName"])); } if (@is_file($OffersImagePathHome . $OffersImagesName)) { $ImagesNamefacebook = FullUrlF . $OffersImagePathHome . $OffersImagesName; } } /* For change lang*/ $url_langarr = array(); if ($OffersID > 0) { $JSON_UrlSlug = json_decode(getUrlSlug('newsdetail', $OffersID, 0, 1), true); if ($JSON_UrlSlug["urltitle"] != "") { array_push($url_langarr, FullUrlF . $JSON_UrlSlug["urltitle"] . "/th/" . $cfgURL['url_offers'][0] . "/" . $Get_URIs); } else { array_push($url_langarr, FullUrlF . $OffersID . "/th/" . $cfgURL['url_offers'][0] . "/" . $Get_URIs); } $JSON_UrlSlug2 = json_decode(getUrlSlug('newsdetail', $OffersID, 0, 2), true); if ($JSON_UrlSlug2["urltitle"] != "") { array_push($url_langarr, FullUrlF . $JSON_UrlSlug2["urltitle"] . "/en/" . $cfgURL['url_offers'][1] . "/" . $Get_URIs); } else { array_push($url_langarr, FullUrlF . $OffersID . "/en/" . $cfgURL['url_offers'][1] . "/" . $Get_URIs); } $JSON_UrlSlug3 = json_decode(getUrlSlug('newsdetail', $OffersID, 0, 3), true); if ($JSON_UrlSlug3["urltitle"] != "") { array_push($url_langarr, FullUrlF . $JSON_UrlSlug3["urltitle"] . "/jp/" . $cfgURL['url_offers'][2] . "/" . $Get_URIs); } else { array_push($url_langarr, FullUrlF . $OffersID . "/cn/" . $cfgURL['url_offers'][2] . "/" . $Get_URIs); } } else { array_push($url_langarr, FullUrlF . "th/" . $cfgURL['url_offers'][0] . $Get_URIs); array_push($url_langarr, FullUrlF . "en/" . $cfgURL['url_offers'][1] . $Get_URIs); array_push($url_langarr, FullUrlF . "cn/" . $cfgURL['url_offers'][2] . $Get_URIs); } // array_push($url_langarr, FullUrlF . "Offers_detail.php?id=".$OfferssID); // array_push($url_langarr, FullUrlF . "Offers_detail.php?id=".$OfferssID); /* For metatag setting*/ if (language == 3) { $langsendgettitle = 2; } else { $langsendgettitle = language; } $Meta_UrlSlug = json_decode(getUrlSlug('main_news', 0, 0, $langsendgettitle), true); if ($UrlMetaTagTitle == "") { if ($Meta_UrlSlug['urltagtitle'] != "") { $UrlMetaTagTitle = $Meta_UrlSlug['urltagtitle']; } else { $UrlMetaTagTitle = $OffersTitle; } } if ($UrlMetaTagKeyword == "") { if ($Meta_UrlSlug['urltagkeyword'] != "") { $UrlMetaTagKeyword = $Meta_UrlSlug['urltagkeyword']; } else { $UrlMetaTagKeyword = ""; } } if ($UrlMetaTagDescription == "") { if ($Meta_UrlSlug['urltagdescription'] != "") { $UrlMetaTagDescription = $Meta_UrlSlug['urltagdescription']; } else { $UrlMetaTagDescription = $OffersOffersShortDetail; } } ?> Belle Villa Resort | Special Offer