$totalrowsOffers = 0;
$sqlOffers = $condb->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;
}
}
?>