<<<<<<< HEAD "; ======= alert('비정상적인 접근입니다.');"; // echo ""; } $type = $_GET['counseling_type_input']; //echo "상담유형 : ".$type; //echo "
IP : ".$_SERVER[REMOTE_ADDR]; //echo "
email : ".$_SESSION['user_id']; //echo "
초기화 수 : ".$num_rows; // 모바일기기 접속 여부 조회 $useragent=$_SERVER['HTTP_USER_AGENT']; if(preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i',$useragent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',substr($useragent,0,4))) { $device = "mobileWeb"; } else { $device = "PC"; } // make a log $sql = "INSERT INTO log_forwarding (datetime_forwarding, prev_url, ip, device) VALUES (now(), 'visitedYonjaReservationTimetable', :ip, :device)"; $result = $conn->prepare($sql); // $result->bindParam(":prev_url",$_GET['quelle']); $result->bindParam(":ip",$_SERVER['REMOTE_ADDR']); $result->bindParam(":device",$device); $result->execute(); $today = date("Y-m-d"); // 상담 가능 횟수 조회 $sql = "SELECT date, availableCount FROM reservation_count WHERE sourceService='yonja'"; $result = $conn->prepare($sql); $result->execute(); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $dateOnDB = $row['date']; $availableCount = $row['availableCount']; } if($dateOnDB != date("Y-m-d")) { // echo "anders"; $sql = "UPDATE reservation_count SET availableCount=5, date='$today' WHERE sourceService='yonja'"; $result = $conn->prepare($sql); $result->execute(); // } else { // $sql = "UPDATE reservation_count SET availableCount=availableCount-1 WHERE sourceService='yonja'"; // $result = $conn->prepare($sql); // $result->execute(); } // '미결제' && '클릭 후 30분 경과' 상담시간 조회 $tb_name = 'schedule_counselor'; $sql = "SELECT number from $tb_name WHERE now() < datetime_counseling AND isPaid=0 AND (datetime_clicked < date_add(now(), interval -30 minute)) AND counselor='급상담' ORDER BY datetime_counseling ASC"; $result = $conn->prepare($sql); $result->execute(); $num_rows = $result->rowCount(); // 해당 아이템들 : 업데이트 --> occupied=occupied-1, time_clicked=NULL, counseling_type='', series=0, etc=NULL if($num_rows>0) { $sql = ""; while($row = $result->fetch(PDO::FETCH_ASSOC)){ $number = $row['number']; $sql .= "UPDATE $tb_name SET isOccupied=0, email=NULL, name_customer=NULL, counseling_type=NULL, series=0, tel=NULL, datetime_clicked=NULL, etc=NULL WHERE number='$number' AND isPaid=0;"; $num_rows--; } $result = $conn->prepare($sql); $result->execute(); } ?> 연애의자격 상담예약
상담예약을 위해 다음의 내용을 입력해주세요^^
개인정보취급방침에 동의합니다.
상담예약안내사항을 확인했습니다.
0) { ?> 급상담은 오늘 최대 명까지만 도와드릴 수 있어요. 오늘의 상담예약은 마감되었지만, 대기번호 1번으로 예약해 드릴 수 있어요.
>>>>>>> 57ce20fb453a1f9d21814261efe38481a2575e4f