ranking_result.jsp

用手机浏览的一个类似于聊天室 博克 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="../common_func.jsp"%>
<%!
	public static String isNull(String str) 
	{ 
		if (str == null) 
		return ""; 
		else 
		return str;
	} 
%>


<%	
	

	/**************************************
			Common_Variable_SET
	***************************************/
	int sizeCvt=100;//荤捞令 牧滚泼矫 臂磊荐 啊廉坷绰 荐

	int       adver_idx = 0;
	String adver_img = null;
	String adver_link = null;

	int recordCount=0; //其捞隆 且 饭内靛 墨款飘
	int pagesize=4;		//其捞瘤 府胶飘 荐
	int pagecount=0;		//其捞瘤 荐
	int gotoPage=1;		//其捞瘤 逞滚
	//String pageurl = url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field="+table_field+"&rankType="+rankType+"&own_field="+own_field;

	

	/**************************************
		BASE_Variable_SET
	***************************************/
	String bgcolor=null;
	int own_field=1; //(磊脚1,惑困0)
	if(request.getParameter("own_field")!=null) own_field=Integer.parseInt(request.getParameter("own_field")); 

	String own_msg=null;
	String member_rank="NO";
	String member_join="NO";
	String myPhone=null;

	int Rank=0;

	if (own_field==1) pagesize=5;


	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;

	//String imageUrl=img_path+"images";
	
	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("mphone");//抗寇利栏肺 vm俊辑 逞绢棵锭 mphone阑 持绢霖促. 捞 其捞瘤俊辑父 弊犯促.

	String sql=null, query2=null, goUserHome = null;
	
	String phonenum=null, nickname=null; 
	
	String strDel=null, strShow=null;
	String boardname=null;
	String myNickname=null;
	int gamerank_idx=0, gamerank_score=0, myScore=0, myRank=0;
	String game_title=null;
	int game_idx=0; //霸烙 绊蜡锅龋
	// 其捞瘤 备泅 眠啊 函荐 


	// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
	int pageNUM=1;    // 其捞瘤 锅龋
	int absolutepage=1; //例措 困摹 其捞瘤 锅龋
    int dbcount=0 ;		// DB 救俊 臂 肮荐 历厘 函荐
	int isNoPage = 0;	//茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
	int rankCnt =1;	//珐欧鉴困 1,2,3困
	int isMember = 0;//雀盔, 厚雀盔 敲贰弊
	
	
	//0724
	if(!isNull(request.getParameter("game_idx")).equals("") )//茫扁肺 甸绢柯 版快促.
	{
		game_idx = Integer.parseInt(request.getParameter("game_idx"));

	}
	else game_idx = 0;
	
	boardname = "GT_gamerank_"+game_idx;	//柳楼
	
	//朝楼 包访	
	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);		//朝楼 谎府扁

	String qcif_img=null;
	String[] gameNameList = null;
	int[]	 gameIdx=null;	
	int		 gameNameCnt = 0;
	int		 gameArrIndex = 0;
	
	String topPhone=null;
	String topIntro=null;
	String topNickname=null;
	int topScore = 0;
	String queryTop=null;
	int topHave = 0; //1困啊 粮犁 窍搁..

	String whereStr = "";
	String columnName = "gamerank_score";//扁夯利栏肺 捞 拿烦疙阑 荤侩窃.
	String turmText = "";


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

	}
	else searchRange = 1;//扁夯篮 捞锅崔捞促.


	String pageurl = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field="+own_field;

	if(searchRange == 1)//坷疵
	{
		turmText = "坷疵";
		columnName = "gamerank_today";
		whereStr = " and datediff(day,gamerank_date,getdate())=0";
	}
	else if(searchRange == 2)//捞锅林
	{
		turmText = "林埃";//陛林
		columnName = "gamerank_score";
		whereStr = " and datediff(week,gamerank_date,getdate())=0";
	}
	else if(searchRange == 3)//捞锅崔
	{
		columnName = "gamerank_score";
		turmText = "穿利";
		whereStr = " ";
	}
	
	String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧啪 栏肺
	String RangeLink1 = "";
	String RangeLink2 = "";
	String RangeLink3 = "";

	//鸥款珐欧 皋春 傅农=====
	String goGameLink	=url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone;//霸烙珐欧 
	String goMyLink		=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&subto=1";//myranking
	String goCafeLink	=url_path+"/ranking/ranking_cafe.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//墨其
	String goKnowLink	=url_path+"/ranking/ranking_knowrank.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//瘤侥
	String goGongLink	=url_path+"/ranking/ranking_gong.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//傍埃
	//==
	
%>

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




	stmt = con.createStatement(); 

	/**************************************
		雀盔_厚雀盔 眉农
	***************************************/
	sql = "SELECT phonenum FROM GT_user_info where phonenum2 ="+Long.parseLong(mphone);
	rs = stmt.executeQuery(sql);
	if(rs.next()) member_join="YES";
	
	if(game_idx==0)//0724
	{
		pstmt = con.prepareStatement("select Top 1 game_idx from "+vGameTableName+" where game_new=2 order by game_hit desc ");
		rs = pstmt.executeQuery();
		if(rs.next())
			game_idx = rs.getInt(1);
		boardname = "GT_gamerank_"+game_idx;
	}
	

	//out.println(member_join);
	//if (true) return;

	if (own_field==1)
	{
				own_msg="磊脚狼 痢荐";
				//郴 殿荐 啊廉坷扁
				queryTop = "select a.phonenum,a.nickname, "+columnName+",myRank=(select count(*)+1 from "+boardname+" where (a."+columnName+"<"+columnName+" or (a."+columnName+"="+columnName+" and a.phonenum<phonenum )) "+whereStr+") from "+boardname+" a WHERE a.phonenum='"+mphone+"' "+whereStr;



				pstmt = con.prepareStatement(queryTop);
				rs = pstmt.executeQuery();
				if(rs.next())
				{
				member_rank="YES";
		
				myPhone = rs.getString("phonenum");
				myNickname = rs.getString("nickname");
				myScore = rs.getInt(3);
				myRank=rs.getInt("myRank");
				}
				rs.close();
				
				//out.println(myRank);
				//if ( true ) return;

				
	}
	else
	{
				own_msg="痢荐 惑困";
				member_rank="NO";

				//1困牢 荤恩狼 迄锅龋客 intro 啊廉柯促 啊廉柯促. 0607
				queryTop = "select Top 1 "+boardname+".phonenum, intro, GT_user_info.nickname, "+columnName+" from "+boardname+" inner join GT_user_info on "+boardname+".phonenum=GT_user_info.phonenum "+whereStr+" order by "+columnName+" desc, gamerank_date desc";

				pstmt = con.prepareStatement(queryTop);
				rs = pstmt.executeQuery();
				if(rs.next())
				{
					topHave = 1;//1困啊 粮犁茄促.
					topPhone = rs.getString(1);
					topIntro = rs.getString(2);
					topNickname = rs.getString(3);
					topScore = rs.getInt(4);
				}
				else
				{
					topHave = 0;//1困啊 粮犁茄促.
				}
				rs.close();
	}
				//out.println(queryTop);

	if(request.getParameter("pageNUM")!=null) gotoPage=Integer.parseInt(request.getParameter("pageNUM"));
	else//其捞瘤 绝捞 立加(弥檬 立加捞促)
	{
		if (own_field==1 && member_rank.equals("YES"))
		{
			if(myRank%pagesize == 0)
				gotoPage=myRank/pagesize;//瘤沥等 其捞瘤 焊咯林扁
			else
				gotoPage=myRank/pagesize+1;//瘤沥等 其捞瘤 焊咯林扁
		}
	}	

	

	//霸烙 力格 啊廉坷扁
	sql = "select game_title,qcif_img from "+vGameTableName+" where game_idx="+game_idx;
	rs = stmt.executeQuery(sql);
	if(rs.next())
	{	
		game_title = rs.getString(1);
		qcif_img = rs.getString("qcif_img");
	}

	sql = "select count(game_idx) from "+vGameTableName+" where game_new=2";
	pstmt = con.prepareStatement(sql);
	rs = pstmt.executeQuery();
	if(rs.next())
	{
		gameNameCnt = rs.getInt(1);
		gameIdx = new int[gameNameCnt];
		gameNameList = new String[gameNameCnt];
	}
	if(pstmt != null) pstmt.close();
	if(rs != null) rs.close();

	sql = "select  game_idx, game_title from "+vGameTableName+" where game_new=2 order by game_hit desc";
	pstmt = con.prepareStatement(sql);
	rs = pstmt.executeQuery();