//========================================
// dehead(config/function/lib) Include
//========================================
include $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php";
//========================================
// Meta Tag
//========================================
$metaTitle = $metaInfo['nbeaf']['title'];
$metaDescription = $metaInfo['nbeaf']['description'];
$metaKeyword = $metaInfo['nbeaf']['keyword'];
$metaImage = $metaInfo['nbeaf']['image'];
//========================================
// Class Connect
//========================================
$Db = new Db(); // 데이터 베이스 클래스
//========================================
// Data Process
//========================================
$rowCount = $pageInfo['photo']['rowCount']; // 한 페이지에 보여질 게시물 수
$startNum = ($page - 1) * $rowCount; // limit 시작 위치
$param = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N);
//========================================
// Search Query
//========================================
if($st){
$param['tag'] = $Db->likeify($st);
$searchINS .= " AND tag LIKE :tag";
}
$addPath = "&st=".urlencode($st);
//========================================
// Data Load
//========================================
$totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_PHOTO WHERE no > :no AND d_show = :show AND del = :del AND reg_date < now() $searchINS", $param);
$totalPages = ceil($totalCount / $rowCount);
if($st){
if($st == '강남점' or
$st == '삼성점' or
$st == '노원점' or
$st == '종로점' or
$st == '일산점'
){
$b_bestINS = "A.b_best DESC,";
}
}
$param = array_merge($param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2, 'startNum' => $startNum, 'rowCount' => $rowCount));
$list = $Db->query("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date,
B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1,
C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2
FROM $TABLE_PHOTO A
LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq
LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq
WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.reg_date < now() $searchINS ORDER BY $b_bestINS A.reg_date DESC, A.no DESC LIMIT :startNum, :rowCount", $param);
$keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "A")));
$Db->CloseConnection;
//========================================
// 2019-11-13
//========================================
if($_GET['etc2']){
$etc2 = $_GET['etc2'];
}else{
$etc2 = 1;
}
/*
$epirel = $Db->row("SELECT * FROM 2019_epilogue_relate WHERE self_view = '".$_GET['no']."'");
$beaf_param = array('show' => PARAMETER_Y, 'del' => PARAMETER_N);
if($epirel['self_view']){
$ep1 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'A' AND d_show = :show AND del = :del AND no = '".$epirel['self_view']."'", $beaf_param);
}
if($epirel['real_view']){
$ep2 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'B' AND d_show = :show AND del = :del AND no = '".$epirel['real_view']."'", $beaf_param);
}
$beaf_param = array_merge($beaf_param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2));
*/
/*if($epirel['beaf']){
$beaf = $Db->row("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date, A.etc1,
B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1,
C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2
FROM $TABLE_PHOTO A
LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq
LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq
WHERE A.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf']."", $beaf_param);
}
if($epirel['beaf2']){
$beaf2 = $Db->row("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date, A.etc1,
B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1,
C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2
FROM $TABLE_PHOTO A
LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq
LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq
WHERE A.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf2']."", $beaf_param);
}*/
/*
preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches);
preg_match_all("/
]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2);
*/
//========================================
// header Include
//========================================
include PATH_INCLUDE."header.php";
//========================================
// SNS Auth
//========================================
require PATH_LIB."naverLogin.php";
require PATH_LIB."kakaoLogin2.php";
require PATH_LIB."googleLogin.php";
require PATH_LIB."facebookLogin.php";
$gogoUrl='beaf/'.$page;
$naver = new Naver(array(
"CLIENT_ID" => NAVER_LOGIN_ID, // (*필수)클라이언트 ID
"CLIENT_SECRET" => NAVER_LOGIN_SECRET, // (*필수)클라이언트 시크릿
"RETURN_URL" => NAVER_LOGIN_REDIRECT_URL, // (*필수)콜백 URL
"AUTO_CLOSE" => true, // 인증 완료후 팝업 자동으로 닫힘 여부 설정 (추가 정보 기재등 추가행동 필요시 false 설정 후 추가)
"SHOW_LOGOUT" => false // 인증 후에 네이버 로그아웃 버튼 표시/ 또는 표시안함
)
);
$kakao = new Kakao(array(
"Rcode" => $returnCode,
"CLIENT_ID" => KAKAO_CLIENT_ID, // (*필수)클라이언트 ID
"RETURN_URL" => KAKAO_CALLBACK_URL,
"AUTO_CLOSE" => true, // 인증 완료후 팝업 자동으로 닫힘 여부 설정 (추가 정보 기재등 추가행동 필요시 false 설정 후 추가)
"SHOW_LOGOUT" => false // 인증 후에 네이버 로그아웃 버튼 표시/ 또는 표시안함
)
);
?>
SNS 계정으로 간편하게 회원가입/로그인하세요.
탈퇴가 자유로우니 부담 갖지 마세요.