<!--#include virtual="/new/common/pageincode.asp" -->
<!--#include virtual="/_Lib/config.asp" -->
<!--#include virtual="/new/common/util.asp" -->
<%
Session("daum_cts")="1" '#다음 CTS
%>
<%
'===========================================================
'  페이지 : /member/join_ok.asp
'  TABLE : TBL_MEMBER
'  설   명 : 사용자>회원가입/수정
'  작성자 : 
'  작성일 : 2011-05-14
'-----------------------------------------------------------
'     수정일     |    작성자    |    내용
'-----------------------------------------------------------
'   2011-05-14   |              |  initialize
'===========================================================


Dim reg_ip

'//테이블 변수
tbl_name = "TBL_MEMBER"

'-----------------------------------------------------------
'  변수값 전달
'-----------------------------------------------------------
Dim req_mode : req_mode = getReplaceInput(fncDefault(request.form("mode"),""),"")

Dim req_user_id : req_user_id = getReplaceInput(fncDefault(request.form("user_id"),""),"")
Dim req_user_pass : req_user_pass = getReplaceInput(fncDefault(request.form("user_pass"),""),"")
Dim req_user_name : req_user_name = getReplaceInput(fncDefault(request.form("user_name"),""),"")
Dim req_user_ssn1 : req_user_ssn1 = getReplaceInput(fncDefault(request.form("user_ssn1"),""),"")
Dim req_user_ssn2  : req_user_ssn2 = getReplaceInput(fncDefault(request.form("user_ssn2"),""),"")
Dim req_user_tel1 : req_user_tel1 = getReplaceInput(fncDefault(request.form("user_tel1"),""),"")
Dim req_user_tel2 : req_user_tel2 = getReplaceInput(fncDefault(request.form("user_tel2"),""),"")
Dim req_user_tel3  : req_user_tel3 = getReplaceInput(fncDefault(request.form("user_tel3"),""),"")
Dim req_user_mobile1 : req_user_mobile1 = getReplaceInput(fncDefault(request.form("user_mobile1"),""),"")
Dim req_user_mobile2 : req_user_mobile2 = getReplaceInput(fncDefault(request.form("user_mobile2"),""),"")
Dim req_user_mobile3 : req_user_mobile3 = getReplaceInput(fncDefault(request.form("user_mobile3"),""),"")
Dim req_user_email1 : req_user_email1 = getReplaceInput(fncDefault(request.form("user_email1"),""),"")
Dim req_user_email2 : req_user_email2 = getReplaceInput(fncDefault(request.form("user_email2"),""),"")
Dim req_user_post1 : req_user_post1 = getReplaceInput(fncDefault(request.form("user_post1"),""),"")
Dim req_user_post2 : req_user_post2 = getReplaceInput(fncDefault(request.form("user_post2"),""),"")
Dim req_user_addr : req_user_addr = getReplaceInput(fncDefault(request.form("user_addr"),""),"")
Dim req_user_addr_detail : req_user_addr_detail = getReplaceInput(fncDefault(request.form("user_addr_detail"),""),"")
Dim req_user_email_flag : req_user_email_flag = getReplaceInput(fncDefault(request.form("user_email_flag"),"0"),"")

reg_ip = Request.ServerVariables("REMOTE_ADDR")

If Trim(req_user_email1&"")<>"" And Trim(req_user_email2&"")<>"" Then
	req_user_email = req_user_email1 & "@" & req_user_email2
End IF

'-----------------------------------------------------------
'  데이타 등록 처리
'-----------------------------------------------------------


If req_mode="U" Then			'//수정모드

	'-----------------------------------------------------------
	'  데이타 수정하기
	'-----------------------------------------------------------
	sql = ""
	sql = sql & "	UPDATE " & tbl_name & " SET "
	sql = sql & "		 user_name = '" & req_user_name & "'"
	sql = sql & "		, user_tel1 = '" & req_user_tel1 & "'"
	sql = sql & "		, user_tel2 = '" & req_user_tel2 & "'"
	sql = sql & "		, user_tel3 = '" & req_user_tel3 & "'"
	sql = sql & "		, user_mobile1 = '" & req_user_mobile1 & "'"
	sql = sql & "		, user_mobile2 = '" & req_user_mobile2 & "'"
	sql = sql & "		, user_mobile3 = '" & req_user_mobile3 & "'"
	sql = sql & "		, user_email_flag = " & req_user_email_flag & ""
	sql = sql & "		, user_post1 = '" & req_user_post1 & "'"
	sql = sql & "		, user_post2 = '" & req_user_post2 & "'"
	sql = sql & "		, user_addr = '" & req_user_addr & "'"
	sql = sql & "		, user_addr_detail = '" & req_user_addr_detail & "'"
	sql = sql & "		, edit_ip = '" & reg_ip & "'"
	sql = sql & "		, edit_dt = getdate() "
	If Trim(req_user_pass&"")<>"" Then
	sql = sql & "		,user_pass = '" & req_user_pass & "'"
	End If
	sql = sql & "	WHERE user_email= '" & session("user_id") &"'"

Else									'//신규 등록
	'//필수값 체크
	If Trim(req_user_name&"")="" Or Trim(req_user_pass&"")=""  Then

		response.write DisplayJavaAlert("정보가 정확하지 않습니다.","1")
		response.End
	End If
	
	
	'//중복이메일 체크
	If CInt(f_chkId(req_user_email)) > 0 Then
		response.write DisplayJavaAlert("이미 등록된 이메일입니다. \n다시 확인해주세요.","1")
		response.End
	End If

	'//중복 회원가입 체크
	'If CInt(f_chkUser(req_user_name, req_user_ssn1, req_user_ssn2)) > 0 Then
	'	response.write DisplayJavaAlert("이미 등록된 회원입니다. \n다시 확인해주세요.","1")
	'	response.End
	'End If
	
	'-----------------------------------------------------------
	'  데이타 입력하기
	'-----------------------------------------------------------
	sql = ""
	sql = sql & "	INSERT INTO " & tbl_name & " ( "
	sql = sql & "		user_id,user_pass,user_name"
	sql = sql & "		,user_ssn1,user_ssn2"
	sql = sql & "		,user_tel1,user_tel2,user_tel3"
	sql = sql & "		,user_mobile1,user_mobile2,user_mobile3"
	sql = sql & "		,user_email,user_email_flag"
	sql = sql & "		,user_post1,user_post2"
	sql = sql & "		,user_addr,user_addr_detail"
	sql = sql & "		,reg_ip,reg_dt,edit_ip,edit_dt,login_dt "
	sql = sql & "	)VALUES ( "
	sql = sql & "		'" & req_user_email & "', '" & req_user_pass & "','" & req_user_name & "'"
	sql = sql & "		,'" & req_user_ssn1 & "','"  & req_user_ssn2 & "'" 
	sql = sql & "		,'" & req_user_tel1 & "','" & req_user_tel2 & "','" & req_user_tel3 & "'" 
	sql = sql & "		,'" & req_user_mobile1 & "','" & req_user_mobile2 & "','" & req_user_mobile3 & "'"
	sql = sql & "		,'" & req_user_email & "'," & req_user_email_flag & ""
	sql = sql & "		,'" & req_user_post1 & "','" & req_user_post2 & "'"
	sql = sql & "		,'" & req_user_addr & "','" & req_user_addr_detail & "'"
	sql = sql & "		,'" & reg_ip & "', getdate() ,'" & reg_ip & "', getdate(), getdate()"
	sql = sql & "	)"
	

	' 가입축하 메일 보내기
	mailtxt = "<table id='Table_01' width='700' border='0' cellpadding='0' cellspacing='0'>"
	mailtxt = mailtxt & "<tr>"
	mailtxt = mailtxt & "<td colspan='2'><img id='mail_01' src='http://uni114.co.kr/images/mail_01.jpg' width='700' height='507'></td>"
	mailtxt = mailtxt & "</tr>"
	mailtxt = mailtxt & "<tr>"
	mailtxt = mailtxt & "<td><img id='mail_02' src='http://uni114.co.kr/images/mail_02.jpg' width='255' height='72'></td>"
	mailtxt = mailtxt & "<td width='445' height='72' background='http://uni114.co.kr/images/mail_03.jpg'>"&req_user_name&"님의 회원가입을 진심으로 환영합니다</td>"
	mailtxt = mailtxt & "</tr>"
	mailtxt = mailtxt & "<tr>"
	mailtxt = mailtxt & "<td colspan='2'><img id='mail_04' src='http://uni114.co.kr/images/mail_04.jpg' width='700' height='221'></td>"
	mailtxt = mailtxt & "</tr>"
	mailtxt = mailtxt & "</table>"

	Call sendmail(req_user_email, "help@uni114.co.kr", "유앤아이 회원가입을 축하드립니다.", mailtxt)

End If


If Trim(sql&"")<>"" Then
	'//transaction begin
	DbCon.BeginTrans
	'Response.write sql
		DbCon.Execute sql

	'//TRANSACTION COMMIT
	If DbCon.Errors.Count = 0 Then
		DbCon.CommitTrans
		Session("user_id") = req_user_email
		Session("user_name") = req_user_name
	Else
		DbCon.RollbackTrans
		message = "정보 저장시 문제가 생겼습니다. \n다시 확인해 주세요."
	End If

End If

' // 객체 연결 끊기
Call SubObjClose(DbCon)

'-----------------------------------------------------------
' 페이지 이동
'-----------------------------------------------------------

%>

<!-- Withpang Tracker v2.0 start 2015.06.16 -->
<script type="text/javascript">
<!--
	(function (w, d, i) {
		w[i]={
			sc : (encodeURIComponent("")),
			form : (encodeURIComponent(d.referrer)),
			url : (encodeURIComponent(w.location.href))
		};

		if(w[i]) {
			var _ar = _ar || [];
			var _s = "log.dreamsearch.or.kr/servlet/rf";
			for(x in w[i]) _ar.push(x + "=" + w[i][x]);
			(new Image).src = d.location.protocol +"//"+ _s +"?"+ _ar.join("&");
		}
	})(window, document, "wp_rf");
//-->
</script>
<!-- Withpang Tracker v2.0 end -->

<!-- Withpang Conversion Tracker v2.0 start -->
<script type="text/javascript">
<!--
	(function (w, d, i) {
		w[i]={
			uid : "uni114",
			ordcode : "",
			pcode : "1",
			qty : "1",
			price : "1",
			pnm : encodeURIComponent(encodeURIComponent("회원가입"))
		};

		try{
			w[i].price= w[i].price.replace(/[^0-9]/g,"");
			if( w[i].ordcode=="" ) {
				w[i].ordcode = w[i].uid +"-"+ new Date().getTime();
			}
		}catch(e){
			w[i].price= 0;
		}
		if(w[i]) {
			var _ar = _ar || [];
			var _s = "log.dreamsearch.or.kr/servlet/conv";
			for(x in w[i]) _ar.push(x + "=" + w[i][x]);
			(new Image).src = d.location.protocol +"//"+ _s +"?"+ _ar.join("&");
		}
	})(window, document, "wp_conv");
//-->
</script>
<!-- Withpang Conversion Tracker v2.0 end -->

<!-- AceCounter Log Gathering Script V.72.2013010701 -->
<script language='javascript'>
if(typeof _GUL == 'undefined'){
var _GUL = 'gtp19.acecounter.com';var _GPT='8080'; var _AIMG = new Image(); var _bn=navigator.appName; var _PR = location.protocol=="https:"?"https://"+_GUL:"http://"+_GUL+":"+_GPT;if( _bn.indexOf("Netscape") > -1 || _bn=="Mozilla"){ setTimeout("_AIMG.src = _PR+'/?cookie';",1); } else{ _AIMG.src = _PR+'/?cookie'; };
document.writeln("<scr"+"ipt language='javascript' src='/acecounter/acecounter_V70.js'></scr"+"ipt>");
}
</script>
<noscript><img src='http://gtp19.acecounter.com:8080/?uid=AM3A38619057818&je=n&' border=0 width=0 height=0></noscript>
<!-- AceCounter Log Gathering Script End -->

<script type="text/javascript" src="https://wcs.naver.net/wcslog.js"></script> 
<script type="text/javascript"> 
if (!wcs_add) var wcs_add={};
wcs_add["wa"] = "s_5955b31bffc";
if (!_nasa) var _nasa={};
_nasa["cnv"] = wcs.cnv("2","1"); // 전환유형 - 회원가입
wcs_do(_nasa);
</script>

<!-- cpcguard v6.0 : 구매전환 --> 
<script type='text/j-vascript'>var _CONVERSION_CPCGUARD = 3</script> 
<!-- cpcguard conversion END --> 

<!--  CPCGUARD SCRIPT V6.0 : 기본분석 -->
<script type="text/javascript">
 (function(){
 var _script = document.createElement("script"); _script.id= "include_cpc_script"; _script.type = "text/javascript"; _script.charset = "utf-8"; _script.async = true; _script.src = (document.location.protocol || "http:") + "//nsc1.cpcguard.com/new/cpc_script.js"; 
 var _node = document.getElementsByTagName("script")[0]; _node.parentNode.insertBefore(_script, _node);
 })();
</script>
<!-- CPCGUARD SCRIPT END -->

<!-- WIDERPLANET PURCHASE SCRIPT START 2014.10.23 -->
<div id="wp_tg_cts" style="display:none;"></div>
<script type="text/j-vascript">
var wptg_tagscript_vars = wptg_tagscript_vars || [];
wptg_tagscript_vars.push(
(function() {
return {
 ti:"20867", //--광고주 코드--
ty:"PurchaseComplete", //--트래킹태그 타입--
device:"web", //--디바이스 종류 (web 또는 mobile)--
items:[{i:"회원가입", //--전환 식별코드 (한글, 영문, 숫자, 공백 허용)--
t:"회원가입", //--전환명 (한글, 영문, 숫자, 공백 허용)--
p:"1", //--전환가격 (전환 가격이 없을경우 1로 설정)--
q:"1" //--전환수량 (전환 수량이 고정적으로 1개 이하일 경우 1로 설정)--
}] 
};
}));
</script> 
<script type="text/j-vascript" src="//astg.widerplanet.com/js/wp_astg_3.0.js"></script>
<!-- // WIDERPLANET PURCHASE SCRIPT END 2014.10.23 -->

<!-- Facebook Conversion Code for 회원가입 - 2014.07.01 -->
<script>(function() {
  var _fbq = window._fbq || (window._fbq = []);
  if (!_fbq.loaded) {
    var fbds = document.createElement('script');
    fbds.async = true;
    fbds.src = '//connect.facebook.net/en_US/fbds.js';
    var s = document.getElementsByTagName('script')[0];
    s.parentNode.insertBefore(fbds, s);
    _fbq.loaded = true;
  }
})();
window._fbq = window._fbq || [];
window._fbq.push(['track', '6015286507903', {'value':'0.00','currency':'USD'}]);
</script>
<noscript><img height="1" width="1" alt="" style="display:none" src="https://www.facebook.com/tr?ev=6015286507903&cd[value]=0.00&cd[currency]=USD&noscript=1" /></noscript>
<!--// Facebook Conversion Code -->

<%


If Trim(req_mode&"") = "I" Then
	message = "회원 등록되었습니다."
	goUrl = "http://www.uni114.co.kr/new/mbr/join_done.asp"
Else
	message = "회원정보가 수정되었습니다."
	goUrl = "http://www.uni114.co.kr/new/index.asp"
End If

Call MoveJavaAlert(message, goUrl)
Response.End

%>