📄 game_result.jsp.svn-base
字号:
<%@ 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"%>
<%@ 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 game_idx=Integer.parseInt(request.getParameter("game_idx"));
int dateFlag = 1;//坷疵 1, 林埃 2, 穿利 3
if(!isNull(request.getParameter("dateFlag")).equals("")){ dateFlag= Integer.parseInt(request.getParameter("dateFlag")); }
int myFlag = 1;//惑困 2, 磊脚 1,
if(!isNull(request.getParameter("myFlag")).equals("")){ myFlag= Integer.parseInt(request.getParameter("myFlag")); }
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
int count = 0 ; //其捞瘤 墨款磐 函荐
String game_title = null;
String myFlag_text = null;
String dateFlag_text = null;
String columnName = null;
String phonenum = null;
String nickname = null;
int gamerank_score = 0;
int mygrade_cnt = 0;
String myphonenum = null;
String mynickname = null;
int mygamerank_score = 0;
int myplay_flag = 1;
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
Statement stmt2 = null;
ResultSet rs = null;
ResultSet rs2 = null;
ResultSet pageset = null;// 其捞瘤 备泅 眠啊 函荐 ---------
String query1 = null;
/*------------------------------------------------------------------------------------------------------
+ 其捞瘤 备泅 眠啊 函荐
-------------------------------------------------------------------------------------------------------*/
int pagesize = 5; // 茄其捞瘤寸 10俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=0; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
/*------------------------------------------------------------------------------------------------------
+ dateFlag_text
-------------------------------------------------------------------------------------------------------*/
if(dateFlag == 1)
{
dateFlag_text = "坷疵";
columnName = "gamerank_today";
}
else if(dateFlag == 2)
{
dateFlag_text = "林埃";
columnName = "gamerank_score";
}
else
{
dateFlag_text = "开措";
columnName = "gamerank_score";
}
/*------------------------------------------------------------------------------------------------------
+ myFlag_text
-------------------------------------------------------------------------------------------------------*/
if(myFlag == 1)
{
myFlag_text = "磊脚狼 痢荐";
}
else
{
myFlag_text = "惑困狼 痢荐";
}
/*------------------------------------------------------------------------------------------------------
+ 八祸绢 汲沥
-------------------------------------------------------------------------------------------------------*/
String szSearchWord = request.getParameter("word");
String szSearchWordParam = null;
String szSearchSQL1 = null;
String szSearchSQL2 = null;
String szSearchSQL3 = null;
if("".equals(szSearchWord) || "null".equals(szSearchWord) || szSearchWord == null)
{
szSearchWord = "";
szSearchSQL1 = "";
szSearchSQL2 = "";
szSearchSQL3 = "";
szSearchWordParam = "";
}
else
{
szSearchWord = makeKOR(szSearchWord);
szSearchWord = szSearchWord.replaceAll("'", "''");
szSearchSQL1 = " AND nickname like '%"+ szSearchWord+"%' ";
szSearchSQL2 = " AND nickname like '%"+ szSearchWord+"%' ";
szSearchSQL3 = " WHERE nickname like '%"+ szSearchWord+"%' ";
szSearchWordParam = "&word=" + java.net.URLEncoder.encode(szSearchWord);
}
/*------------------------------------------------------------------------------------------------------
+
-------------------------------------------------------------------------------------------------------*/
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();
/*------------------------------------------------------------------------------------------------------
+ 霸烙 力格 啊廉坷扁
-------------------------------------------------------------------------------------------------------*/
query1 = "select game_title from GT_game where game_idx="+game_idx;
rs = stmt.executeQuery(query1);
if(rs.next())
game_title = rs.getString(1);
rs.close();
/*------------------------------------------------------------------------------------------------------
+ 磊脚狼 痢荐客 珐欧
-------------------------------------------------------------------------------------------------------*/
if(myFlag == 1 && request.getParameter("pageNUM")==null)//磊脚狼 珐欧捞绊 弥檬立加矫俊父 拌魂
{
query1 = "select "+columnName+",nickname,phonenum from GT_gamerank_"+game_idx+" where phonenum = '"+mphone+"'";
if(dateFlag == 1)
query1 = query1 + " and datediff(day,gamerank_date,getdate())=0 ";
else if(dateFlag == 2)
query1 = query1 + " and datediff(week,gamerank_date,getdate())=0 ";
else
query1 = query1 + " ";
//out.println(query1+"<br>");
rs=stmt.executeQuery(query1);
if(rs.next())
{
myphonenum = rs.getString(3);
mynickname = rs.getString(2);
mygamerank_score = rs.getInt(1);
}
else
{
myplay_flag = 0;
}
rs.close();
if(myplay_flag == 1)
{
query1 = "select count(*)+1 from GT_gamerank_"+game_idx+" where (" +mygamerank_score+" < "+columnName+" or ("+mygamerank_score+" = "+columnName+" and '"+mphone+"' < phonenum ))";
if(dateFlag == 1)
query1 = query1 + " and datediff(day,gamerank_date,getdate())=0 ";
else if(dateFlag == 2)
query1 = query1 + " and datediff(week,gamerank_date,getdate())=0 ";
else
query1 = query1 + " ";
rs=stmt.executeQuery(query1);
//out.println(query1+"<br>");
if(rs.next())
mygrade_cnt = rs.getInt(1);
rs.close();
}
}
//其捞隆-----------------------------------------------------
if(myplay_flag == 1)
{
query1 = " SELECT count(phonenum) as recCount from GT_gamerank_"+game_idx;
if(dateFlag == 1)
query1 = query1 + " where datediff(day,gamerank_date,getdate())=0 "+szSearchSQL2;
else if(dateFlag == 2)
query1 = query1 + " where datediff(week,gamerank_date,getdate())=0 "+szSearchSQL2;
else if(dateFlag == 3)
query1 = query1 + szSearchSQL3;
else
query1 = query1 + " ";
pageset = stmt.executeQuery(query1);
//out.println(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;
}
else if(myFlag == 1)
{
if(mygrade_cnt%pagesize == 0)
pageNUM=mygrade_cnt/pagesize;//瘤沥等 其捞瘤 焊咯林扁
else
pageNUM=mygrade_cnt/pagesize+1;//瘤沥等 其捞瘤 焊咯林扁
if(pageNUM > pagecount)//乐绰 其捞瘤 焊促 奴 蔼捞 甸绢吭阑 锭 贸府
pageNUM = pagecount;
absolutepage=(pageNUM-1)*pagesize;
}
//out.println(absolutepage);
//out.println(mygrade_cnt);
if(pageset != null) pageset.close();
}
//其捞隆场-----------------------------------------------------
%>
<html>
<head>
<title>霸烙_搬苞</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF">
<table width="176" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20" background="<%=img_path%>images/game/bg_pink.png">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3" bgcolor="#FFAEC5"></td>
</tr>
<tr>
<td height="13" bgcolor="#FF4759"> <font color="#ffffff">霸烙搬苞</font></td>
</tr>
<tr>
<td height="3" bgcolor="#FFAEC5"></td>
</tr>
<tr>
<td height="1" bgcolor="#FF4759"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="30" align="center" valign="bottom">
<%
String datePath = url_path+"/ranking/game_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&myFlag="+myFlag+"&dateFlag=";
%>
<!--￠坷疵/林埃/开措 -->
<table width="163" cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="7" height="1" bgcolor="#FF788F"></td>
</tr>
<tr>
<td width="1" bgcolor="#FF788F"></td>
<% if(dateFlag != 1){%>
<td width="53" height="18" align="center" bgcolor="#FFE0E4"><font color="#F60000"><a href="<%=datePath%>1">坷疵</a></font></td>
<% }else{ %>
<td width="53" height="18" align="center"><font color="#FF788F"><b>坷疵</b></font></td>
<% } %>
<td width="1" bgcolor="#FF788F"></td>
<% if(dateFlag != 2){%>
<td width="53" align="center" bgcolor="#FFE0E4"><font color="#F60000"><a href="<%=datePath%>2">林埃</a></font></td>
<% }else{ %>
<td width="53" align="center"><font color="#FF788F"><b>林埃</b></font></td>
<% } %>
<td width="1" bgcolor="#FF788F"></td>
<% if(dateFlag != 3){%>
<td width="53" align="center" bgcolor="#FFE0E4"><font color="#F60000"><a href="<%=datePath%>3">开措</a></font></td>
<% }else{ %>
<td width="53" align="center"><font color="#FF788F"><b>开措</b></font></td>
<% } %>
<td width="1" bgcolor="#FF788F"></td>
</tr>
</table>
<!--¤坷疵/林埃/开措 -->
</td>
</tr>
<tr>
<td height="1" bgcolor="#FF788F"></td>
</tr>
<tr>
<% if(myFlag == 1){ %>
<td height="25" align="center"><font color="#FF788F"><a href="<%=url_path+"/ranking/game_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&myFlag=2&dateFlag="+dateFlag%>">惑困</a></font> <font color="#FF788F">|</font> <font color="#F60000"><b>磊脚</b></font></td>
<% } else { %>
<td height="25" align="center"><font color="#FF788F"><b>惑困</b></font> <font color="#FF788F">|</font> <font color="#F60000"><a href="<%=url_path+"/ranking/game_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&myFlag=1&dateFlag="+dateFlag%>">磊脚</a></font></td>
<% } %>
</tr>
<tr>
<td height="50" align="center" bgcolor="#FF9DAC"><font color="#FFFFFF">* <%=dateFlag_text%> <<%=game_title%>> *
<br><%=myFlag_text%> 珐欧涝聪促.</font></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="20" bgcolor="#FEE0E4" align="center">
<!--￠捞傈/促澜 -->
<%
String pageurl = url_path+"/ranking/game_result.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&myFlag="+myFlag+"&dateFlag="+dateFlag+szSearchWordParam;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
<!--¤捞傈/促澜 -->
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<tr>
<td>
<table width="176" cellpadding="0" cellspacing="0" border="0">
<%
if(myplay_flag == 1)
{
query1 = "select top "+pagesize+" gamerank_idx,phonenum,nickname,"+columnName+",(SELECT text FROM GT_GameUserMent WHERE gameIdx="+game_idx+" AND phonenum = CAST(a.phonenum as bigint) ) as 'Ment' from GT_gamerank_"+game_idx+" a where gamerank_idx not in(select top "+absolutepage+" gamerank_idx from GT_gamerank_"+game_idx;
if(dateFlag == 1)
query1 = query1 + " where datediff(day,gamerank_date,getdate())=0"+szSearchSQL2;
else if(dateFlag == 2)
query1 = query1 + " where datediff(week,gamerank_date,getdate())=0"+szSearchSQL2;
else
query1 = query1 + " "+szSearchSQL3;
query1 = query1 + " order by "+columnName+" desc,phonenum desc) ";
if(dateFlag == 1)
query1 = query1 + " and datediff(day,gamerank_date,getdate())=0 "+szSearchSQL2;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -