📄 ranking_main.jsp.svn-base
字号:
<%@ page import='java.io.*,java.net.*,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;
String news_title=null;
String game_title=null;
String game_text=null;
String game_img_path=null;
int play_first=0;
int play_second=0;
int play_third=0;
int i=0;
String enjoy_game_title[] = new String[3];
String enjoy_game_text[] = new String[3];
/**************************************
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 sizeCvt=10;//荤捞令 牧滚泼矫 臂磊荐 啊廉坷绰 荐
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();
%>
<html>
<body>
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_game.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑窜 捞固瘤 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--
@其捞瘤 荐沥累诀 矫累
@Explain : 捞固瘤 颇老疙 temp_06.png俊辑 tit_01.png肺 官厕
@Auther : 冠惑辣(2007.11.02)
-->
<td width="176" align="center"><img src="<%=img_path%>images/ranking/tit_01.png"></td>
<!-- @其捞瘤 荐沥累诀 场 -->
</tr>
</table>
<!-- 惑窜 捞固瘤 场 -->
</td>
</tr>
<tr>
<td height="3" width="176" bgcolor="#ff2980" align='center'></td>
</tr>
<%
InetAddress inet= InetAddress.getLocalHost();
if (mphone.equals("0196686799") || mphone.equals("0192874282") || mphone.equals("01051323720") )
{
%>
<tr>
<td height="15" width="176" bgcolor="#ff2980" align='center'><b><font color='white'><%=inet.getHostAddress()%></font></b></td>
</tr>
<%
}else{
%>
<tr>
<td height="15" width="176" bgcolor="#ff2980" align='center'><b><font color='white'>≮快府甸狼 牢扁珐欧 BEST≮</font></b></td>
</tr>
<%
}
%>
<tr>
<td height="3" width="176" bgcolor="#ff2980" align='center'></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6"></td>
<td width="7"><img src="<%=img_path%>images/ranking/bu_01.png"></td>
<td width="2"></td>
<td width="49"><font color="#ff5980"><b>牢拱珐欧</b></font></td>
<td width="108" background="<%=img_path%>images/ranking/tab_04.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td width="6"></td>
<td width="5" bgcolor="#ffe0e4"></td>
<td width="160" bgcolor="#ffe0e4">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1"%>"><font color="#ff5980">模备炉</font></a>
<font color="#ff5980"> / </font>
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=2"%>"><font color="#ff5980">老扁炉</font></a>
<font color="#ff5980"> / </font>
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=3"%>"><font color="#ff5980">瘩臂炉</font></a>
<font color="#ff5980"> / </font>
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=4"%>"><font color="#ff5980">规巩炉</font></a>
</td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6"></td>
<td width="7"><img src="<%=img_path%>images/ranking/bu_01.png"></td>
<td width="2"></td>
<td width="49"><font color="#ff5980"><b>墨其珐欧</b></font></td>
<td width="108" background="<%=img_path%>images/ranking/tab_04.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td width="6"></td>
<td width="5" bgcolor="#ffe0e4"></td>
<td width="160" bgcolor="#ffe0e4">
<a href="<%=url_path+"/ranking/ranking_mycaferanking.jsp?mphone="+mphone+"&gphone="+mphone+"&rankType=1"%>"><font color="#ff5980">雀盔炉</font></a>
<font color="#ff5980"> / </font>
<a href="<%=url_path+"/ranking/ranking_mycaferanking.jsp?mphone="+mphone+"&gphone="+mphone+"&rankType=2"%>"><font color="#ff5980">霸矫炉</font></a>
</td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6"></td>
<td width="7"><img src="<%=img_path%>images/ranking/bu_01.png"></td>
<td width="2"></td>
<td width="49"><font color="#ff5980"><b>瘤侥珐欧</b></font></td>
<td width="108" background="<%=img_path%>images/ranking/tab_04.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td width="6"></td>
<td width="5" bgcolor="#ffe0e4"></td>
<td width="160" bgcolor="#ffe0e4">
<a href="<%=url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+mphone+"&rankType=2"%>"><font color="#ff5980">翠函炉</font></a>
<font color="#ff5980"> / </font>
<a href="<%=url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+mphone+"&rankType=1"%>"><font color="#ff5980">龙巩炉</font></a>
</td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6"></td>
<td width="7"><img src="<%=img_path%>images/ranking/bu_01.png"></td>
<td width="2"></td>
<td width="49"><font color="#ff5980"><b>傍皑珐欧</b></font></td>
<td width="108" background="<%=img_path%>images/ranking/tab_04.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td width="6"></td>
<td width="5" bgcolor="#ffe0e4"></td>
<td width="160" bgcolor="#ffe0e4">
<a href="<%=url_path+"/ranking/ranking_mygongamranking.jsp?mphone="+mphone+"&gphone="+mphone+"&rankType=1"%>"><font color="#ff5980">傍皑炉</font></a>
</td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6"></td>
<td width="7"><img src="<%=img_path%>images/ranking/bu_01.png"></td>
<td width="2"></td>
<td width="49"><font color="#ff5980"><b>霸烙珐欧</b></font></td>
<td width="108" background="<%=img_path%>images/ranking/tab_04.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td width="176" align="center"><font color="ff788f">霸烙阑 急琶窍矫搁<br>弊 霸烙狼 珐欧阑 焊角 荐 乐绢夸~</font></td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td width="176">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="4"></td>
<td width="138" align="center">
<select name="game_idx" >
<%
/**************************************
2.霸烙府胶飘
***************************************/
sql="select game_idx,game_title from "+vGameTableName+" where game_new=2";
rs=stmt.executeQuery(sql);
while(rs.next())
{
game_idx=rs.getInt("game_idx");
game_title=rs.getString("game_title");
%>
<option value='<%=game_idx%>'><%=game_title%></option>
<%
}
rs.close();
%>
</select>
</td>
<td width="30" bgcolor="#ffaec5" align="center"><font color="#ffffff"><a href="javascript:form.submit()"><font color="#FFFFFF">焊扁</font></a></font></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="13"></td>
</tr>
<!--
<tr align="center">
<td width="176">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="49" bgcolor="#ffffff"></td>
<td width="70" align="center" bgcolor="#e5efee"><a href=""><font color="#909090">捞侩痹蘑</font></a></td>
<td width="2" bgcolor="#ffffff"></td>
<td width="70" align="center" bgcolor="#e5efee"><a href=""><font color="#909090">捞侩规过</font></a></td>
<td width="49" bgcolor="#ffffff"></td>
</tr>
</table>
</td>
</tr>
-->
</table>
<!-- 窍窜 匙厚霸捞记 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td height="15"><a href="#">权</a>>鸥款珐欧</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 场-->
<%@ include file="../newbottom.jsp"%>
</form>
</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 + -