//======================================== // 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 계정으로 간편하게 회원가입/로그인하세요.
탈퇴가 자유로우니 부담 갖지 마세요.