userstats.jsp

BBS系统

<%
/*##################################################################**
**#  LyBBS ver 1.2.b2 (1.2.beta-2版) / 凌云论坛 ver 1.2.b2         #**
**#                                                                #**
**#  版权所有: 凌云工作室 (原流星电脑工作室)                       #**
**#                                                                #**
**#  制作人  : 星语凌 『teddy (Yongshan Ye)』                      #**
**#                                                                #**
**#  主页地址: http://www.unix-now.com/lybbs   凌云论坛主页        #**
**#            http://www.ierp.info/lybbs      凌云论坛镜像站      #**
**#            http://[e-mail]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
errorinfo="";
if(username.equals("") || username.equals("客人")) {
  errorinfo="没有此用户名！";
}
else {
  int usergrade=0,lastpostid=0,lastpostdb=0,lastposttopic=0,allpostnumber=0,allreplynumber=0,alldeletenumber=0,uservisittimes=0,usermark=0,usermoney=0,userexperience=0,usercharm=0,userimagewidth=0,userimageheight=0;
  String usergradetitle="新手上路",userregistertime="",usermembertitle="",lastposttitle="",lastpostat="",userhomepage="",userqq="",usericq="",usercountry="",userprovince="",usercity="",userpart="",userlastactivetime="",usersex="",usereducation="",usermarry="",userwork="",userbirthday="",usersx="",userastro="",userintrodution="",usersignature="",userimage="",userimageurl="";
  rs=connect.executeQuery("select grade,nposts,nreply,ndelete,visittimes,mark,money,experience,charm,registertime,newmembertitle,email,homepage,qq,icq,country,province,city,newsocialpart,lastactivetime,sex,education,marry,work,birthday,usersx,astro,introdution,signature,imagename,imageurl,imagewidth,imageheight from author where username='"+username+"'");
  if(rs.next()) {
    usergrade=rs.getInt(1);
    allpostnumber=rs.getInt(2);
    allreplynumber=rs.getInt(3);
    alldeletenumber=rs.getInt(4);
    uservisittimes=rs.getInt(5);
    usermark=rs.getInt(6);
    usermoney=rs.getInt(7);
    userexperience=rs.getInt(8);
    usercharm=rs.getInt(9);
    userregistertime=rs.getString(10);
    usermembertitle=rs.getString(11);
    useremail=rs.getString(12);
    userhomepage=rs.getString(13);
    userqq=rs.getString(14);
    usericq=rs.getString(15);
    usercountry=rs.getString(16);
    userprovince=rs.getString(17);
    usercity=rs.getString(18);
    userpart=rs.getString(19);
    userlastactivetime=rs.getString(20);
    usersex=rs.getString(21);
    usereducation=rs.getString(22);
    usermarry=rs.getString(23);
    userwork=rs.getString(24);
    userbirthday=rs.getString(25);
    usersx=rs.getString(26);
    userastro=rs.getString(27);
    userintrodution=rs.getString(28);
    usersignature=rs.getString(29);
    userimage=rs.getString(30);
    userimageurl=rs.getString(31);
    userimagewidth=rs.getInt(32);
    userimageheight=rs.getInt(33);
    if(usergrade!=0) {
      rs=connect.executeQuery("select mname from grade where grade="+usergrade);
      if(rs.next()) {
        usergradetitle=rs.getString(1);
      }
    }
    rs=connect.executeQuery("select db,groupid,title,postat from posts where author='"+username+"' and parentid=0 order by id desc limit 1");
    if(rs.next()) {
      lastpostdb=rs.getInt(1);
      lastposttopic=rs.getInt(2);
      lastposttitle=rs.getString(3);
      lastpostat=rs.getString(4);
    }
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=6 cellspacing=1 border=0 width=100%>
    <tr>
     <td bgcolor=<%=miscbacktwo%> valign=middle colspan=2 align=center>
      <font color=<%=fontcolormisc%>>"<b><font color=<%=fonthighlight%>><%=username%></font></b>" 的个人资料
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle width=30%><font color=<%=fontcolormisc%>><b>注册时间：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userregistertime%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>当前头衔：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usermembertitle%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>当前级别：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><a href="lookinfo.jsp?action=style" target="_blank"><%=usergradetitle%></a></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>最后发表：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%if(lastpostdb!=0) {%><a href="topic.jsp?db=<%=lastpostdb%>&topic=<%=lastposttopic%>"><%=lastposttitle%></a> (<%=lastpostat%>)<%} else out.println("用户还没有发帖！");%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>总共发表：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=allpostnumber%> 篇</font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>总共回复：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=allreplynumber%> 篇</font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>贴子被删除：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=alldeletenumber%> 篇</font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>邮件地址：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><a href="mailto:<%=useremail%>"><%=useremail%></a></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>主页地址：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><% if(!userhomepage.equals("")) {%><a href="<%=userhomepage%>" target="_blank"><%=userhomepage%></a><%} else out.println("没有");%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>OICQ号码：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><% if(!userqq.equals("")) {%><a href=http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=userqq%> target=_blank><img src="images/oicq.gif" alt="查看 OICQ:<%=userqq%> 的资料" border=0 width=16 height=16></a> <%=userqq%><%} else out.println("没有");%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>ICQ 号码：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><% if(!usericq.equals("")) {%><a href=misc.jsp?action=icq&UIN=<%=usericq%> target=_blank><img src="http://wwp.icq.com/scripts/online.dll?icq=<%=usericq%>&img=7" alt="给 ICQ:<%=usericq%> 发个消息" border=0 width=16 height=16></a> <%=usericq%><%} else out.println("没有");%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>国家：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usercountry%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>来自：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userprovince%><%=usercity%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>江湖门派：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userpart%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>威望：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usermark%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>最后访问：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userlastactivetime%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>访问次数：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=uservisittimes%> 次</font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>性别：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usersex%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>学历：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usereducation%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>婚姻状况：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usermarry%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>职业：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userwork%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>出生年月：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userbirthday%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>你的生肖：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><% if(usersx.equals("保密")) out.println("保密"); else {%><IMG src=sx/<%=usersx%>.gif align=absmiddle><%}%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>你的星座：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><% if(usersx.equals("保密")) out.println("保密"); else {%><IMG height=15 src=star/<%=userastro%>.gif  width=15 align=absmiddle><%}%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>金钱：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usermoney%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>经验：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userexperience%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>魅力：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usercharm%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>自我简介：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=userintrodution%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>签名：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><%=usersignature%></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>个性图片：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><%if(!userimageurl.equals("")) out.println("<img src=\""+userimageurl+"\" width="+userimagewidth+" height="+userimageheight+">"); else if(userimage.equals("")) out.println("没有");else out.println("<img src=avatars/"+userimage+">");%></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font color=<%=fontcolormisc%>><b>相关操作：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle>
      <a href="javascript:openScript('friendlist.jsp?action=adduser&friendname=<%=username%>',420,320)">把<%=username%>加为我的好友</a>
      &nbsp;&nbsp;
      <a href="javascript:openScript('messanger.jsp?action=msgsend&toname=<%=username%>',420,320)">给<%=username%>发一个短消息</a>
      &nbsp;&nbsp;
      <a href="search.jsp?action=startsearch&TYPE_OF_SEARCH=username_search&NAME_SEARCH=topictitle_search&FORUMS_TO_SEARCH=all&SEARCH_STRING=<%=username%>" target=_blank>查找<%=username%>发表的所有帖子</a>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>
<%
  }
  else {
    errorinfo="没有此用户名！";
  }
}
if(!errorinfo.equals("")) {
%>
<table cellpadding=6 cellspacing=1 border=0 width=<%=tablewidth%> align=center>
 <tr>
  <td bgcolor=<%=miscbacktwo%> align=center>
    <font color=<%=fontcolormisc%>><b>用户资料查看错误</b></font>
  </td>
 </tr>
 <tr>
  <td bgcolor=<%=miscbackone%>>
    <font color=<%=fontcolormisc%>>
    <b>关于查看用户数据失败的详细原因：</b>
    <ul>
     <li><b><%=errorinfo%> </b>
     <li>您是否需要查看<a href="javascript:openScript('help.jsp',500,400)">帮助文件</a>?
    </ul>
    </font>
    <br><br>
    <center> &gt;&gt; <a href="javascript:self.close()">关闭窗口</a></center>
    </font>
  </td>
 </tr>
</table>
<%
}
%>