game_start.jsp

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

<!--------------------------------------------------------------------------------------------------------------
*@霸烙肺爹拳搁
*@Author : 冠惑辣(2007-12-23)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
	1) game_title_05.png : 戳措弊匙鸥扁 鸥捞撇 捞固瘤
	2) ico_01.png : 傈眉捞侩啊 殿鞭 酒捞能 捞固瘤
--------------------------------------------------------------------------------------------------------------->

<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>

<%! 	 
	public static String isNull(String str) 
	{ 
		if (str == null) 
			return ""; 
		else 
			return str; 
	} 
%>

<%	
	response.setHeader("cache-control","no-cache");
	response.setHeader("expires","0");
	response.setHeader("pragma","no-cache");

	/***********************************************************************
	
	@ Page Description
	 	己龋
		泅犁 弥绊 痢荐客 努肺滚 俺荐甫 啊廉坷绊, 霸烙 洒飘荐甫 棵赴促.
	@ Parameter

	***********************************************************************/

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
		
	String mphone = request.getParameter("mphone");
	String gphone = mphone;
	// VM Type阑 啊廉柯促 - Applet阑 角青且 版肺啊 VM Type俊 蝶扼 搬沥等促.
	String vmtype = request.getParameter("vmtype");
	String game_idx = request.getParameter("game_idx");

	String gamePlayType = null;
	int ngamePlayType=0;

	if(request.getParameter("gamePlayType")!=null) gamePlayType=request.getParameter("gamePlayType"); else gamePlayType="0";
	ngamePlayType = Integer.parseInt(gamePlayType);

	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	int myScore=0, myClover=0;
	String query1=null;

	//int play_first=0, play_second=0, play_third=0;
	int [] play_game = new int[10];
	int isGuest = 0;//雀盔啊涝 救窍绊 霸烙窍绰 蜡历.

	String gameTitle="";
	String game_explain = "";
	String game_limit_image = "";
	String game_loading_image = "";

	String nickname = null;
	String couplenickname = null;
	String phonenum_man = null;
	int score = 0;
	int friendGrade = 0;
	String friendphone = null;
	String mynickname = null;
	String mycouplenickname = null;
	int myscore = 0;
	String mygrade = null;

	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;

try
{

 /*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%

	con.setAutoCommit(false);
	stmt=con.createStatement();

	query1 = " INSERT INTO GT_log_game_connection(phonenum,game_idx,platform) ";
	query1 = query1 + " VALUES("+Long.parseLong(mphone)+","+game_idx+",'QCIF')";
	stmt.executeUpdate(query1);
	
	/**************************************
		1.坷疵狼霸烙 HIT 荐 棵府扁 20071026 眠啊
	***************************************/
	query1="select game_idx from GT_today_game where game_idx="+game_idx+" and datediff(day,regdate,getdate())=0";
	if(rs != null)  rs.close(); 
	rs=stmt.executeQuery(query1);
	if(!rs.next())
	{
		query1="Insert into GT_today_game(game_idx) values("+game_idx+")";
		stmt.executeUpdate(query1);
		
	}
	else
	{
		query1="update GT_today_game SET game_hit=game_hit+1 where game_idx="+game_idx;
		stmt.executeUpdate(query1);
	}
	rs.close();

	/**************************************
		雀盔, 厚雀盔 
	***************************************/
	int sex = 0;
	if(rs != null)  rs.close(); 
	rs = stmt.executeQuery("select phonenum,sex,nickname from GT_user_info where phonenum='"+mphone+"'");
	if(!rs.next())
	{
		isGuest = 1;
		response.sendRedirect(url_path+"/user_info/regist_notice.jsp?mphone="+mphone+"&gphone="+gphone);
		return;
	}
	sex = rs.getInt("sex");
	mynickname = rs.getString("nickname");
	rs.close();

	/**************************************
		霸烙 洒飘荐 棵府扁
	***************************************/
	if(sex == 1)//咯磊
		query1 = "update GT_game set game_hit=game_hit+1,woman_day_cnt=woman_day_cnt+1,woman_week_cnt=woman_week_cnt+1 where game_Idx="+game_idx;
	else//巢磊
		query1 = "update GT_game set game_hit=game_hit+1,man_day_cnt=man_day_cnt+1,man_week_cnt=man_week_cnt+1 where game_Idx="+game_idx;
		
	stmt.executeUpdate(query1);

	/**************************************
		郴 痢荐 啊廉坷扁
	***************************************/
	query1 = " select gamerank_score from GT_gamerank_"+game_idx+" where phonenum='"+mphone+"'";
	if(rs != null)  rs.close(); 
	rs=stmt.executeQuery(query1);
	if(rs.next())
		myScore = rs.getInt(1);	

	rs.close();
	/**************************************
		郴 努肺滚 啊廉坷扁
	***************************************/
/*
	query1 = "select top 1 moneybook_total_clover from GT_moneybook where phonenum='"+mphone+"' order by moneybook_idx desc";	
	rs=stmt.executeQuery(query1);	
	if(rs.next())
		myClover = rs.getInt(1);

	rs.close();
*/

	//霸烙 沥焊 (肺爹拳搁俊 鞘夸茄)
	query1 = "SELECT  game_idx, game_title, game_text, game_img_path, game_tip1, game_limit_image, game_loading_image FROM GT_game ";
	query1 = query1 + " WHERE game_idx=?";
	if(rs != null)  rs.close(); 
	if(pstmt != null)  pstmt.close(); 
	pstmt = con.prepareStatement(query1);
	pstmt.setInt(1,Integer.parseInt(game_idx));
	rs = pstmt.executeQuery();
	if(rs.next())
	{
		gameTitle = rs.getString(2);		//霸烙力格
		game_explain = rs.getString("game_tip1");		//霸烙 眠啊 汲疙(肺爹吝老锭 唱坷绰 咆胶飘)
		game_limit_image = rs.getString(6);	//康殿困 捞固瘤
		game_loading_image = rs.getString(7);	//肺爹 捞固瘤
	}
	rs.close();

	/**************************************
		殿荐 备窍扁
	***************************************/
	int flag = 0;
	switch(ngamePlayType)
	{
		/*------------------------------------------------------------------------------------------------------
		+	老馆霸烙
		-------------------------------------------------------------------------------------------------------*/
		case 0:
			query1 = "select top 1 phonenum,nickname,gamerank_today from GT_gamerank_"+game_idx+" where DATEDIFF (day,gamerank_date, getdate()) = 0 order by gamerank_today desc, gamerank_date desc";
			if(rs != null)  rs.close(); 
			rs=stmt.executeQuery(query1);
//out.println(query1);
			if(rs.next())
			{
				nickname = rs.getString(2);
				score = rs.getInt(3);
			}
			else
			{
				nickname = "绝澜";
				score = 0;
			}
			rs.close();

			query1 = "select gamerank_today,nickname from GT_gamerank_"+game_idx+" where phonenum = '"+mphone+"' and DATEDIFF (day,gamerank_date, getdate()) = 0 ";
			if(rs != null)  rs.close(); 
			rs=stmt.executeQuery(query1);
			if(rs.next())
			{
				mynickname = rs.getString(2);
				myscore = rs.getInt(1);
				flag = 1;
			}
			else
			{
				//mynickname = "绝澜";
				myscore = 0;
				mygrade = "鉴困绝澜";
			}
			rs.close();

			if(flag == 1)
			{
				query1 = "select count(*)+1 from GT_gamerank_"+game_idx+" where DATEDIFF (day,gamerank_date, getdate()) = 0 and ("+myscore+" < gamerank_today or ("+myscore+" = gamerank_today and '"+mphone+"' < phonenum ))";
				if(rs != null)  rs.close(); 
				rs=stmt.executeQuery(query1);

				if(rs.next())
					mygrade =rs.getInt(1)+"困";
			}
			rs.close();
			break;
		/*------------------------------------------------------------------------------------------------------
		+	目敲霸烙
		-------------------------------------------------------------------------------------------------------*/
		case 1:
			query1 = "select top 1 nickname_man, nickname_woman,(gamescore_man+gamescore_woman)score, phonenum_man  from GT_gamecouple where game_idx = "+game_idx+" order by score desc, phonenum_man desc";
			//out.println(query1);
			if(rs != null)  rs.close(); 
			rs=stmt.executeQuery(query1);

			if(rs.next())
			{
				nickname = rs.getString(1);
				couplenickname = rs.getString(2);
				score = rs.getInt(3);
				phonenum_man = rs.getString(4);
			}
			else
			{
				nickname = "绝澜";
				couplenickname = "绝澜";
				score = 0;
			}
			rs.close();
			int gamecouple_idx = 0;
			query1 = "select nickname_man, nickname_woman,(gamescore_man+gamescore_woman)score,gamecouple_idx  from GT_gamecouple where game_idx = "+game_idx+" and (phonenum_man = '"+mphone+"' or phonenum_woman = '"+mphone+"')";
			if(rs != null)  rs.close(); 
			rs=stmt.executeQuery(query1);
			//out.println(query1);
			if(rs.next())
			{
				mynickname = rs.getString(1);
				mycouplenickname = rs.getString(2);
				myscore = rs.getInt(3);
				gamecouple_idx = rs.getInt(4);
				flag = 1;
			}
			else
			{