📄 ranking_mygameranking.jsp.svn-base
字号:
</tr>
<tr>
<td height="8" colspan="2"></td>
</tr>
<tr align="center">
<td height="16" colspan="2" valign="top"><font color="#808080">墨抛绊府甫 急琶窍矫搁<br>
弊 墨抛绊府狼 珐欧阑 焊角 荐 乐绢夸~</font> </td>
</tr>
<tr>
<td height="26" colspan="2" align="center" valign="bottom">
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_subto.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<table width="130" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="79" align="right"> <select name="subto" size="1">
<option value=1 <%if(subto.equals("1")) out.println("selected");%>>牢拱珐欧</option>
<option value=2 <%if(subto.equals("2")) out.println("selected");%>>墨其珐欧</option>
<option value=3 <%if(subto.equals("3")) out.println("selected");%>>瘤侥珐欧</option>
<option value=4 <%if(subto.equals("4")) out.println("selected");%>>傍皑珐欧</option>
<option value=5 <%if(subto.equals("5")) out.println("selected");%>>霸烙珐欧</option>
</select> </td>
<td width="34" align="center" bgcolor="#ff8eab"><a href="javascript:form.submit()"><font color="#FFFFFF">焊扁</font></a></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="25" colspan="2" align="center" valign="bottom">
<a href="<%=RangeLink1%>"><font color="#ff6780">坷疵</font></a> <font color="#ffaec5">l</font>
<a href="<%=RangeLink2%>"><font color="#ff6780">林埃</font></a> <font color="ffaec5">l</font>
<a href="<%=RangeLink3%>"><font color="#ff6780">岿埃</font></a>
</td>
</tr>
<tr>
<td height="4" colspan="2" align="center" valign="top"></td>
</tr>
<tr>
<td height="39" colspan="2" align="center" bgcolor="#ffe0e4"><font color="#ff4759"><<a href="<%=goMoblog%>"><%=mynickname%></a>>丛狼<br>
<%=turmText%> 霸烙 珐欧 涝聪促.</font></td>
</tr>
<tr>
<td height="70" colspan="2" align="center" valign="top"><table cellpadding="0" cellspacing="0">
<tr>
<td height="4" colspan="6"></td>
</tr>
<!-- 酒官鸥 1 府胶飘 扼牢 矫累 -->
<%
int count = 0 ; //其捞瘤 墨款磐 函荐
while(count < pagesize)
{
myRank = 0;
game_idx = rs.getInt(1);
game_title = rs.getString(2);
sql = "select "+columnName+" from GT_gamerank_"+game_idx +" where phonenum="+tphone+ whereStr; //霸烙狼 痢荐甫 啊廉柯促.
rs2 = stmt2.executeQuery(sql);
if(rs2.next())
{
myScore = rs2.getInt(1);//痢荐 啊廉柯促.
}
else myScore = -1; //痢荐啊 0 捞促. 敲贰弊 -1
if(myScore >= 0)
{
sql = "select phonenum from GT_gamerank_"+game_idx+" where "+columnName+">="+myScore + whereStr + " order by gamerank_score desc, gamerank_date desc";
rs2 = stmt2.executeQuery(sql);
int stopFlag = 1;
String myRankPhone="";
while(stopFlag==1)
{
if(rs2.next())//饭内靛啊 粮犁茄促.
{
myRankPhone = rs2.getString(1);
if(myRankPhone.equals(tphone))
{
stopFlag=0;
}
myRank++;
if(myRank>=300)//300困鼻 逞绢啊搁 //0712
{
myRank = -1;
stopFlag = 0;
}
}
else //饭内靛啊 粮犁窍瘤 臼绰促. 郴啊 1困促.
{
myRank=1;
stopFlag=0;
}
}
}
else
myRank = -1; //痢荐啊 绝芭唱 0痢捞促.
//strShow = url_path+"/diary/diary_guest2.jsp?diary_num="+diary_num+"&mphone="+mphone+"&gphone="+gphone;
%>
<tr>
<td width="3" height="3" bgcolor="#DAE6E8"></td>
<td width="48" height="3" bgcolor="#DAE6E8"></td>
<td width="3" height="3" bgcolor="#DAE6E8"></td>
<td width="3" height="3"></td>
<td width="8" height="3" bgcolor="#DAE6E8"></td>
<td width="175" height="3" bgcolor="#DAE6E8"></td>
</tr>
<tr>
<td width="3" height="54" bgcolor="#DAE6E8"></td>
<td width="48" height="54"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=tphone%>"></td>
<td width="3" height="54" bgcolor="#DAE6E8"></td>
<td width="3" height="54"></td>
<td width="8" height="54" bgcolor="#DAE6E8"></td>
<td width="175" height="54"> <table cellpadding="0" cellspacing="0" bgcolor="#DAE6E8">
<tr>
<td width="150" height="39"><font color="#888888"><%=game_title%></font></td>
<td width="25" align="center">
<% if(myRank==1) out.println("<img src='"+img_path+"images/296img/296_ranking/medal_1.png' width=12 height=15>");
else if(myRank==2) out.println("<img src='"+img_path+"images/296img/296_ranking/medal_2.png' width=12 height=15>");
else if(myRank==3) out.println("<img src='"+img_path+"images/296img/296_ranking/medal_3.png' width=12 height=15>");
%>
</td>
</tr>
<tr>
<td height="15" colspan="2">
<font color="#ff4759"><% if(myRank<0) out.println("300困鼻俊 绝嚼聪促."); else{ out.println(myRank+"困"); out.println(myScore+"痢"); } %></font> </td>
</tr>
</table></td>
</tr>
<tr>
<td width="3" height="3" bgcolor="#DAE6E8"></td>
<td width="48" height="3" bgcolor="#DAE6E8"></td>
<td width="3" height="3" bgcolor="#DAE6E8"></td>
<td width="3" height="3"></td>
<td width="8" height="3" bgcolor="#DAE6E8"></td>
<td width="175" height="3" bgcolor="#DAE6E8"></td>
</tr>
<!-- 酒官鸥 1 府胶飘 扼牢 场 -->
<tr>
<td height="3" colspan="6"></td>
</tr>
<%
if(rs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
rs.next();
}
count++;
}//end_while
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(con != null) con.close();
}
catch (Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(rs2 != null) try{rs2.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(stmt2 != null) try{stmt2.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>
</table></td>
</tr>
<tr>
<td height="3" colspan="2" align="center" valign="top"></td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td height="19" colspan="2" align="center" bgcolor="#ffe0e4">
<%//其捞瘤 备泅何
int limit = 4 ; //其捞瘤 府胶飘 俺荐 瘤沥
int temp =(pageNUM-1) % limit ; //矫累 其捞瘤 备窍扁
int startPage = pageNUM - temp;
String pageurl=url_path+"/ranking/ranking_mygameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&searchRange="+searchRange;
%>
<%// [捞傈] 傅农 眠啊窍扁
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>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td colspan="2"> <table width="96" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="17" align="center" valign="bottom" bgcolor="#ff8eab"><a href="<%=link2%>"><font color="#FFFFFF">鸥款珐欧权栏肺</font></a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td height="11" colspan="2">
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧
%>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<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>><%=mynickname%>丛狼珐欧</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -