能排行转生次数的排行榜
<!--#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里面的字段名是自己重新写的,字段名全部不一样，呵呵!
|
