X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FCertificateOwner.java;h=2adda5ee4fea22130a37503464ad44e69c9c71c2;hp=f9e9fbd57f0f721e9ac2c4cfc8a590968e727339;hb=50b8341607e23812216349ef37711e5a85d957c3;hpb=6d215e9cd20c590f1d9fdf17c56043fa7c20239f

diff --git a/src/org/cacert/gigi/dbObjects/CertificateOwner.java b/src/org/cacert/gigi/dbObjects/CertificateOwner.java
index f9e9fbd5..2adda5ee 100644
--- a/src/org/cacert/gigi/dbObjects/CertificateOwner.java
+++ b/src/org/cacert/gigi/dbObjects/CertificateOwner.java
@@ -117,4 +117,13 @@ public abstract class CertificateOwner implements IdCachable {
         return entries.toArray(new String[0]);
     }
 
+    public static CertificateOwner getByEnabledSerial(String serial) {
+        GigiPreparedStatement prep = DatabaseConnection.getInstance().prepare("SELECT `memid` FROM `certs` WHERE serial=? AND `disablelogin`='0' AND `revoked` is NULL");
+        prep.setString(1, serial.toLowerCase());
+        GigiResultSet res = prep.executeQuery();
+        if (res.next()) {
+            return getById(res.getInt(1));
+        }
+        return null;
+    }
 }