📄 game_savescore_friend.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"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%>
<%
response.setHeader("cache-control","no-cache");
response.setHeader("expires","0");
response.setHeader("pragma","no-cache");
/***********************************************************************
@ Page Description
己龋
珐欧历厘
@ Parameter
***********************************************************************/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String game_idx = request.getParameter("game_idx");
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
int score = 0;
int beforeScore=0;
int oppScore = 0;
int todayScore=0;
int addClover = 0;
int idx = 0;
int winFlag = 0;
String myNickname="";
String query1=null, sql=null;
String dayGap=null;
int isMember = 0; //雀盔1, 厚雀盔0
String game_title = "";
String boardname = "GT_gamerank_"+game_idx;//历厘且 霸烙 珐欧 抛捞喉
String cloverTable = "GT_moneybook"; //努肺滚 郴开.
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
Date date = new Date();
if(!isNull(request.getParameter("score")).equals("") ){ score = Integer.parseInt(request.getParameter("score"));}
if(!isNull(request.getParameter("addClover")).equals("") ){ addClover = Integer.parseInt(request.getParameter("addClover"));}
int before_score=Integer.parseInt(request.getParameter("before_score"));
%>
<%
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%
con.setAutoCommit(false);
stmt=con.createStatement();
query1 = " DELETE GT_log_game_connection ";
query1 = query1 + " WHERE phonenum="+Long.parseLong(mphone);
stmt.executeUpdate(query1);
/*------------------------------------------------------------------------------------------------------
+ 郴 喊疙 啊廉坷扁
-------------------------------------------------------------------------------------------------------*/
int sex = 0;
String phonenum=null;
query1 = "select nickname,sex,phonenum from GT_user_info where phonenum='"+mphone+"'";
if(rs != null) rs.close();
rs=stmt.executeQuery(query1);
if(rs.next())
{
isMember = 1;
myNickname = rs.getString(1);
sex = rs.getInt("sex");
phonenum=rs.getString("phonenum");
}
else
{
isMember = 0;
myNickname = "厚雀盔";
}
rs.close();
if(isMember == 1)
{
/*------------------------------------------------------------------------------------------------------
+ 痢荐 历厘窍扁 ( 盔贰 乐带 版快 诀单捞飘, 脚痹捞搁 积己秦辑 历厘)
-------------------------------------------------------------------------------------------------------*/
sql = " select gamerank_idx, gamerank_score, gamerank_today,datediff(day,gamerank_date,getdate()) as dayGap ";
sql = sql + " from "+boardname+" where phonenum='"+mphone+"'";
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
if(!rs.next())
{
rs.close();
sql = "Insert into "+boardname+" (phonenum, nickname, gamerank_score, gamerank_today) Values(?,?,?,?)";
if(pstmt != null) pstmt.close();
pstmt = con.prepareStatement(sql);
pstmt.setString(1,mphone);//傈拳锅龋
pstmt.setString(2,myNickname);//喊疙
pstmt.setInt(3,score);//痢荐
pstmt.setInt(4,score);//痢荐
pstmt.executeUpdate();
}
else
{
beforeScore = rs.getInt("gamerank_score"); //扁粮弥绊痢荐 啊廉柯促.
todayScore = rs.getInt("gamerank_today"); //坷疵痢荐 啊廉柯促.
dayGap = rs.getString("dayGap"); //朝楼 gap阑 啊廉柯促 0 篮 坷疵...
rs.close();
if (dayGap.equals("0"))
{
if(beforeScore < score)//捞锅俊 霸烙茄 痢荐啊 脚扁废焊促 歹 臭促.
{
sql = " UPDATE "+boardname;
sql = sql + " SET gamerank_score="+score;
sql = sql + " , gamerank_today="+score;
sql = sql +" , gamerank_date=GETDATE() where phonenum='"+mphone+"'";
if(pstmt != null) pstmt.close();
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
/*
int scoregap = score - beforeScore;
sql = "UPDATE GT_gameplay_info set play_totalscore=play_totalscore+"+scoregap+" where phonenum='"+mphone+"'";
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
*/
}
else //弥绊扁废焊促 泅犁 痢荐啊 撤栏搁
{
if(todayScore < score) //规陛茄 霸烙痢荐啊 坷疵 扁废茄 霸烙焊促 歹 臭促搁 坷疵弥绊痢荐甫 诀单捞飘 茄促.
{
sql = " Update "+boardname;
sql = sql + " SET gamerank_today="+score;
sql = sql + " , gamerank_date=GETDATE() ";
sql = sql + " WHERE phonenum='"+mphone+"'";
if(pstmt != null) pstmt.close();
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
}
}
}
else
{ //坷疵 贸澜 捞侩.....
if(beforeScore < score)//捞锅俊 霸烙茄 痢荐啊 脚扁废焊促 歹 臭促.
{
sql = " UPDATE "+boardname;
sql = sql + " SET gamerank_score="+score;
sql = sql + " , gamerank_today="+score;
sql = sql +" , gamerank_date=GETDATE() where phonenum='"+mphone+"'";
if(pstmt != null) pstmt.close();
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
/*
int scoregap = score - beforeScore;
sql = "UPDATE GT_gameplay_info set play_totalscore=play_totalscore+"+scoregap+" where phonenum='"+mphone+"'";
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
*/
}
else //弥绊扁废焊促 泅犁 痢荐啊 撤栏搁
{
sql = " Update "+boardname;
sql = sql + " SET gamerank_today="+score;
//sql = sql + " SET gamerank_today=1000";
sql = sql + " , gamerank_date=GETDATE() ";
sql = sql + " WHERE phonenum='"+mphone+"'";
if(pstmt != null) pstmt.close();
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
}
}
}
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
/*------------------------------------------------------------------------------------------------------
+ 坷疵狼 风虐 备窍扁
-------------------------------------------------------------------------------------------------------*/
int rookie_idx = 0;
int up_grade = 0;
int new_up_grade = 0;
sql = "select rookie_idx,up_grade from GT_gamerookie where sex = "+sex+" and datediff(day,regdate,getdate())=0";
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
if(rs.next())//扁粮 风虐啊 乐促.
{
rookie_idx = rs.getInt("rookie_idx");
up_grade = rs.getInt("up_grade");
rs.close();
sql = "select count(*)cnt from GT_gamerank_"+game_idx+" where "+before_score+" < gamerank_today and gamerank_today < "+score;
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
rs.next();
new_up_grade = rs.getInt("cnt");
rs.close();
if(up_grade < new_up_grade)//(眠啊)
{
sql = "update GT_gamerookie set phonenum='"+phonenum+"',nickname='"+myNickname+"',sex="+sex+",up_grade="+new_up_grade+",regdate=getdate() where rookie_idx="+rookie_idx;
if(rs != null) rs.close();
stmt.executeUpdate(sql);
}
}
else//扁粮 风虐啊 绝促(眠啊)
{
sql = "select count(*)cnt from GT_gamerank_"+game_idx+" where "+before_score+" < gamerank_today and gamerank_today < "+score;
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
rs.next();
new_up_grade = rs.getInt("cnt");
rs.close();
sql = "insert into GT_gamerookie(phonenum,nickname,sex,up_grade) values('"+phonenum+"','"+myNickname+"',"+sex+","+new_up_grade+")";
stmt.executeUpdate(sql);
}
/**************************************
GT_gameplay_info俊 insert 窍扁
***************************************/
int [] play_game = new int[10];
int [] play_temp = new int[10];
int i = 0, j = 0;
sql = "select play_idx, play_first, play_second, play_third,play_4,play_5,play_6,play_7,play_8,play_9,play_10 from GT_gameplay_info where phonenum='"+mphone+"'";
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
if(rs.next())//粮犁茄促
{
play_game[0]=rs.getInt("play_first");
play_game[1]=rs.getInt("play_second");
play_game[2]=rs.getInt("play_third");
play_game[3]=rs.getInt("play_4");
play_game[4]=rs.getInt("play_5");
play_game[5]=rs.getInt("play_6");
play_game[6]=rs.getInt("play_7");
play_game[7]=rs.getInt("play_8");
play_game[8]=rs.getInt("play_9");
play_game[9]=rs.getInt("play_10");
for(i=0;i<9;i++)
{
if(play_game[i] == Integer.parseInt(game_idx))
j++;
play_game[i] = play_game[j];
j++;
}
for(i=0;i<9;i++)
{
play_temp[i+1] = play_game[i];
}
play_temp[0] = Integer.parseInt(game_idx);
sql = "update GT_gameplay_info set play_first= ? , play_second= ? , play_third=?,play_4=?,play_5=?,play_6=?,play_7=?,play_8=?,play_9=?,play_10=? where phonenum= ? ";
if(pstmt != null) pstmt.close();
pstmt= con.prepareStatement(sql);
pstmt.setInt(1, play_temp[0]);
pstmt.setInt(2, play_temp[1]);
pstmt.setInt(3, play_temp[2]);
pstmt.setInt(4, play_temp[3]);
pstmt.setInt(5, play_temp[4]);
pstmt.setInt(6, play_temp[5]);
pstmt.setInt(7, play_temp[6]);
pstmt.setInt(8, play_temp[7]);
pstmt.setInt(9, play_temp[8]);
pstmt.setInt(10, play_temp[9]);
pstmt.setString(11, mphone);
pstmt.executeUpdate();
}
else//粮犁窍瘤 臼绰促.
{
sql = "insert into GT_gameplay_info (play_first, phonenum) values( ? , ? )";
if(pstmt != null) pstmt.close();
pstmt= con.prepareStatement(sql);
pstmt.setInt(1, Integer.parseInt(game_idx));
pstmt.setString(2, mphone);
pstmt.executeUpdate();
}
rs.close();
/*------------------------------------------------------------------------------------------------------
+
-------------------------------------------------------------------------------------------------------*/
sql = " select gamerank_score ";
sql = sql + " from "+boardname+" where phonenum='"+gphone+"'";
if(rs != null) rs.close();
rs=stmt.executeQuery(sql);
if(rs.next()){
oppScore = rs.getInt("gamerank_score");
}
rs.close();
pstmt.close();
if(score<oppScore)
{
winFlag = 0;
}
else{
winFlag = 1;
}
/*------------------------------------------------------------------------------------------------------
+ GT_GAMEMATCH update
-------------------------------------------------------------------------------------------------------*/
sql = "select max(idx) idx from gt_GameMatch where phonenum =?";
pstmt= con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
rs = pstmt.executeQuery();
if (rs.next()){
idx = rs.getInt("idx");
}
sql = "update gt_GameMatch set winFlag = ? where idx = ?";
pstmt= con.prepareStatement(sql);
pstmt.setInt(1,winFlag);
pstmt.setInt(2,idx);
pstmt.executeUpdate();
pstmt.close();
}
con.commit();
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(pstmt != null) pstmt.close();
//if(con != null) con.close();
}
catch (Exception e)
{
con.rollback();
out.println(e);
}
finally
{
con.setAutoCommit(true);
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){}
}
// String redirectUrl = url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx;
// response.sendRedirect(redirectUrl);
// if(true) return;
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -