ranking_mygameranking.jsp.svn-base

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

<tr>
  <td height="9" colspan="2"></td>
</tr>
<tr>
  <td colspan="2" align="center">
    <font color="#909090">墨抛绊府甫<br>
    急琶窍矫搁 弊 墨抛绊府狼 珐欧阑<br>
    焊角 荐 乐绢夸~ </font>
  </td>
</tr>
<tr>
  <td height="5" colspan="2" align="center"></td>
</tr>
<tr>
  <td colspan="2" align="center">
	<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="120" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td align="center">
        <select name="subto">
          <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" height="20" align="center" bgcolor="#FFAEC5"><a href="javascript:form.submit()"><font color="#FFFFFF">焊扁</font></a></td>
    </tr>
    </table>
	</form>
  </td>
</tr>
<tr>
  <td height="10" colspan="2"></td>
</tr>
<tr>
  <td colspan="2" align="center">
	<a href="<%=RangeLink1%>"><font color="#FF6780">坷疵</font></a> <font color="#FFAEC5">|</font> 
	<a href="<%=RangeLink2%>"><font color="#FF6780">林埃</font></a> <font color="#FFAEC5">|</font> 
	<a href="<%=RangeLink3%>"><font color="#FF6780">岿埃</font></a>
  </td>
</tr>
<tr>
  <td height="4" colspan="2"></td>
</tr>
<tr>
  <td height="36" colspan="2" align="center" bgcolor="#FFE0E4">
    <font color="#FF4759">&lt;<a href="<%=goMoblog%>"><%=mynickname%></a>&gt;丛狼<br>
    <%=turmText%> 霸烙 珐欧 涝聪促. </font>
  </td>
</tr>
<tr>
  <td height="3" colspan="2"></td>
</tr>



<%
	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 colspan="2">
    <table width="176" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="3" colspan="3" bgcolor="#E1EEF1"></td>
      <td width="3" rowspan="3">&nbsp;</td>
      <td width="119" rowspan="3" align="center" bgcolor="#E1EEF1">
        <table width="110" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="98" height="16"><font color="#7C8889"><%=game_title%> </font></td>
          <td>
		  <%	if(myRank==1) out.println("<img src='"+img_path+"images/202img/202_ranking/medal_1.png' width=11 height=14>"); 
				else if(myRank==2) out.println("<img src='"+img_path+"images/202img/202_ranking/medal_2.png' width=11 height=14>");
				else if(myRank==3) out.println("<img src='"+img_path+"images/202img/202_ranking/medal_3.png' width=11 height=14>");
		  %> 
		  </td>
        </tr>
        <tr>
          <td height="16" 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" bgcolor="#E1EEF1">&nbsp;</td>
      <td width="48"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=tphone%>" ></td>
      <td width="3" bgcolor="#E1EEF1">&nbsp;</td>
    </tr>
    <tr>
      <td height="3" colspan="3" bgcolor="#E1EEF1"></td>
    </tr>
    </table>
  </td>
</tr>
<tr>
  <td height="3" colspan="2"></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){}
}
%>




<tr>
  <td height="16" 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>&nbsp;
   <%}
   //其捞瘤 锅龋 唱凯窍扁
   if(isNoPage == 0)
   {
	 for(int i=startPage ; i<(startPage+limit);i++)
     {
	   if( i == pageNUM)
	   {%>
			<font color="#DB1A00"><b><%=i%></b></font>&nbsp;
	<% }
	   else
	   { %>
			<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>&nbsp;
    <% }
	   if(i >= pagecount) break;
	 }
   }
   else
	  out.println("钎矫 且 郴侩捞 绝嚼聪促.");
   //[促澜] 傅农 眠啊
   if((startPage+limit)<=pagecount){ %>
	<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>&nbsp;
   <%}
%>
  </td>
</tr>
<tr>
  <td height="3" colspan="2"></td>
</tr>
<tr>
  <td colspan="2" align="center">
    <table width="85" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="14" align="center" 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="176" border="0" cellspacing="0" cellpadding="0">
  <tr height="15">
    <td width="7" bgcolor="#BBC7C8"></td>
    <td width="162" bgcolor="#DAE6E8"><a href="<%=step1%>">权</a>&gt;<a href="<%=step2%>">鸥款珐欧</a>&gt;<%=mynickname%>丛狼珐欧</td>
    <td width="7" bgcolor="#BBC7C8"></td>
  </tr>
</table>
<%@ include file="../newbottom.jsp"%>	  
  </td>
</tr>
</table>
</body>
</html>