경로
function getMenuCodeToPathPost($table,$cat,$j)
{
global $DB_CONNECT;
static $arr;
$R=getUidData($table,$cat);
if($R['parent'])
{
$arr[$j]['uid'] = $R['uid'];
$arr[$j]['id'] = $R['id'];
$arr[$j]['name']= $R['name'];
getMenuCodeToPathPost($table,$R['parent'],$j+1);
}
else {
$C=getUidData($table,$cat);
$arr[$j]['uid'] = $C['uid'];
$arr[$j]['id'] = $C['id'];
$arr[$j]['name']= $C['name'];
}
sort($arr);
reset($arr);
return $arr;
}
//메뉴코드->SQL
function getMenuCodeToSqlPost($table,$cat,$f)
{
static $sql;
$R=getUidData($table,$cat);
if ($R['uid']) $sql .= $f.'='.$R['uid'].' or ';
if ($R['isson'])
{
$RDATA=getDbSelect($table,'parent='.$R['uid'],'uid');
while($C=db_fetch_array($RDATA)) getMenuCodeToSqlPost($table,$C['uid'],$f);
}
return substr($sql,0,strlen($sql)-4);
}
function getMenuCodeToSqlPost1($tbl,$cat,$Post,$sql)
{
global $sql;
$R=getUidData($tbl,$cat);
if(!strstr($sql,'['.$R['uid'].']')) $sql = $sql.'['.$R['uid'].']';
if($R['parent'])
{
$C=getUidData($tbl,$R['parent']);
if(!strstr($sql,'['.$C['uid'].']')) $sql = $sql.'['.$C['uid'].']';
getMenuCodeToSqlPost1($tbl,$C['uid'],$Post,$sql);
}
return $sql;
}
function getMenuCodeToSqlPost2($tbl,$cat,$Post,$sql)
{
global $sql;
$R=getUidData($tbl,$cat);
if(!strstr($sql,'['.$R['uid'].']')) $sql = $sql.'['.$R['uid'].']';
if($R['isson'])
{
$RDATA=getDbSelect($tbl,'Post='.$Post.' and parent='.$R['uid'],'uid');
while($C=db_fetch_array($RDATA))
{
if(!strstr($sql,'['.$C['uid'].']')) $sql = $sql.'['.$C['uid'].']';
getMenuCodeToSqlPost2($tbl,$C['uid'],$Post,$sql);
}
}
return $sql;
}
//트리(@ 2.0.0)
function getTreeCategory($conf,$code,$depth,$parent,$tmpcode)
{
$ctype = $conf['ctype']?$conf['ctype']:'uid';
$id = 'tree_'.filterstr(microtime());
$tree = '';
return $tree;
}
//트리 카테고리 - write_plus 전용
function getTreeCategoryForWrite($conf,$code,$depth,$parent,$tmpcode)
{
global $m,$table;
$ctype = $conf['ctype']?$conf['ctype']:'uid';
$id = 'tree_'.filterstr(microtime());
$tree = '';
$CD=getDbSelect($table[$m.'category'],($conf['Post']?'Post='.$conf['Post'].' and ':'').'depth='.($depth+1).' and parent='.$parent.($conf['dispHidden']?' and hidden=0':'').($conf['mobile']?' and mobile=1':'').' order by gid asc','*');
$_i = 0;
while($C=db_fetch_array($CD))
{
$rcode= $tmpcode?$tmpcode.'/'.$C[$ctype]:$C[$ctype];
$t_arr = explode('/', $code);
$t1_arr = explode('/', $rcode);
$topen= in_array($t1_arr[count($t1_arr)-1], $t_arr)?true:false;
$cat_link=$conf['link']?$conf['link'].$C['uid']:'#'; // 링크는 있는 경우에만
$NUM=getDbRows($table[$m.'category'],'parent='.$C['uid']);
// $dispNum=''.$NUM.'';
$is_selected=getDbRows($table[$m.'catidx'],'Post='.$conf['Post'].' and post='.$conf['post'].' and category='.$C['uid']);
$catCheckbox='';
$tree.= '- ';
if ($C['isson'])
{
$tree.=$code;
$tree.= '';
$tree.= '';
if($conf['dispCheckbox']) $tree.= $catCheckbox;
$tree.= $C['name'];
$tree.='';
if($conf['dispNum']) $tree.=$dispNum;
$tree.= '
';
$tree.= getTreeCategoryForWrite($conf,$code,$C['depth'],$C['uid'],$rcode);
$tree.= '
';
}
else {
$tree.= '';
$tree.= '';
if($conf['dispCheckbox']) $tree.= $catCheckbox;
$tree.= $C['name'];
$tree.='';
if($conf['dispNum']) $tree.=$dispNum;
}
$tree.= ' ';
$_i++;
}
$tree.= '
';
}else if($mod=='hold'){
$title='['.$_HS['name'].'] 사이트에 등록된 포스트가 발행보류 처리되었습니다. ';
$content='아래와 같이 '.$RM[$_HS['nametype']].'님이 등록한 포스트가 발행보류 처리되었습니다.
';
}else if($mod=='publish'){
$title='['.$_HS['name'].'] 사이트에 등록된 포스트가 발행 처리되었습니다. ';
$content='아래와 같이 '.$RM[$_HS['nametype']].'님이 등록한 포스트가 발행 처리되었습니다.
';
}
// content 내용에 링크 추가
$content .=''.$link.'';
getSendMail($to_email.'|'.$to_name, $from_email.'|'.$from_name,$title, $content, 'HTML');
}
// 포스트 위젯에서 사용되는 base 쿼리 정의
function getPostBaseQry($m)
{
global $table,$s;
return $table[$m.'data'].'.isreserve=0 and '.$table[$m.'data'].'.step=3';
}
// 포스트 데이타 추출 함수
function getPostData($R,$data)
{
global $g,$table,$r,$_HS,$d;
$m='Post';
include_once $g['path_module'].$m.'/var/var.php';
$result=array();
$B=getUidData($table[$m.'list'],$R['Post']);
if($d['Post']['rewrite']) $result['link']=$g['s'].($r?'/'.$r:'').'/archive/'.$B['id'].'/';
else $result['link'] = $g['s'].'/?r='.$r.'&m='.$m.'&Post='.$B['id'].'&front=list&uid=';
if($R['isphoto']&&$R['upload'])
{
$upArray = getArrayString($R['upload']);
$_U = getUidData($table['s_upload'],$upArray['data'][0]);
$img = $_U['url'].$_U['folder'].'/'.$_U['tmpname'];
}
$img_arr=getImgs($R['content'],'jpg');
$result['preview_img']=$img_arr[0]?$img_arr[0]:'';
// 회원정보 세팅
$M=getDbData($table['s_mbrdata'],'memberuid='.$R['mbruid'],'*');
$M2=getDbData($table['s_mbrid'],'uid='.$R['mbruid'],'*');
// 회원이름
$result['mbr_name']=$M[$_HS['nametype']];
// 회원 아이디
$result['mbr_id']=$M2['id'];
// 아바타 사진 url 세팅
if($M['photo']) $result['avatar_img']=$g['url_root'].'/_var/avatar/'.$M['photo'];
else $result['avatar_img']=$g['url_root'].'/_var/avatar/0.gif';
return $result[$data];
}
// 권기택 추가
//분류코드->SQL
function getPostCategoryCodeToSql($table,$cat)
{
$R=getUidData($table,$cat);
if ($R['uid']) $sql .= 'category='.$R['uid'].' or ';
if ($R['isson'])
{
$RDATA=getDbSelect($table,'parent='.$R['uid'],'uid,isson');
while($C=db_fetch_array($RDATA)) $sql .= getPostCategoryCodeToSqlX($table,$C['uid'],$C['isson']);
}
return substr($sql,0,strlen($sql)-4);
}
//분류코드->SQL
function getPostCategoryCodeToSqlX($table,$cat,$isson)
{
$sql = 'category='.$cat.' or ';
if ($isson)
{
$RDATA=getDbSelect($table,'parent='.$cat,'uid,isson');
while($C=db_fetch_array($RDATA)) $sql .= getPostCategoryCodeToSqlX($table,$C['uid'],$C['isson']);
}
return $sql;
}
// daum 송고용 채널명 추출함수
function getDaumChannel($post){
global $table,$DB_CONNECT;
$tbl_idx = $table['Postcatidx'];
$tbl_cat = $table['Postcategory'];
$query="SELECT i.*,c.* FROM ".$tbl_idx." as i left join ".$tbl_cat." as c on i.category=c.uid
WHERE i.post=".$post." and c.hidden=0 and c.daum_cat<>''";
$result = db_fetch_array(db_query($query,$DB_CONNECT));
$channel = $result['daum_cat'];
return $channel;
}
?>