".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' and ".$prefix."category='$categ' order by ".$prefix."msg_date desc, ".$prefix."msg_id limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 4"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // order값이 desc일때, 즉 목록순서로 정렬할 때이다. ********************************** if($order == "desc") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** //$result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth, ".$prefix."filename, ".$prefix."msg_body"from $tablename order by ".$prefix."msg_date desc, ".$prefix."author asc, ".$prefix."msg_subject asc limit $start_page, $max_msg_per_page"); $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth, ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_date desc, ".$prefix."author asc, ".$prefix."msg_subject asc limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 3"; exit; } $num_rows = mysql_num_rows($result); } // order값이 asc일때, 즉 시간순서로 정렬할 때이다. ********************************** else if ($order == "asc") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_date desc, ".$prefix."msg_id limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 4"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // order값이 hit일때, 즉 조회순서로 정렬할 때이다. ********************************** else if ($order == "hit") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_hit desc, ".$prefix."msg_id desc limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 5"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // order값이 search일때, 즉 검색결과를 표시할 때이다. ********************************** else if ($order == "search") { $keyword = eregi_replace("\+", " ", $keyword); $keyword_list = split(" ", $keyword); $total_array_num = count($keyword_list); $sqlquery = "select count(*) from $tablename "; $sqlquery .= " where ".$prefix.$search_option." like '%".$keyword."%' order by ".$prefix."msg_id desc"; $result = mysql_query($sqlquery); if (!$result){ print "Error No. 5-1"; mysql_close(); exit; } $num_rows = mysql_fetch_row($result); if($search_option == "msg_subject") $count_message = "제목에서 "; else if($search_option == "author") $count_message = "이름에서 "; else if($search_option == "msg_body") $count_message = "본문에서 "; $count_message .= "".$keyword."의 검색결과 총 ".$num_rows[0]." 개의 게시물이 있습니다."; //Search시 페이지 생성 부분 if(($num_rows[0] % $max_msg_per_page) == 0){ $page_total = (int) ($num_rows[0] / $max_msg_per_page); // No remain } else{ $page_total = (int) ($num_rows[0] / $max_msg_per_page) + 1; } //Patch Code ******************************************* $sqlquery = "select count(*) from $tablename where ".$prefix.$search_option." like '%".$keyword."%'"; $result = mysql_query($sqlquery); if(!$result){ print "Search Error. No 1"; mysql_close(); exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; //******************************************************* $sqlquery = "select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name from $tablename "; $sqlquery .= " where ".$prefix."yesno='$yesdisp' and ".$prefix.$search_option." like '%".$keyword."%' order by ".$prefix."msg_id desc limit $start_page, $max_msg_per_page"; $result = mysql_query($sqlquery); if(!$result) { print "Search Error. No 1"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // Display List ****************************************************************** ?> cellspacing=0 cellpadding=0>

cellspacing=0 cellpadding=0> >           [분류] 인터넷 정보통신 과학기술 컴퓨터 중관촌 > >목록순 > >시간순 > >조회순   "; else $attach1 = " "; if($file2name != "") $attach2 = ""; else $attach2 = " "; if($file3name != "") $attach3 = ""; else $attach3 = " "; if($catsort == '1'){ $catlet='인터넷'; } else if($catsort == '2'){ $catlet='정보통신'; } else if($catsort == '3'){ $catlet='과학기술'; } else if($catsort == '4'){ $catlet='컴퓨터'; } else { $catlet='중관촌'; } $datetime = split(" ", $msg_date); $msg_date = $datetime[0]; $msg_time = $datetime[1]; ?>   width=600 height=20> " ?>   color=black>  color=black> ''     color=black>     270) { echo text_cut($content,267)."..."; } else { echo $content."..."; } ?>     " ?>   "; $beforediv = $startdiv - 1; if($div != 0) echo "<<Before "; for($s=$startdiv; $s<=$enddiv; $s++){ if($page_total < $s){ break; } if($s == $cur_page) echo "".$s." " ; else echo "".$s." " ; } if($enddiv < $page_total) echo " Next>>"; ?>