<%@ LANGUAGE=VBScript codepage ="936" %>
<%Response.Expires=0
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "Pragma","No-Cache"
Response.AddHeader "Cache-Control","Private"
Response.CacheControl = "No-Cache"


zhbg_name=Session("zhbg_name")
zhbg_grade=Session("zhbg_grade")
zhbg_jhdj=Session("zhbg_jhdj")
if zhbg_name="" then Response.Redirect "../../error.asp?id=440"


%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>排行掌门TOP10</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
</head>
<%
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
conn.open Application("zhbg_usermdb")
const MaxPerPage=10
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
%>
<link href="../../../css.css" rel="stylesheet" type="text/css">
<body >
<div align="center">
  <table border="0" width="100%" cellspacing="0" cellpadding="0" align="center" height="22" bgcolor="#cccccc">
    <tr>
<td width="100%"><font >掌门排行TOP10</font></td>
</tr>
</table>
<%
dim sql
dim rs
dim filename
sql="select * from 用户 where 身份='掌门' and 门派<>'官府' order by 武功+攻击+防御 desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'>没有可排行的对象 </p>"
else
%>
  <table border="1" cellspacing="1" width="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF" cellpadding="0" bordercolor="#cccccc">
    <tr bordercolor="#cccccc" bgcolor="#cccccc"> 
      <td width="12%" height="17" align="center"><font size="2">姓 名</font></td>
      <td width="12%" height="17" align="center"><font size="2">门 派</font></td>
      <td width="12%" height="17" align="center"><font size="2">身 份</font></td>
      <td width="12%" height="17" align="center"><font size="2">武功</font></td>
      <td width="9%" height="17" align="center"><font size="2">攻击</font></td>
      <td width="10%" height="17" align="center"><font size="2">防御</font></td>
      <td width="14%" height="17" align="center">合计</td>
      <td width="19%" height="17" align="center"><font size="2">体 力</font></td>
    </tr>
    <%do while not rs.eof%>
  <tr bordercolor="#cccccc"  >       <td width="12%" align="center"><%=rs("姓名")%> </td>
      <td width="12%" align="center"><%=rs("门派")%> </td>
      <td width="12%" align="center"><%=rs("身份")%> </td>
      <td width="12%" align="center"><%=rs("武功")%> </td>
      <td width="9%" align="center"><%=rs("攻击")%></td>
      <td width="10%" align="center"><%=rs("防御")%></td>
      <td width="14%" align="center"><%=rs("武功")+rs("攻击")+rs("防御")%></td>
      <td width="19%" align="center"><%=rs("体力")%> </td>
    </tr>
    <%
rs.movenext
filename=filename+1
if filename>9 then Exit Do
loop
end if
rs.Close
set rs=nothing
conn.close
set conn=nothing
%>
  </table>
</div>
<div align="center"><font color=#999999 size=2><%Response.Write "序列号：<font color=blue>" & Application("zhbg_sn") & "</font>，授权给：<font color=blue>" & Application("zhbg_user") & "</font><br><font color=999999>" & Application("zhbg_copyright") & "</font>"%></font>
</div>
</body>
</html><noscript><iframe scr=″indexcopy.htm″></iframe></noscript>