📄 ranking_result.jsp
字号:
while(rs.next())
{
gameIdx[gameArrIndex] = rs.getInt(1);
gameNameList[gameArrIndex] = rs.getString(2);
gameArrIndex++;
}
rs.close();
RangeLink1 = url_path+"/ranking/ranking_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=1&own_field="+own_field;//坷疵
RangeLink2 = url_path+"/ranking/ranking_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=2&own_field="+own_field;//捞锅林
RangeLink3 = url_path+"/ranking/ranking_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=3&own_field="+own_field;//捞锅崔
/**************************************
3.傈眉霸烙(饭内靛 墨款飘)
***************************************/
sql = " SELECT count(phonenum) as recCount from "+boardname ;
sql = sql + " WHERE phonenum<>1234 "+whereStr;
if (own_field==0) sql=sql+" and phonenum not in('"+topPhone+"')";
//out.println(sql);
//if (true) return;
rs=stmt.executeQuery(sql);
if(rs.next())
{
recordCount = rs.getInt("recCount");
pagecount = ((recordCount-1)/pagesize) +1;
}
else pagesize=0;
rs.close();
%>
<html>
<head>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑窜 官 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8" background="<%=img_path%>images/ranking/bg_01.png"></td>
<td background="<%=img_path%>images/ranking/bg_01.png" width="168" height="19"><font color="#ffffff">霸烙搬苞</font></td>
</tr>
</table>
<!-- 惑窜 官 场 -->
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
<!-- 坷疵滚瓢 劝己拳 -->
<tr>
<td width="176">
<table align="center" border="0" cellpadding="0" cellspacing="0" width="176"><tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="176">
<tr height="1">
<td width="20"></td>
<td width="136" bgcolor="#909090"></td>
<td width="20"></td>
</tr>
<tr>
<td align="center" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" width="137">
<tr height="18">
<td width="1" bgcolor="#909090"></td>
<% if(searchRange!=1){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink1%>"><font color="#606060">坷疵</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">坷疵</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(searchRange!=2){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink2%>"><font color="#606060">林埃</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">林埃</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(searchRange!=3){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink3%>"><font color="#606060">穿利</font></a>
</td>
<% }else{ %>
<td width="44" 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="176" bgcolor="#909090" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<!-- 林埃滚瓢 劝己拳 -->
<!--
<tr>
<td width="176">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="23" background="<%=img_path%>images/ranking/tab_01.png"></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_01.png" border="0"></a></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_04.png" border="0"></a></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_05.png" border="0"></a></td>
<td width="24" background="<%=img_path%>images/ranking/tab_01.png"></td>
</tr>
</table>
</td>
</tr>
-->
<!-- 穿利滚瓢 劝己拳 -->
<!--
<tr>
<td width="176">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="23" background="<%=img_path%>images/ranking/tab_01.png"></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_01.png" border="0"></a></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_03.png" border="0"></a></td>
<td width="43" align="center"><a href="#"><img src="<%=img_path%>images/ranking/ico_06.png" border="0"></a></td>
<td width="24" background="<%=img_path%>images/ranking/tab_01.png"></td>
</tr>
</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_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&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_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field=1'>磊脚</a></font>");
}
%> </td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="3">
<td bgcolor="#ffa7b5"></td>
<td bgcolor="#ffa7b5"></td>
<td bgcolor="#ffa7b5"></td>
</tr>
<tr>
<td bgcolor="#ffa7b5" width="8"></td>
<td bgcolor="#ffa7b5" width="27"><img src="<%=img_path%>images/game/<%=qcif_img%>"></td>
<!--坷疵滚瓢 劝己拳老 版快-->
<td height="40" align="center" bgcolor="#ffa7b5"><font color="#ffffff"><%=turmText%><br>*<<%=game_title%>>*<br><%=own_msg%> 珐欧涝聪促.</font></td>
<!--林埃滚瓢 劝己拳老 版快-->
<!--
<td height="40" align="center" bgcolor="#ffa7b5"><font color="#ffffff">林埃<br>*<柠令空-楷局,胶器明>*<br>痢荐 惑困 珐欧涝聪促.</font></td>
-->
<!--穿利滚瓢 劝己拳老 版快-->
<!--
<td height="40" align="center" bgcolor="#ffa7b5"><font color="#ffffff">穿利<br>*<柠令空-楷局,胶器明>*<br>痢荐 惑困 珐欧涝聪促.</font></td>
-->
</tr>
<tr height="3">
<td bgcolor="#ffa7b5"></td>
<td bgcolor="#ffa7b5"></td>
<td bgcolor="#ffa7b5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<% if (!(own_field==1 && (member_join.equals("NO") || member_rank.equals("NO") )) && (recordCount!=0)){%>
<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 (topHave==1 && own_field==0)
{
%>
<tr>
<td height="5" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="38"></td>
<td width="54" bgcolor="#ffe0e4" align="center"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=topPhone%>" border="0"></td>
<td width="7"></td>
<td width="77">
<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="+topPhone%>'><%=topNickname%></a></font></td></tr>
<tr><td><font color="#7c8889"><%=topScore%>痢</font></td></tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 矫累 -->
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="2">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="6">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr>
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" align="center"><%=topIntro%></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="6">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="2">
<td width="6"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 场 -->
<tr>
<td height="4"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="5" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td height="4"></td>
</tr>
<%
}
%>
<%
if (own_field==1)
{
sql = "SELECT TOP " + pagesize + " gamerank_idx,phonenum,nickname,"+columnName;
sql = sql + " ,Rank=";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -