📄 game_destory_friend.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"%>
<%
/***********************************************************************
@ Page Description
扁废阑 拜颇茄 模备甸
@ Parameter
***********************************************************************/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("mphone");
String game_idx = request.getParameter("game_idx");
String before_score = request.getParameter("before_score");
String mygamerank_score = request.getParameter("mygamerank_score");
String cnt = request.getParameter("cnt");
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String bgcolor = null;
String myphonenum = null;
String mynickname = null;
/*------------------------------------------------------------------------------------------------------
+ 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 = 10; // 茄其捞瘤寸 10俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=0; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
%>
<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">拜颇茄 模备甸 吝俊 酒贰 府胶飘狼 10疙鳖瘤 档惯厘捞 朝扼啊夸</font></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td height="17" bgcolor="#e5ecff"> <font color="#858ef2"><b>≮ LIST</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 ===========================
stmt = con.createStatement();
//其捞隆-----------------------------------------------------
query1 = "select count(a.guest_phone) FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 and "+before_score+" < b.gamerank_score and "+mygamerank_score+" > b.gamerank_score";
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;
}
if(pageset != null) pageset.close();
//其捞隆场-----------------------------------------------------
/*------------------------------------------------------------------------------------------------------
+ 拜颇茄 模备甸
-------------------------------------------------------------------------------------------------------*/
query1 = "select top "+pagesize+" a.guest_phone FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 and "+before_score+" < b.gamerank_score and "+mygamerank_score+" > b.gamerank_score and a.guest_phone not in (select top "+absolutepage+" a.guest_phone FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 and "+before_score+" < b.gamerank_score and "+mygamerank_score+" > b.gamerank_score order by b.gamerank_score desc) order by b.gamerank_score desc";
rs=stmt.executeQuery(query1);
//out.println(query1+"<br>");
stmt2 = con.createStatement();
String sex = "咯";
String textColor = "#ff00ff";
while(rs.next())
{
query2 ="select nickname, (Year(getdate())+1- year)nai,sex from GT_user_info where phonenum='"+rs.getString(1)+"'";
//out.println(query2);
rs2=stmt2.executeQuery(query2);
rs2.next();
if(rs2.getInt("sex") == 2)//巢磊
{
sex = "巢";
textColor = "#6a76f2";
}
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5"></td>
<td width="166" height="25" align="center"><font color="<%=textColor%>"><%=rs2.getString("nickname")%>(<%=sex%>) <%=rs2.getInt("nai")%>技</font></td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<!--痢急 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="1"></td>
<td background="<%=img_path%>images/game/dot_01.png" width="232" height="1"></td>
<td width="5" height="1"></td>
</tr>
</table>
</td>
</tr>
<!--痢急 场-->
<%
}
rs.close();
if(rs != null) rs.close();
if(rs2 != null) rs2.close();
if(pstmt != null) pstmt.close();
if(stmt != null) stmt.close();
if(stmt2 != null) stmt2.close();
if(con != null) con.close();
}
catch(Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{ rs.close(); }catch(Exception se){}
if(rs2 != null) try{ rs2.close(); }catch(Exception se){}
if(pstmt != null) try{ pstmt.close(); }catch(Exception se){}
if(stmt != null) try{ stmt.close(); }catch(Exception se){}
if(stmt2 != null) try{ stmt2.close(); }catch(Exception se){}
if(con != null) try{ con.close(); }catch(Exception se){}
}
%>
<tr height="19">
<td bgcolor="#e5ecff" align="center" >
<%
String pageurl = url_path+"/ranking/game_dobaljang.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&before_score="+before_score+"&mygamerank_score="+mygamerank_score;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td width="52"></td>
<td width="72" bgcolor="#9fb7f8" align="center"><a href="<%=url_path+"/ranking/game_dobaljang.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&before_score="+before_score+"&mygamerank_score="+mygamerank_score%>&cnt=<%=cnt%>"><font color="#ffffff">档惯厘啊扁</font></a></td>
<td width="52"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0";//霸烙皋牢
%>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#e5ecff">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr height="19">
<td><a href="<%=step1%>">权</a>><a href="<%=step2%>">霸烙皋牢</a>>拜颇茄 模备甸</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -