그룹최신글 게시판설정에 의해 순서로 출력하는 방법

</strong></p>

<p>function latest_group_search($skin_dir="", $gr_id, $rows=10, $subject_len=40, $content_len=40, $order, $thumb_width, $thumb_height)

{

global $g5;</p>

<p>$s = explode(' ', strip_tags($order));

  for ($i=0; $i<count($s); $i++) {

  $search_str = $s[$i];

  if ($i == 0) { $search_or .= " and (INSTR(wr_subject, '$search_str'))"; }

  else { $search_or .= " or (INSTR(wr_subject, '$search_str'))"; }

 }</p>

<p>$list = array();

$limitrows = $rows;</p>

<p>$sql_gr = " select gr_subject, gr_10 from {$g5['group_table']} where gr_id = '$gr_id' ";

$gr = sql_fetch($sql_gr);

$gr_subject = $gr[gr_subject];

$gr_color = $gr[gr_10];</p>

<p>

$sqlgroup = " select bo_table, bo_subject, bo_order from {$g5['board_table']} where gr_id = '$gr_id' and bo_use_search = '1'  <span style="color:#ff0000">order by bo_order asc "; </span>

$rsgroup = sql_query($sqlgroup);</p>

<p>    if (!$skin_dir) $skin_dir = 'basic';

        $latest_skin_path = G5_SKIN_PATH.'/latest/'.$skin_dir;

        $latest_skin_url  = G5_SKIN_URL.'/latest/'.$skin_dir;

  $lib_thumb_width = $thumb_width; // 썸네일 넓이를 정의함

        $lib_thumb_height =  $thumb_height; // 썸네일 높이를 정의함</p>

<p>for ($j=0, $k=0; $rowgroup=sql_fetch_array($rsgroup); $j++) {

$bo_table = $rowgroup[bo_table];</p>

<p>

// 테이블 이름구함

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

$board = sql_fetch($sql);

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

<p> </p>

<p>// 옵션에 따라 정렬

<span style="color:#0055ff">$sql3 = " select * from {$tmp_write_table} where wr_is_comment = 0 $search_or"; </span>

$sql3 .= " order by wr_id desc";

$sql3 .= " limit $limitrows";

$result3 = sql_query($sql3);</p>

<p> </p>

<p>for ($i=0; $row = sql_fetch_array($result3); $i++, $k++) {</p>

<p>if(!$orderby) $op_list[$k] = $row[wr_datetime];

else  {

$op_list[$k] = is_string($row[$orderby]) ? sprintf("%-256s", $row[$orderby]) : sprintf("%016d", $row[$orderby]);

$op_list[$k] .= $row[wr_datetime];

}</p>

<p>$list[$k] = get_list($row, $board, $latest_skin_path, $subject_len);</p>

<p>$list[$k][bo_table] = $board[bo_table];

$list[$k][bo_subject] = $board[bo_subject];

$list[$k][bo_order] = $board[bo_order];</p>

<p>$list[$k][bo_wr_subject] = cut_str($board[bo_subject] . $list[$k][wr_subject], $subject_len);

}

}

if($k>0) array_multisort($op_list, SORT_DESC, $list);

if($k>$rows) array_splice($list, $rows);</p>

<p> ob_start();

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

    $content = ob_get_contents();

    ob_end_clean();</p>

<p>    return $content;

}</p>

<p><strong>