sp1000je
47 lines
1022 B
Plaintext
47 lines
1022 B
Plaintext
<!--#include virtual = "/common/lib/dbcon.asp" -->
|
|
<!--#include virtual = "/common/lib/func.asp" -->
|
|
<%
|
|
|
|
m_id = inputValue( Request("mms_m_id") )
|
|
tran_etc1 = inputValue( Request("mms_tran_etc1"))
|
|
rtn_url = inputValue( Request("mms_rtn_url"))
|
|
|
|
If m_id="" Or tran_etc1="" Then
|
|
Response.End
|
|
End If
|
|
|
|
If rtn_url = "" Then rtn_url = Request.ServerVariables("HTTP_REFERER")
|
|
|
|
|
|
|
|
' 예약된게 몇개 있는지 조회
|
|
reserved_cn = 0
|
|
sql = "SELECT count(*) FROM SDK_MMS_SEND with(nolock) WHERE user_id='"&m_id&"' AND RESERVED1='"&tran_etc1&"' "
|
|
Set rs = dbcon.execute(sql)
|
|
If Not rs.eof Then
|
|
reserved_cn = CInt(rs(0))
|
|
End If
|
|
rs.close : Set rs = nothing
|
|
|
|
|
|
If reserved_cn > 0 Then
|
|
|
|
sql = "DELETE FROM SDK_MMS_SEND WHERE user_id='"&m_id&"' AND RESERVED1='"&tran_etc1&"' "
|
|
executeQuery( sql )
|
|
|
|
' 갯수 추가
|
|
sql = "update member set M_g_sms = M_g_sms + "&(reserved_cn*3)&" where M_id = '"&m_id&"'"
|
|
executeQuery( sql )
|
|
|
|
End if
|
|
|
|
|
|
|
|
Dbcon.close
|
|
Set Dbcon = Nothing
|
|
|
|
If rtn_url <> "" then
|
|
response.redirect rtn_url
|
|
End if
|
|
%>
|