cat.REF_MODULE_ID = $MID
AND cat.flag = 0
AND cat.CONTENT_CAT_ID = $CID
AND content.SUB_CAT_ID = $SID
AND content.APPROVE_FLAG = 'Y'
AND content.CONTENT_STATUS_FLAG = 0
AND content.CONTENT_ID = $NID
ORDER BY content.ORDER_DATA desc ";
$query = mysql_query($sql, $conn);
$num_rows = mysql_num_rows($query);
$row = mysql_fetch_array($query);
$date = ConvertBoxDate($row['EVENT_START_DATE']);
$dateEnd = ConvertBoxDate($row['EVENT_END_DATE']);
?>
<div class="box-newsdetail-main">
<div class="box-slide-big">
<div id="sync1" class="owl-carousel">
<?php
$audioPlayer = false;
$thumbRender = "\n\n\t";
$extraStyle = "";
$getPicSql = "SELECT * FROM trn_content_picture WHERE CONTENT_ID = ".$CONID." AND CAT_ID = ".$CID." AND ( DIV_NAME != 'Other' OR DIV_NAME IS NULL ) ORDER BY DIV_NAME ASC , ORDER_ID ASC";
$rsPic = mysql_query($getPicSql) or die(mysql_error());
$rowPicturecount = mysql_num_rows($rsPic);
if ($rowPicturecount == 1) {
$extraStyle = " style='display:none;'";
AND content.CONTENT_STATUS_FLAG = 0
AND content.SUB_CAT_ID = " . $museumDataNetworkNewsSubCat . " ORDER BY
EVENT_START_DATE ASC
LIMIT 0,
6";
$query = mysql_query($newsSql, $conn) or die($newsSql);
$index = 1;
while ($row = mysql_fetch_array($query)) {
$gap = "";
if ($index == 2) {
$gap = " mid ";
}
$date = ConvertBoxDate($row['EVENT_START_DATE']);
/*social*/
$path = 'mdn-news-detail.php?MID=' . $MID . '%26CID=' . $CID . '%26SID=' . $row['SUB_CAT_ID'] . '%26CONID=' . $row['CONTENT_ID'] . '';
$fullpath = _FULL_SITE_PATH_ . '/' . $path;
$redirect_uri = _FULL_SITE_PATH_ . '/callback.php?p=' . $row['CONTENT_ID'];
$fb_link = 'https://www.facebook.com/dialog/share?app_id=' . _FACEBOOK_ID_ . '&display=popup&href=' . $fullpath . '&redirect_uri=' . $redirect_uri;
$path = str_replace("%26", "&", $path);
$title = htmlspecialchars(trim($row['CONTENT_LOC']));
$detail = strip_tags(trim($row['CONTENT_BRIEF']));
/*social*/
if ($index == 4)
echo '<hr class="line-gray"/>';
echo '<div class="box-tumb cf' . $gap . '">';
