오늘날짜가 되면 공지처럼 맨 위에 올라가고, 그 외 날짜는 이전 순서데로 list하는 법 채택완료

// 공지 처리

if (!$is_search_bbs) {

    $today = date('Y-m-d 00:00:00');

    $sql = " select * from {$write_table} where wr_datetime >= '{$today}' ";

    $result = sql_query($sql);

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

        $notice_array[] = $row['wr_id'];

 

        $list[$i] = get_list($row, $board, $board_skin_url, G5_IS_MOBILE ? $board['bo_mobile_subject_len'] : $board['bo_subject_len']);

        $list[$i]['is_notice'] = true;

        $list[$i]['num'] = 0;

        $notice_count++;

 

        if($notice_count >= $list_page_rows)

            break;

    }

}

if ($is_search_bbs) {

    $sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$sql_order} limit {$from_record}, $page_rows ";

} else {

    $sql = " select * from {$write_table} where wr_is_comment = 0 and wr_datetime < '{$today}'";

    if(!empty($notice_array))

        $sql .= " and wr_id not in (".implode(', ', $notice_array).") ";

    $sql .= " {$sql_order} limit {$from_record}, $page_rows ";

}