📄 memberrefquery_do.asp
字号:
<%@ LANGUAGE = VBScript %>
<!--#include file="conn.asp"-->
<!--#include file="checklogin.asp"-->
<%
UserName = Request ("UserName")
rs.Open "Select * From member Where Referral = '" & UserName & "' order by Active, Valid, NoReferral DESC, Vacation DESC, SignupTime",Conn
%>
<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="100%" bordercolor="#A50F18">
<tr>
<td width="4%" height="30" align="center">编号</td>
<td width="3%" height="30" align="center">级别</td>
<td width="17%" height="30" align="center">电子邮件地址</td>
<td width="12%" height="30" align="center">用户名</td>
<td width="8%" height="30" align="center">密码</td>
<td width="8%" height="30" align="center">注册时间</td>
<td width="8%" height="30" align="center">注册IP</td>
<td width="8%" height="30" align="center">代理IP</td>
<td width="8%" height="30" align="center">是否随机下线</td>
<td width="8%" height="30" align="center">个人佣金</td>
<td width="8%" height="30" align="center">假期模式</td>
<td width="8%" height="30" align="center">激活状态</td>
<td width="8%" height="30" align="center">有效性</td>
</tr>
<%
While Not rs.EOF
SignupBonus = rs ("SignupBonus")
Dollars = rs ("Dollars")
Dollars1 = rs ("Dollars1")
Dollars2 = rs ("Dollars2")
Dollars3 = rs ("Dollars3")
Dollars4 = rs ("Dollars4")
Dollars5 = rs ("Dollars5")
Dollars6 = rs ("Dollars6")
DollarsCredits = rs ("DollarsCredits")
DollarsDebits = rs ("DollarsDebits")
AllDollars = SignupBonus + Dollars + Dollars1 + Dollars2 + Dollars3 + Dollars4 + Dollars5 + Dollars6 + DollarsCredits - DollarsDebits
ID = rs ("ID")
MemberShip = rs ("MemberShip")
Email = rs ("Email")
UserName = rs ("UserName")
PassWord = rs ("PW")
Referral = rs ("Referral")
SignupTime = rs ("SignupTime")
SignupIP = rs ("SignupIP")
ProxyIP = rs ("ProxyIP")
NoReferral = rs ("NoReferral")
PaymentAccount = rs ("PaymentAccount")
Vacation = rs ("Vacation")
Active = rs ("Active")
Valid = rs ("Valid")
%>
<tr>
<td width="4%" height="30" align="center"><%= ID %></td>
<td width="3%" height="30" align="center"><%= MemberShip %></td>
<td width="17%" height="30" align="center"><%= Email %></td>
<td width="12%" height="30" align="center"><%= UserName %></td>
<td width="8%" height="30" align="center"><%= PassWord %></td>
<td width="8%" height="30" align="center"><%= SignupTime %></td>
<td width="8%" height="30" align="center"><%= SignupIP %></td>
<td width="8%" height="30" align="center"><%= ProxyIP %></td>
<td width="8%" height="30" align="center"><%= NoReferral %></td>
<td width="8%" height="30" align="center"><%= alldollars %></td>
<td width="8%" height="30" align="center"><%= Vacation %></td>
<td width="8%" height="30" align="center"><%= Active %></td>
<td width="8%" height="30" align="center"><%= Valid %></td>
</tr>
<%
rs.MoveNext
Wend
rs.Close
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 + -