2 and site='.$s; if ($my['uid']) $postque .= ' and display > 3'; // 회원공개와 전체공개 포스트 출력 else $postque .= ' and display = 5'; // 전체공개 포스트만 출력 if ($sort == 'gid' && !$keyword) { $TCD = getDbArray($table['postmember'],$postque,'*',$sort,$orderby,$recnum,$p); while($_R = db_fetch_array($TCD)) $RCD[] = getDbData($table['postdata'],'gid='.$_R['gid'],'*'); $NUM = getDbRows($table['postmember'],$postque); } else { if ($where && $keyword) { if (strstr('[name][nic][id][ip]',$where)) $postque .= " and ".$where."='".$keyword."'"; else if ($where == 'term') $postque .= " and d_regis like '".$keyword."%'"; else $postque .= getSearchSql($where,$keyword,$ikeyword,'or'); } $orderby = 'desc'; $NUM = getDbRows($table['postdata'],$postque); $TCD = getDbArray($table['postdata'],$postque,'*',$sort,$orderby,$recnum,$p); while($_R = db_fetch_array($TCD)) $RCD[] = $_R; } $TPG = getTotalPage($NUM,$recnum); switch ($sort) { case 'gid' : $sort_txt='생성순';break; case 'hit' : $sort_txt='조회순';break; case 'likes' : $sort_txt='추천순';break; case 'comment' : $sort_txt='댓글순';break; default : $sort_txt='최신순';break; } $postList = ''; if ($NUM) { foreach ($RCD as $POST) { $comment = $POST['comment'].($POST['oneline']?'+'.$POST['oneline']:''); $_comment = $comment==0?'':$comment; $TMPL['post_uid']=$POST['uid']; $TMPL['post_cid']=$POST['cid']; $TMPL['post_format']=$POST['format']; $TMPL['post_subject']=getContents($POST['subject'],$R['html']); $TMPL['post_has_content']=$POST['content']?'d-block':'d-none'; $TMPL['post_featured_1by1'] = getPreviewResize(getUpImageSrc($POST),'640x640'); $TMPL['post_featured_1by1_sm'] = getPreviewResize(getUpImageSrc($POST),'320x320'); $TMPL['post_has_featured'] = $POST['featured_img']?'':'d-none'; $TMPL['post_provider']=getFeaturedimgMeta($POST,'provider'); $TMPL['post_videoId']=getFeaturedimgMeta($POST,'provider')=='YouTube'?getFeaturedimgMeta($POST,'name'):''; $TMPL['post_hit']=$POST['hit']; $TMPL['post_likes']=$POST['likes']; $TMPL['post_dislikes']=$POST['dislikes']; $TMPL['post_comment']=$_comment; $TMPL['post_d_modify'] = getDateFormat($POST['d_modify']?$POST['d_modify']:$POST['d_regis'],'c'); $TMPL['post_nic'] = getProfileInfo($POST['mbruid'],'nic'); $TMPL['post_time'] = getUpImageTime($POST); $TMPL['post_avatar'] = getAvatarSrc($POST['mbruid'],'68'); $TMPL['post_profile_url']=getProfileLink($POST['mbruid']); $TMPL['post_mbruid']=$POST['mbruid']; $check_like_qry = "mbruid='".$_mbruid."' and module='post' and entry='".$POST['uid']."' and opinion='like'"; $check_dislike_qry = "mbruid='".$_mbruid."' and module='post' and entry='".$POST['uid']."' and opinion='dislike'"; $check_saved_qry = "mbruid='".$_mbruid."' and module='post' and entry='".$POST['uid']."'"; $is_post_liked = getDbRows($table['s_opinion'],$check_like_qry); $is_post_disliked = getDbRows($table['s_opinion'],$check_dislike_qry); $is_post_saved = getDbRows($table['s_saved'],$check_saved_qry); $TMPL['is_post_liked'] = $is_post_liked?'active':''; $TMPL['is_post_disliked'] = $is_post_disliked?'active':''; $TMPL['is_post_saved'] = $is_post_saved?'true':'false'; $skin_postList=new skin('_commList'); $postList.=$skin_postList->make(); } } else { $TMPL['none_txt'] = '게시된 포스트가 없습니다.'; $skin_postList=new skin('_none'); $postList.=$skin_postList->make(); } $result['list']=$postList; $result['num']=$NUM; echo json_encode($result); exit; ?>