http://sir.co.kr/bbs/board.php?bo_table=g4_tiptech&sca=&sfl=wr_subject%7C%7Cwr_content&stx=%B0%F8%C1%F6+%C3%D6%BD%C5&x=0&y=0&sop=and

// 최신글 추출
function quoting(&$item1, $key) { $item1 = "'$item1'"; }
function latest_notice($skin_dir="", $bo_tables, $rows=10, $subject_len=40, $options="") {

    global $g4;

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

    if( !is_array( $bo_tables)) return 'A second parameter error:bo_tables should be an array.';

    array_walk( $bo_tables , 'quoting');
    $bo_tables_cond= implode(',', $bo_tables);
    $notice_res= sql_query( "select bo_table, bo_notice from {$g4['board_table']} where bo_table in ( $bo_tables_cond ) " );

    $notice_wr_id_cond=array();
    $notice_bo_tables=array();

    while( $row= sql_fetch_array( $notice_res)) {
        $this_notice= trim($row['bo_notice']);
        if( empty( $this_notice)) continue;
        $notice_wr_id_cond[]= implode( ',', split("\n", $this_notice));
        $notice_bo_tables[]= $row['bo_table'];
    }

    $sqls= array();

    foreach( $notice_bo_tables as $idx => $notice_bo_table) {
        $sqls[]= " select wr_id , wr_subject from {$g4['write_prefix']}$notice_bo_table where wr_id in ( {$notice_wr_id_cond[$idx]} )";
    }

    $list = array();

    $result = sql_query( implode( ' union all ', $sqls));
    for ($i=0; ($row = sql_fetch_array($result)) && $i < $rows; $i++)
        $list[$i] = get_list($row, array( 'bo_table'=>$notice_bo_table), $latest_skin_path, $subject_len);

    ob_start();
    include "$latest_skin_path/latest.skin.php";
    $content = ob_get_contents();
    ob_end_clean();

    return $content;
}
?>