".$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."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 if($catsort == '5'){ $catlet='역사'; } else if($catsort == '6'){ $catlet='국제'; } else if($catsort == '7'){ $catlet='스포츠'; } else if($catsort == '8'){ $catlet='정보통신'; } else if($catsort == '9'){ $catlet='연예'; } else if($catsort == '10'){ $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."..."; } ?>     " ?> > > >       <<Before "; echo "<<Before "; for($s=$startdiv; $s<=$enddiv; $s++){ if($page_total < $s){ break; } if($s == $cur_page) echo "".$s." " ; else // echo "".$s." " ; echo "".$s." " ; } if($enddiv < $page_total) // echo " Next>>"; echo " Next>>"; ?>