📄 community_rank.asp
字号:
<%
menutype = "community"
rank_type = trim(request("rank_type"))
if rank_type = "" then rank_type = "total"
%>
<!-- #include virtual = /common/top.asp -->
<%menu_down2 = "yes"%>
<%
if rank_type = "win" then
menu_down2_2 = "yes"
elseif rank_type = "money" then
menu_down2_3 = "yes"
else
menu_down2_1 = "yes"
end if
%>
<!-- #include virtual = /community/community_menu.asp -->
<table width="100%" bORDER="0" cellspacing="0" cellpadding="0" background="/community/images/bg_subbody.gif" height="100%">
<tr>
<td>
<div align="center"><img src="images/community_title_rank_<%=rank_type%>.gif" ></div>
</td>
</tr>
<tr>
<td valign="TOP">
<!-- #include virtual="/common/BombConnDB.asp" -->
<%
if rank_type="total" then
sql = "SELECT TOP 100 userid, cLevel, wincount, losecount, smoney, point, partner_tag "
sql = sql & " FROM IB_MEMBER "
sql = sql & " ORDER BY point DESC, smoney DESC, wincount DESC, losecount ASC, name ASC "
elseif rank_type="win" then
sql = "SELECT TOP 100 userid, cLevel, wincount, losecount, smoney, point, partner_tag "
sql = sql & " FROM IB_MEMBER "
sql = sql & " ORDER BY wincount DESC, losecount ASC, smoney DESC, point DESC, name ASC "
elseif rank_type="money" then
sql = "SELECT TOP 100 userid, cLevel, wincount, losecount, smoney, point, partner_tag "
sql = sql & " FROM IB_MEMBER "
sql = sql & " ORDER BY smoney DESC, point DESC, wincount DESC, losecount ASC, name ASC "
end if
set rs = DbCon.Execute(sql)
%>
<table width="587" bORDER="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="550" bORDER="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><img src="images/rank_title.gif"></td>
</tr>
</table>
<table width="550" border="0" cellspacing="0" cellpadding="0" align="center" class="rank_table">
<!-- <tr background="rank/images/rank_title_bg.gif">
<td width="38" align="center"><img src="images/rank_title_rank.gif" width="30" height="23"></td>
<td width="127" align="center"><img src="images/rank_title_id.gif" width="44" height="23"></td>
<td width="100" align="center"><img src="images/rank_title_medal.gif" width="31" height="23"></td>
<td width="93" align="center"><img src="images/rank_title_point.gif" width="46" height="23"></td>
<td width="48" align="center"><img src="images/rank_title_win.gif" width="17" height="23"></td>
<td width="49" align="center"><img src="images/rank_title_lose.gif" width="16" height="23"></td>
<td width="87" align="center"><img src="images/rank_title_money.gif" width="31" height="23"></td>
</tr>
<tr>
<td colspan="7" height="5" bgcolor="#87551F"></td>
</tr> -->
<%
i = 1
while not rs.EOF
partner_tag = rs("cLevel")
%>
<tr <%if (i mod 2) = 0 then%>bgcolor="#D8D8D8"<%else%>bgcolor="#EAEAEA"<%end if%>>
<td width="39" align="center"><%=i%></td>
<td width="133" align="center">
<%if rs("partner_tag") = "NM" then
response.write replace(rs("userid"),"NMB123456_","")
else
response.write rs("userid")
end if%></td>
<td width="90" height="26" valign="middle" align="center">
<% if rs("point") < 300 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n1.gif align=absmiddle > (LV.1)
<% elseif rs("point") >= 300 and rs("point") < 600 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n2.gif align=absmiddle > (LV.2)
<% elseif rs("point") >= 600 and rs("point") < 1200 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n3.gif align=absmiddle > (LV.3)
<% elseif rs("point") >= 1200 and rs("point") < 1800 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n4.gif align=absmiddle > (LV.4)
<% elseif rs("point") >= 1800 and rs("point") < 2400 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n5.gif align=absmiddle > (LV.5)
<% elseif rs("point") >= 2400 and rs("point") < 3000 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n6.gif align=absmiddle > (LV.6)
<% elseif rs("point") >= 3000 and rs("point") < 3900 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n7.gif align=absmiddle > (LV.7)
<% elseif rs("point") >= 3900 and rs("point") < 4800 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n8.gif align=absmiddle > (LV.8)
<% elseif rs("point") >= 4800 and rs("point") < 6000 then %>
<img src=/community/rank/medal/m1.gif align=absmiddle ><img src=/community/rank/medal/n9.gif align=absmiddle > (LV.9)
<% elseif rs("point") >= 6000 and rs("point") < 6300 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n1.gif align=absmiddle > (LV.10)
<% elseif rs("point") >= 6300 and rs("point") < 6600 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n2.gif align=absmiddle > (LV.11)
<% elseif rs("point") >= 6600 and rs("point") < 7200 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n3.gif align=absmiddle > (LV.12)
<% elseif rs("point") >= 7200 and rs("point") < 7800 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n4.gif align=absmiddle > (LV.13)
<% elseif rs("point") >= 7800 and rs("point") < 8400 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n5.gif align=absmiddle > (LV.14)
<% elseif rs("point") >= 8400 and rs("point") < 9000 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n6.gif align=absmiddle > (LV.15)
<% elseif rs("point") >= 9000 and rs("point") < 9900 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n7.gif align=absmiddle > (LV.16)
<% elseif rs("point") >= 9900 and rs("point") < 10800 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n8.gif align=absmiddle > (LV.17)
<% elseif rs("point") >= 10800 and rs("point") < 12000 then %>
<img src=/community/rank/medal/m2.gif align=absmiddle ><img src=/community/rank/medal/n9.gif align=absmiddle > (LV.18)
<% elseif rs("point") >= 12000 and rs("point") < 12600 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n1.gif align=absmiddle > (LV.19)
<% elseif rs("point") >= 12600 and rs("point") < 13200 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n2.gif align=absmiddle > (LV.20)
<% elseif rs("point") >= 13200 and rs("point") < 14400 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n3.gif align=absmiddle > (LV.21)
<% elseif rs("point") >= 14400 and rs("point") < 15600 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n4.gif align=absmiddle > (LV.22)
<% elseif rs("point") >= 15600 and rs("point") < 16800 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n5.gif align=absmiddle > (LV.23)
<% elseif rs("point") >= 16800 and rs("point") < 18000 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n6.gif align=absmiddle > (LV.24)
<% elseif rs("point") >= 18000 and rs("point") < 19800 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n7.gif align=absmiddle > (LV.25)
<% elseif rs("point") >= 19800 and rs("point") < 21600 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n8.gif align=absmiddle > (LV.26)
<% elseif rs("point") >= 21600 and rs("point") < 24000 then %>
<img src=/community/rank/medal/m3.gif align=absmiddle ><img src=/community/rank/medal/n9.gif align=absmiddle > (LV.27)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -