X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FCertificateOwner.java;h=72e5a81672762a74510cfbe7743dda61f19d2231;hb=42466c8f42d997ae9abd583ad9eaeef512b62f1f;hp=f608b2fc01bea94610a6e826af84bed7d573305e;hpb=628b0bb70786afe5de5ba28a8438261dc31e25a6;p=gigi.git diff --git a/src/club/wpia/gigi/dbObjects/CertificateOwner.java b/src/club/wpia/gigi/dbObjects/CertificateOwner.java index f608b2fc..72e5a816 100644 --- a/src/club/wpia/gigi/dbObjects/CertificateOwner.java +++ b/src/club/wpia/gigi/dbObjects/CertificateOwner.java @@ -5,6 +5,7 @@ import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.io.ObjectStreamException; import java.io.Serializable; +import java.math.BigInteger; import java.util.LinkedList; import java.util.List; @@ -24,7 +25,15 @@ public abstract class CertificateOwner implements IdCachable, Serializable { this.id = id; } - protected CertificateOwner() { + /** + * This constructor has a dummy parameter to allow callers to do checks + * before invoking the super constructor. + * + * @param dummy + * a parameter that is not used to allow callers to do checks + * before super constructor invocation. + */ + protected CertificateOwner(Void dummy) { try (GigiPreparedStatement ps = new GigiPreparedStatement("INSERT INTO `certOwners` DEFAULT VALUES")) { ps.execute(); id = ps.lastInsertId(); @@ -131,9 +140,9 @@ public abstract class CertificateOwner implements IdCachable, Serializable { } } - public static CertificateOwner getByEnabledSerial(String serial) { + public static CertificateOwner getByEnabledSerial(BigInteger serial) { try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `memid` FROM `certs` INNER JOIN `logincerts` ON `logincerts`.`id`=`certs`.`id` WHERE serial=? AND `revoked` is NULL")) { - prep.setString(1, serial); + prep.setString(1, serial.toString(16)); GigiResultSet res = prep.executeQuery(); if (res.next()) { return getById(res.getInt(1));