📄 ranking_result.jsp
字号:
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+"')";
rs=stmt.executeQuery(sql);
if(rs.next())
{
recordCount = rs.getInt("recCount");
pagecount = ((recordCount-1)/pagesize) +1;
}
else pagesize=0;
rs.close();
%>
<html>
<head>
<title>ranking_game</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑窜 官 -->
<table width="240" 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="240" height="19"><font color="#ffffff"> 霸烙搬苞</font></td>
</tr>
</table>
<!-- 惑窜 官 场 -->
</td>
</tr>
<!--
<tr>
<td height="12"></td>
</tr>
<tr>
<td align="center"><font color="#909090">霸烙阑 急琶窍矫搁<br>秦寸 霸烙狼 珐欧阑 焊角 荐 乐绢夸~<br>∝ 300困鼻 观篮 焊咯瘤瘤 臼嚼聪促</font></td>
</tr>
<tr>
<td height="12"></td>
</tr>
<tr>
<td width="240">
<table width="240" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="38"></td>
<td width="130">
<select name="game_idx" >
<%
gameArrIndex = 0;
while(gameArrIndex < gameNameCnt)
{
if(game_idx==gameIdx[gameArrIndex])
out.println("<option selected value='"+gameIdx[gameArrIndex]+"' >"+gameNameList[gameArrIndex]+"</option>");
else
out.println("<option value='"+gameIdx[gameArrIndex]+"'>"+gameNameList[gameArrIndex]+"</option>");
gameArrIndex++;
}
%>
</select>
</td>
<td width="34" bgcolor="#ffaec5" align="center"><font color="#ffffff"><a href="javascript:form.submit()">焊扁</a></font></td>
<td width="38"></td>
</tr>
</table>
</td>
</tr>
-->
<tr>
<td height="12"></td>
</tr>
<tr>
<td width="240">
<table align="center" border="0" cellpadding="0" cellspacing="0" width="240"><tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="240">
<tr height="1">
<td width="37"></td>
<td width="166" bgcolor="#909090"></td>
<td width="37"></td>
</tr>
<tr>
<td align="center" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" width="167">
<tr height="18">
<td width="1" bgcolor="#909090"></td>
<% if(searchRange != 1){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink1%>"><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(searchRange != 2){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink2%>"><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(searchRange != 3){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=RangeLink3%>"><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_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="5"></td>
</tr>
<tr>
<td>
<table width="240" 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/<%=qvga_img%>"></td>
<td height="40" align="center" bgcolor="#ffa7b5" width="205"><font color="#ffffff">* <%=turmText%> <<%=game_title%>> *<br><%=own_msg%> 珐欧涝聪促.</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="240" 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="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=<%=topPhone %>" 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><a href="#"><font color="#000000"><a href='<%=url_path+"/mypage/my_confirm.jsp?"+"mphone="+mphone+"&gphone="+topPhone %>'><%=topNickname %></a></font></a></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锅掳 府胶飘 矫累 -->
<%
if (own_field==1)
{
sql = "SELECT TOP " + pagesize + " gamerank_idx,phonenum,nickname,"+columnName;
sql = sql + " ,Rank=";
sql = sql + " (SELECT COUNT(*)+1 FROM "+boardname;
sql = sql + " WHERE (a."+columnName+"<"+columnName+" or (a."+columnName+"="+columnName+" and a.phonenum<phonenum ))";
sql = sql + whereStr;
sql = sql + ")";
sql = sql + " FROM "+boardname+" a";
sql = sql + " WHERE gamerank_idx not in ";
sql = sql + "(SELECT TOP " + ((gotoPage - 1) * pagesize) + " gamerank_idx FROM "+boardname+" WHERE phonenum<>'1234' "+whereStr;
sql = sql + " ORDER BY "+columnName+" desc ,phonenum desc) and phonenum<>'1234' "+whereStr+" order by "+columnName+" desc ,phonenum desc";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -