📄 game_savescore.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;
}
%>
<% //己龋
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
Date date = new Date();
response.setHeader("cache-control","no-cache");
response.setHeader("expires","0");
response.setHeader("pragma","no-cache");
String mphone = request.getParameter("mphone");
String gphone = mphone;
String game_idx = request.getParameter("game_idx");
int score = 0;
int beforeScore=0;
int todayScore=0;
int addClover = 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"; //努肺滚 郴开.
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
{
//=========================== 傍烹函券累诀 : 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 ===========================
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 phonenum2="+Long.parseLong(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 = "厚雀盔";
}
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())
{
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 篮 坷疵...
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();
}
}
}
/*------------------------------------------------------------------------------------------------------
+ 坷疵狼 风虐 备窍扁
-------------------------------------------------------------------------------------------------------*/
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;
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();
/*
//霸烙捞抚 啊廉坷扁
query1 = "select game_title from GT_game where game_idx="+game_idx;
rs = stmt.executeQuery(query1);
if(rs.next())
game_title=rs.getString(1);
else
game_title="霸烙裙垫";
//努肺滚 郴开俊 历厘茄促.
if(addClover > 0)
{
query1 = "select max(moneybook_total_clover) from "+ cloverTable+" where phonenum='"+mphone+"'";//弥辟 焊蜡俺荐 啊廉坷扁
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
int totClover=0;
if(rs.next())
totClover = rs.getInt(1);
rs=stmt.executeQuery(query1);
if(rs.next())
myNickname = rs.getString(1);
sql = "Insert into " + cloverTable + " (moneybook_itemname, moneybook_flag, moneybook_clover, moneybook_total_clover,phonenum)" + " Values(?,?,?,?,?) ";
pstmt = con.prepareStatement(sql);
pstmt.setString(1,game_title);//傈拳锅龋
pstmt.setInt(2,1);//裙垫敲贰弊
pstmt.setInt(3,addClover);//掘篮 努肺滚
pstmt.setInt(4,totClover+addClover);//醚 努肺滚
pstmt.setString(5,mphone);
pstmt.executeUpdate();
}
*/
}
con.commit();
if(rs != null) rs.close();
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) stmt.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);
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -