unloginmd.asp

中文bux点击站源码。配合其他站点用

<%@ LANGUAGE = VBScript %>
<!--#include file="conn.asp"-->

<!--#include file="checklogin.asp"-->

<%
  Tmp = 0
  Server.ScriptTimeout = 999
  DateLimit = Request ("DateLimit2")
  UnsubscribeIP = Request.serverVariables("REMOTE_ADDR")
  If DateLimit = "45 Days" Then
     rs.Open "Select * From member Where Date() - LoginTime > 45 And Vacation <> True",Conn
  Else If DateLimit = "30 Days" Then
          rs.Open "Select * From member Where Date() - LoginTime > 30 And Vacation <> True",Conn
       Else If DateLimit = "14 Days" Then
               rs.Open "Select * From member Where Date() - LoginTime > 14 And Vacation <> True",Conn
            End If
       End If
  End If
  While Not rs.EOF
  Tmp = Tmp + 1
  Email = rs ("Email")
  UserName = rs ("UserName")
  If UserName <> "" Then
     NoReferral = rs ("NoReferral")
     UpLine = rs ("Referral")
     If NoReferral = True Then
        BRChange = -1
        DRChange = 0
     Else
        BRChange = 0
        DRChange = -1
     End If
  End If
  rs.Close
  rs.Open "Insert Into unsubscribe(UserName, Email, UnsubscribeBy, UnsubscribeTime, UnsubscribeIP) values('" & UserName & "', '" & Email & "', 'Webmaster', Now(), '" & UnsubscribeIP & "')",Conn
  rs.Open "Delete FROM member Where UserName = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral = '' Where Referral = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral2 = '' Where Referral2 = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral3 = '' Where Referral3 = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral4 = '' Where Referral4 = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral5 = '' Where Referral5 = '" & UserName & "'",Conn
  rs.Open "Update member Set Referral6 = '' Where Referral6 = '" & UserName & "'",Conn
  If UpLine <> "" Then
        rs.Open "Update member Set BlindReferral = BlindReferral + '" & BRChange & "', DirectReferral = DirectReferral + '" & DRChange & "' Where UserName = '" & UpLine & "'",Conn
  End If
  If DateLimit = "45 Days" Then
     rs.Open "Select * From member Where Date() - LoginTime > 45 And Vacation <> True",Conn
  Else If DateLimit = "30 Days" Then
          rs.Open "Select * From member Where Date() - LoginTime > 30 And Vacation <> True",Conn
       Else If DateLimit = "14 Days" Then
               rs.Open "Select * From member Where Date() - LoginTime > 14 And Vacation <> True",Conn
            End If
       End If
  End If
  If Not rs.Eof Then
     rs.MoveNext
  End If
  Wend
  Conn.Close
  Set Conn = nothing
  Session ("Message") = "会员删除成功。共删除 " & Tmp & " 名不活动会员。"
  Response.Redirect "success.asp"
  Response.End
%>