📄 play_gamename.jsp
字号:
<%@ 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"%>
<%
/**************************************
BASE_Variable_SET
***************************************/
String search_field = null;
String orderby_field = null;
if(request.getParameter("search_field")!=null) search_field=convKOR(request.getParameter("search_field"));
else search_field="";
if(request.getParameter("orderby_field")!=null) orderby_field=request.getParameter("orderby_field");
else orderby_field="game_hit";
int game_idx=0;
if(request.getParameter("game_idx")!=null) game_idx=Integer.parseInt(request.getParameter("game_idx"));
String news_title=null;
String game_title=null;
String game_text=null;
String game_img_path=null;
String game_path=null;
String game_type=null;
int total_count=0;
int rank=0;
/**************************************
DB_Variable_SET
***************************************/
Connection con = null;
PreparedStatement pstmt=null;
CallableStatement cstmt=null; //橇肺矫历 龋免阑 困茄
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
String sql="";
/**************************************
Common_Variable_SET
***************************************/
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");
int adver_idx = 0;
String adver_img = null;
String adver_link = null;
int recordCount=0; //其捞隆 且 饭内靛 墨款飘
int pagesize=5; //其捞瘤 府胶飘 荐
int pagecount=0; //其捞瘤 荐
int gotoPage=1; //其捞瘤 逞滚
String pageurl = url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&orderby_field="+orderby_field;
if(request.getParameter("pageNUM")!=null) gotoPage=Integer.parseInt(request.getParameter("pageNUM"));
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();
/**************************************
1.霸烙沥焊
***************************************/
sql = " SELECT game_title,game_text,game_img_path,game_path,game_type";
sql = sql +" ,total_count=";
sql = sql + " (SELECT COUNT(game_idx) FROM "+vGameTableName+" ";
sql = sql + " WHERE game_new=2)";
sql = sql + " ,rank=";
sql = sql + " (SELECT COUNT(game_idx)+1 FROM "+vGameTableName+" ";
sql = sql + " WHERE game_new=2 ";
sql = sql + " AND a.game_hit<game_hit OR (a.game_hit=game_hit AND a.game_date<game_date))";
sql = sql + " FROM "+vGameTableName+" a ";
sql = sql + " WHERE game_idx="+game_idx;
rs=stmt.executeQuery(sql);
if(rs.next())
{
game_title=rs.getString("game_title");
game_text=rs.getString("game_text");
game_img_path=rs.getString("game_img_path");
game_type=rs.getString("game_type");
game_path=rs.getString("game_path");
total_count=rs.getInt("total_count");
rank=rs.getInt("rank");
}
rs.close();
//out.println(url_path+"/ranking/start_game.jsp?game_idx="+game_idx+"&mphone="+mphone+"&gphone="+gphone);
%>
<html>
<head>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--剧侥
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
-->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!--鸥捞撇 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8" height="20" background="<%=img_path%>images/game/bg_01.png"></td>
<td width="100%" height="20" align="middle" background="<%=img_path%>images/game/bg_01.png"><font color="#ffffff">霸烙</font></td>
</tr>
</table>
</td>
</tr>
<!--鸥捞撇 矫累-->
<!--咯归 矫累-->
<tr>
<td height="10"></td>
</tr>
<!--咯归 场-->
<!--堡绊巩备 矫累-->
<tr>
<td align="center">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7"></td>
<td width="17"><img src="<%=img_path%>images/game/etc_01.png"> </td>
<td width="28" height="13" valign="middle"><img src="<%=img_path%>images/game/<%=game_type%>.png"></td>
<td align="center"><font color="#9819E9"><%=game_title%></font></td>
<td align="left" width="17"><img src="<%=img_path%>images/game/etc_02.png"></td>
<td width="8"></td>
</tr>
</table>
</td>
</tr>
<!--堡绊巩备 场-->
<!--咯归 矫累-->
<tr>
<td height="8"></td>
</tr>
<!--咯归 场-->
<!--霸烙捞固瘤&霸烙规过 汲疙 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2"></td>
<td width="60" height="56"><img src="<%=img_path%>images/game/<%=game_img_path%>"></td>
<td width="4"></td>
<td width="102" valign="middle"><font color="#5E6364"><%=game_text%></font></td>
<td width="8"></td>
</tr>
</table>
</td>
</tr>
<!--霸烙捞固瘤&霸烙规过 汲疙 场-->
<!--咯归 矫累-->
<tr>
<td height="7"></td>
</tr>
<!--咯归 场-->
<!--霸烙矫累窍扁 滚瓢 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="46"></td>
<td width="84"><font color="#ECAAFF">⒑</font><font color="#9819E9"><a href='<%=url_path%>/ranking/start_game.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>'>霸烙矫累窍扁</a></font><font color="#ECAAFF">⒏</font></td>
<td width="46"></td>
</tr>
</table>
</td>
</tr>
<!--霸烙矫累窍扁 滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="10"></td>
</tr>
<!--咯归 场-->
<!--霸烙牢扁鉴困 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="60" align="right"></td>
<td width="100%" align="left"><font color="#ECAAFF">+霸烙牢扁鉴困 : </font><font color="#975ccd"><%=rank%>/<%=total_count%></font></td>
</tr>
</table>
</td>
</tr>
<!--霸烙牢扁鉴困 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!--档框富 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="128" align="right"></td>
<td width="100%" align="left"><font color="#98A3A4">⒑<a href='<%=url_path%>/ranking/game_help.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>'>档框富</a></font></td>
</tr>
</table>
</td>
</tr>
<!--档框富 场-->
<!--咯归 矫累-->
<tr>
<td height="7"></td>
</tr>
<!--咯归 场-->
<!--霸烙权 霸烙珐欧 滚瓢 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="12"></td>
<td width="75" height="16" bgcolor="#C789FF" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+mphone%>"><font color="#ffffff">霸烙权栏肺</font></a></td>
<td width="2"></td>
<td width="75" height="16" bgcolor="#C789FF" align="center"><a href="<%=url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx%>"><font color="#ffffff">霸烙珐欧栏肺</font></a></td>
<td width="12"></td>
</tr>
</table>
</td>
</tr>
<!--霸烙权 霸烙珐欧 滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="11"></td>
</tr>
<!--咯归 场-->
<!--版肺钎矫 矫累-->
<tr>
<td>
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
%>
<tr>
<td height="15" width="7" align="center" bgcolor="#BBC7C8"></td>
<td width="162" align="left" bgcolor="#DAE6E8"><a href="<%=step1%>">权</a>>霸烙</td>
<td height="15" width="7" align="center" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>
<%
}
catch (Exception e)
{
//out.println(e);
out.println(e);
throw e;
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) try{stmt.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -