$no); //======================================== // Data Load //======================================== $view = $Db->row("SELECT no, sort, best, store, insert_date, name, title, content, likes, hit, tag, etc1 FROM $TABLE_EPILOGUE WHERE no = :no", $param); // $keyword = array_filter(explode("|", $Db->single("SELECT keyword2 FROM $TABLE_KEYWORD"))); $no = $view['no']; $sort = $view['sort']; $bestClass = ($view['best'] === "Y") ? "best" : ""; $store = $storeNameArr[$view['store']]; $storeColor = StoreColorClass($view['store']); $insert_date = $view['insert_date']; $name = Utf8SubstrReplace(stripslashes($view['name']), "o"); $title = stripslashes($view['title']); $content = stripslashes($view['content']); $likes = $view['likes']; $hit = $view['hit']; $temp_tag = explode(",", stripslashes($view['tag'])); $tag = implode(",", array_filter($temp_tag)); $etc1 = $view['etc1']; $pnparam = array('sort' => $sort, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'best' => $view['best']); if($sd === "likes"){ $pnparam['likes'] = $likes; $prevINS .= "likes > :likes"; $nextINS .= "likes < :likes"; $prevOrderINS .= "likes ASC"; $nextOrderINS .= "likes DESC"; } else if($sd === "hit"){ $pnparam['hit'] = $hit; $prevINS .= "hit > :hit"; $nextINS .= "hit < :hit"; $prevOrderINS .= "hit ASC"; $nextOrderINS .= "hit DESC"; } else { $pnparam['insert_date'] = $insert_date; $prevINS .= "insert_date > :insert_date"; $nextINS .= "insert_date < :insert_date"; $prevOrderINS .= "insert_date ASC"; $nextOrderINS .= "insert_date DESC"; } $prev = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $prevINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $prevOrderINS LIMIT 0, 1", $pnparam); $next = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $nextINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $nextOrderINS LIMIT 0, 1", $pnparam); if($prev > 0){ $prevTitle = "[".$storeNameArr[$prev['store']]."]".stripslashes($prev['title']); $prevLink = "#".$prev['no']; } else { $prevTitle = "이전글이 없습니다."; $prevLink = "#self"; } if($next > 0){ $nextTitle = "[".$storeNameArr[$next['store']]."]".stripslashes($next['title']); $nextLink = "#".$next['no']; } else { $nextTitle = "다음글이 없습니다."; $nextLink = "#self"; } // if($_SERVER['REMOTE_ADDR'] == "112.222.190.202"){ // debug($insert_date); // debug($pnparam); // } //======================================== // Hit Update //======================================== if(!$_COOKIE["HIT::".$TABLE_EPILOGUE."_".$no]){ $hitPlus = $hit + 1; $hitUp = $Db->query("UPDATE $TABLE_EPILOGUE SET hit = :hit WHERE no = :no", array('hit' => $hitPlus, 'no' => $no)); setcookie("HIT::".$TABLE_EPILOGUE."_".$no, time()+(60*60*24)); } $Db->CloseConnection; //======================================== // 2019-11-13 //======================================== $epirel = $Db->row("SELECT * FROM 2019_epilogue_relate WHERE del = 'N' AND real_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); } $epirel_name = Utf8SubstrReplace(stripslashes($epirel['name']), "o"); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches); preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2); //======================================== // Meta Tag //======================================== $metaTitle = $title; $metaTitle2 = $title; $metaDescription = StrCut(strip_tags($content), 0, 100); $metaKeyword = $tag; $metaImg = explode('src=',$content); $metaImg = explode('>',$metaImg[1]); $metaImg = explode(' ',$metaImg[0]); $metaImg = str_replace('"','',$metaImg[0]); if(!preg_match('#ssdream.co.kr#',$metaImg)){ $metaImg = "http://www.ssdream.co.kr".$metaImg; } //$path = "./img/"; //$dir = opendir($path); $tmpno = "2210"; if($no == $tmpno){ $metaImg = "http://www.ssdream.co.kr/front/epilogue/img/".$no.".jpg"; } $metaImage = $metaImg; $metaNav = $metaInfo['real_list_'.$sort]['nav']; //======================================== // header Include //======================================== include PATH_INCLUDE."header.php"; //======================================== // Page Auth //======================================== //if(MobileCheck() == "Desktop"){ // 일단 없애봄 170703 // 2020-03-13 검색엔진은 통과시키기 // 2020-05-25 header까지는 나오게하기 if( preg_match('#Yeti#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#Googlebot#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#GoogleDocs#',$_SERVER['HTTP_USER_AGENT']) ){ }else{ //echo $_SERVER['HTTP_USER_AGENT']; $prevPage = $_SERVER['HTTP_REFERER']; if(strstr($prevPage, 'youtube.com')||strstr($prevPage, 'googleadservices.com')||strstr($prevPage, 'googleads.g.doubleclick.net')) { $prev_ad = 'youtube'; } if($prev_ad == 'youtube'){ }else{ AuthCheck2($_SESSION['MEMBER_LOGIN_EXIST'],$_GET['no']); } } ?>
HOME  >  ".$metaNav[4]."  > "; } if($metaNav[3]){ echo "".$metaNav[3]."  > "; } if($metaNav[2]){ echo "".$metaNav[2]."  > "; } if($metaNav[1]){ echo "".$metaNav[1]."  > "; } echo "".$metaNav[0].""; ?>

작성자 등록일 조회
PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'sort' => $sort); //======================================== // Search Query //======================================== if($sk){ if($sf){ $param2['keyword'] = $Db->likeify($sk); } else { $param2 = array_merge($param2, array( 'keyword_title' => $Db->likeify($sk), 'keyword_content' => $Db->likeify($sk), 'keyword_tag' => $Db->likeify($sk), )); } $metaTitle2 = $sk." 검색결과"; $searchINS .= ($sf) ? " AND A.$sf LIKE :keyword" : " AND (A.title LIKE :keyword_title AND A.content LIKE :keyword_content AND A.tag LIKE :keyword_tag)"; } //$categoryArr = array('A' => "비중격만곡증", 'B' => "비염", 'C' => "축농증", 'D' => "코성형", 'E' => "코뼈골절"); // Config $nTagArr=array('비중격만곡증','비염','축농증','비밸브','코질환재수술');//코질환 태그들 $mTagArr=array('코성형','코성형재수술','코뼈골절','휜코','짧은코','낮은코','매부리코','화살코','안장코','처진코끝','복코','넓은콧등','구축코','긴코'.'들창코','콧볼축소');//코성형 태그들 if($st){ if($st=='N'){ //코질환 태그 for($nt=0; $ntlikeify($nTagArr[$nt]); if($nt==0){ $searchINS .= " AND ("; }else{ $searchINS .= " OR "; } $searchINS .= "A.tag LIKE '%".$value."%'"; if($nt==(count($nTagArr)-1)){ $searchINS .= ")"; } } //코성형 태그 빼기 for($mt=0; $mtlikeify($mTagArr[$mt]); if($mt==0){ $searchINS .= " AND ("; }else{ $searchINS .= " AND "; } $searchINS .= "A.tag NOT LIKE '%".$value."%'"; if($mt==(count($mTagArr)-1)){ $searchINS .= ")"; } } }else if($st=='M'){ //코성형 태그하나라도 있을시에! for($mt=0; $mtlikeify($mTagArr[$mt]); if($mt==0){ $searchINS .= " AND ("; }else{ $searchINS .= " OR "; } $searchINS .= "A.tag LIKE '%".$value."%'"; if($mt==(count($mTagArr)-1)){ $searchINS .= ")"; } } }else{ $param2['tag'] = $Db->likeify($st); $searchINS .= " AND A.tag LIKE :tag"; } if($st == 'N'){ $metaTitle2 = "코질환 검색결과"; }else if($st == 'M'){ $metaTitle2 = "코성형 검색결과"; }else{ $metaTitle2 = $st." 검색결과"; } } //$metaTitle2 = $metaTitle2." ".$page; if($sb){ $param2['best'] = $sb; $searchINS .= " AND A.best = :best"; $typeALink = "#sb="; $typeBLink = "#self"; } else { $typeALink = "#self"; $typeBLink = "#sb=Y"; } if($sct){ if($sct == 1) $searchINS .= " AND ( A.no = 2446 OR A.no = 2188 )"; else if($sct == 2) $searchINS .= " AND ( A.no = 2395 OR A.no = 1979 OR A.no = 2357)"; } $orderINS .= ($sd) ? "A.$sd DESC" : "A.insert_date DESC"; $addPath = "&no=$no&sort=$sort&sd=$sd&st=$st&sf=$sf&sk=$sk&sb=$sb"; $searchStore = "AND A.store = '".$view['store']."'"; $totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_EPILOGUE A WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.sort = :sort $searchStore $searchINS", $param2); $totalPages = ceil($totalCount / $rowCount); echo ""; $param2 = array_merge($param2, array('code' => "epilogue", 'seq' => PARAMETER_ONE, 'startNum' => $startNum, 'rowCount' => $rowCount)); $list = $Db->query("SELECT A.no, A.store, A.best, A.insert_date, A.name, A.title, A.likes, A.hit, B.attach, B.attach_ori, B.mod_date FROM $TABLE_EPILOGUE A LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :code AND B.seq = :seq WHERE A.no > :no AND A.d_show = :show AND A.del = :del AND A.sort = :sort $searchStore $searchINS ORDER BY A.best ASC, $orderINS LIMIT :startNum, :rowCount", $param2); $code = ($sort === "B") ? "C" : "D"; $keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => $code))); ?>
0) Pageing($totalPages, $blockCount, $page, $addPath); ?>

수술후기 모아보기

    $val){ ?>
님의 리얼후기영상 보기
님의 자필후기 보기
님의 전후사진 보기
  • /'>

    코성형 전후사진 aaa

    수술후 3개월

    /'>
  • /'>

    코성형 전후사진 aaa

    수술후 3개월

    /'>