📄 game_gamename.jsp.svn-base
字号:
nickname = rs.getString(1);
sex = rs.getInt(2);
}
rs.close();
int rsFlag = 0;
query1 = "select nickname_man, nickname_woman,(gamescore_man+gamescore_woman)score from GT_gamecouple where game_idx = "+game_idx+" and (phonenum_man = '"+mphone+"' or phonenum_woman = '"+mphone+"')";
rs=stmt.executeQuery(query1);
//out.println(query1);
if(!rs.next())
{
// mynickname = rs.getString(1);
// mycouplenickname = rs.getString(2);
// myscore = rs.getInt(3);
rsFlag = 1;
}
rs.close();
if(rsFlag == 1)
{
if(sex == 1)//咯磊
query1 = "select top 1 phonenum,nickname from GT_user_info where sex = 2 and phonenum not in (select phonenum_woman from GT_gamecouple) order by newid()";
else
query1 = "select top 1 phonenum,nickname from GT_user_info where sex = 1 and phonenum not in (select phonenum_man from GT_gamecouple) order by newid()";
rs=stmt.executeQuery(query1);
//out.println(query1);
if(rs.next())
{
couplephone = rs.getString(1);
couplenickname = rs.getString(2);
}
else//目敲阑 急沥且荐 绝促
{
response.sendRedirect(url_path+"/ranking/game_notcouple.jsp?mphone="+mphone+"&gphone="+gphone);
return;
}
rs.close();
if(sex == 1)//咯磊
{
query1 = "insert into GT_gamecouple (game_idx,game_title,phonenum_man,nickname_man,phonenum_woman,nickname_woman) values("+game_idx+",'"+game_title+"','"+couplephone+"','"+couplenickname+"','"+mphone+"','"+nickname+"')";
}
else
{
query1 = "insert into GT_gamecouple (game_idx,game_title,phonenum_man,nickname_man,phonenum_woman,nickname_woman) values("+game_idx+",'"+game_title+"','"+mphone+"','"+nickname+"','"+couplephone+"','"+couplenickname+"')";
}
stmt.executeUpdate(query1);
}
}
%>
<tr width="240">
<td height="60" align="center" bgcolor="#FF9DAC"><font color="#FFFFFF">目敲霸烙篮 老喊肺 巢赤狼 局沥款 单捞磐甫 烹窍咯 弊朝狼 模剐档啊 臭篮 鉴栏肺 目敲捞 肝绢瘤哥 笛狼 痢荐甫 钦魂窍咯 珐欧俊 殿废登绰 规侥栏肺 柳青登绰 霸烙涝聪促.</font></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td bgcolor="#ff99a5" height="2"></td>
</tr>
<tr>
<td height="17" bgcolor="#ff6d7e" align="center"><font color="#ffffff"><b>+++坷疵狼 目敲+++</b></font></td>
</tr>
<tr>
<td bgcolor="#ff99a5" height="2"></td>
</tr>
<tr>
<td height="5" bgcolor="#ffaec5"></td>
</tr>
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr height="34">
<td width="6" bgcolor="#ffaec5"></td>
<td width="48" height="58" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>"></td>
<td width="3" bgcolor="#ffaec5"></td>
<td width="126" align="center" bgcolor="#ffe6f5"><font color="#000000"><a href="<%=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+mphone%>"><%=nickname%></a><Br><font color="#ff2431">⒕</font><br><a href="<%=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+couplephone%>"><%=couplenickname%></a></font></td>
<td width="3" bgcolor="#ffaec5"></td>
<td width="48" height="58" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=couplephone%>&gphone=<%=couplephone%>"></td>
<td width="6" bgcolor="#ffaec5"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5" bgcolor="#ffaec5"></td>
</tr>
<!-- 目敲霸矫魄 [S]-->
<%@ include file="../game/coupleBoard_list.jsp"%>
<!-- 目敲霸矫魄 [E]-->
<tr>
<td height="7"></td>
</tr>
<tr>
<td align="center" width="240">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="61" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>&gamePlayType=<%=gamePlayType%>"><font color="#ffffff">霸烙矫累</font></a></td>
<td width="2"></td>
<td width="61" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_help.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">霸烙汲疙</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td align="center" width="240">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="124" bgcolor="#a8bfff" align="center"><a href="<%=url_path+"/ranking/game_result_couple.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx%>"><font color="#ffffff">目敲珐欧</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td align="center" width="240">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="124" bgcolor="#a8bfff" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="12"></td>
</tr>
<%
break;
case 2:
/*------------------------------------------------------------------------------------------------------
+ 模备霸烙
-------------------------------------------------------------------------------------------------------*/
%>
<tr>
<td height="60" align="center" bgcolor="#FF9DAC"><font color="#FFFFFF">泅犁 捞 霸烙阑 茄<br>郴 模备甸狼 珐欧焊促 臭阑 版快<br>档惯厘捞 模备狼 率瘤肺 朝酒癌聪促.<br></font></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="17">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#9fb7f8"></td>
<td width="230" bgcolor="#9fb7f8"><font color="#6a76f2">+</font> <font color="#ffffff">模备甸狼 林埃珐欧</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="7"></td>
</tr>
<%
/**************************************
3.模备 珐欧 啊廉坷扁
***************************************/
//其捞隆-----------------------------------------------------
//stmt = con.createStatement();
pageset = stmt.executeQuery("select count(b.phonenum) FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0");
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"));//瘤沥等 其捞瘤 焊咯林扁
if(pageNUM > pagecount)
pageNUM = pagecount;
absolutepage=(pageNUM-1)*pagesize;
}
if(pageset != null) pageset.close();
//其捞隆场-----------------------------------------------------
query1 = "select top "+pagesize+" b.phonenum, b.nickname, b.gamerank_score FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 and b.gamerank_idx not in(select top "+absolutepage+" b.gamerank_idx FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = cast(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 order by b.gamerank_score desc,b.gamerank_date desc) order by b.gamerank_score desc,b.gamerank_date desc";
rs=stmt.executeQuery(query1);
//out.println(query1);
stmt2 = con.createStatement();
while(rs.next())
{
friendphone = rs.getString(1);
friendnickname = rs.getString(2);
score = rs.getInt(3);
query2 ="select count(*)+1 from GT_gamerank_"+game_idx+" where datediff(week,gamerank_date,getdate())=0 and ("+score+" < gamerank_score or ("+score+" = gamerank_score and '"+friendphone+"' < phonenum ))";
//out.println(query2);
rs2=stmt2.executeQuery(query2);
rs2.next();
%>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr height="60">
<td width="54" bgcolor="#dae6e8">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="3">
<td width="3"></td>
<td width="48"></td>
<td width="3"></td>
</tr>
<tr height="54">
<td width="3"></td>
<td width="48"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=friendphone%>&gphone=<%=friendphone%>" width="48" height="54" border="0"></td>
<td width="3"></td>
</tr>
<tr height="3">
<td width="3"></td>
<td width="48"></td>
<td width="3"></td>
</tr>
</table>
</td>
<td width="3"></td>
<td width="183" bgcolor="#dae6e8">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="8"></td>
<td width="175"><font color="#6a76f2"><b><%=rs2.getInt(1)%>困</b></font><br><font color="#5e6364"><%=friendnickname%></font><br><%=score%>痢</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
<%
rs2.close();
friendCnt++;
}
%>
<tr>
<td height="19" bgcolor="#e5ecff" align="center">
<%
String pageurl = url_path+"/ranking/game_gamename.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&gamePlayType="+gamePlayType;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="61" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>&gamePlayType=<%=gamePlayType%>"><font color="#ffffff">霸烙矫累</font></a></td>
<td width="2"></td>
<td width="61" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_help.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">霸烙汲疙</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="124" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_recordmsg.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>&gamePlayType=<%=gamePlayType%>"><font color="#ffffff">档惯厘膏飘静扁</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="58"></td>
<td width="124" bgcolor="#a8bfff" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
<td width="58"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="12"></td>
</tr>
<%
break;
}
%>
</table>
<%
}
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(rs2 != null) try{ rs2.close(); }catch(Exception se){}
if(stmt2 != null) try{ stmt2.close(); }catch(Exception se){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0";//霸烙皋牢
%>
<table cellpadding="0" cellspacing="0" width="240" height="19">
<tr>
<td width="10" bgcolor="#BDC7CE"> </td>
<td width="220" bgcolor="#DEE7EF"><a href="<%=step1%>">权</a>><a href="<%=step2%>">霸烙皋牢</a>>霸烙救郴</td>
<td width="10" bgcolor="#BDC7CE"> </td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -