//========================================
// dehead(config/function/lib) Include
//========================================
include $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php";
function AuthCheck2($getSession,$contentnumber){
if(!$getSession){
//$utf8str = iconv("euc-kr", "utf-8", "../epilogue/real_view.php?no=".$contentnumber);
AlertMove("로그인 후 이용하실 수 있습니다.", "/front/member/login.php?returnUrl=self_view&no=".$contentnumber);
}
}
//}
//========================================
// Class Connect
//========================================
$Db = new Db(); // 데이터 베이스 클래스
//========================================
// Data Process
//========================================
$param = array('no' => $no);
//========================================
// Data Load
//========================================
$view = $Db->row("SELECT no, sort, best, store, insert_date, name, title, content, likes, hit, tag, etc2 FROM $TABLE_EPILOGUE WHERE no = :no", $param);
$keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "B")));
$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));
$etc2 = $view['etc2'];
$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";
}
//첫 이미지
$content_img = explode("src=\"",$content);
$content_img = explode("\"",$content_img[1]);
$content_img = $content_img[0];
//$imgPath = $content_img;
//$ext = array_pop(explode(".",strtolower($content_img)));
$parts = explode(".", strtolower($content_img));
$ext = array_pop($parts);
$save_path = "../../uploads/thumb/".$no.".".$ext;
if(!is_file($save_path)){
if(!preg_match('#http#',$content_img)){
$content_img = "https://www.ssdream.co.kr".$content_img;
}
if($ext == 'jpg'){
$ori_path = $content_img;
$ori_img = imagecreatefromjpeg($ori_path);
$info_img = getimagesize($ori_path);
$new_img = imagecreatetruecolor(100,100);
imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]);
imagejpeg($new_img,$save_path);
}else if($ext == 'png'){
$ori_path = $content_img;
$ori_img = imagecreatefrompng($ori_path);
$info_img = getimagesize($ori_path);
$new_img = imagecreatetruecolor(100,100);
imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]);
imagepng($new_img,$save_path);
}else if($ext == 'gif'){
$ori_path = $content_img;
$ori_img = imagecreatefromgif($ori_path);
$info_img = getimagesize($ori_path);
$new_img = imagecreatetruecolor(100,100);
imagecopyresampled($new_img,$ori_img,0,0,0,0,100,100,$info_img[0],$info_img[1]);
imagegif($new_img,$save_path);
}
}
$imgPath = "/uploads/thumb/".$no.".".$ext;
//========================================
// 2019-11-13
//========================================
if($_GET['etc2']){
$etc2 = $_GET['etc2'];
}else{
$etc2 = 1;
}
$epirel = $Db->row("SELECT * FROM 2019_epilogue_relate WHERE del = 'N' AND 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);
}
$epirel_name = Utf8SubstrReplace(stripslashes($epirel['name']), "o");
preg_match_all("/]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches);
preg_match_all("/
]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2);
/*$beaf_param = array('show' => PARAMETER_Y, 'del' => PARAMETER_N, 'etc2' => $etc2);
$ep1 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'A' AND d_show = :show AND del = :del AND etc2 = :etc2", $beaf_param);
$ep2 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'B' AND d_show = :show AND del = :del AND etc2 = :etc2", $beaf_param);
$beaf_param = array_merge($beaf_param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2));
$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.etc2 = :etc2", $beaf_param);
preg_match_all("/
]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches);
preg_match_all("/
]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2);
*/
//========================================
// 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;
//========================================
// Meta Tag
//========================================
$metaTitle = $title;
$metaTitle2 = $title;
$metaDescription = StrCut(strip_tags($content), 0, 100);
$metaKeyword = $tag;
$metaNav = $metaInfo['self_list']['nav'];
//========================================
// header Include
//========================================
include PATH_INCLUDE."header.php";
//========================================
// Page Auth
//========================================
//if(MobileCheck() == "Desktop"){
// 일단 없애봄 170703
// 2020-03-19 검색엔진은 통과시키기
// 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'];
AuthCheck2($_SESSION['MEMBER_LOGIN_EXIST'],$_GET['no']);
}
?>
'1', 'title' => 'a1b1.jpg', 'no' => '27'),
array('seq' => '2', 'title' => 'a1b2.jpg', 'no' => '1229'),
array('seq' => '3', 'title' => 'a1b3.jpg', 'no' => '1927')
);
$tmp2 = array(
array('seq' => '1', 'title' => '아들의 꿈을 지켜주셔서 감사해요!', 'no' => '2201'),
array('seq' => '2', 'title' => '딸이 원장님 이름 등에 붙이고 다니고 싶대요!', 'no' => '1816'),
array('seq' => '3', 'title' => '아들의 상황 이해해주셔서 너무 감사합니다.', 'no' => '724')
);
$tmp3 = array(
array('seq' => '1', 'title' => '남편, 이해해줘서 고마워요!', 'no' => '1426'),
array('seq' => '2', 'title' => '부부가 함께 받는 코수술 의지 됩니다.', 'no' => '1445'),
array('seq' => '3', 'title' => '코골이 해결 후 와이프가 좋아해요!', 'no' => '1140')
);
$tmp4 = array(
array('seq' => '1', 'title' => '코수술 후 인정받고 포상휴가도 많이 받았습니다!', 'no' => '2259'),
array('seq' => '2', 'title' => '군인분들 코수술 적극 추천합니다!', 'no' => '1723'),
array('seq' => '3', 'title' => '휴가 기간 중 코수술 만족 합니다!', 'no' => '2111')
);
?>



//=$beaf['no']?>
a=DateConv($beaf['reg_date'], 7);?>a=$beaf['reg_date']?>a수술후 3개월
//=$beaf2['no']?>
a=DateConv($beaf2['reg_date'], 7);?>a=$beaf2['reg_date']?>a수술후 3개월

