userlogin.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]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
boolean logok=false,updateok=false;
int number=connect.getRowNum("author where username='"+username+"' and password='"+password+"'");
if(number==1) {
  rs=connect.executeQuery("select id,status,usermode,grade,nposts from author where username='"+username+"' and password='"+password+"'");
  if(rs.next()) {
    cookieid=String.valueOf(rs.getInt(1));
    userstatus=rs.getString(2);
    cookiemode=String.valueOf(rs.getInt(3));
    cookiename=username;
    usergrade=rs.getInt(4)+1;
    nposts=rs.getInt(5);
  }
  if(userstatus.equals("0")) {
    if(cookiemode.equals("0")) {
      //用户是否可以升级
      rs=connect.executeQuery("select mpostmark from grade where grade="+usergrade);
      if(rs.next()) {
        if(nposts<rs.getInt(1))
           usergrade=usergrade-1;
      }
    }
    else
      usergrade=usergrade-1;
    logok=true;
    rs=connect.executeQuery("select loginmoney,loginexperience,logincharm from encourage where id=1");
    if(rs.next()) {
      loginmoney=rs.getInt(1);
      loginexperience=rs.getInt(2);
      logincharm=rs.getInt(3);
    }
    if(selectstyle==0)
      updateok=connect.executeUpdate("update author set threadages="+threadages+",freshtime="+freshtime+",onlineview='"+onlineview+"',hidden='"+hidden+"',viewmode='"+viewmode+"',msgpopup='"+msgpopup+"',myinfo='"+myinfo+"',mess='"+mess+"',advpost='"+advpost+"',lastactivetime=now(),logintime=now(),online='1',visittimes=visittimes+1,money=money+"+loginmoney+",experience=experience+"+loginexperience+",charm=charm+"+logincharm+",grade="+usergrade+" where username='"+username+"' and password='"+password+"'");
    else if(selectstyle==1)
      updateok=connect.executeUpdate("update author set threadages="+threadages+",styleid=0,freshtime="+freshtime+",onlineview='"+onlineview+"',hidden='"+hidden+"',viewmode='"+viewmode+"',msgpopup='"+msgpopup+"',myinfo='"+myinfo+"',mess='"+mess+"',advpost='"+advpost+"',lastactivetime=now(),logintime=now(),online='1',visittimes=visittimes+1,money=money+"+loginmoney+",experience=experience+"+loginexperience+",charm=charm+"+logincharm+",grade="+usergrade+" where username='"+username+"' and password='"+password+"'");
    else
      updateok=connect.executeUpdate("update author set threadages="+threadages+",styleid="+selectstyle+",freshtime="+freshtime+",onlineview='"+onlineview+"',hidden='"+hidden+"',viewmode='"+viewmode+"',msgpopup='"+msgpopup+"',myinfo='"+myinfo+"',mess='"+mess+"',advpost='"+advpost+"',lastactivetime=now(),logintime=now(),online='1',visittimes=visittimes+1,money=money+"+loginmoney+",experience=experience+"+loginexperience+",charm=charm+"+logincharm+",grade="+usergrade+" where username='"+username+"' and password='"+password+"'");
  }
}
%>
<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 align=center>
        <font face="宋体" color=<%=fontcolormisc%>><b>
<%
if(logok && updateok) {
%>
<%@ include file="setcookie.jsp"%>
<%
  out.println("感谢你登陆 "+username);
}
else out.println("登陆错误");
%>
        </b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle>
       <font face="宋体" color=<%=fontcolormisc%>>
<%
if(logok && updateok) {
  out.println("具体情况：");
  out.println(" <ul>");
  if(db!=0) {
    out.println(" <li><a href='db.jsp?db="+db+"'>进入论坛</a>");
    out.println(" <meta http-equiv='refresh' content='3; url=db.jsp?db="+db+"'>");
  }
  else {
    out.println(" <li><a href='index.jsp'>进入论坛</a>");
    out.println(" <meta http-equiv='refresh' content='3; url=index.jsp'>");
  }
  out.println(" </ul>");
}
else if(userstatus.equals("1")) {
  out.println("登陆错误的原因：");
  out.println(" <ul>");
  out.println(" <li>您的帐号已经被禁！请联系管理员！");
  out.println(" </ul>");
}
else {
  out.println("登陆错误的可能原因：");
  out.println(" <ul>");
  out.println(" <li>密码错误<li>用户名错误<li>您不是<a href=register.jsp>注册</a>用户");
  out.println(" </ul>");
}
%>
       </font>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>