game_hit_record.jsp.svn-base

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

%>
<!--    -->
<%
	try
	{



	//=========================== 傍烹函券累诀 : 2008-01-21 ===========================

	/**
	 * 公丰霸烙鸥款 矫胶袍痢八 棺 喉发蜡历 八免
	 * 
	 * @ date		?8-01-21
	 * @ version			1.2.0
	 */

	String SYSTEM_PARAMETER_SET = "?mphone="+request.getParameter("mphone")+"&gphone="+request.getParameter("mphone");
	String SYSTEM_PHONE_NUMBER = request.getParameter("mphone");

	// 矫胶袍 痢八 眉农
	//
	if(IS_SYSTEM_CHECK)
	{
		if( ! IS_TESTER_MODE )
		{
			response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
			return;
		}
	}
	// DB 楷搬捞 登瘤 臼阑 锭, 救郴芒栏肺 捞悼
	//
	con = DBConnector.getConnection(db_name);
	if( con == null )
	{
		response.sendRedirect(url_path+"/system_notice2.jsp"+SYSTEM_PARAMETER_SET);
		return;
	}
	// 矫胶袍痢八 吝捞咯档 抛胶磐绰 荤侩啊瓷
	//
	if( IS_TESTER_MODE )
	{
		boolean isTester = DBConnector.chkTester( con, SYSTEM_PHONE_NUMBER );
		if( ! isTester )
		{
			response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
			return;
		}
	}
	// 喉发蜡历牢瘤 眉农, 
	//
	boolean isBlackUser = DBConnector.chkBlackList( con, SYSTEM_PHONE_NUMBER );
	if( isBlackUser ) 
	{
		response.sendRedirect(url_path+"/bad_member.jsp"+SYSTEM_PARAMETER_SET);
		return;
	}

	//=========================== 傍烹函券累诀 : 2008-01-21 ===========================



//其捞隆-----------------------------------------------------
		query1="select count(game_idx) as recCount from "+vGameTableName+" where game_new=2";

		stmt = con.createStatement();
		pageset = stmt.executeQuery(query1);

		if(pageset.next()){
			dbcount = pageset.getInt(1);  // 臂 醚 肮荐
			pageset.close();
		}

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

		if(request.getParameter("pageNUM")!=null)
		{
			pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁

			if(pageNUM > pagecount)
				pageNUM = pagecount;

			absolutepage=(pageNUM-1)*pagesize;
		}

		if(pageset != null)  pageset.close(); 
//其捞隆场-----------------------------------------------------
		query1 = "SELECT TOP " + pagesize + " game_Idx,game_title,game_text,qvga_img,game_type,game_diff FROM "+vGameTableName+" ";
		query1 = query1 + " WHERE game_Idx not in ";
		query1 = query1 + "(SELECT TOP " + absolutepage + " game_Idx FROM "+vGameTableName+" where game_new=2 ";
		query1 = query1 + " ORDER BY "+dateColName+" desc) and game_new=2 order by "+dateColName+" desc"; 
//out.println(query1);
		rs=stmt.executeQuery(query1);
		cnt = absolutepage;

		while(rs.next())
		{
			game_idx=rs.getInt("game_idx");
			game_title=rs.getString("game_title");
			game_text=rs.getString("game_text");
			game_img=rs.getString("qvga_img");
			game_type=rs.getString("game_type");
			game_diff = rs.getInt("game_diff");

			cnt++;
%>

	<tr> 
		<td height="6"></td>
	</tr>

	<tr>
		<td>
			<table border="0" cellpadding="0" cellspacing="0">
				<tr>
					<td width="8"></td>
					<td width="232"><b><font color="#ff6a5a"><%=cnt%>困</font><font color="#6a76f2"> : 
						<a href="<%=url_path+"/ranking/game_gamename.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx%>"><%=game_title%></a>
					</font></b></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr> 
		<td height="3"></td>
	</tr>

	<tr> 
		<td height="2" bgcolor="#c0d0d1"></td>
	</tr>

	<tr>
		<td>
			<table border="0" cellpadding="0" cellspacing="0">
				<tr height="48">
					<td width="2" bgcolor="#c0d0d1"></td>
					<td width="23"><img src="<%=img_path%>images/game/<%=game_img%>" width="23" height="48" border="0"></td>
					<td width="213" bgcolor="#ecf8fa">
						<table border="0" cellpadding="0" cellspacing="0">
							<tr height="32">
								<td width="7"></td>
								<td width="206" colspan="3"><font color="#616667"><%=game_text%></font></td>
							</tr>
							<tr height="16">
								<td width="7"></td>
								<td width="130" align="right"><font color="#6a76f2">抄捞档</font></td>
								<td width="5"></td>
								<td width="71">
<%
			starCnt = game_diff/2;
			halfStarFlag = game_diff%2;

			for(int i=1;i<=5;i++)
			{
				if(starCnt>=i)
				{
					%> <img src="<%=img_path%>images/game/bu_01.png" width="11" height="11" border="0" pictosrc="90"> <%
				}
				else
				{
					if((starCnt+1) == i && halfStarFlag == 1)
					{
						%> <img src="<%=img_path%>images/game/bu_02.png" width="11" height="11" border="0" pictosrc="91"> <%
					}
					else
					{
						%> <img src="<%=img_path%>images/game/bu_03.png" width="11" height="11" border="0" pictosrc="92"> <%
					}
				}
			}
%>
								</td>
							</tr>
						</table>
					</td>
					<td width="2" bgcolor="#c0d0d1"></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr> 
		<td height="2" bgcolor="#c0d0d1"></td>
	</tr>
<!--    -->
<%
		}

		if(rs != null)  rs.close(); 
		if(pstmt != null)  pstmt.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(pstmt != null) try{ pstmt.close(); }catch(Exception se){}
		if(stmt != null) try{ stmt.close(); }catch(Exception se){}
		if(con != null) try{ con.close(); }catch(Exception se){}
	}
%>
	<tr> 
		<td height="3"></td>
	</tr>

	<tr> 
		<td height="19" bgcolor="#e5ecff" align="center">
		<% 													
			String pageurl = url_path+"/ranking/game_hit_record.jsp?mphone="+mphone+"&gphone="+gphone+"&dateFlag="+dateFlag+"&manFlag="+manFlag;
			out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
		%>	
		</td>
	</tr>

	<tr> 
		<td height="7"></td>
	</tr>

	<tr>
		<td align="center">
			<table border="0" cellpadding="0" cellspacing="0">
				<tr height="17">
					<td width="78"></td>
					<td width="84" bgcolor="#a8bfff" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
					<td width="78"></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr> 
		<td height="11"></td>
	</tr>

</table>

<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0";//霸烙皋牢
%>

<table cellpadding="0" cellspacing="0" width="240" height="19">
	<tr>
		<td width="10" bgcolor="#BDC7CE">&nbsp;</td>
		<td width="220" bgcolor="#DEE7EF"><a href="<%=step1%>">权</a>&gt;<a href="<%=step2%>">霸烙皋牢</a>&gt;牢扁霸烙</td>
		<td width="10" bgcolor="#BDC7CE">&nbsp;</td>
	</tr>
</table>

<%@ include file="../newbottom.jsp"%>	 	 

</body>
</html>