특정 2개이상에 테이블에서 최신글 뽑아오는 함수 입니다.

그누보드로 작업하다보면..

$bo_tableobj = array("a_bo_table", "b_bo_table");

위 와 같이 bo_table을 넣어주면 됩니다.


<?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가
//skin_dir : 스킨명 , $bo_table : 게시판코드배열, rows : 출력 갯수, $subject : 게시판 제목
function latestNew($skin_dir='', $bo_tableobj, $subject, $rows=10, $subject_len=40, $cache_time=1, $options='')
{
global $g5;

if (!$skin_dir) $skin_dir = 'basic';

if(preg_match('#^theme/(.+)$#', $skin_dir, $match)) {
if (G5_IS_MOBILE) {
$latest_skin_path = G5_THEME_MOBILE_PATH.'/'.G5_SKIN_DIR.'/latest/'.$match[1];
if(!is_dir($latest_skin_path))
$latest_skin_path = G5_THEME_PATH.'/'.G5_SKIN_DIR.'/latest/'.$match[1];
$latest_skin_url = str_replace(G5_PATH, G5_URL, $latest_skin_path);
} else {
$latest_skin_path = G5_THEME_PATH.'/'.G5_SKIN_DIR.'/latest/'.$match[1];
$latest_skin_url = str_replace(G5_PATH, G5_URL, $latest_skin_path);
}

$skin_dir = $match[1];
} else {
if(G5_IS_MOBILE) {
$latest_skin_path = G5_MOBILE_PATH.'/'.G5_SKIN_DIR.'/latest/'.$skin_dir;
$latest_skin_url = G5_MOBILE_URL.'/'.G5_SKIN_DIR.'/latest/'.$skin_dir;
} else {
$latest_skin_path = G5_SKIN_PATH.'/latest/'.$skin_dir;
$latest_skin_url = G5_SKIN_URL.'/latest/'.$skin_dir;
}
}

$c= implode("_", $bo_tableobj);

$cache_fwrite = false;
if(G5_USE_CACHE) {
$cache_file = G5_DATA_PATH."/cache/latest-{$fboard}-{$skin_dir}-{$rows}-{$subject_len}.php";

if(!file_exists($cache_file)) {
$cache_fwrite = true;
} else {
if($cache_time > 0) {
$filetime = filemtime($cache_file);
if($filetime && $filetime < (G5_SERVER_TIME - 3600 * $cache_time)) {
@unlink($cache_file);
$cache_fwrite = true;
}
}

if(!$cache_fwrite)
include($cache_file);
}
}

if(!G5_USE_CACHE || $cache_fwrite) {
$list = array();

$arrboard = implode("','", $bo_tableobj);

$sql = " select * from {$g5['board_new_table']} where bo_table in ('{$arrboard}') and wr_id = wr_parent order by bn_datetime desc limit 0, {$rows}";
$bres = sql_query($sql);
$bo_subject = get_text($subject);

for($i=0; $brow = sql_fetch_array( $bres ); $i++ ){
$tmp_write_table = $g5['write_prefix'] . $brow['bo_table']; // 게시판 테이블 전체이름
$sql = " select * from {$tmp_write_table} where wr_id = '{$brow['wr_id']}' ";
$row = sql_fetch( $sql );
$list[$i] = get_list($row, $brow['bo_table'], $latest_skin_url, $subject_len);
}

if($cache_fwrite) {
$handle = fopen($cache_file, 'w');
$cache_content = "<?php\nif (!defined('_GNUBOARD_')) exit;\n\$bo_subject='".$bo_subject."';\n\$list=".var_export($list, true)."?>";
fwrite($handle, $cache_content);
fclose($handle);
}
}

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

return $content;
}
?>