userregister.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]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
int addrecommendmoney=0,addrecommendexperience=0,addrecommendcharm=0,joinmoney=0,joinexperience=0,joincharm=0;
boolean registerok=false;
String errorinfo="该用户已经存在，请重新输入一个新的用户名！";
String oneaccountperemail="",register="1",registerreason="";
if(username.equals("") || password.equals("") || password2.equals("") || email.equals("") || lostquestion.equals("") || lostanswer.equals(""))
  errorinfo="请输入用户名、密码、邮件地址、密码提示问题和密码提示问题的答案，这些是必需的！";
else if(!password.equals(password2))
  errorinfo="您两次输入的密码不一致！请重新输入！";
else if(password.length()<6)
  errorinfo="您输入的密码太短，必须是六位以上！";
else if(email.indexOf("@")==-1)
  errorinfo="电子邮件格式不对，请重新输入您的电子邮件！";
else if(connect.getRowNum("reservemail where reservemail='"+email+"'")>0)
  errorinfo="您的电子邮件已经被保留，请重新输入您的电子邮件！";
else if(!request.getRemoteAddr().equals("") && connect.getRowNum("banip where banip='"+request.getRemoteAddr()+"'")>0)
  errorinfo="您的ip地址已经被禁，无法继续注册，请联系管理员！";
else if(introdution.length()>maxinslegth)
  errorinfo="您的个人简介太长，只允许有"+maxinslegth+"个字符";
else if(signature.length()>maxsignlegth)
  errorinfo="您的个人签名，只允许有"+maxsignlegth+"个字符";
else if(!userimageurl.equals("") && (userimagewidth>maxposticonwidth || userimageheight>maxposticonheight))
  errorinfo="用户自定义头像时，宽度不能超过"+maxposticonwidth+"象素和高度不能超过"+maxposticonheight+"象素！";
else {
 rs=connect.executeQuery("select oneaccountperemail,register,registerreason from config where id=1");
 if(rs.next()) {
   oneaccountperemail=rs.getString(1);
   register=rs.getString(2);
   registerreason=rs.getString(3);
 }
 if(oneaccountperemail.equals("1"))
   number=connect.getRowNum("author where email='"+email+"'");
 else number=0;
 if(number>0)
   errorinfo="管理员设定了一个电子邮件只能注册一个用户，您输入的电子邮件已经有人在使用！";
 else if(register.equals("0")) {
   errorinfo="管理员关闭了用户注册。详细原因："+registerreason;
 }
 else {
  number=connect.getRowNum("author where username='"+username+"'");
  if(number==0) {
    number=connect.getRowNum("reservename where reservename='"+username+"'");
    if(number==0) {
      rs=connect.executeQuery("select register,registerreason from config where id=1");
      if(rs.next()) {
        register=rs.getString(1);
        if(register.equals("0"))
          errorinfo=rs.getString(2);
        else {
          //注册用户的各项条件已经满足，准以注册！
          rs=connect.executeQuery("select addrecommendmoney,addrecommendexperience,addrecommendcharm,joinmoney,joinexperience,joincharm from encourage where id=1");
          if(rs.next()) {
            addrecommendmoney=rs.getInt(1);
            addrecommendexperience=rs.getInt(2);
            addrecommendcharm=rs.getInt(3);
            joinmoney=rs.getInt(4);
            joinexperience=rs.getInt(5);
            joincharm=rs.getInt(6);
          }
          if(!recommendname.equals("") && !recommendname.equals("客人"))
             connect.executeUpdate("update author set money=money+"+addrecommendmoney+",experience=experience+"+addrecommendexperience+",charm=charm+"+addrecommendcharm+" where username='"+recommendname+"'");
          if(userimageurl.equals(""))
            query="insert into author (username,password,email,lostquestion,lostanswer,recommendname,showemail,newmembertitle,newsocialpart,sex,education,marry,work,birthday,usersx,astro,homepage,qq,icq,country,province,city,introdution,signature,imagename,money,experience,charm,online,logintime,lastactivetime,registertime,ipfrom) values ('"+username+"','"+password+"','"+email+"','"+lostquestion+"','"+lostanswer+"','"+recommendname+"','"+showemail+"','"+newmembertitle+"','"+newsocialpart+"','"+sex+"','"+education+"','"+marry+"','"+work+"','"+birthday+"','"+usersx+"','"+astro+"','"+homepage+"','"+qq+"','"+icq+"','"+country+"','"+province+"','"+city+"','"+introdution+"','"+signature+"','"+useravatar+"',"+joinmoney+","+joinexperience+","+joincharm+",'1',now(),now(),now(),'"+request.getRemoteAddr()+"')";
          else
            query="insert into author (username,password,email,lostquestion,lostanswer,recommendname,showemail,newmembertitle,newsocialpart,sex,education,marry,work,birthday,usersx,astro,homepage,qq,icq,country,province,city,introdution,signature,imageurl,imagewidth,imageheight,money,experience,charm,online,logintime,lastactivetime,registertime,ipfrom) values ('"+username+"','"+password+"','"+email+"','"+lostquestion+"','"+lostanswer+"','"+recommendname+"','"+showemail+"','"+newmembertitle+"','"+newsocialpart+"','"+sex+"','"+education+"','"+marry+"','"+work+"','"+birthday+"','"+usersx+"','"+astro+"','"+homepage+"','"+qq+"','"+icq+"','"+country+"','"+province+"','"+city+"','"+introdution+"','"+signature+"','"+userimageurl+"',"+userimagewidth+","+userimageheight+","+joinmoney+","+joinexperience+","+joincharm+",'1',now(),now(),now(),'"+request.getRemoteAddr()+"')";
          registerok=connect.executeUpdate(query);
          if(registerok) {
            String regmsg="";
            rs=connect.executeQuery("select content from regmsg where id=1");
            if(rs.next())
              regmsg=rs.getString(1);
            rs=connect.executeQuery("select max(id) from author");
            if(rs.next()) {
              cookieid=String.valueOf(rs.getInt(1));
              cookiename=username;
              cookiemode="0";
              if(sendwelcomemessage.equals("1"))
                 connect.executeUpdate("insert into webqq (fromname,toname,title,message,operation,sendat) values ('全体管理人员','"+cookiename+"','欢迎您访问"+boardname+"，祝您使用愉快！','"+regmsg+"<BR><BR>----------------------------<BR>LyBBS 由凌云创作室『星语凌(teddy)』荣誉出品<BR>主页:http://www.unix-now.com/lybbs','get',now())");
%>
<%@ include file="setcookie.jsp"%>
<%
            }
          }
        }
      }
    }
  }
 }
}
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=6 cellspacing=1 border=0 width=100% align=center>
    <tr>
     <td bgcolor=<%=miscbacktwo%> align=center>
      <font color=<%=fontcolormisc%>><b>
<%
if(registerok)
  out.println("感谢您注册，"+username);
else
  out.println("错误： 用户注册");
%>
      </b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%>>
      <font color=<%=fontcolormisc%>>
<%
if(registerok) {
%>
       具体情况：
       <ul>
        <li><a href="index.jsp">返回论坛首页</a>
        <meta http-equiv="refresh" content="3; url=index.jsp">
       </ul>
<%
}
else {
%>
       <b>关于用户注册错误的详细原因：</b>
       <ul>
        <li><b><%=errorinfo%> </b>
        <li>您是否需要查看<a href="javascript:openScript('help.jsp',500,400)">帮助文件</a>?
       </ul>
       <b>产生用户注册错误的可能原因：</b>
       <ul>
        <li>密码错误
        <li>用户名错误
        <li>您不是<a href="register.jsp" >注册</a>用户
       </ul>
       </font>
       <br><br>
       <center> &gt;&gt; <a href="javascript:history.go(-1)">返回上一页</a></center>
<%
}
%>
       </font>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>