src/org/cacert/gigi/pages/main/Signup.java

   1 package org.cacert.gigi.pages.main;
   2
   3 import java.io.IOException;
   4 import java.io.PrintWriter;
   5 import java.sql.PreparedStatement;
   6 import java.sql.ResultSet;
   7 import java.sql.SQLException;
   8 import java.sql.Date;
   9 import java.util.HashMap;
  10 import java.util.Map;
  11
  12 import javax.servlet.http.HttpServletRequest;
  13
  14 import org.cacert.gigi.EmailAddress;
  15 import org.cacert.gigi.Language;
  16 import org.cacert.gigi.User;
  17 import org.cacert.gigi.database.DatabaseConnection;
  18 import org.cacert.gigi.email.EmailProvider;
  19 import org.cacert.gigi.output.DateSelector;
  20 import org.cacert.gigi.output.Form;
  21 import org.cacert.gigi.output.template.Template;
  22 import org.cacert.gigi.pages.Page;
  23 import org.cacert.gigi.util.HTMLEncoder;
  24 import org.cacert.gigi.util.Notary;
  25 import org.cacert.gigi.util.PasswordStrengthChecker;
  26
  27 public class Signup extends Form {
  28         User buildup = new User();
  29         Template t;
  30         boolean general = true, country = true, regional = true, radius = true;
  31
  32         public Signup(HttpServletRequest hsr) {
  33                 super(hsr);
  34                 t = new Template(Signup.class.getResource("Signup.templ"));
  35                 buildup.setFname("");
  36                 buildup.setMname("");
  37                 buildup.setLname("");
  38                 buildup.setSuffix("");
  39                 buildup.setEmail("");
  40                 buildup.setDob(new Date(0));
  41         }
  42
  43         DateSelector myDoB = new DateSelector("day", "month", "year");
  44
  45         @Override
  46         public void outputContent(PrintWriter out, Language l, Map<String, Object> outerVars) {
  47                 HashMap<String, Object> vars = new HashMap<String, Object>();
  48                 vars.put("fname", HTMLEncoder.encodeHTML(buildup.getFname()));
  49                 vars.put("mname", HTMLEncoder.encodeHTML(buildup.getMname()));
  50                 vars.put("lname", HTMLEncoder.encodeHTML(buildup.getLname()));
  51                 vars.put("suffix", HTMLEncoder.encodeHTML(buildup.getSuffix()));
  52                 vars.put("dob", myDoB);
  53                 vars.put("email", HTMLEncoder.encodeHTML(buildup.getEmail()));
  54                 vars.put("general", general ? " checked=\"checked\"" : "");
  55                 vars.put("country", country ? " checked=\"checked\"" : "");
  56                 vars.put("regional", regional ? " checked=\"checked\"" : "");
  57                 vars.put("radius", radius ? " checked=\"checked\"" : "");
  58                 vars.put("helpOnNames", String.format(l.getTranslation("Help on Names %sin the wiki%s"),
  59                         "<a href=\"//wiki.cacert.org/FAQ/HowToEnterNamesInJoinForm\" target=\"_blank\">", "</a>"));
  60                 vars.put("csrf", getCSRFToken());
  61                 t.output(out, l, vars);
  62         }
  63
  64         private void update(HttpServletRequest r) {
  65                 if (r.getParameter("fname") != null) {
  66                         buildup.setFname(r.getParameter("fname"));
  67                 }
  68                 if (r.getParameter("lname") != null) {
  69                         buildup.setLname(r.getParameter("lname"));
  70                 }
  71                 if (r.getParameter("mname") != null) {
  72                         buildup.setMname(r.getParameter("mname"));
  73                 }
  74                 if (r.getParameter("suffix") != null) {
  75                         buildup.setSuffix(r.getParameter("suffix"));
  76                 }
  77                 if (r.getParameter("email") != null) {
  78                         buildup.setEmail(r.getParameter("email"));
  79                 }
  80                 general = "1".equals(r.getParameter("general"));
  81                 country = "1".equals(r.getParameter("country"));
  82                 regional = "1".equals(r.getParameter("regional"));
  83                 radius = "1".equals(r.getParameter("radius"));
  84                 myDoB.update(r);
  85         }
  86
  87         @Override
  88         public synchronized boolean submit(PrintWriter out, HttpServletRequest req) {
  89                 update(req);
  90                 boolean failed = false;
  91                 out.println("<div class='formError'>");
  92                 if (buildup.getFname().equals("") || buildup.getLname().equals("")) {
  93                         outputError(out, req, "First and/or last names were blank.");
  94                         failed = true;
  95                 }
  96                 if (!myDoB.isValid()) {
  97                         outputError(out, req, "Invalid date of birth");
  98                         failed = true;
  99                 }
 100                 if (!"1".equals(req.getParameter("cca_agree"))) {
 101                         outputError(out, req, "You have to agree to the CAcert Community agreement.");
 102                         failed = true;
 103                 }
 104                 if (buildup.getEmail().equals("")) {
 105                         outputError(out, req, "Email Address was blank");
 106                         failed = true;
 107                 }
 108                 String pw1 = req.getParameter("pword1");
 109                 String pw2 = req.getParameter("pword2");
 110                 if (pw1 == null || pw1.equals("")) {
 111                         outputError(out, req, "Pass Phrases were blank");
 112                         failed = true;
 113                 } else if (!pw1.equals(pw2)) {
 114                         outputError(out, req, "Pass Phrases don't match");
 115                         failed = true;
 116                 }
 117                 int pwpoints = PasswordStrengthChecker.checkpw(pw1, buildup);
 118                 if (pwpoints < 3) {
 119                         outputError(out, req, "The Pass Phrase you submitted failed to contain enough"
 120                                 + " differing characters and/or contained words from" + " your name and/or email address.");
 121                         failed = true;
 122                 }
 123                 if (failed) {
 124                         out.println("</div>");
 125                         return false;
 126                 }
 127                 try {
 128                         PreparedStatement q1 = DatabaseConnection.getInstance().prepare(
 129                                 "select * from `email` where `email`=? and `deleted`=0");
 130                         PreparedStatement q2 = DatabaseConnection.getInstance().prepare(
 131                                 "select * from `users` where `email`=? and `deleted`=0");
 132                         q1.setString(1, buildup.getEmail());
 133                         q2.setString(1, buildup.getEmail());
 134                         ResultSet r1 = q1.executeQuery();
 135                         ResultSet r2 = q2.executeQuery();
 136                         if (r1.next() || r2.next()) {
 137                                 outputError(out, req, "This email address is currently valid in the system.");
 138                                 failed = true;
 139                         }
 140                         r1.close();
 141                         r2.close();
 142                         PreparedStatement q3 = DatabaseConnection.getInstance().prepare(
 143                                 "select `domain` from `baddomains` where `domain`=RIGHT(?, LENGTH(`domain`))");
 144                         q3.setString(1, buildup.getEmail());
 145
 146                         ResultSet r3 = q3.executeQuery();
 147                         if (r3.next()) {
 148                                 String domain = r3.getString(1);
 149                                 out.print("<div>");
 150                                 out.print(String.format(
 151                                         Page.translate(req, "We don't allow signups from people using email addresses from %s"), domain));
 152                                 out.println("</div>");
 153                                 failed = true;
 154                         }
 155                         r3.close();
 156                 } catch (SQLException e) {
 157                         e.printStackTrace();
 158                         failed = true;
 159                 }
 160                 String mailResult = EmailProvider.FAIL;
 161                 try {
 162                         mailResult = EmailProvider.getInstance().checkEmailServer(0, buildup.getEmail());
 163                 } catch (IOException e) {
 164                 }
 165                 if (!mailResult.equals(EmailProvider.OK)) {
 166                         if (mailResult.startsWith("4")) {
 167                                 outputError(out, req, "The mail server responsible for your domain indicated"
 168                                         + " a temporary failure. This may be due to anti-SPAM measures, such"
 169                                         + " as greylisting. Please try again in a few minutes.");
 170                         } else {
 171                                 outputError(out, req, "Email Address given was invalid, or a test connection"
 172                                         + " couldn't be made to your server, or the server" + " rejected the email address as invalid");
 173                         }
 174                         if (mailResult.equals(EmailProvider.FAIL)) {
 175                                 outputError(out, req, "Failed to make a connection to the mail server");
 176                         } else {
 177                                 out.print("<div>");
 178                                 out.print(mailResult);
 179                                 out.println("</div>");
 180                         }
 181                         failed = true;
 182                 }
 183
 184                 out.println("</div>");
 185                 if (failed) {
 186                         return false;
 187                 }
 188                 try {
 189                         run(req, pw1);
 190                 } catch (SQLException e) {
 191                         e.printStackTrace();
 192                 }
 193                 return true;
 194         }
 195
 196         private void run(HttpServletRequest req, String password) throws SQLException {
 197                 try {
 198                         DatabaseConnection.getInstance().beginTransaction();
 199
 200                         buildup.setDob(myDoB.getDate());
 201                         buildup.insert(password);
 202                         int memid = buildup.getId();
 203                         EmailAddress ea = new EmailAddress(buildup.getEmail(), buildup);
 204                         ea.insert(Page.getLanguage(req));
 205
 206                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
 207                                 "insert into `alerts` set `memid`=?," + " `general`=?, `country`=?, `regional`=?, `radius`=?");
 208                         ps.setInt(1, memid);
 209                         ps.setString(2, general ? "1" : "0");
 210                         ps.setString(3, country ? "1" : "0");
 211                         ps.setString(4, regional ? "1" : "0");
 212                         ps.setString(5, radius ? "1" : "0");
 213                         ps.execute();
 214                         Notary.writeUserAgreement(memid, "CCA", "account creation", "", true, 0);
 215
 216                         DatabaseConnection.getInstance().commitTransaction();
 217                 } finally {
 218                         DatabaseConnection.getInstance().quitTransaction();
 219                 }
 220
 221         }
 222 }