📄 ranking_people.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"%>
<%@ include file="../common_func.jsp"%>
<%
/**************************************
BASE_Variable_SET
***************************************/
int rankType=2; //扁夯蔼篮 老扁
int own_field=1; //(磊脚1,惑困0)
String bgcolor=null;
String table_field=null;
if(request.getParameter("rankType")!=null) rankType=Integer.parseInt(request.getParameter("rankType")); //傈俊 静带 珐农鸥涝 函荐扼辑 弊措肺 借促...
if(request.getParameter("own_field")!=null) own_field=Integer.parseInt(request.getParameter("own_field"));
String orderby_field = null; //鞘靛疙(模备/老扁/瘩臂/规巩)
String orderby_field2 = null; //鞘靛疙(痢荐啊 鞍疽阑锭 滴锅掳 眉农炼扒)
String orderby_field_msg=null;
if(request.getParameter("table_field")!=null) table_field=request.getParameter("table_field"); //坷疵,林埃,穿利 殿 扁埃阑 困茄 抛捞喉 捞悼
else table_field="gt_count_today";
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];
int myClover=0;
String adver_info_text=null;
int adver_info_clover=0;
int adver_info_idx=0;
int friend_request_idx=0;
String request_intro=null;
int sex=0;
String sexString=null;
int year=0;
int myAge=0;
int myArea=0;
String myexp1=null;
String myexp2=null;
String myexp3=null;
String member_rank=null;
String name=null;
int score=0;
String phonenum=null;
String nickname=null;
int myscore=0;
int myRank=0;
String myphonenum=null;
String mynickname=null;
String topphonenum=null;
String topnickname=null;
String topintro=null;
int topscore=0;
int rank=0;
/**************************************
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
***************************************/
//Calendar now = Calendar.getInstance();
//int thisYear = now.get(Calendar.YEAR);
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("mphone");
int sizeCvt=100;//荤捞令 牧滚泼矫 臂磊荐 啊廉坷绰 荐
int adver_idx = 0;
String adver_img = null;
String adver_link = null;
int recordCount=0; //其捞隆 且 饭内靛 墨款飘
int pagesize=4; //其捞瘤 府胶飘 荐
int pagecount=0; //其捞瘤 荐
int gotoPage=1; //其捞瘤 逞滚
String pageurl = url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field="+table_field+"&rankType="+rankType+"&own_field="+own_field;
if (own_field==1) pagesize=5;
//鸥款珐欧 皋春 傅农=====
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_mycaferanking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//墨其
String goKnowLink =url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//瘤侥
String goGongLink =url_path+"/ranking/ranking_mygongamranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//傍皑
//==
/**************************************
Rank_Type_SET
***************************************/
switch (rankType)
{
case 1: //模备
orderby_field="ranker_friend_cnt";
orderby_field_msg="模备炉篮 模备啊 腹篮<br>鸥款 雀盔狼 鉴困涝聪促.";
break;
case 2://老扁
orderby_field="ranker_diary";
orderby_field_msg="老扁炉篮 老扁甫 啊厘 腹捞 敬<br>鸥款 雀盔狼 鉴困涝聪促.";
break;
case 3://瘩臂
orderby_field="ranker_reply";
orderby_field_msg="瘩臂炉篮 瘩臂阑 啊厘 腹捞 敬<br>鸥款 雀盔 鉴困涝聪促.";
break;
case 4://规巩
orderby_field="ranker_guest";
orderby_field_msg="规巩炉篮 磊脚狼 迄乔俊 规巩磊啊<br>啊厘 腹篮 鸥款 雀盔 鉴困涝聪促.";
break;
}
/**************************************
Rank_Type_SET
***************************************/
if (table_field.equals("gt_count_today"))
{
orderby_field2="count_today_idx";
}
else if (table_field.equals("gt_count_week"))
{
orderby_field2="count_week_idx";
}
else
{
orderby_field2="ranker_idx";
}
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();
if (own_field==1)
{
/**************************************
1.唱狼 殿荐扁废捞 乐绰瘤 咯何......
***************************************/
sql="SELECT myRank=(select count(*)+1 from "+table_field+" WITH(NOLOCK) where (a."+orderby_field+"<"+orderby_field+" or (a."+orderby_field+"="+orderby_field+" and a."+orderby_field2+"<"+orderby_field2+" )))";
sql=sql+",phonenum,nickname,"+orderby_field+" FROM "+table_field+" a WITH(NOLOCK) where phonenum='"+mphone+"'"; //(GT_ranker, GT_count_today, GT_count_week)
rs=stmt.executeQuery(sql);
if(rs.next())
{
member_rank="YES";
myRank=rs.getInt("myRank");
myphonenum=rs.getString("phonenum");
mynickname=rs.getString("nickname");
myscore=rs.getInt(4);
}
else
{
member_rank="NO";
}
rs.close();
}
else
{
member_rank="NO";
/**************************************
2.惑困 1殿
***************************************/
sql="select top 1 a.phonenum,a.nickname,"+orderby_field+",b.intro from "+table_field+" a WITH(NOLOCK) ,GT_user_info b where a.phonenum=b.phonenum order by "+orderby_field+" DESC,a.phonenum DESC";
rs=stmt.executeQuery(sql);
if(rs.next())
{
topintro=rs.getString("intro");
topphonenum=rs.getString("phonenum");
topnickname=rs.getString("nickname");
topscore=rs.getInt(3);
}
rs.close();
}
/**************************************
3.傈眉霸烙(饭内靛 墨款飘)
***************************************/
sql="select count(phonenum) as recCount from " + table_field + " WITH(NOLOCK) "; //(GT_ranker, GT_count_today, GT_count_week)
if (own_field==0) sql=sql+" where phonenum not in('"+topphonenum+"')";
rs=stmt.executeQuery(sql);
if(rs.next())
{
recordCount = rs.getInt("recCount");
pagecount = ((recordCount-1)/pagesize) +1;
}
else pagesize=0;
rs.close();
if(request.getParameter("pageNUM")!=null) gotoPage=Integer.parseInt(request.getParameter("pageNUM"));
else//其捞瘤 绝捞 立加(弥檬 立加捞促)
{
if (own_field==1 && member_rank.equals("YES"))
{
if(myRank%pagesize == 0)
gotoPage=myRank/pagesize;//瘤沥等 其捞瘤 焊咯林扁
else
gotoPage=myRank/pagesize+1;//瘤沥等 其捞瘤 焊咯林扁
}
}
%>
<html>
<link href="mobile.css" rel="stylesheet" type="text/css">
<body>
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_people.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<!--<input type="hidden" name="pageNUM" value="<%=gotoPage%>">-->
<input type="hidden" name="orderby_field" value="<%=orderby_field%>">
<input type="hidden" name="table_field" value="<%=table_field%>">
<input type="hidden" name="own_field" value="<%=own_field%>">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑窜 官 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="<%=img_path%>images/ranking/bg_01.png" width="8" height="19"></td>
<td background="<%=img_path%>images/ranking/bg_01.png" width="176"><font color="#ffffff">牢拱珐欧</font></td>
</tr>
</table>
<!-- 惑窜 官 场 -->
</td>
</tr>
<tr>
<td height="9"></td>
</tr>
<tr>
<td align="center"><font color="#909090">墨抛绊府甫 急琶窍矫搁 弊<br>墨抛绊府狼 珐欧阑 焊角 荐 乐绢夸~<br>∝300困鼻 观篮 焊咯瘤瘤 臼嚼聪促</font></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td width="176">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="39"></td>
<td width="69" align="center">
<select name="rankType">
<%
if (rankType==1)
{
out.print("<OPTION value='1' selected>模备炉</OPTION>");
out.print("<OPTION value='2'>老扁炉</OPTION>");
out.print("<OPTION value='3'>瘩臂炉</OPTION>");
out.print("<OPTION value='4'>规巩炉</OPTION>");
}
else if (rankType==2)
{
out.print("<OPTION value='1' >模备炉</OPTION>");
out.print("<OPTION value='2' selected>老扁炉</OPTION>");
out.print("<OPTION value='3'>瘩臂炉</OPTION>");
out.print("<OPTION value='4'>规巩炉</OPTION>");
}
else if (rankType==3)
{
out.print("<OPTION value='1' >模备炉</OPTION>");
out.print("<OPTION value='2' >老扁炉</OPTION>");
out.print("<OPTION value='3' selected>瘩臂炉</OPTION>");
out.print("<OPTION value='4'>规巩炉</OPTION>");
}
else
{
out.print("<OPTION value='1' >模备炉</OPTION>");
out.print("<OPTION value='2' >老扁炉</OPTION>");
out.print("<OPTION value='3' >瘩臂炉</OPTION>");
out.print("<OPTION value='4' selected>规巩炉</OPTION>");
}
%>
</select>
</td>
<td width="30" bgcolor="#ffaec5" align="center"><a href="javascript:form.submit()"><font color="#ffffff">焊扁</font></a></td>
<td width="38"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td bgcolor="#ff9dac" align="center"><font color="#ffffff"><%=orderby_field_msg%></font></td>
</tr>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="11"></td>
</tr>
<!-- 坷疵滚瓢 劝己拳 -->
<tr>
<td width="176">
<table align="center" border="0" cellpadding="0" cellspacing="0" width="176"><tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="176">
<tr height="1">
<td width="20"></td>
<td width="136" bgcolor="#909090"></td>
<td width="20"></td>
</tr>
<tr>
<td align="center" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" width="137">
<tr height="18">
<td width="1" bgcolor="#909090"></td>
<% if(!table_field.equals("gt_count_today")){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field=gt_count_today&rankType="+rankType+"&own_field="+own_field%>"><font color="#606060">坷疵</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">坷疵</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(!table_field.equals("gt_count_week")){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field=gt_count_week&rankType="+rankType+"&own_field="+own_field%>"><font color="#606060">林埃</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">林埃</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(!table_field.equals("gt_ranker")){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&table_field=gt_ranker&rankType="+rankType+"&own_field="+own_field%>"><font color="#606060">穿利</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">穿利</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
</tr>
</table>
</td>
</tr>
<tr height="1">
<td width="176" bgcolor="#909090" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -