ranking_mygameranking.jsp.svn-base

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

<%@ 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"%>
<%@ include file="../makeKOR.jsp"%>


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

<%	//4焙	己龋
	// 茄荤恩俊 措茄 傈眉霸烙珐欧捞促..  0607
	// 珐欧八祸_霸烙珐欧_qvga.bmp , my珐欧_霸烙珐欧_qvga.bmp
	response.setHeader("cache-control","no-cache");
	response.setHeader("expires","0");
	response.setHeader("pragma","no-cache");

	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	Statement stmt2 = null;
	ResultSet rs = null;
	ResultSet rs2 = null;
	ResultSet pageset = null; 
	
	String vmtype = request.getParameter("vmtype") == null ? "":request.getParameter("vmtype").substring(0,1);
	String vGameTableName = null;
	if(vmtype.equals("b")){ vGameTableName = "GT_game_brew";	}else{ vGameTableName = "GT_game_wipi"; }


	String mphone = request.getParameter("mphone");
	String gphone = request.getParameter("gphone");//抗寇利栏肺 vm俊辑 逞绢棵锭 mphone阑 持绢霖促. 捞 其捞瘤俊辑父 弊犯促.
	String subto = "";
	if(!isNull(request.getParameter("subto")).equals("") )//茫扁肺 甸绢柯 版快促.
	{
		subto = makeKOR(request.getParameter("subto"));
	}

	String query1=null, qry=null, sql=null, qry2 = null, str="";
	
	String phonenum=null, nickname=null; 
	
	String strDel=null, strShow=null;
	String boardname=null;
	int gamerank_idx=0, gamerank_score=0, myScore=0, myRank=0;
	String game_title=null;
	int game_idx=0; //霸烙 绊蜡锅龋
	
	
	// 其捞瘤 备泅 眠啊 函荐 
	int pagesize = 4;  // 茄其捞瘤寸 10俺 免仿拱
	// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
	int pageNUM=1;    // 其捞瘤 锅龋
	int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
	int absolutepage=1; //例措 困摹 其捞瘤 锅龋
    int dbcount=0 ;		// DB 救俊 臂 肮荐 历厘 函荐
	int isNoPage = 0;	//茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
	
	
	int rankCnt =1;	//珐欧鉴困 1,2,3困
	int isMember = 0;//雀盔, 厚雀盔 敲贰弊
	
	//朝楼 包访	
	Timestamp di_date=null;
	Date today = new Date();
	SimpleDateFormat timeform;
	timeform = new SimpleDateFormat("yy斥/mm岿/dd老");

	//di_date 		= 	rs.getTimestamp(3); //朝楼啊廉坷扁
	//<%=timeform.format(di_date);		//朝楼 谎府扁

	int gameTotalCnt = 0, gameCnt=0, gameTempIdx=0;		//gameCnt绰 0何磐 霸烙俺荐父怒 刘啊等促.
	int[] rankScore = null;//阿 霸烙喊 痢荐甫 
	int[] rankSunwi = null;//阿 霸烙喊 殿荐
	String[] gamename = null;//霸烙疙
	String columnName = "gamerank_score";//扁夯利栏肺 捞 拿烦疙阑 荤侩窃.
	String whereStr = "";
	String turmText = "";
	String mynickname = "";
	

	int searchRange = 3;// 坷疵:1, 捞锅林:2, 捞锅崔:3
	if(!isNull(request.getParameter("searchRange")).equals("") )//茫扁肺 甸绢柯 版快促.
	{
		searchRange = Integer.parseInt(makeKOR(request.getParameter("searchRange")));

	}
	else searchRange = 3;//扁夯篮 捞锅崔捞促
	
	if(searchRange==1)//坷疵
	{
		turmText = "坷疵";
		columnName = "gamerank_today";
		whereStr = " and DAY(gamerank_date) = DAY(GETDATE()) and MONTH(gamerank_date) = MONTH(GETDATE())";
	}
	else if(searchRange==2)//捞锅林
	{
		turmText = "林埃";
		whereStr = " and DAY(gamerank_date)/7 = DAY(GETDATE())/7 and MONTH(gamerank_date) = MONTH(GETDATE())";
	}
	else if(searchRange==3)//捞锅崔
	{	
		turmText = "岿埃";
		whereStr = " and MONTH(gamerank_date) = MONTH(GETDATE())";
	}



	String tphone="";
	int isMe = 1;
	if(mphone.equals(gphone))
	{
		isMe = 1;//唱促.
		tphone = mphone;
	}
	else
	{
		isMe = 0;//促弗荤恩捞促.
		tphone = gphone;
	}
	
	//葛喉肺弊肺 傅农吧扁
	String goMoblog  = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+gphone;

	String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧啪 栏肺
	String RangeLink1 = url_path+"/ranking/ranking_mygameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&searchRange=1";
	String RangeLink2 = url_path+"/ranking/ranking_mygameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&searchRange=2";
	String RangeLink3 = url_path+"/ranking/ranking_mygameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&searchRange=3";
%>


<%
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 ===========================



	// 其捞瘤 函荐蔼 荤侩窍扁 困秦辑 DB俊辑 眠免窍绰 何盒
	stmt = con.createStatement();
	stmt2 = con.createStatement();
	
	qry = "select nickname from GT_user_info where phonenum="+ tphone;

	pageset = stmt.executeQuery(qry);
	if(pageset.next())
	{
		mynickname = pageset.getString(1);
	}
	else 
		mynickname = "绝澜";

	
	qry2 = "select count(game_idx) from "+vGameTableName+" where game_new=2 ";
	pageset = stmt.executeQuery(qry2);
	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"));//瘤沥等 其捞瘤 焊咯林扁
		absolutepage=(pageNUM-1)*pagesize+1;
	}

	str = "select game_idx, game_title from "+vGameTableName+" where game_new=2 order by game_idx asc";

	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();
	}
%>

<html>
<head>
<title>Ranking</title>
<link href="mobile_qcif.css" rel="stylesheet" type="text/css" >
</head>

<body>
<!--<img  spritesrc="<%=spr_path%>ranking/ranking.spr">-->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
  <td width="8" height="19" background="<%=img_path%>images/202img/202_bar/red.png">&nbsp;</td>
  <td width="168" background="<%=img_path%>images/202img/202_bar/red.png"><font color="#FFFFFF">公霸鸥模备丛狼 珐欧 </font></td>
</tr>