$module = "3";
$fktype = "WR001";
$fkflag = "HIGHLIGHT";
$LimitRecord = "12";
$LimitRecord = "12";
$NumColumn = "1";
//$pagesizeEventHL = "5";
//$LimitRecord = $pagesizeEventHL;
//$NumColumn = "5";
$sql_ROW = "select category_id
from $tbcontentcms_category
where module_id = '$module'
and tab_id = '$fktype'
and category_status = '1' ";
if(!empty($cgid)){
$sql_ROW .= "and category_id ='$cgid' ";
}
$result_ROW = mysql_query( $sql_ROW, $conn );
@$nrow = mysql_num_rows($result_ROW);
//echo"sql_ROW=$sql_ROW
";
//echo"nrow=$nrow ";
//if($nrow !="0"){
?>
$nrowLine = $NumColumn;
@$nrowRest=$nrow%$nrowLine;
if($nrowRest != 0){
@$nrowExt = $nrowLine - $nrowRest;
}
//เริ่มเตรียมแสดงข้อมูลต่อ 1 หน้า
@$Scriptname=${"Script_Name"};
$pagesize =$LimitRecord;
$totalpage =(int)(($nrow-1)/$pagesize+1);
$totalrec=($pagesize*$totalpage)-1;
if(@$page==""){
$page=1;
}
//เรียงจากน้อยไปมาก
@$goto=(@$page-1)*$pagesize;
$nextpage = $page + 1;
$prevpage = $page - 1;
$listpage = @listpage($page,$totalpage,$pageRange);
$pagelink = "module=$module&fktype=$fktype&cgid=$cgid";
//จบการเตรียมแสดงข้อมูลต่อ 1 หน้า
$sql_Arg = "select *
from $tbcontentcms_category
where module_id = '$module'
and tab_id = '$fktype'
and category_status = '1' ";
if(!empty($cgid)){
$sql_Arg .= "and category_id ='$cgid' ";
}
$sql_Arg .="order by category_sort asc ";
//$sql_Arg .="limit $goto,$pagesize ";
$rs_Arg = select_MySQL_return_RS($sql_Arg);
//echo " $sql_Arg;";
$i=0;
echo"";
while ($arr_Arg= mysql_fetch_array($rs_Arg)){
$i++;
@$obj_id = $arr_Arg["category_id"];
@$obj_topic = $arr_Arg["category_name"];
@$obj_image = $arr_Arg["category_image"];
@$obj_url = trim($arr_Arg["category_desc"]);
@$obj_lastupdate = $arr_Arg["updatedate"];
@$obj_active = $arr_Arg["category_status"];
@$obj_order = $arr_Arg["category_sort"];
@$obj_level = $arr_Arg["level"];
@$obj_parent = $arr_Arg["parent_id"];
$obj_topic=stripslashes($obj_topic);
/*
$obj_topic = ereg_replace("<(BR|br|P|\/P)>"," ", $obj_topic);
$obj_topic = ereg_replace(" ","", $obj_topic);
$obj_topic = ereg_replace("<([^>]*)>","", $obj_topic);
$count_topic = strlen($obj_topic);
if($count_topic > 30){
$obj_topic=substr($obj_topic, 0,30);
$obj_topic = $obj_topic."...";
}else{
$obj_topic = $obj_topic;
}*/
//check null value
if(empty($obj_topic)){ $obj_topic=""; }
$obj_topic_sh = "$obj_topic";
//$obj_topic_sh = "$obj_topic";
//file show
//$url_img = "../dofapps/";
$url_img = "./";
$obj_files = $obj_image;
$paththumb =$url_img."/".$categorythb_imgf;
$pathreal = $url_img."/".$category_imgf;
if ($obj_files !=""){
@$sizefile= getimagesize("$pathreal/$obj_files");
$W=$sizefile[0];
$H=$sizefile[1];
if($obj_url !=""){
//$obj_imgsh=" ";
$obj_imgsh=" ";
}else{
$obj_imgsh=" ";
}
}else{
if($obj_url !=""){
//@$obj_imgsh = " ";
@$obj_imgsh = " ";
}else{
@$obj_imgsh = " ";
}
}
//$obj_imgsh = "$obj_imgsh";
$obj_imgsh = "";
@$odd_line=$i%$NumColumn;
$NumPercent = floor(100/$NumColumn);
if (@$odd_line == 1){
echo"";
}
echo"";
?>
echo" | ";
if (@$odd_line == 0){
echo" ";
}
} //while
//expand row
if($NumColumn != "1"){
if($totalpage == $page){
for ($kk= 1; $kk <= @$nrowExt; $kk++) {
echo" | ";
}
}
}
echo" ";
?> |
// } //nrow
?> |
$pagesizeEvent = "20";
$LimitRecord = $pagesizeEvent;
$NumColumn = "1";
$sql_ROW = "select cont_id
from $tbcontentcms a
where a.module_id = '$module' ";
if(!empty($fktype)){
$sql_ROW .= "and a.tab_id ='$fktype' ";
}
if(!empty($cgid)){
$sql_ROW .= "and category_id ='$cgid' ";
}
if(!empty($fkyear)){
$sql_ROW .= "and from_unixtime(updatedate) like '%$fkyear%' ";
}
if(!empty($data)){
$sql_ROW .= "and ((cont_topic like '%$data%') or (cont_topic_en like '%$data%')) ";
}
$sql_ROW .= "and a.active = '1' ";
$result_ROW = mysql_query( $sql_ROW, $conn );
@$nrow = mysql_num_rows($result_ROW);
//echo"sql_ROW=$sql_ROW
";
//echo"nrow=$nrow
";
if($nrow =="0"){
echo line(3);
echo "No data found !!!";
echo line(3);
}else{
?>
echo"";
echo"Total : $nrow Record | ";
echo" ";
?>
|
$nrowLine = $NumColumn;
@$nrowRest=$nrow%$nrowLine;
if($nrowRest != 0){
$nrowExt = $nrowLine - $nrowRest;
}
//เริ่มเตรียมแสดงข้อมูลต่อ 1 หน้า
@$Scriptname=${"Script_Name"};
$pagesize =$LimitRecord;
$totalpage =(int)(($nrow-1)/$pagesize+1);
$totalrec=($pagesize*$totalpage)-1;
if(@$page==""){
$page=1;
}
//เรียงจากน้อยไปมาก
@$goto=(@$page-1)*$pagesize;
$nextpage = $page + 1;
$prevpage = $page - 1;
$listpage = listpage($page,$totalpage,$pageRange);
$pagelink = "module=$module&fktype=$fktype&pagesize=$pagesize&NumColumn=$NumColumn&cgid=$cgid&data=$data&fkyear=$fkyear";
//จบการเตรียมแสดงข้อมูลต่อ 1 หน้า
$sql_Arg = "select a.*
from $tbcontentcms a
where a.module_id = '$module' ";
if(!empty($fktype)){
$sql_Arg .= "and a.tab_id ='$fktype' ";
}
if(!empty($cgid)){
$sql_Arg .= "and category_id ='$cgid' ";
}
if(!empty($fkyear)){
$sql_Arg .= "and from_unixtime(updatedate) like '%$fkyear%' ";
}
if(!empty($data)){
$sql_Arg .= "and ((cont_topic like '%$data%') or (cont_topic_en like '%$data%')) ";
}
$sql_Arg .= "and a.active = '1' ";
$sql_Arg .="order by $orderby ";
$sql_Arg .="limit $goto,$pagesize ";
$rs_Arg = select_MySQL_return_RS($sql_Arg);
//echo "$sql_Arg;";
$i=0;
echo"";
while ($arr_Arg= mysql_fetch_array($rs_Arg)){
$i++;
@$obj_id = $arr_Arg["cont_id"];
@$obj_topic_th = trim($arr_Arg["cont_topic"]);
@$obj_topic_en = trim($arr_Arg["cont_topic_en"]);
@$obj_intro_th = trim($arr_Arg["cont_intro"]);
@$obj_intro_en = trim($arr_Arg["cont_intro_en"]);
@$obj_detail = trim($arr_Arg["cont_detail"]);
@$obj_datetime = $arr_Arg["updatedate"];
@$obj_thumb = $arr_Arg["cont_thumb"];
@$obj_openflag = $arr_Arg["cont_openflag"]; //HTML, FILE, LINK
@$obj_thumb = trim($arr_Arg["cont_thumb"]);
@$obj_files = $arr_Arg["cont_clip"];
@$obj_filessource = $arr_Arg["cont_clipflag"]; //upload,url
@$obj_filesurl = $arr_Arg["cont_clipurl"];
@$obj_filescode = $arr_Arg["cont_clipcode"];
@$obj_active = $arr_Arg["active"];
@$obj_referurl = $arr_Arg["cont_referurl"];
@$obj_highlight = $arr_Arg["cont_highlight"];
@$obj_openflag = $arr_Arg["cont_openflag"];
@$obj_openurl = $arr_Arg["cont_openurl"];
@$obj_clip = $arr_Arg["cont_clip"];
@$obj_clipname = $arr_Arg["cont_clipname"];
@$obj_price = $arr_Arg["cont_price"];
@$obj_size = $arr_Arg["cont_size"];
@$obj_color = $arr_Arg["cont_color"];
@$obj_weight = $arr_Arg["cont_weight"];
@$obj_contdate = $arr_Arg["cont_date"];
@$obj_contdatestmp = trim($arr_Arg["cont_datestmp"]);
@$tab_id = $arr_Arg["tab_id"];
@$obj_openurl = $arr_Arg["cont_openurl"];
@$obj_fileext1 = $arr_Arg["cont_file1"];
@$obj_fileext2 = $arr_Arg["cont_file2"];
@$obj_fileext3 = $arr_Arg["cont_file3"];
//09/04/2007 17:54:40
//$obj_datetime=formatdate($obj_datetime,"%d/%m/%Y %H:%M");
//$obj_datetime=formatdate($obj_contdatestmp,"%d/%m/%Y");
/*
$datesplit = explode("/", $obj_datetime);
$dnew = $datesplit[2];
$mnew = $datesplit[1];
$ynew = $datesplit[0]+543;
$shortmonth = $thaimonth[trim($mnew)-1];
*/
//(25/12/2007 21:47) --> systemdate
$datepost="(update : ".formatdate($obj_datetime,"%d/%m/%Y %H:%M").")";
// date to show
/*
$datesplit = explode("/", $obj_contdate);
$dnew = $datesplit[2];
$mnew = $datesplit[1];
$ynew = $datesplit[0]+543;
$shortmonth = $thaimonth[trim($mnew)-1];
$obj_dateassign = $dnew." ".$shortmonth." ".$ynew;
*/
//mark new --> หากเป็นกระทู้ที่ พึ่งโพสใหม่ ภายใน 30 วัน ให้ขึ้นกระพริบว่า New
//$start_date = "2010-03-15 00:00:00";
//$end_date = "2010-03-17 09:36:15";
$start_date = formatdate($obj_datetime,"%Y-%m-%d %H:%M:%S");
$end_date = date("Y-m-d H:i:s");
$date_diff = date_diff($start_date, $end_date);
$date_split = explode(" days", $date_diff);
//$day_hot = trim($date_split[0]); // piece1
//edit on 2014-04-21 by Nanthiya
$MyDay = strtotime($start_date);
$today = strtotime($end_date);
$day_hot = round(abs($today-$MyDay)/60/60/24);
//printf("I'm %d days old.", round(abs($today-$MyDay)/60/60/24));
if($day_hot <=15){
$MarkNew=" ";
}else{
$MarkNew="";
}
//set variable
if($_SESSION['SS_LANG'] == 'th'){
$obj_topic= $obj_topic_th;
$obj_intro= $obj_intro_th;
}else{
$obj_topic= $obj_topic_en;
$obj_intro= $obj_intro_en;
}
$obj_topic=stripslashes($obj_topic);
$obj_intro=stripslashes($obj_intro);
$obj_clipname=stripslashes($obj_clipname);
//$obj_topic = CheckRudeEditor($obj_topic);
//$obj_intro = CheckRudeEditor($obj_intro);
$obj_topic = ereg_replace("<(BR|br|P|\/P)>"," ", $obj_topic);
$obj_topic = ereg_replace(" ","", $obj_topic);
$obj_topic = ereg_replace("<([^>]*)>","", $obj_topic);
/*
$count_topic = strlen($obj_topic);
if($count_topic > 255){
$obj_topic=substr($obj_topic, 0,255);
$obj_topic = $obj_topic."...";
}else{
$obj_topic = $obj_topic;
}*/
$obj_intro = ereg_replace("<(BR|br|P|\/P)>"," ", $obj_intro);
$obj_intro = ereg_replace(" ","", $obj_intro);
$obj_intro = ereg_replace("<([^>]*)>","", $obj_intro);
$count_intro = strlen($obj_intro);
if($count_intro > 220){
$obj_intro=substr($obj_intro, 0,220);
$obj_intro = $obj_intro."...";
}else{
$obj_intro = $obj_intro;
}
//check null value
if(empty($obj_topic)){ $obj_topic="-"; }
if(empty($obj_intro)){ $obj_intro=""; }
//$dpath = "../dofapps/".$ctclip_imgf;
$dpath = "/".$ctclip_imgf;
$dfiles = $obj_clip;
$dfilesname = $obj_clipname;
$dfilesname = ereg_replace('[[:space:]]+', '', trim($dfilesname));
/*
url + clip = refer url
url = refer url
clip 1 = open clip
clip >1 = page detail
*/
if(!empty($obj_referurl)){
if(!empty($obj_topic)){
$obj_topic_sh = "$obj_topic";
}
if(!empty($obj_topicen)){
$obj_topicen_sh = "$obj_topicen";
}
}else{
//สำหรับเช็คหน้าที่มีไฟล์หลายไฟล์
//$dpath = "../dofapps/".$ctclip_imgf;
$dpath = "/".$ctclip_imgf;
$dfiles = $obj_clip;
$dfilesname = $obj_clipname;
$dfilesname = ereg_replace('[[:space:]]+', '', trim($dfilesname));
if ((!empty($obj_fileext1)) or (!empty($obj_fileext2)) or (!empty($obj_fileext3)) ) {
if ($obj_files !=""){
$obj_topic_sh = "$obj_topic";
}else{
$obj_topic_sh = "$obj_topic";
}
$obj_contdate_sh = "(update : ".$obj_datetime.")";
}else{
if ($obj_files !=""){
//$obj_topic_sh = "$obj_topic";
$obj_topic_sh = "$obj_topic";
}else{
$obj_topic_sh = "$obj_topic";
}
$obj_contdate_sh = "(update : ".$obj_datetime.")";
}
}
/*
//thumbnail show
$obj_files = $obj_thumb;
$paththumb = $ctthb_imgf;
if ($obj_files !=""){
@$sizefile= getimagesize("$pathreal/$obj_files");
$W=$sizefile[0];
$H=$sizefile[1];
$obj_imgsh=" ";
}else{
@$obj_imgsh = " ";
}
$obj_imgsh = "$obj_imgsh";
$obj_imgsh = "";
*/
@$odd_line=$i%$NumColumn;
$NumPercent = floor(100/$NumColumn);
//iocn
/*
@$oddrow=$i%2;
if($oddrow == 0){
$iconline=" ";
}else{
$iconline=" ";
} */
if (@$odd_line == 1){
echo"";
}
echo"";
?>
echo" | ";
if (@$odd_line == 0){
echo" ";
}
} //while
//expand row
if($NumColumn != "1"){
if($totalpage == $page){
for ($kk= 1; $kk <= $nrowExt; $kk++) {
echo" | ";
}
}
}
echo" ";
} //nrow
?>
if ((@$nrow > 1) && ($totalpage != 1)){?>
echo"";
echo"Total : $nrow Record | PAGE $page/$totalpage : | ";
if($totalpage != 1 && $page != 1){
//echo " ";
//echo " Previous ";
echo"";
echo"<< ";
echo" |
|
";
}
for($i=0;$i";
if($page == $listpage[$i]){
//echo "$listpage[$i]";
echo"
|
|
";
}else{
//echo "$listpage[$i]";
//echo "$listpage[$i]";
echo"
$listpage[$i]
|
|
";
}
//echo" ";
} // for
if($totalpage != 1 && $totalpage != $page){
//echo " ";
//echo " Next ";
echo" ";
echo">> ";
echo" |
|
";
}
echo" ";
?>
|
}//nrow?> |
|
เลือกหมวดหมู่
$module = "3";
$fktype = "WR001";
$fkflag = "HIGHLIGHT";
$LimitRecord = "12";
$LimitRecord = "12";
$NumColumn = "1";
//$pagesizeEventHL = "5";
//$LimitRecord = $pagesizeEventHL;
//$NumColumn = "5";
$sql_ROW = "select category_id
from $tbcontentcms_category
where module_id = '$module'
and tab_id = '$fktype'
and category_status = '1' ";
/* if(!empty($cgid)){
$sql_ROW .= "and category_id ='$cgid' ";
}*/
$result_ROW = mysql_query( $sql_ROW, $conn );
@$nrow = mysql_num_rows($result_ROW);
//echo"sql_ROW=$sql_ROW
";
//echo"nrow=$nrow ";
$nrowLine = $NumColumn;
@$nrowRest=$nrow%$nrowLine;
if($nrowRest != 0){
@$nrowExt = $nrowLine - $nrowRest;
}
//เริ่มเตรียมแสดงข้อมูลต่อ 1 หน้า
@$Scriptname=${"Script_Name"};
$pagesize =$LimitRecord;
$totalpage =(int)(($nrow-1)/$pagesize+1);
$totalrec=($pagesize*$totalpage)-1;
if(@$page==""){
$page=1;
}
//เรียงจากน้อยไปมาก
@$goto=(@$page-1)*$pagesize;
$nextpage = $page + 1;
$prevpage = $page - 1;
$listpage = @listpage($page,$totalpage,$pageRange);
$pagelink = "module=$module&fktype=$fktype&cgid=$cgid";
//จบการเตรียมแสดงข้อมูลต่อ 1 หน้า
$sql_Arg = "select *
from $tbcontentcms_category
where module_id = '$module'
and tab_id = '$fktype'
and category_status = '1' ";
/*if(!empty($cgid)){
$sql_Arg .= "and category_id ='$cgid' ";
} */
$sql_Arg .="order by category_sort asc ";
//$sql_Arg .="limit $goto,$pagesize ";
$rs_Arg = select_MySQL_return_RS($sql_Arg);
//echo " $sql_Arg;";
$i=0;
echo"";
while ($arr_Arg= mysql_fetch_array($rs_Arg)){
$i++;
@$obj_id = $arr_Arg["category_id"];
@$obj_topic = $arr_Arg["category_name"];
@$obj_image = $arr_Arg["category_image"];
@$obj_url = trim($arr_Arg["category_desc"]);
@$obj_lastupdate = $arr_Arg["updatedate"];
@$obj_active = $arr_Arg["category_status"];
@$obj_order = $arr_Arg["category_sort"];
@$obj_level = $arr_Arg["level"];
@$obj_parent = $arr_Arg["parent_id"];
$obj_topic=stripslashes($obj_topic);
$obj_topic = ereg_replace("<(BR|br|P|\/P)>"," ", $obj_topic);
$obj_topic = ereg_replace(" ","", $obj_topic);
$obj_topic = ereg_replace("<([^>]*)>","", $obj_topic);
$count_topic = strlen($obj_topic);
if($count_topic > 100){
$obj_topic=substr($obj_topic, 0,100);
$obj_topic = $obj_topic."...";
}else{
$obj_topic = $obj_topic;
}
//check null value
if(empty($obj_topic)){ $obj_topic=""; }
if($cgid==$obj_id){
if($obj_url !=""){
$obj_topic_sh = "$obj_topic";
//$obj_topic_sh = "$obj_topic";
}else{
$obj_topic_sh = "$obj_topic";
}
}else{
if($obj_url !=""){
$obj_topic_sh = "$obj_topic";
}else{
$obj_topic_sh = "$obj_topic";
}
}
@$odd_line=$i%$NumColumn;
$NumPercent = floor(100/$NumColumn);
if (@$odd_line == 1){
echo"";
}
echo"";
echo"
 |
$obj_topic_sh |
";
echo" | ";
if (@$odd_line == 0){
echo" ";
}
} //while
//expand row
if($NumColumn != "1"){
if($totalpage == $page){
for ($kk= 1; $kk <= @$nrowExt; $kk++) {
echo" | ";
}
}
}
echo" ";
?> |
// } //nrow
?> |
|