새벽에 뜬금없지만.. 그룹 최신글 페이징 가능할까요..? 채택완료
Dizz
11년 전
조회 8,089
검색신공으로 그룹 최신글도 찾고 페이징 최신글도 찾았는데
그룹최신글이 페이징 되는건 쉽지가 않네요.
http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=150169&sca=%EC%B5%9C%EC%8B%A0%EA%B8%80&sfl=wr_subject%7C%7Cwr_content&stx=%ED%8E%98%EC%9D%B4%EC%A7%95">http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=150169&sca=%EC%B5%9C%EC%8B%A0%EA%B8%80&sfl=wr_subject%7C%7Cwr_content&stx=%ED%8E%98%EC%9D%B4%EC%A7%95
이 스킨을 그룹 최신글로 바꾸면 완벽할거 같은데 방법이 있을까요?
</div>
<div><div>// 최신글 추출</div>
<div>function latest_paging($skin_dir="", $bo_table, $url, $page=1, $page_name="page", $rows=5, $subject_len=40, $write_page=5, $total_count = '', $options="")</div>
<div>{</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>global $g4, $config;</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($skin_dir)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/$skin_dir";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>else</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/basic";</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list = array();</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = " select * from {$g4['board_table']} where bo_table = '$bo_table'";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$board = sql_fetch($sql);</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$tmp_write_table = $g4['write_prefix'] . $bo_table; // 게시판 테이블 전체이름</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if($total_count == "")</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>{</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = sql_fetch(" select count(*) as cnt, MIN(wr_num) as n_num, MAX(wr_num) as m_num from $tmp_write_table where wr_is_comment = 0 order by wr_num");</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$total_count = $sql[cnt];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$min_number = $sql[n_num];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$max_number = $sql[m_num];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}<span class="Apple-tab-span" style="white-space: pre"> </span>else {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = sql_fetch(" select count(*) as cnt, MIN(wr_num) as n_num from $tmp_write_table where wr_is_comment = 0 order by wr_num limit 0, $total_count");</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$min_number = $sql[n_num];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$max_number = $sql[n_num] + $total_count;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$total_page = ceil($total_count / $rows); // 전체 페이지 계산</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$from_record = ($page - 1) * $rows; // 시작 열을 구함</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>// 게시물 구해오기</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = " select * from $tmp_write_table where wr_is_comment = 0 AND (wr_num between '".$min_number."' and '".$max_number."') order by wr_num limit $from_record, $rows ";</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>//explain($sql);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$result = sql_query($sql);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>for ($i=0; $row = sql_fetch_array($result); $i++) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if(strstr($url, "?")) { </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$connect = "&";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} else { </div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$connect = "?";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$write_pages = get_paging($write_page, $page, $total_page, $url.$connect.$page_name."=");</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ob_start();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>include "$latest_skin_path/latest.skin.php";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$content = ob_get_contents();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ob_end_clean();</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>return $content;</div>
<div>}</div></div>
<div>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
채택된 답변
+20 포인트
11년 전
생각을 달리해
일반 그룹최신글 스킨에
http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=128944&sca=%EC%B5%9C%EC%8B%A0%EA%B8%80&sfl=wr_subject%7C%7Cwr_content&stx=%ED%8E%98%EC%9D%B4%EC%A7%95">http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=128944&sca=%EC%B5%9C%EC%8B%A0%EA%B8%80&sfl=wr_subject%7C%7Cwr_content&stx=%ED%8E%98%EC%9D%B4%EC%A7%95
적용해서 해결했습니다.
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인