1){ if(!$_SESSION['ss_mb_id']) alert("로그인 후 사용하세요."); if($mb['mb_level'] < $bo_cfg['bc_list_level']) alert("권한이 없습니다."); } $page = $page?$page:1; $limitNum = $bo_cfg['bc_listnum']?$bo_cfg['bc_listnum']:10; // 한페이지당 갯수 $startNum = ($page - 1) * $limitNum; // 시작 열을 구함 $searchField = $schField; $searchValue = $schValue; if($_GET['bo_id']=="counsel"){ //답변글이 리스트에서 노출이 안되는 게시판 $WHERE .= " AND bo_reply = ''"; } if($searchField && $searchValue){ $WHERE .= " AND $searchField LIKE '%".$searchValue."%'"; } if($bo_category){ $WHERE .= " AND bo_category = '".$bo_category."'"; } //페이징을 위한 총 갯수 $SQL = sprintf("SELECT count(*) AS COUNT FROM dh_board_%s WHERE 1 %s",$_GET['bo_id'],$WHERE); $DB->execute_query($SQL); $DATA = $DB->next_row(); $totalPage = 1; $totalCount = $DATA['COUNT']; if($DATA['COUNT']==0){ $list_msg="데이터가 없습니다."; }else{ $totalPage = ceil($DATA['COUNT'] / $limitNum); if(preg_match("/review/i",$_GET['bo_id'])) $ORDERBY = "ORDER BY bo_notice DESC,bo_num ASC,bo_reply"; else $ORDERBY = "ORDER BY bo_notice DESC,bo_num ASC,bo_reply"; $SQL = sprintf("SELECT * FROM dh_board_%s WHERE 1 %s %s ASC,bo_reply ASC LIMIT %d,%d",$_GET['bo_id'],$WHERE,$ORDERBY,$startNum,$limitNum); $DB->execute_query($SQL); $list = array(); $i=0; while($DATA = $DB->next_row()){ $list[$i]['reply_count'] = 0; if($_GET['bo_id']=="counsel"){ //상담게시판 답변 가져오기 $WHERE2 = sprintf(" AND bo_parent = %d",$DATA['bo_no']); $SQL2 = sprintf("SELECT count(*) AS COUNT FROM dh_board_%s WHERE 1 %s AND bo_reply!=''",$_GET['bo_id'],$WHERE2); $DB2 = new daaham_DB; $DB2->execute_query($SQL2); $DATA2 = $DB2->next_row(); $list[$i]['reply_count'] = $DATA2['COUNT']; } if($DATA['bo_secret']=='Y') $list[$i]['secret_icon'] = " "; else $list[$i]['secret_icon'] = "   "; if ($DATA['bo_datetime'] <= date("Y/m/d H:i:s", strtotime("+3 day"))){ $list[$i]['icon_new'] = "\"\""; } $list[$i]['link'] = "board_view.php?bo_id=".$_GET['bo_id']."&bo_category=".$bo_category."&bo_no=".$DATA['bo_no']."&page=".$page."&schField=".$schField."&schValue=".$schValue; foreach ($DATA as $key => $value) { $list[$i][$key] = $value; } $i++; } } $pager = get_paging($limitNum, $page, $totalPage,"?bo_id=".$_GET['bo_id']."&bo_category=".$_GET['bo_category']."&schField=".$_GET['schField']."&schValue=".$_GET['schValue']); include ("./skin/{$bo_cfg['bc_skin']}/list.php"); ?> destroy();?> 1) { $str .= '처음'.PHP_EOL; } $start_page = ( ( (int)( ($cur_page - 1 ) / $write_pages ) ) * $write_pages ) + 1; $end_page = $start_page + $write_pages - 1; if ($end_page >= $total_page) $end_page = $total_page; if ($start_page > 1) $str .= '이전'.PHP_EOL; if ($total_page > 1) { for ($k=$start_page;$k<=$end_page;$k++) { if ($cur_page != $k) $str .= ''.$k.''.PHP_EOL; else $str .= ''.$k.''.PHP_EOL; } } if ($total_page > $end_page) $str .= '다음'.PHP_EOL; if ($cur_page < $total_page) { $str .= '맨끝'.PHP_EOL; } if ($str) return "
{$str}
"; else return ""; } ?>