refcontestend.asp

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

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

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

<%
  Server.ScriptTimeout = 999
  rs.Open "Update setup Set RefContest = False",Conn
  rs.Open "Select * From member",Conn
  While Not rs.EOF
  UserName = rs ("UserName")
  re.Open "Select Count(*) AS Total From member Where Referral = '" & UserName & "' And NoReferral = False And Active = True And Valid = True And Vacation = False",Conn
  DirectActiveRef = re("Total")
  re.Close
  RefContest_Begin = rs ("RefContest_Begin")
  sql = "Update member Set RefContest_End = '" & DirectActiveRef & "' - '" & RefContest_Begin & "' Where UserName = '" & UserName & "'"
  Conn.Execute sql
  rs.MoveNext
  Wend
  rs.Close
  Set rs = nothing
  Conn.Close
  Set Conn = nothing
  Session ("Message") = "下线竞赛现在结束。"
  Response.Redirect "success.asp"
  Response.End
%>