|
<!--#include file="conn.asp" -->
<!--#include
file="top.asp" -->
<%
set
rs=server.createobject("adodb.recordset")
job=left(request("job"),4)
%>
<html>
<head>
<meta
http-equiv="content-type" content="text/html;
charset=gb2312">
<title><%=sitename%></title>
<style
language=javascript type=text/css>a {
color: #000000;
text-decoration: none; text-transform: none
}
a:hover {
color:
#ff0000; text-decoration: underline
}
</style>
<style
type=text/css>td {
font-size: 9pt
}
p {
font-size:
9pt
}
a:active {
text-decoration: none
}
a:hover
{
text-decoration: underline
}
a:link {
text-decoration:
none
}
a:visited {
text-decoration:
none
}
</style>
</head>
<body topmargin="0"
leftmargin="0" align=center bgcolor="#000000"><center>
<table width="80%" height="393"
background="images/top_bg5.gif">
<form action="userrz_ok.asp"
method="post">
<tr>
<td width="750" height="35"
valign="middle"> <p align="center">
<font
size=+1><b><%=muname%> <%=muip%>
<%=muport%></b></font></p></td>
</tr>
<font
color="#ffffff"><tr></font> <td height="353"
valign="top">
<div align="center">
<center>
<table border="1" width="82%" cellspacing="0"
cellpadding="0" height="103" background="images/top_bg5.gif"
style="border-collapse: collapse" bordercolor="#111111"
bordercolorlight="#000000">
<tr>
<td width="100%"
height="20" colspan="8"> <p align="center"><font
color="#000000">等级排行表</td>
</tr>
<tr>
<td width="100%" height="20" colspan="8"> <p
align="center"><a href="?job=32"><font
color="#ff0000">精灵
</font></a><font color="#ff0000">
</font><a href="?job=16"><font
color="#ff0000">剑士</font></a><font color="#ff0000">
</font><a href="?job=0"><font
color="#ff0000">法师</font></a><font color="#ff0000">
</font><a href="?job=17"><font
color="#ff0000">骑士</font></a><font
color="#ff0000">
</font><a href="?job=1"><font
color="#ff0000">魔导士</font></a><font
color="#ff0000">
</font><a href="?job=33"><font
color="#ff0000">圣射手</font></a><font
color="#ff0000">
</font><a href="?job=48"><font
color="#ff0000">魔剑士</font></a><font color="#ff0000">
</font><a href="?job="><font
color="#ff0000">总排行</font></a></td>
</tr>
<tr>
<td width="6%" height="21" valign="middle"> <p
align="center"><font
color="#000000">名次</font></td>
<td width="13%"
height="21" valign="middle"> <p align="center"><font
color="#000000">用户名</font></td>
<td width="8%"
height="21" valign="middle"> <p align="center"><font
color="#000000">等级</font></td>
<td width="25%"
height="21" valign="middle">
<p align="center"><font
color="#000000">能力值(力/敏/体/智/总点数)</font></td>
<td
width="11%" height="21" valign="middle"> <p
align="center"><font
color="#000000">个人财富</font></td>
<td width="8%"
height="21" valign="middle"> <p align="center"><font
color="#000000">pk值</font></td>
<td width="24%"
height="21" valign="middle"> <p align="center"><font
color="#000000">创建日期</font></td>
<td width="6%"
height="21" valign="middle"> <p align="center"><font
color="#000000">转生次数
</font></td></td></tr>
<%if
job="" then
sql="select
name,clevel,class,leveluppoint,strength,dexterity,vitality,energy,money,pktime,mdate,userzs
from
character order by sumlevel desc"
rs.open
sql,conn,1,1
else
sql="select
name,clevel,class,leveluppoint,strength,dexterity,vitality,energy,money,pktime,mdate,userzs
from character where
class="&job&" order by sumlevel desc"
rs.open
sql,conn,1,1
end if
if request("dy")<>empty
then
response.clear
response.write
"document.write(<table><tr><td colspan=3
align=center>waroy排行前"&request("dy")&"名</td></tr>);"
for
n=1 to rs.recordcount
if not rs.eof then
response.write
"document.write(<tr><td>第"&n&"名</td><td>"&rs("name")&"</td><td>"&rs("clevel")&"级</td></tr>);"
else
exit
for
end if
if n>=int(request("dy")) then exit
for
rs.movenext
next
response.write
"document.write(</table>)"
response.end
else
%>
<%do
while not rs.eof
i=i+1 %>
<tr>
<td width="6%" height="21" valign="middle"
align="center"><%=i%></td>
<td width="13%"
height="21" valign="middle"
align="center"><%=rs("name")%></td>
<td width="8%"
height="21" valign="middle"
align="center"><%=rs("clevel")%></td>
<td width="21%"
height="21" valign="middle"
align="center"><%=rs("strength")%>/<%=rs("dexterity")%>/<%=rs
("vitality")%>/<%=rs("energy")%>/<font
color="#ff0000"><%=rs("leveluppoint")+rs("strength")+rs("dexterity")+rs("vitality")
+rs("energy")%></font></td>
<td
width="11%" height="21" valign="middle"
align="center"><%=rs("money")%></td>
<td width="8%"
height="21" valign="middle"
align="center"><%=rs("pktime")%></td>
<td width="24%"
height="21" valign="middle"
align="center"><%=rs("mdate")%></td>
<td width="6%"
height="21" valign="middle"
align="center"><%=rs("userzs")%></td>
<p align="center"></td></tr>
<%
if i>=50 then exit do
rs.movenext
loop
end
if
rs.close
rslife.close
%>
</table>
<p><img border="0"
src="images/bt_confirm.gif" style="cursor:hand"
onclick="javascript:top.location.href=default.asp"></p>
</center>
</div>
<font
color="#ffffff"></td></font> <font
color="#ffffff"></tr></font>
</form>
</table>
</body>
</html><!--#include
file="copyright.asp" -->
需要注意的地方:
第一,必须character表中加入以下两个字段userzs,sumlevel,类型为int,在sumlevel内的公式栏加入以下代码
(clevel
+ userzs *
350)
第二,在转生页中必须加入
rs1("userzs")=转生次数
如果你使用的是我的需要果实转生的网页,可以直接升级果实转生网页搭配使用,升级具体可以看我网页的更新版本!
http://bbs.vzkj.com/dispbbs.asp?boardid=10&id=79737
只要你按照红色部分更改设置后，此排行榜对任何版本奇迹服务器均可使用,除非你的character里面的字段名是自己重新写的,字段名全部不一样，呵呵!
|