0) { for($i=0;$i 0) { for($i=0;$iquery($sql); $fdb->next_record(); $regdate = $fdb->f("regdate"); if($regdate < $bc_date) { $sql = "update info set hit = hit + 1 where idx = '".$idx."'"; $fdb->query($sql); $sql = "insert into board_view (b_idx, b_name, u_ip, regdate) values ('".$idx."', 'info', '".$_SERVER['REMOTE_ADDR']."', '".$today."')"; $fdb->query($sql); } $sql = "select * from info where idx = '".$idx."' and cate = '".$cate."'"; $fdb->query($sql); $fdb->next_record(); $iname = stripslashes($fdb->f("iname")); $brief = stripslashes($fdb->f("brief")); //$content = nl2br(stripslashes($fdb->f("content"))); $content = stripslashes($fdb->f("content")); //$content = autoLink(stripslashes($fdb->f("content"))); //$content = str_replace("

", "", $content); //$content = str_replace("

", "", $content); $tag = $fdb->f("tag"); $thumb_dir = $fdb->f("thumb_dir"); $thumb = $fdb->f("thumb"); $thumb_b = $fdb->f("thumb_b"); $thumb_o = $fdb->f("thumb_o"); $itype = $fdb->f("itype"); $inquire = $fdb->f("inquire"); $isite = $fdb->f("isite"); $option1 = $fdb->f("option1"); $option2 = $fdb->f("option2"); $option3 = $fdb->f("option3"); $hit = $fdb->f("hit"); $recom = $fdb->f("recom"); $reply = $fdb->f("reply"); $reg_ip = $fdb->f("reg_ip"); $member_uid = $fdb->f("member_uid"); $short_url = $fdb->f("short_url"); $regdate = date("Y-m-d", $fdb->f("regdate")); $moddate = "".date("Y-m-d", $fdb->f("regdate"))."".date("H:i:s", $fdb->f("regdate")).""; $term = round(($fdb->f("etime")-($fdb->f("stime")-86400)) / 86400, 0); if($cate == "food") { $stime = $fdb->f("stime"); $etime = $fdb->f("etime"); $sminute = $fdb->f("sminute"); $eminute = $fdb->f("eminute"); if($sminute == "0") { $stime = $stime.":00"; } else { $stime = $stime.":".$sminute; } if($eminute == "0") { $etime = $etime.":00"; } else { $etime = $etime.":".$eminute; } if($option1) { $etime = $etime." / 휴무 : ".$option1; } if($option3 == "1") { $parking = "주차불가"; } else if($option3 == "2") { $parking = "무료"; } else { $parking = "유료"; } if($option2) { $car_num = " (".$option2."대 가능)"; } $view_parking = $parking; } else { $stime = date("Y-m-d", $fdb->f("stime")) ."(".date("D", $fdb->f("stime")).")"; $etime = date("Y-m-d", $fdb->f("etime")) ."(".date("D", $fdb->f("etime")).")"; } if(!strstr(strtolower($isite), "http://")) { $isite = "http://".$isite; } if($cate == "festival") { $stime_chk = $fdb->f("stime") - (3600 * 23); if($stime_chk > $today) { $chkday = mktime(00,00,00,date(m), date(d), date(Y)); $remain_day = round(($stime_chk - $chkday) / (86400), 0) ."일전"; } else { $remain_day = "지난축제"; } } $itype_list = get_info_itype($cate, $itype); $view_thumb_b = get_thumb_info($thumb_dir.$thumb_b, 210); if($thumb_o) { $view_thumb = " $\"\"$ "; } else { $view_thumb = " $\"\"$ "; } // short_url을 가져온다. if(!$short_url || $short_url == "10b") { $current_url = "http://thefestival.co.kr".$_SERVER['REQUEST_URI']; $short_url = getShortURL($current_url); $sql = "update info set short_url = '".$short_url."' where idx = '".$idx."'"; $fdb->query($sql); } /// 주소 정보를 가져온다. $sql = "select * from info_addr where info_idx = '".$idx."'"; $fdb->query($sql); $fdb->next_record(); $addr = stripslashes($fdb->f("addr")); $detail_addr = $fdb->f("detail_addr"); $map_x = trim($fdb->f("map_x")); $map_y = trim($fdb->f("map_y")); $fest_area = $fdb->f("fest_area"); if($cate == "festival") { $sql = "select * from info_sub where info_idx = '".$idx."'"; $fdb->query($sql); while($fdb->next_record()) { $option1_sub = stripslashes($fdb->f("option1")); $option2_sub = stripslashes($fdb->f("option2")); $option3_sub = stripslashes($fdb->f("option3")); $view_sub .= " ".$option1_sub." ".$option2_sub." ".$option3_sub." "; } } else if($cate == "room") { $sql = "select * from info_sub where info_idx = '".$idx."'"; $fdb->query($sql); while($fdb->next_record()) { $option1_sub = stripslashes($fdb->f("option1")); $option2_sub = stripslashes($fdb->f("option2")); $option3_sub = stripslashes($fdb->f("option3")); $view_menu .= " ".$option1_sub." ".$option2_sub." 원 ".$option3_sub." 원 "; } } else if($cate == "food") { $sql = "select * from info_sub where info_idx = '".$idx."'"; $fdb->query($sql); while($fdb->next_record()) { $option1_sub = stripslashes($fdb->f("option1")); $option2_sub = number_format(stripslashes($fdb->f("option2"))); $view_menu .= " ".$option1_sub." ".$option2_sub." "; } } if(is_login()) { $sql = "select addr from member where uid = '".$_SESSION['MEM_USERID']."'"; $fdb->query($sql); $fdb->next_record(); $mem_addr = $fdb->f("addr"); $view_scrap_btn = "

"; } else { $view_scrap_btn = "

"; } ############################## 네티즌 평점 입력 ############################ $listnum = 10; //한페이지당 레코드수... $pagenum = 10; //한페이지당 리스트수... // 검색어 (강의명, 이름, 아이디) if($startpage =="" || $startpage<1) { $startpage=1; } else { } if($curpage == "" || $curpage<1) { $curpage = 1; } else { } $sql = "select idx from info_evel where info_idx = '".$idx."'"; $fdb->query($sql); $total = $fdb->nf(); if($total%$listnum == 0) { $totalpage = floor($total/$listnum); //totalpage... } else { $totalpage = floor($total/$listnum)+1; //totalpage... } if( $totalpage>0 && $curpage>$totalpage) { $curpage = $totalpage; } else { } $startpage = ((ceil($curpage/$pagenum)-1)*$pagenum)+1; //startpage... $start = ($curpage-1)*$listnum; if($curpage == "") { $curpage = "1"; } else {} if($total > 0) { $sql = "select * from info_evel where info_idx = '".$idx."' order by regdate desc limit ".$start.", ".$listnum; $fdb->query($sql); while($fdb->next_record()) { $tail_idx = $fdb->f("idx"); $tail_title = stripslashes($fdb->f("title")); $tail_contents = conv_content(nl2br(stripslashes($fdb->f("contents")))); $tail_grade = $fdb->f("grade"); $tail_member_uid = $fdb->f("member_uid"); $tail_regdate = date("Y-m-d" ,$fdb->f("regdate")); if($tail_member_uid == $_SESSION['MEM_USERID'] || $_SESSION['MEM_TYPE'] == "A") { $reply_mod_btn = "수정"; $reply_del_btn = "삭제"; $view_tail_menu = " $\"\"$ ".$tail_regdate." $\"\"$ ".$reply_mod_btn." $\"\"$ ".$reply_del_btn; } $view_tail_nick = get_mem_nick($tail_member_uid); $view_grade_star = get_avg_star($tail_grade); $view_tail_list .= "


".$view_grade_star."".$tail_grade."	".$tail_title."	".$view_tail_nick."".$view_tail_menu."

	".$tail_contents."

"; } } else { $view_tail_list .= " 등록된 네티즌 평점이 없습니다. "; } /// 트위터에 덧글 입력을 신청했는지 확인 $sql = "select * from member_twitter where member_uid = '".$_SESSION['MEM_USERID']."' "; $fdb->query($sql); $fdb->next_record(); $tw_oauth_token = $fdb->f("oauth_token"); $tw_oauth_token_secret = $fdb->f("oauth_token_secret"); $tw_isValid = $fdb->f("isValid"); if($tw_isValid == "y") { $twChk = "checked"; } /// 트위터에 덧글 입력을 신청했는지 확인 $sql = "select * from member_me2day where member_uid = '".$_SESSION['MEM_USERID']."'"; $fdb->query($sql); $fdb->next_record(); $me_user_id = $fdb->f("user_id"); $me_user_key = $fdb->f("user_key"); $me_isValid = $fdb->f("isValid"); if($me_isValid == "y") { $meChk = "checked"; } if($cate == "festival") { $view_br_title = "축제정보"; } else if($cate == "food") { $view_br_title = "맛집정보"; } else if($cate == "room") { $view_br_title = "숙박정보"; } else if($cate == "tour") { $view_br_title = "관광지정보"; } else if($cate == "prod") { $view_br_title = "특산물정보"; } make_html_head ($iname.' :: '.$view_br_title, '/css/festivalSearch.css'); ?>

날짜

행사명

시간

메뉴명

가격

객실

비수기(주중)

성수기(주말)

-1) { // chunk data $temp = ""; $offset = 0; do { $idx1 = strpos($mapbody, "\r\n", $offset); $chunkLength = hexdec(substr($mapbody, $offset, $idx1 - $offset)); if ($chunkLength == 0) { break; } else { $temp .= substr($mapbody, $idx1+2, $chunkLength); $offset = $idx1 + $chunkLength + 4; } } while(true); $mapbody = $temp; } // header("Content-Type: text/xml; charset=utf-8"); fclose ($fp); } $map_x_point_1=explode("", $mapbody); $map_x_point_2=explode("", $map_x_point_1[1]); $it_naverx=$map_x_point_2[0]; $map_y_point_1=explode("", $mapbody); $map_y_point_2=explode("", $map_y_point_1[1]); $it_navery=$map_y_point_2[0]; //네이버 좌표 추가 끝. } ?>

수정

삭제

축제정보 최종수정일:

close(); $sdb->close(); exit; ?>