$dupli_bann_num = mysqli_num_rows($dupli_bann_result); if ($dupli_bann_num == 0) { // 중복 당첨여부 체크 $dupli2_bann_query = "SELECT * FROM " . $_gl['member_info_table'] . " WHERE mb_phone='" . $mb_phone . "' AND mb_lms='Y'"; $dupli2_bann_result = mysqli_query($my_db, $dupli2_bann_query); $dupli2_bann_num = mysqli_num_rows($dupli2_bann_result); if ($dupli2_bann_num == 0) { $flag = "Y"; send_lms($mb_phone, $mb_serial); } else { $flag = "D"; send_lms2($mb_phone, $mb_serial); } } else { $flag = "D"; send_lms2($mb_phone, $mb_serial); } } else { $flag = "N"; } echo $flag; break; case "insert_click_count": $c_position = $_REQUEST['c_position']; $media = $_SESSION['ss_media']; // 클릭 정보 입력 $click_query = "INSERT INTO " . $_gl['click_info_table'] . "(click_media, click_position, click_date) values ('" . $_SESSION['ss_media'] . "','" . $c_position . "','" . date('Y-m-d H:i:s') . "')"; $result = mysqli_query($my_db, $click_query); if ($result) { $flag = "Y"; } else {
$serial = BA_getSerial($winnerYN); $query = "INSERT INTO " . $_gl['voter_info_table'] . "(vote_ipaddr,vote_name,vote_phone,vote_sel_idx,vote_winner,vote_regdate,vote_gubun,vote_media,vote_serial) values('" . $_SERVER['REMOTE_ADDR'] . "','" . $vote_name . "','" . $vote_phone . "','" . $vote_idx . "','" . $winnerYN . "','" . date("Y-m-d H:i:s") . "','" . $gubun . "','" . $media . "','" . $serial . "')"; $result = mysqli_query($my_db, $query); $query2 = "UPDATE " . $_gl['member_info_table'] . " SET mb_vote=mb_vote+1 WHERE idx='" . $vote_idx . "'"; $result2 = mysqli_query($my_db, $query2); $nominee_query = "SELECT * FROM " . $_gl['member_info_table'] . " WHERE mb_phone='" . $vote_phone . "'"; $nominee_result = mysqli_query($my_db, $nominee_query); $nominee_cnt = mysqli_num_rows($nominee_result); if ($all_cnt == 0) { if ($nominee_cnt == 0) { send_lms2($vote_phone, $serial); } } if ($winnerYN == "N||DELIVERY") { if ($nominee_cnt == 0) { send_lms2($vote_phone, $serial); } } $flag = $winnerYN; } echo $flag; break; case "send_lms": $mb_phone = $_REQUEST['mb_phone']; $mb_gift = $_REQUEST['mb_gift']; $mb_nation = $_REQUEST['mb_nation']; $gift_query = "SELECT * FROM " . $_gl['member_info_table'] . " WHERE mb_phone='" . $mb_phone . "'"; $gift_result = mysqli_query($my_db, $gift_query); $gift_num = mysqli_num_rows($gift_result); $winner_query = "SELECT * FROM " . $_gl['member_info_table'] . " WHERE mb_phone='" . $mb_phone . "' AND mb_winner like '%Y%'"; $winner_result = mysqli_query($my_db, $winner_query);