$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);
$winner_num = mysqli_num_rows($winner_result);
if ($mb_gift == "0D") {
$result = "N";
} else {
if ($mb_gift == "2D") {
$result = "N";
} else {
if ($mb_gift == "3D") {
$result = "N";
} else {
$result = send_lms($mb_phone, $mb_gift, $mb_nation);
}
}
}
echo $gift_num;
break;
case "use_coupon":
$mb_phone = $_REQUEST['mb_phone'];
$query = "UPDATE " . $_gl['member_info_table'] . " SET mb_use='Y' WHERE mb_phone='" . $mb_phone . "'";
$result = mysqli_query($my_db, $query);
if ($result) {
$flag = "Y";
} else {
$flag = "N";
}
echo $flag;
flush();
$query = "UPDATE " . $_gl['member_info_table'] . " SET mb_baby_name='" . $mb_baby_name . "',mb_baby_age='" . $mb_baby_age . "',mb_concept='" . $mb_concept . "', mb_photo1='" . $img_name1 . "', mb_photo2='" . $img_name2 . "', mb_photo3='" . $img_name3 . "', mb_photo4='" . $img_name4 . "', mb_photo5='" . $img_name5 . "', mb_caption1='" . $mb_caption1 . "', mb_caption2='" . $mb_caption2 . "', mb_caption3='" . $mb_caption3 . "', mb_caption4='" . $mb_caption4 . "' WHERE mb_serial='" . $mb_serial . "'";
$result = mysqli_query($my_db, $query);
if ($result) {
// 체험비 무료쿠폰 사이트 중복 당첨여부 체크
$dupli_bann_query = "SELECT * FROM " . $_gl['bann_info_table'] . " WHERE bann_phone='" . $mb_phone . "'";
$dupli_bann_result = mysqli_query($my_db, $dupli_bann_query);
$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'];
<? include_once "../config.php"; //$phone = "01027987332"; $phone = $_REQUEST['mid']; $gift = $_REQUEST['gift']; $nation = $_REQUEST['nation']; send_lms($phone,$gift,$nation); ?>
<?php include_once "../config.php"; $phone = $_REQUEST['mid']; send_lms($phone);
<?
$result = send_lms("07048881164");
print_r($result);
// LMS 발송
function send_lms($phone)
{
global $_gl;
global $my_db;
$httpmethod = "POST";
$url = "http://api.openapi.io/ppurio/1/sendnumber/list/minivertising";
$clientKey = "MTAyMC0xMzg3MzUwNzE3NTQ3LWNlMTU4OTRiLTc4MGItNDQ4MS05NTg5LTRiNzgwYjM0ODEyYw==";
$contentType = "Content-Type: application/x-www-form-urlencoded";
$response = sendRequest($httpmethod, $url, $clientKey, $contentType, $phone);
$json_data = json_decode($response, true);
return $json_data;
}
function sendRequest($httpMethod, $url, $clientKey, $contentType, $phone) {
//create basic authentication header
$headerValue = $clientKey;
$headers = array("x-waple-authorization:" . $headerValue);
$params = array(
'sendnumber' => $phone
);
if($xml->code == 200){
$transUrl = $xml->result->url;
$orgUrl = $xml->result->orgUrl;
$qr = $xml->result->url.".qr";
}
*/
$transUrl = "http://bit.ly/1gZhcTw";
$query = "INSERT INTO " . $_gl['member_info_table'] . "(mb_ipaddr, mb_name, mb_phone, blog_name, mb_s_url, mb_regdate, mb_gubun, mb_media, mb_serialnumber) values('" . $_SERVER['REMOTE_ADDR'] . "','" . $mb_name . "','" . $mb_phone . "','" . $blog_name . "','" . $transUrl . "','" . date("Y-m-d H:i:s") . "','" . $gubun . "','" . $media . "','" . $serial . "')";
$result = mysqli_query($my_db, $query);
if ($result) {
$flag = "Y";
} else {
$flag = "N";
}
send_lms($mb_phone, $transUrl);
} else {
$du_query = "SELECT * FROM " . $_gl['member_info_table'] . " WHERE mb_phone='" . $mb_phone . "' AND mb_regdate like '%" . date('Y-m-d') . "%'";
$du_result = mysqli_query($my_db, $du_query);
$du_cnt = mysqli_num_rows($du_result);
if ($du_cnt == 0) {
$serial = BR_getSerial();
$query = "INSERT INTO " . $_gl['member_info_table'] . "(mb_ipaddr, mb_name, mb_phone, blog_name, mb_s_url, mb_regdate, mb_gubun, mb_media, mb_serialnumber) values('" . $_SERVER['REMOTE_ADDR'] . "','" . $mb_name . "','" . $mb_phone . "','" . $blog_name . "','" . $transUrl . "','" . date("Y-m-d H:i:s") . "','" . $gubun . "','" . $media . "','" . $serial . "')";
$result = mysqli_query($my_db, $query);
if ($result) {
$flag = "T";
} else {
$flag = "N";
}
} else {
$flag = "D";
<?php include_once "../config.php"; //$phone = "01027987332"; $phone = $_REQUEST['mid']; send_lms($phone, 're_send');
