write.skin.php

		
            분류필수
            
                
                    선택하세요
                    
                
				
                    선택하세요
                
            
        

		

bbs/list.php, bbs/view.php, bbs/write.php

		
    for ($i=0; $i0) {
			$category_option_mid.="
";
			foreach($aCategory2 as $v) {
				$v = trim($v);
				$category_option_class = "";
				if($_REQUEST['wr_10']===$v) {
					$category_option_class=' id="bo_subcate_on"';
				}
				$category_option_mid.='
'.$v.'
';
			}
			$category_option_mid.="
";
		}
		// 추가

        $category_option .= '
'.$category_option_mid.'
';
    }

		
if ($board['bo_use_category']) {
    $ca_name = "";
    if (isset($write['ca_name']))
        $ca_name = $write['ca_name'];
    $category_option = get_category_option($bo_table, $ca_name);
    $is_category = true;

	$category_jsons = json_encode(get_category_array($bo_table, $ca_name));
}

		
    if ($search_ca_name)
        $str = " ca_name = '$search_ca_name' ";

    if ($_REQUEST['wr_10']) {
        $str .= " and wr_10 = '{$_REQUEST['wr_10']}' ";
	}

		
function get_category_option($bo_table='', $ca_name='')
{
    global $g5, $board, $is_admin;

    $categories = explode("|", $board['bo_category_list'].($is_admin?"|공지":"")); // 구분자가 , 로 되어 있음
    $str = "";
    for ($i=0; $i

 
#!/home/php/bin/php -q
<?
$document_root = "XE 홈 절대 경로";

/* XE Module */
define('__ZBXE__', true);
require_once($document_root."/config/config.inc.php");
$oContext = &Context::getInstance();
$oContext->init();
$oDB =&DB::getInstance();


/*XE Module */

ini_set('display_errors', 1);

if(!$argv[1] || !$argv[2]){ 
	echo ">>> 게시물 복사(확장변수포함)\n";
	echo "usage : migration 소스모듈번호 대상모듈번호";
	echo "\n";
}

	// xe 함수 /modules/document/document.admin.controller.php
	$admDocument = &getAdminController('document');

	// 강제 로그인 처리 insert시에 에러가남;
	$oMemberModel = &getModel('member');
	$memberInfo = $oMemberModel->getMemberInfoByUserID('xe 관리자 아이디');
	Context::set('logged_info', $memberInfo);

	$sour_module_srl = $argv[1];
	$dest_module_srl = $argv[2];

	$query = "
		select document_srl from xe_documents a
		where  a.module_srl='{$sour_module_srl}'		
		order by a.document_srl asc
	";

	$rs1 = mysql_query($query);
	echo "총 게시물 수 : ";
	echo $rows = mysql_num_rows($rs1);
	echo "\n";

	while($row = mysql_fetch_array($rs1)){
		$output = $admDocument->copyDocumentModule(array($row['document_srl']), $dest_module_srl, 0);

		// copy to eid
		foreach( $output->variables['copied_srls'] as $k=>$v) {
			
			echo ">> copy --- ". $k ." => ". $v . "\n";

			$query = "insert into xe_document_extra_vars (module_srl,document_srl,var_idx,lang_code,value,eid)
			(SELECT '{$dest_module_srl}','{$v}',var_idx,lang_code,value,eid FROM xe_document_extra_vars WHERE module_srl='{$k}')";

			// 확장 변수 카피
			$query = " 
				update xe_document_extra_vars a, xe_document_extra_vars b
				set 
					a.lang_code=b.lang_code,
					a.value=b.value,
					a.eid=b.eid
				where
					a.eid=b.eid
					and a.document_srl='{$v}'
					and b.document_srl='{$k}'
			";
			mysql_query($query);

			// 추가 변수 갱신 구 document_srl
			$query = " 
				update xe_document_extra_vars
				set 
					value='{$k}'
				where
					document_srl='{$v}'
					and eid='document_srl'
			";
			mysql_query($query);

			// 등록,수정 일자 카피
			$query = " 
				update xe_documents a, xe_documents b
				set 
					a.regdate=b.regdate,
					a.last_update=b.last_update
				where
					a.document_srl='{$v}'
					and b.document_srl='{$k}'
			";
			mysql_query($query);
		}
	}
?>