if ($Comms['id']) {
UpdateIcon(TIMESTAMP, $Comms['post_date'], "images/icon/update.gif");
} else {
NewsIcon(TIMESTAMP, $WebBoard['post_date'], "images/icon_new.gif");
}
echo "<FONT FACE=\"tahoma\" COLOR=\"#808080\">(" . number_format($WebBoard['pageview']) . "/" . number_format($SumComm) . ")</FONT></td>\n";
echo "<td width=\"120\"><CENTER><B><FONT COLOR=\"#6600FF\">";
//¡Ã³ÕÊÁÒªÔ¡
if ($WebBoard['is_member']) {
echo "<IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"> <B><FONT COLOR=\"#FF0066\">";
} else {
}
$postTimePast = checkPostTimePast($WebBoard['post_date']);
// echo "".$WebBoard['post_name']."</FONT><br><FONT COLOR=\"#CC0066\">".$postTimePast."</FONT></B></CENTER></td>\n";
echo "" . $WebBoard['post_name'] . "</FONT></B></CENTER></td>\n";
echo "<td width=\"120\"><CENTER><FONT COLOR=\"#339900\">" . ThaiTimeConvert($WebBoard['post_date'], "", "2") . "</FONT></CENTER></td></tr>";
$count++;
}
@mysql_free_result($BoardResult);
echo "</table>";
?>
<BR>
</td>
</TR>
</TBODY>
</TABLE>
$arr['cat'] = $db->fetch($res['cat']);
$CAT = $arr['cat']['post_date'];
?>
<table width="100%" cellspacing="2" cellpadding="1" >
<tr>
<td bgcolor="#F7F7F7" colspan="<?php
echo _GALLERY_ADMIN_COL;
?>
"><font color="#990000" size="4"><b> >> <?php
echo $arr['cat']['category_name'];
?>
</b></font></a> <?php
echo NewsIcon(TIMESTAMP, $arr['cat']['post_date'], "images/icon_new.gif");
?>
( <?php
echo ThaiTimeConvert($arr['cat']['post_date'], '', '');
?>
) <br><font size="3" color="#0066CC"> [ <?php
echo _ADMIN_GALLERY_SHOW_TOTAL_PIC;
?>
<font color="#990000" size="3"><?php
echo $SUMPAGE;
?>
</font> <?php
echo _ADMIN_GALLERY_SHOW_TOTAL_NUM;
?>
] <br><br> </font><font size="2"><?php
echo $arr['cat']['category_detail'];
?>
</font></td>
</tr>
</td>
<td><A HREF="?name=knowledge&file=readknowledge&id=<?php
echo $arr['knowledge']['id'];
?>
" target="_blank"><?php
echo $arr['knowledge']['topic'];
?>
</A><?php
echo $CommentIcon;
echo $PicIcon;
echo $AttIcon;
echo NewsIcon(TIMESTAMP, $arr['knowledge']['post_date'], "images/icon_new.gif");
?>
</td>
<td ><CENTER><?php
echo ThaiTimeConvert($arr['knowledge']['post_date'], '', '');
?>
</CENTER></td>
<td align="center">
<?php
if ($arr['category']['category_name']) {
//ËÒ¡ÁÕËÁÇ´áÊ´§ÃÙ»
?>
<A HREF="#"><IMG SRC="images/admin/folders.gif" BORDER="0" align="absmiddle" alt="<?php
echo $arr['category']['category_name'];
?>
" onMouseOver="MM_displayStatusMsg('<?php
echo $arr['category']['category_name'];
?>
');return document.MM_returnValue"></A>
<?php
while ($comment = $db->fetch($query)) {
$count++;
?>
<TABLE cellSpacing=5 cellPadding=0 width=480 border=0 align="center" class="tablecomment">
<TR>
<TD><B><FONT COLOR="#990000">ความคิดเห็นที่ <?php
echo $count;
?>
</FONT></B>
<?php
if (isset($_SESSION['admin_user'])) {
echo " <A HREF=\"?name=knowledge&file=delete_comment&id=" . $_GET['id'] . "&comment=" . $comment['id'] . "\"><IMG SRC=\"images/admin/trash.gif\" WIDTH=\"20\" HEIGHT=\"20\" BORDER=\"0\" ALIGN=\"absmiddle\"></A>";
}
?>
<BR><?php
echo ThaiTimeConvert($comment['post_date'], "1", "1");
?>
</TD>
</TR>
<TR>
<TD height="1" class="dotline"></TD>
</TR>
<TR>
<TD><?php
echo CHANGE_EMOTICON(BBCODE($comment['comment']));
?>
</TD>
</TR>
<TR>
<TD height="1" class="dotline"></TD>
</TR>
<table width="<?php
echo $widthSUM;
?>
" border="0" cellspacing="0" cellpadding="0" height="3" >
</table>
<br>
<table width="<?php
echo $widthSUM;
?>
" border="0" cellspacing="0" cellpadding="0" height="3" >
<tr>
<td align="center"><img src="images/ip.gif"> <font color="#888888"><b><?php
echo _COUNT_START;
?>
<?php
echo ThaiTimeConvert("" . WEB_TIMESTART . "", "", "");
?>
</b>
</td>
</tr>
<script language="javascript">
<!--
var state = 'none';
function showhide(layer_ref) {
if (state == 'block') {
state = 'none';
}
else {
$count = 0;
$items = $db->fetchAll($query);
foreach ($items as $key => $item) {
if ($count == 0) {
echo "<TR>";
}
//ชื่อหมวดหมู่
$query = $db->select_query("SELECT category_name FROM " . TB_KNOWLEDGE_CAT . " WHERE id='" . $item['category'] . "' ");
$category = $db->fetch($query);
?>
<TD width="50%" valign=top>
<TABLE width="100%">
<TR>
<TD><FONT COLOR="#990000"><B>
<?php
echo ThaiTimeConvert($item['post_date'], "", "");
?>
: <?php
echo $category['category_name'];
?>
</B></FONT></TD>
</TR>
<TR><TD height="3" ></TD></TR>
<TR>
<TD>
<A HREF="?name=knowledge&file=readknowledge&id=<?php
echo $item['id'];
?>
" target="_blank">
<IMG SRC="knowledgeicon/<?php
echo $item['post_date'];
while ($arr['blog'] = $db->fetch($res['blog'])) {
if ($count == 0) {
echo "<TR>";
}
//ª×èÍËÁÇ´ËÁÙè
$res['category'] = $db->select_query("SELECT category_name FROM " . TB_BLOG_CAT . " WHERE id=" . $arr['blog']['category'] . " ");
$arr['category'] = $db->fetch($res['category']);
$ids = highlight("{$keyword}", '<span>' . $arr['blog']['id'] . '</span>');
$topics = highlight("{$keyword}", '<span>' . $arr['blog']['topic'] . '</span>');
$details = highlight("{$keyword}", '<span>' . $arr['blog']['headline'] . '</span>');
?>
<TD width="320" valign=top><TABLE width="320">
<TR>
<TD><FONT COLOR="#990000"><B>
<?php
echo ThaiTimeConvert($arr['blog']['post_date'], "", "");
?>
:
<?php
echo $arr['category']['category_name'];
?>
</B></FONT></TD>
</TR>
<TR>
<TD height="3" ></TD>
</TR>
<TR>
<TD width="320"><A HREF="?name=blog&file=readblog&id=<?php
echo $arr['blog']['id'];
?>
"> <IMG SRC="NewsIcon/<?php
<font color="#006699"><b><?php
echo $arr['events']['detail'];
?>
</font>
<BR>
<?php
echo _DETAIL_PRIVIEW;
?>
<font color="#CC0000"><?php
echo $arr['events']['pageview'];
?>
<B></font><?php
echo _CAL_POSTED_DATE;
?>
<font color="#cc0000"></B><?php
echo ThaiTimeConvert($arr['events']['post_date'], "1", "");
?>
<?php
if ($admin_user) {
//Admin Login Show Icon
?>
<a href="?name=admin&file=editevent&id=<?php
echo $arr['events']['id'];
?>
"><img src="images/admin/edit.gif" border="0" alt="<?php
echo _FROM_IMG_EDIT;
?>
" ></a>
<a href="javascript:Confirm('?name=admin&file=delevent&id=<?php
echo $arr['events']['id'];
echo $arr['ipblock']['post_date'];
?>
','<?php
echo _ADMIN_BUTTON_DEL_MESSAGE;
?>
');"><img src="images/admin/trash.gif" border="0" alt="<?php
echo _ADMIN_BUTTON_DEL;
?>
" ></a>
</td>
<td align="center" width="50"><?php
echo $arr['ipblock']['ip'];
?>
</td>
<td align="center" ><?php
echo ThaiTimeConvert($arr['ipblock']['post_date'], "", "1");
?>
</td>
<td valign="top" align="center" width="40"><input type="checkbox" name="list[]" value="<?php
echo $arr['ipblock']['id'];
?>
"></td>
</tr>
<?php
$count++;
}
?>
</table>
<div align="right">
$db->connectdb(DB_NAME, DB_USERNAME, DB_PASSWORD);
$res['cat_gallery'] = $db->select_query("SELECT * FROM " . TB_GALLERY . " WHERE category='" . $arr['category']['id'] . "' ORDER BY id DESC LIMIT 5 ");
$rows['cat_gallery'] = $db->rows($res['cat_gallery']);
if (!$rows['cat_gallery']) {
echo " " . _FROM_CAT_NO . "";
}
while ($arr['cat_gallery'] = $db->fetch($res['cat_gallery'])) {
?>
<IMG SRC="images/icon/suggest.gif" BORDER="0" ALIGN="absmiddle"> <B><A HREF="?name=gallery&file=readgal&id=<?php
echo $arr['cat_gallery']['id'];
?>
" target="_blank"><?php
echo $arr['cat_gallery']['pic'];
?>
</A></B> <?php
echo ThaiTimeConvert($arr['cat_gallery']['post_date'], "", "");
?>
<BR>
<?php
}
$db->closedb();
?>
</TD>
</TR>
<?php
}
?>
</TABLE>
</TD>
</TR>
</TBODY>
$Comms = $db->fetch($Comm);
$SumComm = $db->num_rows(TB_WEBBOARD_COMMENT, "id", " topic_id='" . $WebBoard['id'] . "' ");
if ($Comms['id']) {
UpdateIcon(TIMESTAMP, $Comms['post_date'], "images/icon/update.gif");
} else {
NewsIcon(TIMESTAMP, $WebBoard['post_date'], "images/icon_new.gif");
}
echo "<FONT FACE=\"tahoma\" COLOR=\"#808080\">(" . number_format($WebBoard['pageview']) . "/" . number_format($SumComm) . ")</FONT></td>\n";
echo "</td>\n";
echo "<td width=\"19%\"><CENTER>";
if ($WebBoard['is_member'] == 1) {
echo "<B><FONT COLOR=\"#FF0066\">" . $WebBoard['post_name'] . "</FONT></B> <IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\">";
} else {
echo "<B><FONT COLOR=\"#6600FF\">" . $WebBoard['post_name'] . "</FONT></B> ";
}
echo "<br><font size='1'>" . _WEBBOARD_DETAIL_POST . " " . ThaiTimeConvert($WebBoard['post_date'], "", "2") . "</font></CENTER></td>\n";
// áÊ´§¤¹µÍºÅèÒÊØ´
//$res['ment'] = $db->select_query("SELECT * FROM ".TB_WEBBOARD_COMMENT." WHERE topic_id=".$WebBoard['id']." ORDER BY id DESC LIMIT 1 ");
//$arr['ment']= $db->fetch($res['ment']);
// if ($arr['ment']['post_name']){
// if($arr['ment']['is_member']==1){
// echo "<td width=\"19%\"><CENTER><B><FONT COLOR=#FF0033\"> ".$arr['ment']['post_name']."</B></FONT><IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"><br><font size='1'>àÁ×èÍ ".ThaiTimeConvert($arr['ment']['post_date'],"","2")."</font></CENTER></td>\n";
// } else {
// echo "<td width=\"19%\"><CENTER><B><FONT COLOR=#6600FF\"> ".$arr['ment']['post_name']."</B></FONT><br><font size='1'>àÁ×èÍ ".ThaiTimeConvert($arr['ment']['post_date'],"","2")."</font></CENTER></td>\n";
// }
// }else {
// echo "<td width=\"19%\"><CENTER><B></CENTER></td>\n";
// }
echo "<td width=\"19%\"><CENTER>" . $WebBoard['ip_address'] . "</center></td>";
?>
<td valign="top" align="center" width="40"><input type="checkbox" name="list[]" value="<?php
echo "<td width=\"15%\"><CENTER>";
if ($WebBoard['is_member'] == 1) {
echo "<B><FONT COLOR=\"#FF0066\">" . $WebBoard['post_name'] . "</FONT></B> <IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\">";
} else {
echo "<B><FONT COLOR=\"#6600FF\">" . $WebBoard['post_name'] . "</FONT></B> ";
}
echo "<br><font size='1'>" . _WEBBOARD_DETAIL_POST . " " . ThaiTimeConvert($WebBoard['post_date'], "", "2") . "</font></CENTER></td>\n";
echo "<td width='5%' align='center'><FONT FACE=\"tahoma\" COLOR=\"#0099FF\">" . number_format($WebBoard['pageview']) . "</FONT></td>\n\t<td width='5%' align='center'><FONT FACE=\"tahoma\" COLOR=\"#808080\">" . number_format($SumComm) . "</FONT></td>\n";
// �ʴ����ͺ����ش
$res['ment'] = $db->select_query("SELECT * FROM " . TB_WEBBOARD_COMMENT . " WHERE topic_id=" . $WebBoard['id'] . " ORDER BY id DESC LIMIT 1 ");
$arr['ment'] = $db->fetch($res['ment']);
if ($arr['ment']['post_name']) {
if ($arr['ment']['is_member'] == 1) {
echo "<td width=\"19%\"><CENTER><B><FONT COLOR=#FF0033\"> " . $arr['ment']['post_name'] . "</B></FONT><IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"><br><font size='1'>" . _WEBBOARD_DETAIL_POST . " " . ThaiTimeConvert($arr['ment']['post_date'], "", "2") . "</font></CENTER></td></tr>\n";
} else {
echo "<td width=\"19%\"><CENTER><B><FONT COLOR=#6600FF\"> " . $arr['ment']['post_name'] . "</B></FONT><br><font size='1'>" . _WEBBOARD_DETAIL_POST . " " . ThaiTimeConvert($arr['ment']['post_date'], "", "2") . "</font></CENTER></td></tr>\n";
}
} else {
echo "<td width=\"19%\"><CENTER><B></CENTER></td></tr>\n";
}
$count++;
}
$db->closedb();
?>
</table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr ><td colspan="6" class="browse_page" width="500"><?php
page_navigator("webboard", "board", "" . $category . "&category=" . $category . "", $before_p, $plus_p, $total, $total_p, $chk_page);
?>
</td></tr>
$res['category'] = $db->select_query("SELECT * FROM " . TB_KNOWLEDGE_CAT . " WHERE id='" . $arr['pdf']['category'] . "' ");
$arr['category'] = $db->fetch($res['category']);
} else {
if ($mo == 'blog') {
$res['pdf'] = $db->select_query("SELECT * FROM " . TB_BLOG . " WHERE id='" . $_GET['id'] . "' ");
$arr['pdf'] = $db->fetch($res['pdf']);
$res['category'] = $db->select_query("SELECT * FROM " . TB_BLOG_CAT . " WHERE id='" . $arr['pdf']['category'] . "' ");
$arr['category'] = $db->fetch($res['category']);
}
}
}
$db->closedb();
$cat = '' . _PDF_CAT . ' : ' . $arr['category']['category_name'] . '<br>';
$titles = '' . _PDF_TOPIC . ' : ' . stripslashes(FixQuotes($arr['pdf']['topic'])) . '<br>';
$authors = '' . _FORM_MOD_POSTED . ' : ' . $arr['pdf']['posted'] . '<br>';
$da = ThaiTimeConvert($arr['pdf']['post_date'], "1", "");
$dates = '' . _FORM_MOD_POSTDATE . ' ' . $da . '<br>';
$view = '' . _DETAIL_PRIVIEW . ' : ' . $arr['pdf']['pageview'] . '<br>';
if ($arr['pdf']['pic'] == 1) {
if ($mo == 'blog') {
$imagex = '<img src=icon/' . $mo . '_' . $arr['pdf']['post_date'] . '_' . $arr['pdf']['posted'] . '.jpg><br>';
} else {
$imagex = '<img src=icon/' . $mo . '_' . $arr['pdf']['post_date'] . '.jpg><br>';
}
} else {
$imagex = '<img src=images/icon/' . $arr['category']['icon'] . '><br>';
}
$sum = '' . $imagex . '' . $cat . '' . $titles . '' . $authors . '' . $dates . '' . $view . '';
require_once 'includes/html2pdf/config/lang/eng.php';
require_once 'includes/html2pdf/tcpdf.php';
require_once 'includes/html2pdf/htmltoolkit.php';
//กรณีแนบรูป
if ($WebBoard['picture']) {
echo "<IMG SRC=\"images/attach.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"> ";
} else {
}
//กรณีกระทู้ใหม่
NewsIcon(TIMESTAMP, $WebBoard['post_date'], "images/icon_new.gif");
echo "<FONT FACE=\"tahoma\" COLOR=\"#808080\">(" . number_format($WebBoard['pageview']) . "/" . number_format($SumComm) . ")</FONT></td>\n";
echo "<td bgcolor=\"" . $ColorFill . "\" width=\"120\"><CENTER><B><FONT COLOR=\"#6600FF\">";
//กรณีสมาชิก
if ($WebBoard['is_member']) {
echo "<IMG SRC=\"images/human.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"> <B><FONT COLOR=\"#FF0066\">";
} else {
}
echo "" . $WebBoard['post_name'] . "</FONT></B></CENTER></td>\n";
echo "<td bgcolor=\"" . $ColorFill . "\" width=\"120\"><CENTER><FONT COLOR=\"#339900\">" . ThaiTimeConvert($WebBoard['post_date'], "", "2") . "</FONT></CENTER></td>\n";
echo "<tr><td colspan=\"3\" height=1 class=\"dotline\"></td></tr>\n";
}
echo "</table>";
?>
<BR>
<table border="0" cellpadding="0" cellspacing="1" width="700" align=center>
<tr>
<td>
<?php
SplitPage($page, $totalpage, "?name=webboard&category=" . $cat_id . "");
echo $ShowSumPages;
echo "<BR>";
echo $ShowPages;
?>
</td>
$ColorFill = ' onmouseover="this.style.backgroundColor=\'#FFF0DF\'" onmouseout="this.style.backgroundColor=\'#ffffff\'" ';
}
echo "<TR " . $ColorFill . ">";
//ª×èÍËÁÇ´ËÁÙè
$res['category'] = $db->select_query("SELECT category_name FROM " . TB_DOWNLOAD_CAT . " WHERE id='" . $arr['download']['category'] . "' ");
$arr['category'] = $db->fetch($res['category']);
$downloadid = $arr['download']['id'];
$ress['com'] = $db->select_query("SELECT *,count(id) as com FROM " . TB_DOWNLOAD_COMMENT . " WHERE id ='" . $downloadid . "' group by id");
$arrs['com'] = $db->fetch($ress['com']);
?>
<TD width="100%" align="left">
<IMG SRC="images/admin/open.gif" BORDER="0" ALIGN="absmiddle"><A HREF="?name=download&file=readdownload&id=<?php
echo $arr['download']['id'];
?>
" ><font color="#990066"><B>[ <?php
echo ThaiTimeConvert($arr['download']['post_date'], "", "");
?>
] </font><font color="#0066FF"><?php
echo $arr['download']['topic'];
?>
</A></font></B>
<?php
echo NewsIcon(TIMESTAMP, $arr['download']['post_date'], "images/icon_new.gif");
?>
(<?php
echo _FORM_MOD_READX;
?>
: <?php
echo $arr['download']['pageview'];
?>
/ <?php
?>
</td>
<td><a href="<?php
echo $item['filepath'];
?>
" title="<?php
echo toTis620('คลิกเพื่อดาวโหลดไฟล์');
?>
"><?php
echo $item['filename'];
?>
</a></td>
<td align="center">
<?php
$time = strtotime($item['time']);
echo ThaiTimeConvert($time, false, 1);
?>
</td>
<td align="center">
<a href="index.php?name=subreport&action=delete&id=<?php
echo $item['id'];
?>
" title="<?php
echo toTis620('คลิกเพื่อลบ');
?>
" onclick="return confirm('<?php
echo toTis620('ยืนยันที่จะลบข้อมูล?');
?>
');"><img src="images/admin/trash.gif"></a>
</td>
</tr>
?>
<TD bgcolor="<?php
echo $ColorFill;
?>
" width="100%" valign=top height="20" align="left">
<IMG SRC="images/admin/open.gif" BORDER="0" ALIGN="absmiddle"><A HREF="?name=research&file=readresearch&id=<?php
echo $arr[research][id];
?>
" name="<?php
echo $arr[research][id];
?>
" title="ajax:index3.php?name=research&file=readresearchtip&id=<?php
echo $arr[research][id];
?>
"><font color="#990066"><B>[ <?php
echo ThaiTimeConvert($arr[research][post_date], "", "");
?>
] </font><font color="#0066FF"><?php
echo $arr[research][topic];
?>
</A></font></B>
<?php
echo NewsIcon(TIMESTAMP, $arr[research][post_date], "images/icon_new.gif");
?>
<font color="#CC3300">( <?php
echo _RESEARCH_READ;
?>
<?php
echo $arr[research][pageview];
?>
)</font> <?php
echo $news['post_date'];
?>
','คุณมั่นใจในการลบหัวข้อนี้ ?');"><img src="images/admin/trash.gif" border="0" alt="ลบ" ></a>
</td>
<td><A HREF="?name=news&file=readnews&id=<?php
echo $news['id'];
?>
" target="_blank"><?php
echo $news['topic'];
?>
</A><?php
echo $CommentIcon;
?>
</td>
<td ><CENTER><?php
echo ThaiTimeConvert($news['post_date'], '', '');
?>
</CENTER></td>
<td align="center">
<?php
if ($category['category_name']) {
//หากมีหมวดแสดงรูป
?>
<A HREF="#"><IMG SRC="images/admin/folders.gif" BORDER="0" align="absmiddle" alt="<?php
echo $category['category_name'];
?>
" onMouseOver="MM_displayStatusMsg('<?php
echo $category['category_name'];
?>
');return document.MM_returnValue"></A>
<?php
</div>
<div class="form-group">
<label for="postdate" class="col-sm-2 control-label">บันทึกเมื่อ</label>
<div class="col-sm-3">
<input type="text" class="form-control" id="postdate" value="<?php
echo ThaiTimeConvert(strtotime($postdate), "", "2");
?>
" disabled>
</div>
</div>
<div class="form-group">
<label for="updatedate" class="col-sm-2 control-label">แก้ไขเมื่อ</label>
<div class="col-sm-3">
<input type="text" class="form-control" id="updatedate" value="<?php
if ($updatedate) {
echo ThaiTimeConvert(strtotime($updatedate), "", "2");
}
?>
" disabled>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-6">
<button type="submit" class="btn btn-primary"><span class="glyphicon glyphicon-ok"></span> บันทึก</button> <button type="submit" class="btn btn-default" onClick="history.go(-1);return true;"><span class="glyphicon glyphicon-remove"></span> ยกเลิก</button>
</div>
</div>
</form>
</div>
</div>
</div>
</body>
echo "<TR>";
if ($Color == 0) {
$Color = 1;
$ColorFill = "#F0F0F0";
} else {
$Color = 0;
$ColorFill = "#FDEAFB";
}
$value = str_replace("</item>", "", $value);
$iTitle[$key] = strip_tags(substr($value, strpos($value, "<title>"), strpos($value, "</title>")));
$iLink[$key] = strip_tags(substr($value, strpos($value, "<link>"), strpos($value, "</link>") - strpos($value, "<link>")));
$iPic[$key] = strip_tags(substr($value, strpos($value, "<pic>"), strpos($value, "</pic>") - strpos($value, "<pic>")));
$iDesc[$key] = strip_tags(substr($value, strpos($value, "<description>"), strpos($value, "</description>") - strpos($value, "<description>")));
$ipubDate[$key] = strip_tags(substr($value, strpos($value, "<pubDate>"), strpos($value, "</pubDate>") - strpos($value, "<pubDate>")));
//�ʴ�������
$timesdate = ThaiTimeConvert($ipubDate[$key], "", "");
// echo "<tr><td><img src=images/go.gif><a href='".$iLink[$key]."' target='_blank' /><img src='".$iPic[$key]."' border=0 align=left><b>".$iTitle[$key]."</b></a><br>".$iDesc[$key]." ";
// echo " ".NewsIcon(TIMESTAMP, $ipubDate[$key], "images/icon_new.gif")."";
// echo "(".$timesdate.")</td></tr>";
echo "<td bgcolor={$ColorFill}><img src=images/17.png><a href='" . $iLink[$key] . "' target='_blank' /><b> " . $iTitle[$key] . "</b></a>";
echo " " . NewsIcon(TIMESTAMP, $ipubDate[$key], "images/icon_new.gif") . "";
echo "(" . $timesdate . ")</td></tr>";
echo "</Tr><TR><TD colspan=2 height=\"1\" class=\"dotline\"></TD></TR>";
}
}
echo "<TR><TD colspan=2 height=\"1\" class=\"dotline\"></TD></TR>";
echo "</table>";
?>
<td>
</tr>
<tr>
</B>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5"><?php
echo _FORM_MOD_READ;
?>
<?php
echo $arr['research']['pageview'];
?>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5">
<?php
echo ThaiTimeConvert($arr['research']['post_date'], "1", "");
?>
</td>
</tr>
</table></td></tr>
</table>
</TD>
</TR>
<TR>
<TD height="1" class="dotline"></TD>
</TR>
<TR>
<TD>
<BR>
<td height="26" colspan="2" bgcolor="#0099CC"> <img src="images/icon/chart.png" width="12" height="12" align="absmiddle" /><b> <font color="#ffffff"><?php
echo _WEBBOARD_INDEX_STATIC;
?>
</b></font></td>
</tr>
<tr >
<td width="10"> </td>
<td height="26">
<?php
$db->connectdb(DB_NAME, DB_USERNAME, DB_PASSWORD);
$BoardResult = $db->select_query("SELECT * FROM " . TB_WEBBOARD . " {$SQLwhere2} ORDER BY id DESC LIMIT 1 ");
while ($WebBoard = $db->fetch($BoardResult)) {
echo "<font size='2' color='#333333'>" . $WebBoard['id'] . " " . _WEBBOARD_INDEX_TOPIC . "</font>";
$res['member'] = $db->select_query("SELECT * FROM " . TB_MEMBER . " ORDER BY id DESC LIMIT 1 ");
while ($arr['member'] = $db->fetch($res['member'])) {
echo " ";
echo "" . _FORM_MOD_POSTED . " " . $arr['member']['id'] . " " . _WEBBOARD_INDEX_MEMBER . " ";
echo " ";
echo "" . _WEBBOARD_INDEX_MEMBER_LAST . "</font><a href='popup.php?name=member&file=member_view&id=" . $arr['member']['id'] . "' onclick=\"return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 500, objectHeight: 300} )\" class=\"highslide\" ><b> " . $arr['member']['user'] . " </b></a>";
}
echo " ";
echo "<br> " . _WEBBOARD_INDEX_TOPIC_LAST . " : <A HREF=\"?name=webboard&file=read&id=" . $WebBoard['id'] . "\" ><b>" . $WebBoard['topic'] . "</b></A> (" . ThaiTimeConvert($WebBoard['post_date'], "", "2") . " )</font>";
}
?>
</td>
</tr>
</table>
<p> </p></TD></TR></TBODY>
</TABLE>
</B>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5"><?php
echo _FORM_MOD_READ;
?>
<?php
echo $arr['news']['pageview'];
?>
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5">
<?php
echo ThaiTimeConvert($arr['news']['post_date'], "1", "");
?>
</td>
</tr>
</table></td></tr>
</table>
</TD>
</TR>
<TR>
<TD height="1" class="dotline"></TD>
</TR>
<TR>
<TD>
<BR>
<th>สถานะ</th>
</thead>
<tbody>
<?php
$sqlcomment = " SELECT * FROM ioffice_bookcomment bc\n LEFT JOIN ioffice_bookstatus bs ON(bc.bookstatusid=bs.bookstatusid)\n LEFT JOIN person_main pm ON(bc.comment_personid=pm.person_id)\n LEFT JOIN person_position pp ON(bc.comment_positionid=pp.position_code)\n LEFT JOIN system_department sd ON(bc.comment_departmentid=sd.department)\n WHERE bookid=" . $row['bookid'];
//echo $sqlcomment;
$resultcomment = mysqli_query($connect, $sqlcomment);
$commentnum = 0;
while ($rowcomment = $resultcomment->fetch_assoc()) {
echo "<tr>";
echo "<td>" . ++$commentnum . "</td>";
echo "<td>" . $rowcomment["commentdetail"] . "</td>";
echo "<td>" . $rowcomment["prename"] . $rowcomment["name"] . " " . $rowcomment["surname"] . "</td>";
echo "<td>" . $rowcomment["position_name"] . "</td>";
echo "<td><a tabindex='0' class='btn btn-xs' role='button' data-toggle='popover' data-placement='top' data-trigger='focus' title='หน่วยงาน' data-content='" . $rowcomment["department_name"] . "''>" . $rowcomment["department_precis"] . "</a></td>";
echo "<td>" . ThaiTimeConvert(strtotime($rowcomment['commentdate']), "", "2") . "</td>";
echo "<td>" . $rowcomment["bookstatusname"] . "</td>";
echo "</tr>";
}
?>
</tbody>
</table>
<hr>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal"><span class='glyphicon glyphicon-remove' aria-hidden='true'></span> ปิด</button>
</div>
</div>
</div>
</div>
</td>
$SQLwhere3 = "where (detail like '%{$keyword}%') or (post_name like '%{$keyword}%')";
$Color = 0;
$BoardResult2 = $db->select_query("SELECT * FROM " . TB_WEBBOARD_COMMENT . " {$SQLwhere3} ORDER BY id DESC LIMIT {$goto}, {$limit}");
while ($WebBoard2 = $db->fetch($BoardResult2)) {
if ($Color == 0) {
$Color = 1;
$ColorFill = "#FFFFFF";
} else {
$Color = 0;
$ColorFill = "#FFFFFF";
}
$result3 = mysql_query($sql3);
$showboard = $db->fetch($db->select_query("SELECT * FROM " . TB_WEBBOARD . " WHERE id = '" . $WebBoard2[topic_id] . "' "));
//Sum comment
echo "<tr height=\"20\">";
echo "<td bgcolor=\"" . $ColorFill . "\" align='left' width='70%'><IMG SRC=\"images/icon/dok.gif\" BORDER=\"0\" ALIGN=\"absmiddle\"> <B>" . sprintf("%0" . _NUM_ID . "d", $showboard[id]) . " : </B> ";
$text4 = "<A HREF=\"index.php?name=webboard&file=read&id=" . $showboard[id] . "#comment" . $WebBoard2[id] . "\" target='_blank'>Re: " . $showboard[topic] . " " . _FROM_COMMENT_NUM . " " . $dbarr[comment][id] . " </A></td><td bgcolor=\"" . $ColorFill . "\" align='center'> ";
$bodytag4 = str_replace("{$key}", "<FONT style=\"BACKGROUND-COLOR: yellow\">{$key}</FONT>", "{$text4}");
echo $bodytag4;
$text5 = "<B><FONT COLOR=\"#6600FF\">" . $showboard[post_name] . "</FONT></B></CENTER></td>\n";
$bodytag5 = str_replace("{$key}", "<FONT style=\"BACKGROUND-COLOR: yellow\">{$key}</FONT>", "{$text5}");
echo $bodytag5;
echo "<td bgcolor=\"" . $ColorFill . "\" width=\"15%\"><CENTER><FONT COLOR=\"#339900\">" . ThaiTimeConvert($showboard[post_date], "", "") . "</FONT></CENTER></td>\n";
echo "<tr><td colspan=\"4\" height=1 class=\"dotline\"></td></tr>\n";
}
@mysql_free_result($BoardResult);
$db->closedb();
}
?>
</table>
?>
<br><br>
เข้าชม : <?php
echo $pageview;
?>
<br><br>
</td>
</tr>
<tr>
<td height="1" class="dotline"></td>
</tr>
<tr>
<td>
<br>
<B>ลงประกาศเมื่อ : </B><?php
echo ThaiTimeConvert($event['post_date'], "1", "");
?>
<?php
if (isset($_SESSION['admin_user'])) {
//Admin Login Show Icon
?>
<a href="?name=admin&file=editevent&id=<?php
echo $event['id'];
?>
"><img src="images/admin/edit.gif" border="0" alt="แก้ไข" ></a>
<a href="javascript:Confirm('?name=admin&file=delevent&id=<?php
echo $event['id'];
?>
','คุณมั่นใจในการลบปฏิทินหัวข้อนี้ ?');"><img src="images/admin/trash.gif" border="0" alt="ลบ" ></a>
<?php
}
$db->del(TB_NEWS, " id='" . $_GET['id'] . "' ");
$db->closedb();
if ($_GET['pic'] != '0') {
@unlink("icon/news_" . $_GET['prefix'] . ".jpg");
}
$data = '<?php xml version="1.0" encoding="' . $iso . '"?>' . "\n";
$data .= '<rss version="2.0">' . "\n";
$data .= '<channel>' . "\n";
$data .= '<title>' . WEB_TITILE . '</title>' . "\n";
$data .= '<description>' . _ADMIN_NEW_MENU_TITLE . '</description>' . "\n";
$data .= '<link>' . WEB_URL . '</link>' . "\n";
$data .= '<lastBuildDate>' . date("D, d M Y H:i:s") . '</lastBuildDate>' . "\n";
$db->connectdb(DB_NAME, DB_USERNAME, DB_PASSWORD);
$listof = $db->select_query("SELECT * FROM " . TB_NEWS . " where category='2' ORDER BY id desc limit 10");
while ($result = $db->fetch($listof)) {
$timesdate = ThaiTimeConvert($result['post_date'], "1", "");
$res['category'] = $db->select_query("SELECT * FROM " . TB_NEWS_CAT . " WHERE id='" . $result['category'] . "' ");
$arr['category'] = $db->fetch($res['category']);
if ($result['pic'] == 1) {
$pics = '' . WEB_URL . '/icon/news_' . $result['post_date'] . '.jpg';
} else {
$pics = '' . WEB_URL . '/images/icon/' . $arr['category']['icon'] . '';
}
$data .= '<item>' . "\n";
$data .= '<title>' . $result['topic'] . '</title>' . "\n";
$data .= '<link>' . WEB_URL . '/?name=news&file=readnews&id=' . $result['id'] . '</link>' . "\n";
$data .= '<pic>' . $pics . '</pic>' . "\n";
$data .= '<description>' . $result['headline'] . '</description>' . "\n";
$data .= '<pubDate>' . $result['post_date'] . '</pubDate>' . "\n";
$data .= '</item>' . "\n";
}
?>
/ <?php
echo _FORM_MOD_DONWLOAD;
?>
: <?php
echo $arr['research']['rate'];
?>
)</font> <?php
echo _RESEARCH_AUTH;
?>
<font color="#CC3300"><?php
echo $arr['research']['auth'];
?>
</font></td>
<td valign="top"><CENTER><?php
echo ThaiTimeConvert($arr['research']['post_date'], '', '');
?>
</CENTER></td>
<td align="center" valign="top">
<?php
if ($arr['category']['category_name']) {
//ËÒ¡ÁÕËÁÇ´áÊ´§ÃÙ»
?>
<A HREF="#"><?php
echo $arr['category']['category_name'];
?>
</A>
<?php
}
?>
</td>
<td >
<img src="images/com/b_04.jpg" width="23" alt=""></td>
<td bgcolor="#F5F5F5" width="100%" alt=""><B><FONT COLOR="#990000"><?php
echo _FROM_COMMENT_NUM;
?>
<?php
echo $count;
?>
</FONT></B>
<?php
if ($admin_user) {
echo " <A HREF=\"?name=video&file=delete_comment&id=" . $id . "&comment=" . $arr['comment']['id'] . "\"><IMG SRC=\"images/admin/trash.gif\" height=\"18\" BORDER=\"0\" ALIGN=\"absmiddle\"></A>";
}
?>
<?php
echo ThaiTimeConvert($arr['comment']['post_date'], "1", "1");
?>
</td>
<td background="images/com/b_05.jpg" width="10" alt="" height="100%"></td>
</tr>
<tr>
<td background="images/com/b_06.jpg" width="23" height="100%" alt=""></td>
<td alt=""><br>
<?php
if (substr_count($arr['comment']['comment'], '<p>') == 1) {
$temp = preg_replace("/<p>/i", "", $arr['comment']['comment']);
$temp = preg_replace("/<\\/p>/i", "", $temp);
$arr['comment']['comment'] = $temp;
}
?>
echo $knowledge['post_date'];
?>
','คุณมั่นใจในการลบหัวข้อนี้ ?');"><img src="images/admin/trash.gif" border="0" alt="ลบ" ></a>
</td>
<td><A HREF="?name=knowledge&file=readknowledge&id=<?php
echo $knowledge['id'];
?>
" target="_blank"><?php
echo $knowledge['topic'];
?>
</A><?php
echo $CommentIcon;
?>
</td>
<td ><CENTER><?php
echo ThaiTimeConvert($knowledge['post_date'], '', '');
?>
</CENTER></td>
<td align="center">
<?php
if ($category['category_name']) {
//หากมีหมวดแสดงรูป
?>
<A HREF="#"><IMG SRC="images/admin/folders.gif" BORDER="0" align="absmiddle" alt="<?php
echo $category['category_name'];
?>
" onMouseOver="MM_displayStatusMsg('<?php
echo $category['category_name'];
?>
');return document.MM_returnValue"></A>
<?php
