" Response.write "【赢家排行】
" Response.write "排行榜按照净胜局数排列,比如赢10局输5局,则净胜5局
" set rs=Server.CreateObject("ADODB.Recordset") rsppl="select userid,jdnum,id from YD_plist where jdnum > 0 order by jdnum desc" rs.open rsppl,ydzqconn,1,1 If Not rs.eof Then Dim PageSize,i PageSize=10 Dim Count,page,pagecount,gopage gopage="pk_top.asp?sid="&sid&"&" Count=rs.recordcount page=int(request.QueryString ("page")) if page<=0 or page="" then page=1 pagecount=(count+pagesize-1)\pagesize if page>pagecount then page=pagecount rs.move(pagesize*(page-1)) For i=1 To PageSize If rs.eof Then Exit For set rs1=Server.CreateObject("ADODB.Recordset") rs1.open"select name from Users where id="&rs("userid")&" order by id desc",conn,1,1 Response.write ""&ubb(rs1("name"))&"(ID:"&ubb(rs("userid"))&")[胜"&rs("jdnum")&"局]
" rs1.close set rs1=nothing rs.moveNext Next if page-pagecount<0 then response.write "下页" if page>1 then response.write "上页" if pagecount>1 then response.write "
"&page&"/"&pagecount&"页跳转
" Else Response.write "暂无相关记录！
" end if rs.close set rs=nothing ydzqconn.close set ydzqconn=nothing conn.close set conn=nothing %> -------------