📄 play_gameranking.jsp.svn-base

📁 用手机浏览的一个类似于聊天室博克 homepage 等对这方面有兴趣的朋友有所帮助的
💻 SVN-BASE
📖 第 1 页 / 共 2 页
字号:
上一页 12
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="61"></td>
		</tr>

		<tr height="3">
			<td width="61"></td>
			<td width="3"></td>
			<td width="48"></td>
			<td width="3"></td>
			<td width="61"></td>
		</tr>
	</table>

	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="35">
			<td width="20"></td>
			<td width="136" bgcolor="#F3F3F3" align="center" valign="middle">
				<font color="#616667"><a href="<%=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+monthTopPhone%>"><font color="#616667"><%=monthTopNickname%></font></a></font>&nbsp;<font color="#000000">丛</font><br>
				<font color="#616667"><%=monthTopScore%></font>&nbsp;<font color="#000000">痢</font><br>
			</td>
			<td width="20"></td>
		</tr>

		<tr height="10">
			<td width="20"></td>
			<td width="136"></td>
			<td width="20"></td>
		</tr>
	</table>
<%
}//1困啊 粮犁茄促搁 谎赴促. 场
%>
	<!--// my game ranking //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="5">
			<td width="10"></td>
			<td width="171"></td>
		</tr>

		<tr height="15">
			<td width="5"></td>
			<td width="171" align="left" valign="middle">
				<font color="#ECAAFF">≮</font><font color="#9819E9">My 霸烙 珐欧</font>
			</td>
		</tr>
	</table>

	<!--// dotted line //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="2">
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
		</tr>
	</table>

	<!--// user information section //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="2">
			<td width="3"></td>
			<td width="48"></td>
			<td width="3"></td>
			<td width="3"></td>
			<td width="119"></td>
		</tr>

		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="54">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48">
				<%
					if(isMember==1) 
						out.println("<img src='"+ava_path+"display_thumb.jsp?mphone="+mphone+"' border='0'>");  
					else out.println("<img src='"+img_path+"/images/202img/202_game/nomember_thumb.png' border='0'>");
				%>
			</td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8">
				<table width="119" border="0" cellspacing="0" cellpadding="0">
					<tr height="12">
						<td width="10"></td>
						<td width="25"></td>
						<td width="74"></td>
						<td width="10"></td>
					</tr>
					
					<tr height="15">
						<td width="10"></td>
						<td width="25" align="left" valign="middle">
							<font color="#000000"><%=myRank%>困</font>
						</td>
						<td width="74" align="right" valign="middle">
							<font color="#000000"><%=myScore%>痢</font>
						</td>
					</tr>
				</table>

				<table width="119" border="0" cellspacing="0" cellpadding="0">					
					<tr height="15">
						<td width="10"></td>
						<td width="99">
							<font color="#000000"><%=myNickname%><% if(isMember==0) out.println("(厚雀盔)"); %></font>
						</td>
						<td width="10"></td>
					</tr>
					
					<tr height="12">
						<td width="10"></td>
						<td width="99"></td>
						<td width="10"></td>
					</tr>
				</table>
			</td>
		</tr>

		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="3">
			<td width="176" colspan="5"></td>
		</tr>
	</table>

	<!--// game menu links //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="16">
			<td width="2"></td>
			<td width="85" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/start_game.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">霸烙促矫窍扁</font></a>
			</td>
			<td width="2"></td>
			<td width="85" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/game.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">霸烙权栏肺</font></a>
			</td>
			<td width="2"></td>
		</tr>

		<tr height="10">
			<td width="176" colspan="5"></td>
		</tr>
	</table>

	<!--// today's ranking //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="5">
			<td width="10"></td>
			<td width="171"></td>
		</tr>

		<tr height="15">
			<td width="5"></td>
			<td width="171" align="left" valign="middle">
				<font color="#ECAAFF">≮</font><font color="#9819E9">坷疵狼 珐欧</font>
			</td>
		</tr>
	</table>

	<!--// dotted line //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="2">
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
		</tr>
	</table>

	<!--// user information section #1 //-->
<%
try
{
	query1 = "select count(gamerank_idx) from "+boardname;
	pageset = stmt.executeQuery(query1);

	if(pageset.next()){
		dbcount = pageset.getInt(1);  // 臂 醚 肮荐
		pageset.close();
		if(dbcount > 100) dbcount = 100;	//弥措 100俺父 备茄促.
	}

	if(dbcount%pagesize == 0)
		pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
	else
		pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁


	if(request.getParameter("pageNUM")!=null)
	{
		pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
		absolutepage=(pageNUM-1)*pagesize+1;
	}

	String str = "select top 100 gamerank_idx, "+boardname+".phonenum, GT_user_info.nickname, gamerank_today ";
	str = str + " from GT_user_info,"+boardname+" where GT_user_info.phonenum="+boardname+".phonenum order by gamerank_today desc, gamerank_date desc";

	rs = stmt.executeQuery(str);	
	if(!rs.next()) // 蔼捞 绝阑锭
	{
		isNoPage = 1;
		pagesize=0;
	}
	else         // 蔼捞 乐阑锭	//rs.absolute(absolutepage);
	{				
		for(int s=0; s<absolutepage-1; s++)
			rs.next();
		rankCnt = absolutepage;
	}

	int count = 0 ; //其捞瘤 墨款磐 函荐
	while(count < pagesize)
	{ 
		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;	//蜡历狼 葛喉肺弊肺 捞悼
%>
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="2">
			<td width="3"></td>
			<td width="48"></td>
			<td width="3"></td>
			<td width="3"></td>
			<td width="119"></td>
		</tr>

		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="54">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48">
				<img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0">
			</td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8">
				<table width="119" border="0" cellspacing="0" cellpadding="0">
					<tr height="12">
						<td width="10"></td>
						<td width="25"></td>
						<td width="74"></td>
						<td width="10"></td>
					</tr>
					
					<tr height="15">
						<td width="10"></td>
						<td width="25" align="left" valign="middle">
							<font color="#000000"><%=rankCnt%>困</font>
						</td>
						<td width="74" align="right" valign="middle">
							<font color="#000000"><%=gamerank_score%>痢</font>
						</td>
					</tr>
				</table>

				<table width="119" border="0" cellspacing="0" cellpadding="0">					
					<tr height="15">
						<td width="10"></td>
						<td width="99">
							<font color="#000000"><a href="<%=goUserHome%>"><%=nickname%></a></font>
						</td>
						<td width="10"></td>
					</tr>
					
					<tr height="12">
						<td width="10"></td>
						<td width="99"></td>
						<td width="10"></td>
					</tr>
				</table>
			</td>
		</tr>

		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="119" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="3">
			<td width="176" colspan="5"></td>
		</tr>
	</table>
<%
		if(rs.isLast())
		{ //盖 付瘤阜 饭内靛 老版快
			 break;
		}
		else
		{
			rs.next();
			rankCnt++;
		}
		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(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){}
}
%>

	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="16">
			<td width="176" bgcolor="#EEE2FF" align="center">
<%//其捞瘤 备泅何
	int limit = 4 ;   //其捞瘤 府胶飘 俺荐 瘤沥	
	int temp =(pageNUM-1) % limit ;	//矫累 其捞瘤 备窍扁
	int startPage = pageNUM - temp;
	String pageurl = url_path+"/ranking/play_gameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx;
%>

<%// [捞傈] 傅农 眠啊窍扁
   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>
	</table>

	<!--// ranking menu link //-->
	<table width="176" border="0" cellspacing="0" cellpadding="0">
		<tr height="16">
			<td width="40"></td>
			<td width="96" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/ranking_main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">鸥款珐欧栏肺</font></a>
			</td>
			<td width="40"></td>
		</tr>

		<tr height="10">
			<td width="176" colspan="3"></td>
		</tr>
	</table>

	<!--// footer : common //-->
	<%
	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;霸烙珐欧</td>
			<td width="7" bgcolor="#BBC7C8"></td>
		</tr>
	</table>
	<%@ include file="../newbottom.jsp"%>
</body>
</html>
上一页 12
💿 文件大小 8175 K
👤 上传用户 iamguest88
📂 所属分类通讯/手机编程
🏷️ 相关标签

#homepage #手机 #方面
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -