='$today')) AND(`Active`='Y' AND `IsDelete`='N' AND `LinkType`='banner') ORDER BY RAND() LIMIT 1";
$result =mysql_query($sql);
while($row =mysql_fetch_assoc($result)){
$BannerName = $row['LinkName'];
$BannerURL = ($row['LinkURL']=="")?"#":htmlspecialchars_decode($row['LinkURL']);
$BannerFile1 = $strCfgWebPathMain."/".$row['File1'];
}
//--- Youtube
$sql= "SELECT `LinkId`,`LinkName`,`LinkURL`,`File1` FROM $strCfgDbTableLink WHERE (`IsForever`='Y' OR (`StartDate`<='$today' AND `StopDate` >='$today')) AND(`Active`='Y' AND `IsDelete`='N' AND `LinkType`='youtube') ORDER BY RAND() LIMIT 1";
$result =mysql_query($sql);
while($row =mysql_fetch_assoc($result)){
$YoutubeURL = str_replace('https://youtu.be/','',$row['LinkURL']);
}
//--news
$tp->block("DataNews");
$sql="SELECT `NewsId`,`LineNo`,`Title`,`File1`,`AddDate`,`UpdateDate` FROM $strCfgDbTableNews WHERE (IsDelete='N' AND `Active`='Y') AND `Cate`='news' AND `ActivityDate`<='$today' order by Mark DESC,LineNo ASC,`NewsId` DESC Limit 0,1";
$result = mysql_query($sql);
//echo $sql;
while($row=mysql_fetch_assoc($result)){
$NewsId = $row['NewsId'];
$NewsTitle = $row['Title'];
$NewsFile1 = $row['File1'];
$NewsImg = <<![]()
apply();
}
//--Event
$tp->block("DataEvent");
$sql="SELECT `NewsId`,`LineNo`,`Title`,`File1`,`AddDate`,`UpdateDate` FROM $strCfgDbTableNews WHERE (IsDelete='N' AND `Active`='Y') AND `Cate`='event' AND `ActivityDate`<='$today' order by Mark DESC,LineNo ASC,`NewsId` DESC Limit 0,1";
$result = mysql_query($sql);
while($row=mysql_fetch_assoc($result)){
$EventId = $row['NewsId'];
$EventTitle = $row['Title'];
$EventFile1 = $row['File1'];
$EventImg = <<![]()
apply();
}
//--CSR
$tp->block("DataCSR");
$sql="SELECT `NewsId`,`LineNo`,`Title`,`File1`,`AddDate`,`UpdateDate` FROM $strCfgDbTableNews WHERE (IsDelete='N' AND `Active`='Y') AND `Cate`='csr' AND `ActivityDate`<='$today' order by Mark DESC,LineNo ASC,`NewsId` DESC Limit 0,1";
$result = mysql_query($sql);
while($row=mysql_fetch_assoc($result)){
$CSRId = $row['NewsId'];
$CSRTitle = $row['Title'];
$CSRFile1 = $row['File1'];
$CSRImg = <<![]()
apply();
}
//--Etc
$tp->block("DataEtc");
$sql="SELECT `NewsId`,`LineNo`,`Title`,`File1`,`AddDate`,`UpdateDate` FROM $strCfgDbTableNews WHERE (IsDelete='N' AND `Active`='Y') AND `Cate`='etc' AND `ActivityDate`<='$today' order by Mark DESC,LineNo ASC,`NewsId` DESC Limit 0,1";
$result = mysql_query($sql);
while($row=mysql_fetch_assoc($result)){
$EtcId = $row['NewsId'];
$EtcTitle = $row['Title'];
$EtcFile1 = $row['File1'];
$EtcImg = <<![]()
apply();
}
//--Calendar
$tp->block("DataCalen");
$sql="SELECT `EventId`,`Title`,`ActivityDate` FROM $strCfgDbTableEvent WHERE (IsDelete='N' AND `Active`='Y') AND `ActivityDate`>='$today' order by `ActivityDate` ASC Limit 0,4";
$result = mysql_query($sql);
while($row=mysql_fetch_assoc($result)){
$CalId = $row['EventId'];
$CalTitle = $row['Title'];
$CalActivityDate = formatDateTime($row['ActivityDate']);
$tp->apply();
}
//---------- Complain ------------------------
$tp->block("DataComplain");
$sql = "SELECT smf_topics.id_topic AS id_topic,smf_messages.id_msg AS id_msg,smf_members.id_member AS id_member,smf_members.member_name AS member_name,smf_members.avatar AS avatar,smf_messages.`subject` AS `subject`,smf_messages.body AS messsage,smf_messages.`poster_time` AS `poster_time`,smf_topics.id_board AS id_board,smf_attachments.id_folder AS id_folder,smf_attachments.id_attach AS id_attach,smf_attachments.filename AS filename,smf_attachments.fileext AS fileext,smf_topics.num_replies As num_replies FROM smf_topics INNER JOIN smf_messages ON smf_topics.id_first_msg = smf_messages.id_msg INNER JOIN smf_members ON smf_messages.id_member = smf_members.id_member LEFT JOIN smf_attachments ON smf_members.id_member=smf_attachments.id_member WHERE smf_topics.id_board = 1 and smf_messages.approved=1 ORDER BY id_topic DESC Limit 0,5";
$rs_complain = mysql_query($sql);
while($row=mysql_fetch_assoc($rs_complain)){
$id_topic = $row['id_topic'];
$id_msg = $row['id_msg'];
$id_member = $row['id_member'];
$member_name = $row['member_name'];
$avatar = $row['avatar'];
$subject = $row['subject'];
$num_replies = $row['num_replies'];
$poster_time = $row['poster_time'];
$id_folder = $row['id_folder'];
$id_attach = $row['id_attach'];
$filename = $row['filename'];
$fileext = $row['fileext'];
if($avatar!=""){
if (preg_match("/^Actors/",$avatar) || preg_match("/^Musicians/",$avatar)) {
$ImgAvatar =$strCfgMainUrl."/board/avatars/".$avatar;
}else{
$ImgAvatar = $avatar;
}
}else if($id_attach!=""){
$ImgAvatar = $strCfgMainUrl."/board/index.php?action=dlattach;attach=".$id_attach.";type=avatar";
}else{
$ImgAvatar = "images/emptyphoto.png";
}
$tp->apply();
}
//-----------// Complain -----------------------
//--- Adv. Banner
$AdvName = "โฆษณา";
$AdvURL = "#";
$AdvFile1 = "images/p_banner2.png";
$sql= "SELECT `LinkId`,`LinkName`,`LinkURL`,`File1` FROM $strCfgDbTableLink WHERE (`IsForever`='Y' OR (`StartDate`<='$today' AND `StopDate` >='$today')) AND(`Active`='Y' AND `IsDelete`='N' AND `LinkType`='adv') ORDER BY RAND() LIMIT 2";
$result =mysql_query($sql);
$tp->block("DataAdv");
while($row =mysql_fetch_assoc($result)){
$AdvName = $row['LinkName'];
$AdvURL = ($row['LinkURL']=="")?"#":$row['LinkURL'];
$AdvFile1 = $strCfgWebPathAdv."/".$row['File1'];
$tp->apply();
}
//--- Link Banner
$LinkName = "Link";
$LinkURL = "#";
$LinkFile1 = "images/p_banner2.png";
$sql= "SELECT `LinkId`,`LinkName`,`LinkURL`,`File1` FROM $strCfgDbTableLink WHERE (`IsForever`='Y' OR (`StartDate`<='$today' AND `StopDate` >='$today')) AND(`Active`='Y' AND `IsDelete`='N' AND `LinkType`='link') ORDER BY RAND() LIMIT 3";
$result =mysql_query($sql);
$tp->block("DataLink");
while($row =mysql_fetch_assoc($result)){
$LinkName = $row['LinkName'];
$LinkURL = ($row['LinkURL']=="")?"#":$row['LinkURL'];
$LinkFile1 = $strCfgWebPathLink."/".$row['File1'];
$tp->apply();
}
mysql_close($conn);
$tp->Display();
exit;
/*------------------------------------------------------------------*/
?>