21'C 흐림
서울 강남구
1. /lib/common.lib.php get_group_select() 아래 또는 /adm/admin.lib.php 하단에 아래 함수 추가
// 게시판을 SELECT 형식으로 얻음
function get_board_select($name, $selected='', $event='', $gr_id="")
{
global $g5, $is_admin, $member;
if ($gr_id) $gr_id=" AND gr_id='".$gr_id."' ";
$sql = " SELECT bo_table, bo_subject from ".$g5['board_table']." WHERE 1 ".$gr_id." AND bo_table <> 'mailer' ";
$sql .= " ORDER BY bo_table ";
$result = sql_query($sql);
$str = "<select name='".$name."' id='".$name."' ".$event.">";
$str .= "<option value=''> ::: 전체게시판 ::: </option>";
for ($i=0; $row=sql_fetch_array($result); $i++) {
$str .= "<option value='".$row['bo_table']."'";
if ($row['bo_table'] == $selected) $str .= " selected";
$str .= ">".$row['bo_subject']."</option>";
}
$str .= "</select>";
return $str;
}
<tr>
<th scope="row"><label for="cf_add_bo_table">원본 테이블명</label></th>
<td colspan="3">
<?php echo get_group_select("cf_add_gr_id", $config['cf_add_gr_id'], " onchange="caname(this.value)""); ?>
<?php echo get_board_select("cf_add_bo_table", $config['cf_add_bo_table'], "", $config['cf_add_gr_id']);?>
<a href="<?php echo G5_BBS_URL; ?>/board.php?bo_table=<?php echo $config['cf_add_bo_table'];?>" target="_blank" class="btn_frmline">게시판확인</a>
</td>
</tr>
<script type="text/javascript">
function caname(gr_id, bo_table) {
$.ajax({
type: 'POST',
url: 'ajax.bo_table.php',
data: {
"gr_id" : gr_id
},
dataType: "json",
success: function(data) {
$("#cf_add_bo_table").html(data.option);
}
});
}
</script>
<?php
include_once('./_common.php');
include_once(G5_LIB_PATH.'/json.lib.php');
if ($gr_id) $gr_id=" AND gr_id='".$gr_id."' ";
$sql = " SELECT bo_table, bo_subject from ".$g5['board_table']." WHERE 1 ".$gr_id." AND bo_table <> 'mailer' ";
$sql .= " ORDER BY bo_table ";
$result = sql_query($sql);
$option .= "<option value=''> ::: 전체게시판 ::: </option>";
for ($i=0; $row=sql_fetch_array($result); $i++) {
$option .= "<option value='".$row['bo_table']."'";
if ($row['bo_table'] == $selected) $str .= " selected";
$option .= ">".$row['bo_subject']."</option>";
}
if($i == 0){
$option = '<option value="">---게시판없음---</option>';
}
die(json_encode(array('option'=>$option)));
?>