"; $result = mysql_query($query); $num = mysql_num_rows($result); if ($num) { $row = mysql_fetch_array($result); $category_title = $row['CATEGORY_TITLE']; $board_title = $row['BOARD_TITLE']; _ColorTextBar(htmlspecialchars(ucwords($category_title)).' - '.htmlspecialchars(ucwords($board_title)), '7BD8FE', 'FFFFFF', '480', 20, 'FFFFFF', 4, "font-family:arial;font-size:18;color:FFFFFF';font-weight:800;"); print(''); /* $query = "select POSTING.POSTING_ID as POSTING_ID, TITLE, POSTING.MEMBER_ID as MEMBER_ID, POSTING.REG as REG, POSTING.MESSAGE_BODY as MESSAGE_BODY, POSTING.PIC_PATH, greatest(max(REPLY.DATE_TIME), max(POSTING.DATE_TIME)) as LAST_REPLY from POSTING left join REPLY using (POSTING_ID) where BOARD_ID=$board_id group by POSTING_ID order by LAST_REPLY desc limit ".NUMBER_MESSAGES_SHOWN; */ // offset if (!$current_page) $current_page =1; $offset = ($current_page - 1) * NUMBER_MESSAGES_SHOWN; // mysql_data_seek($result, $offset); // $query = "select POSTING_ID, TITLE, MEMBER_ID, REG, MESSAGE_BODY, DATE_TIME $query = "select POSTING_ID, TITLE, DATE_TIME from POSTING where BOARD_ID=$board_id order by DATE_TIME desc limit ".$offset.",".NUMBER_MESSAGES_SHOWN; $result = mysql_query($query); if($result) $num = mysql_num_rows($result); $query_c = "select count(*) from POSTING where BOARD_ID=$board_id"; $result_c = mysql_query($query_c); $count = mysql_fetch_array($result_c); $pages = ceil($count[0] / NUMBER_MESSAGES_SHOWN); $startPage = $current_page - 5; $endPage = $current_page + 5; if($current_page < 6) {$startPage = 1; $endPage = min(11,$pages) ;} if($current_page > ($pages - 5)){$startPage = max(($pages - 10),1); $endPage = $pages;} // for ($i=1;$i<=$pages;$i++) for ($i=$startPage;$i<=$endPage;$i++) $p[] = ($i == $current_page) ? "$i" : "$i"; if($endPage > 0) $page_txt = 'Page : '.implode(' | ', $p); if($endPage != $pages) $page_txt .= "..."; print(""); print(""); print("'); // end of the message table print(""); print('

$page_txt

"); // "); // print post if(mysql_num_rows($result)>0) for($i=0;$i < NUMBER_MESSAGES_SHOWN; $i++) { $row = mysql_fetch_array($result); if(!$row) break; $posting_id = $row['POSTING_ID']; $title = htmlspecialchars($row['TITLE']); $poster = htmlspecialchars($row['MEMBER_ID']); $date = substr($row['DATE_TIME'], 0, 7); $message = $row['MESSAGE_BODY']; $message = htmlspecialchars(substr(trim($message), 0, 76)).'...'; $pic_path = $row['PIC_PATH']; if($pic_path) $img=""; else $img=""; // print(""); print(""); } // print(' Title Title Date Pictures $title $date $img $title

$page_txt

'); print(''); } else { print('Sorry!!!, our system is under maintenence. Please come back later'); } ?>