"; ################################################################################################ ########################################## 공지사항 ############################################ $n_sql = "select * from $board_table where db='$board_db' && notice='Y' $addboard order by idx 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], 0, 10)){ $n_wdate = "".substr($n_row[wdate], 0, 10).""; $newIco = "

"; } else { $n_wdate = substr($n_row[wdate], 0, 10); $newIco = ""; } echo" [공지] $n_subject $newIco ".b_string_cut($n_row[name], $name_length, "..")." $n_wdate $ficon1 $ficon2 $ficon3 $n_row[hit] "; } ########################################## 공지사항 ############################################ ################################################################################################ #################################### 게시물 리스트 S ########################################### $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 idx 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(($login_id == $row[id] && $row[id]) || $login_level>=$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"; } //echo $subject; if($row[sort]){ $subject = "

".$subject; for($i=0; $i"; $newIco = "

"; } else { $wdate = substr($row[wdate],0,10); $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"; //상세 보기 창 5월 16일 $bmem_sql = "select * from member where userid='$row[id]' "; $bmem_row = mysql_fetch_array(mysql_query($bmem_sql)); echo" ".$pnum--." $subject $newIco $close_icon "; echo " ".b_string_cut($write_name, $name_length, "..").""; echo " $wdate $ficon1 $ficon2 $ficon3 $row[hit] "; } if(!$total){ echo" 등록(검색)된 글이 없습니다. "; } echo"

"; $fquery = "board_db=$board_db&column=$column&keyword=$keyword&pm=$pm"; psk_pagelinkB($totalpage, $pageitem, $page, "$board_img/i_prev.gif", "$board_img/i_next.gif", $fquery, "$board_img/i_prev2.gif", "$board_img/i_next2.gif"); echo"

"; print_button("write_form", "i_write.gif"); echo"

이름 제목 내용

"; #### 검색 폼 E #### ?>