sp1000je
39 lines
1.1 KiB
Plaintext
39 lines
1.1 KiB
Plaintext
<!--#include virtual = "/common/lib/dbcon.asp" -->
|
|
<!--#include virtual = "/common/lib/func.asp" -->
|
|
<!--#include file = "inc_auth_code.asp" -->
|
|
<%
|
|
|
|
|
|
m_mobile1 = InputValue( request("m_mobile1") )
|
|
m_mobile2 = InputValue( request("m_mobile2") )
|
|
m_mobile3 = InputValue( request("m_mobile3") )
|
|
auth_code_num = request("auth_code_num")
|
|
|
|
|
|
If auth_code_num = "" Then
|
|
|
|
Response.write "auth_code error"
|
|
Response.end
|
|
|
|
End if
|
|
|
|
tran_phone = m_mobile1 & m_mobile2 & m_mobile3
|
|
tran_callback = "15449642"
|
|
Rdate = Date() & " " & Right(hour(now), 2) & ":" & Right(minute(now), 2) & ":" & Right(second(now), 2)
|
|
s_num = get_idx_add()
|
|
|
|
|
|
|
|
|
|
message = "[나눔문자서비스]모바일 인증번호는 " & auth_code_arr( CInt(auth_code_num) ) & "입니다. 정확히 입력해주세요."
|
|
|
|
|
|
SQL = "Insert into em_tran(tran_id, tran_phone, tran_callback, tran_status, tran_date, tran_msg, tran_etc1, tran_etc2, tran_etc3, tran_etc4) values ("
|
|
SQL = SQL & "'nninc','"&tran_phone&"', '"&tran_callback&"', '1', '"&Rdate&"', '"&message&"','', '"&s_num&"','161', '159')"
|
|
'response.write sql & "<br>"
|
|
'response.write "<br>sql="&sql
|
|
'response.end
|
|
dbcon.execute sql
|
|
|
|
Response.write "ok"
|
|
%> |