X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FDomain.java;h=36b7dc6f651dec5c071f15796ac38c42a3117a56;hp=d4ffd8e28d377b038953a1cc2e2d808aeb16fd05;hb=0b86fb147b4a61f315770fa5bba4466ca18ddfa8;hpb=36658ae4a12bea7095e02e45b1fe8400d85add8b diff --git a/src/org/cacert/gigi/dbObjects/Domain.java b/src/org/cacert/gigi/dbObjects/Domain.java index d4ffd8e2..36b7dc6f 100644 --- a/src/org/cacert/gigi/dbObjects/Domain.java +++ b/src/org/cacert/gigi/dbObjects/Domain.java @@ -110,7 +110,7 @@ public class Domain implements IdCachable, Verifyable { public void addPing(DomainPingType type, String config) throws GigiApiException { try (GigiPreparedStatement ps = new GigiPreparedStatement("INSERT INTO `pingconfig` SET `domainid`=?, `type`=?::`pingType`, `info`=?")) { ps.setInt(1, id); - ps.setString(2, type.toString().toLowerCase()); + ps.setEnum(2, type); ps.setString(3, config); ps.execute(); } @@ -173,8 +173,8 @@ public class Domain implements IdCachable, Verifyable { return em; } - public static Domain searchUserIdByDomain(String domain) { - try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `id` FROM `domains` WHERE `domain` = ?")) { + public static Domain searchDomain(String domain) { + try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `id` FROM `domains` WHERE `domain` = ? AND `deleted` IS NULL")) { ps.setString(1, domain); GigiResultSet res = ps.executeQuery(); if (res.next()) {