그누4용 최근게시글 페이지기능을 그누5로 변경 채택완료

</p>

<p>// 최신글 추출

function latest_paging($skin_dir="", $bo_table, $url, $page=1, $page_name="page", $rows=5, $subject_len=40, $write_page=5, $total_count = '', $options="")

{

    global $g5, $config;</p>

<p>    if ($skin_dir)

        $GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g5['path']}/skin/latest/$skin_dir";

    else

        $GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g5['path']}/skin/latest/basic";</p>

<p>    $list = array();</p>

<p>    $sql = " select * from {$g5['board_table']} where bo_table = '{$bo_table}' ";

        $board = sql_fetch($sql);

        $bo_subject = get_text($board['bo_subject']);</p>

<p>        $tmp_write_table = $g5['write_prefix'] . $bo_table; // 게시판 테이블 전체이름

        $sql = " select * from {$tmp_write_table} where wr_is_comment = 0 order by wr_num limit 0, {$rows} ";

        $result = sql_query($sql);</p>

<p>    if($total_count == "")

    {

        $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");

        $total_count = $sql[cnt];

        $min_number = $sql[n_num];

        $max_number = $sql[m_num];

    }    else  {

        $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");

        $min_number = $sql[n_num];

        $max_number = $sql[n_num] + $total_count;

    }</p>

<p>    $total_page  = ceil($total_count / $rows);  // 전체 페이지 계산

    if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)

    $from_record = ($page - 1) * $rows; // 시작 열을 구함</p>

<p>    // 게시물 구해오기

    $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 ";</p>

<p>    //explain($sql);

    $result = sql_query($sql);

    for ($i=0; $row = sql_fetch_array($result); $i++) {

        $list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);

    }</p>

<p>    if(strstr($url, "?")) { 

        $connect = "&";

    } else { 

        $connect = "?";

    }</p>

<p>    $write_pages = get_paging($write_page, $page, $total_page, $url.$connect.$page_name."=");</p>

<p>    ob_start();

    include "$latest_skin_path/latest.skin.php";

    $content = ob_get_contents();

    ob_end_clean();</p>

<p>    return $content;

}</p>

<p> </p>

<p>