<?
if (!defined('_GNUBOARD_')) exit;

// 최신글 추출
function boardnew($title="New Write", $skin_dir="", $rows=10, $subject_len=40, $options="")
{
    global $g4, $g4_board, $g4_board, $g4_table_in;

    if ($skin_dir)
        $new_skin_path = "$g4[path]/skin/board_new/$skin_dir";
    else
        $new_skin_path = "$g4[path]/skin/board_new/basic";

    $list = array();
	
	// fixing.lib.php 파일에서 사용된 $g4_table_in 을 그대로 사용한다.
    $sql = " select bo_table, wr_id from $g4[board_new_table] where wr_id = wr_parent $g4_table_in order by bn_datetime desc limit 0, $rows ";
    $result = sql_query($sql);
	$b = 0;
    for ($i=0; $row = sql_fetch_array($result); $i++) {
	   $id = $row[wr_id];
	   $bot = $row[bo_table];
	   $new[$bot][$id] = $i;
	   // 중복배열제거 하면서 테이블별 wr_id 값을 정리
	   if($new_in[$bot]){
			$new_in[$bot] .= ", '{$id}'";
	   }else{
			$new_bo[$b] = $bot;
			$new_in[$bot] = "'{$id}'";
			$b++;
	   }
    }
	$bo_new[count] = $i;
	for($i=0; $i<count($new_bo); $i++){
		//배열에서 이름 찾기
		$board = $g4_board[$g4_board['num'][$new_bo[$i]]];
		$tmp_write_table = $g4['write_prefix'] . $new_bo[$i];
		$sql = " select * from $tmp_write_table where wr_id in ( {$new_in[$new_bo[$i]]} ) ";
		$result = sql_query($sql);
		for ($q=0; $row = sql_fetch_array($result); $q++) {
			$num = $new[$new_bo[$i]][$row['wr_id']];
			$list[$num] = get_list($row, $board, $new_skin_path, $subject_len);
			$list[$num][new_board] = $board[bo_subject];
			$list[$num][new_href] = "{$g4[bbs_path]}/board.php?bo_table={$new_bo[$i]}";
		}
	}

    ob_start();
    include "$new_skin_path/board_new.skin.php";
    $content = ob_get_contents();
    ob_end_clean();

    return $content;
} 
?>