📄 ranking_game.jsp
字号:
<!--------------------------------------------------------
* @ 权 > 鸥款珐欧 > 辆钦珐欧
* @ Author : 碍辑康 ( 2008-05-19 )
* @ Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
----------------------------------------------------------->
<%@ 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;
}
%>
<%
/**************************************
Common_Variable_SET
***************************************/
int sizeCvt=100;//荤捞令 牧滚泼矫 臂磊荐 啊廉坷绰 荐
int adver_idx = 0;
String adver_img = null;
String adver_link = null;
// 其捞瘤 备泅 眠啊 函荐
// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
int pageNUM=1; // 其捞瘤 锅龋
int pageNUM2=1;
int absolutepage=1; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
int recordCount=0; //其捞隆 且 饭内靛 墨款飘
int pagesize=4; //其捞瘤 府胶飘 荐
int pagecount=1; //其捞瘤 荐
int gotoPage=1; //其捞瘤 逞滚
/**************************************
BASE_Variable_SET
***************************************/
String bgcolor=null;
int own_field=1; //(磊脚1,惑困0)
if(request.getParameter("own_field")!=null) own_field=Integer.parseInt(request.getParameter("own_field"));
String szCount ="";
int Rank=0;
if (own_field==1) pagesize=4;
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
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");//抗寇利栏肺 vm俊辑 逞绢棵锭 mphone阑 持绢霖促. 捞 其捞瘤俊辑父 弊犯促.
String sql=null, query2=null, goUserHome = null ,pagesql = null;
String phonenum=null, nickname=null;
String boardname=null;
int gamerank_idx=0, gamerank_score=0, myScore=0, myRank=0;
String game_title=null;
int game_idx=0; //霸烙 绊蜡锅龋
//0724
if(!isNull(request.getParameter("game_idx")).equals("") )//茫扁肺 甸绢柯 版快促.
{
game_idx = Integer.parseInt(request.getParameter("game_idx"));
}
else game_idx = 0;
boardname = "GT_gamerank_"+game_idx; //柳楼
//朝楼 包访
Date today = new Date();
String[] gameNameList = null;
int[] gameIdx=null;
int gameNameCnt = 0;
int gameArrIndex = 0;
String topPhone=null;
String topIntro=null;
String topNickname=null;
int topScore = 0;
String queryTop=null;
int topHave = 0; //1困啊 粮犁 窍搁..
String whereStr = "";
String columnName = "gamerank_score";//扁夯利栏肺 捞 拿烦疙阑 荤侩窃.
String turmText = "";
int searchRange = 1;// 坷疵:1, 捞锅林:2, 捞锅崔:3
if(!isNull(request.getParameter("searchRange")).equals("") )//茫扁肺 甸绢柯 版快促.
{
searchRange = Integer.parseInt(convKOR(request.getParameter("searchRange")));
}
else searchRange = 1;//扁夯篮 捞锅崔捞促.
String pageurl = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field="+own_field;
if(searchRange == 1)//坷疵
{
turmText = "坷疵";
columnName = "gamerank_today";
whereStr = " and datediff(day,gamerank_date,getdate())=0";
}
else if(searchRange == 2)//捞锅林
{
turmText = "林埃";//陛林
columnName = "gamerank_score";
whereStr = " and datediff(week,gamerank_date,getdate())=0";
}
else if(searchRange == 3)//捞锅崔
{
columnName = "gamerank_score";
turmText = "穿利";
whereStr = " ";
}
String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧啪 栏肺
String RangeLink1 = "";
String RangeLink2 = "";
String RangeLink3 = "";
//鸥款珐欧 皋春 傅农=====
String goGameLink =url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone;//霸烙珐欧
String goMyLink =url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&subto=1";//myranking
String goCafeLink =url_path+"/ranking/ranking_cafe.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//墨其
String goKnowLink =url_path+"/ranking/ranking_knowrank.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//瘤侥
String goGongLink =url_path+"/ranking/ranking_gong.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//傍埃
//==
%>
<%
try
{
%><%@ include file="../getConnection.jsp"%><%
stmt = con.createStatement();
/****************************
******************************/
if(game_idx==0)//0724
{
if(columnName == "gamerank_today"){
columnName = "point";
}else{
columnName = "point_old";
}
queryTop = "select TOP 1 phonenum, "+columnName+",nickname "+
" from gt_gameranking order by "+columnName+" desc ";
pstmt = con.prepareStatement(queryTop);
rs = pstmt.executeQuery();
if(rs.next())
{
topHave = 1;//1困啊 粮犁茄促.
topPhone = rs.getString(1);
topScore= rs.getInt(2);
topNickname = rs.getString(3);
String queryIntro = "select cafe_intro from GT_cafe where phonenum='0"+topPhone+"'";
pstmt = con.prepareStatement(queryIntro);
ResultSet rsrs = pstmt.executeQuery();
if(rsrs.next()){
topIntro = rsrs.getString("cafe_intro");
}
}
else
{
topHave = 0;//1困啊 粮犁茄促.
}
rs.close();
pstmt.close();
//霸烙 力格 啊廉坷扁
sql = "select game_title,qvga_img from "+vGameTableName+" where game_idx="+game_idx;
rs = stmt.executeQuery(sql);
if(rs.next())
{
game_title = rs.getString(1);
}
rs.close();
sql = "select count(game_idx) from "+vGameTableName+" where game_new=2";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
gameNameCnt = rs.getInt(1);
gameIdx = new int[gameNameCnt];
gameNameList = new String[gameNameCnt];
}
rs.close();
pstmt.close();
sql = "select game_idx, game_title from "+vGameTableName+" where game_new=2 order by game_hit desc";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next())
{
gameIdx[gameArrIndex] = rs.getInt(1);
gameNameList[gameArrIndex] = rs.getString(2);
gameArrIndex++;
}
rs.close();
pstmt.close();
RangeLink1 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=1&own_field="+own_field;//坷疵
RangeLink2 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=2&own_field="+own_field;//捞锅林
RangeLink3 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=3&own_field="+own_field;//捞锅崔
String sqlsql = "select idx, phonenum,nickname,"+columnName+ " from gt_gameranking where " +
" idx not in(select Top 1 idx from gt_gameranking)";
szCount ="select count(idx) from("+sqlsql+")countNum";
pstmt = con.prepareStatement(szCount);
pageset = pstmt.executeQuery();
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"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
}else{
//1困牢 荤恩狼 迄锅龋客 intro 啊廉柯促 啊廉柯促. 0607
queryTop = "select TOP 1 "+boardname+".phonenum, "+boardname+"."+columnName+", "+boardname+".nickname "+
" from "+boardname+" order by "+columnName+" desc ";
pstmt = con.prepareStatement(queryTop);
rs = pstmt.executeQuery();
if(rs.next())
{
topHave = 1;//1困啊 粮犁茄促.
topPhone = rs.getString(1);
topScore= rs.getInt(2);
topNickname = rs.getString(3);
String queryIntro = "select cafe_intro from GT_cafe where phonenum='0"+topPhone+"'";
pstmt = con.prepareStatement(queryIntro);
ResultSet rsrs = pstmt.executeQuery();
if(rsrs.next()){
topIntro= rsrs.getString("cafe_intro");
}
}
else
{
topHave = 0;//1困啊 粮犁茄促.
}
rs.close();
pstmt.close();
if(request.getParameter("pageNUM")!=null) gotoPage=Integer.parseInt(request.getParameter("pageNUM"));
else//其捞瘤 绝捞 立加(弥檬 立加捞促)
{
if (own_field==1)
{
if(myRank%pagesize == 0)
gotoPage=myRank/pagesize;//瘤沥等 其捞瘤 焊咯林扁
else
gotoPage=myRank/pagesize+1;//瘤沥等 其捞瘤 焊咯林扁
}
}
//霸烙 力格 啊廉坷扁
sql = "select game_title from "+vGameTableName+" where game_idx="+game_idx;
rs = stmt.executeQuery(sql);
if(rs.next())
{
game_title = rs.getString(1);
}
rs.close();
sql = "select count(game_idx) from "+vGameTableName+" where game_new=2";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
gameNameCnt = rs.getInt(1);
gameIdx = new int[gameNameCnt];
gameNameList = new String[gameNameCnt];
}
rs.close();
pstmt.close();
sql = "select game_idx, game_title from "+vGameTableName+" where game_new=2 order by game_hit desc";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next())
{
gameIdx[gameArrIndex] = rs.getInt(1);
gameNameList[gameArrIndex] = rs.getString(2);
gameArrIndex++;
}
rs.close();
pstmt.close();
RangeLink1 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=1&own_field="+own_field;//坷疵
RangeLink2 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=2&own_field="+own_field;//捞锅林
RangeLink3 = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange=3&own_field="+own_field;//捞锅崔
/***********************************
get the page about myself should be
************************************/
pagesql = "select gamerank_idx, phonenum, "+columnName+" from "+boardname+" where "+
"gamerank_idx not in(select Top 1 gamerank_idx from "+boardname+" order by "+columnName+" desc ) "+
"order by "+columnName+" desc ";
if(pstmt != null) pstmt.close();
if(rs != null) rs.close();
pstmt = con.prepareStatement(pagesql);
rs = pstmt.executeQuery();
String page_cafe_phonenum = null;
int i = 1;
while(rs.next()){
page_cafe_phonenum = rs.getString(2);
if(page_cafe_phonenum.equals(mphone)){
if(i> pagesize && i % pagesize == 0){
pageNUM2 = i/pagesize;
break;
}else if(i> pagesize && i % pagesize != 0){
pageNUM2 = i/pagesize+1;
break;
}else if (i<= pagesize){
pageNUM2 = 1;
break;
}
}
i++;
}
String sqlsql = "select gamerank_idx, phonenum,nickname,"+columnName+ " from "+boardname+" where " +
"gamerank_idx not in(select Top 1 gamerank_idx from "+boardname+")";
szCount ="select count(gamerank_idx) from("+sqlsql+")countNum";
pstmt = con.prepareStatement(szCount);
pageset = pstmt.executeQuery();
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"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
}
%>
<html>
<head>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -