<%@ LANGUAGE="VBSCRIPT" %>
<!--#include file="data.asp"-->
<!--#include file="check.asp"-->
<!--#include file="delmail.asp"-->
<%
   dim sql 
   dim rs

set rs=server.createobject("adodb.recordset")
sql="select * from user where id="&request("id")
rs.open sql,conn,1,3 
email=rs("信箱")


'--------------------------------------------------刪除信箱--------------------------------------------------------
			
			set con2 = Server.CreateObject("ADODB.Connection") 
			'刪除此用戶的信箱數(shù)據(jù)
			ConnStr="DBQ=" & Server.Mappath("db/mails1.mdb") & ";DRIVER={Microsoft Access Driver (*.mdb)};"
			con2.open(ConnStr)
			set Record2 = Server.CreateObject("ADODB.Recordset")
			Record2.ActiveConnection = con2
			Record2.CursorType = adOpenKeyset
			Record2.LockType = adLockOptimistic
			
			DelAll "del" 
			DelAll "recived" 
			DelAll "sendout" 	
			con2.close
			set con2=nothing
'--------------------------------------------------刪除信箱--------------------------------------------------------

rs.Delete
'   Dim objNewMail As CDONTS.NewMail
'   Set objNewMail = CreateObject("CDONTS.NewMail")
'Set objNewMail = CreateObject("CDONTS.NewMail")
'objNewMail.Send("webmaster@sxhighway.net", email, "您的帳號(hào)未通過審核或被刪除", _
'"您的帳號(hào)未通過審核或被刪除，具體情況請(qǐng)?jiān)儐柟芾韱T", 0) '' low importance
'Set objNewMail = Nothing '' canNOT reuse it for another message



   conn.close
   set conn=nothing
   rs.close
   set rs=nothing  
response.redirect "userchk.asp"

%>