📄 p2scontest.asp
字号:
<%@ LANGUAGE = VBScript %>
<!--#include file="conn.asp"-->
<!--#include file="checklogin.asp"-->
<%
rs.Open "Select * From setup",Conn
P2SContest = rs ("P2SContest")
rs.Close
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link REL="StyleSheet" HREF="../tjscripts.css" TYPE="text/css" MEDIA="screen">
<title><%= SiteTitle %>后台管理系统</title>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<table border="1" cellspacing="1" width="100%" bordercolor="#0033CC">
<tr>
<td width="100%" height="31" bgcolor="#FFCC00"><b>注册竞赛管理</b></td>
</tr>
<tr>
<td width="100%">
<div align="center">
<table border="1" cellspacing="1" width="99%" bordercolor="#A50F18">
<tr>
<td width="50%" height="30" align="center">
<form method="POST" action="p2scontestbegin.asp">
<% If P2SContest = True Then %>
<p><input type="submit" value="开始注册竞赛" name="Button" Disabled></p>
<% Else %>
<p><input type="submit" value="开始注册竞赛" name="Button"></p>
<% End If %>
</form>
</td>
<td width="50%" height="30" align="center">
<form method="POST" action="p2scontestend.asp">
<% If P2SContest = True Then %>
<p><input type="submit" value="结束注册竞赛" name="Button"></p>
<% Else %>
<p><input type="submit" value="结束注册竞赛" name="Button" Disabled></p>
<% End If %>
</form>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td width="100%" align="center">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="99%">
<tr>
<td width="100%" align="center" height="30" colspan="8"><b>上次注册竞赛前5名</b></td>
</tr>
<%
rs.Open "Select Count(*) AS Total From member Where Active = True And Valid = True",Conn
TotalMember = rs("Total")
rs.Close
If TotalMember >= 5 Then
%>
<tr>
<td align="center" height="30">名次</td>
<td align="center" height="30">用户名</td>
<td align="center" height="30">星级</td>
<td align="center" height="30">VIP级别</td>
<td align="center" height="30">电子邮件</td>
<td align="center" height="30">注册次数</td>
<td align="center" height="30">注册积分</td>
<td align="center" height="30">注册质量</td>
</tr>
<%
i = 0
rs.Open "Select * From member Where active = True And P2S_End > 0 Order by (P2SJiFen_End / P2S_End) DESC, P2SJiFen_End DESC, P2S_End DESC",Conn
While ((not i = 5) And (not rs.eof))
UserName = rs ("UserName")
MemberShip = rs ("MemberShip")
MemberPriority = rs ("MemberPriority")
If MemberShip > 5 Then
MemberShip = 5
End If
Email = rs ("Email")
P2S_End = rs ("P2S_End")
P2SJiFen_End = rs ("P2SJiFen_End")
i = i + 1
%>
<tr>
<td align="center" height="30"><%= i %></td>
<td align="center" height="30"><%= UserName %></td>
<td align="center" height="30"><%= MemberShip %></td>
<td align="center" height="30"><%= MemberPriority %></td>
<td align="center" height="30"><%= Email %></td>
<td align="center" height="30"><%= P2S_End %></td>
<td align="center" height="30"><%= P2SJiFen_End %></td>
<td align="center" height="30"><%= FormatNumber (P2SJiFen_End / P2S_End, 4 ,-1) %></td>
</tr>
<%
rs.MoveNext
Wend
rs.Close
%>
<% Else %>
<tr>
<td width="100%" align="center" height="30" colspan="8">现在会员数少于5名，无法开始竞赛。</td>
</tr>
<%
End If
Set rs = nothing
Conn.Close
Set Conn = nothing
%>
</table>
</div>
</td>
</tr>
<tr>
<td width="100%" align="center"><a href="javascript:history.back();"><b>返回</b></a></td>
</tr>
</table>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -