📄 game_ranking.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@霸烙珐欧
*@Author : 辑厘盔(2007-12-22)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
1) bg_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"%>
<%@ include file="../common_func.jsp"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
/*------------------------------------------------------------------------------------------------------
+ 珐欧 饭骇 备窍绰 窃荐
-------------------------------------------------------------------------------------------------------*/
public static String rankGrade(int rnaking)
{
String grade = null;
if(rnaking == 1) grade = "[TOP]";
else if(2 <= rnaking && rnaking <= 10) grade = "[SSS]";
else if(11 <= rnaking && rnaking <= 50) grade = "[SS]";
else if(51 <= rnaking && rnaking <= 100) grade = "[S]";
else if(101 <= rnaking && rnaking <= 200) grade = "[AAA]";
else if(201 <= rnaking && rnaking <= 500) grade = "[AA]";
else if(501 <= rnaking && rnaking <= 1000) grade = "[A]";
else if(1001 <= rnaking && rnaking <= 3000) grade = "[BBB]";
else if(3001 <= rnaking && rnaking <= 8000) grade = "[BB]";
else if(8001 <= rnaking && rnaking <= 15000) grade = "[B]";
else if(8001 <= rnaking && rnaking <= 15000) grade = "[CCC]";
else if(15001 <= rnaking && rnaking <= 30000) grade = "[CC]";
else if(30001 <= rnaking && rnaking <= 60000) grade = "[C]";
else if(60001 <= rnaking && rnaking <= 100000) grade = "[檬焊A]";
else if(100001 <= rnaking && rnaking <= 600000) grade = "[[檬焊B]";
else if(600001 <= rnaking) grade = "[檬焊C]";
return grade;
}
%>
<%
/***********************************************************************
@ Page Description
郴霸烙_珐欧
@ Parameter
***********************************************************************/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
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");
int manFlag = 1;//俺牢 1, 目敲 2
if(!isNull(request.getParameter("manFlag")).equals("")){ manFlag= Integer.parseInt(request.getParameter("manFlag")); }
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
int game_idx = 0;
String game_title = null;
int score = 0;
int rnaking = 0;
String grade = null;
int [] play_game = new int[10];
int [] play_temp = new int[10];
int loop = 0;
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
Statement stmt2 = null;
ResultSet rs2 = null;
ResultSet pageset = null;// 其捞瘤 备泅 眠啊 函荐 ---------
String query1 = null;
String query2 = null;
/*------------------------------------------------------------------------------------------------------
+ 其捞瘤 备泅 眠啊 函荐
-------------------------------------------------------------------------------------------------------*/
int pagesize = 5; // 茄其捞瘤寸 10俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=0; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
%>
<html>
<head>
<title>郴霸烙_珐欧</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3" bgcolor="#A8BFFF"></td>
</tr>
<tr>
<td height="13" bgcolor="#6A76F2"> <font color="#ffffff">霸烙珐欧</font></td>
</tr>
<tr>
<td height="3" bgcolor="#A8BFFF"></td>
</tr>
<tr>
<td height="1" bgcolor="#6A76F2"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td align="center"><font color="#666666">
<%
if(manFlag == 1)
{
%>
弥辟俊 角青 茄 10俺狼 霸烙捞 磊悼栏肺 扁废俊 馆康登夸 霸烙 殿鞭苞 珐欧阑 犬牢秦焊技夸 霸烙殿鞭篮 开措珐欧 扁霖栏肺 焊咯廉夸
<%
}
else
{
%>
霸烙 殿鞭苞 珐欧阑 犬牢秦焊技夸 目敲 霸烙殿鞭篮 坷疵 珐欧 扁霖栏肺 焊咯廉夸
<%
}
%>
</font></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td height="17" bgcolor="#e5ecff" align="center"><font color="#858ef2">
<%
if(manFlag == 1)
{
%>
<b>老 馆</b> | <a href="<%=url_path+"/ranking/game_ranking.jsp?mphone="+mphone+"&gphone="+gphone+"&manFlag=2"%>">目 敲</a>
<%
}
else
{
%>
<a href="<%=url_path+"/ranking/game_ranking.jsp?mphone="+mphone+"&gphone="+gphone+"&manFlag=1"%>">老 馆</a> | <b>目 敲</b>
<%
}
%>
</font></td>
</tr>
<%
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 ===========================
if(vmtype.equals("b"))
{
response.sendRedirect(url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone);
}
stmt = con.createStatement();
if(manFlag == 1)
{
query1 = "select play_idx, play_first, play_second, play_third,play_4,play_5,play_6,play_7,play_8,play_9,play_10 from GT_gameplay_info where phonenum='"+mphone+"'";
}
else
{
query1 = "SELECT gamecouple_idx,game_idx,game_title,(gamescore_man+gamescore_woman)score FROM GT_gamecouple ";
query1 = query1 + " WHERE phonenum_man="+"'"+mphone+"' or phonenum_woman="+"'"+mphone+"'";
}
//out.println(query1);
rs=stmt.executeQuery(query1);
stmt2 = con.createStatement();
/*------------------------------------------------------------------------------------------------------
+ 郴啊茄 霸烙 府胶飘 免仿
-------------------------------------------------------------------------------------------------------*/
if(manFlag == 1 && rs.next())
{
play_game[0]=rs.getInt("play_first");
play_game[1]=rs.getInt("play_second");
play_game[2]=rs.getInt("play_third");
play_game[3]=rs.getInt("play_4");
play_game[4]=rs.getInt("play_5");
play_game[5]=rs.getInt("play_6");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -