번호 분류 제목 글쓴이 날짜 조회 "; ################################################################################################ ########################################## 공지사항 ############################################ $n_sql = "select * from $board_table where db='$board_db' && notice='Y' $addboard order by wdate desc "; $n_res = mysql_query($n_sql); while($n_row = @mysql_fetch_array($n_res)){ ########################################## 코멘트 갯수 ############################################ $c_sql = "select count(num) from $comment_table where usernum = '$n_row[num]'"; $c_row = mysql_fetch_array(mysql_query($c_sql)); if($c_row[0]) $comment_cnt = " [$c_row[0]]"; else $comment_cnt = ""; ########################################## 코멘트 갯수 ############################################ $nt_subject = strip_tags(html_entity_decode($n_row[subject])); $ncut_subject = b_string_cut($nt_subject, $subject_length, "..."); $n_subject = ereg_replace($nt_subject, $ncut_subject, html_entity_decode($n_row[subject])); //$n_subject = b_string_cut(html_entity_decode($n_row[subject]), $subject_length, "..."); $n_subject = "$n_subject $comment_cnt"; if(date("Y-m-d") == substr($n_row[wdate], 5, 5)){ $n_wdate = "".substr($n_row[wdate], 5, 5).""; $newIco = ""; } else { $n_wdate = substr($n_row[wdate], 5, 5); $newIco = ""; } echo" [공지] $n_subject $newIco ".b_string_cut($n_row[name], $name_length, "..")." $n_wdate $n_row[hit] "; } ########################################## 공지사항 ############################################ ################################################################################################ #################################### 게시물 리스트 S ########################################### $sql = "select count(num) from $board_table where db='$board_db' && notice!='Y' $addwhere "; $res = mysql_query($sql); $row = mysql_fetch_array($res); $total = $row[0]; $item = $page_skip; if(!$item) $item = 10; $pageitem = $pagenumber; if(!$pageitem) $pageitem = 10; if(!$page) $page = 1; $start = ($page - 1) * $item; $totalpage = ceil($total / $item); $pnum = $total - (($page-1) * $item); $sql = "select * from $board_table where db='$board_db' && notice!='Y' $addwhere order by wdate desc, sort asc limit $start, $item"; //echo $sql; $res = mysql_query($sql); while($row = mysql_fetch_array($res)){ ########################################## 코멘트 갯수 ############################################ $c_sql = "select count(num) from $comment_table where usernum='$row[num]'"; $c_row = mysql_fetch_array(mysql_query($c_sql)); if($c_row[0]) $comment_cnt = " [$c_row[0]]"; else $comment_cnt = ""; ########################################## 코멘트 갯수 ############################################ if($open_print == "yes" && $row[secret] == "Y"){ if(($member_id == $row[id] && $row[id]) || $db_levell>=$secret_level){ $close_icon = ""; $write_name = $row[name]; $subject = b_string_cut(html_entity_decode($row[subject]), $subject_length, "..."); $t_subject = strip_tags(html_entity_decode($row[subject])); $cut_subject = b_string_cut($t_subject, $subject_length, "..."); //$subject = ereg_replace($t_subject, $cut_subject, html_entity_decode($row[subject])); $subject = "$subject"; } else { $close_icon = ""; $write_name = $row[name]; $subject = b_string_cut(html_entity_decode($row[subject]), $subject_length, "..."); $t_subject = strip_tags(html_entity_decode($row[subject])); $cut_subject = b_string_cut($t_subject, $subject_length, "..."); //$subject = ereg_replace($t_subject, $cut_subject, html_entity_decode($row[subject])); $subject = "$subject"; } } else { $close_icon = ""; $write_name = $row[name]; $subject = b_string_cut(html_entity_decode($row[subject]), $subject_length, "..."); $t_subject = strip_tags(html_entity_decode($row[subject])); $cut_subject = b_string_cut($t_subject, $subject_length, "..."); //$subject = ereg_replace("$t_subject", "$cut_subject", html_entity_decode($row[subject])); $subject = "$subject"; } //echo $subject; if($row[sort]){ $subject = "".$subject; for($i=0; $i"; $newIco = ""; } else { $wdate = substr($row[wdate],5,5); $newIco = ""; } $file = explode("||", $row[exname]); $file_name = explode("||", $row[file_name]); if($file_name[0]) $ficon1 = ""; else $ficon1 = ""; if($file_name[1]) $ficon2 = ""; else $ficon2 = ""; if($file_name[2]) $ficon3 = ""; else $ficon3 = ""; if($pnum%2) $bgcolor = "#FFFFFF"; else $bgcolor = "#FFFFFF"; echo" ".$pnum--." $row[category] $subject $newIco $close_icon ".b_string_cut($row[name], $name_length, "..")." $wdate $row[hit] "; } if(!$total){ echo" 등록(검색)된 글이 없습니다. "; } echo"
"; $fquery = "n=$n&board_db=$board_db&column=$column&keyword=$keyword"; psk_pagelinkB($totalpage, $pageitem, $page, "$board_img/prev.gif", "$board_img/next.gif", $fquery); echo" "; if(!$member_level)$member_level=0; if($write_level<=$member_level){ print_button("write_form", "i_write.gif"); } echo"
"; #### 검색 폼 S #### if($action != "read"){ echo"
"; } #### 검색 폼 E #### ?>