X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fpages%2FVerify.java;h=2ebd54c5f2d4447ae9fe5a8352a05c53229c8300;hp=8d292667df203c07f99907dee14c862f4a750207;hb=e409ba881965634f63f0b67824bc93dda4ec4327;hpb=7cf984749cf0027ccae90a53ebef07ab97ff164b diff --git a/src/org/cacert/gigi/pages/Verify.java b/src/org/cacert/gigi/pages/Verify.java index 8d292667..2ebd54c5 100644 --- a/src/org/cacert/gigi/pages/Verify.java +++ b/src/org/cacert/gigi/pages/Verify.java @@ -2,71 +2,54 @@ package org.cacert.gigi.pages; import java.io.IOException; import java.io.PrintWriter; -import java.sql.PreparedStatement; -import java.sql.ResultSet; -import java.sql.SQLException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; -import org.cacert.gigi.database.DatabaseConnection; +import org.cacert.gigi.GigiApiException; +import org.cacert.gigi.dbObjects.Domain; +import org.cacert.gigi.dbObjects.EmailAddress; public class Verify extends Page { - public static final String PATH = "/verify"; - public Verify() { - super("Verify email"); - } - @Override - public boolean needsLogin() { - return false; - } - @Override - public void doGet(HttpServletRequest req, HttpServletResponse resp) - throws IOException { - PrintWriter out = resp.getWriter(); - String hash = req.getParameter("hash"); - String type = req.getParameter("type"); - String id = req.getParameter("id"); - if ("email".equals(type)) { - try { - PreparedStatement ps = DatabaseConnection - .getInstance() - .prepare( - "select email, memid from `email` where `id`=? and `hash`=? and `hash` != '' and `deleted` = 0"); - ps.setString(1, id); - ps.setString(2, hash); - ResultSet rs = ps.executeQuery(); - rs.last(); - if (rs.getRow() == 1) { - PreparedStatement ps1 = DatabaseConnection - .getInstance() - .prepare( - "update `email` set `hash`='', `modified`=NOW() where `id`=?"); - ps1.setString(1, id); - ps1.execute(); - PreparedStatement ps2 = DatabaseConnection - .getInstance() - .prepare( - "update `users` set `verified`='1' where `id`=? and `email`=? and `verified`='0'"); - ps2.setString(1, rs.getString(2)); - ps2.setString(2, rs.getString(1)); - ps2.execute(); - out.println("Your email is good."); - } else { - out.println("Your request is invalid"); - } - } catch (SQLException e) { - e.printStackTrace(); - } - } - } - @Override - public void doPost(HttpServletRequest req, HttpServletResponse resp) - throws IOException { - String hash = req.getParameter("hash"); - String type = req.getParameter("type"); - if ("email".equals(type)) { - } - } + public static final String PATH = "/verify"; + + public Verify() { + super("Verify email"); + } + + @Override + public boolean needsLogin() { + return false; + } + + @Override + public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException { + PrintWriter out = resp.getWriter(); + String hash = req.getParameter("hash"); + String type = req.getParameter("type"); + String id = req.getParameter("id"); + if ("email".equals(type)) { + try { + EmailAddress ea = EmailAddress.getById(Integer.parseInt(id)); + ea.verify(hash); + out.println("Email verification completed."); + } catch (IllegalArgumentException e) { + out.println(translate(req, "The email address is invalid.")); + } catch (GigiApiException e) { + e.format(out, getLanguage(req)); + } + } else if ("domain".equals(type)) { + try { + Domain ea = Domain.getById(Integer.parseInt(id)); + ea.verify(hash); + out.println("Domain verification completed."); + } catch (IllegalArgumentException e) { + out.println(translate(req, "The domain address is invalid.")); + } catch (GigiApiException e) { + e.format(out, getLanguage(req)); + } + } + } + }