$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);
