= '0000-00-00' ";
}
/*
if($loginAfterUrl != ''){
$locationUrl = base64_decode($loginAfterUrl);
}
*/
if($autoLoginIS != 'N'){
$_ID = $_COOKIE['_ID_NPLACE_SAVE'] != '' ? $_COOKIE['_ID_NPLACE_SAVE'] : $_POST['p_id'];
$_PW = $_COOKIE['_PW_NPLACE_SAVE'] != '' ? $_COOKIE['_PW_NPLACE_SAVE'] : $_POST['p_pass'];
}else{
$_ID = $_POST['p_id'];
$_PW = $_POST['p_pass'];
}
$ambr1 = getValue('_MEMBER', " where m_pass = '".trim(addslashes(setSqlFilter($_PW)))."' and m_id = '".$_ID."' and m_use = 'Y' ".$_WHERE." ", 'ar', 'm_idx, m_level, m_id, m_pass', 0);
//echoAr($ambr1);
if($ambr1 != ''){
//if($ambr['m_id'] != 'guest' ){
// $ALLOWRow = getValue('_ADMINALLOW_IP', " where a_ip = '".$connectIP."' ", 'a_idx', 'a_idx');
// if(!$ALLOWRow) useExit('{"result":"N","message":"허용되지 않은 아이피입니다.\n관리자에게 문의해주세요.\n\n접속 아이피 : '.$connectIP.'", "code":"", "url":"/"}');
//}
$PWSAVEIS = $_COOKIE['_PW_NPLACE_SAVE'] != '' ? 'Y' : $_REQUEST['pwSave'];
if($PWSAVEIS == 'Y'){
setCookie('_ID_NPLACE_SAVE', $_ID, time()+2678400,'/', _HOST);
setCookie('_PW_NPLACE_SAVE',$_PW, time()+2678400,'/', _HOST);
}else{
setCookie('_ID_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', _HOST);
}
$MEMIDX = $ambr1['m_idx'];
$_SET_LEVEL = 9;
if($ambr1['m_level'] == 'super')
$_SET_LEVEL = 10;
if($ambr1['m_level'] == 'hq')
$_SET_LEVEL = 5;
if($ambr1['m_level'] == 'user')
$_SET_LEVEL = 1;
if($ambr1['m_level'] == 'guest')
$_SET_LEVEL = 1;
setSession('_IDX', $MEMIDX);
setSession('_LEVEL', $_SET_LEVEL);
setSession('ltype', "general");
setCookie('_LEVEL', $_SET_LEVEL, time()+2678400, '/', '.'._HOST);
if($_COOKIE['_ID_NPLACE_SAVE'] == $ambr1['m_id'] && $_COOKIE['_PW_NPLACE_SAVE'] == trim(addslashes(setSqlFilter($ambr1['m_pass']))) && $_COOKIE['_LEVEL'] == $PUSANKJS['LEVEL'][$ambr1['m_level']]){
if($autoLoginIS != 'N')
msg('', $locationUrl);
}else{
//echo $_SET_LEVEL;
//exit;
if($_SET_LEVEL>=9)
{
$locationUrl = _ADMIN_LOGIN_URL;
useExit('{"result":"Y","url":"'.$locationUrl.'"}');
}else{
//업데이트여러번 말고 한번만 하도록 변경
$usql = "update _MEMBER set m_ip='".$_SERVER["REMOTE_ADDR"]."', m_agent='".$_SERVER["USER_AGENT"]."', m_lastlogindate=now()";
//강제로 업데이트 한번더 한다.
if($_REQUEST["fcm"]!="")
{
$usql .= ", m_regi='".$_REQUEST["fcm"]."'";
}
if($_REQUEST["lat"]!=""&&$_REQUEST["lon"]!="")
{
//$usql = ", p_lat='".$_REQUEST["lat"]."', p_lon='".$_REQUEST["lon"]."'";
}
if($_REQUEST["os"])
{
$usql .= ", m_os='".$_REQUEST["os"]."'";
}
if($_REQUEST["m_uniq"])
{
$usql .= ", m_uniq='".$_REQUEST["m_uniq"]."'";
}
$usql .= " where m_idx='".$MEMIDX."'";
$urs = query($usql);
//useExit('{"result":"Y","message":"'.$MEMIDX.'","url":"/item_mag.siso"}');
useExit('{"result":"Y","url":"/index.siso"}');
}
}
}else{
setCookie('_ID_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_MAIN_CODE_SAVE', '', 0, '/', _HOST);
if($_COOKIE['_ID_NPLACE_SAVE'] != ''){
if($_LEVELS == 'user')
$loginUrl = _USER_LOGIN_URL;
else
$loginUrl = _ADMIN_LOGIN_URL;
msg('비밀번호가 변경되었거나\n계정 저장 기간이 만료되었습니다.', $loginUrl);
}else{
useExit('{"result":"N","message":"=======잘못된 정보입니다=======\n'.$securityTxtMent.'아이디와 비밀번호를 다시 확인해주세요.\n\n\n이 문제는 다음과 같은 원인이 있을수도 있습니다.\n- 대소문자 구분을 잘못한 경우.\n- 한/영이 변경된 경우.\n- 회원 탈퇴한 경우.\n- 관리자가 상태를 변경한 경우.\n- 사용기간이 종료된 경우(관리자에게 문의)"}');
}
}
}
//만료일 이후라면 페이지 이동을 위한 로그인 체크 2019.06.27 by zero
if($dbControl == 'setChkLoginCk'){
$_WHERE = '';
if($autologin != 'Y'){
setCookie('_ID_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_MAIN_CODE_SAVE', '', 0, '/', _HOST);
setCookie('_LEVEL', '', 0, '/', _HOST);
setSession('_IDX', '');
setSession('_LEVEL', '');
}
$_LEVELS = $_REQUEST['setLevel'];
$locationUrl = _ADMIN_URL;
if($_LEVELS == 'hq')
$locationUrl = _HQ_URL;
if($_LEVELS == 'user'){
$locationUrl = _USER_INDEX;
//$_WHERE .= " AND m_expire_datetime >= now() ";
}
if($loginAfterUrl != ''){
//$locationUrl = base64_decode($loginAfterUrl);
//$locationUrl = $loginAfterUrl;
}
//echo $locationUrl;
//exit;
if($autoLoginIS != 'N'){
$_ID = $_COOKIE['_ID_NPLACE_SAVE'] != '' ? $_COOKIE['_ID_NPLACE_SAVE'] : $_POST['p_id'];
$_PW = $_COOKIE['_PW_NPLACE_SAVE'] != '' ? $_COOKIE['_PW_NPLACE_SAVE'] : $_POST['p_pass'];
}else{
$_ID = $_POST['p_id'];
$_PW = $_POST['p_pass'];
}
$ambr = getValue('_MEMBER', " where m_pw = '".trim(addslashes(setSqlFilter($_PW)))."' and m_id = '".$_ID."' and (m_level = '".$_LEVELS."' or m_level = 'super' ) and m_use = 'Y' and m_site = '".$getSiteSkin['di_idx']."' ".$_WHERE." ", 'ar', 'm_idx, m_level, m_id, m_pw, m_expire_datetime', false);
//echoAr($ambr);
if($ambr != ''){
if($ambr['m_id'] != 'guest' ){
$ALLOWRow = getValue('_ADMINALLOW_IP', " where a_ip = '".$connectIP."' ", 'a_idx', 'a_idx');
if(!$ALLOWRow)
{
useExit('{"result":"N","message":"허용되지 않은 아이피입니다.\n관리자에게 문의해주세요.\n\n접속 아이피 : '.$connectIP.'", "code":"", "url":"/"}');
}
//echoAr($ambr);
if (!in_array($ambr['m_id'],array("admin","master")))
{
$expire_datetime = strtotime($ambr["m_expire_datetime"]);
//echo time();
//echo "|";
//echo $ambr["m_expire_datetime"];
//echo $expire_datetime;
//echo print_r($ambr);
//exit;
if (time()>$expire_datetime) //만료일일자이후에 로그인하는거라면 결제페이지로 넘긴다.
{
//echo "";
//echo "dddd";
//msg('', $locationUrl);
$locationUrl = "/test_payment.siso?mid=".$ambr["m_id"];
//msg('', $locationUrl1);
//exit;
//useExit('{"result":"Y","message":"만료일이 지난 계정입니다.\n결제 페이지로 이동합니다.", "code":"", "url":"'.$locationUrl1.'"}');
}
}
}
$PWSAVEIS = $_COOKIE['_PW_NPLACE_SAVE'] != '' ? 'Y' : $_REQUEST['pwSave'];
if($PWSAVEIS == 'Y'){
setCookie('_ID_NPLACE_SAVE', $_ID, time()+2678400,'/', _HOST);
setCookie('_PW_NPLACE_SAVE',$_PW, time()+2678400,'/', _HOST);
}else{
setCookie('_ID_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', _HOST);
}
$MEMIDX = $ambr['m_idx'];
$_SET_LEVEL = 9;
if($ambr['m_level'] == 'super')
$_SET_LEVEL = 10;
if($ambr['m_level'] == 'hq')
$_SET_LEVEL = 5;
if($ambr['m_level'] == 'user')
$_SET_LEVEL = 1;
setSession('_IDX', $MEMIDX);
setSession('_LEVEL', $_SET_LEVEL);
setCookie('_LEVEL', $_SET_LEVEL, time()+2678400, '/', '.'._HOST);
if($_COOKIE['_ID_NPLACE_SAVE'] == $ambr['m_id'] && $_COOKIE['_PW_NPLACE_SAVE'] == trim(addslashes(setSqlFilter($ambr['m_pass']))) && $_COOKIE['_LEVEL'] == $PUSANKJS['LEVEL'][$ambr['m_level']]){
if($autoLoginIS != 'N')
msg('', $locationUrl);
}else{
useExit('{"result":"Y","message":"'.$MEMIDX.'","url":"'.$locationUrl.'"}');
}
}else{
setCookie('_ID_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', _HOST);
setCookie('_MAIN_CODE_SAVE', '', 0, '/', _HOST);
if($_COOKIE['_ID_NPLACE_SAVE'] != ''){
if($_LEVELS == 'user')
$loginUrl = _USER_LOGIN_URL;
else
$loginUrl = _ADMIN_LOGIN_URL;
msg('비밀번호가 변경되었거나\n계정 저장 기간이 만료되었습니다.', $loginUrl);
}else{
useExit('{"result":"N","message":"=======잘못된 정보입니다=======\n'.$securityTxtMent.'아이디와 비밀번호를 다시 확인해주세요.\n\n\n이 문제는 다음과 같은 원인이 있을수도 있습니다.\n- 대소문자 구분을 잘못한 경우.\n- 한/영이 변경된 경우.\n- 회원 탈퇴한 경우.\n- 관리자가 상태를 변경한 경우.\n- 사용기간이 종료된 경우(관리자에게 문의)"}');
}
}
}
if($dbControl == 'setMemberLogOut'){
setSession('_IDX', '');
setSession('_LEVEL', '');
setCookie('_ID_NPLACE_SAVE', '', 0, '/', '.'._HOST);
setCookie('_PW_NPLACE_SAVE', '', 0, '/', '.'._HOST);
useExit('{"result":"Y","message":"정상적으로 로그아웃되었습니다.", "code":"", "url":"/"}');
}
//아이디(이메일) 찾기
if($dbControl == "findMemberEmail")
{
$m_hp = $_POST["cellnum"];
$findMeminfo = getValue($TB_M," where m_hp='".$m_hp."' and m_email!='' and m_name!='' ","ar","*");
if ($findMeminfo)
{
$sendMail = sendMail('yds5004@naver.com', '인연톡', '인연톡 아이디를 알려드립니다.' ,'인연톡 아이디는 '.$findMeminfo["m_id"].'입니다.', $findMeminfo["m_email"], $findMeminfo['m_name'], true);
useExit('{"result":"Y","value":"'.$findMeminfo["m_id"].'","url":""}');
}else{
useExit('{"result":"N","message":"등록한 아이디 및 이메일이 정확하지 않습니다.\n대소문자를 구분합니다.\n정확히 다시 한번 입력하시기 바랍니다.\n또는 관리자의 의해 상태가 변경되었을수도 있습니다."}');
}
}
//비밀번호 찾기
if($dbControl == "findMemberPass")
{
$m_hp = $_POST["cellnum"];
$findMeminfo = getValue($TB_M," where m_hp='".$m_hp."' and m_email!='' and m_name!=''","ar","*");
if ($findMeminfo)
{
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$charactersLength = strlen($characters);
$randomString = "";
for($i=0;10>$i;$i++)
{
$randomString .= $characters[rand(0,$charactersLength-1)];
}
$usql = "update _MEMBER set m_pass='".$randomString."' where m_idx='".$findMeminfo["m_idx"]."'";
$urs = query($usql);
if($urs)
{
$sendMail = sendMail('yds5004@naver.com', '인연톡', '인연톡 비밀번호를 알려드립니다.' ,'인연톡 비밀번호는 '.$randomString.'입니다.', $findMeminfo["m_email"], $findMeminfo['m_name'], true);
useExit('{"result":"Y","value":"'.$randomString.'","url":""}');
}else{
useExit('{"result":"N","message":"비밀번호 변경도중 오류가 발생했습니다."}');
}
}else{
useExit('{"result":"N","message":"등록한 핸드폰번호가 정확하지 않습니다.\n정확히 다시 한번 입력하시기 바랍니다.\n또는 관리자의 의해 상태가 변경되었을수도 있습니다."}');
}
}
//비밀번호 변경
if($dbControl=="chgPasswd")
{
//echoAr($_REQUEST);
$m_idx=$_REQUEST["m_idx"];
$old_pass = $_REQUEST["old_passwd"];
$new_pass = $_REQUEST["new_passwd"];
$meminfo = getValue("_MEMBER"," where m_idx='".$m_idx."' and m_pass='".$old_pass."'","ar","*");
if($meminfo)
{
$usql = "update _MEMBER set m_pass='".$new_pass."' where m_idx=".$m_idx;
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","message":"비밀번호 변경 처리가 완료되었습니다.","url":"/index.siso"}');
}else{
useExit('{"result":"N","message":"비밀번호 변경 도중 오류가 발생했습니다.\n정확히 다시 한번 입력하시기 바랍니다.\n또는 관리자의 의해 상태가 변경되었을수도 있습니다."}');
}
}else{
useExit('{"result":"N","message":"기존 비밀번호가 정확하지 않습니다.\n정확히 다시 한번 입력하시기 바랍니다.\n또는 관리자의 의해 상태가 변경되었을수도 있습니다."}');
}
}
if($_REQUEST['dbControl'] == 'setMemberUserLoginCk'){
$_ID = $_POST['m_id'];
$_PW = $_POST['m_pass'];
$locationUrl = '/';
if($loginAfterUrl != ''){
$locationUrl = base64_decode($loginAfterUrl);
}
$ambr = getValue('_MEMBER', " where m_id = '".$_ID."' and m_pass = '".trim(addslashes(setSqlFilter($_PW)))."' and m_site = '".$getSiteSkin['di_idx']."' and m_use = 'Y' ", 'ar', 'm_idx, m_class, m_hardware_no', false);
if($ambr['m_idx'] != ''){
if($ambr['m_hardware_no'] != setSqlFilter($_POST['HARDWARE_NO'])){
query("
insert into
_MAC_ADDR
SET
m_user_idx = '".$ambr['m_idx']."'
, m_use_is = 'N'
, m_com_date= now()
, m_mac = '".setSqlFilter($_POST['HARDWARE_NO'])."'
, m_mac_old = '".setSqlFilter($paymentIIInfo['mac'])."'
, m_class = '".setSqlFilter($_POST['CLASS'])."'
, m_agent = '".setSqlFilter($agent)."'
, m_reghost = '".setSqlFilter($connectIP)."'
, m_domain = '".setSqlFilter($getSiteSkin['di_idx'])."'
, m_regdate = now()
");
useExit('{"result":"N","message":"하드웨어 번호가 일치하지 않습니다.\n관리자에게 문의하여 주시기 바랍니다.","MEMCODE":"N"}');
}
$MEMIDX = $ambr['m_idx'];
$_SET_LEVEL = 1;
setSession('_IDX', $MEMIDX);
setSession('_LEVEL', $_SET_LEVEL);
//query("update _MEMBER set m_fcm = '".trim(addslashes(setSqlFilter($_POST['m_fcm'])))."', m_uniq = '".trim(addslashes(setSqlFilter($_POST['m_uniq'])))."' where m_idx = '".$ambr['m_idx']."'");
useExit('{"result":"Y","message":"","url":"'.$locationUrl.'","MEMCODE":"'.$MEMIDX.'"}');
}else{
useExit('{"result":"N","message":"아이디 및 비밀번호가 정확하지 않습니다.\n대소문자를 구분합니다.\n정확히 다시 한번 입력하시기 바랍니다.\n또는 관리자의 의해 상태가 변경되었을수도 있습니다.","MEMCODE":"N"}');
}
}
if($_POST['dbControl'] == 'getMemberInfo'){
//useExit(json_encode($memberInfo));
useExit(json_encode(getValue('_MEMBER', " where m_idx = '".$_POST['CODE']."' and m_site = '".$getSiteSkin['di_idx']."' and m_use = 'Y' ", 'ar', "*")));
}
if($_POST['dbControl'] == 'setDomainSend'){
$_WHERE = '';
$_DIR = 'DOMAIN_INFO';
$_TB = '_'.$_DIR;
$sql = "
insert into
".$_TB."
set
di_domain = '".setOutput2($_POST['di_domain'])."'
, di_ver = '".setOutput2($_POST['di_ver'])."'
, di_terms = '".setOutput2($_POST['di_terms'])."'
, di_personal_information = '".setOutput2($_POST['di_personal_information'])."'
, di_regdate = now()
".$_WHERE."
";
$rs = query($sql);
$lastid = insert_id();
if($rs){
useExit('{"result":"Y","message":"성공적으로 등록 완료되었습니다.","url":"'.$_POST['RETURNURL'].'"}');
}else
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
if($_POST['dbControl'] == 'setDomainModify'){
$_WHERE = '';
$_DIR = 'DOMAIN_INFO';
$_TB = '_'.$_DIR;
$sql = "
update
".$_TB."
set
di_terms = '".setOutput2($_POST['di_terms'])."'
, di_personal_information = '".setOutput2($_POST['di_personal_information'])."'
".$_WHERE."
where
di_idx = '".setOutput2($_POST['CODE'])."'
";
$rs = query($sql);
if($rs)
useExit('{"result":"Y","message":"성공적으로 수정 완료되었습니다.","url":"'.$_POST['RETURNURL'].'"}');
else
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
if($dbControl == 'setDomainEdit'){
$_WHERE = '';
$_DIR = 'DOMAIN_INFO';
$_TB = '_'.$_DIR;
$oldInfo = getValue($_TB, " where di_idx = '".$getSiteSkin['di_idx']."' ", 'ar', 'di_loding_img');
//$_WHERE .= photoUploadNew('di_loding_img', $_DIR, '_WHERE', $oldInfo['di_loding_img'], false);
$sql = "
UPDATE
".$_TB."
SET
di_terms = '".trim(addslashes($_POST['di_terms']))."'
, di_personal_information = '".trim(addslashes($_POST['di_personal_information']))."'
, di_app_ver = '".trim(addslashes($_POST['di_app_ver']))."'
, di_googleplay_url = '".trim(addslashes($_POST['di_googleplay_url']))."'
, di_update_contents = '".trim(addslashes($_POST['di_update_contents']))."'
, di_location = '".trim(addslashes($_POST['di_location']))."'
, di_shop_url = '".trim(addslashes($_POST['di_shop_url']))."'
, di_loding_img_is = '".trim(addslashes($_POST['di_loding_img_is']))."'
, di_calculate_is = '".trim(addslashes($_POST['di_calculate_is']))."'
".$_WHERE."
WHERE
di_idx = '".trim(addslashes($getSiteSkin['di_idx']))."'
";
//echoAr($_REQUEST);
$rs = query($sql);
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$returnUrl.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'getTerm'){
//echo 'w';echoAr($getSiteSkin);
$ar = array('di_terms'=>stripslashes($getSiteSkin['di_terms']), 'di_personal_information'=>stripslashes($getSiteSkin['di_personal_information']), 'di_location'=>stripslashes($getSiteSkin['di_location']));
useExit(json_encode(str_replace(array('{sitename}', '{domain}', '{money}'), array($getSiteSkin['di_company_name'], 'http://'.$connUrlDomain, number_format($getSiteSkin['di_sve_price']/1.1)), $ar)));
}
if($dbControl == 'setPlaystorUpdateCheck'){
if($getSiteSkin['di_app_ver'] > $_POST['thisVer']){
useExit('{"result":"N","msg":"['.$getSiteSkin['di_app_ver']." 개선사항]\n".$getSiteSkin['di_update_contents'].'\n지금 업데이트가 있습니다.","url":"'.$getSiteSkin['di_googleplay_url'].'"}');
}else{
useExit('{"result":"Y","msg":"","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setCustomerCk')
{
$ck = getValue(('_MEMBER'), " where m_name = '".trim(addslashes(setSqlFilter($_POST['m_name'])))."' and right(m_hp, 4) = '".substr(trim(addslashes(setSqlFilter($_POST['m_hp']))), -4)."' and m_site = '".$getSiteSkin['di_idx']."' ", 'cnt', 'count(*) as cnt');
if($ck > 0){
exit('{"result":"N","message":"이미 회원가입하셨습니다.\n감사합니다.","url":"'.$returnURL.'"}');
}else{
//이름과 핸드폰번호를 통해 랜덤 숫자를 생성하여 출력
$m_name = trim(addslashes(setSqlFilter($_POST['m_name'])));
$sms_to = str_replace("-","",trim(addslashes(setSqlFilter($_POST['m_hp']))));
$number = random_int(100000,999999);
//echo $number;
//exit;
$crs = getValue("_AUTH_CELLNUM"," where m_name='".$m_name."' and cell_number='".$sms_to."'","ar","*");
if ($crs["idx"])
{
$usql = "update _AUTH_CELLNUM set auth_number='".$number."' where idx='".$crs["idx"]."'";
$urs = query($usql);
}else{
$isql = "insert into _AUTH_CELLNUM set m_name='".$m_name."', cell_number='".$sms_to."', auth_number='".$number."'";
$irs = query($isql);
}
$ch = curl_init();
$smsmsg="[NPLACE]인증번호는(".$number.")입니다";
$url="https://marketingmonster.kr/lib/sms.send.siso?sms_from=16666589&httpsRedirect=N&sms_to=".$sms_to."&smsmsg=".$smsmsg;
// $url="https://alrigo.co.kr/lib/sms.send.siso?sms_from=16444726&httpsRedirect=N&sms_to=".$sms_to."&smsmsg=".$smsmsg;
// set url
curl_setopt($ch, CURLOPT_URL, $url);
//return the transfer as a string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// $output contains the output string
$output = curl_exec($ch);
//var_dump($output);
// close curl resource to free up system resources
curl_close($ch);
exit('{"result":"Y","message":"","url":"'.$returnURL.'"}');
}
}
if($_REQUEST['dbControl'] == 'setAuthnumCk')
{
$m_name = trim(addslashes(setSqlFilter($_POST['m_name'])));
$cell_number = trim(addslashes(setSqlFilter($_POST['m_hp'])));
$auth_number = trim(addslashes(setSqlFilter($_POST['m_auth_number'])));
$ck = getValue("_AUTH_CELLNUM", " where m_name = '".$m_name."' and cell_number = '".$cell_number."' and auth_number = '".$auth_number."' ", 'cnt', 'count(*) as cnt',false);
//echo $ck."66666";
//exit;
if ($ck>0)
{
exit('{"result":"Y","message":"","url":"'.$returnURL.'"}');
}else{
exit('{"result":"N","message":"인증이 잘못되었습니다. 다시 인증해주세요.","url":"'.$returnURL.'"}');
}
}
if($_POST['dbControl'] == 'setMemberUserRegi'){
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
//if($_POST['m_uniq'] == '') useExit('{"result":"N","message":"휴대폰은 필수 입력입니다.","url":""}');
//if($_POST['m_fcm'] == '') useExit('{"result":"N","message":"휴대폰은 필수 입력입니다.","url":""}');
//if(strlen($_POST['m_fcm']) < 50) useExit('{"result":"N","message":"휴대폰은 필수 입력입니다.","url":""}');
//trim(addslashes(setSqlFilter($_POST['m_uniq'])))
//echoAr($_REQUEST);
//exit;
$m_id = trim(addslashes(setSqlFilter($_POST['m_email'])));
$m_pass = trim(addslashes(setSqlFilter($_POST['m_pass'])));
$m_pass_chk = trim(addslashes(setSqlFilter($_POST['m_pass_chk'])));
if($m_pass!=$m_pass_chk)
{
useExit('{"result":"N","message":"비밀번호가 일치 하지 않습니다."}');
}
//$m_name = trim(addslashes(setSqlFilter($_POST['m_name'])));
$m_email = trim(addslashes(setSqlFilter($_POST['m_email'])));
//$m_hp = trim(addslashes(setSqlFilter($_POST['m_hp1'])))."-".trim(addslashes(setSqlFilter($_POST['m_hp2'])))."-".trim(addslashes(setSqlFilter($_POST['m_hp3'])));
$m_hp = str_replace("-","",trim(addslashes(setSqlFilter($_POST['m_hp']))));
$m_regi = trim(addslashes(setSqlFilter($_POST['fcm'])));
$m_uniq = trim(addslashes(setSqlFilter($_SESSION["m_uniq"])));
$lat = trim(addslashes(setSqlFilter($_POST['lat'])));
$lon = trim(addslashes(setSqlFilter($_POST['lon'])));
$os = trim(addslashes(setSqlFilter($_POST['os'])));
//$m_auth_number = trim(addslashes(setSqlFilter($_POST['m_auth_number'])));
$old = getValue('_MEMBER', " where m_id='".$m_id."' and m_email='".$m_email."' ", 'ar', '*');
if($old['m_idx']){
$sql = "
UPDATE
".$_TB."
SET
m_site = '".$getSiteSkin['di_idx']."'
, m_hp = '".$m_hp."'
, m_regi = '".$m_regi."'
, modidate = now()
, m_agent = '".$agent."'
".$_WHERE."
WHERE
m_idx = '".$old['m_idx']."'
";
$rs = query($sql);
$thisKey= $old['m_idx'];
if($old['m_age'] == ''){
$PROfILEIS = 'N';
}else{
$PROfILEIS = 'Y';
}
useExit('{"result":"N","message":"이미 등록된 이메일 입니다.\n아이디를 확인 후 사용하시기 바랍니다.","MEMCODE":"'.$old['m_idx'].'"}');
}else{
$sql = "
INSERT INTO
".$_TB."
SET
m_site = '".$getSiteSkin['di_idx']."'
, m_id = '".$m_id."'
, m_hp = '".$m_hp."'
, m_pass = '".$m_pass."'
, m_email = '".$m_email."'
, m_regi = '".$m_regi."'
, m_os = '".$os."'
, regdate = now()
, m_ip = '".$_SERVER["REMOTE_ADDR"]."'
, m_agent = '".$_SERVER["HTTP_USER_AGENT"]."'
, m_expire_date = '0000-00-00'
, m_expire_time = '00:00:00'
, m_use = 'Y'
, m_level = 'guest'
, m_lastlogindate = now()
".$_WHERE."
";
//echo $sql;
//exit;
$rs = query($sql);
}
if($rs){
$thisKey= insert_id();
$maillink = "https://lifeadvisor.ncue.net/mailaccept.php?midx=".$thisKey."&memail=".$m_id."&m_os=".$_SESSION["os"];
$mailcontents = "아래 이메일 주소를 클릭하여 정식회원이 되세요.
인증 하기";
//2. 이메일 인증 메일 전송
$sendMail = sendMail('yds5004@naver.com', '인연톡', '인연톡 이메일 인증' ,$mailcontents, $m_id, "인연톡 임시회원", true);
$PROfILEIS = 'N';
$retrunUrl = "reg_profile.siso?idx=".$thisKey;
//3. 자동 로그인 처리후 프로필등록 페이지로 보낸다.
$_SET_LEVEL = 0; //임시회원상태
setSession('_IDX', $thisKey);
setSession('_LEVEL', $_SET_LEVEL);
setCookie('_LEVEL', $_SET_LEVEL, time()+2678400, '/', '.'._HOST);
useExit('{"result":"Y","message":"가입에 사용하신 이메일을 확인하세요. `본인 인증 후에 사용이 가능합니다.`","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'","PROfILEIS":"'.$PROfILEIS.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'setMemberUserEdit'){
//echoAr($memberInfo);
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
$oldInfo = getValue($_TB, " where m_idx = '".$memberInfo['m_idx']."' ", 'ar', 'm_photo');
$_WHERE .= photoUploadNew('m_photo', $_DIR, '_WHERE', $oldInfo['m_photo'], false);
$sql = "
UPDATE
".$_TB."
SET
m_fcm = '".trim(addslashes(setSqlFilter($_POST['m_fcm'])))."'
, m_uniq = '".trim(addslashes(setSqlFilter($_POST['m_uniq'])))."'
, m_age = '".trim(addslashes(setSqlFilter($_POST['m_age'])))."'
, m_sex = '".trim(addslashes(setSqlFilter($_POST['m_sex'])))."'
, m_nick = '".trim(addslashes(setSqlFilter($_POST['m_nick'])))."'
, m_theme = '".trim(addslashes(setSqlFilter($_POST['m_theme'])))."'
, m_profile_is = 'N'
, modidate = now()
".$_WHERE."
where
m_idx = '".$memberInfo['m_idx']."'
";
$rs = query($sql);
$thisKey= $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'setMemberLocationEdit'){
//echoAr($memberInfo);
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
$sql = "
UPDATE
".$_TB."
SET
m_x = '".trim(addslashes(setSqlFilter($_POST['m_x'])))."'
, m_y = '".trim(addslashes(setSqlFilter($_POST['m_y'])))."'
where
m_idx = '".$memberInfo['m_idx']."'
";
$rs = query($sql);
$thisKey= $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'setMemberUserEditMovie'){
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
if($_FILES['m_movie']['name'] != ''){
//if(getAllPointSum($memberInfo['m_idx']) )
if(getAllPointSum($memberInfo['m_idx']) < _MOVIE_POINT){
exit('{"result":"N","message":"포인트가 부족합니다.\n충전후 이용하시기 바랍니다.", "cnt":"", "url":""}');
}else{
$pointSave = setPoint('-', $memberInfo['m_idx'], (int)str_replace(',','',_MOVIE_POINT), 'Y', '영상프로필 등록 차감');
}
}
$oldInfo = getValue($_TB, " where m_idx = '".$memberInfo['m_idx']."' ", 'ar', 'm_movie, m_movie_thum');
$_WHERE .= photoUploadNew('m_movie', $_DIR, '_WHERE', $oldInfo['m_movie'], false);
$_WHERE .= photoUploadNew('m_movie_thum', $_DIR, '_WHERE', $oldInfo['m_movie_thum'], false);
$sql = "
UPDATE
".$_TB."
SET
m_addr1 = '".trim(addslashes(setSqlFilter($_POST['m_addr1'])))."'
, m_addr2 = '".trim(addslashes(setSqlFilter($_POST['m_addr2'])))."'
, m_job = '".trim(addslashes(setSqlFilter($_POST['m_job'])))."'
, m_cm = '".trim(addslashes(setSqlFilter($_POST['m_cm'])))."'
, m_introduction= '".trim(addslashes(setSqlFilter($_POST['m_introduction'])))."'
, dongmodidate = now()
".$_WHERE."
where
m_idx = '".$memberInfo['m_idx']."'
";
$rs = query($sql);
$thisKey= $memberInfo['m_idx'];
if($rs){
$point = getAllPointSum($memberInfo['m_idx']);
useExit('{"result":"Y","message":"성공적으로 등록/수정하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'", "point":"'.$point.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":"", "point":"'.$point.'"}');
}
}
if($dbControl == "setIOSmemInfo")
{
$m_idx = $_POST["idx"];
$m_regi = $_POST["fcm"];
$p_lat = $_POST["lat"];
$p_lon = $_POST["lon"];
$usql = "update _MEMBER set m_regi='".$m_regi."' where m_idx='".$m_idx."'";
$urs = query($usql);
if ($urs)
{
$profileinfo = getValue("_PROFILE"," where p_m_idx='".$m_idx."'","ar","*");
if($profileinfo)
{
$uusql = "update _PROFILE set p_lat='".$p_lat."', p_lon='".$p_lon."' where p_m_idx='".$m_idx."'";
$uurs = query($uusql);
if($uurs)
{
useExit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"reg_profile.siso?idx='.$m_idx.'" }');
}
}
}
}
if($_REQUEST['dbControl'] == 'setCustomerMemberOTPPC'){
$mck = getValue('_MEMBER', " where REPLACE(m_hp, '-', '') = '".str_replace('-', '', $_REQUEST['FROMTEL'])."' /*and m_lite_is = '".trim(addslashes(setSqlFilter($_REQUEST['m_lite_is'] == 'Y' ? 'Y' : 'N')))."' and m_class = '".trim(addslashes(setSqlFilter($_REQUEST['CLASS'])))."'*/ and m_site = '".$getSiteSkin['di_idx']."' ", 'm_idx', 'm_idx');
if($mck){
//useExit('{"result":"N","message":"이미 회원가입 이력이 존재합니다.\n로그인을 진행하시기 바랍니다.","NUM":""}');
useExit('{"result":"N","message":"해당 핸드폰은 이미 등록된 번호입니다.\n번호를 다시 한번 확인하시거나, 다른번호를 등록하시기 바랍니다.","NUM":""}');
}
$rand_num = '';
for ($i=0; $i<6; $i++) $rand_num .= mt_rand(1,9);
$smsmsg = '[마케팅몬스터]인증번호는 '.$rand_num.' 입니다.';
$sms_from = '16444726';
$sms_to = str_replace('-', '', $FROMTEL);
//pusankjs 문자 모듈 수정[2019-01-02]
$smssend = socketPost(_SMS_SEND_URL.'/lib/sms.send.siso', '&httpsRedirect=N&sms_from='.$sms_from.'&sms_to='.$sms_to.'&smsmsg='.$smsmsg);
$resultAr = json_decode($smssend, true);
if($resultAr['result'] == 'Y'){
//useExit('{"result":"Y","message":"성공적으로 답변 완료되었습니다.","url":"f5"}');
useExit('{"result":"Y","message":"인증번호가 성공적으로 발송하였습니다.\n문자 확인후 정확히 입력하시기 바랍니다. ","url":"'.$returnURL.'","NUM":"'.$rand_num.'"}');
}else{
useExit('{"result":"'.$resultAr['result'].'","message":"'.$resultAr['message'].'","url":"'.$resultAr['url'].'","NUM":""}');
}
}
if($dbControl == 'memberAdminModify'){
$_WHERE = '';
if(trim(addslashes(setSqlFilter($_POST['m_pass'])))){
$_WHERE .= " , m_pass = '".trim(addslashes(setSqlFilter($_POST['m_pass'])))."' ";
}
if(trim(addslashes(setSqlFilter($_POST['m_sms_one_price'])))){
$_WHERE .= " , m_sms_one_price = '".trim(addslashes(setSqlFilter(str_replace(',', '', $_POST['m_sms_one_price']))))."' ";
}
if(trim(addslashes(setSqlFilter($_POST['m_lms_one_price'])))){
$_WHERE .= " , m_lms_one_price = '".trim(addslashes(setSqlFilter(str_replace(',', '', $_POST['m_lms_one_price']))))."' ";
}
if(trim(addslashes(setSqlFilter($_POST['m_mms_one_price'])))){
$_WHERE .= " , m_mms_one_price = '".trim(addslashes(setSqlFilter(str_replace(',', '', $_POST['m_mms_one_price']))))."' ";
}
$sql = "
UPDATE
_MEMBER
SET
m_name = '".trim(addslashes(setSqlFilter($_POST['m_name'])))."'
, m_hp = '".trim(addslashes(setSqlFilter($_POST['m_hp'])))."'
".$_WHERE."
where
m_idx = '".$_POST['CODE']."'
";
$rs = query($sql);
$thisKey= $_POST['CODE'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$RETURNURL.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setMemberUserEdit2'){
$_WHERE = '';
if(trim($_POST['m_pass'])){
if(trim($_POST['m_pass']) != trim($_POST['m_pass_confirm'])) useExit('{"result":"N","message":"비밀번호가 일치하지 않습니다.\n정확히 다시 입력하시기 바랍니다.","url":""}');
}
if($_POST['m_hp'] == '') useExit('{"result":"N","message":"휴대폰은 필수 입력입니다.","url":""}');
if(trim(addslashes(setSqlFilter($_POST['m_pass'])))){
$_WHERE .= " , m_pass = '".trim(addslashes(setSqlFilter($_POST['m_pass'])))."' ";
}
$sql = "
UPDATE
_MEMBER
SET
m_name = '".trim(addslashes(setSqlFilter($_POST['m_name'])))."'
, m_birthday = '".trim(addslashes(setSqlFilter($_POST['m_birthday'])))."'
, m_hp = '".trim(addslashes(setSqlFilter($_POST['m_hp'])))."'
, modidate = now()
".$_WHERE."
where
m_idx = '".$memberInfo['m_idx']."'
";
$rs = query($sql);
$thisKey= $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$retrunUrl.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setMemberFcmEdit'){
$_WHERE = '';
$sql = "
UPDATE
_MEMBER
SET
m_fcm = '".trim(addslashes(setSqlFilter($_POST['m_fcm'])))."'
, m_uniq = '".trim(addslashes(setSqlFilter($_POST['m_uniq'])))."'
where
m_idx = '".$memberInfo['m_idx']."'
";
$rs = query($sql);
$thisKey= $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정하였습니다.","url":"'.$retrunUrl.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setQNARegi'){
$_WHERE = '';
$_DIR = 'BOARD_QNA';
$_TB = '_'.$_DIR;
$regdate = date('Y-m-d H:i:s');
$sql = "
INSERT INTO
".$_TB."
SET
b_user_idx = '".trim(addslashes(setSqlFilter($memberInfo['m_idx'])))."'
, b_site = '".$getSiteSkin['di_idx']."'
, b_email = '".trim(addslashes(setSqlFilter($_POST['b_email'])))."'
, b_title = '".trim(addslashes(setSqlFilter($_POST['b_title'])))."'
, b_contents = '".trim(addslashes(setSqlFilter($_POST['b_contents'])))."'
, b_regdate = now()
, b_ip = '".$connectIP."'
, b_agent = '".$agent."'
";
$rs = query($sql);
$thisKey= insert_id();
if($rs){
useExit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"'.$retrunUrl.'","CODE":"'.$thisKey.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","CODE":""}');
}
}
if($_POST['dbControl'] == 'getMemberList'){
$_WHERE = " WHERE 1 and m_idx <> '".$memberInfo['m_idx']."' and m_level = 'user' and m_sex <> '' ";
$_TAGS = "";
$_DISTANCE = "";
if($_REQUEST['keyword'] != '' && $_REQUEST['word'] != ''){
$_WHERE .= " AND ".$_REQUEST['keyword']." LIKE '%".$_REQUEST['word']."%' ";
$_TAGS .= '&keyword='.$_REQUEST['keyword'];
$_TAGS .= '&word='.$_REQUEST['word'];
}
if($_REQUEST['MOVIE'] == 'Y'){
$_WHERE .= " AND m_movie <> '' ";
$_TAGS .= '&MOVIE='.$_REQUEST['MOVIE'];
}
if($_REQUEST['x'] && $_REQUEST['y']){
$_DISTANCE = " ,round( 6371 * acos( cos( radians('".$_REQUEST['x']."') ) * cos( radians( m_x ) ) * cos( radians( m_y ) - radians('".$_REQUEST['y']."') ) + sin( radians('".$_REQUEST['x']."') ) * sin( radians( m_x ) ) ) ,2) AS distance";
//$_WHERE .= " AND m_move <> '' ";
//$_TAGS .= '&MOVIE='.$_REQUEST['MOVIE'];
}
if($_REQUEST['GENDER']){
$_WHERE .= " AND m_sex = '".$_REQUEST['GENDER']."' ";
$_TAGS .= '&GENDER='.$_REQUEST['GENDER'];
}
$_TABLE = '_MEMBER';
if($_ORDERTYPE == 'distance'){
$_ORDER = 'ORDER BY distance asc';
}else{
$_ORDER = 'ORDER BY m_lastlogin DESC';
}
$onePageCount = 20;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
".$_DISTANCE."
FROM
".$_TABLE.$_WHERE.$_ORDER."
limit ".$offset.", ".$onePageCount
;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($_POST['dbControl'] == 'setQuestionDetail'){
$row = getValue('_QNA as A inner join _MEMBER as B on A.q_user_idx = B.m_idx', " where q_idx = '".$_POST['CODE']."' ", 'ar', 'A.*, B.m_name');
$sql2 = "select A.*, B.m_name, B.m_photo, B.m_class from _QNA_REPLY as A inner join _MEMBER as B on A.q_user_idx = B.m_idx where q_qna_idx = '".$row['q_idx']."' ";
$rs2 = query($sql2);
if(rows() > 0){
$list = Array();
for($i=0; $row2 = assoc($rs2); $i++){
$list[] = $row2;
}
}
$jsonList = array('data'=> $row, 'reply'=>$list);
$json = json_encode( $jsonList);
useExit($json);
}
if($_POST['dbControl'] == 'setBoardSend'){
//$getBoardAdmin = getValue('_BOARD_ADMIN', " where ba_idx = '".$BCODE."' ");
$_WHERE = "";
//$sql = "INSERT INTO _BOARD_".$getBoardAdmin['ba_table']." SET b_cate = '".trim(addslashes(setSqlFilter($_POST['b_cate'])))."', b_site = '".setSqlFilter($getSiteSkin['di_idx'])."', b_title ='".trim(addslashes(setSqlFilter($_POST['b_title'])))."', b_contents= '".trim(addslashes(setSqlFilter($_POST['b_contents'])))."', b_reply = '".trim(addslashes(setSqlFilter($_POST['b_reply'])))."', b_user_idx ='".trim(addslashes(setSqlFilter($partnerInfo['p_idx'] ? $partnerInfo['p_idx'] : $memberInfo['m_idx'])))."', b_name = '".trim(addslashes(setSqlFilter($_POST['b_name'])))."', b_hits=1, b_notice_is ='".trim(addslashes(setSqlFilter($_POST['b_notice_is'] == 'Y' ? 'Y' : 'N')))."', b_secret_is = '".trim(addslashes(setSqlFilter($_POST['b_secret_is'] == 'Y' ? 'Y' : 'N')))."', b_user_level ='".trim(addslashes(setSqlFilter($partnerInfo['p_idx'] != '' ? 'PARTNER' : 'ADMIN')))."', b_ip = '".$connectIP."', b_agent = '".$agent."', b_tag = '".$b_tag."', b_class ='".trim(addslashes(setSqlFilter($_POST['b_class'])))."', b_add1 = '".trim(addslashes(setSqlFilter($_POST['b_add1'])))."', b_add2 = '".trim(addslashes(setSqlFilter($_POST['b_add2'])))."', b_add3 ='".trim(addslashes(setSqlFilter($_POST['b_add3'])))."', b_add4 = '".trim(addslashes(setSqlFilter($_POST['b_add4'])))."', b_add5 = '".trim(addslashes(setSqlFilter($_POST['b_add5'])))."', b_add6 ='".trim(addslashes(setSqlFilter($_POST['b_add6'])))."', b_add7 = '".trim(addslashes(setSqlFilter($_POST['b_add7'])))."', b_add8 = '".trim(addslashes(setSqlFilter($_POST['b_add8'])))."', b_add9 = '".trim(addslashes(setSqlFilter($_POST['b_add9'])))."', b_add10 = '".trim(addslashes(setSqlFilter($_POST['b_add10'])))."', b_regdate = now()";
$sql = "insert into board set title='".$_POST["title"]."'";
if ($BCODE=="1")
{
$sql .= ", category='notice'";
}else if($BCODE=="4"){
$sql .= ", category='qna'";
}
$sql .= ", contents='".trim(addslashes(setSqlFilter($_POST['contents'])))."', regdate=now(), b_name='".trim(addslashes(setSqlFilter($_POST['b_name'])))."'";
$rs = query($sql);
$thisKey= insert_id();
//query("update _BOARD_".$getBoardAdmin['ba_table']." set b_parent = '".$thisKey."' where b_idx = '".$thisKey."' ");
query("update board set fn_boardNum = '".$thisKey."' where idx = '".$thisKey."' ");
/*
$FILEINFO = array();
$_WHERE = '';
$_DIR = 'BOARD';
$_DIR_DELIM = $getBoardAdmin['ba_table'];
for($f=1; $f <= trim($getBoardAdmin['ba_file_cnt']); $f++){
$_FILENUM = 1;
$_FILENAME = 'bf_file_'.$f;
if($_FILES[$_FILENAME]['name'] != ''){
$FILEINFO['_UPLOADFILE']= fileUpload($_FILENAME, $_DIR, $_DIR_DELIM);
$FILEINFO['_DIR'] = '/UPLOAD/'.$_DIR.'/'.$_DIR_DELIM.'/';
$FILEINFO['_FILE'] = $FILEINFO['_UPLOADFILE'];
$FILEINFO['_FILE_ORG'] = $_FILES[$_FILENAME]['name'];
$FILEINFO['_FILE_SIZE'] = $_FILES[$_FILENAME]['size'];
$filesql = "
INSERT INTO
_BOARD_FILE
SET
bf_board_id = '".$BCODE."'
, bf_board_idx = '".$thisKey."'
, bf_dir = '".$FILEINFO['_DIR']."'
, bf_file = '".$FILEINFO['_FILE']."'
, bf_file_org = '".$FILEINFO['_FILE_ORG']."'
, bf_file_size = '".$FILEINFO['_FILE_SIZE']."'
, bf_contents = ''
, bf_download = 0
, bf_rank = '".$f."'
, bf_regdate = now()
";
$filers = query($filesql);
$_FILENUM++;
}
}
*/
if($rs){
if($_POST['RETURNURLCONTROL']){
$REUTN = $_POST['RETURNURLCONTROL'];
}else{
$REUTN = $_POST['RETURNURL'].'?BCODE='.$BCODE;
}
if($BCODE == '2'){
$message = Array('type'=>'notice', 'title'=>trim(addslashes(setSqlFilter($_POST['b_title']))), 'CODE'=>$thisKey);
$_MEMBER_TABLE = '_MEMBER';
$_MEMBER_WHERE = " where m_fcm <> '' ";
$_MEMBER_ORDER = " order by m_idx asc ";
$_MEMBER_TOTAL = getValue($_MEMBER_TABLE, $_MEMBER_WHERE, 'cnt', 'count(*) as cnt');
$_MEMBER_ONEPAGECOUNT = 1000;
$totalPageCnt = ceil($_MEMBER_TOTAL/$_MEMBER_ONEPAGECOUNT);
for($pos=0; $pos < $totalPageCnt; $pos++){
//$pagenum = $pos+1;
$_MEMBERR_OFFSET = ($pos) * $_MEMBER_ONEPAGECOUNT;
$sql ="SELECT * FROM ".$_MEMBER_TABLE.$_MEMBER_WHERE.$_MEMBER_ORDER." limit ".$_MEMBERR_OFFSET.", ".$_MEMBER_ONEPAGECOUNT;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
$pushkey = Array();
for($i=0; $row = assoc($rs); $i++){
$pushkey[] = $row['m_fcm'];
}
//echo '';print_r($pushkey);echo '
';
//print_r($pushkey);
fcm_push($message,'AAAAfg0C6B0:APA91bEnjpuFJqgFMPPmJLOYdgkw4wU3HZrxZM7dxHTUPGgHgwDmcYEXuErHBQcQBeRQCcd5e-hYhRrNqe8dZQq8fccsxhHYiAjWYwrfjHbGVes4ADIAqY2bGjlLtClxyiK7Ol2rN9UO',$pushkey);
}
//echo $pos.'
';
}
}
useExit('{"result":"Y","message":"성공적으로 등록 완료되었습니다.","url":"'.$REUTN.'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_POST['dbControl'] == 'setBoardModify'){
//echoAr($_REQUEST);
//$getBoardAdmin = getValue('_BOARD_ADMIN', " where ba_idx = '".$BCODE."' ");
$sql = "
UPDATE
board
SET
title = '".trim(addslashes(setSqlFilter($_POST['title'])))."'
, contents = '".trim(addslashes(setSqlFilter($_POST['contents'])))."'
, b_reply = '".trim(addslashes(setSqlFilter($_POST['b_reply'])))."'
, b_notice_is = '".trim(addslashes(setSqlFilter($_POST['b_notice_is'] == 'Y' ? 'Y' : 'N')))."'
, b_secret_is = '".trim(addslashes(setSqlFilter($_POST['b_secret_is'] == 'Y' ? 'Y' : 'N')))."'
, b_name = '".trim(addslashes(setSqlFilter($_POST['b_name'])))."'
, b_modidate = now()
".$_WHERE."
WHERE
idx = '".$CODE."'
";
//echoAr($sql);
$rs = query($sql);
$thisKey= $CODE;
/*
$FILEINFO = array();
$_WHERE = '';
$_DIR = 'BOARD';
$_DIR_DELIM = $getBoardAdmin['ba_table'];
for($f=1; $f <= trim($getBoardAdmin['ba_file_cnt']); $f++){
$_FILENUM = 1;
$_FILENAME = 'bf_file_'.$f;
if($_FILES[$_FILENAME]['name'] != ''){
$getFileInfo = getValue('_BOARD_FILE', " where bf_idx = '".$bf_idx[$f]."' ", 'ar', 'bf_dir, bf_file');
@unlink($_SERVER['DOCUMENT_ROOT'].'/'.$getFileInfo['bf_dir'].'/'.$getFileInfo['bf_file']);
$FILEINFO['_UPLOADFILE']= fileUpload($_FILENAME, $_DIR, $_DIR_DELIM);
$FILEINFO['_DIR'] = '/UPLOAD/'.$_DIR.'/'.$_DIR_DELIM.'/';
$FILEINFO['_FILE'] = $FILEINFO['_UPLOADFILE'];
$FILEINFO['_FILE_ORG'] = $_FILES[$_FILENAME]['name'];
$FILEINFO['_FILE_SIZE'] = $_FILES[$_FILENAME]['size'];
if($getFileInfo['bf_file'] != ''){
$filesql = "
UPDATE
_BOARD_FILE
SET
bf_dir = '".$FILEINFO['_DIR']."'
, bf_file = '".$FILEINFO['_FILE']."'
, bf_file_org = '".$FILEINFO['_FILE_ORG']."'
, bf_file_size = '".$FILEINFO['_FILE_SIZE']."'
, bf_contents = ''
, bf_download = 0
, bf_regdate = now()
WHERE
bf_idx = '".$bf_idx[$f]."'
";
}else{
$filesql = "
INSERT INTO
_BOARD_FILE
SET
bf_board_id = '".$BCODE."'
, bf_board_idx = '".$thisKey."'
, bf_dir = '".$FILEINFO['_DIR']."'
, bf_file = '".$FILEINFO['_FILE']."'
, bf_file_org = '".$FILEINFO['_FILE_ORG']."'
, bf_file_size = '".$FILEINFO['_FILE_SIZE']."'
, bf_contents = ''
, bf_download = 0
, bf_rank = '".$f."'
, bf_regdate = now()
";
}
$filers = query($filesql);
$_FILENUM++;
}
}
*/
if($rs){
useExit('{"result":"Y","message":"성공적으로 수정 완료되었습니다.","url":"'.($_POST['RETURNURL'].'?BCODE='.$BCODE).'"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setBoardReply'){
$v_ar = explode('@|@|@|', $v);
$getBoardAdmin = getValue('_BOARD_ADMIN', " where ba_idx = '".$v_ar[0]."' ");
$info = getValue("_BOARD_".$getBoardAdmin['ba_table'], " where b_idx = '".$CODE."' ");
$info2 = getValue("_MEMBER", " where m_idx = '".$info['b_user_idx']."' ", 'ar', 'm_name');
$sql = "
UPDATE
_BOARD_".$getBoardAdmin['ba_table']."
SET
b_reply = '".trim(addslashes(setSqlFilter($v_ar[1])))."'
, b_reply_is = 'Y'
, b_reply_date = now()
WHERE
b_idx = '".$CODE."'
";
$rs = query($sql);
if($rs){
$sendMail = sendMail('jxforever1@naver.com', '플랜트파트너', '질문에 답변이 달렸습니다.' ,$v_ar[1], $info['b_email'], $info2['m_namez'], true);
useExit('{"result":"Y","message":"성공적으로 답변 완료되었습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_POST['dbControl'] == 'setBoardDel'){
//$getBoardAdmin = getValue('_BOARD_ADMIN', " where ba_idx = '".$v."' ");
/*
$fileSql = "select * from _BOARD_FILE where bf_board_idx = '".$CODE."' and bf_board_id = '".$getBoardAdmin['ba_idx']."' ";
$fileRs = query($fileSql);
if(rows() > 0){
for($f=0; $fileRow = assoc($fileRs); $f++){
@unlink($_SERVER['DOCUMENT_ROOT'].'/'.$fileRow['bf_dir'].'/'.$fileRow['bf_file']);
query("delete from _BOARD_FILE where bf_idx = '".$fileRow['bf_idx']."' ");
}
}
*/
//$sql = "delete from _BOARD_".$getBoardAdmin['ba_table']." where b_idx = '".$CODE."' ";
$sql = "delete from board where idx = '".$CODE."' ";
$rs = query($sql);
if($rs){
useExit('{"result":"Y","message":"성공적으로 삭제 완료되었습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl=="sendBoardPush")
{
//echoAr($_POST);
$BCODE=$_POST["v"];
$idx = $_POST["CODE"];
if ($BCODE=="1")
{
$noticeinfo = getValue("board"," where idx='".$idx."'","ar","*");
if($noticeinfo)
{
$sql = "select distinct m_regi, m_os from _MEMBER where m_regi !='' and m_notice_push='Y'";
$rs = query($sql);
if (rows()>0)
{
$andlist1 = array();
$andlist2 = array();
$andlist3 = array();
$andlist4 = array();
$andlist5 = array();
$ioslist1 = array();
$ioslist2 = array();
$ioslist3 = array();
$ioslist4 = array();
$ioslist5 = array();
for($i=0;$row=assoc($rs);$i++)
{
if($row["m_os"]=="android")
{
$andlist[] = $row["m_regi"];
}else if($row["m_os"]=="IOS"){
$ioslist[] = $row["m_regi"];
}
}
//echoAr($andlist);
for($i=0;count($andlist)>$i;$i++)
{
if($i>=0 && $i<1000)
{
$andlist1[] = $andlist[$i];
}else if ($i>=1000 && $i<2000)
{
$andlist2[] = $andlist[$i];
}else if ($i>=2000 && $i<3000)
{
$andlist3[] = $andlist[$i];
}else if ($i>=3000 && $i<4000)
{
$andlist4[] = $andlist[$i];
}else if ($i>=4000 && $i<5000)
{
$andlist5[] = $andlist[$i];
}
}
for($i=0;count($ioslist)>$i;$i++)
{
if($i>=0 && $i<1000)
{
$ioslist1[] = $ioslist[$i];
}else if ($i>=1000 && $i<2000)
{
$ioslist2[] = $ioslist[$i];
}else if ($i>=2000 && $i<3000)
{
$ioslist3[] = $ioslist[$i];
}else if ($i>=3000 && $i<4000)
{
$ioslist4[] = $ioslist[$i];
}else if ($i>=4000 && $i<5000)
{
$ioslist5[] = $ioslist[$i];
}
}
$msg["title"] = "notice";
$msg["type"] = "notice";
$msg["message"] = strip_tags($noticeinfo["contents"]);
$msg["sender_img"] = "";
$msg["msg_from"] = "1";
$msg["sender_nick"] = "관리자";
$msg["sender_gender"] = "";
$msg["room_idx"] = "";
$msg["idx"] = $idx;
//echoAr($andlist1);
if(count($andlist1)>0)
{
send_notification($andlist1,$msg);
}
if(count($andlist2)>0)
{
send_notification($andlist2,$msg);
}
if(count($andlist3)>0)
{
send_notification($andlist3,$msg);
}
if(count($andlist4)>0)
{
send_notification($andlist4,$msg);
}
if(count($andlist5)>0)
{
send_notification($andlist5,$msg);
}
if(count($ioslist1)>0)
{
send_notification_IOS($ioslist1,$msg);
}
if(count($ioslist2)>0)
{
send_notification_IOS($ioslist2,$msg);
}
if(count($ioslist3)>0)
{
send_notification_IOS($ioslist3,$msg);
}
if(count($ioslist4)>0)
{
send_notification_IOS($ioslist4,$msg);
}
if(count($ioslist5)>0)
{
send_notification_IOS($ioslist5,$msg);
}
}
useExit('{"result":"Y","message":"","url":"f5"}');
}else{
useExit('{"result":"N","message":"잘못된 게시물 입니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"공지사항만 푸시전송가능합니다.","url":"f5"}');
}
}
if($dbControl == 'getStartCheck'){
useExit('{"ver":"'.$getSiteSkin['di_ver'].'", "TIME":"'.date('Y-m-d H:i:s').'", "updateFile":"'.$getSiteSkin['di_update_file'].'", "terms":"'.$term['terms'].'", "personal_information":"'.$term['personal_information'].'", "di_logo_pc1":"'.$getSiteSkin['di_logo_pc1'].'", "di_logo_pc2":"'.$getSiteSkin['di_logo_pc2'].'"}');
}
if($dbControl == 'getNoticeList'){
$BCODE = 1;
$getBoardAdmin = getValue('_BOARD_ADMIN', " where ba_idx = '".$BCODE."' ");
$_WHERE = " WHERE 1 and b_site = '".$getSiteSkin['di_idx']."' ";
$_TAGS = "&BCODE=".$BCODE;
if($_REQUEST['keyword'] != '' && $_REQUEST['word'] != ''){
$_WHERE .= " AND ".$_REQUEST['keyword']." LIKE '%".$_REQUEST['word']."%' ";
$_TAGS .= '&keyword='.$_REQUEST['keyword'];
$_TAGS .= '&word='.$_REQUEST['word'];
}
$_TABLE = '_BOARD_'.$getBoardAdmin['ba_table'];
$_ORDER = 'ORDER BY b_idx DESC';
$onePageCount = $_POST['_onePageCount'] ? $_POST['_onePageCount'] : 20;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
FROM
".$_TABLE.$_WHERE.$_ORDER."
limit ".$offset.", ".$onePageCount
;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
//$row['code'] = $row['b_class'] == 'ALL' ? '전체' : getValue('_SETTING', " where s_class = '".$row['b_class']."' ", 's_name', 's_name');
//$row['title'] = '['.stripslashes($row['c_company_name']).']'.stripslashes($row['c_company_person']).':'.stripslashes($row['c_contents']);
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
//$json = '{"total":"0","maxpageno":"0","result":"N","message":"데이터 없음", "data":""}';
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($dbControl == 'setMemberPhotoUpdate'){
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
$oldInfo = getValue($_TB, " where m_idx = '".$memberInfo['m_idx']."' ", 'ar', 'm_photo');
$_WHERE .= photoUploadNew('m_photo', $_DIR, '_WHERE', $oldInfo['m_photo'], false);
$sql = "update ".$_TB." set modidate = now() ".$_WHERE." where m_idx in (".$memberInfo['m_idx'].") ";
$rs = query($sql);
$thisKey = $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 삭제하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'setMemberPhotoDel'){
$_WHERE = '';
$_DIR = 'MEMBER';
$_TB = '_'.$_DIR;
$oldFile = getValue($_TB, " where m_idx = '".$memberInfo['m_idx']."' ", 'ar', 'm_photo');
@unlink($_SERVER['DOCUMENT_ROOT'].$oldFile['m_photo']);
//$sql = "delete from ".$_TB." where m_idx in (".$memberInfo['m_idx'].") ";
$sql = "update ".$_TB." set m_photo = '' where m_idx in (".$memberInfo['m_idx'].") ";
$rs = query($sql);
$thisKey = $memberInfo['m_idx'];
if($rs){
useExit('{"result":"Y","message":"성공적으로 삭제하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'getMemberPhotoList'){
$_WHERE = " WHERE 1 and p_site = '".$getSiteSkin['di_idx']."' and p_user_idx = '".$memberInfo['m_idx']."' ";
$_TAGS = "&BCODE=".$BCODE;
if($_REQUEST['keyword'] != '' && $_REQUEST['word'] != ''){
$_WHERE .= " AND ".$_REQUEST['keyword']." LIKE '%".$_REQUEST['word']."%' ";
$_TAGS .= '&keyword='.$_REQUEST['keyword'];
$_TAGS .= '&word='.$_REQUEST['word'];
}
$_TABLE = '_PHOTO';
$_ORDER = 'ORDER BY p_idx DESC';
$onePageCount = 20;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
FROM
".$_TABLE.$_WHERE.$_ORDER."
limit ".$offset.", ".$onePageCount
;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
//$row['code'] = $row['b_class'] == 'ALL' ? '전체' : getValue('_SETTING', " where s_class = '".$row['b_class']."' ", 's_name', 's_name');
//$row['title'] = '['.stripslashes($row['c_company_name']).']'.stripslashes($row['c_company_person']).':'.stripslashes($row['c_contents']);
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
//$json = '{"total":"0","maxpageno":"0","result":"N","message":"데이터 없음", "data":""}';
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($dbControl == 'setMemberBoardRegi'){
$_WHERE = '';
$_DIR = 'BOARD_BOARD';
$_TB = '_'.$_DIR;
//$_WHERE .= photoUploadNew('p_photo', $_DIR, '_WHERE', '', false);
$sql = "
INSERT INTO
".$_TB."
SET
b_site = '".$getSiteSkin['di_idx']."'
, b_title = '".trim(addslashes(setSqlFilter($_POST['b_title'])))."'
, b_contents= '".trim(addslashes(setSqlFilter($_POST['b_contents'])))."'
, b_memo = '".trim(addslashes(setSqlFilter($_POST['b_memo'])))."'
, b_user_idx= '".trim(addslashes(setSqlFilter($memberInfo['m_idx'])))."'
, b_name = '".trim(addslashes(setSqlFilter($memberInfo['m_name'])))."'
, b_email = '".trim(addslashes(setSqlFilter($memberInfo['m_email'])))."'
, b_hp = '".trim(addslashes(setSqlFilter($memberInfo['m_hp'])))."'
, b_regdate = now()
, b_ip = '".$connectIP."'
, b_agent = '".$agent."'
".$_WHERE."
";
$rs = query($sql);
$thisKey= insert_id();
if($rs){
useExit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'setMemberBoardDel'){
$_WHERE = '';
$_DIR = 'BOARD_BOARD';
$_TB = '_'.$_DIR;
//$_WHERE .= photoUploadNew('p_photo', $_DIR, '_WHERE', '', false);
$sql = "delete from ".$_TB." where b_idx in (".$CODE.") ";
$rs = query($sql);
//$thisKey= insert_id();
if($rs){
useExit('{"result":"Y","message":"성공적으로 삭제하였습니다.","url":"'.$retrunUrl.'","MEMCODE":"'.$thisKey.'" }');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","MEMCODE":""}');
}
}
if($dbControl == 'getMemberBoardList'){
$_WHERE = " WHERE 1 and b_site = '".$getSiteSkin['di_idx']."' and b_user_idx = '".$memberInfo['m_idx']."' ";
$_TAGS = "&BCODE=".$BCODE;
if($_REQUEST['keyword'] != '' && $_REQUEST['word'] != ''){
$_WHERE .= " AND ".$_REQUEST['keyword']." LIKE '%".$_REQUEST['word']."%' ";
$_TAGS .= '&keyword='.$_REQUEST['keyword'];
$_TAGS .= '&word='.$_REQUEST['word'];
}
$_TABLE = '_BOARD_BOARD';
$_ORDER = 'ORDER BY b_idx DESC';
$onePageCount = 20;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
FROM
".$_TABLE.$_WHERE.$_ORDER."
limit ".$offset.", ".$onePageCount
;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
//$row['code'] = $row['b_class'] == 'ALL' ? '전체' : getValue('_SETTING', " where s_class = '".$row['b_class']."' ", 's_name', 's_name');
//$row['title'] = '['.stripslashes($row['c_company_name']).']'.stripslashes($row['c_company_person']).':'.stripslashes($row['c_contents']);
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
//$json = '{"total":"0","maxpageno":"0","result":"N","message":"데이터 없음", "data":""}';
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($dbControl == 'setrequestMacChangeUpdate'){
$info = getValue('_MAC_ADDR', "where m_idx = '".$_POST['CODE']."'" );
//$oldMemberMac = getValue('_MEMBER', "where m_idx = '".$info['m_idx']."'", 'm_hardware_no', 'm_hardware_no');
//echo "update cp_pay_request set mac = '".trim(addslashes($info['m_mac']))."' where m_idx = '".$info['m_user_idx']."' and p_class = '".$info['m_class']."' ";exit;
$rs = query("update _MEMBER set m_hardware_no = '".trim(addslashes($info['m_mac']))."' where m_idx = '".$info['m_user_idx']."' ");
if($rs){
//query("update cp_pay_request set mac = '".trim(addslashes($info['m_mac']))."' where mac = '".trim(addslashes($oldMemberMac))."' ");
query("update _MAC_ADDR set m_use_is = 'Y', m_com_date = now() where m_idx = '".$_POST['CODE']."' ");
useExit('{"result":"Y","message":"성공적으로 하드웨어 번호를 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setMemberUseChangeUpdate'){
$rs = query("update _MEMBER set m_profile_is = '".trim(addslashes(setSqlFilter($_POST['v'])))."' where m_idx = '".$_POST['CODE']."' ");
if($rs){
useExit('{"result":"Y","message":"성공적으로 상태를 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($dbControl == 'setMemberOutpriceChangeUpdate'){
$code_ar = explode('|', $_POST['CODE']);
$rs = query("update _OUT_PRICE set o_state_is = '".trim(addslashes(setSqlFilter($_POST['v'])))."' where o_idx = '".$code_ar[0]."' ");
if($rs){
query("update _PAYMENT set p_state = '".trim(addslashes(setSqlFilter($_POST['v'])))."' where p_idx = '".$code_ar[1]."' ");
useExit('{"result":"Y","message":"성공적으로 상태를 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'getChatData')
{
$c_idx = $_REQUEST["chatNum"];
$list = array();
$sql = "select * from chatting c join _PROFILE p on c.talker=p.p_m_idx where c.fn_chatR='".$c_idx."' and c.talker!='system' order by c.idx asc";
$rs = query($sql);
if(rows()>0)
{
for($i=0;$row=assoc($rs);$i++)
{
$list[$i] = $row;
$list[$i]["chattime"] = strtotime($row["regdate"]);
}
}
$jsonList = $list;
$json = json_encode( $jsonList);
useExit($json);
}
if($_REQUEST['dbControl'] == "setChkChatData")
{
$chatNum = $_REQUEST["chatNum"];
$lastdata = getValue("chatting"," where fn_chatR='".$chatNum."' order by regdate desc","ar","*");
if($lastdata)
{
$time = strtotime($lastdata["regdate"]);
$json = json_encode($time);
useExit($json);
}
}
if($_REQUEST['dbControl'] == "setChatBotData")
{
//echoAr($_REQUEST);
$fn_chatR = $_REQUEST["fn_chatR"];
$talker = $_REQUEST["m_idx"];
$comment = $_REQUEST["content"];
if(trim($comment)=="")
{
useExit('{"result":"N","message":"공백은 입력할 수 없습니다.","url":""}');
}
$isql = "insert into chatting set fn_chatR='".$fn_chatR."', talker='".$talker."', `comment`='".$comment."';";
//echo $isql;
$irs = query($isql);
if($irs)
{
$msgidx = insert_id();
$chatbotcomment_info = getValue("QA"," where question='".$comment."' and status='Y' order by answer_datetime desc", "ar","*");
if($chatbotcomment_info)
{
$chatbotcomment = $chatbotcomment_info["answer"];
}else{
$chatbotcomment = "알 수 없는 내용이네요.";
}
//질문에 대한 답변역시 입력한다.
$iisql = "insert into chatting set fn_chatR='".$fn_chatR."', talker='1', `comment`='".$chatbotcomment."'";
$iirs = query($iisql);
if ($iirs)
{
}
//푸시를 보내기 위해서 나를 제외한 채팅방인원을 가져온다.(1:1이므로 한개만 추출하도록 한다.)
//$tChatinfo = getValue("chatMember"," where fn_chatR='".$fn_chatR."' and fn_member !='".$talker."' and status in ('R','C','O')","ar","*");
//if($tChatinfo)
//{
//$fn_senderinfo = getValue("_MEMBER m left join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$tChatinfo["fn_member"]."' and m.m_chat_push='Y'","ar","*");
//if ($fn_senderinfo)
//{
//$message = $comment;
//$fn_chatRoom = $fn_chatR;
//}
useExit('{"result":"Y","url":"f5"}');
//}else{
// useExit('{"result":"N","message":"채팅을 보낼 인원이 없습니다.","url":""}');
//}
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == "setChatData")
{
$fn_chatR = $_REQUEST["fn_chatR"];
$talker = $_REQUEST["m_idx"];
$comment = $_REQUEST["content"];
if(trim($comment)=="")
{
useExit('{"result":"N","message":"공백은 입력할 수 없습니다.","url":""}');
}
$isql = "insert into chatting set fn_chatR='".$fn_chatR."', talker='".$talker."', `comment`='".$comment."';";
//echo $isql;
$irs = query($isql);
if($irs)
{
$msgidx = insert_id();
//푸시를 보내기 위해서 나를 제외한 채팅방인원을 가져온다.(1:1이므로 한개만 추출하도록 한다.)
$tChatinfo = getValue("chatMember"," where fn_chatR='".$fn_chatR."' and fn_member !='".$talker."' and status in ('R','C','O')","ar","*");
if($tChatinfo)
{
$fn_senderinfo = getValue("_MEMBER m left join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$tChatinfo["fn_member"]."' and m.m_chat_push='Y'","ar","*");
if ($fn_senderinfo)
{
$message = $comment;
$fn_chatRoom = $fn_chatR;
//1.상대방의 푸시여부 확인해서 보내기
if($fn_senderinfo["m_os"]=="android"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "chat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush($msg);
}else if($fn_senderinfo["m_os"]=="IOS"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "chat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush_IOS($msg);
}
}
useExit('{"result":"Y","url":"f5"}');
}else{
useExit('{"result":"N","message":"채팅을 보낼 인원이 없습니다.","url":""}');
}
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == "setChatImgData")
{
$fn_chatR = $_REQUEST["fn_chatR"];
$talker = $_REQUEST["m_idx"];
$comment = $_REQUEST["content"];
if(trim($comment)=="")
{
useExit('{"result":"N","message":"공백은 입력할 수 없습니다.","url":""}');
}
$isql = "insert into chatting set fn_chatR='".$fn_chatR."', talker='".$talker."', `comment`='".$comment."', talkerinfo='img';";
//echo $isql;
$irs = query($isql);
if($irs)
{
$msgidx = insert_id();
//푸시를 보내기 위해서 나를 제외한 채팅방인원을 가져온다.(1:1이므로 한개만 추출하도록 한다.)
$tChatinfo = getValue("chatMember"," where fn_chatR='".$fn_chatR."' and fn_member !='".$talker."' and status in ('R','C','O')","ar","*");
if($tChatinfo)
{
$fn_senderinfo = getValue("_MEMBER m left join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$tChatinfo["fn_member"]."' and m.m_chat_push='Y'","ar","*");
if ($fn_senderinfo)
{
$message = $comment;
$fn_chatRoom = $fn_chatR;
//1.상대방의 푸시여부 확인해서 보내기
if($fn_senderinfo["m_os"]=="android"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "chat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush($msg);
}else if($fn_senderinfo["m_os"]=="IOS"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "chat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush_IOS($msg);
}
}
useExit('{"result":"Y","url":"f5"}');
}else{
useExit('{"result":"N","message":"채팅을 보낼 인원이 없습니다.","url":""}');
}
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if ($_REQUEST['dbControl'] == 'setChatJoinOut')
{
$fn_chatR = $_REQUEST["v"];
$fn_member = $_REQUEST["CODE"];
$usql = "update chatMember set outdate=now(), status='O' where fn_chatR='".$fn_chatR."' and fn_member='".$fn_member."'";
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","url":"chat.siso"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if ($_REQUEST["dbControl"] == "setTalkBar")
{
//echoAr($_REQUEST);
$fn_member = $_POST["fn_member"];
$introduce = $_POST["contents"];
$tb_settime = $_POST["setTime"];
$tb_setchocolate = $_POST["setChocolate"];
//기본 설정은 되어야 생성가능
if ($tb_settime!=""&&$tb_settime!="0"&&$tb_setchocolate!=""&&$tb_setchocolate!="0")
{
//토킹바를 위한 채팅방을 생성한다.
$iisql = "insert into chatRoom set host='".$fn_member."', category='talkingbar', title='".$memberInfo["m_name"]." 토킹바 입니다.', contents='".$introduce."', memCount='1', status='Y' ";
$iirs = query($iisql);
if ($iirs)
{
$fn_chatR = insert_id();
$iiisql = "insert into chatMember set fn_chatR='".$fn_chatR."', fn_member='".$fn_member."', regdate=now(), status='R'";
$iiirs = query($iiisql);
if($iiirs)
{
$isql = "insert into talkingbar set fn_member='".$fn_member."', introduce='".$introduce."', tb_settime='".$tb_settime."', tb_setchocolate='".$tb_setchocolate."', tb_regdate=now(), chatNum='".$fn_chatR."'";
$irs = query($isql);
if($irs)
{
$tb_idx = insert_id();
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"talkbar.siso", "tb_idx":"'.$tb_idx.'"}');
}else{
exit('{"result":"N","message":"등록하는 도중 실패하였습니다.","url":"f5"}');
}
}
}else{
exit('{"result":"N","message":"채팅방 생성 도중 실패하였습니다.","url":"f5"}');
}
}else{
exit('{"result":"N","message":"시간 및 초콜릿은 기본생성이 되어야 합니다.","url":"f5"}');
}
}
if($_REQUEST['dbControl'] == "setTalkChatData")
{
//echoAr($_REQUEST);
$fn_chatR = $_REQUEST["fn_chatR"];
$talker = $_REQUEST["m_idx"];
$comment = $_REQUEST["content"];
if(trim($comment)=="")
{
useExit('{"result":"N","message":"공백은 입력할 수 없습니다.","url":""}');
}
$chatstatus = "Y";
//1. 토킹바 활성화여부를 확인한다.
$chkTalkBar = getValue("talkingbar"," where chatnum='".$fn_chatR."' and tb_status='Y' ","ar","*");
if($chkTalkBar)
{
if($chkTalkBar["tb_sdate"]!="0000-00-00 00:00:00")
{
$tbstime = strtotime($chkTalkBar["tb_sdate"]);
$maxetime = $tbstime+($chkTalkBar["tb_settime"]*60);
if(time()>=$maxetime)
{
$chatstatus = "N"; //채팅이 완료된 상황
}else{
$chatstatus = "Y"; //정상적으로 채팅하는 상황
}
}else{
$chatstatus = "Y"; //게스트혼자 채팅하는 상황
}
}else{
useExit('{"result":"N","message":"토킹바가 종료되었습니다.","url":"talkbar.siso"}');
}
//2. 채팅이 가능하지 않는경우 토킹바 방을 비우고 초콜릿을 분배한다.
if($chatstatus=="Y")
{
$isql = "insert into chatting set fn_chatR='".$fn_chatR."', talker='".$talker."', `comment`='".$comment."';";
//echo $isql;
//exit;
$irs = query($isql);
if($irs)
{
$msgidx = insert_id();
//푸시를 보내기 위해서 나를 제외한 채팅방인원을 가져온다.(1:1이므로 한개만 추출하도록 한다.)
$tChatinfo = getValue("chatMember"," where fn_chatR='".$fn_chatR."' and fn_member !='".$talker."' and status in ('R','C','O')","ar","*");
if($tChatinfo)
{
$fn_senderinfo = getValue("_MEMBER m left join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$tChatinfo["fn_member"]."' and m.m_chat_push='Y'","ar","*");
if ($fn_senderinfo)
{
$message = $comment;
$fn_chatRoom = $fn_chatR;
//1.상대방의 푸시여부 확인해서 보내기
if($fn_senderinfo["m_os"]=="android"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "talkchat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush($msg);
}else if($fn_senderinfo["m_os"]=="IOS"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "talkchat";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush_IOS($msg);
}
}
useExit('{"result":"Y","url":"f5"}');
}else{
useExit('{"result":"N","message":"채팅을 보낼 인원이 없습니다.","url":""}');
}
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}else{
$usql = "update talkingbar set tb_status='N', tb_edate='".date("Y-m-d H:i:s",$maxetime)."' where chatNum='".$fn_chatR."' and tb_idx='".$chkTalkBar["tb_idx"]."'";
$urs = query($usql);
if($urs)
{
$minuschoco = $chkTalkBar["tb_setchocolate"];
$pluschoco = ($minuschoco/2);
$hostidx = $chkTalkBar["fn_member"];
$usql = "update _MEMBER set m_chocolate=m_chocolate+".$pluschoco." where m_idx='".$hostidx."'";
$urs = query($usql);
if($urs)
{
$isql = "insert into pointHistory set fn_member='".$hostidx."', point_type='chocolate', point='".$pluschoco."', history_log='talkingbar_host', regdate=now()";
$irs = query($isql);
if($irs)
{
$uusql = "update chatMember set status='O', outdate=now() where fn_chatR='".$fn_chatR."' and fn_member='".$hostidx."'";
$uurs = query($uusql);
}else{
useExit('{"result":"N","message":"호스트 인원 정보 업데이트 도중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"호스트 인원 정보 업데이트 도중 오류가 발생했습니다.","url":"f5"}');
}
$guestinfo = getValue("chatRoom"," where host='".$hostidx."' and idx='".$fn_chatR."'","ar","*");
if($guestinfo)
{
$guestidx = $guestinfo["guest"];
$uusql = "update _MEMBER set m_chocolate=m_chocolate-".$minuschoco." where m_idx='".$guestidx."'";
$uurs = query($uusql);
if($uurs)
{
$isql = "insert into pointHistory set fn_member='".$guestidx."', point_type='chocolate', point='-".$minuschoco."', history_log='talkingbar_guest', regdate=now()";
$irs = query($isql);
if($irs)
{
$uusql = "update chatMember set status='O', outdate=now() where fn_chatR='".$fn_chatR."' and fn_member='".$guestidx."'";
$uurs = query($uusql);
}else{
useExit('{"result":"N","message":"게스트 인원 정보 업데이트 도중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"게스트 인원 정보 업데이트 도중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"잘못된 토킹바 인원입니다.","url":"f5"}');
}
useExit('{"result":"Y","message":"토킹바가 종료됩니다.","url":"talkbar.siso"}');
}else{
useExit('{"result":"N","message":"토킹바 업데이트 도중 오류가 발생했습니다.","url":"f5"}');
}
}
}
if($_REQUEST['dbControl'] == 'setTalkbarJoinOut')
{
$fn_chatR = $_REQUEST["v"]; //채팅 방번호
$fn_member = $_REQUEST["CODE"]; //나간 사람의 번호
//나간사람이 호스트인가? 게스트인가?
$talkbarinfo = getValue("talkingbar"," where chatNum='".$fn_chatR."'","ar","*",false);
if($talkbarinfo)
{
$chatRoom = getValue("chatRoom"," where idx='".$fn_chatR."'","ar","*");
if($chatRoom)
{
$hostinfo = getValue("_MEMBER"," where m_idx='".$chatRoom["host"]."'","ar","*");
$guestinfo = getValue("_MEMBER"," where m_idx='".$chatRoom["guest"]."'","ar","*");
}else{
}
//정상적으로 토킹바가 생성이 된것인지 확인
if ($talkbarinfo["tb_sdate"]!="0000-00-00 00:00:00") //정상 토킹바
{
//사용시간 계산
$chatstimeinfo = getValue("chatting"," where fn_chatR='".$fn_chatR."' and talker='1' order by regdate desc","ar","*");
if($chatstimeinfo)
{
$chatstime = strtotime($chatstimeinfo["regdate"]);
$chatmaxtime = $chatstime+($talkbarinfo["tb_settime"]*60);
$chatetime = time();
$setchocolate = $talkbarinfo["tb_setchocolate"];
//실제 채팅한 시간
$rchattime = ($chatmaxtime-$chatetime);
if($rchattime<=0) //채팅시간꽉채움
{
$minuschoco = $setchocolate;
$pluschoco = floor($setchocolate/2);
}else{
//몇분간 남았는가?
$lastchatmin = floor($rchattime/60); //남은 분
$usechatmin = ($talkbarinfo["tb_settime"]-$lastchatmin);
//분당 얼마짜리인가?
$usechatmin = floor($talkbarinfo["tb_setchocolate"]/$talkbarinfo["tb_settime"]);
$minuschoco = ($usechatmin*$usechatmin);
$rsetchocolate = ($setchocolate-$minuschoco);
$pluschoco = floor($rsetchocolate/2);
}
$usql = "update _MEMBER set m_chocolate=m_chocolate-".$minuschoco." where m_idx='".$chatRoom["guest"]."'";
$urs = query($usql);
if($urs)
{
$isql = "insert into pointHistory set fn_member='".$chatRoom["guest"]."', point_type='chocolate', point='-".$minuschoco."', history_log='talkingbar_guest', regdate=now()";
$irs = query($isql);
if($irs)
{
}else{
}
}else{
}
$usql = "update _MEMBER set m_chocolate=m_chocolate+".$pluschoco." where m_idx='".$chatRoom["host"]."'";
$urs = query($usql);
if($urs)
{
$isql = "insert into pointHistory set fn_member='".$chatRoom["host"]."', point_type='chocolate', point='".$pluschoco."', history_log='talkingbar_host', regdate=now()";
$irs = query($isql);
if($irs)
{
}else{
}
}else{
}
//토킹바 업데이트
$usql = "update talkingbar set tb_status='N' where tb_idx='".$talkbarinfo["tb_idx"]."'";
$urs = query($usql);
if($urs)
{
}else{
}
//방상태 업데이트
$usql = "update chatRoom set status='N' where idx='".$fn_chatR."'";
$urs = query($usql);
if($urs)
{
}else{
}
$usql = "update chatMember set outdate=now(), status='O' where fn_chatR='".$fn_chatR."'";
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
}else{ //비정상 토킹바(게스트 대기중이다 나감,방장이 안들어옴)
//1. 채팅방의 게스트 정보 초기화
$usql = "update chatRoom set guest='', memCount='1' where idx='".$fn_chatR."'";
$urs = query($usql);
if($urs)
{
//2. 채팅멤버 삭제
$dsql = "delete from chatMember where fn_chatR='".$fn_chatR."' and fn_member='".$fn_member."'";
$drs = query($dsql);
if($drs)
{
//3. 채팅 내역 삭제
$ddsql = "delete from chatting where fn_chatR='".$fn_chatR."'";
$ddrs = query($ddsql);
if($ddrs)
{
useExit('{"result":"Y","url":"/talkbar.siso"}');
}else{
}
}else{
}
}else{
}
}
}
}
if($_REQUEST['dbControl'] == 'getChatList'){
/*
$row = getValue('chatting_db._CHAT_ROOM AS A INNER JOIN sunny_db._MEMBER AS B ON A.cr_user_idx = B.m_idx', " WHERE cr_room_idx = ".$_POST['c_room_idx']." AND cr_user_idx <> ".$memberInfo['m_idx']." ");
exit('{"result":"Y","data":'.json_encode($row).'}');
*/
//$sql = "SELECT * FROM chatting_db._CHAT WHERE c_room_idx IN ( SELECT cr_room_idx from chatting_db._CHAT_ROOM WHERE cr_user_idx = ".$memberInfo['m_idx']." ) GROUP BY c_room_idx ORDER BY c_regdate desc";
//$roomIs = getValue('chatting_db._CHAT_ROOM', " WHERE cr_room_idx IN (SELECT cr_room_idx FROM chatting_db._CHAT_ROOM WHERE cr_user_idx = ".$_POST['host_user_idx'].") AND cr_user_idx = ".$_POST['guest_user_idx']." ");
/*
$bansql = "SELECT c_room_idx FROM chatting_db._CHAT where c_user_idx IN (select mb_target FROM sunny_db._MEMBER_BAN WHERE mb_user = ".$memberInfo['m_idx']." ) GROUP BY c_room_idx";
$banrs = query($bansql);
if(rows() > 0){
$banlist = Array();
for($j=0; $banrow = assoc($banrs); $j++){
$banlist[] = $banrow['c_room_idx'];
}
}
*/
if($_POST['friend_is']){
$_FRIENDSQL = " AND c_user_idx in (select mf_target from sunny_db._MEMBER_FRIEND where mf_user = '".$memberInfo['m_idx']."' ) ";
}else{
$_FRIENDSQL = '';
}
$sql = "SELECT * FROM (SELECT * FROM chatting_db._CHAT WHERE c_room_idx IN ( SELECT cr_room_idx from chatting_db._CHAT_ROOM WHERE cr_user_idx = ".$memberInfo['m_idx']." ) ".$_FRIENDSQL." ORDER BY c_regdate DESC ) AS A GROUP BY c_room_idx";
//echoAr($sql);
$rs = query($sql);
$cnt = rows();
if($cnt > 0){
$list = Array();
for($i=0; $row = assoc($rs); $i++){
//getValue('_MEMBER_BAN', " where mb_user = '".$memberInfo['m_idx']."' and ");
/*
if(in_array($row['c_room_idx'], $banlist, true)){
continue;
}
*/
$row['userRow'] = getValue('chatting_db._CHAT_ROOM AS A INNER JOIN sunny_db._MEMBER AS B ON A.cr_user_idx = B.m_idx', " WHERE cr_room_idx = ".$row['c_room_idx']." AND cr_user_idx <> ".$memberInfo['m_idx']." ");
$row['sum'] = getValue('chatting_db._CHAT', " where c_room_idx = '".$row['c_room_idx']."' and c_user_idx <> '".$memberInfo['m_idx']."' ", 'sum', 'SUM(c_read_cnt) AS sum', false);
$list[] = $row;
}
$jsonList = array('total'=> $cnt, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($_POST['dbControl'] == 'setTalkRegi'){
$_WHERE = '';
$_DIR = 'TALK';
$_TB = '_'.$_DIR;
if($_FILES['t_img']['name'] == ''){
$oldInfo = getValue($_TB, " where t_user_idx = '".$memberInfo['m_idx']."' ", 'ar', 't_img, t_idx');
@unlink($_SERVER['DOCUMENT_ROOT'].$oldInfo['t_img']);
$_WHERE .= ", t_img = '' ";
}else{
$oldInfo = getValue($_TB, " where t_user_idx = '".$memberInfo['m_idx']."' ", 'ar', 't_img, t_idx');
$_WHERE .= photoUploadNew('t_img', $_DIR, '_WHERE', $oldInfo['t_img'], false);
}
if($oldInfo['t_idx']){
$sql = "
update
".$_TB."
set
t_site = '".$getSiteSkin['di_idx']."'
, t_content = '".trim(addslashes(setSqlFilter($_POST['t_content'])))."'
, t_modifydate = now()
".$_WHERE."
where
t_idx = '".$oldInfo['t_idx']."'
";
$rs = query($sql);
$_MENT = '수정';
}else{
$sql = "
insert into
".$_TB."
set
t_site = '".$getSiteSkin['di_idx']."'
, t_user_idx = '".trim(addslashes(setSqlFilter($memberInfo['m_idx'])))."'
, t_content = '".trim(addslashes(setSqlFilter($_POST['t_content'])))."'
, t_regdate = now()
, t_modifydate = now()
".$_WHERE."
";
$rs = query($sql);
$lastid = insert_id();
$_MENT = '등록';
}
if($rs){
useExit('{"result":"Y","message":"성공적으로 '.$_MENT.' 완료되었습니다.","url":"'.$_POST['RETURNURL'].'"}');
}else
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
if($dbControl == 'getTalkList'){
$_WHERE = " WHERE 1 ";
$_TAGS = "";
$_HAVING = "";
$_DISTANCE = ", 0 AS distance ";
if($_REQUEST['word'] != ''){
$_WHERE .= " AND (B.m_nick LIKE '%".$_REQUEST['word']."%' or A.t_content LIKE '%".$_REQUEST['word']."%') ";
}
if($_REQUEST['x'] && $_REQUEST['y']){
$_DISTANCE = " ,round( 6371 * acos( cos( radians('".$_REQUEST['x']."') ) * cos( radians( B.m_x ) ) * cos( radians( B.m_y ) - radians('".$_REQUEST['y']."') ) + sin( radians('".$_REQUEST['x']."') ) * sin( radians( B.m_x ) ) ) ,2) AS distance";
}
if($_REQUEST['TYPE'] == 'AREA'){
$_HAVING = " having distance < 40 and distance >= 20 ";
}elseif($_REQUEST['TYPE'] == 'TOWN'){
$_HAVING = " having distance < 20 and distance >= 10 ";
}elseif($_REQUEST['TYPE'] == 'NEIGHBORHOOD') {
$_HAVING = " having distance <= 5 and distance >= 0 ";
}elseif($_REQUEST['TYPE'] == 'MYTALK'){
$_WHERE .= ' AND A.t_user_idx ="'.$memberInfo['m_idx'].'"';
}
$_TABLE = '_TALK as A inner join _MEMBER as B ON A.t_user_idx = B.m_idx';
$_ORDER = 'ORDER BY distance DESC, t_regdate desc';
$onePageCount = 20;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
".$_DISTANCE."
FROM
".$_TABLE.$_WHERE.$_HAVING.$_ORDER."
limit ".$offset.", ".$onePageCount
;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
//$json = '{"total":"0","maxpageno":"0","result":"N","message":"데이터 없음", "data":""}';
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($_REQUEST['dbControl'] == 'setChattingPhotoUpload'){
$_WHERE = '';
$_DIR = 'chatfile';
$_WHERE .= photoUploadNew('chattingImg', $_DIR, '_FILE', '', false);
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","file":"'.$_WHERE.'"}');
if($rs){
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setChattingMovieUpload'){
$_WHERE = '';
$_DIR = 'CHATTING';
$_WHERE1 .= photoUploadNew('chattingThum', $_DIR, '_FILE', '', false);
$_WHERE2 .= photoUploadNew('chattingmovie', $_DIR, '_FILE', '', false);
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","thum":"'.$_WHERE1.'","movie":"'.$_WHERE2.'"}');
if($rs){
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'getNotReadAllSum'){
$sum = getValue("chatting_db._CHAT", " where c_room_idx IN (SELECT cr_room_idx FROM chatting_db._CHAT_ROOM WHERE cr_user_idx = ".$memberInfo['m_idx'].") AND c_user_idx <> ".$memberInfo['m_idx']." ", 'sum', 'SUM(c_read_cnt) AS sum', 0);
exit('{"result":"Y","sum":"'.(int)$sum.'"}');
}
if($_REQUEST['dbControl'] == 'setNoteSend'){
$banIs = getValue('sunny_db._MEMBER_BAN', " WHERE (mb_user = ".$_POST['host_user_idx']." OR mb_target =".$_POST['host_user_idx'].") AND (mb_user = ".$_POST['guest_user_idx']." OR mb_target =".$_POST['guest_user_idx'].")", 'mb_idx', 'mb_idx');
if($banIs){
exit('{"result":"N","message":"[쪽지발송불가]차단된 회원입니다."}');
}
if(getAllPointSum($memberInfo['m_idx']) < _NOTE_POINT){
exit('{"result":"N","message":"포인트가 부족합니다.\n충전후 이용하시기 바랍니다.", "cnt":"", "url":""}');
}else{
$pointSave = setPoint('-', $memberInfo['m_idx'], (int)str_replace(',','',_NOTE_POINT), 'Y', '쪽지 발송 차감');
}
$roomIs = getValue('chatting_db._CHAT_ROOM', " WHERE cr_room_idx IN (SELECT cr_room_idx FROM chatting_db._CHAT_ROOM WHERE cr_user_idx = ".$_POST['host_user_idx'].") AND cr_user_idx = ".$_POST['guest_user_idx']." ");
if($roomIs['cr_room_idx']){
$roomNumber = $roomIs['cr_room_idx'];
}else{
$maxRoom = getValue('chatting_db._CHAT_ROOM', " WHERE 1 order by cr_room_idx desc limit 1 ", 'cr_room_idx', 'ifnull( max( cast(cr_room_idx as unsigned) ) , 0) + 1 AS cr_room_idx');
query("INSERT INTO chatting_db._CHAT_ROOM set cr_room_idx = '".$maxRoom."', cr_user_idx = '".$_POST['host_user_idx']."', cr_class = 'host', cr_regdate = now() ");
query("INSERT INTO chatting_db._CHAT_ROOM set cr_room_idx = '".$maxRoom."', cr_user_idx = '".$_POST['guest_user_idx']."' , cr_class = 'guest', cr_regdate = now() ");
$roomNumber = $maxRoom;
}
$rs = query("
insert into
chatting_db._CHAT
set
c_room_idx = '".$roomNumber."'
, c_user_idx = '".$_POST['user_idx']."'
, c_msg_type = '".trim(addslashes(setSqlFilter($_POST['msg_type'])))."'
, c_msg = '".trim(addslashes(setSqlFilter($_POST['c_msg'])))."'
, c_read_cnt = 1
, c_regdate = now();
");
if($rs){
$pushkey = getValue('sunny_db._MEMBER', " where m_idx in ( SELECT cr_user_idx FROM chatting_db._CHAT_ROOM WHERE cr_room_idx = ".$roomNumber." AND cr_user_idx <> ".$_POST['user_idx']." ) ", 'm_fcm', 'm_fcm');
if(trim(addslashes(setSqlFilter($_POST['msg_type']))) == 'text'){
$contents = trim(addslashes(setSqlFilter($_POST['msg_type'])));
}elseif(trim(addslashes(setSqlFilter($_POST['msg_type']))) == 'movie'){
$contents = '동영상이 도착했습니다.';
}else{
$contents = '사진이 도착했습니다.';
}
//membersearchquery = "SELECT FROM ";
$membersearchrow = getValue('sunny_db._MEMBER', " WHERE m_idx = '".$_POST['user_idx']."' ", 'ar', " *,round( 6371 * acos( cos( radians('".$_POST['x']."') ) * cos( radians( m_x ) ) * cos( radians( m_y ) - radians('".$_POST['y']."') ) + sin( radians('".$_POST['x']."') ) * sin( radians( m_x ) ) ) ,2) AS distance " );
$message = Array('type'=>'chat', 'title'=>'새로운 메시지가 도착했습니다.', 'body'=>$contents, 'user_idx'=>$_POST['user_idx'], 'user_info'=>$membersearchrow);
fcm_push($message, _PUSH_KEY, $pushkey);
exit('{"result":"Y","message":"성공적으로 발송 완료되었습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setMassagePointPresent'){
$room_idx = $_POST['room_idx'];
$user_idx = $_POST['user_idx'];
$guest_idx = $_POST['guest_idx'];
$banIs = getValue('sunny_db._MEMBER_BAN', " WHERE (mb_user = ".$user_idx." OR mb_target =".$user_idx.") AND (mb_user = ".$guest_idx." OR mb_target =".$guest_idx.")", 'mb_idx', 'mb_idx');
if($banIs){
exit('{"result":"N","message":"[쪽지발송불가]차단된 회원입니다."}');
}
$point = str_replace(',', '', $_POST['POINT']);
$pontSend = str_replace(',', '', $_POST['POINT']*0.85);
$pontAdmin = str_replace(',', '', $_POST['POINT']*0.15);
if(getAllPointSum($memberInfo['m_idx']) < $point){
exit('{"result":"N","message":"포인트가 부족합니다.\n충전후 이용하시기 바랍니다.", "cnt":"", "url":""}');
}else{
$username = getValue('_MEMBER', " where m_idx = '".$user_idx."' ", 'ar', 'm_id, m_idx, m_nick');
$guestname = getValue('_MEMBER', " where m_idx = '".$guest_idx."' ", 'ar', 'm_id, m_idx, m_nick');
$pointSave = setPoint('-', $user_idx, (int)str_replace(',','',$point), 'Y', $guestname['m_nick'].' 회원에게 포인트 선물 차감');
$pointSave = setPoint('+', $guest_idx, (int)str_replace(',','',$pontSend), 'Y', $username['m_nick'].' 회원에게 포인트 선물 받음');
$pointSave = setPoint('+', 1, (int)str_replace(',','',$pontAdmin), 'Y', ' 회원간 포인트 선물', ($username['m_nick'].'|'.$guestname['m_nick'].'|'.$room_idx));
$user_c_msg = $guestname['m_nick'].' 회원님에게 '.setOutput($point, 'money').' 포인트를 선물 하였습니다.';
$guest_c_msg = $username['m_nick'].' 회원님에게 '.setOutput($pontSend, 'money').' 포인트를 선물 받으셨습니다.';
/*
$rs = query("
insert into
chatting_db._CHAT
set
c_room_idx = '".$room_idx."'
, c_user_idx = '".$user_idx."'
, c_msg_type = 'present'
, c_msg = '".trim(addslashes(setSqlFilter($user_c_msg)))."'
, c_read_cnt = 1
, c_regdate = now();
");
$rs = query("
insert into
chatting_db._CHAT
set
c_room_idx = '".$room_idx."'
, c_user_idx = '".$guest_idx."'
, c_msg_type = 'present'
, c_msg = '".trim(addslashes(setSqlFilter($guest_c_msg)))."'
, c_read_cnt = 1
, c_regdate = now();
");
*/
exit('{"result":"Y","message":"성공적으로 발송 완료되었습니다."}');
if($rs){
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
}
if($_REQUEST['dbControl'] == 'setNoteDel'){
$rs = query("delete from chatting_db._CHAT where c_room_idx = '".$_POST['room_idx']."'");
if($rs){
query("delete from chatting_db._CHAT_ROOM where cr_room_idx = '".$_POST['room_idx']."'");
exit('{"result":"Y","message":"성공적으로 삭제 하였습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setNoteAllRead'){
$rs = query(" UPDATE chatting_db._CHAT set c_read_cnt = c_read_cnt-1 where c_room_idx = ".$_POST['room_idx']." and c_user_idx <> ".$_POST['user_idx']." and c_read_cnt > 0 ");
if($rs){
exit('{"result":"Y","message":"성공적으로 처리 하였습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setNoteAllDel'){
$sql = "select * from chatting_db._CHAT_ROOM where cr_user_idx = '".$_POST['user_idx']."' ";
$rs = query($sql);
if(rows() > 0){
$no = 0;
for($i=0; $row = assoc($rs); $i++){
query("delete from chatting_db._CHAT where c_room_idx = '".$row['cr_room_idx']."'");
query("delete from chatting_db._CHAT_ROOM where cr_room_idx = '".$row['cr_room_idx']."'");
$no++;
}
}
if($no > 0){
exit('{"result":"Y","message":"성공적으로 삭제 하였습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setNoteAllAllRead'){
$sql = "select * from chatting_db._CHAT_ROOM where cr_user_idx = '".$_POST['user_idx']."' ";
$rs = query($sql);
if(rows() > 0){
$no = 0;
for($i=0; $row = assoc($rs); $i++){
query(" UPDATE chatting_db._CHAT set c_read_cnt = c_read_cnt-1 where c_room_idx = ".$row['cr_room_idx']." and c_user_idx <> ".$_POST['user_idx']." and c_read_cnt > 0 ");
$no++;
}
}
if($no > 0){
exit('{"result":"Y","message":"성공적으로 읽음 처리 하였습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setMemberBanRegi'){
$ck = getValue('_MEMBER_BAN', " where mb_user = '".$_POST['user_idx']."' and mb_target = '".$_POST['target_idx']."' ", 'mb_idx', 'mb_idx' );
if($ck){
$rs = query("delete from _MEMBER_BAN where mb_user = '".$_POST['user_idx']."' and mb_target = '".$_POST['target_idx']."' ");
$ment = ' 차단 취소';
}else{
$rs = query("
insert into
_MEMBER_BAN
set
mb_user = '".$_POST['user_idx']."'
, mb_target = '".$_POST['target_idx']."'
, mb_regdate = now();
");
$ment = ' 차단';
}
if($rs){
exit('{"result":"Y","message":"성공적으로 '.$ment.'되었습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'getMemberBanCheck'){
$banIs = getValue('sunny_db._MEMBER_BAN', " WHERE (mb_user = ".$_POST['host_user_idx']." OR mb_target =".$_POST['host_user_idx'].") AND (mb_user = ".$_POST['guest_user_idx']." OR mb_target =".$_POST['guest_user_idx'].")", 'mb_idx', 'mb_idx');
if($banIs){
exit('{"result":"Y"}');
}else{
exit('{"result":"N"}');
}
}
if($_REQUEST['dbControl'] == 'setChatDeclareSend'){
$rs = query("
insert into
_CHAT_DECLARE
set
cd_user_idx = '".$_POST['cd_user_idx']."'
, cd_guest_idx = '".$_POST['cd_guest_idx']."'
, cd_room_idx = '".$_POST['cd_room_idx']."'
, cd_contents = '".trim(addslashes(setSqlFilter($_POST['cd_contents'])))."'
, cd_regdate = now();
");
if($rs){
exit('{"result":"Y","message":"성공적으로 신고 접수 되었습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'getShopUrl'){
exit('{"url":"'.trim(addslashes($getSiteSkin['di_shop_url'])).'"}');
}
if($_REQUEST['dbControl'] == 'getPopImg'){
exit('{"img":"'.trim(addslashes($getSiteSkin['di_loding_img'])).'", "loding_img_is":"'.trim(addslashes($getSiteSkin['di_loding_img_is'])).'"}');
}
if($_REQUEST['dbControl'] == 'setMemberFriendRegi'){
$ck = getValue('_MEMBER_FRIEND', " where mf_user = '".$_POST['user_idx']."' and mf_target = '".$_POST['target_idx']."' ", 'mf_idx', 'mf_idx' );
if($ck){
$rs = query("delete from _MEMBER_FRIEND where mf_user = '".$_POST['user_idx']."' and mf_target = '".$_POST['target_idx']."' ");
$ment = ' 친구제외 완료';
}else{
$rs = query("
insert into
_MEMBER_FRIEND
set
mf_user = '".$_POST['user_idx']."'
, mf_target = '".$_POST['target_idx']."'
, mf_regdate = now();
");
$ment = ' 친구신청이 완료';
}
if($rs){
exit('{"result":"Y","message":"성공적으로 '.$ment.'되었습니다."}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_POST['dbControl'] == 'setAndroidINAPPPayment'){
//$memberInfo = getValue('_MEMBER', "where 1 and m_idx = '".$MEMIDX."' ", 'ar', 'm_expire_datetime');
$pay_type = "android";
$fn_member = $_REQUEST["fn_member"]; //충전하는 회원번호
$orderID = $_REQUEST["orderID"]; //주문아이디
$purchasetime = $_REQUEST["purchasetime"]; //결제시간
$signature = $_REQUEST["signature"]; //기본값
$token = $_REQUEST["token"]; //결제 토큰
$sku = $_REQUEST["packageName"]; //값
$purchasePrice = $_REQUEST["purchasePrice"]; //결제 금액
$productId = $_REQUEST["productId"]; //상품 고유 값
$p_info = $_REQUEST["p_info"]; //전체 결제 내역(json)
switch($productId)
{
case "buy_ticket_3month" : $purchasePrice = "51000"; break;
case "buy_ticket_1month" : $purchasePrice = "21000"; break;
case "buy_chocolate_300" : $purchasePrice = "37000"; break;
case "buy_chocolate_200" : $purchasePrice = "27000"; break;
case "buy_chocolate_100" : $purchasePrice = "14000"; break;
case "buy_chocolate_30" : $purchasePrice = "3900"; break;
}
$sql = " insert into payInfo SET pay_type='".$pay_type."', fn_member = '".setSqlFilter($fn_member)."', orderID = '".setSqlFilter($orderID)."', purchasetime = '".$purchasetime."', signature = '".setSqlFilter($signature)."', token = '".setSqlFilter($token)."', sku = '".setSqlFilter($sku)."', purchasePrice = '".setSqlFilter($_POST['purchasePrice'])."', p_info='".$p_info."', regdate = now()";
//echoAr($sql);
$rs = query($sql);
if($rs){
$charge_chocolate = 0;
$payInfoIdx = insert_id();
$usql = "update _MEMBER set ";
//구독 여부 확인
if(in_array($productId,array("buy_ticket_3month","buy_ticket_1month")))
{
$m_inapp_subsrc = "Y";
$pointType = "ticket";
$meminfo = getValue("_MEMBER"," where m_idx='".$fn_member."'","ar","*");
if($productId=="buy_ticket_3month")
{
if($meminfo["m_ticket"]=="yes")
{
$m_ticket_edatetime = (strtotime($meminfo["m_ticket_edatetime"])+(90*86400));
}else{
$m_ticket_edatetime = (time()+(90*86400));
}
}else if($productId=="buy_ticket_1month")
{
if($meminfo["m_ticket"]=="yes")
{
$m_ticket_edatetime = (strtotime($meminfo["m_ticket_edatetime"])+(30*86400));
}else{
$m_ticket_edatetime = (time()+(30*86400));
}
}
$usql .= "m_inapp_subsrc='".$m_inapp_subsrc."', m_ticket='yes', m_ticket_sdatetime='".date("Y-m-d H:i:s")."', m_ticket_edatetime='".date("Y-m-d H:i:s",$m_ticket_edatetime)."'";
}else{
$pointType = "chocolate";
//초콜릿 구매일경우 회원정보에 초콜릿 내용
if($productId=="buy_chocolate_300")
{
$charge_chocolate = 350;
}else if($productId=="buy_chocolate_200")
{
$charge_chocolate = 230;
}else if ($productId=="buy_chocolate_100")
{
$charge_chocolate = 110;
}else if ($productId=="buy_chocolate_30")
{
$charge_chocolate = 30;
}
$usql .= "m_chocolate=m_chocolate+".$charge_chocolate;
}
$usql .= " where m_idx='".$fn_member."'";
$urs = query($usql);
if($urs)
{
//pointHistory 입력
$isql = "insert into pointHistory set fn_member='".$fn_member."', stackType='S', fn_payInfo='".$payInfoIdx."', point_type='".$pointType."', point='".$charge_chocolate."', history_log='".$productId."', regdate=now()";
$irs = query($isql);
if($irs)
{
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"item_mag.siso", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"f5"}');
}
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"f5"}');
}
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
if($_POST['dbControl'] == 'setIOSINAPPPayment'){
//echoAr($_REQUEST);
$pay_type = "IOS";
$fn_member = $_REQUEST["idx"]; //충전하는 회원번호
$orderID = $_REQUEST["productIdentifier"]; //주문아이디
$purchasetime = date("Y-m-d H:i:s"); //결제시간
$signature = $_REQUEST["signature"]; //기본값
$token = $_REQUEST["quantity"]; //결제 토큰
$sku = $_REQUEST["code"]; //값
$productId = $_REQUEST["code"]; //상품 고유 값
$p_info = $_REQUEST["applicationUsername"]."|".$_REQUEST["idx"]."|".$_REQUEST["code"]."|".$_REQUEST["productIdentifier"]."|".$_REQUEST["simulatesAskToBuyInSandbox"]."|".$_REQUEST["quantity"]."|".$_REQUEST["action"]."|".$_REQUEST["name"]; //전체 결제 내역(json)
switch($productId)
{
case "buy_ticket_3month" : $purchasePrice = "51000"; break;
case "buy_ticket_1month" : $purchasePrice = "21000"; break;
case "buy_chocolate_300" : $purchasePrice = "37000"; break;
case "buy_chocolate_200" : $purchasePrice = "27000"; break;
case "buy_chocolate_100" : $purchasePrice = "14000"; break;
case "buy_chocolate_30" : $purchasePrice = "3900"; break;
}
$sql = " insert into payInfo SET pay_type='".$pay_type."', fn_member = '".setSqlFilter($fn_member)."', orderID = '".setSqlFilter($orderID)."', purchasetime = '".setSqlFilter($purchasetime)."', signature = '".setSqlFilter($signature)."', token = '".setSqlFilter($token)."', sku = '".setSqlFilter($sku)."', purchasePrice = '".setSqlFilter($_POST['purchasePrice'])."', p_info='".$p_info."', regdate = now()";
//echoAr($sql);
//echo $sql;
//exit;
$rs = query($sql);
if($rs){
$charge_chocolate = 0;
$payInfoIdx = insert_id();
$usql = "update _MEMBER set ";
//구독 여부 확인
if(in_array($productId,array("buy_ticket_3month","buy_ticket_1month")))
{
$pointType = "ticket";
$meminfo = getValue("_MEMBER"," where m_idx='".$fn_member."'","ar","*");
if($productId=="buy_ticket_3month")
{
if($meminfo["m_ticket"]=="yes")
{
$m_ticket_edatetime = (strtotime($meminfo["m_ticket_edatetime"])+(90*86400));
}else{
$m_ticket_edatetime = (time()+(90*86400));
}
}else if($productId=="buy_ticket_1month")
{
if($meminfo["m_ticket"]=="yes")
{
$m_ticket_edatetime = (strtotime($meminfo["m_ticket_edatetime"])+(30*86400));
}else{
$m_ticket_edatetime = (time()+(30*86400));
}
}
$usql .= "m_ticket='yes', m_ticket_sdatetime='".date("Y-m-d H:i:s")."', m_ticket_edatetime='".date("Y-m-d H:i:s",$m_ticket_edatetime)."'";
}else{
$pointType = "chocolate";
//초콜릿 구매일경우 회원정보에 초콜릿 내용
if($productId=="buy_chocolate_300")
{
$charge_chocolate = 350;
}else if($productId=="buy_chocolate_200")
{
$charge_chocolate = 230;
}else if ($productId=="buy_chocolate_100")
{
$charge_chocolate = 110;
}else if ($productId=="buy_chocolate_30")
{
$charge_chocolate = 30;
}
$usql .= "m_chocolate=m_chocolate+".$charge_chocolate;
}
$usql .= " where m_idx='".$fn_member."'";
$urs = query($usql);
if($urs)
{
//pointHistory 입력
$isql = "insert into pointHistory set fn_member='".$fn_member."', stackType='S', fn_payInfo='".$payInfoIdx."', point_type='".$pointType."', point='".$charge_chocolate."', history_log='".$productId."', regdate=now()";
$irs = query($isql);
if($irs)
{
//echo "";
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"item_mag.siso", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"f5"}');
}
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"f5"}');
}
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
if($_POST["dbControl"] == "chgPointToChocolate")
{
$m_idx = $_REQUEST["CODE"];
$point = $_REQUEST["v"];
$m_point = ($point/5);
//echoAr($_REQUEST);
$usql = "update _MEMBER set m_point=m_point-".$point.", m_chocolate=m_chocolate+".$m_point." where m_idx='".$m_idx."' ";
$urs = query($usql);
if($urs)
{
$isql = "insert into pointHistory set fn_member='".$m_idx."', stackType='C', point_type='chocolate', point='".$m_point."', history_log='charge_point_to_chocolate', regdate=now()";
$irs = query($isql);
if($irs)
{
exit('{"result":"Y","message":"전환성공하였습니다.","url":"item_mag.siso","point":"'.$m_point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
if($_POST['dbControl'] == 'setPointINAPPPayment'){
$MEMIDX = $_POST['p_user_idx'];// ? $_POST['CODE'] : $_POST['idx'];
//$memberInfo = getValue('_MEMBER', "where 1 and m_idx = '".$MEMIDX."' ", 'ar', 'm_expire_datetime');
$sql = "
insert into
_PAYMENT
SET
p_site = '".$getSiteSkin['di_idx']."'
, p_user_idx = '".setSqlFilter($memberInfo['m_idx'])."'
, p_state = '".setSqlFilter('Y')."'
, p_orderid = '".setSqlFilter($_POST['p_orderid'])."'
, p_token = '".setSqlFilter($_POST['p_token'])."'
, p_product = '".setSqlFilter($_POST['productId'])."'
, p_method = '".setSqlFilter('INAPP')."'
, p_pay_data_info = '".setSqlFilter($_POST['p_pay_data_info'])."'
, p_market = '".setSqlFilter($_POST['p_market'])."'
, pdat_price = '".setSqlFilter(str_replace(',','',$_POST['price']))."'
, pdat_price_real = '".setSqlFilter(str_replace(',','',$_POST['price']))."'
, p_pay_datetime = '".setSqlFilter($_POST['purchasetime'])."'
, p_point = '".setSqlFilter((int)str_replace(',','',$_POST['p_point']))."'
, p_regdate = now()
";
//echoAr($sql);
$rs = query($sql);
if($rs){
$pointSave = setPoint('+', $memberInfo['m_idx'], (int)str_replace(',','',$_POST['p_point']), 'Y', '포인트 결제 획득');
$point = getAllPointSum($memberInfo['m_idx']);
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"'.$retrunUrl.'", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
if($_POST['dbControl'] == 'getMyPointSearch'){
$point = getAllPointSum($memberInfo['m_idx']);
exit('{"result":"Y", "point":"'.$point.'"}');
}
if($_POST['dbControl'] == 'setMemberAttendance'){
$ck = getValue('_MEMBER_ATTENDANCE', " where DATE_FORMAT(ma_regdate, '%Y-%m-%d') = curdate() and ma_user_idx = '".setSqlFilter($memberInfo['m_idx'])."' ", 'ar', 'ma_regdate');
if($ck['ma_regdate']){
exit('{"result":"N","message":"'.$ck['ma_regdate'].'에 이미 출석체크를 진해하였습니다.\n내일 다시 출석체크 하시길 바랍니다.","url":"","point":""}');
}else{
$sql = "
insert into
_MEMBER_ATTENDANCE
SET
ma_site = '".$getSiteSkin['di_idx']."'
, ma_user_idx = '".setSqlFilter($memberInfo['m_idx'])."'
, ma_point = '".setSqlFilter(_ATTENDANCE_POINT)."'
, ma_regdate = now()
";
$rs = query($sql);
if($rs){
$pointSave = setPoint('+', $memberInfo['m_idx'], (int)str_replace(',','',_ATTENDANCE_POINT), 'Y', '출석체크 차감');
$point = getAllPointSum($memberInfo['m_idx']);
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"'.$retrunUrl.'", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
}
if($_POST['dbControl'] == 'setMovieProfileView'){
$ck = getValue('_MEMBER_MOVIE_VIEW', " where DATE_FORMAT(mmv_regdate, '%Y-%m-%d') < DATE_ADD(curdate(), INTERVAL +2 DAY) and mmv_user_idx = '".setSqlFilter($memberInfo['m_idx'])."' ", 'ar', 'mmv_regdate');
if($ck['mmv_regdate']){
exit('{"result":"Y","message":"","url":"","point":""}');
}else{
$sql = "
insert into
_MEMBER_MOVIE_VIEW
SET
mmv_site = '".$getSiteSkin['di_idx']."'
, mmv_user_idx = '".setSqlFilter($memberInfo['m_idx'])."'
, mmv_target_idx = '".setSqlFilter($_POST['target_idx'])."'
, mmv_point = '".setSqlFilter(_PROFILE_VIEW_POINT)."'
, mmv_regdate = now()
";
$rs = query($sql);
$IDX = insert_id();
if($rs){
if(getAllPointSum($memberInfo['m_idx']) < _PROFILE_VIEW_POINT){
exit('{"result":"N","message":"포인트가 부족합니다.\n충전후 이용하시기 바랍니다.", "cnt":"", "url":""}');
}else{
$pointSave = setPoint('-', $memberInfo['m_idx'], (int)str_replace(',','',_PROFILE_VIEW_POINT), 'Y', '영상프로필 열람 차감');
$pointSave = setPoint('+', $_POST['target_idx'], (int)str_replace(',','',_PROFILE_VIEW_TARGET_POINT), 'Y', '영상프로필 열람 획득');
$pointSave = setPoint('+', 1, (int)str_replace(',','',_PROFILE_VIEW_TARGET_POINT), 'Y', '영상프로필 열람으로 관리자 획득', ('MOVIE|'.$IDX));
$point = getAllPointSum($memberInfo['m_idx']);
}
exit('{"result":"Y","message":"성공적으로 등록하였습니다.","url":"'.$retrunUrl.'", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
}
if($_REQUEST['dbControl'] == 'getCalculate'){
exit('{"calculateIS":"'.trim(addslashes($getSiteSkin['di_calculate_is'])).'"}');
}
if($_POST['dbControl'] == 'setOutpriceSave'){
$pointJson = setPoint('-', $memberInfo['m_idx'], (int)str_replace(',','',$_POST['POINT']), 'W', '출금 요청');
$pointAr = json_decode($pointJson, true);
if($pointAr['CODE']){
$sql = "
insert into
_OUT_PRICE
SET
o_payment_idx = '".$pointAr['CODE']."'
, o_user_idx = '".setSqlFilter($memberInfo['m_idx'])."'
, o_site = '".$getSiteSkin['di_idx']."'
, o_bank_name = '".setSqlFilter($_POST['o_bank_name'])."'
, o_bank_number = '".setSqlFilter($_POST['o_bank_number'])."'
, o_name = '".setSqlFilter($_POST['o_name'])."'
, o_price = '".setSqlFilter($_POST['POINT'])."'
, o_regdate = now()
";
$rs = query($sql);
$IDX = insert_id();
$point = getAllPointSum($memberInfo['m_idx']);
exit('{"result":"Y","message":"성공적으로 출금 요청 하였습니다.","url":"'.$retrunUrl.'", "point":"'.$point.'"}');
}else{
exit('{"result":"N","message":"일시적 오류입니다.","url":"","point":""}');
}
}
if($_POST['dbControl'] == 'getMemberDisLgoin'){
$_WHERE = '';
if($_POST['_GENDER']){
$_WHERE .= " and m_sex = '".$_POST['_GENDER']."' ";
}
if($_POST['_TYPE'] == 'distance'){
$_DISTANCE = " ,round( 6371 * acos( cos( radians('".$_REQUEST['x']."') ) * cos( radians( m_x ) ) * cos( radians( m_y ) - radians('".$_REQUEST['y']."') ) + sin( radians('".$_REQUEST['x']."') ) * sin( radians( m_x ) ) ) ,2) AS distance";
$sql = "select m_idx ".$_DISTANCE." from _MEMBER where m_idx <> '".$memberInfo['m_idx']."' ".$_WHERE." order by distance asc limit 25 ";
}else{
$sql = "select m_idx from _MEMBER where m_idx <> '".$memberInfo['m_idx']."' ".$_WHERE." order by m_lastlogin desc limit 15 ";
}
$rs = query($sql);
$cn = rows();
if($cn > 0){
$list = Array();
for($i=0; $row = assoc($rs); $i++){
$list[] = $row;
}
$jsonList = array('total'=> $cn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if($_POST['dbControl'] == 'setStatusUpdate'){
$oldInfo = getValue('_KEYWORD_NEWDB_STATE', " where kns_code = '".$_POST['CODE']."' and kns_user_idx = '".$memberInfo['m_idx']."' ", 'ar', 'kns_idx');
if($oldInfo['kns_idx']){
$sql = "
UPDATE
_KEYWORD_NEWDB_STATE
SET
kns_state = '".$_POST['v']."'
, kns_lastdate = now()
WHERE
kns_idx = '".$oldInfo['kns_idx']."'
";
}else{
$sql = "
insert into
_KEYWORD_NEWDB_STATE
SET
kns_code = '".$_POST['CODE']."'
, kns_user_idx = '".setSqlFilter($memberInfo['m_idx'])."'
, kns_state = '".$_POST['v']."'
, kns_regdate = now()
";
}
$rs = query($sql);
if($rs){
useExit('{"result":"Y","message":"성공적으로 상태 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}
if($_REQUEST['dbControl'] == 'setGestPWChange'){
if($_REQUEST['pwpwpw']){
$sql = "
UPDATE
_MEMBER
SET
m_pw = '".$_REQUEST['pwpwpw']."'
WHERE
m_idx = '3'
";
$rs = query($sql);
if($rs){
useExit('{"result":"Y","message":"성공적으로 비번 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":""}');
}
}else{
useExit('{"result":"N","message":"신규 비번을 넣어주세요.('.getValue('_MEMBER', " where m_idx = '3' ", 'm_pw', 'm_pw').')","url":""}');
}
}
if($_POST['dbControl'] == 'setPurchageBankSMSSendNplace'){
$memberInfo = getValue("_MEMBER"," where m_idx='".$_SESSION["_IDX"]."'","ar","*");
if(trim(addslashes(setSqlFilter($memberInfo['m_idx']))) == '') useExit('{"result":"N","message":"[필수값 누락]로그인한 회원만 가능합니다.\n먼저 로그인을 진행해주시기 바랍니다.","url":"/login.siso","key":""}');
if(trim(addslashes(setSqlFilter($memberInfo['m_hp']))) == '') useExit('{"result":"N","message":"[필수값 누락]전화번호 정보가 존재하지 않습니다.","url":"","key":""}');
//$settingInfo = getValue('_SETTING', " where s_class = '".$_POST['CLASS']."' and s_domain = '".$getSiteSkin['di_idx']."' ", 'ar', 's_storeparm_url, s_price, s_name, s_idx');
//$stroeurl = $settingInfo['s_storeparm_url'];
//$price = $settingInfo['s_price'];
$stroeurl = "";
//echoAr($_POST);
$price = $_POST['price'];
//$per = $commission[$_PARTNER_IDX][$settingInfo['s_idx']];
$per = $_PARTNER_ID != 'coreplanet' ? ($price/2) : 0;
//$per = ($partnerInfo['p_permission']);
$money = $price*1.1;
$oldinfo = getValue('cp_pay_request', " where m_idx = '".$memberInfo['m_idx']."' and p_class = '".trim(addslashes(setSqlFilter($_POST['CLASS'])))."' ", 'ar', 'idx, pay_state, expire_datetime');
if(strtotime($oldinfo['expire_datetime']) > time()){
//if($oldinfo['pay_state'] == 4){
useExit('{"result":"N","message":"이미 결제 회원이십니다.\n감사합니다.","url":"'.$returnURL.'"}');
}
if($oldinfo['idx']){
$oldinfo2 = getValue('cp_pay_request', " where m_idx = '".$_POST['MEMCODE']."' /*and lite_is = '".$liteis."'*/ and p_class = '".trim(addslashes(setSqlFilter($_POST['CLASS'])))."' and date_format(expire_datetime, '%Y-%m-%d') < curdate() ", 'ar', 'idx, pay_state, expire_datetime');
if($oldinfo['expire_datetime'] != '0000-00-00 00:00:00' && $oldinfo2['idx']){
$qry = "
INSERT INTO
cp_pay_request
SET
pversion = 'Y'
, c_site = '".$getSiteSkin['di_idx']."'
, name = '".trim(addslashes(setSqlFilter($memberInfo['m_name'])))."'
, seller = '".trim(addslashes(setSqlFilter(($_PARTNER_ID))))."'
/*, mac = '".trim(addslashes(setSqlFilter($memberInfo['m_hardware_no'])))."'*/
, reg_date = now()
, recvphone = '".trim(addslashes(setSqlFilter(str_replace('-', '', $memberInfo['m_hp']))))."'
, permission = '".trim(addslashes(setSqlFilter($per ? str_replace(',', '', $per) : 0)))."'
/*, lite_is = '".trim(addslashes(setSqlFilter($liteis)))."'*/
, pay_payment_class = '".trim(addslashes(setSqlFilter('BANK')))."'
, m_idx = '".trim(addslashes(setSqlFilter($memberInfo['m_idx'])))."'
, pay_class = '".trim(addslashes(setSqlFilter('프로그램구매')))."'
, price = '".trim(addslashes(setSqlFilter(str_replace(',', '', $price))))."'
, p_class = '".trim(addslashes(setSqlFilter($_POST['CLASS'])))."'
";
$rs = query($qry);
$bf_idx = insert_id(); //bf_req last index
query("update cp_pay_request set group_no = '".$bf_idx."', total_price = '".str_replace(',', '', $price)."' where idx = '".$bf_idx."' ");
}else{
$qry = "update cp_pay_request set permission = '".($per ? str_replace(',', '', $per) : 0)."', /*lite_is = '".$liteis."',*/ pay_payment_class = 'BANK' WHERE idx = '".$oldinfo['idx']."' ";
$rs = query($qry);
$bf_idx = $oldinfo['idx'];
}
}else{
$qry = "
INSERT INTO
cp_pay_request
SET
pversion = 'Y'
, c_site = '".$getSiteSkin['di_idx']."'
, name = '".trim(addslashes(setSqlFilter($memberInfo['m_name'])))."'
, seller = '".trim(addslashes(setSqlFilter(($_PARTNER_ID))))."'
, reg_date = now()
, recvphone = '".trim(addslashes(setSqlFilter(str_replace('-', '', $memberInfo['m_hp']))))."'
, permission = '".trim(addslashes(setSqlFilter($per ? str_replace(',', '', $per) : 0)))."'
, pay_payment_class = '".trim(addslashes(setSqlFilter('BANK')))."'
, m_idx = '".trim(addslashes(setSqlFilter($memberInfo['m_idx'])))."'
, pay_class = '".trim(addslashes(setSqlFilter('프로그램구매')))."'
, price = '".trim(addslashes(setSqlFilter(str_replace(',', '', $price))))."'
, p_class = '".trim(addslashes(setSqlFilter($_POST['CLASS'])))."'
";
//echo $qry;
//exit;
$rs = query($qry);
$bf_idx = insert_id(); //bf_req last index
query("update cp_pay_request set group_no = '".$bf_idx."', total_price = '".str_replace(',', '', $price)."' where idx = '".$bf_idx."' ");
}
if($rs){
/*
include_once $_SERVER['DOCUMENT_ROOT'].'/lib/sms/apitool/class/json.class.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/lib/sms/apitool/config.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/lib/sms/apitool/class/result_code.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/lib/sms/apitool/class/now_sms_send.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/lib/sms/apitool/curl/curl.php';
*/
//$smsmsg = "[".$settingInfo['s_name']."]기업은행\n518-057804-01-010\n주)코어플라넷 이주하\n".setOutput($money,'money')."원";
$smsmsg = "[Nplace]기업은행\n518-057804-01-010\n주)코어플라넷 이주하\n".setOutput($money,'money')."원";
$sms_from = '16444726';
$sms_to = str_replace('-', '', $memberInfo['m_hp']);
/*
$data = new now_sms_send;
$caller = str_replace('-', '', $sms_from);
$toll = str_replace('-', '', $sms_to);
$smsmsg = addslashes($smsmsg);
if($type_set == ''){
$type_set = '-1';
}
$sendrs = $data->set($caller, $toll, $smsmsg, 1, $subject, $type = $type_set );
//echoAr($sendrs);
if($sendrs[0]==true){
$result = $data->send();
if($result == '발송성공'){
useExit('{"result":"Y","message":"계좌정보가 성공적으로 발송하였습니다.\n입금후 고객센터로 연락주시기 바랍니다. ","url":"'.$returnURL.'"}');
}else{
useExit('{"result":"N","message":"계좌정보 발송에 에러가 발생하였습니다.\n원인 : '.$result.'","url":"'.$returnURL.'"}');
}
}else{
useExit('{"result":"N","message":"'.$sendrs[1].'","url":"'.$returnURL.'"}');
}
useExit('{"result":"Y","message":"","url":"","key":"'.$thisKey.'"}');
*/
//pusankjs 문자 모듈 수정[2019-01-02]
$smssend = socketPost(_SMS_SEND_URL.'/lib/sms.send.siso', '&httpsRedirect=N&sms_from='.$sms_from.'&sms_to='.$sms_to.'&smsmsg='.$smsmsg);
$resultAr = json_decode($smssend, true);
if($resultAr['result'] == 'Y'){
useExit('{"result":"Y","message":"계좌정보가 성공적으로 발송하였습니다.\n입금후 고객센터로 연락주시기 바랍니다. ","url":"'.$returnURL.'"}');
}else{
useExit('{"result":"'.$resultAr['result'].'","message":"'.$resultAr['message'].'","url":"'.$resultAr['url'].'"}');
}
}else{
useExit('{"result":"N","message":"일시적 오류입니다.","url":"","key":""}');
}
}
if($_POST['dbControl'] == 'setPurchageCardPaymentNplace'){
$memberInfo = getValue("_MEMBER"," where m_idx='".$_SESSION["_IDX"]."'","ar","*");
if(trim(addslashes(setSqlFilter($memberInfo['m_idx']))) == '') useExit('{"result":"N","message":"[필수값 누락]로그인한 회원만 가능합니다.\n먼저 로그인을 진행해주시기 바랍니다.","url":"/login.siso","key":""}');
//if(trim(addslashes(setSqlFilter($memberInfo['m_hp']))) == '') useExit('{"result":"N","message":"[필수값 누락]전화번호 정보가 존재하지 않습니다.","url":"","key":""}');
//$settingInfo = getValue('_SETTING', " where s_class = '".$_POST['CLASS']."' ", 'ar', 's_storeparm_url, s_price, s_name');
$oldinfo = getValue('cp_pay_request', " where m_idx = '".$memberInfo['m_idx']."' and p_class = '".trim(addslashes(setSqlFilter($_POST['CLASS'])))."' and pay_state = 4 ", 'ar', 'idx, expire_datetime');
//if($oldinfo['idx']){
if(strtotime($oldinfo['expire_datetime']) > time()){
useExit('{"result":"N","message":"해당 상품은 이미 구매하신 상품입니다.","url":"","key":""}');
}else{
$PRICE = $_POST["PRICE"];
if ($PRICE==500000)
{
$PRODUCTNAME = "Nplace_yesterday";
}else{
$PRODUCTNAME = "Nplace_today";
}
if ($_SERVER["REMOTE_ADDR"]=="1.212.218.28")
{
$PRODUCTNAME = "Nplace_yesterday";
$PRICE = 100;
}
$RPRICE = ($PRICE*1.1);
useExit('{"result":"Y","message":"","url":"","key":"'.$thisKey.'","PRODUCTNAME":"'.$PRODUCTNAME.'","PRICE":"'.$RPRICE.'"}');
}
}
$TB_S = "_SIDO";
$TB_K = "_KEYWORD";
$TB_SK = "_SIDO_KEYWORD";
$TB_V = "_VMACHINE";
$TB_KN = "_KEYWORD_NEWDB";
$TB_KNS = "_KEYWORD_NEWDB_STATE";
if ($_REQUEST["dbControl"] == "setSidoKeyword")
{
$sql = "select * from ".$TB_S." order by idx ";
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$sido[] = $row;
}
}
$ksql = "select * from ".$TB_K." order by idx ";
$krs = query($ksql);
if(rows() > 0){
for($i=0; $krow = assoc($krs); $i++){
$keyword[] = $krow;
}
}
$insertcnt = 0;
for($i=0;count($sido)>$i;$i++)
{
for($j=0;count($keyword)>$j;$j++)
{
$isql = "insert into ".$TB_SK." set bunru='".$sido[$i]["bunru"]."', keyword='".$keyword[$j]["keyword"]."', regdate=now();";
query($isql);
$insertcnt++;
}
}
echo $insertcnt."개 입력";
}
if ($_REQUEST["dbControl"] == "setSidoKeywordCnt")
{
$bunru = $_REQUEST["bunru"];
$keyword = $_REQUEST["keyword"];
$searchcnt = $_REQUEST["searchcnt"];
$usql = "update ".$TB_SK." set search_cnt = ".$searchcnt.", moddate=now() where bunru='".$bunru."' and keyword='".$keyword."'";
$urs = query($usql);
if ($urs)
{
useExit('{"result":"Y","message":"성공적으로 변경하였습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 입력중 오류가 발생했습니다.","url":"f5"}');
}
}
if ($_REQUEST["dbControl"] == "getSidoKeywordList")
{
$_WHERE = " where keyword in ('음식점','네일','미용','쇼핑','학원','카페','부동산','인테리어') ";
//$_WHERE = " where active='Y' ";
$_ORDER = " order by sk_idx ";
$onePageCount = 1000;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
$total = getValue($TB_SK, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
$sql =
"
SELECT
*
FROM
".$TB_SK.$_WHERE.$_ORDER."
limit ".$offset.", ".$onePageCount
;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
$list[] = $row;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$jsonList = array('total'=> $total, 'maxpageno'=>$toalPageCn, 'result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode( $jsonList);
}else{
$jsonList = array('total'=> 0, 'maxpageno'=>0, 'result'=>'N', 'message'=>'데이터 없음', 'data'=>'');
$json = json_encode( $jsonList);
}
if($view == 'ar')
echoAr($jsonList);
else
useExit($json);
}
if ($_REQUEST["dbControl"] == "getSidoKeywordarrayCNT")
{
$_WHERE = " where active='Y' and search_cnt<=2500 and search_cnt>0";
$_ORDER = " order by sk_idx ";
$sql = "SELECT * FROM ".$TB_SK.$_WHERE.$_ORDER;
//echo $sql;
$rs = query($sql);
if(rows() > 0){
$listcnt = 0;
$keywordcnt = 0;
$prev_cnt=0;
$bunrutext = "";
$keywordarry = array();
for($i=0; $row = assoc($rs); $i++){
if ($row["search_cnt"]+$prev_cnt<=2500)
{
$prev_cnt = $prev_cnt+$row["search_cnt"];
$keywordarry[$keywordcnt] = $row["keyword"];
$keywordcnt++;
if ($bunrutext!="")
{
if ($bunrutext==$row["bunru"])
{
$bunrutext = $row["bunru"];
}else{
$list[$listcnt]["bunru"] = $bunrutext;
$list[$listcnt]["keywords"] = implode(",",$keywordarry);
$list[$listcnt]["search_cnt"] = $prev_cnt;
$listcnt++;
$prev_cnt=0;
$bunrutext = "";
$keywordcnt=0;
}
}else{
$bunrutext = $row["bunru"];
}
}else{
$prev_cnt=0;
$keywordcnt=0;
}
}
}
//echoAr($list);
$jsonList = array('result'=>'Y', 'message'=>'', 'total'=>$listcnt,'data'=>$list);
$json = json_encode($jsonList);
useExit($json);
}
if ($_REQUEST["dbControl"] == "setkeywordserverally")
{
$_WHERE = " where active='Y' and servernum=0 ";
$_ORDER = " order by sk_idx ";
$sql = "SELECT * FROM ".$TB_SK.$_WHERE.$_ORDER;
$rs = query($sql);
$servernum = 1;
$searchcnt = 0;
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
if($searchcnt<=2500)
{
$searchcnt = $searchcnt + $row["search_cnt"];
}else{
$searchcnt = 0;
$servernum++;
}
$usql = "update ".$TB_SK." set active='Y', servernum=".$servernum." where sk_idx=".$row["sk_idx"];
$urs = query($usql);
}
}
echo $servernum;
}
if ($_REQUEST["dbControl"] == "setkeywordserverally2")
{
$_WHERE = " where active='N' and servernum=0 and search_cnt<2500 and search_cnt>0 and keyword in ('음식점','네일','미용') ";
$_ORDER = " order by search_cnt ";
$sql = "SELECT * FROM ".$TB_SK.$_WHERE.$_ORDER;
$rs = query($sql);
$servernum = 137;
$searchcnt = 0;
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
if($searchcnt<=2500)
{
$searchcnt = $searchcnt + $row["search_cnt"];
}else{
$searchcnt = 0;
$servernum++;
}
$usql = "update ".$TB_SK." set active='Y', servernum=".$servernum." where sk_idx=".$row["sk_idx"];
$urs = query($usql);
}
}
echo $servernum;
}
//키워드 분배작업 동적키워드(구분자|), 한 서버 배정수 받아서 분배작업 2019.08.01 by zero
if ($_REQUEST["dbControl"] == "setkeywordserverally3")
{
$keyword_arry = explode("|",$_REQUEST["keyword"]);
$servermaxnum = $_REQUEST["servermaxnum"];
$serverminnum = $_REQUEST["serverminnum"];
$servertotalcnt = $_REQUEST["servertotalcnt"];
$usql = "update ".$TB_SK." set active='N', servernum=0 WHERE active='Y' AND servernum>=0 ";
//echo $usql;
//exit;
query($usql);
$_WHERE = " where search_cnt<".$servermaxnum." and search_cnt>".$serverminnum." and keyword in ('".implode("','",$keyword_arry)."') ";
$_ORDER = " order by search_cnt desc";
$sql = "SELECT * FROM ".$TB_SK.$_WHERE.$_ORDER;
//echo $sql;
//exit;
$rs = query($sql);
$servernum = 1;
$searchcnt = 0;
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$list1[$i]["sk_idx"] = $row["sk_idx"];
$list1[$i]["keyword"] = $row["keyword"];
$list1[$i]["servernum"] = $servernum;
$list1[$i]["search_cnt"] = $row["search_cnt"];
if ($servertotalcnt<$servernum)
{
break;
}else{
$usql = "update ".$TB_SK." set active='Y', servernum=".$servernum." where sk_idx=".$row["sk_idx"];
query($usql);
$servernum++;
}
}
}
//echoAr($list1);
if (count($list1)>0)
{
for($i=0;count($list1)>$i;$i++)
{
$servernum1 = $list1[$i]["servernum"];
//echo $list1[$i]["search_cnt"]."
";
if($servermaxnum-$list1[$i]["search_cnt"]>=$serverminnum)
{
$sql1 = "select * from ".$TB_SK." where active='N' and search_cnt <= ".($servermaxnum-$list1[$i]["search_cnt"])." and search_cnt >= ".$serverminnum." and servernum = 0 and keyword in ('".implode("','",$keyword_arry)."') order by search_cnt desc limit 0,1";
//echo $sql1."
";
$rs1 = query($sql1);
if(rows() > 0)
{
for($j=0;$row1 = assoc($rs1);$j++)
{
$list2[$j]["sk_idx"] = $row1["sk_idx"];
$list2[$j]["keyword"] = $row1["keyword"];
$list2[$j]["servernum"] = $row1["servernum"];
$list2[$j]["search_cnt"] = $row1["search_cnt"];
if ($servertotalcnt<$servernum1)
{
break;
}else{
$usql1 = "update ".$TB_SK." set active='Y', servernum=".$servernum1." where sk_idx=".$row1["sk_idx"];
query($usql1);
$servernum1++;
}
}
}
}
}
}
//echoAr($list2);
echo "ok";
//echo $servernum;
}
if ($_REQUEST["dbControl"] == "setVmachine")
{
$servernum = $_REQUEST["servernum"];
$sql = "select * from ".$TB_SK." where active='Y' and servernum='".$servernum."' order by sk_idx";
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$fullkeyword[] = $row["bunru"].$row["keyword"];
}
}
$usql = "update ".$TB_V." set keywords='".implode(",",$fullkeyword)."' where uuid='".$servernum."'";
$urs = query($usql);
echo "OK";
}
if ($_REQUEST["dbControl"] == "setVmachines")
{
$totservernum = $_REQUEST["totservernum"];
if ($totservernum=="")
{
$totservernum = 100;
}
//echo $totservernum;
//exit;
//검색갯수가 0개인것은 상태값과 젠서버 숫자를 초기화 시킨다.
$usql = "update ".$TB_SK." set active='N', servernum=0 where active='Y' and search_cnt=0";
$urs = query($usql);
for($servernum=1;$totservernum>=$servernum;$servernum++)
{
$sql = "select * from ".$TB_SK." where active='Y' and servernum='".$servernum."' order by sk_idx";
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$fullkeyword[] = $row["bunru"].$row["keyword"];
}
}
$usql = "update ".$TB_V." set keywords='".implode(",",$fullkeyword)."' where uuid='".$servernum."'";
//echo $usql."
";
$urs = query($usql);
$fullkeyword=array();
}
echo $servernum." OK";
}
if ($_REQUEST["dbControl"] == "getVmachineList")
{
$sql = "select * from ".$TB_V." order by uuid desc";
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$list[] = $row;
}
}
$jsonList = array('result'=>'Y', 'message'=>'', 'data'=>$list);
$json = json_encode($jsonList);
useExit($json);
}
if ($_REQUEST["dbControl"] == "chkKeywordPlaceId")
{
$id = $_REQUEST["id"];
$kn_sid = "s".$id;
$keyword = $_REQUEST["keyword"];
$knsinfo = getValue($TB_KNS," where kns_code='".$id."'","ar","*");
if ($knsinfo["kns_code"])
{
$usql = "update ".$TB_KNS." set kns_lastdate=now() where kns_idx='".$knsinfo["kns_idx"]."'";
$urs = query($usql);
if ($urs)
{
$kninfo = getValue($TB_KN," where kn_sid='".$kn_sid."' and kn_keyword='".$keyword."'","ar","*");
if ($kninfo["kn_idx"])
{
//수정한 아이디 중심으로 현재일자와 비교해서 알려준다.
$kn_editdatetime = strtotime($kninfo["kn_editdate"]);
if (date("Ymd")>date("Ymd",$kn_editdatetime))
{
$jsonList = array('result'=>'Y', 'message'=>'금일데이터가 아닙니다.', 'data'=>$kninfo);
}else{
$jsonList = array('result'=>'N', 'message'=>'금일데이터입니다.');
}
}else{
$jsonList = array('result'=>'Y', 'message'=>'없는 가게 정보입니다.', 'data'=>'');
}
}else{
$jsonList = array('result'=>'N', 'message'=>'업데이트 도중 오류가 발생했습니다.');
}
}else{
$isql = "insert into ".$TB_KNS." set kns_code='".$id."', kns_user_idx='1', kns_regdate=now() ";
$irs = query($isql);
if ($irs)
{
$kninfo = getValue($TB_KN," where kn_sid='".$kn_sid."' and kn_keyword='".$keyword."'","ar","*");
if ($kninfo["kn_idx"])
{
//수정한 아이디 중심으로 현재일자와 비교해서 알려준다.
$kn_editdatetime = strtotime($kninfo["kn_editdate"]);
if (date("Ymd")>date("Ymd",$kn_editdatetime))
{
$jsonList = array('result'=>'Y', 'message'=>'금일데이터가 아닙니다.', 'data'=>$kninfo);
}else{
$jsonList = array('result'=>'N', 'message'=>'금일데이터입니다.');
}
}else{
$jsonList = array('result'=>'Y', 'message'=>'없는 가게 정보입니다.', 'data'=>'');
}
}else{
$jsonList = array('result'=>'N', 'message'=>'인서트 도중 오류가 발생했습니다.');
}
}
$json = json_encode($jsonList);
useExit($json);
}
if($_REQUEST["dbControl"] == "setKeywordPlaceId")
{
$kn_sid = "s".$_REQUEST["code"]; //고유코드
$kn_category = $_REQUEST["category"]; //분류
$kn_name = $_REQUEST["name"]; //업체명
$kn_address = $_REQUEST["address"]; //등록주소
$kn_teldisplay = $_REQUEST["tel"]; //전화번호
$kn_url = $_REQUEST["site_url"]; //주소검색
$kn_banned = $_REQUEST["banned"]; //지도에서 노출유무(0:노출,1:실패)
$kn_checked = "1"; //확인유무(0:미확인,1:확인)
$kn_keyword = $_REQUEST["keyword"]; //검색키워드
$kn_editdate = $_REQUEST["editdate"]; //수정일자
$kn_editdatearry = explode(".",$kn_editdate);
$kn_editdatetime = mktime(0,0,0,$kn_editdatearry[1],$kn_editdatearry[2],$kn_editdatearry[0]);
$kn_regdate = $_REQUEST["lastModified"]; //실제 네이버에서 갱신된 일자
if ($kn_regdate == "")
{
$kn_regdate = "now()";
}else{
//$kn_regdate = "'".$kn_regdate."'";
$kn_regdate = "now()";
}
$kninfo = getValue($TB_KN," where kn_sid='".$kn_sid."' ","ar","*");
if ($kninfo["kn_idx"])
{
//지도 노출이 되었는지 확인
if ($kn_banned=="0")
{
$usql = "update ".$TB_KN." set kn_sid='".$kn_sid."', kn_category='".$kn_category."', kn_name='".$kn_name."', kn_address='".$kn_address."', kn_teldisplay='".$kn_teldisplay."', kn_url='".$kn_url."', kn_banned='".$kn_banned."' , kn_checked='".$kn_checked."', kn_keyword='".$kn_keyword."'";
if (date("Ymd",$kn_editdatetime) == date("Ymd",strtotime($kninfo["kn_editdate"])))
{
}else{
$usql .= ", kn_editdate='".date("Y-m-d",$kn_editdatetime)." 00:00:00' ";
}
$usql .= "where kn_idx='".$kninfo["kn_idx"]."'";
}else{
$usql = "update ".$TB_KN." set kn_banned='".$kn_banned."', kn_checked='0' where kn_idx='".$kninfo["kn_idx"]."'";
}
$urs = query($usql);
if($urs)
{
$jsonList = array('result'=>'Y', 'message'=>'정보가 갱신되었습니다.');
}else{
$jsonList = array('result'=>'N', 'message'=>'인서트 오류가 발생했습니다.');
}
}else{
$isql = "insert into ".$TB_KN." set kn_sid='".$kn_sid."', kn_category='".$kn_category."', kn_name='".$kn_name."', kn_address='".$kn_address."', kn_teldisplay='".$kn_teldisplay."', kn_url='".$kn_url."', kn_banned='".$kn_banned."', kn_checked='".$kn_checked."', kn_keyword='".$kn_keyword."', kn_regdate=".$kn_regdate.", kn_editdate='".date("Y-m-d",$kn_editdatetime)." 00:00:00' ";
$irs = query($isql);
if ($irs)
{
$jsonList = array('result'=>'Y', 'message'=>'정보가 갱신되었습니다.');
}else{
$jsonList = array('result'=>'N', 'message'=>'인서트 오류가 발생했습니다.');
}
}
$json = json_encode($jsonList);
useExit($json);
}
//호감도 증가하게 하는 내역 2020-02-11 by zero
if($dbControl == "setLikePoint1")
{
$m_idx = $_SESSION["_IDX"];
$t_idx = $_REQUEST["CODE"];
$ml_type = "ml_photo"; //사진이 마음에 드는 점수근거
$ml_point = $_REQUEST["v"];
$chkinfo = getValue("member_like"," where m_idx='".$m_idx."' and t_idx='".$t_idx."' and ml_type='".$ml_type."'");
if($chkinfo)
{
//$usql = "update member_like set ml_point='".$ml_point."' where ml_idx='".$ml_idx."'";
$rml_point = ($ml_point - $chkinfo["ml_point"]);
if($rml_point<0)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt".$rml_point." where m_idx='".$t_idx."'";
}else{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$rml_point." where m_idx='".$t_idx."'";
}
$urs = query($usql);
if($urs)
{
//기존 내역 변경하기
$uusql = "update member_like set ml_point='".$ml_point."', regdate=now() where ml_idx='".$chkinfo["ml_idx"]."'";
$uurs = query($uusql);
if ($uurs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
$isql = "insert into member_like set m_idx='".$m_idx."', t_idx='".$t_idx."', ml_type='".$ml_type."', ml_point='".$ml_point."', regdate=now()";
$irs = query($isql);
if($irs)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$ml_point." where m_idx='".$t_idx."'";
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 입력중 오류가 발생했습니다.","url":"f5"}');
}
}
//echoAr($_REQUEST);
}
//호감도 증가하게 하는 내역 2020-02-11 by zero
if($dbControl == "setLikePoint2")
{
$m_idx = $_SESSION["_IDX"];
$t_idx = $_REQUEST["CODE"];
$ml_type = "ml_disposition"; //취향이 마음에 드는 점수근거
$ml_point = $_REQUEST["v"];
$chkinfo = getValue("member_like"," where m_idx='".$m_idx."' and t_idx='".$t_idx."' and ml_type='".$ml_type."'");
if($chkinfo)
{
//$usql = "update member_like set ml_point='".$ml_point."' where ml_idx='".$ml_idx."'";
$rml_point = ($ml_point - $chkinfo["ml_point"]);
if($rml_point<0)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt".$rml_point." where m_idx='".$t_idx."'";
}else{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$rml_point." where m_idx='".$t_idx."'";
}
$urs = query($usql);
if($urs)
{
//기존 내역 변경하기
$uusql = "update member_like set ml_point='".$ml_point."', regdate=now() where ml_idx='".$chkinfo["ml_idx"]."'";
$uurs = query($uusql);
if ($uurs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
$isql = "insert into member_like set m_idx='".$m_idx."', t_idx='".$t_idx."', ml_type='".$ml_type."', ml_point='".$ml_point."', regdate=now()";
$irs = query($isql);
if($irs)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$ml_point." where m_idx='".$t_idx."'";
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 입력중 오류가 발생했습니다.","url":"f5"}');
}
}
//echoAr($_REQUEST);
}
//호감도 증가하게 하는 내역 2020-02-11 by zero
if($dbControl == "setLikePoint3")
{
$m_idx = $_SESSION["_IDX"];
$t_idx = $_REQUEST["CODE"];
$ml_type = "ml_conversation"; //대화가 통하는지에 대한 점수근거
$ml_point = $_REQUEST["v"];
$chkinfo = getValue("member_like"," where m_idx='".$m_idx."' and t_idx='".$t_idx."' and ml_type='".$ml_type."'");
if($chkinfo)
{
//$usql = "update member_like set ml_point='".$ml_point."' where ml_idx='".$ml_idx."'";
$rml_point = ($ml_point - $chkinfo["ml_point"]);
if($rml_point<0)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt".$rml_point." where m_idx='".$t_idx."'";
}else{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$rml_point." where m_idx='".$t_idx."'";
}
$urs = query($usql);
if($urs)
{
//기존 내역 변경하기
$uusql = "update member_like set ml_point='".$ml_point."', regdate=now() where ml_idx='".$chkinfo["ml_idx"]."'";
$uurs = query($uusql);
if ($uurs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
$isql = "insert into member_like set m_idx='".$m_idx."', t_idx='".$t_idx."', ml_type='".$ml_type."', ml_point='".$ml_point."', regdate=now()";
$irs = query($isql);
if($irs)
{
$usql = "update _MEMBER set m_likecnt=m_likecnt+".$ml_point." where m_idx='".$t_idx."'";
$urs = query($usql);
if($urs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 입력중 오류가 발생했습니다.","url":"f5"}');
}
}
//echoAr($_REQUEST);
}
//푸시알림 설정 하기
if($dbControl == "setpushevent")
{
//echoAr($_POST);
$code = $_POST["CODE"];
$chkval = $_POST["v"];
$sql = "update _MEMBER set ";
if($code=="notice")
{
$sql .= " m_notice_push='".$chkval."'";
}else if ($code=="talk")
{
$sql .= " m_talk_push='".$chkval."'";
}else if ($code=="chat")
{
$sql .= " m_chat_push='".$chkval."'";
}
$sql .= " where m_idx='".$memberInfo["m_idx"]."'";
//echo $sql;
//exit;
$urs = query($sql);
if($urs)
{
useExit('{"result":"Y","message":"성공적으로 처리했습니다.","url":"f5"}');
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}
//메세지 보내기
if($dbControl=="setMessageSend")
{
//echoAr($_POST);
$fn_member = $_POST["fn_member"]; //메시지 보내는 사람인덱스
$fn_sender = $_POST["fn_sender"]; //메시지 받는 사람인덱스
$message = $_POST["message"]; //메시지 내용
$m_ticketchk = "N";
$m_chocolatechk = "N";
//1. 메시지 보내는 사람이 메시지를 보낼수 있는지 확인(이용권 및 초콜릿 보유자)
$fn_memberinfo = getValue("_MEMBER m join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$fn_member."'","ar","*");
if($fn_memberinfo)
{
if($fn_memberinfo["m_ticket"]=="yes")
{
if(time()<=strtotime($fn_memberinfo["m_ticket_edatetime"]))
{
$m_ticketchk="Y";
}else{
$usql = "update _MEMBER set m_ticket='none' where m_idx='".$fn_member."'";
$urs = query($usql);
if($urs)
{
if($fn_memberinfo["m_chocolate"]>=5)
{
$m_chocolatechk = "Y";
}else{
useExit('{"result":"N","message":"메세지를 보낼수 없습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"DB 수정중 오류가 발생했습니다.","url":"f5"}');
}
}
}else{
if($fn_memberinfo["m_chocolate"]>=5)
{
$m_chocolatechk = "Y";
}else{
useExit('{"result":"N","message":"메세지를 보낼수 없습니다.","url":"f5"}');
}
}
//1-1. 나의 성별과 다른 사람인지 확인 체크
if ($fn_memberinfo["p_sex"]=="F")
{
$chkgender = "M";
}else{
$chkgender = "F";
}
//2. 메시지 받는 사람이 메시지를 받을수 있는지 확인한다.
$fn_senderinfo = getValue("_MEMBER m join _PROFILE p on m.m_idx=p.p_m_idx"," where m.m_idx='".$fn_sender."' and p.p_sex='".$chkgender."'","ar","*");
if($fn_senderinfo)
{
//기존에 생성된 채팅방이 있는지 확인한다 2020-02-14 by zero
$chatRoom = getValue("chatRoom"," where ((host='".$fn_member."' and guest='".$fn_sender."') or (guest='".$fn_member."' and host='".$fn_sender."')) and status='Y' ","ar","*");
if($chatRoom)
{
$fn_chatRoom = $chatRoom["idx"];
}else{
//채팅방생성한다. 2020-02-13 by zero
//티켓사용자는 초콜릿 감소 없음
if ($m_ticketchk=="Y")
{
}else if( $m_chocolatechk=="Y")
{
$usql = "update _MEMBER set m_chocolate=m_chocolate-5 where m_idx='".$fn_member."'";
$urs = query($usql);
if($urs)
{
$isql = "insert into pointHistory set fn_member='".$fn_member."', stackType='U', point_type=''";
}else{
useExit('{"result":"N","message":"초콜릿 차감 도중 문제가 발생하였습니다.","url":"f5"}');
}
}
$isql = "insert into chatRoom set host='".$fn_member."', guest='".$fn_sender."', category='chat', title='채팅방입니다.', contents='".$message."', memCount=2, status='Y', regdate=now()";
$irs = query($isql);
if($irs)
{
$fn_chatRoom = insert_id();
$isql_fm = "insert into chatMember set fn_chatR='".$fn_chatRoom."', fn_member='".$fn_member."', regdate=now(), status='R'";
$ifmrs = query($isql_fm);
if($ifmrs)
{
}else{
useExit('{"result":"N","message":"채팅방 생성도중 문제가 발생하였습니다.","url":"f5"}');
}
$isql_fs = "insert into chatMember set fn_chatR='".$fn_chatRoom."', fn_member='".$fn_sender."', regdate=now(), status='C'";
$ifsrs = query($isql_fs);
if($ifsrs)
{
}else{
useExit('{"result":"N","message":"채팅방 생성도중 문제가 발생하였습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"채팅방 생성도중 문제가 발생하였습니다.","url":"f5"}');
}
}
$iisql = "insert into messageBox set fn_member='".$fn_member."', fn_sender='".$fn_sender."', fn_chatRoom='".$fn_chatRoom."', `check`='N', regdate=now(), message='".$message."' ";
//echo $iisql;
//exit;
$iirs = query($iisql);
if($iirs)
{
$msgidx = insert_id();
//3.상대방의 푸시여부 확인해서 보내기
if($fn_senderinfo["m_os"]=="android"&&$fn_senderinfo["m_talk_push"]=="Y"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "message";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush($msg);
}else if($fn_senderinfo["m_os"]=="IOS"&&$fn_senderinfo["m_talk_push"]=="Y"&&$fn_senderinfo["m_regi"]!="")
{
$msg["m_fcm_token"] = $fn_senderinfo["m_regi"];
$msg["type"] = "message";
$msg["message"] = $message;
$msg["sender_img"] = "";
$msg["msg_from"] = $fn_memberinfo["m_idx"];
$msg["sender_nick"] = $fn_memberinfo["p_name"];
$msg["sender_gender"] = $fn_memberinfo["p_sex"];
$msg["room_idx"] = $fn_chatRoom;
$msg["idx"] = $msgidx;
FCMPush_IOS($msg);
}
useExit('{"result":"Y","message":"","url":""}');
}else{
useExit('{"result":"N","message":"메시지내역 생성도중 문제가 발생하였습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"상대방에게 메세지를 보낼수 없습니다.","url":"f5"}');
}
}else{
useExit('{"result":"N","message":"메세지를 보낼수 없습니다.","url":"f5"}');
}
}
//챗봇 세팅
if($dbControl=="setChatBotSave")
{
//echoAr($_REQUEST);
$idx = $_REQUEST["idx"];
$question = $_REQUEST["bot_q"];
$answer = $_REQUEST["bot_a"];
$mode = $_REQUEST["mode"];
if($mode=="w")
{
$isql = "insert into QA set status='Y', m_idx='0', title='채팅봇 질문 답변', question='".$question."', answer='".$answer."', regdate=now(), answer_datetime=now()";
$irs = query($isql);
if ($irs)
{
useExit('{"result":"Y","message":"","url":"f5"}');
}else{
useExit('{"result":"N","message":"잘못된 입력입니다.","url":"f5"}');
}
}else{
$usql = "update QA set question='".$question."', answer='".$answer."', answer_datetime=now() where idx='".$idx."'";
$urs = query($usql);
if ($urs)
{
useExit('{"result":"Y","message":"","url":"f5"}');
}else{
useExit('{"result":"N","message":"잘못된 입력입니다.","url":"f5"}');
}
}
}
//푸시 테스트
if($dbControl=="testFcmAndroid")
{
$msg["m_fcm_token"] = "fJJn2ENlLc4:APA91bHWC8r8soUoMFtOag2-SCf3d_AEBRyBmE4QT5oD4CMkHcfBJM6pgFJa_dyG5ec3CAsiKttycztZU-CBFqRBvbWTqHHgJLNy30GE49sb8if6rpxZ2Cghrti0hsNH13kpQhHD8GaQ"; //기수안드로이드
$msg["type"] = "chat";
$msg["message"] = "테스트";
$msg["sender_img"] = "";
$msg["msg_from"] = "107727";
$msg["sender_nick"] = "나야나";
$msg["sender_gender"] = "M";
$msg["room_idx"] = "601";
$msg["idx"] = 317;
FCMPush($msg);
}
//푸시 테스트
if($dbControl=="testFcmIOS")
{
echo $_REQUEST["TKN"]."으로 전송";
// $msg["m_fcm_token"] = "eXGeUAQ5paU:APA91bE2dyRxx5U6WYojI3aRferXgmx9k-VvXeD9xo_aMS3UBMYPOOIrTqaNDW43Cev9ncFAs4p3QED7H4dfK_wunAig2VroTuWZj7IIRBYM0W28k5DD8TQgqa65opwuW3fPH83YMzTn"; //주형IOS
$msg["m_fcm_token"] = $_REQUEST["TKN"]; //주형IOS
$msg["type"] = "chat";
$msg["message"] = "/UPLOAD/15840001431584000148812img.jpg";
$msg["sender_img"] = "";
$msg["msg_from"] = "107727";
$msg["sender_nick"] = "나야나";
$msg["sender_gender"] = "M";
$msg["room_idx"] = "605";
$msg["idx"] = 326;
FCMPush_IOS($msg);
}
?>