📄 ranking_people.jsp
字号:
<td width="1" bgcolor="#909090"></td>
<% if (!table_field.equals("gt_count_week")){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field=gt_count_week&rankType="+rankType+"&own_field="+own_field%>"><font color="#606060">林埃</font></a>
</td>
<% }else{ %>
<td width="54" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">林埃</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if (!table_field.equals("gt_ranker")){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field=gt_ranker&rankType="+rankType+"&own_field="+own_field%>"><font color="#606060">穿利</font></a>
</td>
<% }else{ %>
<td width="54" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">穿利</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
</tr>
</table>
</td>
</tr>
<tr height="1">
<td width="240" bgcolor="#909090" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="5" align="center">
<%
if (own_field==1)
{
out.print("<a href='"+url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field="+table_field+"&rankType="+rankType+"&own_field=0'><font color='#FF9DAC'>惑困</font></a>");
out.print("<font color='#FF9DAC'> | </font><font color='#F60000'>磊脚</font>");
}
else
{
out.print("<font color='#F60000'>惑困</font>");
out.print("<font color='#FF9DAC'> | </font><font color='#FF9DAC'><a href='"+url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field="+table_field+"&rankType="+rankType+"&own_field=1'>磊脚</a></font>");
}
%>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<% if (!(own_field==1 && member_rank.equals("NO"))){%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f"><%=pagePath(pageurl, recordCount, gotoPage, pagecount)%></font></td>
</tr>
<%}%>
<tr height="3">
<td></td>
</tr>
<%
if (own_field==0)
{
%>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td width="240" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="64"></td>
<td width="54" bgcolor="#ffe0e4" align="center"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=topphonenum%>" border="0"></td>
<td width="13"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr><td><font color="#ff4759">1困</font> <img pictosrc='32' src="<%=img_path%>images/ranking/temp_03.png"></td></tr>
<tr><td><font color="#000000"><a href='<%=url_path+"/mypage/my_confirm.jsp?"+"mphone="+mphone+"&gphone="+topphonenum%>'><%=topnickname%></a></font></td></tr>
<tr><td><font color="#7c8889"><%=topscore%>痢</font></td></tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 矫累 -->
<tr>
<td>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr height="2">
<td width="13"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="212" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="11"></td>
</tr>
<tr height="5">
<td width="13"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="212"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="11"></td>
</tr>
<tr height="39">
<td width="13"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="212" align="center"><%=topintro%></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="11"></td>
</tr>
<tr height="6">
<td width="13"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="212"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="11"></td>
</tr>
<tr height="2">
<td width="13"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="212" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="11"></td>
</tr>
</table>
</td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 场 -->
<tr>
<td height="6"></td>
</tr>
<tr>
<td width="240" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<%
}
%>
<!-- 1锅掳 府胶飘 矫累 -->
<%
/**************************************
4.傈眉霸烙(其捞隆)
***************************************/
if (own_field==1)
{
sql = " SELECT phonenum,nickname,"+orderby_field+", Rank=";
sql = sql + " (SELECT COUNT(*)+1 FROM "+table_field;
sql = sql + " WHERE (B."+orderby_field+"<"+orderby_field+" or (B."+orderby_field+"="+orderby_field+" and B."+orderby_field2+"<"+orderby_field2+" )))";
sql = sql + " FROM ";
sql = sql + " (SELECT TOP " + pagesize + " "+orderby_field2+",phonenum,nickname,"+orderby_field;
sql = sql + " FROM ";
sql = sql + " (SELECT TOP " + (((gotoPage - 1) * pagesize)+pagesize) + " "+orderby_field2+",phonenum,nickname,"+orderby_field;
sql = sql + " FROM " + table_field + " WITH(NOLOCK) ";
sql = sql + " ORDER BY "+orderby_field+" DESC ,"+orderby_field2+" DESC)";
sql = sql + " A ORDER BY A."+orderby_field+" ,A."+orderby_field2+")";
sql = sql + " B ORDER BY B."+orderby_field+" DESC ,B."+orderby_field2+" DESC ";
}
else
{
sql = " SELECT phonenum,nickname,"+orderby_field+", Rank=";
sql = sql + " (SELECT COUNT(*)+1 FROM "+table_field;
sql = sql + " WHERE (B."+orderby_field+"<"+orderby_field+" or (B."+orderby_field+"="+orderby_field+" and B."+orderby_field2+"<"+orderby_field2+" )))";
sql = sql + " FROM ";
sql = sql + " (SELECT TOP " + pagesize + " "+orderby_field2+",phonenum,nickname,"+orderby_field;
sql = sql + " FROM ";
sql = sql + " (SELECT TOP " + (((gotoPage - 1) * pagesize)+pagesize) + " "+orderby_field2+",phonenum,nickname,"+orderby_field;
sql = sql + " FROM " + table_field + " WITH(NOLOCK) ";
sql = sql + " WHERE phonenum<>'"+topphonenum+"'";
sql = sql + " ORDER BY "+orderby_field+" DESC ,"+orderby_field2+" DESC)";
sql = sql + " A ";
sql = sql + " WHERE phonenum<>'"+topphonenum+"'";
sql = sql + " ORDER BY A."+orderby_field+" ,A."+orderby_field2+")";
sql = sql + " B ORDER BY B."+orderby_field+" DESC ,B."+orderby_field2+" DESC ";
}
//out.println(sql);
//if (true) return;
rs=stmt.executeQuery(sql);
if (!(member_rank.equals("NO") && own_field==1))
{
if (recordCount!=0)
{
while(rs.next())
{
phonenum=rs.getString("phonenum");
nickname=rs.getString("nickname");
score=rs.getInt(3);
rank=rs.getInt("Rank");
if (mphone.equals(phonenum)) bgcolor="#fff999";
else bgcolor="#dae6e8";
%>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="<%=bgcolor%>">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"> </td>
<td width="48" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="<%=bgcolor%>">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="153" height="14"><font color="#ff4759"><%=rank%>困</font> <font color="#000000"><a href='<%=url_path+"/mypage/my_confirm.jsp?"+"mphone="+mphone+"&gphone="+phonenum%>'><%=nickname%></a></font>
</td>
<td width="25">
<%
if(rank==2) out.println("<img pictosrc='33' src='"+img_path+"images/ranking/temp_04.png' width=11 height=14>");
else if(rank==3) out.println("<img pictosrc='34' src='"+img_path+"images/ranking/temp_05.png' width=11 height=14>");
else if(rank==1) out.println("<img pictosrc='32' src='"+img_path+"images/ranking/temp_03.png' width=11 height=14>");
%> </td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="153" height="15"><font color="#7c8889"><%=score%>痢</font></td>
<td width="25"></td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
} //while
}else{
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}
} //if (!(member_rank.equals("NO") && own_field==1))
rs.close();
%>
<% if (!(own_field==1 && member_rank.equals("NO"))){%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f"><%=pagePath(pageurl, recordCount, gotoPage, pagecount)%></font></td>
</tr>
<%}%>
<tr>
<td height="17"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goMyLink%>"><font color="#ff4759">牢拱珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goCafeLink%>"><font color="#ff4759">墨其珐欧</font></a></b></td>
</tr>
<tr>
<td height="4"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goKnowLink%>"><font color="#ff4759">瘤侥珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGongLink%>"><font color="#ff4759">傍皑珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGameLink%>"><font color="#ff4759">霸烙珐欧</font></a></b></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr align="center">
<td>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="72"></td>
<td width="96" bgcolor="#FF8EAB" align="center"><a href='<%=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone%>'><font color="#FFFFFF">鸥款珐欧权栏肺</font></a></td>
<td width="72"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<table width="240" border="0" cellspacing="0" cellpadding="0">
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧
%>
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td><a href="<%=step1%>">权</a>><a href="<%=step2%>">鸥款珐欧</a>>牢拱珐欧</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</form>
<%@ include file="../newbottom.jsp"%>
</body>
</html>
<%
}
catch (Exception e)
{
//out.println(e);
out.println(e);
throw e;
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) try{stmt.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -