📄 ranking_game.jsp
字号:
</tr>
<!--痢急扼牢 场-->
</table>
</td>
</tr>
<!--珐欧 1困 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="5"></td>
</tr>
<!--咯归 场-->
<%
if(game_idx==0)//0724
{
sql = "select TOP " + pagesize + " idx, phonenum,nickname,"+columnName+ " from gt_gameranking where " +
" idx not in(select Top 1 idx from gt_gameranking order by "+columnName+ " desc )"+
" order by "+columnName+ " desc ";
rs = stmt.executeQuery(sql);
if(!rs.next()) // 蔼捞 绝阑锭
{
isNoPage = 1;
pagesize=0;
}
else // 蔼捞 乐阑锭 //rs.absolute(absolutepage);
{
for(int s=0; s<absolutepage-1; s++)
rs.next();
}
}else{
sql = "select gamerank_idx, phonenum,nickname,"+columnName+ " from "+boardname+" where " +
"gamerank_idx not in(select Top 1 gamerank_idx from "+boardname+" order by "+columnName+ " desc )"+
" order by "+columnName+ " desc ";
//out.println(sql);
rs = stmt.executeQuery(sql);
if(!rs.next()) // 蔼捞 绝阑锭
{
isNoPage = 1;
pagesize=0;
}
else // 蔼捞 乐阑锭 //rs.absolute(absolutepage);
{
for(int s=0; s<absolutepage-1; s++)
rs.next();
}
}
int count = 0 ; //其捞瘤 墨款磐 函荐
if (own_field==0){ //惑困
if (topHave==0 && recordCount==0){ //饭内靛啊 绝绰版快
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}else{//饭内靛 唱坷搁 等促.
//Rank = absolutepage;
if(pageNUM<2){
Rank=2;
}else{
Rank=(pageNUM-1)*4+2;
}
while(count<pagesize){
count++;
gamerank_idx=rs.getInt(1); //霸烙id
phonenum=rs.getString(2);
nickname=rs.getString(3);
gamerank_score=rs.getInt(4);
goUserHome = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum; //蜡历狼 葛喉肺弊肺 捞悼
if (mphone.equals(phonenum)) bgcolor="#fff999";
else bgcolor="#dae6e8";
%>
<!--珐欧2困 冠胶 矫累-->
<tr>
<td>
<table width="240" bgcolor="#dae6e8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="54" align="top" bgcolor="<%=bgcolor%>">
<!--酒官鸥 矫累-->
<table width="54" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=bgcolor%>">
<tr>
<td colspan="3" height="3" bgcolor="<%=bgcolor%>"></td>
</tr>
<tr>
<td width="3" bgcolor="<%=bgcolor%>"></td>
<td align="top" bgcolor="<%=bgcolor%>"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgcolor%>"></td>
</tr>
<tr>
<td colspan="3" height="3" bgcolor="<%=bgcolor%>"></td>
</tr>
</table>
<!--酒官鸥 场-->
</td>
<td bgcolor="<%=bgcolor%>" width="3"></td>
<td width="183" bgcolor="<%=bgcolor%>">
<!--珐欧郴侩 矫累-->
<table width="183" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" height="5"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#ff4877"><%=Rank%>困</font> <a href="<%=goUserHome%>"><%=nickname%></a></td>
<td width="10" align="right" >
<%
if(Rank==2) out.println("<img pictosrc='34' src='"+ img_path +" /images/game/temp_06.png'>");
else if(Rank==3) out.println("<img pictosrc='34' src='"+ img_path +"/images/game/temp_07.png'>");
else if(Rank==1) out.println("<img pictosrc='32' src='"+ img_path +"/images/game/temp_05.png'>");
%>
</td>
<td width="7"></td>
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#b4b4b4" size="3"><%=gamerank_score%>痢</font></td>
<td width="10" align="right"></td>
<td width="7"></td>
</tr>
</table>
<!--珐欧郴侩 场-->
</td>
</tr>
</table>
</td>
</tr>
<!--珐欧2困 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<%
Rank++;
if(rs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
rs.next();
}
}//while
}
}else{
//Rank = absolutepage;
if(pageNUM<2){
Rank=2;
}else{
Rank=(pageNUM-1)*4+2;
}
while(count<pagesize){
count++;
gamerank_idx=rs.getInt(1); //霸烙id
phonenum=rs.getString(2);
nickname=rs.getString(3);
gamerank_score=rs.getInt(4);
goUserHome = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum; //蜡历狼 葛喉肺弊肺 捞悼
if (mphone.equals(phonenum)) bgcolor="#fff999";
else bgcolor="#dae6e8";
%>
<tr>
<td>
<table width="240" bgcolor="#dae6e8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="54" align="top" bgcolor="<%=bgcolor%>">
<!--酒官鸥 矫累-->
<table width="54" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=bgcolor%>">
<tr>
<td colspan="3" height="3" bgcolor="<%=bgcolor%>"></td>
</tr>
<tr>
<td width="3" bgcolor="<%=bgcolor%>"></td>
<td align="top" bgcolor="<%=bgcolor%>"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgcolor%>"></td>
</tr>
<tr>
<td colspan="3" height="3" bgcolor="<%=bgcolor%>"></td>
</tr>
</table>
<!--酒官鸥 场-->
</td>
<td bgcolor="<%=bgcolor%>" width="3"></td>
<td width="183" bgcolor="<%=bgcolor%>">
<!--珐欧郴侩 矫累-->
<table width="183" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=bgcolor%>">
<tr>
<td colspan="4" height="5"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#ff4877"><%=Rank%>困</font>
<a href="<%=goUserHome%>"><%=nickname%>
</a>
</td>
<td width="10" align="right" >
<%
if(Rank==2) out.println("<img pictosrc='34' src='"+ img_path +" /images/game/temp_06.png'>");
else if(Rank==3) out.println("<img pictosrc='34' src='"+ img_path +"/images/game/temp_07.png'>");
else if(Rank==1) out.println("<img pictosrc='32' src='"+ img_path +"/images/game/temp_05.png'>");
%>
</td>
<td width="7"></td>
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#b4b4b4" size="3"><%=gamerank_score%>痢</font></td>
<td width="10" align="right" ></td>
<td width="7"></td>
</tr>
</table>
<!--珐欧郴侩 场-->
</td>
</tr>
</table>
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<%
Rank++;
if(rs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
rs.next();
}
}
}
%>
<tr>
<td>
<!--其捞瘤 傅农 矫累-->
<table width="240" bgcolor="#e5ecff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="19" colspan="6" bgcolor="#FEF4C2" valign="bottom" align="center">
<%//其捞瘤 备泅何
int limit = 5 ; //其捞瘤 府胶飘 俺荐 瘤沥
int temp =(pageNUM-1) % limit ; //矫累 其捞瘤 备窍扁
int startPage = pageNUM - temp;
%>
<%// [捞傈] 傅农 眠啊窍扁
if ((startPage-limit)>0){ %>
<a href="<%=pageurl%>&pageNUM=<%=startPage-1%>"><font color="#DB1A00">捞傈</font></a>
<%}
//其捞瘤 锅龋 唱凯窍扁
if(isNoPage == 0)
{
for(int i=startPage ; i<(startPage+limit);i++)
{
if( i == pageNUM)
{%>
<font color="#DB1A00"><b><%=i%></b></font>
<% }
else
{ %>
<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>
<% }
if(i >= pagecount) break;
}
}
else
out.println("钎矫 且 郴侩捞 绝嚼聪促.");
//[促澜] 傅农 眠啊
if((startPage+limit)<=pagecount){ %>
<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>
<%}
%>
</td>
</tr>
</table>
<!--其捞瘤 傅农 场-->
</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="23"></td>
<td width="96" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF"><a href='<%=url_path+"/ranking/game_gamename.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx%>'>霸烙窍扁</a></font></td>
<td width="2"></td>
<td width="96" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF"><a href='<%=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone%>'>鸥款珐欧权栏肺</a></font></td>
<td width="23"></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>
<%@ include file="../newbottom.jsp"%>
</form>
</body>
</html>
<%
}
catch (Exception e)
{
out.println(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 + -